r1109 + FreeBSD and others in server OS chapter
[racktables] / install / init-dictbase.sql
1 LOCK TABLES `Attribute` WRITE;
2 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (1,'string','OEM S/N 1');
3 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (2,'dict','HW type');
4 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (3,'string','FQDN');
5 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (4,'dict','SW type');
6 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (5,'string','SW version');
7 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (6,'uint','number of ports');
8 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (7,'float','max. current, Ampers');
9 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (8,'float','power load, percents');
10 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (14,'string','contact person');
11 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (13,'float','max power, Watts');
12 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (16,'uint','flash memory, MB');
13 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (17,'uint','DRAM, MB');
14 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (18,'uint','CPU, MHz');
15 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (20,'string','OEM S/N 2');
16 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (21,'string','support contract expiration');
17 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (22,'string','HW warranty expiration');
18 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (24,'string','SW warranty expiration');
19 UNLOCK TABLES;
20
21 LOCK TABLES `AttributeMap` WRITE;
22 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,1,0);
23 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,2,11);
24 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,3,0);
25 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (5,1,0);
26 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (12,1,0);
27 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,4,14);
28 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,5,0);
29 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,2,12);
30 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,4,13);
31 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,3,11);
32 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,3,11);
33 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,1,11);
34 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,14,18);
35 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,14,18);
36 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,21,18);
37 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,22,18);
38 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,14,15);
39 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,2,17);
40 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,4,16);
41 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,1,15);
42 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,5,15);
43 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (12,3,15);
44 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (9,6,15);
45 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,16,15);
46 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,17,15);
47 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,18,15);
48 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,16,15);
49 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,17,15);
50 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,18,15);
51 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (5,2,18);
52 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (6,2,19);
53 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (12,7,18);
54 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (12,13,18);
55 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,24,18);
56 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (12,8,18);
57 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,20,18);
58 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (12,20,18);
59 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,21,18);
60 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,22,18);
61 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,24,18);
62 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,24,18);
63 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,22,18);
64 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,21,18);
65 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (6,1,18);
66 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (6,20,18);
67 UNLOCK TABLES;
68
69 LOCK TABLES `Chapter` WRITE;
70 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (11,'no','server models');
71 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (12,'no','switch models');
72 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (13,'no','server OS type');
73 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (14,'no','switch OS type');
74 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (1,'yes','RackObjectType');
75 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (2,'yes','PortType');
76 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (3,'yes','RackRow');
77 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (16,'no','router OS type');
78 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (17,'no','router models');
79 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (18,'no','disk array models');
80 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (19,'no','tape library models');
81 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (20,'yes','Protocols');
82 UNLOCK TABLES;
83
84 LOCK TABLES `PortCompat` WRITE;
85 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (4,4);
86 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (5,5);
87 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (6,6);
88 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (7,7);
89 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (8,8);
90 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (9,9);
91 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (10,10);
92 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (11,11);
93 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (12,12);
94 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (13,13);
95 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (14,14);
96 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (15,15);
97 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (5,6);
98 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (6,5);
99 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (5,11);
100 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (11,5);
101 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (6,11);
102 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (11,6);
103 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (16,16);
104 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (7,8);
105 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (8,7);
106 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (9,10);
107 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (10,9);
108 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (12,13);
109 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (13,12);
110 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (14,15);
111 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (15,14);
112 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (17,17);
113 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (3,3);
114 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (4,4);
115 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (5,5);
116 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (6,6);
117 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (7,7);
118 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (8,8);
119 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (9,9);
120 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (10,10);
121 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (11,11);
122 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (12,12);
123 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (13,13);
124 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (14,14);
125 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (15,15);
126 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (5,6);
127 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (6,5);
128 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (5,11);
129 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (11,5);
130 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (6,11);
131 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (11,6);
132 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (16,16);
133 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (7,8);
134 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (8,7);
135 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (9,10);
136 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (10,9);
137 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (12,13);
138 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (13,12);
139 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (14,15);
140 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (15,14);
141 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (17,17);
142 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (3,3);
143 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (19,19);
144 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (20,20);
145 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (21,21);
146 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (22,22);
147 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (23,23);
148 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (24,24);
149 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (25,25);
150 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (26,26);
151 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (27,27);
152 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (28,28);
153 UNLOCK TABLES;
154
155 LOCK TABLES `Dictionary` WRITE;
156 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,1,'BlackBox');
157 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,2,'PDU');
158 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,3,'Shelf');
159 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,4,'Server');
160 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,5,'DiskArray');
161 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,6,'TapeLibrary');
162 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,7,'Router');
163 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,8,'Switch');
164 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,9,'PatchPanel');
165 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,10,'CableOrganizer');
166 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,11,'Placeholder');
167 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,12,'UPS');
168 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,14,'Modem');
169 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,15,'MediaConverter');
170 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,16,'console');
171 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,17,'LC/10GBase-SR');
172 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,3,'power plug');
173 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,4,'BNC/10Base2');
174 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,5,'RJ-45/10Base-T');
175 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,6,'RJ-45/100Base-TX');
176 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,7,'SC/100Base-FX');
177 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,8,'LC/100Base-FX');
178 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,9,'SC/100Base-SX');
179 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,10,'LC/100Base-SX');
180 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,11,'RJ-45/1000Base-T');
181 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,12,'SC/1000Base-SX');
182 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,13,'LC/1000Base-SX');
183 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,14,'SC/1000Base-LX');
184 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,15,'LC/1000Base-LX');
185 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,16,'async serial');
186 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,19,'sync serial');
187 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,18,'veth (Xen bridge)');
188 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,20,'KVM');
189 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,21,'1000Base-ZX');
190 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,22,'10GBase-ER');
191 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,23,'10GBase-LR');
192 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,24,'10GBase-LRM');
193 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,25,'10GBase-ZR');
194 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,26,'10GBase-LX4');
195 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,27,'10GBase-CX4');
196 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,28,'10GBase-Kx');
197 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (20,1,'TCP');
198 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (20,2,'UDP');
199 UNLOCK TABLES;