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