14 lines
1.1 KiB
MySQL
14 lines
1.1 KiB
MySQL
|
ALTER TABLE center_server_application_rel ADD COLUMN `subdomains` varchar(225) DEFAULT NULL COMMENT '二级域名' AFTER `sort`;
|
||
|
|
ALTER TABLE center_server_application_rel ADD COLUMN `remark` varchar(225) DEFAULT NULL COMMENT '声明' AFTER `subdomains`;
|
||
|
|
ALTER TABLE center_server_application_rel ADD COLUMN `logo_url` varchar(128) DEFAULT NULL COMMENT '平台logo' AFTER `remark`;
|
||
|
|
|
||
|
|
ALTER TABLE center_server_application_rel MODIFY COLUMN `application_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '应用名称';
|
||
|
|
ALTER TABLE `center_server_application_rel`
|
||
|
|
COLUMN `adcode` varchar(20) NULL COMMENT '地址编码' AFTER `logo_url`,
|
||
|
|
ADD COLUMN `lng` decimal(10, 6) NULL COMMENT '经度' AFTER `adcode`,
|
||
|
|
ADD COLUMN `lat` decimal(10, 6) NULL COMMENT '纬度' AFTER `lng`;
|
||
|
|
ALTER TABLE `center_server_application_rel`
|
||
|
|
ADD COLUMN `adcode` varchar(20) NULL COMMENT '地址编码' AFTER `logo_url`,
|
||
|
|
ADD COLUMN `address` varchar(128) NULL COMMENT '地址' AFTER `adcode`,
|
||
|
|
ADD COLUMN `lng` decimal(10, 6) NULL COMMENT '经度' AFTER `address`,
|
||
|
|
ADD COLUMN `lat` decimal(10, 6) NULL COMMENT '纬度' AFTER `lng`;
|