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