r1808 + introduce SHOW_EXPLICIT_TAGS, SHOW_IMPLICIT_TAGS and SHOW_AUTOMATIC_TAGS...
[racktables] / install / init-dictbase.sql
1 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (1,'string','OEM S/N 1');
2 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (2,'dict','HW type');
3 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (3,'string','FQDN');
4 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (4,'dict','SW type');
5 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (5,'string','SW version');
6 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (6,'uint','number of ports');
7 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (7,'float','max. current, Ampers');
8 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (8,'float','power load, percents');
9 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (14,'string','contact person');
10 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (13,'float','max power, Watts');
11 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (16,'uint','flash memory, MB');
12 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (17,'uint','DRAM, MB');
13 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (18,'uint','CPU, MHz');
14 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (20,'string','OEM S/N 2');
15 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (21,'string','support contract expiration');
16 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (22,'string','HW warranty expiration');
17 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (24,'string','SW warranty expiration');
18 INSERT INTO `Attribute` (`attr_id`, `attr_type`, `attr_name`) VALUES (25,'string','UUID');
19
20 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,1,0);
21 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,2,11);
22 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,3,0);
23 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,4,13);
24 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,14,0);
25 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,21,0);
26 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,22,0);
27 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,25,0);
28 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (4,24,0);
29 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (5,1,0);
30 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (5,2,18);
31 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (6,1,0);
32 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (6,2,19);
33 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (6,20,0);
34 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,1,0);
35 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,2,17);
36 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,3,0);
37 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,4,16);
38 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,5,0);
39 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,14,0);
40 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,16,0);
41 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,17,0);
42 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,18,0);
43 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,21,0);
44 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,22,0);
45 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (7,24,0);
46 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,1,0);
47 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,2,12);
48 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,3,0);
49 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,4,14);
50 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,5,0);
51 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,14,0);
52 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,16,0);
53 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,17,0);
54 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,18,0);
55 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,20,0);
56 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,21,0);
57 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,22,0);
58 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (8,24,0);
59 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (9,6,0);
60 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (12,1,0);
61 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (12,3,0);
62 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (12,7,0);
63 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (12,8,0);
64 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (12,13,0);
65 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (12,20,0);
66 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (445, 1, 0);
67 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (445, 2, 21);
68 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (445, 3, 0);
69 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (445, 5, 0);
70 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (445, 14, 0);
71 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (445, 22, 0);
72 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (447, 1, 0);
73 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (447, 2, 22);
74 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (447, 3, 0);
75 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (447, 5, 0);
76 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (447, 14, 0);
77 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (447, 22, 0);
78 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_no`) VALUES (15, 2, 23);
79
80 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (11,'no','server models');
81 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (12,'no','network switch models');
82 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (13,'no','server OS type');
83 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (14,'no','switch OS type');
84 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (1,'yes','RackObjectType');
85 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (2,'yes','PortType');
86 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (3,'yes','RackRow');
87 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (16,'no','router OS type');
88 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (17,'no','router models');
89 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (18,'no','disk array models');
90 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (19,'no','tape library models');
91 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (20,'yes','Protocols');
92 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (21,'no','KVM switch models');
93 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (22,'no','multiplexer models');
94 INSERT INTO `Chapter` (`chapter_no`, `sticky`, `chapter_name`) VALUES (23, 'no', 'console models');
95
96 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (17,17);
97 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (18,18);
98 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (19,19);
99 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (20,20);
100 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (21,21);
101 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (22,22);
102 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (23,23);
103 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (24,24);
104 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (25,25);
105 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (26,26);
106 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (27,27);
107 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (28,28);
108 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (18,19);
109 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (19,18);
110 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (18,24);
111 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (24,18);
112 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (19,24);
113 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (24,19);
114 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (29,29);
115 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (20,21);
116 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (21,20);
117 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (22,23);
118 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (23,22);
119 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (25,26);
120 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (26,25);
121 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (27,28);
122 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (28,27);
123 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (30,30);
124 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (16,16);
125 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (17,17);
126 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (18,18);
127 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (19,19);
128 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (20,20);
129 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (21,21);
130 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (22,22);
131 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (23,23);
132 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (24,24);
133 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (25,25);
134 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (26,26);
135 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (27,27);
136 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (28,28);
137 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (18,19);
138 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (19,18);
139 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (18,24);
140 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (24,18);
141 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (19,24);
142 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (24,19);
143 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (29,29);
144 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (29,681);
145 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (29,682);
146 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (20,21);
147 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (21,20);
148 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (22,23);
149 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (23,22);
150 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (25,26);
151 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (26,25);
152 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (27,28);
153 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (28,27);
154 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (30,30);
155 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (16,16);
156 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (32,32);
157 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (33,446);
158 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (34,34);
159 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (35,35);
160 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (36,36);
161 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (37,37);
162 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (38,38);
163 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (39,39);
164 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (40,40);
165 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (41,41);
166 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (439,439);
167 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (446,33);
168 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (681,29);
169 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (681,681);
170 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (681,682);
171 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (682,29);
172 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (682,681);
173 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES (682,682);
174
175 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,1,'BlackBox');
176 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,2,'PDU');
177 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,3,'Shelf');
178 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,4,'Server');
179 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,5,'DiskArray');
180 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,6,'TapeLibrary');
181 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,7,'Router');
182 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,8,'network switch');
183 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,9,'PatchPanel');
184 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,10,'CableOrganizer');
185 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,11,'Placeholder');
186 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,12,'UPS');
187 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,13,'Modem');
188 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,14,'MediaConverter');
189 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,15,'console');
190 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,16,'power plug');
191 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,17,'BNC/10Base2');
192 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,18,'RJ-45/10Base-T');
193 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,19,'RJ-45/100Base-TX');
194 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,20,'SC/100Base-FX');
195 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,21,'LC/100Base-FX');
196 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,22,'SC/100Base-SX');
197 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,23,'LC/100Base-SX');
198 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,24,'RJ-45/1000Base-T');
199 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,25,'SC/1000Base-SX');
200 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,26,'LC/1000Base-SX');
201 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,27,'SC/1000Base-LX');
202 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,28,'LC/1000Base-LX');
203 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,29,'async serial (RJ-45)');
204 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,30,'LC/10GBase-SR');
205 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,31,'veth (Xen bridge)');
206 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,32,'sync serial');
207 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,33,'KVM (host)');
208 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,34,'1000Base-ZX');
209 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,35,'10GBase-ER');
210 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,36,'10GBase-LR');
211 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,37,'10GBase-LRM');
212 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,38,'10GBase-ZR');
213 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,39,'10GBase-LX4');
214 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,40,'10GBase-CX4');
215 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,41,'10GBase-Kx');
216 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (20,336,'TCP');
217 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (20,337,'UDP');
218 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,439,'dry contact');
219 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,440,'unknown');
220 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,445,'KVM switch');
221 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,446,'KVM (console)');
222 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (1,447,'multiplexer');
223 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,681,'async serial (DB-9)');
224 INSERT INTO `Dictionary` (`chapter_no`, `dict_key`, `dict_value`) VALUES (2,682,'async serial (DB-25)');
225
226 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('rtwidth_0','9','uint','no','yes','');
227 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('rtwidth_1','21','uint','no','yes','');
228 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('rtwidth_2','9','uint','no','yes','');
229 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('color_F','8fbfbf','string','no','yes','HSV: 180-25-75. Free atoms, they are available for allocation to objects.');
230 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('color_A','bfbfbf','string','no','yes','HSV: 0-0-75. Absent atoms.');
231 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('color_U','bf8f8f','string','no','yes','HSV: 0-25-75. Unusable atoms. Some problems keep them from being free.');
232 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('color_T','408080','string','no','yes','HSV: 180-50-50. Taken atoms, object_id should be set for such.');
233 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('color_Th','80ffff','string','no','yes','HSV: 180-50-100. Taken atoms with highlight. They are not stored in the database and are only used for highlighting.');
234 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('color_Tw','804040','string','no','yes','HSV: 0-50-50. Taken atoms with object problem. This is detected at runtime.');
235 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('color_Thw','ff8080','string','no','yes','HSV: 0-50-100. An object can be both current and problematic. We run highlightObject() first and markupObjectProblems() second.');
236 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('default_port_type','24','uint','no','no','Default port type');
237 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('MASSCOUNT','15','uint','no','no','"Fast" form is this many records tall');
238 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('MAXSELSIZE','30','uint','no','no','<SELECT> lists height');
239 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('enterprise','MyCompanyName','string','no','no','Organization name');
240 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('NAMEFUL_OBJTYPES','4,7,8','string','yes','no','Expect common name configured for the following object types');
241 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('ROW_SCALE','2','uint','no','no','Picture scale for rack row display');
242 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('PORTS_PER_ROW','12','uint','no','no','Ports per row in VLANs tab');
243 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('IPV4_ADDRS_PER_PAGE','256','uint','no','no','IPv4 addresses per page');
244 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('DEFAULT_RACK_HEIGHT','42','uint','yes','no','Default rack height');
245 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('REQUIRE_ASSET_TAG_FOR','4,7,8','string','yes','no','Require asset tag for the following object types');
246 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('DEFAULT_SLB_VS_PORT','','uint','yes','no','Default port of SLB virtual service');
247 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('DEFAULT_SLB_RS_PORT','','uint','yes','no','Default port of SLB real server');
248 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('IPV4_PERFORMERS','1,4,7,8,12,14,445,447','string','yes','no','IPv4-capable object types');
249 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('NATV4_PERFORMERS','4,7,8','string','yes','no','NATv4-capable object types');
250 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('USER_AUTH_SRC','database','string','no','no','User authentication source');
251 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('DETECT_URLS','no','string','yes','no','Detect URLs in text fields');
252 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('RACK_PRESELECT_THRESHOLD','1','uint','no','no','Rack pre-selection threshold');
253 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('DEFAULT_IPV4_RS_INSERVICE','no','string','no','no','Inservice status for new SLB real servers');
254 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('AUTOPORTS_CONFIG','4 = 1*33*kvm + 2*24*eth%u;15 = 1*446*kvm','string','yes','no','AutoPorts configuration');
255 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('DEFAULT_OBJECT_TYPE','4','uint','yes','no','Default object type for new objects');
256 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('SHOW_EXPLICIT_TAGS','yes','string','no','no','Show explicit tags');
257 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('SHOW_IMPLICIT_TAGS','yes','string','no','no','Show implicit tags');
258 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('SHOW_AUTOMATIC_TAGS','no','string','no','no','Show automatic tags');
259 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES ('DB_VERSION','0.14.12','string','no','yes','Database version.');
260
261 INSERT INTO `UserPermission` (`user_id`, `page`, `tab`, `access`) VALUES (1,'%','%','yes');