动态创建表的sqlserver ddl调整。ddl模板调整，增加默认字段项

yinshy · Jul 7, 2014 · fdfefe8 · fdfefe8
1 parent 787081f
commit fdfefe8
Show file tree

Hide file tree

Showing 2 changed files with 4 additions and 1 deletion.
diff --git a/...ain/resources/db/web/schema-sqlserver.sql → src/main/resources/db/web/schema-mssql.sql b/...ain/resources/db/web/schema-sqlserver.sql → src/main/resources/db/web/schema-mssql.sql
diff --git a/src/main/resources/templates/ddls/mysql/ddl.httl b/src/main/resources/templates/ddls/mysql/ddl.httl
@@ -6,5 +6,8 @@ CREATE TABLE T_${dbtable.name} (
 <!--#foreach(field in dbtable.fields)-->
     ${field.name}${blank}<!--#if(field.type == '1')-->VARCHAR<!--#if(field.dataLength > 0)-->(${field.dataLength})<!--#end--><!--#elseif(field.type == '2')--><!--#if(field.dataLength < 5)-->SMALLINT<!--#else-->BIGINT(${field.dataLength})<!--#end--><!--#elseif(field.type == '3')-->DOUBLE<!--#if(field.dataLength > 0 && field.dataDigit > 0)-->(${field.dataLength},${field.dataDigit})<!--#end--><!--#elseif(field.type == '4')-->DATETIME<!--#elseif(field.type == '5')-->TEXT<!--#else-->VARCHAR<!--#end-->${blank}<!--#if(field.required == '1')-->NOT${blank}<!--#end-->NULL,
 <!--#end-->
-    ID  VARCHAR(32) NOT NULL PRIMARY KEY
+    ID  VARCHAR(32) NOT NULL PRIMARY KEY,
+    OPERATETIME  VARCHAR(20),
+    OPERATOR     VARCHAR(50),
+    ORDERID      VARCHAR(32)
 );