<?xml version="1.0" encoding="utf-8"?>

<databaseChangeLog
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.4.xsd">


	<changeSet author="tb" id="2021-08-27-tb-1">
		<preConditions onFail="MARK_RAN">
			<not>
				<tableExists tableName="jc_rally_point"/>
			</not>
		</preConditions>
		<comment>create table jc_rally_point</comment>
		<sql>
			CREATE TABLE `jc_rally_point` (
			`sequence_nbr` bigint(30) NOT NULL COMMENT '主键',
			`name` varchar(100) DEFAULT NULL COMMENT '名称',
			`address` varchar(255) DEFAULT NULL COMMENT '地址',
			`alert_id` bigint(30) NOT NULL COMMENT '警情id',
			`longitude` varchar(20) NOT NULL COMMENT '经度',
			`latitude` varchar(20) NOT NULL COMMENT '纬度',
			`rec_user_id` bigint(30) NOT NULL COMMENT '更新用户id',
			`rec_user_name` varchar(30) NOT NULL COMMENT '更新用户名称',
			`rec_date` datetime NOT NULL COMMENT '更新日期',
			`is_delete` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除(1:删除,0:未删除)',
			PRIMARY KEY (`sequence_nbr`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='集结点';
		</sql>
	</changeSet>
	<changeSet author="tb" id="2021-08-27-tb-2">
		<preConditions onFail="MARK_RAN">
			<not>
				<tableExists tableName="jc_alert_location_log"/>
			</not>
		</preConditions>
		<comment>create table jc_alert_location_log</comment>
		<sql>
			CREATE TABLE `jc_alert_location_log` (
			`sequence_nbr` bigint(30) NOT NULL COMMENT '主键',
			`alert_id` bigint(30) NOT NULL COMMENT '警情id',
			`longitude` varchar(30) NOT NULL COMMENT '经度',
			`latitude` varchar(30) NOT NULL COMMENT '纬度',
			`rec_user_id` bigint(30) NOT NULL COMMENT '更新人员id',
			`rec_user_name` varchar(50) NOT NULL COMMENT '更新人员名称',
			`rec_date` datetime NOT NULL COMMENT '更新时间',
			`is_delete` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除(1: 已删除，0:未删除)',
			PRIMARY KEY (`sequence_nbr`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
		</sql>
	</changeSet>
	<changeSet author="chenhao" id="2021-08-31-chenhao-1">
		
		<comment>modify table cb_firefighters_thought add one columns</comment>
		<sql>
			ALTER TABLE `cb_firefighters_thought` modify talking_time datetime COMMENT '谈话时间';
		</sql>
	</changeSet>
	<changeSet author="litengwei" id="2021-09-01-litengwei-1">
		<preConditions onFail="MARK_RAN">

			<tableExists tableName="cb_data_dictionary" />
<!--			<sqlCheck expectedResult="0">select count(*) from cb_data_dictionary where sequence_nbr between 1152 and-->
<!--				1166</sqlCheck>-->
			<not>
				<primaryKeyExists primaryKeyName="sequence_nbr" tableName="cb_data_dictionary"/>
			</not>
		</preConditions>
		<comment>add data cb_data_dictionary</comment>
		<sql>
			INSERT INTO `cb_data_dictionary` VALUES(1152, '1152', '大面积航班延误保障', 'QTZL', NULL, NULL, NULL, NULL, NULL, 0, 1);
			INSERT INTO `cb_data_dictionary` VALUES(1153, '1153', '二类运行保障', 'QTZL', NULL, NULL, NULL, NULL, NULL, 0, 1);
			INSERT INTO `cb_data_dictionary` VALUES(1154, '1154', '施工加油保障', 'QTZL', NULL, NULL, NULL, NULL, NULL, 0, 1);
			INSERT INTO `cb_data_dictionary` VALUES(1155, '1155', '航空器失事', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0, 1);
			INSERT INTO `cb_data_dictionary` VALUES(1156, '1156', '空中遇险', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0, 1);
			INSERT INTO `cb_data_dictionary` VALUES(1157, '1157', '跑道事件', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0, 1);
			INSERT INTO `cb_data_dictionary` VALUES(1158, '1158', '地面遇险', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0, 1);
			INSERT INTO `cb_data_dictionary` VALUES(1159, '1159', '劫机', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0, 1);
			INSERT INTO `cb_data_dictionary` VALUES(1160, '1160', '发现爆炸物', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0, 1);
			INSERT INTO `cb_data_dictionary` VALUES(1161, '1161', '爆炸物威胁', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0, 1);
			INSERT INTO `cb_data_dictionary` VALUES(1162, '1162', '其他非法干扰', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0, 1);
			INSERT INTO `cb_data_dictionary` VALUES(1163, '1163', '残损航空器搬移', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0, 1);
			INSERT INTO `cb_data_dictionary` VALUES(1164, '1164', '紧急出动', 'XYJB', NULL, NULL, NULL, NULL, NULL, 0, 1);
			INSERT INTO `cb_data_dictionary` VALUES(1165, '1165', '紧急集结', 'XYJB', NULL, NULL, NULL, NULL, NULL, 0, 1);
			INSERT INTO `cb_data_dictionary` VALUES(1166, '1166', '原地待命', 'XYJB', NULL, NULL, NULL, NULL, NULL, 0, 1);
		</sql>
	</changeSet>
	<changeSet author="litengwei" id="2021-09-01-litengwei-2">
		<preConditions onFail="MARK_RAN">
			<tableExists tableName="jc_alert_form" />
			<not>
				<primaryKeyExists primaryKeyName="sequence_nbr" tableName="jc_alert_form"/>
			</not>
		</preConditions>
		<comment>add data jc_alert_form</comment>
		<sql>
			INSERT INTO `jc_alert_form` VALUES(127, '230', 'HKQJYZL', '航空器救援子类', 'aircraftRescueSub', 'radio', NULL, NULL, NULL, 0, 1, 1, NULL);
			INSERT INTO `jc_alert_form` VALUES(128, '242', 'QTZL', '子类', 'sub', 'radio', NULL, NULL, NULL, 0, 1, 1, NULL);
			INSERT INTO `jc_alert_form` VALUES(129, '230', NULL, '机位', 'mechinePosition', 'select', NULL, NULL, NULL, 0, 0, 5, NULL);
			INSERT INTO `jc_alert_form` VALUES(130, '230', NULL, '响应级别', 'responseLevel', 'select', NULL, NULL, NULL, 0, 0, 8, NULL);
		</sql>
	</changeSet>
	<changeSet author="litengwei" id="2021-09-01-litengwei-3">
		<preConditions onFail="MARK_RAN">
			<tableExists tableName="jc_alert_form" />
		</preConditions>
		<comment>update data jc_alert_form</comment>
		<sql>
			UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='航班号', field_code='flightNumber', field_type='selectDelay', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL, is_delete=0, block=0, sort_num=2, url='aircraft/getAircraftNum' WHERE sequence_nbr=103;
			UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='航空器型号', field_code='aircraftModel', field_type='input', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL, is_delete=0, block=0, sort_num=3, url='aircraft/getAircraft' WHERE sequence_nbr=104;
			UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='落地时间', field_code='landingTime', field_type='datetime', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL, is_delete=0, block=0, sort_num=4, url=NULL WHERE sequence_nbr=105;
			UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='航空器故障部位', field_code='damageLocation', field_type='selectDelay', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL, is_delete=0, block=0, sort_num=7, url='data-dictionary/gwmcDataDictionary/FJSSWZ' WHERE sequence_nbr=106;
			UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='燃油量(吨)', field_code='fuelQuantity', field_type='inputNumber', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL, is_delete=0, block=0, sort_num=10, url=NULL WHERE sequence_nbr=107;
			UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='载客量', field_code='passengerCapacity', field_type='inputNumber', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL, is_delete=0, block=0, sort_num=9, url=NULL WHERE sequence_nbr=108;
			UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code='PJPD', field_name='迫降跑道', field_code='forcedLandingTrack ', field_type='select', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL, is_delete=0, block=0, sort_num=6, url='' WHERE sequence_nbr=109;
			UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='灾害事故情况', field_code='accidentSituation', field_type='textarea', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL, is_delete=0, block=1, sort_num=11, url=NULL WHERE sequence_nbr=110;
			UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='发展态势', field_code='developmentTrend', field_type='textarea', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL, is_delete=0, block=1, sort_num=12, url=NULL WHERE sequence_nbr=111;
			UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='备注', field_code='remarks', field_type='textarea', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL, is_delete=0, block=1, sort_num=13, url=NULL WHERE sequence_nbr=112;
			UPDATE `jc_alert_form` SET alert_type_code='242', field_value_code=NULL, field_name='保障类别', field_code='securityCategory', field_type='selectDelay', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL, is_delete=0, block=0, sort_num=2, url='data-dictionary/gwmcDataDictionary/YGCJ' WHERE sequence_nbr=124;
			UPDATE `jc_alert_form` SET alert_type_code='242', field_value_code=NULL, field_name='事件概述', field_code='eventOverview', field_type='textarea', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL, is_delete=0, block=1, sort_num=3, url=NULL WHERE sequence_nbr=125;
			UPDATE `jc_alert_form` SET alert_type_code='242', field_value_code=NULL, field_name='备注', field_code='remarks', field_type='textarea', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL, is_delete=0, block=1, sort_num=4, url=NULL WHERE sequence_nbr=126;
		</sql>
	</changeSet>
	<changeSet author="chenhao" id="2021-09-02-chenhao-1">
		<comment>update data cb_data_dictionary</comment>
		<sql>
			update  cb_data_dictionary set name ='无固定期合同' where name ='无固定器合同' and type='HTLB';
		</sql>
	</changeSet>
	<changeSet author="chenhao" id="2021-09-02-chenhao-2">
		<comment>update data jc_alert_form</comment>
		<sql>
			update  jc_alert_form set field_name ='燃油量(吨)' where alert_type_code ='230' and field_code='fuelQuantity';
			update  jc_alert_form set field_name ='载客量(人)' where alert_type_code ='230' and field_code='passengerCapacity';
		</sql>
	</changeSet>
	<changeSet author="chenhao" id="2021-09-02-chenhao-3">
		<comment>update data cb_fire_team</comment>
		<sql>
				ALTER TABLE `cb_fire_team` modify longitude double(18,14) COMMENT '经度';
				ALTER TABLE `cb_fire_team` modify latitude double(18,14) COMMENT '纬度';
		</sql>
	</changeSet>
	<changeSet author="chenhao" id="2021-09-02-chenhao-4">
		<comment>update data cb_fire_station</comment>
		<sql>
				ALTER TABLE `cb_fire_station` modify longitude double(18,14) COMMENT '经度';
				ALTER TABLE `cb_fire_station` modify latitude double(18,14) COMMENT '纬度';
		</sql>
	</changeSet>
	<changeSet author="chenhao" id="2021-09-02-chenhao-5">
		<comment>update data cb_linkage_unit</comment>
		<sql>
				ALTER TABLE `cb_linkage_unit` modify longitude double(18,14) COMMENT '经度';
				ALTER TABLE `cb_linkage_unit` modify latitude double(18,14) COMMENT '纬度';
		</sql>
	</changeSet>
	<changeSet author="chenhao" id="2021-09-02-chenhao-6">
		<comment>update data cb_water_resource</comment>
		<sql>
				ALTER TABLE `cb_water_resource` modify longitude double(18,14) COMMENT '经度';
				ALTER TABLE `cb_water_resource` modify latitude double(18,14) COMMENT '纬度';
		</sql>
	</changeSet>
	<changeSet author="kongfm" id="2021-09-03-kongfm-1">
		<preConditions onFail="MARK_RAN">
			<tableExists tableName="cb_firefighters"/>
		</preConditions>
		<comment>modify table cb_firefighters add several columns</comment>
		<sql>
			ALTER TABLE `cb_firefighters` add native_place_value varchar(255) COMMENT '户籍所在地的值';
		</sql>
	</changeSet>
	 <changeSet author="chenhao" id="2021-09-06-chenhao-1">
		<preConditions onFail="MARK_RAN">
			<tableExists tableName="cb_data_dictionary" />
			<not>
				<primaryKeyExists primaryKeyName="sequence_nbr" tableName="cb_data_dictionary"/>
			</not>
    	</preConditions>
		<comment>insert data cb_data_dictionary</comment>
		<sql>
				INSERT INTO cb_data_dictionary (`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES ('1168', '1168', '环状管网', 'XFJSGW', NULL, NULL, NULL, NULL, NULL, '\0', '1');
				INSERT INTO cb_data_dictionary (`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES ('1169', '1169', '环支状管网', 'XFJSGW', NULL, NULL, NULL, NULL, NULL, '\0', '1');
				INSERT INTO cb_data_dictionary (`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES ('1170', '1170', '可用', 'SYZT', NULL, NULL, NULL, NULL, NULL, '\0', '1');
				INSERT INTO cb_data_dictionary (`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES ('1171', '1171', '不可用', 'SYZT', NULL, NULL, NULL, NULL, NULL, '\0', '1');
		</sql> 
	</changeSet>
    <changeSet author="guowubin" id="1629430730658-1">
        <comment>alter table jc_controller</comment>
        <sql>
            DROP TABLE IF EXISTS `jc_controller`;
            CREATE TABLE `jc_controller` (
            `sequence_nbr` bigint(22) NOT NULL COMMENT 'id',
            `station` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '控制站',
            `c_ip` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'ip',
            `c_port` int(11) NULL DEFAULT NULL COMMENT '端口',
            `c_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '控制器名称',
            `type` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '控制器类别',
            `c_state` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
            `rec_date` datetime(0) NULL DEFAULT NULL,
            `rec_user_id` int(11) NULL DEFAULT NULL,
            `rec_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
            `is_delete` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
            PRIMARY KEY (`sequence_nbr`) USING BTREE
            ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
        </sql>
    </changeSet>

    <changeSet author="guowubin" id="1629430730658-2">
        <preConditions onFail="MARK_RAN">
            <tableExists tableName="jc_controller"/>
        </preConditions>
        <comment>add data table jc_controller</comment>
        <sql>
            INSERT INTO `jc_controller` VALUES (1245230062463119361, '2', NULL, NULL, '南站广播', '2', '1', '2021-08-20
            09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller` VALUES (1308575795966443521, '1', NULL, NULL, '主站警铃', '1', '1', '2021-08-20
            09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller` VALUES (1428303671921250305, '3', NULL, NULL, '北站广播', '2', '1', '2021-08-20
            09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller` VALUES (1428306948020801538, '3', NULL, NULL, '北站警铃', '1', '1', '2021-08-20
            09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller` VALUES (1428323093599784962, '2', '172.19.111.163', 502, '南站电门控制', '3', '1',
            '2021-08-20 09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller` VALUES (1428325245344845826, '2', NULL, NULL, '南站警铃', '1', '1', '2021-08-20
            09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller` VALUES (1428325285853433857, '3', '172.19.111.153', 502, '北站电门控制', '3', '1',
            '2021-08-20 09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller` VALUES (1428325336898113537, '1', NULL, NULL, '主站广播', '2', '1', '2021-08-20
            09:46:02', 3111584, 'admin_jcs', '0');
        </sql>
    </changeSet>

    <changeSet author="guowubin" id="1629430730658-3">
        <comment>alter table jc_controller_equip</comment>
        <sql>
            DROP TABLE IF EXISTS `jc_controller_equip`;
            CREATE TABLE `jc_controller_equip` (
            `sequence_nbr` bigint(20) NOT NULL COMMENT 'id',
            `controller_seq` bigint(20) NULL DEFAULT NULL COMMENT '控制站',
            `e_num` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'ip',
            `e_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '端口',
            `e_state` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态',
            `rec_date` datetime(0) NULL DEFAULT NULL,
            `rec_user_id` int(11) NULL DEFAULT NULL,
            `rec_user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
            `is_delete` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
            PRIMARY KEY (`sequence_nbr`) USING BTREE
            ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
        </sql>
    </changeSet>

    <changeSet author="guowubin" id="1629430730658-4">
        <preConditions onFail="MARK_RAN">
            <tableExists tableName="jc_controller_equip"/>
        </preConditions>
        <comment>add data table jc_controller_equip</comment>
        <sql>
            INSERT INTO `jc_controller_equip` VALUES (1192346783527378946, 1428325245344845826, '206', '警铃终端', '1',
            '2021-08-20 09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller_equip` VALUES (1245230052539396097, 1245230062463119361, '202', '广播终端', '1',
            '2021-08-20 09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller_equip` VALUES (1272442241152421890, 1428325285853433857, '100', '1号门', '1',
            '2021-08-20 09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller_equip` VALUES (1274947632054542338, 1428325285853433857, '101', '2号门', '1',
            '2021-08-20 09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller_equip` VALUES (1302793235940249602, 1428306948020801538, '205', '警铃终端', '1',
            '2021-08-20 09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller_equip` VALUES (1315854437968797697, 1428323093599784962, '100', '4个电门', '1',
            '2021-08-20 09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller_equip` VALUES (1320637765980856322, 1428325285853433857, '102', '3号门', '1',
            '2021-08-20 09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller_equip` VALUES (1332610043605946369, 1308575795966443521, '204', '警铃终端', '1',
            '2021-08-20 09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller_equip` VALUES (1343765647514955778, 1428325336898113537, '201', '广播终端', '1',
            '2021-08-20 09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller_equip` VALUES (1397143491787747330, 1428303671921250305, '203', '广播终端', '1',
            '2021-08-20 09:46:02', 3111584, 'admin_jcs', '0');
            INSERT INTO `jc_controller_equip` VALUES (1397145718640209921, 1428325285853433857, '103', '4号门', '1',
            '2021-08-20 09:46:02', 3111584, 'admin_jcs', '0');
        </sql>
    </changeSet>
    <changeSet author="tb" id="2021-08-23-tb-1">
        <preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_water_resource"/>
        </preConditions>
        <comment>modify table cb_water_resource add several columns</comment>
        <sql>
            ALTER TABLE `cb_water_resource` ADD equip_id BIGINT ( 20 ) COMMENT '设施定义',
            ADD COLUMN equip_name VARCHAR ( 50 ) COMMENT '设施定义名称',
            ADD COLUMN equip_category_id BIGINT ( 20 ) COMMENT '设施分类',
            ADD COLUMN equip_category_name VARCHAR ( 50 ) COMMENT '设施分类名称',
            ADD COLUMN equip_code VARCHAR ( 20 ) COMMENT '设施编码',
            ADD COLUMN maintenance_period VARCHAR ( 10 ) COMMENT '维保周期';
        </sql>
    </changeSet>

    <changeSet author="chenhao" id="2021-08-26-chenhao-1">
        <preConditions onFail="MARK_RAN">
            <not>
                <columnExists tableName="cb_firefighters_contract" columnName="start_time"/>
            </not>
        </preConditions>
        <comment>modify table cb_firefighters_contract add one columns</comment>
        <sql>
            ALTER TABLE `cb_firefighters_contract` ADD start_time date COMMENT '起始时间';
        </sql>
    </changeSet>

    <changeSet author="tb" id="2021-08-27-tb-1">
        <preConditions onFail="MARK_RAN">
            <not>
                <tableExists tableName="jc_rally_point"/>
            </not>
        </preConditions>
        <comment>create table jc_rally_point</comment>
        <sql>
            CREATE TABLE `jc_rally_point` (
            `sequence_nbr` bigint(30) NOT NULL COMMENT '主键',
            `name` varchar(100) DEFAULT NULL COMMENT '名称',
            `address` varchar(255) DEFAULT NULL COMMENT '地址',
            `alert_id` bigint(30) NOT NULL COMMENT '警情id',
            `longitude` varchar(20) NOT NULL COMMENT '经度',
            `latitude` varchar(20) NOT NULL COMMENT '纬度',
            `rec_user_id` bigint(30) NOT NULL COMMENT '更新用户id',
            `rec_user_name` varchar(30) NOT NULL COMMENT '更新用户名称',
            `rec_date` datetime NOT NULL COMMENT '更新日期',
            `is_delete` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除(1:删除,0:未删除)',
            PRIMARY KEY (`sequence_nbr`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='集结点';
        </sql>
    </changeSet>
    <changeSet author="tb" id="2021-08-27-tb-2">
        <preConditions onFail="MARK_RAN">
            <not>
                <tableExists tableName="jc_alert_location_log"/>
            </not>
        </preConditions>
        <comment>create table jc_alert_location_log</comment>
        <sql>
            CREATE TABLE `jc_alert_location_log` (
            `sequence_nbr` bigint(30) NOT NULL COMMENT '主键',
            `alert_id` bigint(30) NOT NULL COMMENT '警情id',
            `longitude` varchar(30) NOT NULL COMMENT '经度',
            `latitude` varchar(30) NOT NULL COMMENT '纬度',
            `rec_user_id` bigint(30) NOT NULL COMMENT '更新人员id',
            `rec_user_name` varchar(50) NOT NULL COMMENT '更新人员名称',
            `rec_date` datetime NOT NULL COMMENT '更新时间',
            `is_delete` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除(1: 已删除，0:未删除)',
            PRIMARY KEY (`sequence_nbr`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
        </sql>
    </changeSet>
    <changeSet author="chenhao" id="2021-08-31-chenhao-1">

        <comment>modify table cb_firefighters_thought add one columns</comment>
        <sql>
            ALTER TABLE `cb_firefighters_thought` modify talking_time datetime COMMENT '谈话时间';
        </sql>
    </changeSet>
    <changeSet author="litengwei" id="2021-09-01-litengwei-1">
        <preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_data_dictionary"/>
        </preConditions>
        <comment>add data cb_data_dictionary</comment>
        <sql>
            INSERT INTO `cb_data_dictionary` VALUES(1152, '1152', '大面积航班延误保障', 'QTZL', NULL, NULL, NULL, NULL, NULL, 0,
            1);
            INSERT INTO `cb_data_dictionary` VALUES(1153, '1153', '二类运行保障', 'QTZL', NULL, NULL, NULL, NULL, NULL, 0, 1);
            INSERT INTO `cb_data_dictionary` VALUES(1154, '1154', '施工加油保障', 'QTZL', NULL, NULL, NULL, NULL, NULL, 0, 1);
            INSERT INTO `cb_data_dictionary` VALUES(1155, '1155', '航空器失事', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0,
            1);
            INSERT INTO `cb_data_dictionary` VALUES(1156, '1156', '空中遇险', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0,
            1);
            INSERT INTO `cb_data_dictionary` VALUES(1157, '1157', '跑道事件', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0,
            1);
            INSERT INTO `cb_data_dictionary` VALUES(1158, '1158', '地面遇险', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0,
            1);
            INSERT INTO `cb_data_dictionary` VALUES(1159, '1159', '劫机', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0, 1);
            INSERT INTO `cb_data_dictionary` VALUES(1160, '1160', '发现爆炸物', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0,
            1);
            INSERT INTO `cb_data_dictionary` VALUES(1161, '1161', '爆炸物威胁', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0,
            1);
            INSERT INTO `cb_data_dictionary` VALUES(1162, '1162', '其他非法干扰', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0,
            1);
            INSERT INTO `cb_data_dictionary` VALUES(1163, '1163', '残损航空器搬移', 'HKQJYZL', NULL, NULL, NULL, NULL, NULL, 0,
            1);
            INSERT INTO `cb_data_dictionary` VALUES(1164, '1164', '紧急出动', 'XYJB', NULL, NULL, NULL, NULL, NULL, 0, 1);
            INSERT INTO `cb_data_dictionary` VALUES(1165, '1165', '紧急集结', 'XYJB', NULL, NULL, NULL, NULL, NULL, 0, 1);
            INSERT INTO `cb_data_dictionary` VALUES(1166, '1166', '原地待命', 'XYJB', NULL, NULL, NULL, NULL, NULL, 0, 1);
        </sql>
    </changeSet>
    <changeSet author="litengwei" id="2021-09-01-litengwei-2">
        <preConditions onFail="MARK_RAN">
            <tableExists tableName="jc_alert_form"/>
        </preConditions>
        <comment>add data jc_alert_form</comment>
        <sql>
            INSERT INTO `jc_alert_form` VALUES(127, '230', 'HKQJYZL', '航空器救援子类', 'aircraftRescueSub', 'radio', NULL,
            NULL, NULL, 0, 1, 1, NULL);
            INSERT INTO `jc_alert_form` VALUES(128, '242', 'QTZL', '子类', 'sub', 'radio', NULL, NULL, NULL, 0, 1, 1,
            NULL);
            INSERT INTO `jc_alert_form` VALUES(129, '230', NULL, '机位', 'mechinePosition', 'select', NULL, NULL, NULL, 0,
            0, 5, NULL);
            INSERT INTO `jc_alert_form` VALUES(130, '230', NULL, '响应级别', 'responseLevel', 'select', NULL, NULL, NULL, 0,
            0, 8, NULL);
        </sql>
    </changeSet>
    <changeSet author="litengwei" id="2021-09-01-litengwei-3">
        <preConditions onFail="MARK_RAN">
            <tableExists tableName="jc_alert_form"/>
        </preConditions>
        <comment>update data jc_alert_form</comment>
        <sql>
            UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='航班号',
            field_code='flightNumber', field_type='selectDelay', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL,
            is_delete=0, block=0, sort_num=2, url='aircraft/getAircraftNum' WHERE sequence_nbr=103;
            UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='航空器型号',
            field_code='aircraftModel', field_type='input', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL,
            is_delete=0, block=0, sort_num=3, url='aircraft/getAircraft' WHERE sequence_nbr=104;
            UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='落地时间',
            field_code='landingTime', field_type='datetime', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL,
            is_delete=0, block=0, sort_num=4, url=NULL WHERE sequence_nbr=105;
            UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='航空器故障部位',
            field_code='damageLocation', field_type='selectDelay', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL,
            is_delete=0, block=0, sort_num=7, url='data-dictionary/gwmcDataDictionary/FJSSWZ' WHERE sequence_nbr=106;
            UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='燃油量(吨)',
            field_code='fuelQuantity', field_type='inputNumber', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL,
            is_delete=0, block=0, sort_num=10, url=NULL WHERE sequence_nbr=107;
            UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='载客量',
            field_code='passengerCapacity', field_type='inputNumber', rec_user_name=NULL, rec_user_id=NULL,
            rec_date=NULL, is_delete=0, block=0, sort_num=9, url=NULL WHERE sequence_nbr=108;
            UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code='PJPD', field_name='迫降跑道',
            field_code='forcedLandingTrack ', field_type='select', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL,
            is_delete=0, block=0, sort_num=6, url='' WHERE sequence_nbr=109;
            UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='灾害事故情况',
            field_code='accidentSituation', field_type='textarea', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL,
            is_delete=0, block=1, sort_num=11, url=NULL WHERE sequence_nbr=110;
            UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='发展态势',
            field_code='developmentTrend', field_type='textarea', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL,
            is_delete=0, block=1, sort_num=12, url=NULL WHERE sequence_nbr=111;
            UPDATE `jc_alert_form` SET alert_type_code='230', field_value_code=NULL, field_name='备注',
            field_code='remarks', field_type='textarea', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL,
            is_delete=0, block=1, sort_num=13, url=NULL WHERE sequence_nbr=112;
            UPDATE `jc_alert_form` SET alert_type_code='242', field_value_code=NULL, field_name='保障类别',
            field_code='securityCategory', field_type='selectDelay', rec_user_name=NULL, rec_user_id=NULL,
            rec_date=NULL, is_delete=0, block=0, sort_num=2, url='data-dictionary/gwmcDataDictionary/YGCJ' WHERE
            sequence_nbr=124;
            UPDATE `jc_alert_form` SET alert_type_code='242', field_value_code=NULL, field_name='事件概述',
            field_code='eventOverview', field_type='textarea', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL,
            is_delete=0, block=1, sort_num=3, url=NULL WHERE sequence_nbr=125;
            UPDATE `jc_alert_form` SET alert_type_code='242', field_value_code=NULL, field_name='备注',
            field_code='remarks', field_type='textarea', rec_user_name=NULL, rec_user_id=NULL, rec_date=NULL,
            is_delete=0, block=1, sort_num=4, url=NULL WHERE sequence_nbr=126;
        </sql>
    </changeSet>
    <changeSet author="chenhao" id="2021-09-02-chenhao-1">
        <comment>update data cb_data_dictionary</comment>
        <sql>
            update cb_data_dictionary set name ='无固定期合同' where name ='无固定器合同' and type='HTLB';
        </sql>
    </changeSet>
    <changeSet author="chenhao" id="2021-09-02-chenhao-2">
        <comment>update data jc_alert_form</comment>
        <sql>
            update jc_alert_form set field_name ='燃油量(吨)' where alert_type_code ='230' and field_code='fuelQuantity';
            update jc_alert_form set field_name ='载客量(人)' where alert_type_code ='230' and
            field_code='passengerCapacity';
        </sql>
    </changeSet>
    <changeSet author="chenhao" id="2021-09-02-chenhao-3">
        <comment>update data cb_fire_team</comment>
        <sql>
            ALTER TABLE `cb_fire_team` modify longitude double(18,14) COMMENT '经度';
            ALTER TABLE `cb_fire_team` modify latitude double(18,14) COMMENT '纬度';
        </sql>
    </changeSet>
    <changeSet author="chenhao" id="2021-09-02-chenhao-4">
        <comment>update data cb_fire_station</comment>
        <sql>
            ALTER TABLE `cb_fire_station` modify longitude double(18,14) COMMENT '经度';
            ALTER TABLE `cb_fire_station` modify latitude double(18,14) COMMENT '纬度';
        </sql>
    </changeSet>
    <changeSet author="chenhao" id="2021-09-02-chenhao-5">
        <comment>update data cb_linkage_unit</comment>
        <sql>
            ALTER TABLE `cb_linkage_unit` modify longitude double(18,14) COMMENT '经度';
            ALTER TABLE `cb_linkage_unit` modify latitude double(18,14) COMMENT '纬度';
        </sql>
    </changeSet>
    <changeSet author="chenhao" id="2021-09-02-chenhao-6">
        <comment>update data cb_water_resource</comment>
        <sql>
            ALTER TABLE `cb_water_resource` modify longitude double(18,14) COMMENT '经度';
            ALTER TABLE `cb_water_resource` modify latitude double(18,14) COMMENT '纬度';
        </sql>
    </changeSet>
    <changeSet author="kongfm" id="2021-09-03-kongfm-1">
        <preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_firefighters"/>
        </preConditions>
        <comment>modify table cb_firefighters add several columns</comment>
        <sql>
            ALTER TABLE `cb_firefighters` add native_place_value varchar(255) COMMENT '户籍所在地的值';
        </sql>
    </changeSet>
    <changeSet author="chenhao" id="2021-09-06-chenhao-1">
        <preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_data_dictionary"/>
        </preConditions>
        <comment>insert data cb_data_dictionary</comment>
        <sql>
            INSERT INTO cb_data_dictionary (`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`,
            `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES ('1168', '1168', '环状管网',
            'XFJSGW', NULL, NULL, NULL, NULL, NULL, '\0', '1');
            INSERT INTO cb_data_dictionary (`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`,
            `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES ('1169', '1169', '环支状管网',
            'XFJSGW', NULL, NULL, NULL, NULL, NULL, '\0', '1');
            INSERT INTO cb_data_dictionary (`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`,
            `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES ('1170', '1170', '可用', 'SYZT',
            NULL, NULL, NULL, NULL, NULL, '\0', '1');
            INSERT INTO cb_data_dictionary (`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`,
            `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES ('1171', '1171', '不可用', 'SYZT',
            NULL, NULL, NULL, NULL, NULL, '\0', '1');
        </sql>
    </changeSet>
    <changeSet author="tb" id="2021-09-08-tb-1">
        <preConditions onFail="MARK_RAN">
            <not>
                <tableExists tableName="jc_transfer_resource_feedback"/>
            </not>
        </preConditions>
        <comment>create table jc_transfer_resource_feedback</comment>
        <sql>
            CREATE TABLE `jc_transfer_resource_feedback` (
            `sequence_nbr` bigint(30) NOT NULL COMMENT '主键',
            `transfer_company_resource_id` bigint(30) NOT NULL COMMENT '调派任务id',
            `status` varchar(255) NOT NULL COMMENT '反馈调派任务状态（执行中：executing，已完成：finished）',
            `remark` varchar(255) DEFAULT NULL COMMENT '备注',
            `rec_user_id` bigint(30) NOT NULL COMMENT '更新人id',
            `rec_user_name` varchar(50) NOT NULL COMMENT '更新人名称',
            `rec_date` datetime NOT NULL COMMENT '更新时间',
            `is_delete` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除（1：删除，0：未删除）',
            PRIMARY KEY (`sequence_nbr`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='警情调派任务反馈';
        </sql>
    </changeSet>
    <changeSet author="tb" id="2021-09-08-tb-2">
        <preConditions onFail="MARK_RAN">
            <not>
                <columnExists tableName="jc_power_transfer_company_resources" columnName="status"/>
            </not>
        </preConditions>
        <comment>modify table jc_power_transfer_company_resources add status column</comment>
        <sql>
            ALTER TABLE `jc_power_transfer_company_resources` ADD status varchar(20) DEFAULT 'executing' COMMENT
            '调派任务状态(执行中：executing，已完成：finished)';
        </sql>
    </changeSet>
    
    <changeSet author="chenhao" id="2021-09-13-chenhao-1">
		<comment>update data cb_firefighters_workexperience</comment>
		<sql>
				ALTER TABLE `cb_firefighters_workexperience` modify working_hours date COMMENT '参加工作时间';
				ALTER TABLE `cb_firefighters_workexperience` modify fire_working_hours date COMMENT '参加消防部门工作时间';
				</sql>
	</changeSet>
	<changeSet author="kongfm" id="2021-09-13-kongfm-1">
		<preConditions onFail="MARK_RAN">
			<tableExists tableName="cb_firefighters"/>
		</preConditions>
		<comment>BUG 3658 优化 by kongfm 2021-09-13 需求详细说明 1. 添加两个字段  2. 地区选择联动  只有新增时带联动  编辑时不带联动 3. 导出模板及导入同步修改</comment>
		<sql>
			ALTER TABLE `cb_firefighters` add native_place_val varchar(255) COMMENT '户籍所在地详细地址';
			ALTER TABLE `cb_firefighters` add residence_detail_val varchar(255) COMMENT '现居住地详细地址';
		</sql>
	</changeSet>


    <changeSet id="2021-09-24" author="cz">

        <preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_data_dictionary"/>
        </preConditions>
        <comment>修改数据库字段type_desc长度</comment>
        <sql>
            ALTER TABLE cb_data_dictionary MODIFY COLUMN type_desc VARCHAR(225);
        </sql>
    </changeSet>

    <changeSet author="chenzhao" id="2021-09-07-chenzhao">
        <preConditions onFail="MARK_RAN">

            <tableExists tableName="cb_data_dictionary"/>

            <primaryKeyExists primaryKeyName="sequence_nbr" tableName="cb_data_dictionary"/>

        </preConditions>
        <comment>add data cb_data_dictionary</comment>
        <sql>

            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1173,'394','GTC屋顶','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/GTCWD_BASE_ZLXY/MapServer');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1174,'386','T1航站楼二层','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/T1F2_BASE_ZLXY1/MapServer');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1175,'397','T1航站楼一层','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/T1F1_BASE_ZLXY1/MapServer');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1176,'387','T2航站楼二层','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/T2F2_BASE_ZLXY/MapServer');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1177,'398','T2航站楼地下一层','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/T2B1_BASE_ZLXY/MapServer');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1178,'399','T2航站楼一层','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/T2F1_BASE_ZLXY/MapServer');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1179,'400','T2航站楼一层夹层','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/T2F1J_BASE_ZLXY/MapServer');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1180,'965','南指廊二层夹层','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/NZLF2J_BASE_ZLXY/MapServer');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1181,'389','南指廊二层','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/NZLF2_BASE_ZLXY/MapServer');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1182,'867','南指廊一层','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/NZLF1_BASE_ZLXY/MapServer');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1183,'412','T3航站楼二层夹层','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/T3F2J_BASE_LT/MapServer');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1184,'411','T3航站楼二层','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/T3F2_BASE_ZLXY1/MapServer');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1185,'410','T3航站楼一层夹层','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/T3F1J_BASE_ZLXY/MapServer');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1186,'409','T3航站楼一层','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/T3F1_BASE_ZLXY1/MapServer');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1187,'407','T3航站楼地下一层','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/T3B1_BASE_ZLXY/MapServer');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1188,'408','T3航站楼地下二层','GISDT','http://172.19.80.22:6080/arcgis/rest/services/ZLXY/T3B2_BASE_ZLXY/MapServer');
        </sql>
    </changeSet>

    <changeSet author="chenzhao" id="2021-09-08-chenzhao">
        <preConditions onFail="MARK_RAN">

            <tableExists tableName="cb_data_dictionary"/>

            <primaryKeyExists primaryKeyName="sequence_nbr" tableName="cb_data_dictionary"/>

        </preConditions>
        <comment>add data cb_data_dictionary</comment>
        <sql>

            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type) VALUES (1189,'1189','T1航站楼GIS','GISDT');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type) VALUES (1190,'1190','T2航站楼GIS','GISDT');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type) VALUES (1191,'1191','T3航站楼GIS','GISDT');

        </sql>
    </changeSet>


    <changeSet author="chenzhao" id="2021-09-08-chenzhao-2">
        <comment>update data cb_data_dictionary</comment>
        <sql>
            update cb_data_dictionary set parent = 1189 where sequence_nbr = 1174 ;
            update cb_data_dictionary set parent = 1189 where sequence_nbr = 1175 ;
            update cb_data_dictionary set parent = 1190 where sequence_nbr = 1176 ;
            update cb_data_dictionary set parent = 1190 where sequence_nbr = 1177 ;
            update cb_data_dictionary set parent = 1190 where sequence_nbr = 1178 ;
            update cb_data_dictionary set parent = 1190 where sequence_nbr = 1179 ;
            update cb_data_dictionary set parent = 1191 where sequence_nbr = 1180 ;
            update cb_data_dictionary set parent = 1191 where sequence_nbr = 1181 ;
            update cb_data_dictionary set parent = 1191 where sequence_nbr = 1182 ;
            update cb_data_dictionary set parent = 1191 where sequence_nbr = 1183 ;
            update cb_data_dictionary set parent = 1191 where sequence_nbr = 1184 ;
            update cb_data_dictionary set parent = 1191 where sequence_nbr = 1185 ;
            update cb_data_dictionary set parent = 1191 where sequence_nbr = 1186 ;
            update cb_data_dictionary set parent = 1191 where sequence_nbr = 1187 ;
            update cb_data_dictionary set parent = 1191 where sequence_nbr = 1188 ;
        </sql>
    </changeSet>

    <changeSet author="chenzhao" id="2021-09-13-chenzhao">
        <preConditions onFail="MARK_RAN">

            <tableExists tableName="cb_data_dictionary"/>
            <primaryKeyExists primaryKeyName="sequence_nbr" tableName="cb_data_dictionary"/>

        </preConditions>
        <comment>add data cb_data_dictionary</comment>
        <sql>
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES (1192,'1192',' 8T
            吊车','JYZBLX','救援装备类型');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES (1193,'1193',' 16T
            吊车','JYZBLX','救援装备类型');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES (1194,'1194',' 50T
            吊车','JYZBLX','救援装备类型');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES (1195,'1195',' 70T
            吊车','JYZBLX','救援装备类型');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES (1196,'1196',' 100T
            吊车','JYZBLX','救援装备类型');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES (1197,'1197',' 130T
            吊车','JYZBLX','救援装备类型');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES (1198,'1198',' 180T
            吊车','JYZBLX','救援装备类型');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES (1199,'1199',' 260T
            吊车','JYZBLX','救援装备类型');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES (1200,'1200',' 300T
            吊车','JYZBLX','救援装备类型');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES (1201,'1201',' 350T
            吊车','JYZBLX','救援装备类型');
        </sql>
    </changeSet>

    <changeSet author="chenzhao" id="2021-09-13-chenzhao-2">
        <preConditions onFail="MARK_RAN">

            <tableExists tableName="cb_data_dictionary"/>
            <primaryKeyExists primaryKeyName="sequence_nbr" tableName="cb_data_dictionary"/>
        </preConditions>
        <comment>add data cb_data_dictionary</comment>
        <sql>
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1202,'1202','副支队长','XFRYGW','消防人员岗位');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1203,'1203','党支部副书记','XFRYGW','消防人员岗位');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1204,'1204','大队长','XFRYGW','消防人员岗位');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1205,'1205','支队长助理','XFRYGW','消防人员岗位');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1206,'1206','班组长','XFRYGW','消防人员岗位');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES (1207,'1207','中队长
            ','XFRYGW','消防人员岗位');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES (1208,'1208','代理大队长
            ','XFRYGW','消防人员岗位');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES (1209,'1209','代理副大队长
            ','XFRYGW','消防人员岗位');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1210,'1210','指挥员','XFRYGW','消防人员岗位');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES (1211,'1211','副中队长
            ','XFRYGW','消防人员岗位');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1212,'1212','内勤','XFRYGW','消防人员岗位');
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,type_desc) VALUES
            (1213,'1213','支队长','XFRYGW','消防人员岗位');
        </sql>
    </changeSet>

    <changeSet author="chenzhao" id="2021-09-23-chenzhao">
        <preConditions onFail="MARK_RAN">
            <not>
            <tableExists tableName="cb_data_dictionary"/>
            </not>
            <primaryKeyExists primaryKeyName="sequence_nbr" tableName="cb_data_dictionary"/>
        </preConditions>
        <comment>add data cb_data_dictionary</comment>
        <sql>
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,parent) VALUES (1237,'1237','河流','TRSYLX',389);
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,parent) VALUES (1238,'1238','湖泊','TRSYLX',389);
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,parent) VALUES (1239,'1239','海洋','TRSYLX',389);
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,parent) VALUES (1240,'1240','水库','TRSYLX',389);
            INSERT INTO cb_data_dictionary (sequence_nbr,code,name,type,parent) VALUES (1241,'1241','其他','TRSYLX',389);
        </sql>
    </changeSet>

	<changeSet author="kongfm" id="2021-09-15-kongfm-1">
		<preConditions onFail="MARK_RAN">
			<tableExists tableName="cb_org_usr"/>
		</preConditions>
		<comment>BUG 2889 机场单位主键不为long 导致一系列报错，修改主键类型</comment>
		<sql>
			alter table cb_org_usr MODIFY sequence_nbr BIGINT(32);
		</sql>
	</changeSet>

	<changeSet author="kongfm" id="2021-09-15-kongfm-2">
		<preConditions onFail="MARK_RAN">
			<tableExists tableName="cb_dynamic_form_column" />
			<not>
				<primaryKeyExists primaryKeyName="sequence_nbr" tableName="cb_dynamic_form_column"/>
			</not>
		</preConditions>
		<comment>优化项958 值班区域字段添加</comment>
		<sql>
			INSERT INTO cb_dynamic_form_column (sequence_nbr, field_code, field_name, field_type, group_id, query_strategy, not_null, block, group_code, rec_date, is_delete) VALUES ('132828674811007', 'dutyArea', '值班区域', 'input', '132828674811', 'like', b'0', b'0', 'dutyPerson',  '2021-09-14 02:29:15',  b'0');
			INSERT INTO cb_dynamic_form_column (sequence_nbr, field_code, field_name, field_type, group_id, query_strategy, not_null, block, group_code, rec_date, is_delete) VALUES ('132828674811008', 'dutyAreaId', '值班区域Id', 'input', '132828674811', 'eq', b'1', b'0', 'dutyPerson', '2021-09-14 02:29:15', b'0');
			INSERT INTO cb_dynamic_form_column (sequence_nbr, field_code, field_name, field_type, group_id, query_strategy, not_null, block, group_code, rec_date, is_delete) VALUES ('132828674810009', 'dutyArea', '值班区域', 'input', '132828674810', 'like', b'0', b'0', 'dutyCar',  '2021-09-14 02:29:15', b'0');
			INSERT INTO cb_dynamic_form_column (sequence_nbr, field_code, field_name, field_type, group_id, query_strategy, not_null, block, group_code, rec_date, is_delete) VALUES ('132828674810010', 'dutyAreaId', '值班区域Id', 'input', '132828674810', 'eq', b'1', b'0', 'dutyCar',  '2021-09-14 02:29:15', b'0');
		</sql>
	</changeSet>



	<changeSet author="tw" id="2021-09-17-001">
		<preConditions onFail="MARK_RAN">

			<tableExists tableName="cb_data_dictionary" />
			<primaryKeyExists primaryKeyName="sequence_nbr" tableName="cb_data_dictionary"/>
		</preConditions>
		<comment>add data cb_data_dictionary</comment>
		<sql>
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1214, '1214', '120急救', 'JQLB', NULL, NULL, NULL, NULL, NULL, b '0', 6 );
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1215, '1215', '婴幼儿', 'NLD', NULL, NULL, NULL, NULL, NULL, b '0', 1 );
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1216, '1216', '少儿', 'NLD', NULL, NULL, NULL, NULL, NULL, b '0', 1 );
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1217, '1217', '青少年', 'NLD', NULL, NULL, NULL, NULL, NULL, b '0', 1 );
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1218, '1218', '青年', 'NLD', NULL, NULL, NULL, NULL, NULL, b '0', 1 );
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1219, '1219', '中年', 'NLD', NULL, NULL, NULL, NULL, NULL, b '0', 1 );
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1220, '1220', '老年', 'NLD', NULL, NULL, NULL, NULL, NULL, b '0', 1 );
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1222, '1222', '呼吸心跳停止', 'HZXZ', NULL, NULL, NULL, NULL, NULL, b '0', 1 );
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1223, '1223', '晕倒', 'HZXZ', NULL, NULL, NULL, NULL, NULL, b '0', 2 );
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1224, '1224', '外伤', 'HZXZ', NULL, NULL, NULL, NULL, NULL, b '0', 3 );
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1225, '1225', '骨折', 'HZXZ', NULL, NULL, NULL, NULL, NULL, b '0', 4 );
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1226, '1226', '死亡', 'HZXZ', NULL, NULL, NULL, NULL, NULL, b '0', 5 );
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1227, '1227', '烫伤', 'HZXZ', NULL, NULL, NULL, NULL, NULL, b '0', 6 );
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1228, '1228', '上呼吸道被异物卡住', 'HZXZ', NULL, NULL, NULL, NULL, NULL, b '0', 7 );
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1229, '1229', '出血', 'HZXZ', NULL, NULL, NULL, NULL, NULL, b '0', 8 );
			INSERT INTO `cb_data_dictionary` ( `sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num` )
			VALUES
			( 1230, '1230', '抽搐(癫痫)', 'HZXZ', NULL, NULL, NULL, NULL, NULL, b '0', 9 );
		</sql>
	</changeSet>


	<changeSet author="tw" id="2021-09-17-002">
		<preConditions onFail="MARK_RAN">
			<not>
				<columnExists tableName="jc_alert_form" columnName="hide"/>
			</not>
		</preConditions>
		<comment>jc_alert_form add column</comment>
		<sql>
			alter table `jc_alert_form` add column `hide` bit(1) NULL DEFAULT b'0' COMMENT '隐藏';
		</sql>
	</changeSet>



	<changeSet author="tw" id="2021-09-17-003">
		<preConditions onFail="MARK_RAN">

			<tableExists tableName="jc_alert_form" />
			<primaryKeyExists primaryKeyName="sequence_nbr" tableName="jc_alert_form"/>
		</preConditions>
		<comment>add data cb_data_dictionary</comment>
		<sql>
			INSERT INTO `jc_alert_form`(`sequence_nbr`, `alert_type_code`, `field_value_code`, `field_name`, `field_code`, `field_type`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `block`, `sort_num`, `url`, `hide`) VALUES (131, '229', NULL, '重点部位', 'keySiteExcle', 'select', NULL, NULL, NULL, b'0', b'0', 0, '', b'0');
			INSERT INTO `jc_alert_form`(`sequence_nbr`, `alert_type_code`, `field_value_code`, `field_name`, `field_code`, `field_type`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `block`, `sort_num`, `url`, `hide`) VALUES (132, '229', NULL, '楼层经度', 'floorLongitude', 'input', NULL, NULL, NULL, b'0', b'0', 2, NULL, b'1');
			INSERT INTO `jc_alert_form`(`sequence_nbr`, `alert_type_code`, `field_value_code`, `field_name`, `field_code`, `field_type`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `block`, `sort_num`, `url`, `hide`) VALUES (133, '229', NULL, '楼层纬度', 'floorLatitude', 'input', NULL, NULL, NULL, b'0', b'0', 3, NULL, b'1');
			INSERT INTO `jc_alert_form`(`sequence_nbr`, `alert_type_code`, `field_value_code`, `field_name`, `field_code`, `field_type`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `block`, `sort_num`, `url`, `hide`) VALUES (134, '1214', 'HZXZ', '患者现状', 'patientStatus', 'CheckBoxSelect', NULL, NULL, NULL, b'0', b'1', 1, NULL, b'0');
			INSERT INTO `jc_alert_form`(`sequence_nbr`, `alert_type_code`, `field_value_code`, `field_name`, `field_code`, `field_type`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `block`, `sort_num`, `url`, `hide`) VALUES (135, '1214', 'XB', '性别', 'gender', 'select', NULL, NULL, NULL, b'0', b'0', 2, NULL, b'0');
			INSERT INTO `jc_alert_form`(`sequence_nbr`, `alert_type_code`, `field_value_code`, `field_name`, `field_code`, `field_type`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `block`, `sort_num`, `url`, `hide`) VALUES (136, '1214', 'NLD', '年龄段(岁)', 'ageGroup', 'select', NULL, NULL, NULL, b'0', b'0', 3, NULL, b'0');
			INSERT INTO `jc_alert_form`(`sequence_nbr`, `alert_type_code`, `field_value_code`, `field_name`, `field_code`, `field_type`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `block`, `sort_num`, `url`, `hide`) VALUES (137, '1214', NULL, '患者现状说明', 'presentSituation', 'textarea', NULL, NULL, NULL, b'0', b'1', 4, NULL, b'0');
			INSERT INTO `jc_alert_form`(`sequence_nbr`, `alert_type_code`, `field_value_code`, `field_name`, `field_code`, `field_type`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `block`, `sort_num`, `url`, `hide`) VALUES (138, '1214', NULL, '情况说明', 'situation', 'textarea', NULL, NULL, NULL, b'0', b'1', 5, NULL, b'0');
			INSERT INTO `jc_alert_form`(`sequence_nbr`, `alert_type_code`, `field_value_code`, `field_name`, `field_code`, `field_type`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `block`, `sort_num`, `url`, `hide`) VALUES (139, '1214', NULL, '备注', 'remarks', 'textarea', NULL, NULL, NULL, b'0', b'1', 6, NULL, b'0');

		</sql>
	</changeSet>

	<changeSet author="tw" id="2021-09-17-004">
		<preConditions onFail="MARK_RAN">

			<tableExists tableName="jc_alert_form_type" />
			<primaryKeyExists primaryKeyName="sequence_nbr" tableName="jc_alert_form_type"/>
		</preConditions>
		<comment>add data cb_data_dictionary</comment>
		<sql>
			INSERT INTO `jc_alert_form_type`(`sequence_nbr`, `alert_type_code`, `alert_type_name`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`) VALUES (10, '1214', '120急救', NULL, NULL, NULL, b'0');

		</sql>
	</changeSet>



	<changeSet author="tw" id="2021-09-17-005">
		<preConditions onFail="MARK_RAN">
			<not>
				<columnExists tableName="cb_key_site" columnName="latitude"/>
			</not>
		</preConditions>
		<comment>cb_key_site add column</comment>
		<sql>
			alter table `cb_key_site` add column `latitude` double(18, 14) NULL DEFAULT NULL ;
		</sql>
	</changeSet>
	<changeSet author="tw" id="2021-09-17-006">
		<preConditions onFail="MARK_RAN">
			<not>
				<columnExists tableName="cb_key_site" columnName="longitude"/>
			</not>
		</preConditions>
		<comment>cb_key_site add column</comment>
		<sql>
			alter table `cb_key_site` add column `longitude` double(18, 14) NULL DEFAULT NULL ;
		</sql>
	</changeSet>

	<changeSet author="tw" id="2021-09-17-007">
		<preConditions onFail="MARK_RAN">
			<not>
				<columnExists tableName="jc_alert_form_value" columnName="hide"/>
			</not>
		</preConditions>
		<comment>jc_alert_form_value add column</comment>
		<sql>
			alter table `jc_alert_form_value` add column `hide` bit(1) NULL DEFAULT b'0' COMMENT '隐藏';
		</sql>
	</changeSet>

	<changeSet author="ltw" id="2021-09-17-ltw-1">
		<preConditions onFail="MARK_RAN">
			<not>
				<tableExists tableName="jc_airport_stand"/>
			</not>
		</preConditions>
		<comment>create table jc_airport_stand</comment>
		<sql>
			CREATE TABLE `jc_airport_stand` (
			`sequence_nbr` bigint(19) NOT NULL COMMENT 'id',
			`stand_code` varchar(30) DEFAULT NULL COMMENT '机位号',
			`coordinate_x` varchar(30) DEFAULT NULL COMMENT '坐标X',
			`coordinate_y` varchar(30) NOT NULL COMMENT '坐标Y',
			`longitude` varchar(50) DEFAULT NULL COMMENT '经度',
			`latitude` varchar(30) DEFAULT NULL COMMENT '纬度',
			`update_time` datetime DEFAULT NULL COMMENT '更新时间',
			`rec_user_name` varchar(20) DEFAULT NULL COMMENT '操作人名称',
			`rec_user_id` varchar(19) DEFAULT NULL COMMENT '操作人员',
			`rec_date` datetime DEFAULT NULL COMMENT '创建时间',
			`is_delete` bit(1) DEFAULT b'0' COMMENT '是否删除',
			PRIMARY KEY (`sequence_nbr`) USING BTREE
			) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='机场机位旋转角度';
		</sql>
	</changeSet>

	<changeSet author="ltw" id="2021-09-17-ltw-2">
		<preConditions onFail="MARK_RAN">
			<tableExists tableName="jc_airport_stand" />
			<primaryKeyExists primaryKeyName="sequence_nbr" tableName="jc_airport_stand"/>
		</preConditions>
		<comment>add data jc_airport_stand</comment>
		<sql>
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(1, '101', '40965.809267', '135142.201791', '108.759608', '34.445599', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(2, '102', '40986.744088', '135087.512154', '108.759009', '34.445417', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(3, '103', '40979.436181', '135035.658797', '108.758635', '34.44506', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(4, '104', '40979.812127', '134989.889541', '108.758257', '34.444791', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(5, '105', '40974.036546', '134944.985349', '108.75793', '34.444486', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(6, '106', '40974.747582', '134894.168919', '108.757508', '34.444189', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(7, '107', '40983.950663', '134823.469694', '108.756861', '34.443833', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(8, '108', '40988.208275', '134746.201368', '108.756197', '34.443404', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(9, '109', '40989.54867', '134679.183029', '108.755637', '34.443016', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(10, '110', '40995.932526', '134621.013262', '108.755114', '34.442714', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(11, '111', '40998.580672', '134562.433011', '108.754614', '34.442385', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(12, '112', '40995.142679', '134503.932135', '108.754158', '34.442015', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(13, '113', '40988.903636', '134447.343935', '108.753739', '34.441637', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(14, '114', '40985.635094', '134389.823007', '108.75329', '34.441274', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(15, '115', '40983.636221', '134324.653551', '108.752769', '34.440874', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(16, '116', '40983.291895', '134241.046615', '108.752086', '34.440377', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(17, '117', '40983.149667', '134166.112131', '108.751472', '34.439931', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(18, '118', '41153.26154', '134147.376075', '108.750099', '34.440976', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(19, '119', '41153.37107', '134205.325019', '108.750574', '34.44132', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(20, '120', '41153.48094', '134263.273861', '108.751049', '34.441664', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(21, '121', '41153.591241', '134321.222552', '108.751524', '34.442008', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(22, '122', '41153.703819', '134380.170267', '108.752007', '34.442359', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(23, '123', '41153.814907', '134438.118688', '108.752482', '34.442703', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(24, '124', '41153.926352', '134496.066996', '108.752957', '34.443047', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(25, '125', '41154.206285', '134640.715857', '108.754142', '34.443906', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(26, '126', '41154.321447', '134699.84864', '108.754626', '34.444257', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(27, '127', '41154.438585', '134759.789981', '108.755118', '34.444614', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(28, '128', '41154.558058', '134820.733179', '108.755617', '34.444976', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(29, '129', '41162.32458', '134958.96986', '108.756696', '34.445848', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(30, '130', '41162.404818', '134999.432935', '108.757028', '34.446088', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(31, '131', '41162.485269', '135039.895922', '108.757359', '34.446328', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(32, '132', '41162.565855', '135080.358817', '108.757691', '34.446569', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(33, '133', '41162.646664', '135120.821697', '108.758022', '34.446809', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(34, '134', '41162.922493', '135258.235589', '108.759148', '34.447625', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(35, '135', '41163.011164', '135302.194898', '108.759509', '34.447886', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(36, '136', '41163.100101', '135346.154167', '108.759869', '34.448148', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(37, '137', '41163.189263', '135390.113359', '108.760229', '34.448409', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(38, '138', '41163.392728', '135490.020302', '108.761048', '34.449002', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(39, '139', '41163.482625', '135533.979243', '108.761408', '34.449263', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(40, '140', '41163.572704', '135577.93807', '108.761768', '34.449524', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(41, '141', '41163.66305', '135621.896857', '108.762128', '34.449785', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(42, '142', '41163.75362', '135665.855567', '108.762489', '34.450047', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(43, '143', '41163.844407', '135709.814213', '108.762849', '34.450308', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(44, '144', '41148.647328', '135849.392984', '108.764104', '34.451032', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(45, '145', '41159.363136', '135957.014489', '108.76491', '34.451742', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(46, '147', '41156.025022', '136080.420466', '108.765947', '34.452451', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(47, '148', '41156.164499', '136146.357325', '108.766488', '34.452843', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(48, '201', '41157.588722', '136298.710039', '108.767728', '34.453755', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(49, '202', '41157.721273', '136360.650189', '108.768236', '34.454123', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(50, '203', '41157.854252', '136422.590158', '108.768744', '34.454491', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(51, '204', '41157.996236', '136488.482605', '108.769284', '34.454882', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(52, '205', '41158.125828', '136548.424249', '108.769775', '34.455239', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(53, '206', '41158.255829', '136608.365722', '108.770266', '34.455595', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(54, '207', '41157.871568', '136661.314837', '108.770703', '34.455906', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(55, '208', '41158.181798', '136803.174984', '108.771866', '34.456749', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(56, '209', '41158.275119', '136845.633105', '108.772214', '34.457001', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(57, '210', '41158.368633', '136888.091201', '108.772562', '34.457253', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(58, '211', '41158.462373', '136930.549179', '108.77291', '34.457505', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(59, '212', '41158.589519', '136987.991259', '108.773381', '34.457846', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(60, '213', '41158.68374', '137030.449056', '108.773728', '34.458099', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(61, '214', '41158.778125', '137072.906803', '108.774076', '34.458351', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(62, '215', '41158.872791', '137115.36448', '108.774424', '34.458603', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(63, '216', '41017.997561', '137115.312059', '108.775433', '34.457646', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(64, '217', '41017.902734', '137072.854123', '108.775085', '34.457394', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(65, '218', '41017.80816', '137030.396093', '108.774737', '34.457141', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(66, '219', '41017.71378', '136987.938038', '108.774389', '34.456889', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(67, '220', '41017.586397', '136930.495592', '108.773918', '34.456548', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(68, '221', '41017.492498', '136888.037297', '108.77357', '34.456296', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(69, '222', '41017.398778', '136845.578965', '108.773222', '34.456043', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(70, '223', '41017.30531', '136803.120597', '108.772874', '34.455791', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(71, '224', '41016.994524', '136661.25957', '108.771712', '34.454948', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(72, '225', '41016.901938', '136618.800867', '108.771364', '34.454696', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(73, '301', '40185.653053', '134601.800252', '108.760759', '34.437097', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(74, '302', '40127.698072', '134601.777949', '108.761174', '34.436703', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(75, '303', '40055.753806', '134601.750828', '108.761689', '34.436214', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(76, '304', '39997.798799', '134601.829054', '108.762104', '34.435821', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(77, '305', '39921.478341', '134588.528231', '108.762542', '34.435224', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(78, '306', '39922.269929', '134516.835039', '108.761947', '34.434804', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(79, '307', '39932.694222', '134445.938054', '108.761291', '34.434455', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(80, '308', '39993.465494', '134430.909005', '108.760732', '34.434779', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(81, '309', '40051.42105', '134430.930883', '108.760318', '34.435172', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(82, '310', '40123.365686', '134430.958528', '108.759803', '34.435661', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(83, '311', '40176.304903', '134425.580148', '108.759379', '34.435989', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(84, '312', '40177.022028', '134280.066605', '108.75818', '34.435131', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(85, '313', '40123.065953', '134276.05152', '108.758533', '34.434741', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(86, '314', '40055.117929', '134276.024907', '108.75902', '34.434279', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(87, '315', '39996.162894', '134276.002225', '108.759442', '34.433879', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(88, '316', '39929.037303', '134257.812715', '108.759773', '34.433315', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(89, '317', '39921.635974', '134191.106077', '108.759279', '34.43287', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(90, '318', '39932.062993', '134120.208299', '108.758622', '34.43252', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(91, '319', '39992.835498', '134105.180064', '108.758063', '34.432844', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(92, '320', '40050.791545', '134105.202749', '108.757649', '34.433238', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(93, '321', '40122.736856', '134105.231483', '108.757134', '34.433727', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(94, '322', '40184.689628', '134105.25665', '108.75669', '34.434147', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(95, '324', '39901.419234', '133934.265249', '108.757315', '34.43121', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(96, '325', '39901.338716', '133891.799784', '108.756967', '34.430958', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(97, '326', '39901.258419', '133849.334239', '108.756619', '34.430706', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(98, '327', '39901.077828', '133753.411869', '108.755834', '34.430136', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(99, '328', '39900.998235', '133710.946148', '108.755486', '34.429884', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(100, '329', '39900.918838', '133668.480285', '108.755138', '34.429631', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(101, '330', '39900.839622', '133626.014384', '108.75479', '34.429379', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(102, '331', '39898.991625', '133559.568134', '108.754258', '34.428973', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(103, '332', '39898.891733', '133505.611193', '108.753816', '34.428652', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(104, '333', '40017.304333', '133505.660033', '108.752968', '34.429457', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(105, '334', '40017.404025', '133559.616693', '108.75341', '34.429777', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(106, '335', '40017.482771', '133602.082448', '108.753758', '34.43003', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(107, '336', '40017.579369', '133654.040487', '108.754184', '34.430338', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(108, '337', '40017.658531', '133696.505938', '108.754532', '34.43059', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(109, '338', '40017.759427', '133750.462148', '108.754974', '34.430911', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(110, '339', '40017.945305', '133849.381802', '108.755784', '34.431498', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(111, '340', '40018.047154', '133903.337691', '108.756226', '34.431819', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(112, '341', '40018.127594', '133945.802897', '108.756574', '34.432071', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(113, '342L', '40153.517714', '133941.861206', '108.755572', '34.432967', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(114, '342R', '40153.598152', '133984.326097', '108.75592', '34.43322', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(115, '343', '40168.489445', '133888.139068', '108.755024', '34.432751', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(116, '344L', '40251.527252', '133853.725431', '108.754147', '34.433111', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(117, '344R', '40209.059431', '133853.70729', '108.754451', '34.432822', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(118, '345', '40161.077284', '133710.55438', '108.75362', '34.431648', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(119, '346', '40160.998201', '133668.089071', '108.753272', '34.431396', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(120, '347', '40160.91932', '133625.623683', '108.752924', '34.431143', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(121, '348', '40160.84069', '133583.158203', '108.752576', '34.430891', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(122, '401', '40186.197415', '134751.062661', '108.76198', '34.437985', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(123, '402', '40128.242655', '134751.040735', '108.762395', '34.437591', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(124, '403', '40057.79759', '134751.014673', '108.762899', '34.437113', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(125, '404', '39999.842592', '134750.9936', '108.763314', '34.436719', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(126, '405', '39945.868197', '134744.016938', '108.763643', '34.436311', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(127, '406', '39899.903727', '134744.000736', '108.763972', '34.435999', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(128, '425', '39919.89102', '134993.803259', '108.765879', '34.437615', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(129, '701', '40765.499568', '133906.8558', '108.750902', '34.436917', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(130, '702', '40838.441745', '133907.624599', '108.750386', '34.437416', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(131, '703', '40855.056475', '133977.148225', '108.750838', '34.437941', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(132, '704', '40843.528361', '134037.591691', '108.751417', '34.438221', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(133, '705', '40843.608408', '134080.055064', '108.751765', '34.438474', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(134, '706', '40843.688636', '134122.5184', '108.752113', '34.438726', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(135, '707', '40843.769116', '134164.981642', '108.75246', '34.438978', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(136, '708', '41009.847627', '134000.179085', '108.749918', '34.439129', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(137, '709', '41062.43108', '134000.205813', '108.749542', '34.439487', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(138, '710', '41104.897508', '134000.227578', '108.749238', '34.439775', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
			INSERT INTO `jc_airport_stand`
			(sequence_nbr, stand_code, coordinate_x, coordinate_y, longitude, latitude, update_time, rec_user_name, rec_user_id, rec_date, is_delete)
			VALUES(139, '711', '41157.480923', '134000.254869', '108.748862', '34.440132', '2021-09-17 08:02:38', NULL, NULL, '2021-09-17 08:02:57', 0);
		</sql>
	</changeSet>



	<changeSet author="tw" id="2021-09-17-020">
		<comment>update data jc_alert_form</comment>
		<sql>
			update jc_alert_form set field_name = '火灾位置',field_type='inputPoi'    where sequence_nbr = 2 ;

		</sql>
	</changeSet>

	<changeSet author="tw" id="2021-09-18-0001">
		<comment>update data jc_alert_form</comment>
		<sql>
			update jc_alert_form set url = 'data-dictionary/gwmcDataDictionary/SGXZ'    where sequence_nbr = 113 ;

		</sql>
	</changeSet>

	<changeSet author="tw" id="2021-09-18-0002">
		<preConditions onFail="MARK_RAN">

			<tableExists tableName="cb_data_dictionary" />
			<primaryKeyExists primaryKeyName="sequence_nbr" tableName="cb_data_dictionary"/>
		</preConditions>
		<comment>add data cb_data_dictionary</comment>
		<sql>
			INSERT INTO `cb_data_dictionary`(`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES (1231, '1231', '居民家中取钥匙', 'SGXZ', NULL, NULL, NULL, NULL, NULL, b'0', 1);
			INSERT INTO `cb_data_dictionary`(`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES (1232, '1232', '摘除蜂窝', 'SGXZ', NULL, NULL, NULL, NULL, NULL, b'0', 2);
			INSERT INTO `cb_data_dictionary`(`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES (1233, '1233', '关闭居民水', 'SGXZ', NULL, NULL, NULL, NULL, NULL, b'0', 3);
			INSERT INTO `cb_data_dictionary`(`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES (1234, '1234', '气阀门', 'SGXZ', NULL, NULL, NULL, NULL, NULL, b'0', 4);
			INSERT INTO `cb_data_dictionary`(`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES (1235, '1235', '锅炉事故', 'SGXZ', NULL, NULL, NULL, NULL, NULL, b'0', 5);
			INSERT INTO `cb_data_dictionary`(`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES (1236, '1236', '其它', 'SGXZ', NULL, NULL, NULL, NULL, NULL, b'0', 6);

		</sql>
	</changeSet>




	<changeSet author="tw" id="2021-09-22-0001">
		<preConditions onFail="MARK_RAN">

			<tableExists tableName="jc_alert_form" />
			<primaryKeyExists primaryKeyName="sequence_nbr" tableName="jc_alert_form"/>
		</preConditions>
		<comment>add data jc_alert_form</comment>
		<sql>
			INSERT INTO `jc_alert_form`(`sequence_nbr`, `alert_type_code`, `field_value_code`, `field_name`, `field_code`, `field_type`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `block`, `sort_num`, `url`, `hide`) VALUES (140, '238', '', '航空器类型', 'aircraft', 'TextInputpo', NULL, NULL, NULL, b'0', b'0', 1, 'aircraft/queryAircraftList', b'0');
			INSERT INTO `jc_alert_form`(`sequence_nbr`, `alert_type_code`, `field_value_code`, `field_name`, `field_code`, `field_type`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `block`, `sort_num`, `url`, `hide`) VALUES (141, '237', '', '航空器类型', 'aircraft', 'TextInputpo', NULL, NULL, NULL, b'0', b'0', 0, 'aircraft/queryAircraftList', b'0');
			INSERT INTO `jc_alert_form`(`sequence_nbr`, `alert_type_code`, `field_value_code`, `field_name`, `field_code`, `field_type`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `block`, `sort_num`, `url`, `hide`) VALUES (142, '237', NULL, '航班号', 'flightNumber', 'selectDelay', NULL, NULL, NULL, b'0', b'0', -1, 'aircraft/getAircraftNum', b'0');
		</sql>
	</changeSet>
	<changeSet author="litw" id="2021-09-22-litw-1">
		<preConditions onFail="MARK_RAN">
			<tableExists tableName="cb_fire_station"/>
		</preConditions>
		<comment>BUG 2961 微型消防站名称字段过短导致报错</comment>
		<sql>
			ALTER TABLE cb_fire_station MODIFY COLUMN name varchar(300) NULL COMMENT '微型消防站名称';
		</sql>
	</changeSet>



	<changeSet author="tw" id="2021-09-22-0002">
		<preConditions onFail="MARK_RAN">
			<tableExists tableName="cb_firefighters"/>
		</preConditions>
		<comment>增加amos账号关联字段</comment>
		<sql>
			ALTER TABLE `cb_firefighters` add amos_name varchar(255) COMMENT 'amos账户名称';
			ALTER TABLE `cb_firefighters` add amos_user_id varchar(255) COMMENT 'amos账户id';
		</sql>
	</changeSet>




	<changeSet author="tw" id="2021-09-23-0001">
		<preConditions onFail="MARK_RAN">
			<not>
				<tableExists tableName="jc_firestation_jacket"/>
			</not>
		</preConditions>
		<comment>create table jc_firestation_jacket</comment>
		<sql>
			CREATE TABLE `jc_firestation_jacket`  (
			`sequence_nbr` bigint(19) NOT NULL COMMENT 'id',
			`firefighters_id` bigint(19) NULL DEFAULT NULL COMMENT '微型消防站id',
			`equipment_detail_id` bigint(19) NULL DEFAULT NULL COMMENT '装备id',
			`amount` double(10, 0) NULL DEFAULT NULL COMMENT '装备数量',
			`unit` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '装备计量单位',
			`equipment_detail_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '装备名称',
			`equipment_type_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '装备分类名称',
			`allotment_time` date NULL DEFAULT NULL COMMENT '配发日期',
			`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
			`rec_user_name` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人名称',
			`rec_user_id` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人员',
			`rec_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
			`is_delete` bit(1) NULL DEFAULT b'0' COMMENT '是否删除',
			`stock_detail_id` bigint(19) NULL DEFAULT NULL COMMENT '装备库存明细id',
			PRIMARY KEY (`sequence_nbr`) USING BTREE
			) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消防人员配装记录' ROW_FORMAT = Dynamic;
		</sql>
	</changeSet>

<!--   <changeSet author="tw" id="2021-09-24-0001">-->
<!--        <preConditions onFail="MARK_RAN">-->
<!--            <tableExists tableName="jc_alert_called"/>-->
<!--        </preConditions>-->
<!--        <comment>警情来源系统</comment>-->
<!--        <sql>-->
<!--            ALTER TABLE `jc_alert_called` add system_source varchar(255)  COMMENT '来源系统';-->
<!--            ALTER TABLE `jc_alert_called` add system_source_code varchar(255)  COMMENT '系统来源code';-->
<!--        </sql>-->
<!--    </changeSet>-->



    <changeSet author="tw" id="2021-09-24-0002">
        <preConditions onFail="MARK_RAN">

            <tableExists tableName="cb_data_dictionary" />
            <primaryKeyExists primaryKeyName="sequence_nbr" tableName="cb_data_dictionary"/>
        </preConditions>
        <comment>add data jc_alert_form</comment>
        <sql>
            INSERT INTO `cb_data_dictionary`(`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES (1242, '1242', '融合调度系统', 'SOURCE', NULL, NULL, NULL, NULL, NULL, b'0', 1);
            INSERT INTO `cb_data_dictionary`(`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES (1243, '1243', '消防物联系统', 'SOURCE', NULL, NULL, NULL, NULL, NULL, b'0', 1);
            INSERT INTO `cb_data_dictionary`(`sequence_nbr`, `code`, `name`, `type`, `type_desc`, `parent`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `sort_num`) VALUES (1244, '1244', '119接处警系统', 'SOURCE', NULL, NULL, NULL, NULL, NULL, b'0', 1);
        </sql>
    </changeSet>


    <changeSet id="2021-09-24-02" author="cz">

        <preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_data_dictionary"/>
        </preConditions>
        <comment>删除无用数据</comment>
        <sql>
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1173 ;
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1174 ;
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1175 ;
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1176 ;
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1177 ;
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1178 ;
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1179 ;
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1180 ;
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1181 ;
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1182 ;
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1183 ;
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1184 ;
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1185 ;
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1186 ;
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1187 ;
            update cb_data_dictionary set type_desc = null where sequence_nbr = 1188 ;
        </sql>
    </changeSet>

    <changeSet id="2021-09-272" author="chenzhao">

        <preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_data_dictionary"/>
        </preConditions>
        <comment>删除无用数据</comment>
        <sql>
            update cb_data_dictionary set parent = null where sequence_nbr = 1237 ;
            update cb_data_dictionary set parent = null where sequence_nbr = 1238 ;
            update cb_data_dictionary set parent = null where sequence_nbr = 1239 ;
            update cb_data_dictionary set parent = null where sequence_nbr = 1240 ;
            update cb_data_dictionary set parent = null where sequence_nbr = 1241 ;
        </sql>
    </changeSet>


    <changeSet author="chenzhao" id="2021-09-27-cz-1">
        <preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_fire_experts"/>
        </preConditions>
        <comment>BUG 2928 表中新增两个字段用来保存详细地址值 </comment>
        <sql>
            ALTER TABLE `cb_fire_experts` add native_place_val varchar(255) COMMENT '户籍所在地详细地址';
            ALTER TABLE `cb_fire_experts` add residence_detail_val varchar(255) COMMENT '现居住地详细地址';
        </sql>
    </changeSet>
	<changeSet id="2021-10-13" author="chenhao-1">
		<preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_dynamic_form_group" />
            <primaryKeyExists primaryKeyName="sequence_nbr" tableName="cb_dynamic_form_group"/>
        </preConditions>
        <comment>add data cb_dynamic_form_group</comment>
			<sql>
				INSERT INTO cb_dynamic_form_group (`sequence_nbr`, `group_name`, `group_code`, `parent_id`, `group_config`, `org_code`, `sort`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`) VALUES ('132828674815', '值班消防', 'dutyFireFighting', '0', NULL, '10', '1', NULL, NULL, '2021-09-28 10:34:05', '\0');
			</sql>
	</changeSet>
	
	<changeSet id="2021-10-13" author="chenhao-2">
		<preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_dynamic_form_column" />
            <primaryKeyExists primaryKeyName="sequence_nbr" tableName="cb_dynamic_form_column"/>
        </preConditions>
        <comment>add data cb_dynamic_form_column</comment>
			<sql>
			INSERT INTO cb_dynamic_form_column (`sequence_nbr`, `field_code`, `field_name`, `field_type`, `group_id`, `query_strategy`, `not_null`, `block`, `group_code`, `column_config`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `remark`, `sort`, `org_code`) VALUES ('132828674812067', 'userId', '用户id', 'input', '132828674815', 'eq', '\0', '\0', 'dutyFireFighting', NULL, NULL, NULL, '2021-09-28 10:34:05', '\0', NULL, NULL, NULL);
			INSERT INTO cb_dynamic_form_column (`sequence_nbr`, `field_code`, `field_name`, `field_type`, `group_id`, `query_strategy`, `not_null`, `block`, `group_code`, `column_config`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `remark`, `sort`, `org_code`) VALUES ('132828674812068', 'userName', '用户名称', 'input', '132828674815', 'like', '\0', '\0', 'dutyFireFighting', NULL, NULL, NULL, '2021-09-28 10:34:05', '\0', NULL, NULL, NULL);
			INSERT INTO cb_dynamic_form_column (`sequence_nbr`, `field_code`, `field_name`, `field_type`, `group_id`, `query_strategy`, `not_null`, `block`, `group_code`, `column_config`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `remark`, `sort`, `org_code`) VALUES ('132828674812071', 'postType', '岗位id', 'input', '132828674815', 'eq', '\0', '\0', 'dutyFireFighting', NULL, NULL, NULL, '2021-09-28 10:34:05', '\0', NULL, NULL, NULL);
			INSERT INTO cb_dynamic_form_column (`sequence_nbr`, `field_code`, `field_name`, `field_type`, `group_id`, `query_strategy`, `not_null`, `block`, `group_code`, `column_config`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `remark`, `sort`, `org_code`) VALUES ('132828674812072', 'postTypeName', '岗位名称', 'input', '132828674815', 'like', '\0', '\0', 'dutyFireFighting', NULL, NULL, NULL, '2021-09-28 10:34:05', '\0', NULL, NULL, NULL);
			INSERT INTO cb_dynamic_form_column (`sequence_nbr`, `field_code`, `field_name`, `field_type`, `group_id`, `query_strategy`, `not_null`, `block`, `group_code`, `column_config`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `remark`, `sort`, `org_code`) VALUES ('132828674812073', 'fireFighting', '微型消防站', 'input', '132828674815', 'like', '\0', '\0', 'dutyFireFighting', NULL, NULL, NULL, '2021-09-28 10:34:05', '\0', NULL, NULL, NULL);
			INSERT INTO cb_dynamic_form_column (`sequence_nbr`, `field_code`, `field_name`, `field_type`, `group_id`, `query_strategy`, `not_null`, `block`, `group_code`, `column_config`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `remark`, `sort`, `org_code`) VALUES ('132828674812074', 'fireFightingId', '微型消防站Id', 'input', '132828674815', 'eq', '\0', '\0', 'dutyFireFighting', NULL, NULL, NULL, '2021-09-28 10:34:05', '\0', NULL, NULL, NULL);
			INSERT INTO cb_dynamic_form_column (`sequence_nbr`, `field_code`, `field_name`, `field_type`, `group_id`, `query_strategy`, `not_null`, `block`, `group_code`, `column_config`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `remark`, `sort`, `org_code`) VALUES ('132828674812075', 'teamId', '单位名称id', 'input', '132828674815', 'eq', '\0', '\0', 'dutyFireFighting', NULL, NULL, NULL, '2021-09-28 10:34:05', '\0', NULL, NULL, NULL);
			INSERT INTO cb_dynamic_form_column (`sequence_nbr`, `field_code`, `field_name`, `field_type`, `group_id`, `query_strategy`, `not_null`, `block`, `group_code`, `column_config`, `rec_user_name`, `rec_user_id`, `rec_date`, `is_delete`, `remark`, `sort`, `org_code`) VALUES ('132828674812076', 'teamName', '单位名称', 'input', '132828674815', 'like', '\0', '\0', 'dutyFireFighting', NULL, NULL, NULL, '2021-09-28 10:34:05', '\0', NULL, NULL, NULL);
			</sql>
	</changeSet>


    <changeSet id="2021-10-09" author="tw01">

        <preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_data_dictionary"/>
        </preConditions>
        <comment>修改排序</comment>
        <sql>
            update cb_data_dictionary set sort_num = 1 where sequence_nbr = 1192 ;
            update cb_data_dictionary set sort_num = 2 where sequence_nbr = 847 ;
            update cb_data_dictionary set sort_num = 3 where sequence_nbr = 1193 ;
            update cb_data_dictionary set sort_num = 4 where sequence_nbr = 848 ;
            update cb_data_dictionary set sort_num = 5 where sequence_nbr = 849 ;
            update cb_data_dictionary set sort_num = 6 where sequence_nbr = 1194 ;
            update cb_data_dictionary set sort_num = 7 where sequence_nbr = 850 ;
            update cb_data_dictionary set sort_num = 8 where sequence_nbr = 1195 ;
            update cb_data_dictionary set sort_num = 9 where sequence_nbr = 851 ;
            update cb_data_dictionary set sort_num = 10 where sequence_nbr = 1196 ;
            update cb_data_dictionary set sort_num = 11 where sequence_nbr = 1197 ;
            update cb_data_dictionary set sort_num = 12 where sequence_nbr = 1198 ;
            update cb_data_dictionary set sort_num = 13 where sequence_nbr = 1199 ;
            update cb_data_dictionary set sort_num = 14 where sequence_nbr = 1200 ;
            update cb_data_dictionary set sort_num = 15 where sequence_nbr = 1201 ;
        </sql>
    </changeSet>


    <changeSet author="tw" id="2021-10-12-001">

        <preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_data_dictionary"/>
        </preConditions>
        <comment>删除无用数据</comment>
        <sql>
            DELETE from cb_data_dictionary where cb_data_dictionary.sequence_nbr  in ( 1,2,3,4,5,6)
        </sql>
    </changeSet>

    <changeSet author="tw" id="2021-10-12-002">

        <preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_data_dictionary"/>
        </preConditions>
        <comment>修改数据</comment>
        <sql>
            UPDATE cb_data_dictionary set type ='GWMC'  where type='XFRYGW'
        </sql>
    </changeSet>


    <changeSet author="tw" id="2021-10-12-003">

        <preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_data_dictionary"/>
        </preConditions>
        <comment>修改数据</comment>
        <sql>
            UPDATE cb_data_dictionary set name ='财务军需类'  where sequence_nbr=147
        </sql>
    </changeSet>

    <changeSet author="ltw" id="2021-10-12-ltw-1">
        <preConditions onFail="MARK_RAN">
            <not>
                <tableExists tableName="cb_org_usr_safe_report"/>
            </not>
        </preConditions>
        <comment>create table cb_org_usr_safe_report</comment>
        <sql>
            CREATE TABLE cb_org_usr_safe_report (
            `sequence_nbr` bigint(30) NOT NULL COMMENT '唯一主键',
            `name` varchar(100) NOT NULL COMMENT '报告名称',
            `type` varchar(30) DEFAULT NULL COMMENT '报告类型',
            `type_code` varchar(30) DEFAULT NULL COMMENT '报告类型code',
            `take_effect_year` datetime DEFAULT NULL  COMMENT '生效年份',
            `signed_date` datetime DEFAULT NULL COMMENT '签订时间',
            `org_code` varchar(30) DEFAULT NULL COMMENT '机构代码用于权限过滤',
            `company` varchar(30) DEFAULT NULL COMMENT '所属机场单位名称',
            `attachment` varchar(500) DEFAULT NULL COMMENT '报告附件',
            `company_id` bigint(20) DEFAULT NULL COMMENT '所属机场单位id',
            `company_type` varchar(10) DEFAULT NULL COMMENT '单位类型（1机场单位，0机场部门）',
            `duty_person` varchar(30) NOT NULL COMMENT '责任人',
            `duty_person_id` bigint(20) NOT NULL COMMENT '责任人id',
            `rec_user_id` bigint(20) NOT NULL COMMENT '更新人id',
            `rec_user_name` varchar(30) NOT NULL COMMENT '更新人名称',
            `rec_date` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
            `is_delete` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除（0：未删除，1：已删除）',
            PRIMARY KEY (`sequence_nbr`) USING BTREE
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='机场单位消防安全报告';
        </sql>
    </changeSet>

    <changeSet author="ltw" id="2021-10-12-2">
        <preConditions onFail="MARK_RAN">

            <tableExists tableName="cb_data_dictionary" />
            <primaryKeyExists primaryKeyName="sequence_nbr" tableName="cb_data_dictionary"/>
        </preConditions>
        <comment>add data cb_data_dictionary</comment>
        <sql>
            INSERT INTO cb_data_dictionary (sequence_nbr, code, name, `type`, type_desc, parent, rec_user_name, rec_user_id, rec_date, is_delete, sort_num) VALUES(1322, '1322', '消防安全责任人报告书', 'XFAQBG', NULL, NULL, NULL, NULL, NULL, 0, 1);
            INSERT INTO cb_data_dictionary (sequence_nbr, code, name, `type`, type_desc, parent, rec_user_name, rec_user_id, rec_date, is_delete, sort_num) VALUES(1323, '1323', '消防安全管理人报告书', 'XFAQBG', NULL, NULL, NULL, NULL, NULL, 0, 1);
            INSERT INTO cb_data_dictionary (sequence_nbr, code, name, `type`, type_desc, parent, rec_user_name, rec_user_id, rec_date, is_delete, sort_num) VALUES(1324, '1324', '消防安全管理规章制度', 'XFAQBG', NULL, NULL, NULL, NULL, NULL, 0, 1);
            INSERT INTO cb_data_dictionary (sequence_nbr, code, name, `type`, type_desc, parent, rec_user_name, rec_user_id, rec_date, is_delete, sort_num) VALUES(1325, '1325', '其他', 'XFAQBG', NULL, NULL, NULL, NULL, NULL, 0, 1);

        </sql>
    </changeSet>

    <changeSet author="chenzhao" id="2021-10-13">
        <preConditions onFail="MARK_RAN">
            <viewExists viewName="alert_today"/>
        </preConditions>
        <dropView viewName="alert_today"/>
        <comment>delete alert_today</comment>
    </changeSet>

    <changeSet author="chenzhao" id="2021-10-13-2">
        <createView  viewName="alert_today" replaceIfExists="true" >
            select '今日接警' AS `title`,count(`jc_alert_called`.`alert_status`) AS `alert_count` from `jc_alert_called` where (to_days(`jc_alert_called`.`call_time`) = to_days(now())) union all
            <![CDATA[select '已处警' AS `title`,count(`jc_alert_called`.`alert_status`) AS `alert_count` from `jc_alert_called`,jc_power_transfer where ((to_days(`jc_alert_called`.`call_time`) = to_days(now()) and jc_power_transfer.alert_called_id = jc_alert_called.sequence_nbr  ) and (`jc_alert_called`.`alert_stage` <> '警情接报')) union all]]>            select '未结案' AS `title`,count(`jc_alert_called`.`alert_status`) AS `alert_count` from `jc_alert_called` where (`jc_alert_called`.`alert_status` = 0) union all
            select '已结案' AS `title`,count(`jc_alert_called`.`alert_status`) AS `alert_count` from `jc_alert_called` where ((year(`jc_alert_called`.`call_time`) = year(now())) and (`jc_alert_called`.`alert_status` = 1));
        </createView>
    </changeSet>




    <changeSet author="tw" id="2021-10-13-tw-01">
        <preConditions onFail="MARK_RAN">
            <not>
                <tableExists tableName="jc_user_car"/>
            </not>
        </preConditions>
        <comment>create table jc_user_car</comment>
        <sql>
            CREATE TABLE `jc_user_car`  (
            `sequence_nbr` bigint(20) NOT NULL COMMENT '物理主键',
            `amos_user_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '平台账号',
            `amos_user_id` bigint(20) NULL DEFAULT NULL COMMENT '平台账号id',
            `car_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车牌号',
            `car_id` bigint(20) NULL DEFAULT NULL COMMENT '车辆id',
            `rec_user_name` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人名称',
            `rec_user_id` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人员',
            `rec_date` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
            `is_delete` bit(1) NULL DEFAULT b'0' COMMENT '是否删除',
            PRIMARY KEY (`sequence_nbr`) USING BTREE
            ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
        </sql>
    </changeSet>

    <changeSet id="2021-10-14-1" author="chenzhao">
        <preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_data_dictionary" />
            <primaryKeyExists  primaryKeyName="sequence_nbr" tableName="cb_data_dictionary"/>
        </preConditions>
        <comment>add data cb_data_dictionary</comment>
        <sql>
            INSERT INTO cb_data_dictionary (sequence_nbr, code, name, `type`) VALUES(1326, '1326', '消防物联系统', 'LYXT');
            INSERT INTO cb_data_dictionary (sequence_nbr, code, name, `type`) VALUES(1327, '1327', '接处警手动上报', 'LYXT');
            INSERT INTO cb_data_dictionary (sequence_nbr, code, name, `type`) VALUES(1328, '1328', '融合终端系统', 'LYXT');
        </sql>
    </changeSet>

    <changeSet id="2021-10-14" author="cz">

        <preConditions onFail="MARK_RAN">
            <tableExists tableName="cb_org_usr_safe_report"/>
        </preConditions>
        <comment>删除责任人非空约束</comment>
        <sql>
            ALTER TABLE cb_org_usr_safe_report MODIFY COLUMN duty_person VARCHAR(30);
            ALTER TABLE cb_org_usr_safe_report MODIFY COLUMN duty_person_id bigint(20);
        </sql>
    </changeSet>

        </databaseChangeLog>
