禅道数据迁移

1.最新版是18.10，公司版本12.3，我使用18.8主要是因为这个版本稳定，相关插件支持，都是开源版本。

2.主要数据是zt_module 模块，zt_action 历史(包括bug里面的历史)，zt_bug，zt_project(包括迭代信息)，zt_file(附件)，zt_product(产品，这个看情况，可能自己新建，但是对应的zt_project要改信息)，比对过虽然字段有增减，但是都能正常导出导入。

3.把app下面的data都复制过去，主要是附件。

如果只导一个项目，下面是有用的相关简单SQL，自己备份用。

导出源

#1 导bug
SELECT * FROM zt_product WHERE NAME='产品名称'

delete FROM zt_bug WHERE product='1';
SELECT * FROM zt_bug WHERE product='80' and deleted ='0';
UPDATE zt_bug set product='1' WHERE product='80';
delete FROM zt_bug WHERE product='1' and deleted<>'0';
delete FROM zt_bug WHERE product<>'1'

SELECT * FROM zt_bug WHERE product='1' and deleted ='0';
UPDATE zt_bug set project='7' WHERE product='1';

#2 导module
SELECT * FROM zt_module WHERE root='80';
DELETE FROM zt_module WHERE root<>'80';
DELETE FROM zt_module WHERE deleted='1';
UPDATE zt_module set root='1';
SELECT * FROM zt_module WHERE root='1';

#导附件表
#zt_file，表的数据应该要导入。
#导历史表
DELETE FROM zt_action WHERE id < 4000;
#导附件文件，只能通过外部导入


SELECT count(*) FROM zt_action

导入

SELECT * from zt_module;
#删除垃圾数据，勿随意执行
DELETE FROM zt_module WHERE id >='122';

#修改自增长起始数据
SELECT MAX(id) FROM zt_module; 

#历史数据清理
DELETE from zt_action WHERE id >=4000 and objectType <>'bug';
DELETE from zt_action WHERE id >=4000 and objectType ='bug' and objectID>'24187';
SELECT count(*) FROM zt_action;
DELETE FROM zt_action WHERE objectID not in ( SELECT id FROM zt_bug);

#更新bug归属项目
SELECT * FROM zt_bug WHERE product='1' and deleted ='0' and status<>'closed';
SELECT * FROM zt_project WHERE NAME='省2024';
UPDATE zt_bug set project='22' WHERE product='1' and deleted ='0' and status<>'closed';


#其他
SELECT * FROM zt_bug WHERE id=24188;

SELECT * FROM zt_file WHERE