r3060 - 0.17.4 pre-release justifications
[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
d55aa037
DO
122INSERT INTO `PortCompat` (`type1`, `type2`) VALUES
123(17,17),
124(18,18),
125(19,19),
126(20,20),
127(21,21),
128(22,22),
129(23,23),
130(24,24),
131(25,25),
132(26,26),
133(27,27),
134(28,28),
135(18,19),
136(19,18),
137(18,24),
138(24,18),
139(19,24),
140(24,19),
141(29,29),
142(20,21),
74aee2dc 143(20,1083),
d55aa037 144(21,20),
74aee2dc 145(21,1083),
d55aa037
DO
146(22,23),
147(23,22),
148(25,26),
149(26,25),
150(27,28),
151(28,27),
152(30,30),
153(16,16),
d55aa037
DO
154(29,681),
155(29,682),
d55aa037
DO
156(32,32),
157(33,446),
158(34,34),
159(35,35),
160(36,36),
161(37,37),
162(38,38),
163(39,39),
164(40,40),
165(41,41),
166(439,439),
167(446,33),
168(681,29),
169(681,681),
170(681,682),
171(682,29),
172(682,681),
028e6459 173(682,682),
74aee2dc
DO
174(1077,1077),
175(1083,20),
176(1083,21),
56a797ef
DO
177(1083,1083),
178(1087,1087);
9a6012eb 179
d55aa037
DO
180INSERT INTO `Config` (varname, varvalue, vartype, emptyok, is_hidden, description) VALUES
181('color_F','8fbfbf','string','no','yes','HSV: 180-25-75. Free atoms, they are available for allocation to objects.'),
182('color_A','bfbfbf','string','no','yes','HSV: 0-0-75. Absent atoms.'),
183('color_U','bf8f8f','string','no','yes','HSV: 0-25-75. Unusable atoms. Some problems keep them from being free.'),
184('color_T','408080','string','no','yes','HSV: 180-50-50. Taken atoms, object_id should be set for such.'),
185('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.'),
186('color_Tw','804040','string','no','yes','HSV: 0-50-50. Taken atoms with object problem. This is detected at runtime.'),
187('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.'),
188('default_port_type','24','uint','no','no','Default port type'),
189('MASSCOUNT','15','uint','no','no','"Fast" form is this many records tall'),
190('MAXSELSIZE','30','uint','no','no','<SELECT> lists height'),
191('enterprise','MyCompanyName','string','no','no','Organization name'),
192('ROW_SCALE','2','uint','no','no','Picture scale for rack row display'),
193('PORTS_PER_ROW','12','uint','no','no','Ports per row in VLANs tab'),
194('IPV4_ADDRS_PER_PAGE','256','uint','no','no','IPv4 addresses per page'),
195('DEFAULT_RACK_HEIGHT','42','uint','yes','no','Default rack height'),
196('DEFAULT_SLB_VS_PORT','','uint','yes','no','Default port of SLB virtual service'),
197('DEFAULT_SLB_RS_PORT','','uint','yes','no','Default port of SLB real server'),
198('DETECT_URLS','no','string','yes','no','Detect URLs in text fields'),
199('RACK_PRESELECT_THRESHOLD','1','uint','no','no','Rack pre-selection threshold'),
200('DEFAULT_IPV4_RS_INSERVICE','no','string','no','no','Inservice status for new SLB real servers'),
201('AUTOPORTS_CONFIG','4 = 1*33*kvm + 2*24*eth%u;15 = 1*446*kvm','string','yes','no','AutoPorts configuration'),
202('DEFAULT_OBJECT_TYPE','4','uint','yes','no','Default object type for new objects'),
203('SHOW_EXPLICIT_TAGS','yes','string','no','no','Show explicit tags'),
204('SHOW_IMPLICIT_TAGS','yes','string','no','no','Show implicit tags'),
205('SHOW_AUTOMATIC_TAGS','no','string','no','no','Show automatic tags'),
206('IPV4_AUTO_RELEASE','1','uint','no','no','Auto-release IPv4 addresses on allocation'),
207('SHOW_LAST_TAB','no','string','yes','no','Remember last tab shown for each page'),
208('EXT_IPV4_VIEW','yes','string','no','no','Extended IPv4 view'),
209('TREE_THRESHOLD','25','uint','yes','no','Tree view auto-collapse threshold'),
210('IPV4_JAYWALK','no','string','no','no','Enable IPv4 address allocations w/o covering network'),
211('ADDNEW_AT_TOP','yes','string','no','no','Render "add new" line at top of the list'),
212('IPV4_TREE_SHOW_USAGE','yes','string','no','no','Show address usage in IPv4 tree'),
213('PREVIEW_TEXT_MAXCHARS','10240','uint','yes','no','Max chars for text file preview'),
214('PREVIEW_TEXT_ROWS','25','uint','yes','no','Rows for text file preview'),
215('PREVIEW_TEXT_COLS','80','uint','yes','no','Columns for text file preview'),
216('PREVIEW_IMAGE_MAXPXS','320','uint','yes','no','Max pixels per axis for image file preview'),
217('VENDOR_SIEVE','','string','yes','no','Vendor sieve configuration'),
218('IPV4LB_LISTSRC','{$typeid_4}','string','yes','no','List source: IPv4 load balancers'),
219('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'),
220('IPV4NAT_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8}','string','yes','no','List source: IPv4 NAT performers'),
221('ASSETWARN_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8}','string','yes','no','List source: object, for which asset tag should be set'),
222('NAMEWARN_LISTSRC','{$typeid_4} or {$typeid_7} or {$typeid_8}','string','yes','no','List source: object, for which common name should be set'),
084aca6c 223('RACKS_PER_ROW','12','uint','yes','no','Racks per row'),
590e1281 224('FILTER_PREDICATE_SIEVE','','string','yes','no','Predicate sieve regex(7)'),
23cdc7e9
DO
225('FILTER_DEFAULT_ANDOR','or','string','no','no','Default list filter boolean operation (or/and)'),
226('FILTER_SUGGEST_ANDOR','yes','string','no','no','Suggest and/or selector in list filter'),
227('FILTER_SUGGEST_TAGS','yes','string','no','no','Suggest tags in list filter'),
228('FILTER_SUGGEST_PREDICATES','yes','string','no','no','Suggest predicates in list filter'),
229('FILTER_SUGGEST_EXTRA','no','string','no','no','Suggest extra expression in list filter'),
49b605d9 230('DEFAULT_SNMP_COMMUNITY','public','string','no','no','Default SNMP Community string'),
f06fe423 231('IPV4_ENABLE_KNIGHT','yes','string','no','no','Enable IPv4 knight feature'),
9e51318b
DO
232('TAGS_TOPLIST_SIZE','50','uint','yes','no','Tags top list size'),
233('TAGS_QUICKLIST_SIZE','20','uint','no','no','Tags quick list size'),
234('TAGS_QUICKLIST_THRESHOLD','50','uint','yes','no','Tags quick list threshold'),
f44fdef9 235('ENABLE_MULTIPORT_FORM','no','string','no','no','Enable "Add/update multiple ports" form'),
e49d8a77 236('DB_VERSION','0.17.4','string','no','yes','Database version.');
032a2fb2 237
d35cd472 238INSERT INTO `Script` VALUES ('RackCode','allow {$userid_1}');