r1207 + fixed comments
[racktables] / install / dbadjust-0.14.4-0.14.5.sql
1 --
2 -- This script should be executed to upgrade database from version 0.14.4 to 0.14.5.
3 --
4
5 -- applies to RT <= 0.14.4
6 delete from IPAddress where name = '' and reserved = 'no';
7
8
9 -- applies to RT <= 0.14.4
10 alter table Attribute AUTO_INCREMENT = 10000;
11 alter table Chapter AUTO_INCREMENT = 10000;
12 alter table Dictionary AUTO_INCREMENT = 10000;
13 alter table UserAccount AUTO_INCREMENT = 10000;
14 update UserAccount set user_id = user_id + 10000 where user_id > 1;
15 update UserPermission set user_id = user_id + 10000 where user_id > 1;
16 update Attribute set attr_id = attr_id + 10000 where attr_id > 24;
17 update AttributeMap set attr_id = attr_id + 10000 where attr_id > 24;
18 update Chapter set chapter_no = chapter_no + 10000 where chapter_no > 20;
19 update AttributeMap set chapter_no = chapter_no + 10000 where chapter_no > 20;