4dkankan-center-manage/doc/update.2.2.0.sql

CREATE TABLE `4dkankan_v4`.`t_district_code`  (
                                           `id` int NOT NULL AUTO_INCREMENT,
                                           `code` varchar(255) NULL,
                                           `name` varchar(255) NULL,
                                           `parent_code` varchar(255) NULL,
                                           PRIMARY KEY (`id`)
);


ALTER TABLE `4dkankan_v4`.`jy_platform`
    ADD COLUMN `district_code` varchar(255) NULL AFTER `id_card`,
    ADD COLUMN `district_name` varchar(255) NULL AFTER `district_code`;


ALTER TABLE `4dkankan_v4`.`jy_user`
    ADD COLUMN `district_code` varchar(255) NULL AFTER `platform_id`,
    ADD COLUMN `district_name` varchar(255) NULL AFTER `district_code`;