Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
--
-- Script to downgrade from FTS3 Schema 5.0.0 to the previous schema
--
ALTER TABLE `t_job`
DROP INDEX `idx_jobtype`;
ALTER TABLE `t_file`
DROP INDEX `idx_state`;
ALTER TABLE `t_file`
DROP INDEX `idx_host`;
ALTER TABLE `t_optimizer_evolution`
DROP INDEX `idx_datetime`;
ALTER TABLE `t_file`
MODIFY reason varchar(2048) CHARACTER SET latin1;
ALTER TABLE `t_file_backup`
MODIFY reason varchar(2048) CHARACTER SET latin1;
ALTER TABLE `t_dm`
MODIFY reason varchar(2048) CHARACTER SET latin1;
ALTER TABLE `t_dm_backup`
MODIFY reason varchar(2048) CHARACTER SET latin1;
ALTER TABLE `t_file_retry_errors`
MODIFY reason varchar(2048) CHARACTER SET latin1;
ALTER TABLE `t_file_retry_errors`
DROP INDEX `idx_datetime`;
ALTER TABLE `t_file`
DROP `priority`;
ALTER TABLE `t_file`
DROP UNIQUE KEY `dest_surl_uuid`;
ALTER TABLE `t_file`
DROP `dest_surl_uuid`;
DROP TABLE t_dm;
RENAME TABLE t_dm_old TO t_dm;
ALTER TABLE t_dm
DROP INDEX dm_job_id;
--
-- Archive tables need to match the new schema
--
DROP TABLE t_dm_backup;
RENAME TABLE t_dm_backup_old TO t_dm_backup;
UPDATE t_schema_vers SET MAJOR=4, PATCH=1, MESSAGE='DOWNGRADE from 5.0.0' where MAJOR = 5;