ALTER TABLE `police`
DROP COLUMN `province`,
DROP COLUMN `city`,
DROP COLUMN `level`,
ADD COLUMN `orgname`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机构名称' AFTER `tel`;
ADD COLUMN `shortname`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '机构简称' AFTER `phone`,
ADD COLUMN `remarks`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注' AFTER `shortname`,
ADD COLUMN `contact`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人' AFTER `remarks`,
ADD COLUMN `usernum`  int(11) NULL DEFAULT NULL COMMENT '用户数' AFTER `contact`,
ADD COLUMN `parent_org`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '上级机构' AFTER `usernum`,
ADD COLUMN `orderno`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排序序号' AFTER `parent_org`;
ADD COLUMN `code`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位代码' AFTER `parent_org`;