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