r1207 + fixed comments
[racktables] / install / dbadjust-0.14.4-0.14.5.sql
CommitLineData
e673ee24
DO
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
6delete from IPAddress where name = '' and reserved = 'no';
7
8
9-- applies to RT <= 0.14.4
10alter table Attribute AUTO_INCREMENT = 10000;
11alter table Chapter AUTO_INCREMENT = 10000;
12alter table Dictionary AUTO_INCREMENT = 10000;
13alter table UserAccount AUTO_INCREMENT = 10000;
14update UserAccount set user_id = user_id + 10000 where user_id > 1;
15update UserPermission set user_id = user_id + 10000 where user_id > 1;
16update Attribute set attr_id = attr_id + 10000 where attr_id > 24;
17update AttributeMap set attr_id = attr_id + 10000 where attr_id > 24;
18update Chapter set chapter_no = chapter_no + 10000 where chapter_no > 20;
19update AttributeMap set chapter_no = chapter_no + 10000 where chapter_no > 20;