Forgive me if this sounds pedantic, but how do you distinguish between DDL and SQL scripts? I only ask because I use a single directory (sql
, although I like ddl
as well) for this. Aren't they the same thing?
I also wonder if you have a sibling dml directory which has the definitions for a SQL phrasebook. To be honest, that idea only just occurred to me, but it does seems attractive. Something like:
+--dml # database setup scripts and definitions here.
+--ddl # data files with phrasebook definitions here.