r2834 - do necessary arrangements in FC switch records
[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
DO
25INSERT INTO `AttributeMap` (`objtype_id`, `attr_id`, `chapter_id`) VALUES
26(4,1,0),
27(4,2,11),
28(4,3,0),
29(4,4,13),
30(4,14,0),
31(4,21,0),
32(4,22,0),
33(4,25,0),
34(4,24,0),
35(5,1,0),
36(5,2,18),
37(6,1,0),
38(6,2,19),
39(6,20,0),
40(7,1,0),
41(7,2,17),
42(7,3,0),
43(7,4,16),
44(7,5,0),
45(7,14,0),
46(7,16,0),
47(7,17,0),
48(7,18,0),
49(7,21,0),
50(7,22,0),
51(7,24,0),
52(8,1,0),
53(8,2,12),
54(8,3,0),
55(8,4,14),
56(8,5,0),
57(8,14,0),
58(8,16,0),
59(8,17,0),
60(8,18,0),
61(8,20,0),
62(8,21,0),
63(8,22,0),
64(8,24,0),
65(9,6,0),
66(12,1,0),
67(12,3,0),
68(12,7,0),
69(12,8,0),
70(12,13,0),
71(12,20,0),
72(445,1,0),
73(445,2,21),
74(445,3,0),
75(445,5,0),
76(445,14,0),
77(445,22,0),
78(447,1,0),
79(447,2,22),
80(447,3,0),
81(447,5,0),
82(447,14,0),
83(447,22,0),
84(15,2,23),
85(798,1,0),
86(798,2,24),
87(798,3,0),
88(798,5,0),
89(798,14,0),
90(798,16,0),
91(798,17,0),
92(798,18,0),
93(798,20,0),
94(798,21,0),
95(798,22,0),
d488506b
DO
96(798,24,0),
97(965,1,0),
98(965,3,0),
cd35f322
DO
99(965,2,25),
100(1055,2,26);
e673ee24 101
d55aa037 102INSERT INTO `Chapter` (`id`, `sticky`, `name`) VALUES
7b1a3a72
AD
103(1,'yes','RackObjectType'),
104(2,'yes','PortType'),
d55aa037
DO
105(11,'no','server models'),
106(12,'no','network switch models'),
107(13,'no','server OS type'),
108(14,'no','switch OS type'),
d55aa037
DO
109(16,'no','router OS type'),
110(17,'no','router models'),
111(18,'no','disk array models'),
112(19,'no','tape library models'),
113(21,'no','KVM switch models'),
114(22,'no','multiplexer models'),
115(23,'no','console models'),
d488506b 116(24,'no','network security models'),
7b1a3a72
AD
117(25,'no','wireless models'),
118(26,'no','fibre channel switch models');
e673ee24 119
d55aa037
DO
120INSERT INTO `PortCompat` (`type1`, `type2`) VALUES
121(17,17),
122(18,18),
123(19,19),
124(20,20),
125(21,21),
126(22,22),
127(23,23),
128(24,24),
129(25,25),
130(26,26),
131(27,27),
132(28,28),
133(18,19),
134(19,18),
135(18,24),
136(24,18),
137(19,24),
138(24,19),
139(29,29),
140(20,21),
141(21,20),
142(22,23),
143(23,22),
144(25,26),
145(26,25),
146(27,28),
147(28,27),
148(30,30),
149(16,16),
d55aa037
DO
150(29,681),
151(29,682),
d55aa037
DO
152(32,32),
153(33,446),
154(34,34),
155(35,35),
156(36,36),
157(37,37),
158(38,38),
159(39,39),
160(40,40),
161(41,41),
162(439,439),
163(446,33),
164(681,29),
165(681,681),
166(681,682),
167(682,29),
168(682,681),
169(682,682);
9a6012eb 170
d55aa037
DO
171INSERT INTO `Dictionary` (`chapter_id`, `dict_key`, `dict_value`) VALUES
172(1,1,'BlackBox'),
173(1,2,'PDU'),
174(1,3,'Shelf'),
175(1,4,'Server'),
176(1,5,'DiskArray'),
177(1,6,'TapeLibrary'),
178(1,7,'Router'),
179(1,8,'Network switch'),
180(1,9,'PatchPanel'),
181(1,10,'CableOrganizer'),
182(1,11,'spacer'),
183(1,12,'UPS'),
184(1,13,'Modem'),
185(1,14,'MediaConverter'),
186(1,15,'console'),
187(2,16,'power plug'),
188(2,17,'BNC/10Base2'),
189(2,18,'RJ-45/10Base-T'),
190(2,19,'RJ-45/100Base-TX'),
191(2,20,'SC/100Base-FX'),
192(2,21,'LC/100Base-FX'),
193(2,22,'SC/100Base-SX'),
194(2,23,'LC/100Base-SX'),
195(2,24,'RJ-45/1000Base-T'),
196(2,25,'SC/1000Base-SX'),
197(2,26,'LC/1000Base-SX'),
198(2,27,'SC/1000Base-LX'),
199(2,28,'LC/1000Base-LX'),
200(2,29,'async serial (RJ-45)'),
201(2,30,'LC/10GBase-SR'),
202(2,31,'veth (Xen bridge)'),
203(2,32,'sync serial'),
204(2,33,'KVM (host)'),
205(2,34,'1000Base-ZX'),
206(2,35,'10GBase-ER'),
207(2,36,'10GBase-LR'),
208(2,37,'10GBase-LRM'),
209(2,38,'10GBase-ZR'),
210(2,39,'10GBase-LX4'),
211(2,40,'10GBase-CX4'),
212(2,41,'10GBase-Kx'),
213(2,439,'dry contact'),
214(2,440,'unknown'),
215(1,445,'KVM switch'),
216(2,446,'KVM (console)'),
217(1,447,'multiplexer'),
218(2,681,'async serial (DB-9)'),
219(2,682,'async serial (DB-25)'),
d488506b 220(1,798,'Network security'),
cd35f322
DO
221(1,965,'Wireless'),
222(1,1055,'FC switch');
d55aa037
DO
223
224INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES
225('color_F','8fbfbf','string','no','yes','HSV: 180-25-75. Free atoms, they are available for allocation to objects.'),
226('color_A','bfbfbf','string','no','yes','HSV: 0-0-75. Absent atoms.'),
227('color_U','bf8f8f','string','no','yes','HSV: 0-25-75. Unusable atoms. Some problems keep them from being free.'),
228('color_T','408080','string','no','yes','HSV: 180-50-50. Taken atoms, object_id should be set for such.'),
229('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.'),
230('color_Tw','804040','string','no','yes','HSV: 0-50-50. Taken atoms with object problem. This is detected at runtime.'),
231('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.'),
232('default_port_type','24','uint','no','no','Default port type'),
233('MASSCOUNT','15','uint','no','no','"Fast" form is this many records tall'),
234('MAXSELSIZE','30','uint','no','no','<SELECT> lists height'),
235('enterprise','MyCompanyName','string','no','no','Organization name'),
236('ROW_SCALE','2','uint','no','no','Picture scale for rack row display'),
237('PORTS_PER_ROW','12','uint','no','no','Ports per row in VLANs tab'),
238('IPV4_ADDRS_PER_PAGE','256','uint','no','no','IPv4 addresses per page'),
239('DEFAULT_RACK_HEIGHT','42','uint','yes','no','Default rack height'),
240('DEFAULT_SLB_VS_PORT','','uint','yes','no','Default port of SLB virtual service'),
241('DEFAULT_SLB_RS_PORT','','uint','yes','no','Default port of SLB real server'),
242('DETECT_URLS','no','string','yes','no','Detect URLs in text fields'),
243('RACK_PRESELECT_THRESHOLD','1','uint','no','no','Rack pre-selection threshold'),
244('DEFAULT_IPV4_RS_INSERVICE','no','string','no','no','Inservice status for new SLB real servers'),
245('AUTOPORTS_CONFIG','4 = 1*33*kvm + 2*24*eth%u;15 = 1*446*kvm','string','yes','no','AutoPorts configuration'),
246('DEFAULT_OBJECT_TYPE','4','uint','yes','no','Default object type for new objects'),
247('SHOW_EXPLICIT_TAGS','yes','string','no','no','Show explicit tags'),
248('SHOW_IMPLICIT_TAGS','yes','string','no','no','Show implicit tags'),
249('SHOW_AUTOMATIC_TAGS','no','string','no','no','Show automatic tags'),
250('IPV4_AUTO_RELEASE','1','uint','no','no','Auto-release IPv4 addresses on allocation'),
251('SHOW_LAST_TAB','no','string','yes','no','Remember last tab shown for each page'),
252('EXT_IPV4_VIEW','yes','string','no','no','Extended IPv4 view'),
253('TREE_THRESHOLD','25','uint','yes','no','Tree view auto-collapse threshold'),
254('IPV4_JAYWALK','no','string','no','no','Enable IPv4 address allocations w/o covering network'),
255('ADDNEW_AT_TOP','yes','string','no','no','Render "add new" line at top of the list'),
256('IPV4_TREE_SHOW_USAGE','yes','string','no','no','Show address usage in IPv4 tree'),
257('PREVIEW_TEXT_MAXCHARS','10240','uint','yes','no','Max chars for text file preview'),
258('PREVIEW_TEXT_ROWS','25','uint','yes','no','Rows for text file preview'),
259('PREVIEW_TEXT_COLS','80','uint','yes','no','Columns for text file preview'),
260('PREVIEW_IMAGE_MAXPXS','320','uint','yes','no','Max pixels per axis for image file preview'),
261('VENDOR_SIEVE','','string','yes','no','Vendor sieve configuration'),
262('IPV4LB_LISTSRC','{$typeid_4}','string','yes','no','List source: IPv4 load balancers'),
263('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'),
264('IPV4NAT_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8}','string','yes','no','List source: IPv4 NAT performers'),
265('ASSETWARN_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8}','string','yes','no','List source: object, for which asset tag should be set'),
266('NAMEWARN_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8}','string','yes','no','List source: object, for which common name should be set'),
f5883ec1 267('RACKS_PER_ROW','12','unit','yes','no','Racks per row'),
590e1281 268('FILTER_PREDICATE_SIEVE','','string','yes','no','Predicate sieve regex(7)'),
23cdc7e9
DO
269('FILTER_DEFAULT_ANDOR','or','string','no','no','Default list filter boolean operation (or/and)'),
270('FILTER_SUGGEST_ANDOR','yes','string','no','no','Suggest and/or selector in list filter'),
271('FILTER_SUGGEST_TAGS','yes','string','no','no','Suggest tags in list filter'),
272('FILTER_SUGGEST_PREDICATES','yes','string','no','no','Suggest predicates in list filter'),
273('FILTER_SUGGEST_EXTRA','no','string','no','no','Suggest extra expression in list filter'),
7b1a3a72 274('DB_VERSION','0.17.2','string','no','yes','Database version.');
032a2fb2 275
d35cd472 276INSERT INTO `Script` VALUES ('RackCode','allow {$userid_1}');