ALTER TABLE `js_open_location_server`.`device_template` ADD COLUMN `create_time` datetime DEFAULT NULL COMMENT '创建时间';
ALTER TABLE `js_open_location_server`.`device_template` ADD COLUMN `create_by` varchar(128) DEFAULT NULL COMMENT '创建人';
ALTER TABLE `js_open_location_server`.`device_template` ADD COLUMN `update_time` datetime DEFAULT NULL COMMENT '更新时间';
ALTER TABLE `js_open_location_server`.`device_template` ADD COLUMN `update_by` varchar(128) DEFAULT NULL COMMENT '更新人';

ALTER TABLE `js_open_location_server`.`building` ADD COLUMN `create_time` datetime DEFAULT NULL COMMENT '创建时间';
ALTER TABLE `js_open_location_server`.`building` ADD COLUMN `create_by` varchar(128) DEFAULT NULL COMMENT '创建人';
ALTER TABLE `js_open_location_server`.`building` ADD COLUMN `update_time` datetime DEFAULT NULL COMMENT '更新时间';
ALTER TABLE `js_open_location_server`.`building` ADD COLUMN `update_by` varchar(128) DEFAULT NULL COMMENT '更新人';

ALTER TABLE `js_open_location_server`.`building_floor_map` ADD COLUMN `img_type` int(16) DEFAULT NULL COMMENT '地图图片类型，目前支持0:jpg和1:svg';