ALTER TABLE `sp_se_user` ADD COLUMN `firstLogin` varchar(10) NULL DEFAULT NULL COMMENT '是否第一次登入,用于弹窗判断' AFTER `updater`, INSERT INTO `config_system`( `sysKey`, `sysValue`) VALUES ('web_url', 'http://localhost:8888/police'); INSERT INTO `config_system`( `sysKey`, `sysValue`) VALUES ('preview_url', 'http://localhost:8888'); CREATE TABLE `sp_tel_phone` ( `id` int(11) NOT NULL AUTO_INCREMENT, `province` varchar(255) DEFAULT NULL, `city` varchar(255) DEFAULT NULL, `area` varchar(255) DEFAULT NULL, `level` int(10) DEFAULT NULL COMMENT '审批等级,区 市', `telPhone` varchar(255) DEFAULT NULL, `addTime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, `updateTime` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='警局咨询电话'; update sp_activity set isBackUp = 0 where isGov = 0; update sp_activity set isBackUp = 1 where isGov = 1;