123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657 |
- --1.0.0--
- CREATE TABLE IF NOT EXISTS `__PREFIX__tablemake_tables` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `name` varchar(50) NOT NULL COMMENT '模型名称',
- `table` varchar(20) NOT NULL COMMENT '表名称',
- `desc` varchar(150) DEFAULT NULL COMMENT '简介',
- `createtime` int(11) NOT NULL COMMENT '创建时间',
- `updatetime` int(11) NOT NULL COMMENT '更新时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '自建表管理表' ROW_FORMAT = Compact;
- CREATE TABLE IF NOT EXISTS `__PREFIX__tablemake_fields` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `mid` int(11) NOT NULL COMMENT '所属模型',
- `category` tinyint(2) NOT NULL COMMENT '字段类型',
- `title` varchar(50) NOT NULL DEFAULT '' COMMENT '字段标题',
- `name` varchar(50) NOT NULL DEFAULT '' COMMENT '字段名称',
- `field` varchar(50) NOT NULL DEFAULT '' COMMENT '字段名',
- `special` varchar(50) NOT NULL DEFAULT '' COMMENT '特殊字段',
- `suffix` varchar(50) NOT NULL DEFAULT '' COMMENT '字段后缀',
- `type` varchar(50) NOT NULL DEFAULT '' COMMENT '字段类型',
- `length` varchar(10) NOT NULL COMMENT '字段长度',
- `default` varchar(255) NOT NULL COMMENT '默认值',
- `comment` varchar(2000) NOT NULL COMMENT '字段备注',
- `createtime` int(11) NOT NULL COMMENT '创建时间',
- `updatetime` int(11) NOT NULL COMMENT '更新时间',
- PRIMARY KEY (`id`) USING BTREE
- ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字段管理表' ROW_FORMAT = Compact;
- --1.0.7--
- ALTER TABLE `__PREFIX__tablemake_tables` ADD COLUMN `weigh` bigint(11) NOT NULL DEFAULT 0 COMMENT '排序权重' AFTER `desc`;
- UPDATE `__PREFIX__tablemake_tables` SET `weigh`=`id`;
- ALTER TABLE `__PREFIX__tablemake_tables`
- MODIFY COLUMN `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'ID' FIRST ,
- MODIFY COLUMN `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '自建表名称' AFTER `id`,
- MODIFY COLUMN `table` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '自建表表名' AFTER `name`,
- MODIFY COLUMN `desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '自建表简介' AFTER `table`,
- MODIFY COLUMN `createtime` bigint(11) NOT NULL DEFAULT 0 COMMENT '创建时间' AFTER `weigh`,
- MODIFY COLUMN `updatetime` bigint(11) NOT NULL DEFAULT 0 COMMENT '更新时间' AFTER `createtime`;
-
-
- ALTER TABLE `__PREFIX__tablemake_fields` ADD COLUMN `desc` varchar(255) NOT NULL DEFAULT '' COMMENT '字段备注' AFTER `comment`, ADD COLUMN `weigh` bigint(11) NOT NULL DEFAULT 0 COMMENT '排序权重' AFTER `desc`;
- UPDATE `__PREFIX__tablemake_fields` SET `weigh`=`id`;
- ALTER TABLE `__PREFIX__tablemake_fields`
- MODIFY COLUMN `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'ID' FIRST ,
- MODIFY COLUMN `mid` bigint(11) NOT NULL DEFAULT 0 COMMENT '所属自建表ID' AFTER `id`,
- MODIFY COLUMN `length` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 0 COMMENT '字段长度' AFTER `type`,
- MODIFY COLUMN `default` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '默认值' AFTER `length`,
- MODIFY COLUMN `comment` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '字段备注' AFTER `default`,
- MODIFY COLUMN `createtime` bigint(11) NOT NULL DEFAULT 0 COMMENT '创建时间' AFTER `weigh`,
- MODIFY COLUMN `updatetime` bigint(11) NOT NULL DEFAULT 0 COMMENT '更新时间' AFTER `createtime`;
-
-
|