ad5081d3
 孙向锦
初始化项目
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `${tabletop}${objectNameUpper}`
-- ----------------------------
DROP TABLE IF EXISTS `${tabletop}${objectNameUpper}`;
CREATE TABLE `${tabletop}${objectNameUpper}` (
`${objectNameUpper}_ID` varchar(100) NOT NULL,
`PARENT_ID` varchar(100) NOT NULL,
`NAME` 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>
PRIMARY KEY (`${objectNameUpper}_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
