ALTER TABLE `permission` DROP FOREIGN KEY `fk_permission_module_id`;

ALTER TABLE `permission` DROP FOREIGN KEY `fk_permission_native`;

ALTER TABLE `permission` DROP FOREIGN KEY `fk_permission_operation`;

ALTER TABLE `permission` DROP FOREIGN KEY `fk_permission_role`;

ALTER TABLE `module`
MODIFY COLUMN `id`  int(11) NOT NULL AUTO_INCREMENT FIRST ;
ALTER TABLE `module`
MODIFY COLUMN `moduletype`  varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '公安1公司2' AFTER `update_by`;

ALTER TABLE `operation`
MODIFY COLUMN `id`  int(11) NOT NULL AUTO_INCREMENT FIRST ;