r1110 + 0.14.5 -> 0.14.6 database adjustment script
[racktables] / install / dbadjust-0.14.5-0.14.6.sql
1 --
2 -- This script should be executed to upgrade database from version 0.14.5 to 0.14.6.
3 --
4
5 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (13,25,'FreeBSD 1.x');
6 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (13,26,'FreeBSD 2.x');
7 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (13,27,'FreeBSD 3.x');
8 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (13,28,'FreeBSD 4.x');
9 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (13,29,'FreeBSD 5.x');
10 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (13,30,'FreeBSD 6.x');
11 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (13,31,'RHFC8');
12 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (13,32,'ALTLinux Master 4.0');
13 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (20,20);
14 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (21,21);
15 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (22,22);
16 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (23,23);
17 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (24,24);
18 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (25,25);
19 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (26,26);
20 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (27,27);
21 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (28,28);
22 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,20,'KVM');
23 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,21,'1000Base-ZX');
24 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,22,'10GBase-ER');
25 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,23,'10GBase-LR');
26 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,24,'10GBase-LRM');
27 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,25,'10GBase-ZR');
28 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,26,'10GBase-LX4');
29 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,27,'10GBase-CX4');
30 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,28,'10GBase-Kx');