r3134 - maintenance->trunk sync of changesets: 3130, 3131, 3133
[racktables] / install / init-dictbase.sql
1 -- This file is intentionally kept in extended INSERT syntax
2 -- (1 query = N rows) to generate less diff noise on column
3 -- name change.
4
5 INSERT INTO `Attribute` (`id`, `type`, `name`) VALUES
6 (1,'string','OEM S/N 1'),
7 (2,'dict','HW type'),
8 (3,'string','FQDN'),
9 (4,'dict','SW type'),
10 (5,'string','SW version'),
11 (6,'uint','number of ports'),
12 (7,'float','max. current, Ampers'),
13 (8,'float','power load, percents'),
14 (14,'string','contact person'),
15 (13,'float','max power, Watts'),
16 (16,'uint','flash memory, MB'),
17 (17,'uint','DRAM, MB'),
18 (18,'uint','CPU, MHz'),
19 (20,'string','OEM S/N 2'),
20 (21,'string','support contract expiration'),
21 (22,'string','HW warranty expiration'),
22 (24,'string','SW warranty expiration'),
23 (25,'string','UUID');
24
25 INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_id`) VALUES
26 (2,1,NULL),
27 (2,2,27),
28 (2,3,NULL),
29 (2,5,NULL),
30 (4,1,NULL),
31 (4,2,11),
32 (4,3,NULL),
33 (4,4,13),
34 (4,14,NULL),
35 (4,21,NULL),
36 (4,22,NULL),
37 (4,25,NULL),
38 (4,24,NULL),
39 (5,1,NULL),
40 (5,2,18),
41 (6,1,NULL),
42 (6,2,19),
43 (6,20,NULL),
44 (7,1,NULL),
45 (7,2,17),
46 (7,3,NULL),
47 (7,4,16),
48 (7,5,NULL),
49 (7,14,NULL),
50 (7,16,NULL),
51 (7,17,NULL),
52 (7,18,NULL),
53 (7,21,NULL),
54 (7,22,NULL),
55 (7,24,NULL),
56 (8,1,NULL),
57 (8,2,12),
58 (8,3,NULL),
59 (8,4,14),
60 (8,5,NULL),
61 (8,14,NULL),
62 (8,16,NULL),
63 (8,17,NULL),
64 (8,18,NULL),
65 (8,20,NULL),
66 (8,21,NULL),
67 (8,22,NULL),
68 (8,24,NULL),
69 (9,6,NULL),
70 (12,1,NULL),
71 (12,3,NULL),
72 (12,7,NULL),
73 (12,8,NULL),
74 (12,13,NULL),
75 (12,20,NULL),
76 (445,1,NULL),
77 (445,2,21),
78 (445,3,NULL),
79 (445,5,NULL),
80 (445,14,NULL),
81 (445,22,NULL),
82 (447,1,NULL),
83 (447,2,22),
84 (447,3,NULL),
85 (447,5,NULL),
86 (447,14,NULL),
87 (447,22,NULL),
88 (15,2,23),
89 (798,1,NULL),
90 (798,2,24),
91 (798,3,NULL),
92 (798,5,NULL),
93 (798,14,NULL),
94 (798,16,NULL),
95 (798,17,NULL),
96 (798,18,NULL),
97 (798,20,NULL),
98 (798,21,NULL),
99 (798,22,NULL),
100 (798,24,NULL),
101 (965,1,NULL),
102 (965,3,NULL),
103 (965,2,25),
104 (1055,2,26);
105
106 INSERT INTO `Chapter` (`id`, `sticky`, `name`) VALUES
107 (1,'yes','RackObjectType'),
108 (2,'yes','PortOuterInterface'),
109 (11,'no','server models'),
110 (12,'no','network switch models'),
111 (13,'no','server OS type'),
112 (14,'no','switch OS type'),
113 (16,'no','router OS type'),
114 (17,'no','router models'),
115 (18,'no','disk array models'),
116 (19,'no','tape library models'),
117 (21,'no','KVM switch models'),
118 (22,'no','multiplexer models'),
119 (23,'no','console models'),
120 (24,'no','network security models'),
121 (25,'no','wireless models'),
122 (26,'no','fibre channel switch models'),
123 (27,'no','PDU models');
124
125 INSERT INTO `PortInnerInterface` VALUES
126 (1,'hardwired'),
127 (2,'SFP-100'),
128 (3,'GBIC'),
129 (4,'SFP-1000'),
130 (5,'XENPAK'),
131 (6,'X2'),
132 (7,'XPAK'),
133 (8,'XFP'),
134 (9,'SFP+');
135
136 INSERT INTO `PortInterfaceCompat` VALUES
137 (2,1208),(2,1195),(2,1196),(2,1197),(2,1198),(2,1199),(2,1200),(2,1201),
138 (3,1078),(3,24),(3,34),(3,1202),(3,1203),(3,1204),(3,1205),(3,1206),(3,1207),
139 (4,1077),(4,24),(4,34),(4,1202),(4,1203),(4,1204),(4,1205),(4,1206),(4,1207),
140 (5,1079),(5,30),(5,35),(5,36),(5,37),(5,38),(5,39),(5,40),
141 (6,1080),(6,30),(6,35),(6,36),(6,37),(6,38),(6,39),(6,40),
142 (7,1081),(7,30),(7,35),(7,36),(7,37),(7,38),(7,39),(7,40),
143 (8,1082),(8,30),(8,35),(8,36),(8,37),(8,38),(8,39),(8,40),
144 (9,1084),(9,30),(9,35),(9,36),(9,37),(9,38),(9,39),(9,40),
145 (1,16),(1,19),(1,24),(1,29),(1,31),(1,33),(1,446),(1,681),(1,682),(1,1322);
146
147 INSERT INTO `PortCompat` (`type1`, `type2`) VALUES
148 (17,17),
149 (18,18),
150 (19,19),
151 (20,20),
152 (21,21),
153 (21,1195),
154 (22,22),
155 (22,1196),
156 (23,23),
157 (23,1196),
158 (24,24),
159 (25,25),
160 (26,26),
161 (27,27),
162 (28,28),
163 (18,19),
164 (19,18),
165 (18,24),
166 (24,18),
167 (19,24),
168 (24,19),
169 (29,29),
170 (20,21),
171 (20,1083),
172 (20,1195),
173 (21,20),
174 (21,1083),
175 (22,23),
176 (23,22),
177 (25,26),
178 (25,1202),
179 (26,25),
180 (26,1202),
181 (27,28),
182 (27,1204),
183 (28,27),
184 (28,1204),
185 (30,30),
186 (16,1322),
187 (1322,16),
188 (29,681),
189 (29,682),
190 (32,32),
191 (33,446),
192 (34,34),
193 (35,35),
194 (36,36),
195 (37,37),
196 (38,38),
197 (39,39),
198 (40,40),
199 (41,41),
200 (439,439),
201 (446,33),
202 (681,29),
203 (681,681),
204 (681,682),
205 (682,29),
206 (682,681),
207 (682,682),
208 (1077,1077),
209 (1083,20),
210 (1083,21),
211 (1083,1083),
212 (1083,1195),
213 (1084,1084),
214 (1087,1087),
215 (1195,20),
216 (1195,21),
217 (1195,1083),
218 (1195,1195),
219 (1196,22),
220 (1196,23),
221 (1196,1196),
222 (1197,1197),
223 (1198,1199),
224 (1199,1198),
225 (1200,1200),
226 (1201,1201),
227 (1202,25),
228 (1202,26),
229 (1202,1202),
230 (1203,1203),
231 (1204,27),
232 (1204,28),
233 (1204,1204),
234 (1205,1205),
235 (1206,1207),
236 (1207,1206),
237 (1209,1209),
238 (1210,1210),
239 (1211,1211),
240 (1212,1212),
241 (1213,1213),
242 (1214,1214),
243 (1215,1215),
244 (1216,1216),
245 (1217,1217),
246 (1218,1218),
247 (1219,1219),
248 (1220,1220),
249 (1221,1221),
250 (1222,1222),
251 (1223,1223),
252 (1224,1224),
253 (1225,1225),
254 (1226,1226),
255 (1227,1227),
256 (1228,1228),
257 (1229,1229),
258 (1230,1230),
259 (1231,1231),
260 (1232,1232),
261 (1233,1233),
262 (1234,1234),
263 (1235,1235),
264 (1236,1236),
265 (1237,1237),
266 (1238,1238),
267 (1239,1239),
268 (1240,1240),
269 (1241,1241),
270 (1242,1242),
271 (1243,1243),
272 (1244,1244),
273 (1245,1245),
274 (1246,1246),
275 (1247,1247),
276 (1248,1248),
277 (1249,1249),
278 (1250,1250),
279 (1251,1251),
280 (1252,1252),
281 (1253,1253),
282 (1254,1254),
283 (1255,1255),
284 (1256,1256),
285 (1257,1257),
286 (1258,1258),
287 (1259,1259),
288 (1260,1260),
289 (1261,1261),
290 (1262,1262),
291 (1263,1263),
292 (1264,1264),
293 (1265,1265),
294 (1266,1266),
295 (1267,1267),
296 (1268,1268),
297 (1269,1269),
298 (1270,1270),
299 (1271,1271),
300 (1272,1272),
301 (1273,1273),
302 (1274,1274),
303 (1275,1275),
304 (1276,1276),
305 (1277,1277),
306 (1278,1278),
307 (1279,1279),
308 (1280,1280),
309 (1281,1281),
310 (1282,1282),
311 (1283,1283),
312 (1284,1284),
313 (1285,1285),
314 (1286,1286),
315 (1287,1287),
316 (1288,1288),
317 (1289,1289),
318 (1290,1290),
319 (1291,1291),
320 (1292,1292),
321 (1293,1293),
322 (1294,1294),
323 (1295,1295),
324 (1296,1296),
325 (1297,1297),
326 (1298,1298),
327 (1299,1299),
328 (1300,1300),
329 (1316,1316);
330
331 INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES
332 ('color_F','8fbfbf','string','no','yes','HSV: 180-25-75. Free atoms, they are available for allocation to objects.'),
333 ('color_A','bfbfbf','string','no','yes','HSV: 0-0-75. Absent atoms.'),
334 ('color_U','bf8f8f','string','no','yes','HSV: 0-25-75. Unusable atoms. Some problems keep them from being free.'),
335 ('color_T','408080','string','no','yes','HSV: 180-50-50. Taken atoms, object_id should be set for such.'),
336 ('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.'),
337 ('color_Tw','804040','string','no','yes','HSV: 0-50-50. Taken atoms with object problem. This is detected at runtime.'),
338 ('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.'),
339 ('MASSCOUNT','15','uint','no','no','"Fast" form is this many records tall'),
340 ('MAXSELSIZE','30','uint','no','no','<SELECT> lists height'),
341 ('enterprise','MyCompanyName','string','no','no','Organization name'),
342 ('ROW_SCALE','2','uint','no','no','Picture scale for rack row display'),
343 ('PORTS_PER_ROW','12','uint','no','no','Ports per row in VLANs tab'),
344 ('IPV4_ADDRS_PER_PAGE','256','uint','no','no','IPv4 addresses per page'),
345 ('DEFAULT_RACK_HEIGHT','42','uint','yes','no','Default rack height'),
346 ('DEFAULT_SLB_VS_PORT','','uint','yes','no','Default port of SLB virtual service'),
347 ('DEFAULT_SLB_RS_PORT','','uint','yes','no','Default port of SLB real server'),
348 ('DETECT_URLS','no','string','yes','no','Detect URLs in text fields'),
349 ('RACK_PRESELECT_THRESHOLD','1','uint','no','no','Rack pre-selection threshold'),
350 ('DEFAULT_IPV4_RS_INSERVICE','no','string','no','no','Inservice status for new SLB real servers'),
351 ('AUTOPORTS_CONFIG','4 = 1*33*kvm + 2*24*eth%u;15 = 1*446*kvm','string','yes','no','AutoPorts configuration'),
352 ('DEFAULT_OBJECT_TYPE','4','uint','yes','no','Default object type for new objects'),
353 ('SHOW_EXPLICIT_TAGS','yes','string','no','no','Show explicit tags'),
354 ('SHOW_IMPLICIT_TAGS','yes','string','no','no','Show implicit tags'),
355 ('SHOW_AUTOMATIC_TAGS','no','string','no','no','Show automatic tags'),
356 ('IPV4_AUTO_RELEASE','1','uint','no','no','Auto-release IPv4 addresses on allocation'),
357 ('SHOW_LAST_TAB','no','string','yes','no','Remember last tab shown for each page'),
358 ('EXT_IPV4_VIEW','yes','string','no','no','Extended IPv4 view'),
359 ('TREE_THRESHOLD','25','uint','yes','no','Tree view auto-collapse threshold'),
360 ('IPV4_JAYWALK','no','string','no','no','Enable IPv4 address allocations w/o covering network'),
361 ('ADDNEW_AT_TOP','yes','string','no','no','Render "add new" line at top of the list'),
362 ('IPV4_TREE_SHOW_USAGE','yes','string','no','no','Show address usage in IPv4 tree'),
363 ('PREVIEW_TEXT_MAXCHARS','10240','uint','yes','no','Max chars for text file preview'),
364 ('PREVIEW_TEXT_ROWS','25','uint','yes','no','Rows for text file preview'),
365 ('PREVIEW_TEXT_COLS','80','uint','yes','no','Columns for text file preview'),
366 ('PREVIEW_IMAGE_MAXPXS','320','uint','yes','no','Max pixels per axis for image file preview'),
367 ('VENDOR_SIEVE','','string','yes','no','Vendor sieve configuration'),
368 ('IPV4LB_LISTSRC','{$typeid_4}','string','yes','no','List source: IPv4 load balancers'),
369 ('IPV4OBJ_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8} or {$typeid_12} or {$typeid_445} or {$typeid_447}','string','yes','no','List source: IPv4-enabled objects'),
370 ('IPV4NAT_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8}','string','yes','no','List source: IPv4 NAT performers'),
371 ('ASSETWARN_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8}','string','yes','no','List source: object, for which asset tag should be set'),
372 ('NAMEWARN_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8}','string','yes','no','List source: object, for which common name should be set'),
373 ('RACKS_PER_ROW','12','uint','yes','no','Racks per row'),
374 ('FILTER_PREDICATE_SIEVE','','string','yes','no','Predicate sieve regex(7)'),
375 ('FILTER_DEFAULT_ANDOR','or','string','no','no','Default list filter boolean operation (or/and)'),
376 ('FILTER_SUGGEST_ANDOR','yes','string','no','no','Suggest and/or selector in list filter'),
377 ('FILTER_SUGGEST_TAGS','yes','string','no','no','Suggest tags in list filter'),
378 ('FILTER_SUGGEST_PREDICATES','yes','string','no','no','Suggest predicates in list filter'),
379 ('FILTER_SUGGEST_EXTRA','no','string','no','no','Suggest extra expression in list filter'),
380 ('DEFAULT_SNMP_COMMUNITY','public','string','no','no','Default SNMP Community string'),
381 ('IPV4_ENABLE_KNIGHT','yes','string','no','no','Enable IPv4 knight feature'),
382 ('TAGS_TOPLIST_SIZE','50','uint','yes','no','Tags top list size'),
383 ('TAGS_QUICKLIST_SIZE','20','uint','no','no','Tags quick list size'),
384 ('TAGS_QUICKLIST_THRESHOLD','50','uint','yes','no','Tags quick list threshold'),
385 ('ENABLE_MULTIPORT_FORM','no','string','no','no','Enable "Add/update multiple ports" form'),
386 ('DEFAULT_PORT_IIF_ID','1','uint','no','no','Default port inner interface ID'),
387 ('DEFAULT_PORT_OIF_IDS','1=24; 3=1078; 4=1077; 5=1079; 6=1080; 8=1082; 9=1084','string','no','no','Default port outer interface IDs'),
388 ('IPV4_TREE_RTR_AS_CELL','yes','string','no','no','Show full router info for each network in IPv4 tree view'),
389 ('DB_VERSION','0.17.5','string','no','yes','Database version.');
390
391 INSERT INTO `Script` VALUES ('RackCode','allow {$userid_1}');