
-- 初始化修理厂信息表
TRUNCATE TABLE dd_repair_shop;

-- ---------修理厂信息表数据迁移------------------
INSERT INTO `dd_repair_shop` (
	`reapir_name`,
	`repair_code`,
	`linker_name`,
	`linker_phone`,
	`task_upper_limit`,
	`address`,
	`longitude`,
	`latitude`,
	`is_enable`,
	`create_by`,
	`create_time`,
	`update_by`,
	`update_time`
) SELECT
	ABBREVIATION,
	USER_CODE,
	`NAME`,
	REPAIR_TEL,
	'100',
	ADDRESS,
	LONGITUDE,
	LATITUDE,
	IS_ENABLE,
	CREATE_BY,
	CREATE_DATE,
	UPDATE_BY,
	UPDATE_DATE
FROM
	sd_survey
WHERE
	SURVEY_TYPE = '1';
	






