9 lines
810 B
SQL
9 lines
810 B
SQL
--
|
|
--把tableprefix_换你的表前缀再执行;
|
|
--
|
|
|
|
ALTER TABLE `tableprefix_menu` CHANGE `app` `app` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '应用名称app';
|
|
ALTER TABLE `tableprefix_menu` CHANGE `model` `model` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '控制器';
|
|
ALTER TABLE `tableprefix_menu` CHANGE `action` `action` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作名称';
|
|
ALTER TABLE `tableprefix_menu` CHANGE `data` `data` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '额外参数';
|
|
ALTER TABLE `tableprefix_menu` CHANGE `remark` `remark` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注'; |