add SNMP support for 3560E-12SD (#564)
[racktables] / scripts / init-sample-racks.sql
CommitLineData
58652ac1
DY
1set names 'utf8';
2
9b8174d7 3INSERT INTO `Object` (id, name, label, objtype_id, asset_no, has_problems, comment) VALUES
e1add254
AD
4(905,'london router','bbrtr1',7,'net247','no',NULL),
5(906,'londonswitch1','',8,NULL,'no',NULL),
6(907,'New-York router 1','bbrtr2a',7,'net55','no',NULL),
81659c05
AD
7(908,'moscow router','bbrtr3',7,NULL,'no',NULL),
8(909,'tokyo router','bbrtr4',7,NULL,'no',NULL),
e1add254
AD
9(910,'London server 1','lserver01',4,'srv500','no',NULL),
10(911,'London server 2','lserver02',4,'srv501','no',NULL),
11(912,'London server 3','lserver03',4,'srv502','no',NULL),
81659c05 12(913,'London server 4','lserver04',4,'srv503','yes','this one needs replacement'),
e1add254
AD
13(914,'London server 5','lserver05',4,'srv504','no',NULL),
14(915,'london LB','llb',8,'net1000','no',NULL),
15(916,'shared storage','',5,NULL,'no',NULL),
16(917,'london-NAS','',7,'net1001','no',NULL),
81659c05
AD
17(918,'London server 6','lserver06',4,'srv505','no',NULL),
18(919,'London server 7','lserver07',4,'srv506','no',NULL),
19(920,'backup library','lbackup',6,'misc200','no',NULL),
20(921,'lserver06 array','lserver06 array',5,NULL,'no',NULL),
21(922,'lserver07 array','lserver07 array',5,NULL,'no',NULL),
22(923,'Tokyo server 1','tserver01',4,'srv654','no',NULL),
23(924,'Tokyo server 2','tserver02',4,'srv848','no',NULL),
24(925,'Tokyo server 3','tserver03',4,'srv139','no',NULL),
25(926,'Tokyo switch','tswitch',8,'net385','no',NULL),
26(927,'New-York router 2','bbrtr2b',7,'net498','no',NULL),
27(928,'New-York IPVS LB A','nylba',4,'net554','no',NULL),
28(929,'New-York IPVS LB B','nylbb',4,'net555','no',NULL),
29(930,'New-York server switch A','nyswitcha',8,'net084','no',NULL),
30(931,'New-York server switch B','nyswitchb',8,'net486','no',NULL),
31(932,'New-York server 1A','nysrv1a',4,'srv287','no',NULL),
32(933,'New-York server 1B','nysrv1b',4,'srv288','no',NULL),
33(934,'New-York server 2A','nysrv2a',4,NULL,'no',NULL),
34(935,'New-York server 2B','nysrv2b',4,NULL,'no',NULL),
35(936,'New-York server 3A','nysrv3a',4,NULL,'no',NULL),
36(937,'New-York server 3B','nysrv3b',4,NULL,'no',NULL),
37(938,'New-York server 4A','nysrv4a',4,NULL,'no',NULL),
38(939,'New-York server 4B','nysrv4b',4,NULL,'no',NULL),
39(940,'New-York server 5A','nysrv5a',4,NULL,'no',NULL),
40(941,'New-York server 5B','nysrv5b',4,NULL,'no',NULL),
e1add254
AD
41(942,'wing A UPS',NULL,12,NULL,'no',NULL),
42(943,'wing B UPS',NULL,12,NULL,'no',NULL),
43(944,'network UPS',NULL,12,NULL,'no',NULL),
44(945,NULL,NULL,9,NULL,'no',NULL),
45(946,NULL,NULL,9,NULL,'no',NULL),
46(947,NULL,NULL,2,NULL,'no',NULL),
47(948,NULL,NULL,2,NULL,'no',NULL),
48(949,NULL,NULL,2,NULL,'no',NULL),
49(950,NULL,NULL,2,NULL,'no',NULL),
50(951,NULL,NULL,2,NULL,'no',NULL),
51(952,NULL,NULL,2,NULL,'no',NULL),
52(953,NULL,NULL,2,NULL,'no',NULL),
53(954,NULL,NULL,2,NULL,'no',NULL),
54(955,NULL,NULL,2,NULL,'no',NULL),
55(956,'mps1',NULL,4,NULL,'no',NULL),
56(957,'mps2',NULL,4,NULL,'no',NULL),
57(958,'mps3',NULL,4,NULL,'no',NULL),
58(959,'mps4',NULL,4,NULL,'no',NULL),
59(960,'mps5',NULL,4,NULL,'no',NULL),
60(961,'mskswitch',NULL,8,'sw0001','no',NULL),
61(962,'moscow kvm switch',NULL,445,'sw0002','no',NULL),
62(963,'Row 1',NULL,1561,NULL,'no',NULL),
63(964,'Row A',NULL,1561,NULL,'no',NULL),
64(965,'CF-4',NULL,1561,NULL,'no',NULL),
65(966,'Row 1',NULL,1561,NULL,'no',NULL),
66(967,'L01',NULL,1560,NULL,'no','test'),
67(968,'L02',NULL,1560,NULL,'no','network equipment mini-rack'),
68(969,'L03',NULL,1560,NULL,'no',NULL),
69(970,'NY100',NULL,1560,NULL,'no',NULL),
70(971,'NY101',NULL,1560,NULL,'no','server farm wing A'),
71(972,'M01',NULL,1560,NULL,'no',NULL),
72(973,'NY102',NULL,1560,NULL,'no','server farm wing B'),
73(974,'T01',NULL,1560,NULL,'no',NULL),
74(975,'Moscow',NULL,1562,NULL,'no',NULL),
75(976,'Tokyo',NULL,1562,NULL,'no',NULL),
76(977,'New-York',NULL,1562,NULL,'no',NULL),
77(978,'London',NULL,1562,NULL,'no',NULL);
9b8174d7
AD
78
79INSERT INTO `EntityLink` (`parent_entity_type`, `parent_entity_id`, `child_entity_type`, `child_entity_id`) VALUES
e1add254
AD
80('row',966,'rack',967),
81('row',966,'rack',968),
82('row',966,'rack',969),
83('row',965,'rack',970),
84('row',965,'rack',971),
85('row',963,'rack',972),
86('row',965,'rack',973),
87('row',964,'rack',974),
88('location',975,'row',963),
89('location',976,'row',964),
90('location',977,'row',965),
91('location',978,'row',966);
cafd4cf3 92
3e74655e
DO
93INSERT INTO `AttributeValue` VALUES (905,7,2,NULL,269,NULL);
94INSERT INTO `AttributeValue` VALUES (906,8,2,NULL,165,NULL);
95INSERT INTO `AttributeValue` VALUES (915,8,2,NULL,118,NULL);
96INSERT INTO `AttributeValue` VALUES (915,8,4,NULL,245,NULL);
97INSERT INTO `AttributeValue` VALUES (917,7,2,NULL,267,NULL);
98INSERT INTO `AttributeValue` VALUES (916,5,2,NULL,320,NULL);
99INSERT INTO `AttributeValue` VALUES (910,4,2,NULL,57,NULL);
100INSERT INTO `AttributeValue` VALUES (910,4,4,NULL,220,NULL);
101INSERT INTO `AttributeValue` VALUES (911,4,4,NULL,220,NULL);
102INSERT INTO `AttributeValue` VALUES (911,4,2,NULL,57,NULL);
103INSERT INTO `AttributeValue` VALUES (912,4,4,NULL,220,NULL);
104INSERT INTO `AttributeValue` VALUES (912,4,2,NULL,57,NULL);
105INSERT INTO `AttributeValue` VALUES (913,4,2,NULL,57,NULL);
106INSERT INTO `AttributeValue` VALUES (913,4,4,NULL,220,NULL);
107INSERT INTO `AttributeValue` VALUES (914,4,2,NULL,57,NULL);
108INSERT INTO `AttributeValue` VALUES (914,4,4,NULL,220,NULL);
109INSERT INTO `AttributeValue` VALUES (918,4,2,NULL,88,NULL);
110INSERT INTO `AttributeValue` VALUES (918,4,4,NULL,220,NULL);
111INSERT INTO `AttributeValue` VALUES (919,4,2,NULL,88,NULL);
112INSERT INTO `AttributeValue` VALUES (919,4,4,NULL,220,NULL);
113INSERT INTO `AttributeValue` VALUES (920,6,2,NULL,326,NULL);
114INSERT INTO `AttributeValue` VALUES (921,5,2,NULL,318,NULL);
115INSERT INTO `AttributeValue` VALUES (922,5,2,NULL,318,NULL);
116INSERT INTO `AttributeValue` VALUES (923,4,2,NULL,102,NULL);
117INSERT INTO `AttributeValue` VALUES (923,4,4,NULL,233,NULL);
118INSERT INTO `AttributeValue` VALUES (926,8,2,NULL,126,NULL);
119INSERT INTO `AttributeValue` VALUES (926,8,4,NULL,244,NULL);
120INSERT INTO `AttributeValue` VALUES (925,4,2,NULL,102,NULL);
121INSERT INTO `AttributeValue` VALUES (925,4,4,NULL,233,NULL);
122INSERT INTO `AttributeValue` VALUES (924,4,2,NULL,102,NULL);
123INSERT INTO `AttributeValue` VALUES (924,4,4,NULL,233,NULL);
124INSERT INTO `AttributeValue` VALUES (907,7,2,NULL,269,NULL);
125INSERT INTO `AttributeValue` VALUES (907,7,4,NULL,258,NULL);
126INSERT INTO `AttributeValue` VALUES (927,7,2,NULL,269,NULL);
127INSERT INTO `AttributeValue` VALUES (927,7,4,NULL,258,NULL);
128INSERT INTO `AttributeValue` VALUES (956,4,2,NULL,62,NULL);
129INSERT INTO `AttributeValue` VALUES (956,4,4,NULL,791,NULL);
130INSERT INTO `AttributeValue` VALUES (957,4,2,NULL,62,NULL);
131INSERT INTO `AttributeValue` VALUES (957,4,4,NULL,791,NULL);
132INSERT INTO `AttributeValue` VALUES (958,4,2,NULL,62,NULL);
133INSERT INTO `AttributeValue` VALUES (958,4,4,NULL,791,NULL);
134INSERT INTO `AttributeValue` VALUES (959,4,2,NULL,62,NULL);
135INSERT INTO `AttributeValue` VALUES (959,4,4,NULL,791,NULL);
136INSERT INTO `AttributeValue` VALUES (960,4,2,NULL,62,NULL);
137INSERT INTO `AttributeValue` VALUES (960,4,4,NULL,791,NULL);
138INSERT INTO `AttributeValue` VALUES (961,8,2,NULL,755,NULL);
139INSERT INTO `AttributeValue` VALUES (962,445,2,NULL,470,NULL);
140INSERT INTO `AttributeValue` VALUES (967,1560,27,NULL,42,NULL);
141INSERT INTO `AttributeValue` VALUES (968,1560,27,NULL,12,NULL);
142INSERT INTO `AttributeValue` VALUES (969,1560,27,NULL,42,NULL);
143INSERT INTO `AttributeValue` VALUES (970,1560,27,NULL,16,NULL);
144INSERT INTO `AttributeValue` VALUES (971,1560,27,NULL,42,NULL);
145INSERT INTO `AttributeValue` VALUES (972,1560,27,NULL,42,NULL);
146INSERT INTO `AttributeValue` VALUES (973,1560,27,NULL,42,NULL);
147INSERT INTO `AttributeValue` VALUES (974,1560,27,NULL,16,NULL);
e673ee24 148
706ce117
DO
149INSERT INTO `IPv4Address` VALUES (180879678,'default gw','no');
150INSERT INTO `IPv4Address` VALUES (180879617,'',NULL);
151INSERT INTO `IPv4Address` VALUES (180879680,'network','yes');
152INSERT INTO `IPv4Address` VALUES (180879743,'broadcast','yes');
153INSERT INTO `IPv4Address` VALUES (180879681,'',NULL);
154INSERT INTO `IPv4Address` VALUES (180879683,'',NULL);
155INSERT INTO `IPv4Address` VALUES (180879684,'',NULL);
156INSERT INTO `IPv4Address` VALUES (180879685,'',NULL);
157INSERT INTO `IPv4Address` VALUES (180879616,'network','yes');
158INSERT INTO `IPv4Address` VALUES (180879679,'broadcast','yes');
159INSERT INTO `IPv4Address` VALUES (180879686,'',NULL);
160INSERT INTO `IPv4Address` VALUES (180879687,'',NULL);
161INSERT INTO `IPv4Address` VALUES (180879360,'',NULL);
162INSERT INTO `IPv4Address` VALUES (180879361,'',NULL);
163INSERT INTO `IPv4Address` VALUES (180880192,'network','yes');
164INSERT INTO `IPv4Address` VALUES (180880255,'broadcast','yes');
165INSERT INTO `IPv4Address` VALUES (180880448,'network','yes');
166INSERT INTO `IPv4Address` VALUES (180880511,'broadcast','yes');
167INSERT INTO `IPv4Address` VALUES (180880384,'network','yes');
168INSERT INTO `IPv4Address` VALUES (180880447,'broadcast','yes');
169INSERT INTO `IPv4Address` VALUES (180880128,'network','no');
170INSERT INTO `IPv4Address` VALUES (180880191,'broadcast','no');
171INSERT INTO `IPv4Address` VALUES (180879936,'network','yes');
172INSERT INTO `IPv4Address` VALUES (180879999,'broadcast','yes');
173INSERT INTO `IPv4Address` VALUES (180879872,'network','yes');
174INSERT INTO `IPv4Address` VALUES (180879935,'broadcast','yes');
175INSERT INTO `IPv4Address` VALUES (180880193,'',NULL);
176INSERT INTO `IPv4Address` VALUES (180880194,'',NULL);
177INSERT INTO `IPv4Address` VALUES (180880195,'',NULL);
178INSERT INTO `IPv4Address` VALUES (180879618,'',NULL);
179INSERT INTO `IPv4Address` VALUES (180879677,'',NULL);
180INSERT INTO `IPv4Address` VALUES (180879676,'',NULL);
181INSERT INTO `IPv4Address` VALUES (180879675,'',NULL);
182INSERT INTO `IPv4Address` VALUES (180880254,'',NULL);
183INSERT INTO `IPv4Address` VALUES (180880504,'for field engineer','yes');
e673ee24 184
706ce117
DO
185INSERT INTO `IPv4Allocation` VALUES (905,180879678,'fa2/0','router');
186INSERT INTO `IPv4Allocation` VALUES (906,180879617,'','regular');
187INSERT INTO `IPv4Allocation` VALUES (910,180879681,'eth0','regular');
188INSERT INTO `IPv4Allocation` VALUES (911,180879682,'eth0','regular');
189INSERT INTO `IPv4Allocation` VALUES (912,180879683,'eth0','regular');
190INSERT INTO `IPv4Allocation` VALUES (913,180879684,'eth0','regular');
191INSERT INTO `IPv4Allocation` VALUES (914,180879685,'eth0','regular');
192INSERT INTO `IPv4Allocation` VALUES (918,180879686,'bge0','regular');
193INSERT INTO `IPv4Allocation` VALUES (919,180879687,'bge0','regular');
194INSERT INTO `IPv4Allocation` VALUES (908,180879360,'se1/0','regular');
195INSERT INTO `IPv4Allocation` VALUES (905,180879361,'se1/1','regular');
196INSERT INTO `IPv4Allocation` VALUES (923,180880193,'eth0','regular');
197INSERT INTO `IPv4Allocation` VALUES (924,180880194,'eth0','regular');
198INSERT INTO `IPv4Allocation` VALUES (925,180880195,'eth0','regular');
199INSERT INTO `IPv4Allocation` VALUES (915,180879618,'telnet access','regular');
200INSERT INTO `IPv4Allocation` VALUES (915,180879677,'VIP3','regular');
201INSERT INTO `IPv4Allocation` VALUES (915,180879676,'VIP2','regular');
202INSERT INTO `IPv4Allocation` VALUES (915,180879675,'VIP1','regular');
203INSERT INTO `IPv4Allocation` VALUES (910,180879675,'','virtual');
204INSERT INTO `IPv4Allocation` VALUES (911,180879675,'','virtual');
205INSERT INTO `IPv4Allocation` VALUES (912,180879675,'','virtual');
206INSERT INTO `IPv4Allocation` VALUES (919,180879677,'','virtual');
207INSERT INTO `IPv4Allocation` VALUES (918,180879677,'','virtual');
208INSERT INTO `IPv4Allocation` VALUES (909,180880254,'fa2/0','router');
209INSERT INTO `IPv4Allocation` VALUES (907,180879363,'se1/1','regular');
210INSERT INTO `IPv4Allocation` VALUES (905,180879362,'se1/0','regular');
211INSERT INTO `IPv4Allocation` VALUES (914,180879676,'','virtual');
212INSERT INTO `IPv4Allocation` VALUES (913,180879676,'','virtual');
213INSERT INTO `IPv4Allocation` VALUES (932,180879973,'','regular');
214INSERT INTO `IPv4Allocation` VALUES (934,180879974,'','regular');
215INSERT INTO `IPv4Allocation` VALUES (936,180879975,'','regular');
216INSERT INTO `IPv4Allocation` VALUES (938,180879976,'','regular');
217INSERT INTO `IPv4Allocation` VALUES (940,180879977,'','regular');
218INSERT INTO `IPv4Allocation` VALUES (933,180879978,'','regular');
219INSERT INTO `IPv4Allocation` VALUES (935,180879979,'','regular');
220INSERT INTO `IPv4Allocation` VALUES (937,180879980,'','regular');
221INSERT INTO `IPv4Allocation` VALUES (939,180879981,'','regular');
222INSERT INTO `IPv4Allocation` VALUES (941,180879982,'','regular');
223INSERT INTO `IPv4Allocation` VALUES (928,180879877,'','regular');
224INSERT INTO `IPv4Allocation` VALUES (929,180879878,'','regular');
225INSERT INTO `IPv4Allocation` VALUES (956,180880449,'eth0','regular');
226INSERT INTO `IPv4Allocation` VALUES (957,180880450,'eth0','regular');
227INSERT INTO `IPv4Allocation` VALUES (958,180880451,'eth0','regular');
228INSERT INTO `IPv4Allocation` VALUES (959,180880452,'eth0','regular');
229INSERT INTO `IPv4Allocation` VALUES (960,180880453,'eth0','regular');
230INSERT INTO `IPv4Allocation` VALUES (908,180880510,'fa2/0','router');
231INSERT INTO `IPv4Allocation` VALUES (962,180880386,'','regular');
232INSERT INTO `IPv4Allocation` VALUES (909,180879366,'se1/0','regular');
233INSERT INTO `IPv4Allocation` VALUES (908,180879367,'se1/1','regular');
234INSERT INTO `IPv4Allocation` VALUES (909,180879365,'se1/1','regular');
235INSERT INTO `IPv4Allocation` VALUES (907,180879364,'se1/0','regular');
236INSERT INTO `IPv4Allocation` VALUES (907,180879998,'','shared');
237INSERT INTO `IPv4Allocation` VALUES (927,180879998,'','shared');
238INSERT INTO `IPv4Allocation` VALUES (908,180880446,'fa1/0','router');
239INSERT INTO `IPv4Allocation` VALUES (961,180880385,'','regular');
1365dddb 240
ce1f34ef
AA
241INSERT INTO `IPv6Allocation` VALUES ('908', 0xFC0014500001BEEF0000000000000001, 'fa1/0', 'router');
242INSERT INTO `IPv6Allocation` VALUES ('919', 0xFC0014500001DEAD0000000000000001, 'bge1', 'router');
20ac2076 243
706ce117
DO
244INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (96,180879616,26,'London network devices and VIPs');
245INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (97,180879680,26,'London HA server farm');
246INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (98,180879872,26,'New-York network devices');
247INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (99,180879936,26,'New-York servers');
248INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (108,180880192,26,'Tokyo server farm');
249INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (102,180879360,31,'M-L P2P');
250INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (103,180879362,31,'L-NY P2P');
251INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (104,180879364,31,'NY-T P2P');
252INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (105,180879366,31,'T-M P2P');
253INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (106,180880384,26,'Moscow network devices');
254INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (107,180880448,26,'Moscow servers');
e673ee24 255
ce1f34ef
AA
256INSERT INTO `IPv6Network` (`id`, `ip`, `mask`, `last_ip`, `name`, `comment`) VALUES ('1', 0xFC000000000000000000000000000000, '7', 0xFDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF, 'Local IPv6', null);
257INSERT INTO `IPv6Network` (`id`, `ip`, `mask`, `last_ip`, `name`, `comment`) VALUES ('2', 0xFC001450000100000000000000000000, '48', 0xFC0014500001FFFFFFFFFFFFFFFFFFFF, 'v6 Suballoc 1', null);
258INSERT INTO `IPv6Network` (`id`, `ip`, `mask`, `last_ip`, `name`, `comment`) VALUES ('3', 0xFC001450000200000000000000000000, '48', 0xFC0014500002FFFFFFFFFFFFFFFFFFFF, 'v6 Suballoc 2', null);
259INSERT INTO `IPv6Network` (`id`, `ip`, `mask`, `last_ip`, `name`, `comment`) VALUES ('4', 0xFC0014500001DEAD0000000000000000, '64', 0xFC0014500001DEADFFFFFFFFFFFFFFFF, 'dead net', null);
260INSERT INTO `IPv6Network` (`id`, `ip`, `mask`, `last_ip`, `name`, `comment`) VALUES ('5', 0xFC0014500001BEEF0000000000000000, '64', 0xFC0014500001BEEFFFFFFFFFFFFFFFFF, 'beef net', null);
20ac2076 261
4d87feaf
DO
262INSERT INTO `IPv4RSPool` VALUES (1,'Apache servers',NULL,NULL);
263INSERT INTO `IPv4RSPool` VALUES (2,'Resin servers',NULL,NULL);
264
cafd4cf3
DO
265INSERT INTO `IPv4VS` VALUES (1,180879877,80,'TCP','virtual web','lvs_sched wlc\r\nlvs_method NAT\r\ndelay_loop 3\r\nalpha\r\nomega\r\nquorum 3\r\nhysteresis 1\r\n\r\n# this is a comment\r\n# VS name is %VNAME%\r\n#\r\n','HTTP_GET {\r\nurl {\r\npath /\r\nstatus_code 200\r\n}\r\nconnect_timeout 1\r\n}');
266INSERT INTO `IPv4VS` VALUES (2,180879878,80,'TCP','virtual app','lvs_sched wlc\r\nlvs_method NAT\r\ndelay_loop 3\r\nalpha\r\nomega\r\nquorum 3\r\nhysteresis 1\r\n\r\n','HTTP_GET {\r\nurl {\r\npath /\r\nstatus_code 200\r\n}\r\nconnect_timeout 1\r\n}');
267
92ee2b01
AA
268INSERT INTO `IPv4LB` VALUES (928,1,1,NULL,NULL,NULL);
269INSERT INTO `IPv4LB` VALUES (929,1,1,NULL,NULL,NULL);
270INSERT INTO `IPv4LB` VALUES (929,2,2,NULL,NULL,NULL);
cafd4cf3 271
e2d09cef
AD
272INSERT INTO `IPv4RS` VALUES (1,'yes',180879973,80,1,NULL,NULL);
273INSERT INTO `IPv4RS` VALUES (2,'yes',180879974,80,1,NULL,NULL);
274INSERT INTO `IPv4RS` VALUES (3,'no',180879975,80,1,NULL,NULL);
275INSERT INTO `IPv4RS` VALUES (4,'yes',180879976,80,1,NULL,NULL);
276INSERT INTO `IPv4RS` VALUES (5,'yes',180879977,80,1,NULL,NULL);
277INSERT INTO `IPv4RS` VALUES (6,'no',180879978,8080,2,NULL,NULL);
278INSERT INTO `IPv4RS` VALUES (7,'yes',180879979,8080,2,NULL,NULL);
279INSERT INTO `IPv4RS` VALUES (8,'yes',180879980,8080,2,NULL,NULL);
280INSERT INTO `IPv4RS` VALUES (9,'yes',180879981,8080,2,NULL,NULL);
281INSERT INTO `IPv4RS` VALUES (10,'yes',180879982,8080,2,NULL,NULL);
1365dddb 282
fc8e1110
DO
283INSERT INTO PortInterfaceCompat (iif_id, oif_id) VALUES
284(1,32);
09d6afa4
DO
285INSERT INTO `Port` VALUES (3057,905,'se1/0',1,32,NULL,NULL,'');
286INSERT INTO `Port` VALUES (3058,905,'se1/1',1,32,NULL,NULL,'');
287INSERT INTO `Port` VALUES (3059,905,'fa2/0',1,19,'00000000A001',NULL,'');
288INSERT INTO `Port` VALUES (3060,905,'fa2/1',1,19,'00000000A002','ISP uplink','');
289INSERT INTO `Port` VALUES (3063,906,'gi1',1,24,'00000000B001',NULL,'1');
290INSERT INTO `Port` VALUES (3062,906,'gi2',1,24,'00000000B002',NULL,'2');
291INSERT INTO `Port` VALUES (3064,906,'gi3',1,24,'00000000B003',NULL,'3');
292INSERT INTO `Port` VALUES (3065,906,'gi4',1,24,'00000000B004',NULL,'4');
293INSERT INTO `Port` VALUES (3066,906,'gi5',1,24,'00000000B005',NULL,'5');
294INSERT INTO `Port` VALUES (3067,906,'gi6',1,24,'00000000B006',NULL,'6');
295INSERT INTO `Port` VALUES (3068,906,'gi7',1,24,'00000000B007',NULL,'7');
296INSERT INTO `Port` VALUES (3069,906,'gi8',1,24,'00000000B008',NULL,'8');
297INSERT INTO `Port` VALUES (3070,907,'se1/0',1,32,NULL,NULL,'');
298INSERT INTO `Port` VALUES (3071,907,'se1/1',1,32,NULL,NULL,'');
299INSERT INTO `Port` VALUES (3072,915,'e1',1,19,NULL,NULL,'1');
300INSERT INTO `Port` VALUES (3073,915,'e2',1,19,NULL,NULL,'2');
301INSERT INTO `Port` VALUES (3074,915,'e3',1,19,NULL,NULL,'3');
302INSERT INTO `Port` VALUES (3075,915,'e4',1,19,NULL,NULL,'4');
303INSERT INTO `Port` VALUES (3076,915,'e5',1,19,NULL,NULL,'5');
304INSERT INTO `Port` VALUES (3077,915,'e6',1,19,NULL,NULL,'6');
305INSERT INTO `Port` VALUES (3078,915,'e7',1,19,NULL,NULL,'7');
306INSERT INTO `Port` VALUES (3079,915,'e8',1,19,NULL,NULL,'8');
307INSERT INTO `Port` VALUES (3080,910,'eth0',1,24,NULL,NULL,'1');
308INSERT INTO `Port` VALUES (3081,910,'eth1',1,24,NULL,NULL,'2');
309INSERT INTO `Port` VALUES (3082,909,'se1/0',1,32,NULL,NULL,'');
310INSERT INTO `Port` VALUES (3083,909,'se1/1',1,32,NULL,NULL,'');
311INSERT INTO `Port` VALUES (3084,908,'se1/0',1,32,NULL,NULL,'');
312INSERT INTO `Port` VALUES (3085,908,'se1/1',1,32,NULL,NULL,'');
313INSERT INTO `Port` VALUES (3086,911,'eth0',1,24,NULL,NULL,'1');
314INSERT INTO `Port` VALUES (3087,911,'eth1',1,24,NULL,NULL,'2');
315INSERT INTO `Port` VALUES (3088,912,'eth0',1,24,NULL,NULL,'1');
316INSERT INTO `Port` VALUES (3089,912,'eth1',1,24,NULL,NULL,'2');
317INSERT INTO `Port` VALUES (3090,913,'eth0',1,24,NULL,NULL,'1');
318INSERT INTO `Port` VALUES (3091,913,'eth1',1,24,NULL,NULL,'2');
319INSERT INTO `Port` VALUES (3092,914,'eth0',1,24,NULL,NULL,'1');
320INSERT INTO `Port` VALUES (3093,914,'eth1',1,24,NULL,NULL,'2');
321INSERT INTO `Port` VALUES (3094,917,'fa0/0',1,19,NULL,NULL,'');
322INSERT INTO `Port` VALUES (3095,919,'bge0',1,24,NULL,NULL,'');
323INSERT INTO `Port` VALUES (3096,919,'bge1',1,24,NULL,NULL,'');
324INSERT INTO `Port` VALUES (3097,918,'bge0',1,24,NULL,NULL,'');
325INSERT INTO `Port` VALUES (3098,918,'bge1',1,24,NULL,NULL,'');
326INSERT INTO `Port` VALUES (3099,909,'fa2/0',1,19,NULL,NULL,'');
327INSERT INTO `Port` VALUES (3100,909,'fa2/1',1,19,NULL,'ISP uplink','');
328INSERT INTO `Port` VALUES (3101,926,'fa1',1,19,NULL,NULL,'1');
329INSERT INTO `Port` VALUES (3102,926,'fa2',1,19,NULL,NULL,'2');
330INSERT INTO `Port` VALUES (3103,926,'fa3',1,19,NULL,NULL,'3');
331INSERT INTO `Port` VALUES (3104,926,'fa4',1,19,NULL,NULL,'4');
332INSERT INTO `Port` VALUES (3105,926,'fa5',1,19,NULL,NULL,'5');
333INSERT INTO `Port` VALUES (3106,926,'fa6',1,19,NULL,NULL,'6');
334INSERT INTO `Port` VALUES (3107,926,'fa7',1,19,NULL,NULL,'7');
335INSERT INTO `Port` VALUES (3108,926,'fa8',1,19,NULL,NULL,'8');
336INSERT INTO `Port` VALUES (3109,926,'fa9',1,19,NULL,NULL,'9');
337INSERT INTO `Port` VALUES (3110,926,'fa10',1,19,NULL,NULL,'10');
338INSERT INTO `Port` VALUES (3111,926,'fa11',1,19,NULL,NULL,'11');
339INSERT INTO `Port` VALUES (3112,926,'fa12',1,19,NULL,NULL,'12');
340INSERT INTO `Port` VALUES (3113,923,'eth0',1,24,NULL,NULL,'1');
341INSERT INTO `Port` VALUES (3114,923,'eth1',1,24,NULL,NULL,'2');
342INSERT INTO `Port` VALUES (3115,924,'eth0',1,24,NULL,NULL,'1');
343INSERT INTO `Port` VALUES (3116,924,'eth1',1,24,NULL,NULL,'2');
344INSERT INTO `Port` VALUES (3117,925,'eth0',1,24,NULL,NULL,'1');
345INSERT INTO `Port` VALUES (3118,925,'eth1',1,24,NULL,NULL,'2');
346INSERT INTO `Port` VALUES (3119,908,'fa2/0',1,19,NULL,NULL,'');
347INSERT INTO `Port` VALUES (3120,908,'fa2/1',1,19,NULL,'ISP uplink','');
348INSERT INTO `Port` VALUES (3121,907,'fa2/0',1,19,NULL,NULL,'');
349INSERT INTO `Port` VALUES (3122,907,'fa2/1',1,19,NULL,NULL,'');
fc8e1110
DO
350INSERT INTO `Port` VALUES (3123,927,'gi3/0',3,1202,NULL,'ISP uplink','');
351INSERT INTO `Port` VALUES (3124,927,'gi4/0',3,1202,NULL,NULL,'');
352INSERT INTO `Port` VALUES (3125,907,'gi3/0',3,1202,NULL,'ISP uplink','');
353INSERT INTO `Port` VALUES (3126,907,'gi4/0',3,1202,NULL,NULL,'');
09d6afa4
DO
354INSERT INTO `Port` VALUES (3127,956,'kvm',1,33,NULL,NULL,'');
355INSERT INTO `Port` VALUES (3128,956,'eth0',1,24,NULL,NULL,'');
356INSERT INTO `Port` VALUES (3129,956,'eth1',1,24,NULL,NULL,'');
357INSERT INTO `Port` VALUES (3130,957,'kvm',1,33,NULL,NULL,'');
358INSERT INTO `Port` VALUES (3131,957,'eth0',1,24,NULL,NULL,'');
359INSERT INTO `Port` VALUES (3132,957,'eth1',1,24,NULL,NULL,'');
360INSERT INTO `Port` VALUES (3133,958,'kvm',1,33,NULL,NULL,'');
361INSERT INTO `Port` VALUES (3134,958,'eth0',1,24,NULL,NULL,'');
362INSERT INTO `Port` VALUES (3135,958,'eth1',1,24,NULL,NULL,'');
363INSERT INTO `Port` VALUES (3136,959,'kvm',1,33,NULL,NULL,'');
364INSERT INTO `Port` VALUES (3137,959,'eth0',1,24,NULL,NULL,'');
365INSERT INTO `Port` VALUES (3138,959,'eth1',1,24,NULL,NULL,'');
366INSERT INTO `Port` VALUES (3139,960,'kvm',1,33,NULL,NULL,'');
367INSERT INTO `Port` VALUES (3140,960,'eth0',1,24,NULL,NULL,'');
368INSERT INTO `Port` VALUES (3141,960,'eth1',1,24,NULL,NULL,'');
369INSERT INTO `Port` VALUES (3142,908,'con0',1,29,NULL,NULL,'console');
370INSERT INTO `Port` VALUES (3143,961,'1',1,24,'01040104AA00',NULL,'');
371INSERT INTO `Port` VALUES (3144,961,'2',1,24,'01040104AA01','for field engineer','');
372INSERT INTO `Port` VALUES (3145,961,'3',1,24,'01040104AA02',NULL,'');
373INSERT INTO `Port` VALUES (3146,961,'4',1,24,'01040104AA03',NULL,'');
374INSERT INTO `Port` VALUES (3147,961,'5',1,24,'01040104AA04',NULL,'');
375INSERT INTO `Port` VALUES (3148,961,'6',1,24,'01040104AA05',NULL,'');
376INSERT INTO `Port` VALUES (3149,961,'7',1,24,'01040104AA06',NULL,'');
377INSERT INTO `Port` VALUES (3150,961,'8',1,24,'01040104AA07',NULL,'');
378INSERT INTO `Port` VALUES (3151,961,'9',1,24,'01040104AA08',NULL,'');
379INSERT INTO `Port` VALUES (3152,961,'10',1,24,'01040104AA09',NULL,'');
380INSERT INTO `Port` VALUES (3153,961,'11',1,24,'01040104AA0A',NULL,'');
381INSERT INTO `Port` VALUES (3154,961,'12',1,24,'01040104AA0B',NULL,'');
382INSERT INTO `Port` VALUES (3155,961,'13',1,24,'01040104AA0C',NULL,'');
383INSERT INTO `Port` VALUES (3156,961,'14',1,24,'01040104AA0D',NULL,'');
384INSERT INTO `Port` VALUES (3157,961,'15',1,24,'01040104AA0E',NULL,'');
385INSERT INTO `Port` VALUES (3158,961,'16',1,24,'01040104AA0F',NULL,'');
386INSERT INTO `Port` VALUES (3159,961,'con',1,681,NULL,NULL,'console');
387INSERT INTO `Port` VALUES (3160,956,'ttyS0',1,681,NULL,NULL,'serial A');
388INSERT INTO `Port` VALUES (3161,956,'ttyS1',1,681,NULL,NULL,'serial B');
389INSERT INTO `Port` VALUES (3162,962,'tail1',1,446,NULL,NULL,'');
390INSERT INTO `Port` VALUES (3163,962,'tail2',1,446,NULL,NULL,'');
391INSERT INTO `Port` VALUES (3164,962,'tail3',1,446,NULL,NULL,'');
392INSERT INTO `Port` VALUES (3165,962,'tail4',1,446,NULL,NULL,'');
393INSERT INTO `Port` VALUES (3166,962,'tail5',1,446,NULL,NULL,'');
394INSERT INTO `Port` VALUES (3167,962,'tail6',1,446,NULL,NULL,'');
395INSERT INTO `Port` VALUES (3168,962,'tail7',1,446,NULL,NULL,'');
396INSERT INTO `Port` VALUES (3169,962,'tail8',1,446,NULL,NULL,'');
397INSERT INTO `Port` VALUES (3170,962,'head',1,33,NULL,'monitor connected','');
398INSERT INTO `Port` VALUES (3171,962,'net',1,19,'020002003333',NULL,'');
399INSERT INTO `Port` VALUES (3178,927,'fa1/0',1,19,NULL,NULL,'');
400INSERT INTO `Port` VALUES (3179,908,'fa1/0',1,19,NULL,NULL,'');
69323c6c
DO
401INSERT INTO `Port` VALUES (3180,955,'in',1,16,NULL,'from local distribution','');
402INSERT INTO `Port` VALUES (3181,955,'out1',1,1322,NULL,NULL,'');
403INSERT INTO `Port` VALUES (3182,955,'out2',1,1322,NULL,NULL,'');
404INSERT INTO `Port` VALUES (3183,955,'out3',1,1322,NULL,NULL,'');
405INSERT INTO `Port` VALUES (3184,955,'out4',1,1322,NULL,NULL,'');
406INSERT INTO `Port` VALUES (3185,955,'out5',1,1322,NULL,NULL,'');
407INSERT INTO `Port` VALUES (3186,923,'ps',1,16,NULL,NULL,'');
408INSERT INTO `Port` VALUES (3187,924,'ps',1,16,NULL,NULL,'');
409INSERT INTO `Port` VALUES (3188,925,'ps',1,16,NULL,NULL,'');
410INSERT INTO `Port` VALUES (3189,926,'ps',1,16,NULL,NULL,'');
411INSERT INTO `Port` VALUES (3190,909,'ps',1,16,NULL,NULL,'');
e673ee24 412
d344ae81
DO
413INSERT INTO `Link` VALUES (3057,3071,NULL);
414INSERT INTO `Link` VALUES (3058,3084,NULL);
415INSERT INTO `Link` VALUES (3059,3069,NULL);
416INSERT INTO `Link` VALUES (3062,3094,NULL);
417INSERT INTO `Link` VALUES (3063,3079,NULL);
418INSERT INTO `Link` VALUES (3070,3083,NULL);
419INSERT INTO `Link` VALUES (3072,3080,NULL);
420INSERT INTO `Link` VALUES (3073,3086,NULL);
421INSERT INTO `Link` VALUES (3074,3088,NULL);
422INSERT INTO `Link` VALUES (3075,3090,NULL);
423INSERT INTO `Link` VALUES (3076,3092,NULL);
424INSERT INTO `Link` VALUES (3077,3097,NULL);
425INSERT INTO `Link` VALUES (3078,3095,NULL);
426INSERT INTO `Link` VALUES (3082,3085,NULL);
427INSERT INTO `Link` VALUES (3099,3112,NULL);
428INSERT INTO `Link` VALUES (3101,3113,NULL);
429INSERT INTO `Link` VALUES (3102,3114,NULL);
430INSERT INTO `Link` VALUES (3103,3115,NULL);
431INSERT INTO `Link` VALUES (3104,3116,NULL);
432INSERT INTO `Link` VALUES (3105,3117,NULL);
433INSERT INTO `Link` VALUES (3106,3118,NULL);
434INSERT INTO `Link` VALUES (3142,3160,NULL);
435INSERT INTO `Link` VALUES (3159,3161,NULL);
436INSERT INTO `Link` VALUES (3134,3143,NULL);
437INSERT INTO `Link` VALUES (3119,3147,NULL);
438INSERT INTO `Link` VALUES (3131,3148,NULL);
439INSERT INTO `Link` VALUES (3137,3151,NULL);
440INSERT INTO `Link` VALUES (3140,3154,NULL);
441INSERT INTO `Link` VALUES (3128,3158,NULL);
442INSERT INTO `Link` VALUES (3127,3162,NULL);
443INSERT INTO `Link` VALUES (3130,3163,NULL);
444INSERT INTO `Link` VALUES (3133,3164,NULL);
445INSERT INTO `Link` VALUES (3136,3165,NULL);
446INSERT INTO `Link` VALUES (3139,3168,NULL);
447INSERT INTO `Link` VALUES (3145,3171,NULL);
448INSERT INTO `Link` VALUES (3124,3126,NULL);
449INSERT INTO `Link` VALUES (3181,3186,NULL);
450INSERT INTO `Link` VALUES (3182,3187,NULL);
451INSERT INTO `Link` VALUES (3183,3190,NULL);
452INSERT INTO `Link` VALUES (3184,3188,NULL);
453INSERT INTO `Link` VALUES (3185,3189,NULL);
f000e1cd 454
706ce117
DO
455INSERT INTO `IPv4NAT` (`object_id`, `proto`, `localip`, `localport`, `remoteip`, `remoteport`, `description`) VALUES (915,'TCP',180879675,80,180879681,80,'');
456INSERT INTO `IPv4NAT` (`object_id`, `proto`, `localip`, `localport`, `remoteip`, `remoteport`, `description`) VALUES (915,'TCP',180879675,80,180879682,80,'');
457INSERT INTO `IPv4NAT` (`object_id`, `proto`, `localip`, `localport`, `remoteip`, `remoteport`, `description`) VALUES (915,'TCP',180879675,80,180879683,80,'');
458INSERT INTO `IPv4NAT` (`object_id`, `proto`, `localip`, `localport`, `remoteip`, `remoteport`, `description`) VALUES (915,'UDP',180879676,53,180879684,53,'');
459INSERT INTO `IPv4NAT` (`object_id`, `proto`, `localip`, `localport`, `remoteip`, `remoteport`, `description`) VALUES (915,'UDP',180879676,53,180879685,53,'');
460INSERT INTO `IPv4NAT` (`object_id`, `proto`, `localip`, `localport`, `remoteip`, `remoteport`, `description`) VALUES (915,'TCP',180879677,443,180879686,443,'');
461INSERT INTO `IPv4NAT` (`object_id`, `proto`, `localip`, `localport`, `remoteip`, `remoteport`, `description`) VALUES (915,'TCP',180879677,443,180879687,443,'');
e673ee24 462
9b8174d7
AD
463INSERT INTO `RackSpace` VALUES (968,9,'interior','T',905);
464INSERT INTO `RackSpace` VALUES (968,9,'front','T',905);
465INSERT INTO `RackSpace` VALUES (968,10,'interior','T',905);
466INSERT INTO `RackSpace` VALUES (968,10,'front','T',905);
467INSERT INTO `RackSpace` VALUES (968,11,'interior','T',905);
468INSERT INTO `RackSpace` VALUES (968,11,'front','T',905);
469INSERT INTO `RackSpace` VALUES (968,7,'front','T',906);
470INSERT INTO `RackSpace` VALUES (968,7,'interior','T',906);
471INSERT INTO `RackSpace` VALUES (970,16,'interior','T',907);
472INSERT INTO `RackSpace` VALUES (970,16,'rear','T',907);
473INSERT INTO `RackSpace` VALUES (970,15,'interior','T',907);
474INSERT INTO `RackSpace` VALUES (970,15,'rear','T',907);
475INSERT INTO `RackSpace` VALUES (970,14,'interior','T',907);
476INSERT INTO `RackSpace` VALUES (970,14,'rear','T',907);
477INSERT INTO `RackSpace` VALUES (974,15,'interior','T',909);
478INSERT INTO `RackSpace` VALUES (974,15,'rear','T',909);
479INSERT INTO `RackSpace` VALUES (974,14,'interior','T',909);
480INSERT INTO `RackSpace` VALUES (974,14,'rear','T',909);
481INSERT INTO `RackSpace` VALUES (974,13,'interior','T',909);
482INSERT INTO `RackSpace` VALUES (974,13,'rear','T',909);
483INSERT INTO `RackSpace` VALUES (972,20,'interior','T',908);
484INSERT INTO `RackSpace` VALUES (972,20,'rear','T',908);
485INSERT INTO `RackSpace` VALUES (972,19,'interior','T',908);
486INSERT INTO `RackSpace` VALUES (972,19,'rear','T',908);
487INSERT INTO `RackSpace` VALUES (972,18,'interior','T',908);
488INSERT INTO `RackSpace` VALUES (972,18,'rear','T',908);
489INSERT INTO `RackSpace` VALUES (967,2,'front','T',910);
490INSERT INTO `RackSpace` VALUES (967,2,'interior','T',910);
491INSERT INTO `RackSpace` VALUES (967,2,'rear','T',910);
492INSERT INTO `RackSpace` VALUES (967,4,'front','T',911);
493INSERT INTO `RackSpace` VALUES (967,4,'interior','T',911);
494INSERT INTO `RackSpace` VALUES (967,4,'rear','T',911);
495INSERT INTO `RackSpace` VALUES (967,6,'front','T',912);
496INSERT INTO `RackSpace` VALUES (967,6,'interior','T',912);
497INSERT INTO `RackSpace` VALUES (967,6,'rear','T',912);
498INSERT INTO `RackSpace` VALUES (967,8,'front','T',913);
499INSERT INTO `RackSpace` VALUES (967,8,'interior','T',913);
500INSERT INTO `RackSpace` VALUES (967,8,'rear','T',913);
501INSERT INTO `RackSpace` VALUES (967,10,'front','T',914);
502INSERT INTO `RackSpace` VALUES (967,10,'interior','T',914);
503INSERT INTO `RackSpace` VALUES (967,10,'rear','T',914);
504INSERT INTO `RackSpace` VALUES (967,23,'rear','T',916);
505INSERT INTO `RackSpace` VALUES (967,23,'interior','T',916);
506INSERT INTO `RackSpace` VALUES (967,23,'front','T',916);
507INSERT INTO `RackSpace` VALUES (968,5,'front','T',915);
508INSERT INTO `RackSpace` VALUES (968,5,'interior','T',915);
509INSERT INTO `RackSpace` VALUES (968,4,'interior','T',915);
510INSERT INTO `RackSpace` VALUES (968,4,'front','T',915);
511INSERT INTO `RackSpace` VALUES (967,22,'front','T',916);
512INSERT INTO `RackSpace` VALUES (967,22,'interior','T',916);
513INSERT INTO `RackSpace` VALUES (967,22,'rear','T',916);
514INSERT INTO `RackSpace` VALUES (969,7,'front','T',918);
515INSERT INTO `RackSpace` VALUES (969,7,'interior','T',918);
516INSERT INTO `RackSpace` VALUES (969,7,'rear','T',918);
517INSERT INTO `RackSpace` VALUES (969,6,'front','T',918);
518INSERT INTO `RackSpace` VALUES (969,6,'interior','T',918);
519INSERT INTO `RackSpace` VALUES (969,6,'rear','T',918);
520INSERT INTO `RackSpace` VALUES (969,5,'front','T',918);
521INSERT INTO `RackSpace` VALUES (969,5,'interior','T',918);
522INSERT INTO `RackSpace` VALUES (969,5,'rear','T',918);
523INSERT INTO `RackSpace` VALUES (969,4,'front','T',918);
524INSERT INTO `RackSpace` VALUES (969,4,'interior','T',918);
525INSERT INTO `RackSpace` VALUES (969,4,'rear','T',918);
526INSERT INTO `RackSpace` VALUES (969,3,'front','T',918);
527INSERT INTO `RackSpace` VALUES (969,3,'interior','T',918);
528INSERT INTO `RackSpace` VALUES (969,3,'rear','T',918);
529INSERT INTO `RackSpace` VALUES (969,13,'front','T',919);
530INSERT INTO `RackSpace` VALUES (969,13,'interior','T',919);
531INSERT INTO `RackSpace` VALUES (969,13,'rear','T',919);
532INSERT INTO `RackSpace` VALUES (969,12,'front','T',919);
533INSERT INTO `RackSpace` VALUES (969,12,'interior','T',919);
534INSERT INTO `RackSpace` VALUES (969,12,'rear','T',919);
535INSERT INTO `RackSpace` VALUES (969,11,'front','T',919);
536INSERT INTO `RackSpace` VALUES (969,11,'interior','T',919);
537INSERT INTO `RackSpace` VALUES (969,11,'rear','T',919);
538INSERT INTO `RackSpace` VALUES (969,10,'front','T',919);
539INSERT INTO `RackSpace` VALUES (969,10,'interior','T',919);
540INSERT INTO `RackSpace` VALUES (969,10,'rear','T',919);
541INSERT INTO `RackSpace` VALUES (969,9,'front','T',919);
542INSERT INTO `RackSpace` VALUES (969,9,'interior','T',919);
543INSERT INTO `RackSpace` VALUES (969,9,'rear','T',919);
544INSERT INTO `RackSpace` VALUES (969,37,'front','T',920);
545INSERT INTO `RackSpace` VALUES (969,37,'interior','T',920);
546INSERT INTO `RackSpace` VALUES (969,37,'rear','T',920);
547INSERT INTO `RackSpace` VALUES (969,36,'front','T',920);
548INSERT INTO `RackSpace` VALUES (969,36,'interior','T',920);
549INSERT INTO `RackSpace` VALUES (969,36,'rear','T',920);
550INSERT INTO `RackSpace` VALUES (969,35,'front','T',920);
551INSERT INTO `RackSpace` VALUES (969,35,'interior','T',920);
552INSERT INTO `RackSpace` VALUES (969,35,'rear','T',920);
553INSERT INTO `RackSpace` VALUES (969,34,'front','T',920);
554INSERT INTO `RackSpace` VALUES (969,34,'interior','T',920);
555INSERT INTO `RackSpace` VALUES (969,34,'rear','T',920);
556INSERT INTO `RackSpace` VALUES (969,33,'front','T',920);
557INSERT INTO `RackSpace` VALUES (969,33,'interior','T',920);
558INSERT INTO `RackSpace` VALUES (969,33,'rear','T',920);
559INSERT INTO `RackSpace` VALUES (969,32,'front','T',920);
560INSERT INTO `RackSpace` VALUES (969,32,'interior','T',920);
561INSERT INTO `RackSpace` VALUES (969,32,'rear','T',920);
562INSERT INTO `RackSpace` VALUES (969,31,'front','T',920);
563INSERT INTO `RackSpace` VALUES (969,31,'interior','T',920);
564INSERT INTO `RackSpace` VALUES (969,31,'rear','T',920);
565INSERT INTO `RackSpace` VALUES (969,30,'front','T',920);
566INSERT INTO `RackSpace` VALUES (969,30,'interior','T',920);
567INSERT INTO `RackSpace` VALUES (969,30,'rear','T',920);
568INSERT INTO `RackSpace` VALUES (969,16,'front','T',921);
569INSERT INTO `RackSpace` VALUES (969,16,'interior','T',921);
570INSERT INTO `RackSpace` VALUES (969,16,'rear','T',921);
571INSERT INTO `RackSpace` VALUES (969,15,'front','T',921);
572INSERT INTO `RackSpace` VALUES (969,15,'interior','T',921);
573INSERT INTO `RackSpace` VALUES (969,15,'rear','T',921);
574INSERT INTO `RackSpace` VALUES (969,18,'front','T',922);
575INSERT INTO `RackSpace` VALUES (969,18,'interior','T',922);
576INSERT INTO `RackSpace` VALUES (969,18,'rear','T',922);
577INSERT INTO `RackSpace` VALUES (969,17,'front','T',922);
578INSERT INTO `RackSpace` VALUES (969,17,'interior','T',922);
579INSERT INTO `RackSpace` VALUES (969,17,'rear','T',922);
580INSERT INTO `RackSpace` VALUES (974,11,'interior','T',926);
581INSERT INTO `RackSpace` VALUES (974,11,'rear','T',926);
582INSERT INTO `RackSpace` VALUES (974,1,'front','T',923);
583INSERT INTO `RackSpace` VALUES (974,1,'interior','T',923);
584INSERT INTO `RackSpace` VALUES (974,1,'rear','T',923);
585INSERT INTO `RackSpace` VALUES (974,3,'front','T',924);
586INSERT INTO `RackSpace` VALUES (974,3,'interior','T',924);
587INSERT INTO `RackSpace` VALUES (974,3,'rear','T',924);
588INSERT INTO `RackSpace` VALUES (974,5,'front','T',925);
589INSERT INTO `RackSpace` VALUES (974,5,'interior','T',925);
590INSERT INTO `RackSpace` VALUES (974,5,'rear','T',925);
591INSERT INTO `RackSpace` VALUES (970,12,'interior','T',927);
592INSERT INTO `RackSpace` VALUES (970,12,'rear','T',927);
593INSERT INTO `RackSpace` VALUES (970,11,'interior','T',927);
594INSERT INTO `RackSpace` VALUES (970,11,'rear','T',927);
595INSERT INTO `RackSpace` VALUES (970,10,'interior','T',927);
596INSERT INTO `RackSpace` VALUES (970,10,'rear','T',927);
597INSERT INTO `RackSpace` VALUES (970,2,'front','T',944);
598INSERT INTO `RackSpace` VALUES (970,2,'interior','T',944);
599INSERT INTO `RackSpace` VALUES (970,2,'rear','T',944);
600INSERT INTO `RackSpace` VALUES (970,1,'front','T',944);
601INSERT INTO `RackSpace` VALUES (970,1,'interior','T',944);
602INSERT INTO `RackSpace` VALUES (970,1,'rear','T',944);
603INSERT INTO `RackSpace` VALUES (971,5,'front','T',942);
604INSERT INTO `RackSpace` VALUES (971,5,'interior','T',942);
605INSERT INTO `RackSpace` VALUES (971,5,'rear','T',942);
606INSERT INTO `RackSpace` VALUES (971,4,'front','T',942);
607INSERT INTO `RackSpace` VALUES (971,4,'interior','T',942);
608INSERT INTO `RackSpace` VALUES (971,4,'rear','T',942);
609INSERT INTO `RackSpace` VALUES (971,3,'front','T',942);
610INSERT INTO `RackSpace` VALUES (971,3,'interior','T',942);
611INSERT INTO `RackSpace` VALUES (971,3,'rear','T',942);
612INSERT INTO `RackSpace` VALUES (971,2,'front','T',942);
613INSERT INTO `RackSpace` VALUES (971,2,'interior','T',942);
614INSERT INTO `RackSpace` VALUES (971,2,'rear','T',942);
615INSERT INTO `RackSpace` VALUES (971,1,'front','T',942);
616INSERT INTO `RackSpace` VALUES (971,1,'interior','T',942);
617INSERT INTO `RackSpace` VALUES (971,1,'rear','T',942);
618INSERT INTO `RackSpace` VALUES (973,5,'front','T',943);
619INSERT INTO `RackSpace` VALUES (973,5,'interior','T',943);
620INSERT INTO `RackSpace` VALUES (973,5,'rear','T',943);
621INSERT INTO `RackSpace` VALUES (973,4,'front','T',943);
622INSERT INTO `RackSpace` VALUES (973,4,'interior','T',943);
623INSERT INTO `RackSpace` VALUES (973,4,'rear','T',943);
624INSERT INTO `RackSpace` VALUES (973,3,'front','T',943);
625INSERT INTO `RackSpace` VALUES (973,3,'interior','T',943);
626INSERT INTO `RackSpace` VALUES (973,3,'rear','T',943);
627INSERT INTO `RackSpace` VALUES (973,2,'front','T',943);
628INSERT INTO `RackSpace` VALUES (973,2,'interior','T',943);
629INSERT INTO `RackSpace` VALUES (973,2,'rear','T',943);
630INSERT INTO `RackSpace` VALUES (973,1,'front','T',943);
631INSERT INTO `RackSpace` VALUES (973,1,'interior','T',943);
632INSERT INTO `RackSpace` VALUES (973,1,'rear','T',943);
633INSERT INTO `RackSpace` VALUES (971,6,'front','U',NULL);
634INSERT INTO `RackSpace` VALUES (971,6,'interior','U',NULL);
635INSERT INTO `RackSpace` VALUES (971,6,'rear','U',NULL);
636INSERT INTO `RackSpace` VALUES (973,6,'front','U',NULL);
637INSERT INTO `RackSpace` VALUES (973,6,'interior','U',NULL);
638INSERT INTO `RackSpace` VALUES (973,6,'rear','U',NULL);
639INSERT INTO `RackSpace` VALUES (973,17,'rear','T',954);
640INSERT INTO `RackSpace` VALUES (972,20,'front','T',953);
641INSERT INTO `RackSpace` VALUES (968,6,'front','T',952);
642INSERT INTO `RackSpace` VALUES (967,1,'rear','T',949);
643INSERT INTO `RackSpace` VALUES (973,37,'rear','T',931);
644INSERT INTO `RackSpace` VALUES (973,37,'interior','T',931);
645INSERT INTO `RackSpace` VALUES (973,40,'rear','T',929);
646INSERT INTO `RackSpace` VALUES (973,40,'interior','T',929);
647INSERT INTO `RackSpace` VALUES (973,15,'rear','T',941);
648INSERT INTO `RackSpace` VALUES (973,15,'interior','T',941);
649INSERT INTO `RackSpace` VALUES (973,15,'front','T',941);
650INSERT INTO `RackSpace` VALUES (973,13,'front','T',939);
651INSERT INTO `RackSpace` VALUES (973,11,'rear','T',937);
652INSERT INTO `RackSpace` VALUES (973,11,'interior','T',937);
653INSERT INTO `RackSpace` VALUES (973,9,'interior','T',935);
654INSERT INTO `RackSpace` VALUES (973,7,'interior','T',933);
655INSERT INTO `RackSpace` VALUES (974,16,'rear','T',946);
656INSERT INTO `RackSpace` VALUES (971,38,'rear','T',930);
657INSERT INTO `RackSpace` VALUES (971,40,'interior','T',928);
658INSERT INTO `RackSpace` VALUES (971,15,'rear','T',940);
659INSERT INTO `RackSpace` VALUES (971,13,'rear','T',938);
660INSERT INTO `RackSpace` VALUES (971,11,'rear','T',936);
661INSERT INTO `RackSpace` VALUES (971,9,'rear','T',934);
662INSERT INTO `RackSpace` VALUES (971,7,'rear','T',932);
663INSERT INTO `RackSpace` VALUES (968,12,'rear','A',NULL);
664INSERT INTO `RackSpace` VALUES (968,11,'rear','A',NULL);
665INSERT INTO `RackSpace` VALUES (968,10,'rear','A',NULL);
666INSERT INTO `RackSpace` VALUES (968,9,'rear','A',NULL);
667INSERT INTO `RackSpace` VALUES (968,8,'rear','A',NULL);
668INSERT INTO `RackSpace` VALUES (968,7,'rear','A',NULL);
669INSERT INTO `RackSpace` VALUES (968,6,'rear','A',NULL);
670INSERT INTO `RackSpace` VALUES (968,5,'rear','A',NULL);
671INSERT INTO `RackSpace` VALUES (968,4,'rear','A',NULL);
672INSERT INTO `RackSpace` VALUES (968,3,'rear','A',NULL);
673INSERT INTO `RackSpace` VALUES (968,2,'rear','A',NULL);
674INSERT INTO `RackSpace` VALUES (968,1,'rear','A',NULL);
675INSERT INTO `RackSpace` VALUES (974,9,'rear','T',955);
676INSERT INTO `RackSpace` VALUES (971,17,'rear','T',951);
677INSERT INTO `RackSpace` VALUES (970,9,'rear','T',948);
678INSERT INTO `RackSpace` VALUES (969,14,'rear','T',950);
679INSERT INTO `RackSpace` VALUES (969,2,'rear','T',947);
680INSERT INTO `RackSpace` VALUES (973,38,'rear','T',931);
681INSERT INTO `RackSpace` VALUES (973,38,'interior','T',931);
682INSERT INTO `RackSpace` VALUES (973,41,'rear','T',929);
683INSERT INTO `RackSpace` VALUES (973,41,'interior','T',929);
684INSERT INTO `RackSpace` VALUES (973,13,'rear','T',939);
685INSERT INTO `RackSpace` VALUES (973,13,'interior','T',939);
686INSERT INTO `RackSpace` VALUES (973,11,'front','T',937);
687INSERT INTO `RackSpace` VALUES (973,9,'rear','T',935);
688INSERT INTO `RackSpace` VALUES (973,9,'front','T',935);
689INSERT INTO `RackSpace` VALUES (973,7,'rear','T',933);
690INSERT INTO `RackSpace` VALUES (973,7,'front','T',933);
691INSERT INTO `RackSpace` VALUES (970,13,'rear','T',945);
692INSERT INTO `RackSpace` VALUES (971,37,'rear','T',930);
693INSERT INTO `RackSpace` VALUES (971,37,'interior','T',930);
694INSERT INTO `RackSpace` VALUES (971,38,'interior','T',930);
695INSERT INTO `RackSpace` VALUES (971,40,'rear','T',928);
696INSERT INTO `RackSpace` VALUES (971,41,'rear','T',928);
697INSERT INTO `RackSpace` VALUES (971,41,'interior','T',928);
698INSERT INTO `RackSpace` VALUES (971,15,'interior','T',940);
699INSERT INTO `RackSpace` VALUES (971,15,'front','T',940);
700INSERT INTO `RackSpace` VALUES (971,13,'interior','T',938);
701INSERT INTO `RackSpace` VALUES (971,13,'front','T',938);
702INSERT INTO `RackSpace` VALUES (971,11,'interior','T',936);
703INSERT INTO `RackSpace` VALUES (971,11,'front','T',936);
704INSERT INTO `RackSpace` VALUES (971,9,'interior','T',934);
705INSERT INTO `RackSpace` VALUES (971,9,'front','T',934);
706INSERT INTO `RackSpace` VALUES (971,7,'interior','T',932);
707INSERT INTO `RackSpace` VALUES (971,7,'front','T',932);
708INSERT INTO `RackSpace` VALUES (968,2,'front','T',917);
709INSERT INTO `RackSpace` VALUES (968,2,'interior','T',917);
710INSERT INTO `RackSpace` VALUES (968,1,'front','T',917);
711INSERT INTO `RackSpace` VALUES (968,1,'interior','T',917);
712INSERT INTO `RackSpace` VALUES (972,2,'front','T',956);
713INSERT INTO `RackSpace` VALUES (972,2,'interior','T',956);
714INSERT INTO `RackSpace` VALUES (972,2,'rear','T',956);
715INSERT INTO `RackSpace` VALUES (972,4,'front','T',957);
716INSERT INTO `RackSpace` VALUES (972,4,'interior','T',957);
717INSERT INTO `RackSpace` VALUES (972,4,'rear','T',957);
718INSERT INTO `RackSpace` VALUES (972,6,'front','T',958);
719INSERT INTO `RackSpace` VALUES (972,6,'interior','T',958);
720INSERT INTO `RackSpace` VALUES (972,6,'rear','T',958);
721INSERT INTO `RackSpace` VALUES (972,8,'front','T',959);
722INSERT INTO `RackSpace` VALUES (972,8,'interior','T',959);
723INSERT INTO `RackSpace` VALUES (972,8,'rear','T',959);
724INSERT INTO `RackSpace` VALUES (972,10,'front','T',960);
725INSERT INTO `RackSpace` VALUES (972,10,'interior','T',960);
726INSERT INTO `RackSpace` VALUES (972,10,'rear','T',960);
727INSERT INTO `RackSpace` VALUES (972,35,'interior','T',961);
728INSERT INTO `RackSpace` VALUES (972,35,'rear','T',961);
729INSERT INTO `RackSpace` VALUES (972,34,'interior','T',962);
730INSERT INTO `RackSpace` VALUES (972,34,'rear','T',962);
e673ee24 731
e1add254
AD
732INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (1,NULL,'testing');
733INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (2,NULL,'production');
734INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (10,NULL,'network');
735INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (5,10,'WAN link');
736INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (6,NULL,'racks');
737INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (7,6,'tall racks');
738INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (8,6,'low racks');
739INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (9,NULL,'load balancer');
740INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (11,10,'small network');
741INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (12,10,'medium network');
742INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (16,NULL,'XKCD');
743INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (17,16,'romance');
744INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (18,16,'sarcasm');
745INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (19,16,'math');
746INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (20,16,'language');
41497dbe 747
e1add254
AD
748INSERT INTO `TagStorage` VALUES ('object',905,1,NULL,NULL);
749INSERT INTO `TagStorage` VALUES ('object',908,2,NULL,NULL);
750INSERT INTO `TagStorage` VALUES ('object',909,1,NULL,NULL);
03c5a938 751INSERT INTO `TagStorage` VALUES ('object',928,9,NULL,NULL);
03c5a938 752INSERT INTO `TagStorage` VALUES ('object',929,9,NULL,NULL);
e1add254
AD
753INSERT INTO `TagStorage` VALUES ('object',956,2,NULL,NULL);
754INSERT INTO `TagStorage` VALUES ('object',957,2,NULL,NULL);
755INSERT INTO `TagStorage` VALUES ('object',958,2,NULL,NULL);
756INSERT INTO `TagStorage` VALUES ('object',959,2,NULL,NULL);
757INSERT INTO `TagStorage` VALUES ('object',960,2,NULL,NULL);
758INSERT INTO `TagStorage` VALUES ('object',961,2,NULL,NULL);
759INSERT INTO `TagStorage` VALUES ('object',962,2,NULL,NULL);
760INSERT INTO `TagStorage` VALUES ('ipv4net',96,12,NULL,NULL);
761INSERT INTO `TagStorage` VALUES ('ipv4net',97,12,NULL,NULL);
762INSERT INTO `TagStorage` VALUES ('ipv4net',98,12,NULL,NULL);
763INSERT INTO `TagStorage` VALUES ('ipv4net',99,12,NULL,NULL);
764INSERT INTO `TagStorage` VALUES ('ipv4net',102,5,NULL,NULL);
03c5a938 765INSERT INTO `TagStorage` VALUES ('ipv4net',102,11,NULL,NULL);
e1add254 766INSERT INTO `TagStorage` VALUES ('ipv4net',103,5,NULL,NULL);
03c5a938 767INSERT INTO `TagStorage` VALUES ('ipv4net',103,11,NULL,NULL);
e1add254 768INSERT INTO `TagStorage` VALUES ('ipv4net',104,5,NULL,NULL);
03c5a938 769INSERT INTO `TagStorage` VALUES ('ipv4net',104,11,NULL,NULL);
e1add254 770INSERT INTO `TagStorage` VALUES ('ipv4net',105,5,NULL,NULL);
03c5a938 771INSERT INTO `TagStorage` VALUES ('ipv4net',105,11,NULL,NULL);
e1add254
AD
772INSERT INTO `TagStorage` VALUES ('ipv4net',106,12,NULL,NULL);
773INSERT INTO `TagStorage` VALUES ('ipv4net',107,12,NULL,NULL);
774INSERT INTO `TagStorage` VALUES ('ipv4net',108,12,NULL,NULL);
775INSERT INTO `TagStorage` VALUES ('rack',967,7,NULL,NULL);
03c5a938 776INSERT INTO `TagStorage` VALUES ('rack',968,8,NULL,NULL);
e1add254
AD
777INSERT INTO `TagStorage` VALUES ('rack',969,7,NULL,NULL);
778INSERT INTO `TagStorage` VALUES ('rack',970,8,NULL,NULL);
779INSERT INTO `TagStorage` VALUES ('rack',971,7,NULL,NULL);
03c5a938 780INSERT INTO `TagStorage` VALUES ('rack',972,7,NULL,NULL);
e1add254
AD
781INSERT INTO `TagStorage` VALUES ('rack',973,7,NULL,NULL);
782INSERT INTO `TagStorage` VALUES ('rack',974,8,NULL,NULL);
783INSERT INTO `TagStorage` VALUES ('ipv6net','1','10',NULL,NULL);
784INSERT INTO `TagStorage` VALUES ('ipv6net','2','12',NULL,NULL);
785INSERT INTO `TagStorage` VALUES ('ipv6net','3','12',NULL,NULL);
03c5a938 786INSERT INTO `TagStorage` VALUES ('ipv6net','4','18',NULL,NULL);
03c5a938 787INSERT INTO `TagStorage` VALUES ('ipv6net','5','18',NULL,NULL);
b1808b2a
DO
788
789INSERT INTO `VLANDomain` VALUES
790(2,'English'),
791(1,'русский'),
792(3,'українська'),
793(4,'日本語');
794
795INSERT INTO `VLANDescription` VALUES
796(1,1,'compulsory','default'),
797(1,2,'ondemand','второй'),
798(1,3,'ondemand','третий'),
799(1,4,'ondemand','четвёртый'),
800(1,5,'ondemand','пятый'),
801(1,6,'ondemand','шестой'),
802(1,7,'ondemand','седьмой'),
803(1,8,'ondemand','восьмой'),
804(1,9,'ondemand','девятый'),
805(1,10,'ondemand','десятый'),
806(1,11,'ondemand','одиннадцатый'),
807(1,12,'ondemand','двенадцатый'),
808(1,13,'ondemand','тринадцатый'),
809(1,14,'ondemand','четырнадцатый'),
810(1,15,'ondemand','пятнадцатый'),
811(2,1,'compulsory','default'),
812(2,2,'ondemand','second'),
813(2,3,'ondemand','third'),
814(2,4,'ondemand','fourth'),
815(2,5,'ondemand','fifth'),
816(2,6,'ondemand','sixth'),
817(2,7,'ondemand','seventh'),
818(2,8,'ondemand','eighth'),
819(2,9,'ondemand','ninth'),
820(2,10,'ondemand','tenth'),
821(2,11,'ondemand','eleventh'),
822(2,12,'ondemand','twelfth'),
823(2,13,'ondemand','thirteenth'),
824(2,14,'ondemand','fourteenth'),
825(2,15,'ondemand','fifteenth'),
826(3,1,'compulsory','default'),
827(3,2,'ondemand','другий'),
828(3,3,'ondemand','третій'),
829(3,4,'ondemand','четвертий'),
830(3,5,'ondemand','п\'ятий'),
831(3,6,'ondemand','шостий'),
832(3,7,'ondemand','сьомий'),
833(3,8,'ondemand','восьмий'),
834(3,9,'ondemand','дев\'ятий'),
835(3,10,'ondemand','десятий'),
836(3,11,'ondemand','одинадцятий'),
837(3,12,'ondemand','дванадцятий'),
838(3,13,'ondemand','тринадцятий'),
839(3,14,'ondemand','чотирнадцятий'),
840(3,15,'ondemand','п\'ятнадцятий'),
841(4,1,'compulsory','default'),
842(4,2,'ondemand','第二'),
843(4,3,'ondemand','第三'),
844(4,4,'ondemand','第四'),
845(4,5,'ondemand','第五'),
846(4,6,'ondemand','第六'),
847(4,7,'ondemand','第七'),
848(4,8,'ondemand','第八'),
849(4,9,'ondemand','第九'),
850(4,10,'ondemand','第十'),
851(4,11,'ondemand','第十一'),
852(4,12,'ondemand','第十二'),
853(4,13,'ondemand','第十三'),
854(4,14,'ondemand','第十四'),
855(4,15,'ondemand','第十五');