ALTER TABLE  `drawing`
    ADD COLUMN `nature` varchar(10) NULL COMMENT 'in:内网,out:外网。' AFTER `updateTime`;

ALTER TABLE  `drawing`
    ADD COLUMN `offlinePath` varchar(255) NULL COMMENT '离线包路径' AFTER `nature`;

INSERT INTO  `drawing`(`id`, `fileId`, `name`, `fileType`, `description`, `addTime`, `updateTime`, `nature`, `offlinePath`) VALUES (1, '2011775863924736', '展览馆', '2', '内场流线模型', '2020-12-07 17:25:25', NULL, 'in', '65f80e6f8117b0564e4abd8d724b3d95');
INSERT INTO  `drawing`(`id`, `fileId`, `name`, `fileType`, `description`, `addTime`, `updateTime`, `nature`, `offlinePath`) VALUES (2, '2011775915100352', '展览馆', '2', '外建筑简模', '2020-12-07 17:25:50', NULL, 'in', '8b5ce03c1965550cd344f578ab27b371');


INSERT INTO  `config_system`(`sysKey`, `sysValue`) VALUES ('bim_nature', 'in');

UPDATE  `config_menu` SET `province` = '110000,640000' WHERE `id` = 1001;
UPDATE  `config_menu` SET `province` = '110000,640000' WHERE `id` = 1002;

INSERT INTO  `base_venue`(`id`, `fullName`, `address`) VALUES (3, '宁夏会展中心', '银川市金凤区北京中路169号');

INSERT INTO `venue_drawing`(`venueId`, `drawingId`) VALUES (3, 1);
INSERT INTO `venue_drawing`(`venueId`, `drawingId`) VALUES (3, 2);