2 <#list tableList as table>
\r
3 <#list table.foreignKeyList as fk>ALTER TABLE ${table.name} DROP CONSTRAINT ${fk.name}
\r
7 <#list tableList as table>
\r
8 DROP TABLE ${table.name};
\r
12 <#list tableList as table>
\r
13 CREATE TABLE ${table.name} (
\r
14 <#list table.columnList as column> ${column.name} ${column.definition}<#if column_has_next>,</#if>
\r
16 <#if !table.suppressCommonColumn>
\r
17 , CREATE_USER VARCHAR2(20) NOT NULL
\r
18 , CREATE_DATETIME DATE NOT NULL
\r
19 , UPDATE_USER VARCHAR2(20) NOT NULL
\r
20 , UPDATE_DATETIME DATE NOT NULL
\r
21 , VERSION_NO NUMBER(8) NOT NULL
\r
25 <#if table.primaryKey??>ALTER TABLE ${table.name} ADD CONSTRAINT ${table.primaryKey.name}
\r
26 PRIMARY KEY (<#list table.primaryKey.columnNameList as columnName>${columnName}<#if columnName_has_next>,</#if></#list>)
\r
29 <#list table.uniqueList as unique>ALTER TABLE ${table.name} ADD CONSTRAINT ${unique.name}
\r
30 UNIQUE (<#list unique.columnNameList as columnName>${columnName}<#if columnName_has_next>,</#if></#list>)
\r
33 <#list table.indexList as index>CREATE INDEX ${index.name} ON ${table.name}
\r
34 (<#list index.columnList as columnName>${columnName}<#if columnName_has_next>,</#if></#list>)
\r
37 <#if table.alias?? || table.note??>
\r
38 COMMENT ON TABLE ${table.name} IS '<#if table.alias??>${table.alias}:</#if><#if table.note??>${table.note}</#if>'
\r
41 <#list table.columnList as column>
\r
42 <#if column.alias?? || column.note??>
\r
43 COMMENT ON COLUMN ${table.name}.${column.name} IS '<#if column.alias??>${column.alias}:</#if><#if column.note??>${column.note}</#if>'
\r
50 <#list tableList as table>
\r
51 <#list table.foreignKeyList as fk>ALTER TABLE ${table.name} ADD CONSTRAINT ${fk.name}
\r
52 FOREIGN KEY (<#list fk.columnNameList as columnName>${columnName}<#if columnName_has_next>,</#if></#list>)
\r
53 REFERENCES ${fk.targetTable} (<#list fk.targetColumnNameList as columnName>${columnName}<#if columnName_has_next>,</#if></#list>)
\r