孙向锦 / SunvoteEducation

Blame view

resources/ftl/createSoCode/mysql_SQL_Template.ftl 712 Bytes
Edit Raw Normal View History
ad5081d3   孙向锦   初始化项目 
1
2
3
4
5
6
7
8
 
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for `${tabletop}${objectNameUpper}`
  -- ----------------------------
  DROP TABLE IF EXISTS `${tabletop}${objectNameUpper}`;
  CREATE TABLE `${tabletop}${objectNameUpper}` (
b980d59d   孙向锦   修改模板 
9
 
   		`$ID` int(100) NOT NULL AUTO_INCREMENT,
ad5081d3   孙向锦   初始化项目 
10
11
12
13
14
15
16
17
18
19
 
   		`${faobject}_ID` varchar(100) NOT NULL,
  	<#list fieldList as var>
  		<#if var[1] == 'Integer'>
  		`${var[0]}` int(${var[5]}) NOT NULL COMMENT '${var[2]}',
  		<#elseif var[1] == 'Double'>
  		`${var[0]}` double(${var[5]},${var[6]}) DEFAULT NULL COMMENT '${var[2]}',
  		<#else>
  		`${var[0]}` varchar(${var[5]}) DEFAULT NULL COMMENT '${var[2]}',
  		</#if>
  	</#list>
b980d59d   孙向锦   修改模板 
20
 
    		PRIMARY KEY (`$ID`)
ad5081d3   孙向锦   初始化项目 
21
 
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;