d38d52affad7f3bfb916bca94a5de3e985aaa655
[racktables] / scripts / init-sample-racks.sql
1 set names 'utf8';
2
3 INSERT INTO `Molecule` (`id`) VALUES
4 (1);
5
6 INSERT INTO `Object` (`id`, `name`, `label`, `objtype_id`, `asset_no`, `has_problems`, `comment`) VALUES
7 (905,'london router','bbrtr1',7,'net247','no',NULL),
8 (906,'londonswitch1','',8,NULL,'no',NULL),
9 (907,'New-York router 1','bbrtr2a',7,'net55','no',NULL),
10 (908,'moscow router','bbrtr3',7,NULL,'no',NULL),
11 (909,'tokyo router','bbrtr4',7,NULL,'no',NULL),
12 (910,'London server 1','lserver01',4,'srv500','no',NULL),
13 (911,'London server 2','lserver02',4,'srv501','no',NULL),
14 (912,'London server 3','lserver03',4,'srv502','no',NULL),
15 (913,'London server 4','lserver04',4,'srv503','yes','this one needs replacement'),
16 (914,'London server 5','lserver05',4,'srv504','no',NULL),
17 (915,'london LB','llb',8,'net1000','no',NULL),
18 (916,'shared storage','',5,NULL,'no',NULL),
19 (917,'london-NAS','',7,'net1001','no',NULL),
20 (918,'London server 6','lserver06',4,'srv505','no',NULL),
21 (919,'London server 7','lserver07',4,'srv506','no',NULL),
22 (920,'backup library','lbackup',6,'misc200','no',NULL),
23 (921,'lserver06 array','lserver06 array',5,NULL,'no',NULL),
24 (922,'lserver07 array','lserver07 array',5,NULL,'no',NULL),
25 (923,'Tokyo server 1','tserver01',4,'srv654','no',NULL),
26 (924,'Tokyo server 2','tserver02',4,'srv848','no',NULL),
27 (925,'Tokyo server 3','tserver03',4,'srv139','no',NULL),
28 (926,'Tokyo switch','tswitch',8,'net385','no',NULL),
29 (927,'New-York router 2','bbrtr2b',7,'net498','no',NULL),
30 (928,'New-York IPVS LB A','nylba',4,'net554','no',NULL),
31 (929,'New-York IPVS LB B','nylbb',4,'net555','no',NULL),
32 (930,'New-York server switch A','nyswitcha',8,'net084','no',NULL),
33 (931,'New-York server switch B','nyswitchb',8,'net486','no',NULL),
34 (932,'New-York server 1A','nysrv1a',4,'srv287','no',NULL),
35 (933,'New-York server 1B','nysrv1b',4,'srv288','no',NULL),
36 (934,'New-York server 2A','nysrv2a',4,NULL,'no',NULL),
37 (935,'New-York server 2B','nysrv2b',4,NULL,'no',NULL),
38 (936,'New-York server 3A','nysrv3a',4,NULL,'no',NULL),
39 (937,'New-York server 3B','nysrv3b',4,NULL,'no',NULL),
40 (938,'New-York server 4A','nysrv4a',4,NULL,'no',NULL),
41 (939,'New-York server 4B','nysrv4b',4,NULL,'no',NULL),
42 (940,'New-York server 5A','nysrv5a',4,NULL,'no',NULL),
43 (941,'New-York server 5B','nysrv5b',4,NULL,'no',NULL),
44 (942,'wing A UPS',NULL,12,NULL,'no',NULL),
45 (943,'wing B UPS',NULL,12,NULL,'no',NULL),
46 (944,'network UPS',NULL,12,NULL,'no',NULL),
47 (945,NULL,NULL,9,NULL,'no',NULL),
48 (946,NULL,NULL,9,NULL,'no',NULL),
49 (947,NULL,NULL,2,NULL,'no',NULL),
50 (948,NULL,NULL,2,NULL,'no',NULL),
51 (949,NULL,NULL,2,NULL,'no',NULL),
52 (950,NULL,NULL,2,NULL,'no',NULL),
53 (951,NULL,NULL,2,NULL,'no',NULL),
54 (952,NULL,NULL,2,NULL,'no',NULL),
55 (953,NULL,NULL,2,NULL,'no',NULL),
56 (954,NULL,NULL,2,NULL,'no',NULL),
57 (955,NULL,NULL,2,NULL,'no',NULL),
58 (956,'mps1',NULL,4,NULL,'no',NULL),
59 (957,'mps2',NULL,4,NULL,'no',NULL),
60 (958,'mps3',NULL,4,NULL,'no',NULL),
61 (959,'mps4',NULL,4,NULL,'no',NULL),
62 (960,'mps5',NULL,4,NULL,'no',NULL),
63 (961,'mskswitch',NULL,8,'sw0001','no',NULL),
64 (962,'moscow kvm switch',NULL,445,'sw0002','no',NULL),
65 (963,'Row 1',NULL,1561,NULL,'no',NULL),
66 (964,'Row A',NULL,1561,NULL,'no',NULL),
67 (965,'CF-4',NULL,1561,NULL,'no',NULL),
68 (966,'Row 1',NULL,1561,NULL,'no',NULL),
69 (967,'L01',NULL,1560,NULL,'no','test'),
70 (968,'L02',NULL,1560,NULL,'no','network equipment mini-rack'),
71 (969,'L03',NULL,1560,NULL,'no',NULL),
72 (970,'NY100',NULL,1560,NULL,'no',NULL),
73 (971,'NY101',NULL,1560,NULL,'no','server farm wing A'),
74 (972,'M01',NULL,1560,NULL,'no',NULL),
75 (973,'NY102',NULL,1560,NULL,'no','server farm wing B'),
76 (974,'T01',NULL,1560,NULL,'no',NULL),
77 (975,'Moscow',NULL,1562,NULL,'no',NULL),
78 (976,'Tokyo',NULL,1562,NULL,'no',NULL),
79 (977,'New-York',NULL,1562,NULL,'no',NULL),
80 (978,'London',NULL,1562,NULL,'no',NULL),
81 (979,'sw-a1',NULL,8,NULL,'no',NULL),
82 (980,'sw-a2',NULL,8,NULL,'no',NULL),
83 (981,'sw-d1',NULL,8,NULL,'no',NULL);
84
85 INSERT INTO `Atom` (`molecule_id`, `rack_id`, `unit_no`, `atom`) VALUES
86 (1,967,35,'front'),
87 (1,967,35,'interior');
88
89 INSERT INTO `EntityLink` (`parent_entity_type`, `parent_entity_id`, `child_entity_type`, `child_entity_id`) VALUES
90 ('row',966,'rack',967),
91 ('row',966,'rack',968),
92 ('row',966,'rack',969),
93 ('row',965,'rack',970),
94 ('row',965,'rack',971),
95 ('row',963,'rack',972),
96 ('row',965,'rack',973),
97 ('row',964,'rack',974),
98 ('location',975,'row',963),
99 ('location',976,'row',964),
100 ('location',977,'row',965),
101 ('location',978,'row',966),
102 ('rack',968,'object',979),
103 ('rack',969,'object',980);
104
105 INSERT INTO `AttributeValue` (`object_id`, `object_tid`, `attr_id`, `string_value`, `uint_value`, `float_value`) VALUES
106 (905,7,2,NULL,269,NULL),
107 (906,8,2,NULL,165,NULL),
108 (915,8,2,NULL,118,NULL),
109 (915,8,4,NULL,245,NULL),
110 (917,7,2,NULL,267,NULL),
111 (916,5,2,NULL,320,NULL),
112 (910,4,2,NULL,57,NULL),
113 (910,4,4,NULL,220,NULL),
114 (911,4,4,NULL,220,NULL),
115 (911,4,2,NULL,57,NULL),
116 (912,4,4,NULL,220,NULL),
117 (912,4,2,NULL,57,NULL),
118 (913,4,2,NULL,57,NULL),
119 (913,4,4,NULL,220,NULL),
120 (914,4,2,NULL,57,NULL),
121 (914,4,4,NULL,220,NULL),
122 (918,4,2,NULL,88,NULL),
123 (918,4,4,NULL,220,NULL),
124 (919,4,2,NULL,88,NULL),
125 (919,4,4,NULL,220,NULL),
126 (920,6,2,NULL,326,NULL),
127 (921,5,2,NULL,318,NULL),
128 (922,5,2,NULL,318,NULL),
129 (923,4,2,NULL,102,NULL),
130 (923,4,4,NULL,233,NULL),
131 (926,8,2,NULL,126,NULL),
132 (926,8,4,NULL,244,NULL),
133 (925,4,2,NULL,102,NULL),
134 (925,4,4,NULL,233,NULL),
135 (924,4,2,NULL,102,NULL),
136 (924,4,4,NULL,233,NULL),
137 (907,7,2,NULL,269,NULL),
138 (907,7,4,NULL,258,NULL),
139 (927,7,2,NULL,269,NULL),
140 (927,7,4,NULL,258,NULL),
141 (956,4,2,NULL,62,NULL),
142 (956,4,4,NULL,791,NULL),
143 (957,4,2,NULL,62,NULL),
144 (957,4,4,NULL,791,NULL),
145 (958,4,2,NULL,62,NULL),
146 (958,4,4,NULL,791,NULL),
147 (959,4,2,NULL,62,NULL),
148 (959,4,4,NULL,791,NULL),
149 (960,4,2,NULL,62,NULL),
150 (960,4,4,NULL,791,NULL),
151 (961,8,2,NULL,755,NULL),
152 (962,445,2,NULL,470,NULL),
153 (967,1560,27,NULL,42,NULL),
154 (967,1560,29,NULL,1,NULL),
155 (968,1560,27,NULL,12,NULL),
156 (968,1560,29,NULL,2,NULL),
157 (969,1560,27,NULL,42,NULL),
158 (969,1560,29,NULL,3,NULL),
159 (970,1560,27,NULL,16,NULL),
160 (970,1560,29,NULL,1,NULL),
161 (971,1560,27,NULL,42,NULL),
162 (971,1560,29,NULL,2,NULL),
163 (972,1560,27,NULL,42,NULL),
164 (972,1560,29,NULL,1,NULL),
165 (973,1560,27,NULL,42,NULL),
166 (973,1560,29,NULL,3,NULL),
167 (974,1560,27,NULL,16,NULL),
168 (974,1560,29,NULL,1,NULL),
169 (979,8,2,NULL,167,NULL),
170 (979,8,4,NULL,252,NULL),
171 (980,8,2,NULL,1337,NULL),
172 (980,8,4,NULL,1369,NULL),
173 (981,8,2,NULL,188,NULL),
174 (981,8,4,NULL,252,NULL);
175
176 INSERT INTO `CachedPVM` (`object_id`, `port_name`, `vlan_mode`) VALUES
177 (979,'gi0/1','trunk'),
178 (979,'gi0/10','access'),
179 (979,'gi0/11','access'),
180 (979,'gi0/12','access'),
181 (979,'gi0/13','access'),
182 (979,'gi0/14','access'),
183 (979,'gi0/15','access'),
184 (979,'gi0/16','access'),
185 (979,'gi0/17','access'),
186 (979,'gi0/18','access'),
187 (979,'gi0/19','access'),
188 (979,'gi0/2','trunk'),
189 (979,'gi0/20','access'),
190 (979,'gi0/21','access'),
191 (979,'gi0/22','access'),
192 (979,'gi0/23','access'),
193 (979,'gi0/24','trunk'),
194 (979,'gi0/3','access'),
195 (979,'gi0/4','access'),
196 (979,'gi0/5','access'),
197 (979,'gi0/6','access'),
198 (979,'gi0/7','access'),
199 (979,'gi0/8','access'),
200 (979,'gi0/9','access'),
201 (980,'gi0/0/1','trunk'),
202 (980,'gi0/0/10','access'),
203 (980,'gi0/0/11','access'),
204 (980,'gi0/0/12','access'),
205 (980,'gi0/0/13','access'),
206 (980,'gi0/0/14','access'),
207 (980,'gi0/0/15','access'),
208 (980,'gi0/0/16','access'),
209 (980,'gi0/0/17','access'),
210 (980,'gi0/0/18','access'),
211 (980,'gi0/0/19','access'),
212 (980,'gi0/0/2','access'),
213 (980,'gi0/0/20','access'),
214 (980,'gi0/0/21','access'),
215 (980,'gi0/0/22','access'),
216 (980,'gi0/0/23','access'),
217 (980,'gi0/0/24','access'),
218 (980,'gi0/0/25','access'),
219 (980,'gi0/0/26','access'),
220 (980,'gi0/0/27','access'),
221 (980,'gi0/0/28','access'),
222 (980,'gi0/0/29','access'),
223 (980,'gi0/0/3','access'),
224 (980,'gi0/0/30','access'),
225 (980,'gi0/0/31','access'),
226 (980,'gi0/0/32','access'),
227 (980,'gi0/0/33','access'),
228 (980,'gi0/0/34','access'),
229 (980,'gi0/0/35','access'),
230 (980,'gi0/0/36','access'),
231 (980,'gi0/0/37','access'),
232 (980,'gi0/0/38','access'),
233 (980,'gi0/0/39','access'),
234 (980,'gi0/0/4','access'),
235 (980,'gi0/0/40','access'),
236 (980,'gi0/0/41','access'),
237 (980,'gi0/0/42','access'),
238 (980,'gi0/0/43','access'),
239 (980,'gi0/0/44','access'),
240 (980,'gi0/0/45','access'),
241 (980,'gi0/0/46','access'),
242 (980,'gi0/0/47','access'),
243 (980,'gi0/0/48','trunk'),
244 (980,'gi0/0/5','access'),
245 (980,'gi0/0/6','access'),
246 (980,'gi0/0/7','access'),
247 (980,'gi0/0/8','access'),
248 (980,'gi0/0/9','access'),
249 (980,'gi0/1','access'),
250 (980,'gi0/10','access'),
251 (980,'gi0/11','access'),
252 (980,'gi0/12','access'),
253 (980,'gi0/13','access'),
254 (980,'gi0/14','access'),
255 (980,'gi0/15','access'),
256 (980,'gi0/16','access'),
257 (980,'gi0/17','access'),
258 (980,'gi0/18','access'),
259 (980,'gi0/19','access'),
260 (980,'gi0/2','access'),
261 (980,'gi0/20','access'),
262 (980,'gi0/21','access'),
263 (980,'gi0/22','access'),
264 (980,'gi0/23','access'),
265 (980,'gi0/24','access'),
266 (980,'gi0/25','access'),
267 (980,'gi0/26','access'),
268 (980,'gi0/27','access'),
269 (980,'gi0/28','access'),
270 (980,'gi0/29','access'),
271 (980,'gi0/3','access'),
272 (980,'gi0/30','access'),
273 (980,'gi0/31','access'),
274 (980,'gi0/32','access'),
275 (980,'gi0/33','access'),
276 (980,'gi0/34','access'),
277 (980,'gi0/35','access'),
278 (980,'gi0/36','access'),
279 (980,'gi0/37','access'),
280 (980,'gi0/38','access'),
281 (980,'gi0/39','access'),
282 (980,'gi0/4','access'),
283 (980,'gi0/40','access'),
284 (980,'gi0/41','access'),
285 (980,'gi0/42','access'),
286 (980,'gi0/43','access'),
287 (980,'gi0/44','access'),
288 (980,'gi0/45','access'),
289 (980,'gi0/46','access'),
290 (980,'gi0/47','access'),
291 (980,'gi0/48','access'),
292 (980,'gi0/5','access'),
293 (980,'gi0/6','access'),
294 (980,'gi0/7','access'),
295 (980,'gi0/8','access'),
296 (980,'gi0/9','access'),
297 (981,'gi0/1','trunk'),
298 (981,'gi0/10','trunk'),
299 (981,'gi0/11','trunk'),
300 (981,'gi0/12','trunk'),
301 (981,'gi0/2','trunk'),
302 (981,'gi0/3','trunk'),
303 (981,'gi0/4','trunk'),
304 (981,'gi0/5','trunk'),
305 (981,'gi0/6','trunk'),
306 (981,'gi0/7','trunk'),
307 (981,'gi0/8','trunk'),
308 (981,'gi0/9','trunk');
309
310 INSERT INTO `CachedPAV` (`object_id`, `port_name`, `vlan_id`) VALUES
311 (979,'gi0/1',7),
312 (979,'gi0/1',8),
313 (979,'gi0/1',9),
314 (979,'gi0/10',9),
315 (979,'gi0/11',9),
316 (979,'gi0/12',9),
317 (979,'gi0/13',3),
318 (979,'gi0/14',9),
319 (979,'gi0/15',9),
320 (979,'gi0/16',9),
321 (979,'gi0/17',9),
322 (979,'gi0/18',9),
323 (979,'gi0/19',9),
324 (979,'gi0/2',7),
325 (979,'gi0/2',8),
326 (979,'gi0/2',9),
327 (979,'gi0/20',9),
328 (979,'gi0/21',9),
329 (979,'gi0/22',9),
330 (979,'gi0/23',9),
331 (979,'gi0/24',3),
332 (979,'gi0/24',7),
333 (979,'gi0/24',8),
334 (979,'gi0/24',9),
335 (979,'gi0/3',9),
336 (979,'gi0/4',9),
337 (979,'gi0/5',9),
338 (979,'gi0/6',9),
339 (979,'gi0/7',9),
340 (979,'gi0/8',9),
341 (979,'gi0/9',9),
342 (980,'gi0/0/1',1),
343 (980,'gi0/0/1',11),
344 (980,'gi0/0/1',12),
345 (980,'gi0/0/1',13),
346 (980,'gi0/0/10',1),
347 (980,'gi0/0/11',1),
348 (980,'gi0/0/12',1),
349 (980,'gi0/0/13',1),
350 (980,'gi0/0/14',1),
351 (980,'gi0/0/15',1),
352 (980,'gi0/0/16',1),
353 (980,'gi0/0/17',1),
354 (980,'gi0/0/18',1),
355 (980,'gi0/0/19',1),
356 (980,'gi0/0/2',1),
357 (980,'gi0/0/20',1),
358 (980,'gi0/0/21',1),
359 (980,'gi0/0/22',1),
360 (980,'gi0/0/23',1),
361 (980,'gi0/0/24',1),
362 (980,'gi0/0/25',1),
363 (980,'gi0/0/26',1),
364 (980,'gi0/0/27',1),
365 (980,'gi0/0/28',1),
366 (980,'gi0/0/29',1),
367 (980,'gi0/0/3',1),
368 (980,'gi0/0/30',1),
369 (980,'gi0/0/31',1),
370 (980,'gi0/0/32',1),
371 (980,'gi0/0/33',1),
372 (980,'gi0/0/34',1),
373 (980,'gi0/0/35',1),
374 (980,'gi0/0/36',1),
375 (980,'gi0/0/37',1),
376 (980,'gi0/0/38',1),
377 (980,'gi0/0/39',1),
378 (980,'gi0/0/4',3),
379 (980,'gi0/0/40',1),
380 (980,'gi0/0/41',1),
381 (980,'gi0/0/42',1),
382 (980,'gi0/0/43',1),
383 (980,'gi0/0/44',1),
384 (980,'gi0/0/45',1),
385 (980,'gi0/0/46',1),
386 (980,'gi0/0/47',1),
387 (980,'gi0/0/48',3),
388 (980,'gi0/0/48',5),
389 (980,'gi0/0/48',11),
390 (980,'gi0/0/48',12),
391 (980,'gi0/0/48',13),
392 (980,'gi0/0/5',5),
393 (980,'gi0/0/6',1),
394 (980,'gi0/0/7',1),
395 (980,'gi0/0/8',1),
396 (980,'gi0/0/9',1),
397 (980,'gi0/1',1),
398 (980,'gi0/10',1),
399 (980,'gi0/11',1),
400 (980,'gi0/12',1),
401 (980,'gi0/13',1),
402 (980,'gi0/14',1),
403 (980,'gi0/15',1),
404 (980,'gi0/16',1),
405 (980,'gi0/17',1),
406 (980,'gi0/18',1),
407 (980,'gi0/19',1),
408 (980,'gi0/2',1),
409 (980,'gi0/20',1),
410 (980,'gi0/21',1),
411 (980,'gi0/22',1),
412 (980,'gi0/23',1),
413 (980,'gi0/24',1),
414 (980,'gi0/25',1),
415 (980,'gi0/26',1),
416 (980,'gi0/27',1),
417 (980,'gi0/28',1),
418 (980,'gi0/29',1),
419 (980,'gi0/3',1),
420 (980,'gi0/30',1),
421 (980,'gi0/31',1),
422 (980,'gi0/32',1),
423 (980,'gi0/33',1),
424 (980,'gi0/34',1),
425 (980,'gi0/35',1),
426 (980,'gi0/36',1),
427 (980,'gi0/37',1),
428 (980,'gi0/38',1),
429 (980,'gi0/39',1),
430 (980,'gi0/4',1),
431 (980,'gi0/40',1),
432 (980,'gi0/41',1),
433 (980,'gi0/42',1),
434 (980,'gi0/43',1),
435 (980,'gi0/44',1),
436 (980,'gi0/45',1),
437 (980,'gi0/46',1),
438 (980,'gi0/47',1),
439 (980,'gi0/48',1),
440 (980,'gi0/5',1),
441 (980,'gi0/6',1),
442 (980,'gi0/7',1),
443 (980,'gi0/8',1),
444 (980,'gi0/9',1),
445 (981,'gi0/1',3),
446 (981,'gi0/1',7),
447 (981,'gi0/1',8),
448 (981,'gi0/1',9),
449 (981,'gi0/10',1),
450 (981,'gi0/11',1),
451 (981,'gi0/12',1),
452 (981,'gi0/2',1),
453 (981,'gi0/3',3),
454 (981,'gi0/3',5),
455 (981,'gi0/3',11),
456 (981,'gi0/3',12),
457 (981,'gi0/3',13),
458 (981,'gi0/4',1),
459 (981,'gi0/5',1),
460 (981,'gi0/6',1),
461 (981,'gi0/7',1),
462 (981,'gi0/8',1),
463 (981,'gi0/9',1);
464
465 INSERT INTO `CachedPNV` (`object_id`, `port_name`, `vlan_id`) VALUES
466 (979,'gi0/1',9),
467 (979,'gi0/10',9),
468 (979,'gi0/11',9),
469 (979,'gi0/12',9),
470 (979,'gi0/13',3),
471 (979,'gi0/14',9),
472 (979,'gi0/15',9),
473 (979,'gi0/16',9),
474 (979,'gi0/17',9),
475 (979,'gi0/18',9),
476 (979,'gi0/19',9),
477 (979,'gi0/2',9),
478 (979,'gi0/20',9),
479 (979,'gi0/21',9),
480 (979,'gi0/22',9),
481 (979,'gi0/23',9),
482 (979,'gi0/3',9),
483 (979,'gi0/4',9),
484 (979,'gi0/5',9),
485 (979,'gi0/6',9),
486 (979,'gi0/7',9),
487 (979,'gi0/8',9),
488 (979,'gi0/9',9),
489 (980,'gi0/0/1',1),
490 (980,'gi0/0/10',1),
491 (980,'gi0/0/11',1),
492 (980,'gi0/0/12',1),
493 (980,'gi0/0/13',1),
494 (980,'gi0/0/14',1),
495 (980,'gi0/0/15',1),
496 (980,'gi0/0/16',1),
497 (980,'gi0/0/17',1),
498 (980,'gi0/0/18',1),
499 (980,'gi0/0/19',1),
500 (980,'gi0/0/2',1),
501 (980,'gi0/0/20',1),
502 (980,'gi0/0/21',1),
503 (980,'gi0/0/22',1),
504 (980,'gi0/0/23',1),
505 (980,'gi0/0/24',1),
506 (980,'gi0/0/25',1),
507 (980,'gi0/0/26',1),
508 (980,'gi0/0/27',1),
509 (980,'gi0/0/28',1),
510 (980,'gi0/0/29',1),
511 (980,'gi0/0/3',1),
512 (980,'gi0/0/30',1),
513 (980,'gi0/0/31',1),
514 (980,'gi0/0/32',1),
515 (980,'gi0/0/33',1),
516 (980,'gi0/0/34',1),
517 (980,'gi0/0/35',1),
518 (980,'gi0/0/36',1),
519 (980,'gi0/0/37',1),
520 (980,'gi0/0/38',1),
521 (980,'gi0/0/39',1),
522 (980,'gi0/0/4',3),
523 (980,'gi0/0/40',1),
524 (980,'gi0/0/41',1),
525 (980,'gi0/0/42',1),
526 (980,'gi0/0/43',1),
527 (980,'gi0/0/44',1),
528 (980,'gi0/0/45',1),
529 (980,'gi0/0/46',1),
530 (980,'gi0/0/47',1),
531 (980,'gi0/0/5',5),
532 (980,'gi0/0/6',1),
533 (980,'gi0/0/7',1),
534 (980,'gi0/0/8',1),
535 (980,'gi0/0/9',1),
536 (980,'gi0/1',1),
537 (980,'gi0/10',1),
538 (980,'gi0/11',1),
539 (980,'gi0/12',1),
540 (980,'gi0/13',1),
541 (980,'gi0/14',1),
542 (980,'gi0/15',1),
543 (980,'gi0/16',1),
544 (980,'gi0/17',1),
545 (980,'gi0/18',1),
546 (980,'gi0/19',1),
547 (980,'gi0/2',1),
548 (980,'gi0/20',1),
549 (980,'gi0/21',1),
550 (980,'gi0/22',1),
551 (980,'gi0/23',1),
552 (980,'gi0/24',1),
553 (980,'gi0/25',1),
554 (980,'gi0/26',1),
555 (980,'gi0/27',1),
556 (980,'gi0/28',1),
557 (980,'gi0/29',1),
558 (980,'gi0/3',1),
559 (980,'gi0/30',1),
560 (980,'gi0/31',1),
561 (980,'gi0/32',1),
562 (980,'gi0/33',1),
563 (980,'gi0/34',1),
564 (980,'gi0/35',1),
565 (980,'gi0/36',1),
566 (980,'gi0/37',1),
567 (980,'gi0/38',1),
568 (980,'gi0/39',1),
569 (980,'gi0/4',1),
570 (980,'gi0/40',1),
571 (980,'gi0/41',1),
572 (980,'gi0/42',1),
573 (980,'gi0/43',1),
574 (980,'gi0/44',1),
575 (980,'gi0/45',1),
576 (980,'gi0/46',1),
577 (980,'gi0/47',1),
578 (980,'gi0/48',1),
579 (980,'gi0/5',1),
580 (980,'gi0/6',1),
581 (980,'gi0/7',1),
582 (980,'gi0/8',1),
583 (980,'gi0/9',1),
584 (981,'gi0/10',1),
585 (981,'gi0/11',1),
586 (981,'gi0/12',1),
587 (981,'gi0/2',1),
588 (981,'gi0/4',1),
589 (981,'gi0/5',1),
590 (981,'gi0/6',1),
591 (981,'gi0/7',1),
592 (981,'gi0/8',1),
593 (981,'gi0/9',1);
594
595 INSERT INTO `PortVLANMode` (`object_id`, `port_name`, `vlan_mode`) VALUES
596 (979,'gi0/1','trunk'),
597 (979,'gi0/10','access'),
598 (979,'gi0/11','access'),
599 (979,'gi0/12','access'),
600 (979,'gi0/13','access'),
601 (979,'gi0/14','access'),
602 (979,'gi0/15','access'),
603 (979,'gi0/16','access'),
604 (979,'gi0/17','access'),
605 (979,'gi0/18','access'),
606 (979,'gi0/19','access'),
607 (979,'gi0/2','trunk'),
608 (979,'gi0/20','access'),
609 (979,'gi0/21','access'),
610 (979,'gi0/22','access'),
611 (979,'gi0/23','access'),
612 (979,'gi0/24','trunk'),
613 (979,'gi0/3','access'),
614 (979,'gi0/4','access'),
615 (979,'gi0/5','access'),
616 (979,'gi0/6','access'),
617 (979,'gi0/7','access'),
618 (979,'gi0/8','access'),
619 (979,'gi0/9','access'),
620 (980,'gi0/0/1','trunk'),
621 (980,'gi0/0/10','access'),
622 (980,'gi0/0/11','access'),
623 (980,'gi0/0/12','access'),
624 (980,'gi0/0/13','access'),
625 (980,'gi0/0/14','access'),
626 (980,'gi0/0/15','access'),
627 (980,'gi0/0/16','access'),
628 (980,'gi0/0/17','access'),
629 (980,'gi0/0/18','access'),
630 (980,'gi0/0/19','access'),
631 (980,'gi0/0/2','access'),
632 (980,'gi0/0/20','access'),
633 (980,'gi0/0/21','access'),
634 (980,'gi0/0/22','access'),
635 (980,'gi0/0/23','access'),
636 (980,'gi0/0/24','access'),
637 (980,'gi0/0/25','access'),
638 (980,'gi0/0/26','access'),
639 (980,'gi0/0/27','access'),
640 (980,'gi0/0/28','access'),
641 (980,'gi0/0/29','access'),
642 (980,'gi0/0/3','access'),
643 (980,'gi0/0/30','access'),
644 (980,'gi0/0/31','access'),
645 (980,'gi0/0/32','access'),
646 (980,'gi0/0/33','access'),
647 (980,'gi0/0/34','access'),
648 (980,'gi0/0/35','access'),
649 (980,'gi0/0/36','access'),
650 (980,'gi0/0/37','access'),
651 (980,'gi0/0/38','access'),
652 (980,'gi0/0/39','access'),
653 (980,'gi0/0/4','access'),
654 (980,'gi0/0/40','access'),
655 (980,'gi0/0/41','access'),
656 (980,'gi0/0/42','access'),
657 (980,'gi0/0/43','access'),
658 (980,'gi0/0/44','access'),
659 (980,'gi0/0/45','access'),
660 (980,'gi0/0/46','access'),
661 (980,'gi0/0/47','access'),
662 (980,'gi0/0/48','trunk'),
663 (980,'gi0/0/5','access'),
664 (980,'gi0/0/6','access'),
665 (980,'gi0/0/7','access'),
666 (980,'gi0/0/8','access'),
667 (980,'gi0/0/9','access'),
668 (981,'gi0/1','trunk'),
669 (981,'gi0/10','trunk'),
670 (981,'gi0/11','trunk'),
671 (981,'gi0/12','trunk'),
672 (981,'gi0/2','trunk'),
673 (981,'gi0/3','trunk'),
674 (981,'gi0/4','trunk'),
675 (981,'gi0/5','trunk'),
676 (981,'gi0/6','trunk'),
677 (981,'gi0/7','trunk'),
678 (981,'gi0/8','trunk'),
679 (981,'gi0/9','trunk');
680
681 INSERT INTO `PortAllowedVLAN` (`object_id`, `port_name`, `vlan_id`) VALUES
682 (979,'gi0/1',7),
683 (979,'gi0/1',8),
684 (979,'gi0/1',9),
685 (979,'gi0/10',9),
686 (979,'gi0/11',9),
687 (979,'gi0/12',9),
688 (979,'gi0/13',3),
689 (979,'gi0/14',9),
690 (979,'gi0/15',9),
691 (979,'gi0/16',9),
692 (979,'gi0/17',9),
693 (979,'gi0/18',9),
694 (979,'gi0/19',9),
695 (979,'gi0/2',7),
696 (979,'gi0/2',8),
697 (979,'gi0/2',9),
698 (979,'gi0/20',9),
699 (979,'gi0/21',9),
700 (979,'gi0/22',9),
701 (979,'gi0/23',9),
702 (979,'gi0/24',3),
703 (979,'gi0/24',7),
704 (979,'gi0/24',8),
705 (979,'gi0/24',9),
706 (979,'gi0/3',9),
707 (979,'gi0/4',9),
708 (979,'gi0/5',9),
709 (979,'gi0/6',9),
710 (979,'gi0/7',9),
711 (979,'gi0/8',9),
712 (979,'gi0/9',9),
713 (980,'gi0/0/1',1),
714 (980,'gi0/0/1',11),
715 (980,'gi0/0/1',12),
716 (980,'gi0/0/1',13),
717 (980,'gi0/0/10',1),
718 (980,'gi0/0/11',1),
719 (980,'gi0/0/12',1),
720 (980,'gi0/0/13',1),
721 (980,'gi0/0/14',1),
722 (980,'gi0/0/15',1),
723 (980,'gi0/0/16',1),
724 (980,'gi0/0/17',1),
725 (980,'gi0/0/18',1),
726 (980,'gi0/0/19',1),
727 (980,'gi0/0/2',1),
728 (980,'gi0/0/20',1),
729 (980,'gi0/0/21',1),
730 (980,'gi0/0/22',1),
731 (980,'gi0/0/23',1),
732 (980,'gi0/0/24',1),
733 (980,'gi0/0/25',1),
734 (980,'gi0/0/26',1),
735 (980,'gi0/0/27',1),
736 (980,'gi0/0/28',1),
737 (980,'gi0/0/29',1),
738 (980,'gi0/0/3',1),
739 (980,'gi0/0/30',1),
740 (980,'gi0/0/31',1),
741 (980,'gi0/0/32',1),
742 (980,'gi0/0/33',1),
743 (980,'gi0/0/34',1),
744 (980,'gi0/0/35',1),
745 (980,'gi0/0/36',1),
746 (980,'gi0/0/37',1),
747 (980,'gi0/0/38',1),
748 (980,'gi0/0/39',1),
749 (980,'gi0/0/4',3),
750 (980,'gi0/0/40',1),
751 (980,'gi0/0/41',1),
752 (980,'gi0/0/42',1),
753 (980,'gi0/0/43',1),
754 (980,'gi0/0/44',1),
755 (980,'gi0/0/45',1),
756 (980,'gi0/0/46',1),
757 (980,'gi0/0/47',1),
758 (980,'gi0/0/48',3),
759 (980,'gi0/0/48',5),
760 (980,'gi0/0/48',11),
761 (980,'gi0/0/48',12),
762 (980,'gi0/0/48',13),
763 (980,'gi0/0/5',5),
764 (980,'gi0/0/6',1),
765 (980,'gi0/0/7',1),
766 (980,'gi0/0/8',1),
767 (980,'gi0/0/9',1),
768 (981,'gi0/1',3),
769 (981,'gi0/1',7),
770 (981,'gi0/1',8),
771 (981,'gi0/1',9),
772 (981,'gi0/10',1),
773 (981,'gi0/11',1),
774 (981,'gi0/12',1),
775 (981,'gi0/2',1),
776 (981,'gi0/3',3),
777 (981,'gi0/3',5),
778 (981,'gi0/3',11),
779 (981,'gi0/3',12),
780 (981,'gi0/3',13),
781 (981,'gi0/4',1),
782 (981,'gi0/5',1),
783 (981,'gi0/6',1),
784 (981,'gi0/7',1),
785 (981,'gi0/8',1),
786 (981,'gi0/9',1);
787
788 INSERT INTO `PortNativeVLAN` (`object_id`, `port_name`, `vlan_id`) VALUES
789 (979,'gi0/1',9),
790 (979,'gi0/10',9),
791 (979,'gi0/11',9),
792 (979,'gi0/12',9),
793 (979,'gi0/13',3),
794 (979,'gi0/14',9),
795 (979,'gi0/15',9),
796 (979,'gi0/16',9),
797 (979,'gi0/17',9),
798 (979,'gi0/18',9),
799 (979,'gi0/19',9),
800 (979,'gi0/2',9),
801 (979,'gi0/20',9),
802 (979,'gi0/21',9),
803 (979,'gi0/22',9),
804 (979,'gi0/23',9),
805 (979,'gi0/3',9),
806 (979,'gi0/4',9),
807 (979,'gi0/5',9),
808 (979,'gi0/6',9),
809 (979,'gi0/7',9),
810 (979,'gi0/8',9),
811 (979,'gi0/9',9),
812 (980,'gi0/0/1',1),
813 (980,'gi0/0/10',1),
814 (980,'gi0/0/11',1),
815 (980,'gi0/0/12',1),
816 (980,'gi0/0/13',1),
817 (980,'gi0/0/14',1),
818 (980,'gi0/0/15',1),
819 (980,'gi0/0/16',1),
820 (980,'gi0/0/17',1),
821 (980,'gi0/0/18',1),
822 (980,'gi0/0/19',1),
823 (980,'gi0/0/2',1),
824 (980,'gi0/0/20',1),
825 (980,'gi0/0/21',1),
826 (980,'gi0/0/22',1),
827 (980,'gi0/0/23',1),
828 (980,'gi0/0/24',1),
829 (980,'gi0/0/25',1),
830 (980,'gi0/0/26',1),
831 (980,'gi0/0/27',1),
832 (980,'gi0/0/28',1),
833 (980,'gi0/0/29',1),
834 (980,'gi0/0/3',1),
835 (980,'gi0/0/30',1),
836 (980,'gi0/0/31',1),
837 (980,'gi0/0/32',1),
838 (980,'gi0/0/33',1),
839 (980,'gi0/0/34',1),
840 (980,'gi0/0/35',1),
841 (980,'gi0/0/36',1),
842 (980,'gi0/0/37',1),
843 (980,'gi0/0/38',1),
844 (980,'gi0/0/39',1),
845 (980,'gi0/0/4',3),
846 (980,'gi0/0/40',1),
847 (980,'gi0/0/41',1),
848 (980,'gi0/0/42',1),
849 (980,'gi0/0/43',1),
850 (980,'gi0/0/44',1),
851 (980,'gi0/0/45',1),
852 (980,'gi0/0/46',1),
853 (980,'gi0/0/47',1),
854 (980,'gi0/0/5',5),
855 (980,'gi0/0/6',1),
856 (980,'gi0/0/7',1),
857 (980,'gi0/0/8',1),
858 (980,'gi0/0/9',1),
859 (981,'gi0/10',1),
860 (981,'gi0/11',1),
861 (981,'gi0/12',1),
862 (981,'gi0/2',1),
863 (981,'gi0/4',1),
864 (981,'gi0/5',1),
865 (981,'gi0/6',1),
866 (981,'gi0/7',1),
867 (981,'gi0/8',1),
868 (981,'gi0/9',1);
869
870 INSERT INTO `IPv4Address` (`ip`, `name`, `reserved`) VALUES
871 (180879678,'default gw','no'),
872 (180879617,'',NULL),
873 (180879680,'network','yes'),
874 (180879743,'broadcast','yes'),
875 (180879681,'',NULL),
876 (180879683,'',NULL),
877 (180879684,'',NULL),
878 (180879685,'',NULL),
879 (180879616,'network','yes'),
880 (180879679,'broadcast','yes'),
881 (180879686,'',NULL),
882 (180879687,'',NULL),
883 (180879360,'',NULL),
884 (180879361,'',NULL),
885 (180880192,'network','yes'),
886 (180880255,'broadcast','yes'),
887 (180880448,'network','yes'),
888 (180880511,'broadcast','yes'),
889 (180880384,'network','yes'),
890 (180880447,'broadcast','yes'),
891 (180880128,'network','no'),
892 (180880191,'broadcast','no'),
893 (180879936,'network','yes'),
894 (180879999,'broadcast','yes'),
895 (180879872,'network','yes'),
896 (180879935,'broadcast','yes'),
897 (180880193,'',NULL),
898 (180880194,'',NULL),
899 (180880195,'',NULL),
900 (180879618,'',NULL),
901 (180879677,'',NULL),
902 (180879676,'',NULL),
903 (180879675,'',NULL),
904 (180880254,'',NULL),
905 (180880504,'for field engineer','yes');
906
907 INSERT INTO `IPv4Allocation` (`object_id`, `ip`, `name`, `type`) VALUES
908 (905,180879678,'fa2/0','router'),
909 (906,180879617,'','regular'),
910 (910,180879681,'eth0','regular'),
911 (911,180879682,'eth0','regular'),
912 (912,180879683,'eth0','regular'),
913 (913,180879684,'eth0','regular'),
914 (914,180879685,'eth0','regular'),
915 (918,180879686,'bge0','regular'),
916 (919,180879687,'bge0','regular'),
917 (908,180879360,'se1/0','regular'),
918 (905,180879361,'se1/1','regular'),
919 (923,180880193,'eth0','regular'),
920 (924,180880194,'eth0','regular'),
921 (925,180880195,'eth0','regular'),
922 (915,180879618,'telnet access','regular'),
923 (915,180879677,'VIP3','regular'),
924 (915,180879676,'VIP2','regular'),
925 (915,180879675,'VIP1','regular'),
926 (910,180879675,'','virtual'),
927 (911,180879675,'','virtual'),
928 (912,180879675,'','virtual'),
929 (919,180879677,'','virtual'),
930 (918,180879677,'','virtual'),
931 (909,180880254,'fa2/0','router'),
932 (907,180879363,'se1/1','regular'),
933 (905,180879362,'se1/0','regular'),
934 (914,180879676,'','virtual'),
935 (913,180879676,'','virtual'),
936 (932,180879973,'','regular'),
937 (934,180879974,'','regular'),
938 (936,180879975,'','regular'),
939 (938,180879976,'','regular'),
940 (940,180879977,'','regular'),
941 (933,180879978,'','regular'),
942 (935,180879979,'','regular'),
943 (937,180879980,'','regular'),
944 (939,180879981,'','regular'),
945 (941,180879982,'','regular'),
946 (928,180879877,'','regular'),
947 (929,180879878,'','regular'),
948 (956,180880449,'eth0','regular'),
949 (957,180880450,'eth0','regular'),
950 (958,180880451,'eth0','regular'),
951 (959,180880452,'eth0','regular'),
952 (960,180880453,'eth0','regular'),
953 (908,180880510,'fa2/0','router'),
954 (962,180880386,'','regular'),
955 (909,180879366,'se1/0','regular'),
956 (908,180879367,'se1/1','regular'),
957 (909,180879365,'se1/1','regular'),
958 (907,180879364,'se1/0','regular'),
959 (907,180879998,'','shared'),
960 (927,180879998,'','shared'),
961 (908,180880446,'fa1/0','router'),
962 (961,180880385,'','regular');
963
964 INSERT INTO `IPv6Allocation` (`object_id`, `ip`, `name`, `type`) VALUES
965 ('908', 0xFC0014500001BEEF0000000000000001, 'fa1/0', 'router'),
966 ('919', 0xFC0014500001DEAD0000000000000001, 'bge1', 'router');
967
968 INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES
969 (96,180879616,26,'London network devices and VIPs'),
970 (97,180879680,26,'London HA server farm'),
971 (98,180879872,26,'New-York network devices'),
972 (99,180879936,26,'New-York servers'),
973 (108,180880192,26,'Tokyo server farm'),
974 (102,180879360,31,'M-L P2P'),
975 (103,180879362,31,'L-NY P2P'),
976 (104,180879364,31,'NY-T P2P'),
977 (105,180879366,31,'T-M P2P'),
978 (106,180880384,26,'Moscow network devices'),
979 (107,180880448,26,'Moscow servers');
980
981 INSERT INTO `IPv6Network` (`id`, `ip`, `mask`, `last_ip`, `name`, `comment`) VALUES
982 ('1', 0xFC000000000000000000000000000000, '7', 0xFDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF, 'Local IPv6', NULL),
983 ('2', 0xFC001450000100000000000000000000, '48', 0xFC0014500001FFFFFFFFFFFFFFFFFFFF, 'v6 Suballoc 1', NULL),
984 ('3', 0xFC001450000200000000000000000000, '48', 0xFC0014500002FFFFFFFFFFFFFFFFFFFF, 'v6 Suballoc 2', NULL),
985 ('4', 0xFC0014500001DEAD0000000000000000, '64', 0xFC0014500001DEADFFFFFFFFFFFFFFFF, 'dead net', NULL),
986 ('5', 0xFC0014500001BEEF0000000000000000, '64', 0xFC0014500001BEEFFFFFFFFFFFFFFFFF, 'beef net', NULL);
987
988 INSERT INTO `IPv4RSPool` (`id`, `name`, `vsconfig`, `rsconfig`) VALUES
989 (1,'Apache servers',NULL,NULL),
990 (2,'Resin servers',NULL,NULL);
991
992 INSERT INTO `IPv4VS` (`id`, `vip`, `vport`, `proto`, `name`, `vsconfig`, `rsconfig`) VALUES
993 (1,0x0AC80205,80,'TCP','virtual web','lvs_sched wlc\ndelay_loop 3\nalpha\nomega\nquorum 3\nhysteresis 1\n\n# this is a comment\n# VS name is %VNAME%\n#\n','CHECK=%CHECK_TCP%\n'),
994 (2,0x0AC80206,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}'),
995 (3,0x0000000C,NULL,'MARK','test fwmark service','lvs_sched wrr\nVIP=10.200.2.5\nMETHOD=TUN\nDELAY_LOOP=10','CHECK=%CHECK_TCP%');
996
997 INSERT INTO `IPv4LB` (`object_id`, `rspool_id`, `vs_id`, `prio`, `vsconfig`, `rsconfig`) VALUES
998 (928,1,1,NULL,NULL,NULL),
999 (929,1,1,NULL,NULL,NULL),
1000 (929,2,2,NULL,NULL,NULL);
1001
1002 INSERT INTO `IPv4RS` (`id`, `inservice`, `rsip`, `rsport`, `rspool_id`, `rsconfig`, `comment`) VALUES
1003 (1,'yes',0x0AC80265,80,1,NULL,NULL),
1004 (2,'yes',0x0AC80266,80,1,NULL,NULL),
1005 (3,'no',0x0AC80267,80,1,NULL,NULL),
1006 (4,'yes',0x0AC80268,80,1,NULL,NULL),
1007 (5,'yes',0x0AC80269,80,1,NULL,NULL),
1008 (6,'no',0x0AC8026A,8080,2,NULL,NULL),
1009 (7,'yes',0x0AC8026B,8080,2,NULL,NULL),
1010 (8,'yes',0x0AC8026C,8080,2,NULL,NULL),
1011 (9,'yes',0x0AC8026D,8080,2,NULL,NULL),
1012 (10,'yes',0x0AC8026E,8080,2,NULL,NULL);
1013
1014 INSERT INTO `PortInterfaceCompat` (`iif_id`, `oif_id`) VALUES
1015 (1,32);
1016
1017 INSERT INTO `Port` (`id`, `object_id`, `name`, `iif_id`, `type`, `l2address`, `reservation_comment`, `label`) VALUES
1018 (3057,905,'se1/0',1,32,NULL,NULL,''),
1019 (3058,905,'se1/1',1,32,NULL,NULL,''),
1020 (3059,905,'fa2/0',1,19,'00000000A001',NULL,''),
1021 (3060,905,'fa2/1',1,19,'00000000A002','ISP uplink',''),
1022 (3063,906,'gi1',1,24,'00000000B001',NULL,'1'),
1023 (3062,906,'gi2',1,24,'00000000B002',NULL,'2'),
1024 (3064,906,'gi3',1,24,'00000000B003',NULL,'3'),
1025 (3065,906,'gi4',1,24,'00000000B004',NULL,'4'),
1026 (3066,906,'gi5',1,24,'00000000B005',NULL,'5'),
1027 (3067,906,'gi6',1,24,'00000000B006',NULL,'6'),
1028 (3068,906,'gi7',1,24,'00000000B007',NULL,'7'),
1029 (3069,906,'gi8',1,24,'00000000B008',NULL,'8'),
1030 (3070,907,'se1/0',1,32,NULL,NULL,''),
1031 (3071,907,'se1/1',1,32,NULL,NULL,''),
1032 (3072,915,'e1',1,19,NULL,NULL,'1'),
1033 (3073,915,'e2',1,19,NULL,NULL,'2'),
1034 (3074,915,'e3',1,19,NULL,NULL,'3'),
1035 (3075,915,'e4',1,19,NULL,NULL,'4'),
1036 (3076,915,'e5',1,19,NULL,NULL,'5'),
1037 (3077,915,'e6',1,19,NULL,NULL,'6'),
1038 (3078,915,'e7',1,19,NULL,NULL,'7'),
1039 (3079,915,'e8',1,19,NULL,NULL,'8'),
1040 (3080,910,'eth0',1,24,NULL,NULL,'1'),
1041 (3081,910,'eth1',1,24,NULL,NULL,'2'),
1042 (3082,909,'se1/0',1,32,NULL,NULL,''),
1043 (3083,909,'se1/1',1,32,NULL,NULL,''),
1044 (3084,908,'se1/0',1,32,NULL,NULL,''),
1045 (3085,908,'se1/1',1,32,NULL,NULL,''),
1046 (3086,911,'eth0',1,24,NULL,NULL,'1'),
1047 (3087,911,'eth1',1,24,NULL,NULL,'2'),
1048 (3088,912,'eth0',1,24,NULL,NULL,'1'),
1049 (3089,912,'eth1',1,24,NULL,NULL,'2'),
1050 (3090,913,'eth0',1,24,NULL,NULL,'1'),
1051 (3091,913,'eth1',1,24,NULL,NULL,'2'),
1052 (3092,914,'eth0',1,24,NULL,NULL,'1'),
1053 (3093,914,'eth1',1,24,NULL,NULL,'2'),
1054 (3094,917,'fa0/0',1,19,NULL,NULL,''),
1055 (3095,919,'bge0',1,24,NULL,NULL,''),
1056 (3096,919,'bge1',1,24,NULL,NULL,''),
1057 (3097,918,'bge0',1,24,NULL,NULL,''),
1058 (3098,918,'bge1',1,24,NULL,NULL,''),
1059 (3099,909,'fa2/0',1,19,NULL,NULL,''),
1060 (3100,909,'fa2/1',1,19,NULL,'ISP uplink',''),
1061 (3101,926,'fa1',1,19,NULL,NULL,'1'),
1062 (3102,926,'fa2',1,19,NULL,NULL,'2'),
1063 (3103,926,'fa3',1,19,NULL,NULL,'3'),
1064 (3104,926,'fa4',1,19,NULL,NULL,'4'),
1065 (3105,926,'fa5',1,19,NULL,NULL,'5'),
1066 (3106,926,'fa6',1,19,NULL,NULL,'6'),
1067 (3107,926,'fa7',1,19,NULL,NULL,'7'),
1068 (3108,926,'fa8',1,19,NULL,NULL,'8'),
1069 (3109,926,'fa9',1,19,NULL,NULL,'9'),
1070 (3110,926,'fa10',1,19,NULL,NULL,'10'),
1071 (3111,926,'fa11',1,19,NULL,NULL,'11'),
1072 (3112,926,'fa12',1,19,NULL,NULL,'12'),
1073 (3113,923,'eth0',1,24,NULL,NULL,'1'),
1074 (3114,923,'eth1',1,24,NULL,NULL,'2'),
1075 (3115,924,'eth0',1,24,NULL,NULL,'1'),
1076 (3116,924,'eth1',1,24,NULL,NULL,'2'),
1077 (3117,925,'eth0',1,24,NULL,NULL,'1'),
1078 (3118,925,'eth1',1,24,NULL,NULL,'2'),
1079 (3119,908,'fa2/0',1,19,NULL,NULL,''),
1080 (3120,908,'fa2/1',1,19,NULL,'ISP uplink',''),
1081 (3121,907,'fa2/0',1,19,NULL,NULL,''),
1082 (3122,907,'fa2/1',1,19,NULL,NULL,''),
1083 (3123,927,'gi3/0',3,1202,NULL,'ISP uplink',''),
1084 (3124,927,'gi4/0',3,1202,NULL,NULL,''),
1085 (3125,907,'gi3/0',3,1202,NULL,'ISP uplink',''),
1086 (3126,907,'gi4/0',3,1202,NULL,NULL,''),
1087 (3127,956,'kvm',1,33,NULL,NULL,''),
1088 (3128,956,'eth0',1,24,NULL,NULL,''),
1089 (3129,956,'eth1',1,24,NULL,NULL,''),
1090 (3130,957,'kvm',1,33,NULL,NULL,''),
1091 (3131,957,'eth0',1,24,NULL,NULL,''),
1092 (3132,957,'eth1',1,24,NULL,NULL,''),
1093 (3133,958,'kvm',1,33,NULL,NULL,''),
1094 (3134,958,'eth0',1,24,NULL,NULL,''),
1095 (3135,958,'eth1',1,24,NULL,NULL,''),
1096 (3136,959,'kvm',1,33,NULL,NULL,''),
1097 (3137,959,'eth0',1,24,NULL,NULL,''),
1098 (3138,959,'eth1',1,24,NULL,NULL,''),
1099 (3139,960,'kvm',1,33,NULL,NULL,''),
1100 (3140,960,'eth0',1,24,NULL,NULL,''),
1101 (3141,960,'eth1',1,24,NULL,NULL,''),
1102 (3142,908,'con0',1,29,NULL,NULL,'console'),
1103 (3143,961,'1',1,24,'01040104AA00',NULL,''),
1104 (3144,961,'2',1,24,'01040104AA01','for field engineer',''),
1105 (3145,961,'3',1,24,'01040104AA02',NULL,''),
1106 (3146,961,'4',1,24,'01040104AA03',NULL,''),
1107 (3147,961,'5',1,24,'01040104AA04',NULL,''),
1108 (3148,961,'6',1,24,'01040104AA05',NULL,''),
1109 (3149,961,'7',1,24,'01040104AA06',NULL,''),
1110 (3150,961,'8',1,24,'01040104AA07',NULL,''),
1111 (3151,961,'9',1,24,'01040104AA08',NULL,''),
1112 (3152,961,'10',1,24,'01040104AA09',NULL,''),
1113 (3153,961,'11',1,24,'01040104AA0A',NULL,''),
1114 (3154,961,'12',1,24,'01040104AA0B',NULL,''),
1115 (3155,961,'13',1,24,'01040104AA0C',NULL,''),
1116 (3156,961,'14',1,24,'01040104AA0D',NULL,''),
1117 (3157,961,'15',1,24,'01040104AA0E',NULL,''),
1118 (3158,961,'16',1,24,'01040104AA0F',NULL,''),
1119 (3159,961,'con',1,681,NULL,NULL,'console'),
1120 (3160,956,'ttyS0',1,681,NULL,NULL,'serial A'),
1121 (3161,956,'ttyS1',1,681,NULL,NULL,'serial B'),
1122 (3162,962,'tail1',1,446,NULL,NULL,''),
1123 (3163,962,'tail2',1,446,NULL,NULL,''),
1124 (3164,962,'tail3',1,446,NULL,NULL,''),
1125 (3165,962,'tail4',1,446,NULL,NULL,''),
1126 (3166,962,'tail5',1,446,NULL,NULL,''),
1127 (3167,962,'tail6',1,446,NULL,NULL,''),
1128 (3168,962,'tail7',1,446,NULL,NULL,''),
1129 (3169,962,'tail8',1,446,NULL,NULL,''),
1130 (3170,962,'head',1,33,NULL,'monitor connected',''),
1131 (3171,962,'net',1,19,'020002003333',NULL,''),
1132 (3178,927,'fa1/0',1,19,NULL,NULL,''),
1133 (3179,908,'fa1/0',1,19,NULL,NULL,''),
1134 (3180,955,'in',1,16,NULL,'from local distribution',''),
1135 (3181,955,'out1',1,1322,NULL,NULL,''),
1136 (3182,955,'out2',1,1322,NULL,NULL,''),
1137 (3183,955,'out3',1,1322,NULL,NULL,''),
1138 (3184,955,'out4',1,1322,NULL,NULL,''),
1139 (3185,955,'out5',1,1322,NULL,NULL,''),
1140 (3186,923,'ps',1,16,NULL,NULL,''),
1141 (3187,924,'ps',1,16,NULL,NULL,''),
1142 (3188,925,'ps',1,16,NULL,NULL,''),
1143 (3189,926,'ps',1,16,NULL,NULL,''),
1144 (3190,909,'ps',1,16,NULL,NULL,''),
1145 (3191,979,'gi0/1',1,24,NULL,NULL,''),
1146 (3192,979,'gi0/2',1,24,NULL,NULL,''),
1147 (3193,979,'gi0/3',1,24,NULL,NULL,''),
1148 (3194,979,'gi0/4',1,24,NULL,NULL,''),
1149 (3195,979,'gi0/5',1,24,NULL,NULL,''),
1150 (3196,979,'gi0/6',1,24,NULL,NULL,''),
1151 (3197,979,'gi0/7',1,24,NULL,NULL,''),
1152 (3198,979,'gi0/8',1,24,NULL,NULL,''),
1153 (3199,979,'gi0/9',1,24,NULL,NULL,''),
1154 (3200,979,'gi0/10',1,24,NULL,NULL,''),
1155 (3201,979,'gi0/11',1,24,NULL,NULL,''),
1156 (3202,979,'gi0/12',1,24,NULL,NULL,''),
1157 (3203,979,'gi0/13',1,24,NULL,NULL,''),
1158 (3204,979,'gi0/14',1,24,NULL,NULL,''),
1159 (3205,979,'gi0/15',1,24,NULL,NULL,''),
1160 (3206,979,'gi0/16',1,24,NULL,NULL,''),
1161 (3207,979,'gi0/17',1,24,NULL,NULL,''),
1162 (3208,979,'gi0/18',1,24,NULL,NULL,''),
1163 (3209,979,'gi0/19',1,24,NULL,NULL,''),
1164 (3210,979,'gi0/20',1,24,NULL,NULL,''),
1165 (3211,979,'gi0/21',1,24,NULL,NULL,''),
1166 (3212,979,'gi0/22',1,24,NULL,NULL,''),
1167 (3213,979,'gi0/23',1,24,NULL,NULL,''),
1168 (3214,979,'gi0/24',1,24,NULL,NULL,''),
1169 (3215,980,'gi0/0/1',1,24,NULL,NULL,''),
1170 (3216,980,'gi0/0/2',1,24,NULL,NULL,''),
1171 (3217,980,'gi0/0/3',1,24,NULL,NULL,''),
1172 (3218,980,'gi0/0/4',1,24,NULL,NULL,''),
1173 (3219,980,'gi0/0/5',1,24,NULL,NULL,''),
1174 (3220,980,'gi0/0/6',1,24,NULL,NULL,''),
1175 (3221,980,'gi0/0/7',1,24,NULL,NULL,''),
1176 (3222,980,'gi0/0/8',1,24,NULL,NULL,''),
1177 (3223,980,'gi0/0/9',1,24,NULL,NULL,''),
1178 (3224,980,'gi0/0/10',1,24,NULL,NULL,''),
1179 (3225,980,'gi0/0/11',1,24,NULL,NULL,''),
1180 (3226,980,'gi0/0/12',1,24,NULL,NULL,''),
1181 (3227,980,'gi0/0/13',1,24,NULL,NULL,''),
1182 (3228,980,'gi0/0/14',1,24,NULL,NULL,''),
1183 (3229,980,'gi0/0/15',1,24,NULL,NULL,''),
1184 (3230,980,'gi0/0/16',1,24,NULL,NULL,''),
1185 (3231,980,'gi0/0/17',1,24,NULL,NULL,''),
1186 (3232,980,'gi0/0/18',1,24,NULL,NULL,''),
1187 (3233,980,'gi0/0/19',1,24,NULL,NULL,''),
1188 (3234,980,'gi0/0/20',1,24,NULL,NULL,''),
1189 (3235,980,'gi0/0/21',1,24,NULL,NULL,''),
1190 (3236,980,'gi0/0/22',1,24,NULL,NULL,''),
1191 (3237,980,'gi0/0/23',1,24,NULL,NULL,''),
1192 (3238,980,'gi0/0/24',1,24,NULL,NULL,''),
1193 (3239,980,'gi0/0/25',1,24,NULL,NULL,''),
1194 (3240,980,'gi0/0/26',1,24,NULL,NULL,''),
1195 (3241,980,'gi0/0/27',1,24,NULL,NULL,''),
1196 (3242,980,'gi0/0/28',1,24,NULL,NULL,''),
1197 (3243,980,'gi0/0/29',1,24,NULL,NULL,''),
1198 (3244,980,'gi0/0/30',1,24,NULL,NULL,''),
1199 (3245,980,'gi0/0/31',1,24,NULL,NULL,''),
1200 (3246,980,'gi0/0/32',1,24,NULL,NULL,''),
1201 (3247,980,'gi0/0/33',1,24,NULL,NULL,''),
1202 (3248,980,'gi0/0/34',1,24,NULL,NULL,''),
1203 (3249,980,'gi0/0/35',1,24,NULL,NULL,''),
1204 (3250,980,'gi0/0/36',1,24,NULL,NULL,''),
1205 (3251,980,'gi0/0/37',1,24,NULL,NULL,''),
1206 (3252,980,'gi0/0/38',1,24,NULL,NULL,''),
1207 (3253,980,'gi0/0/39',1,24,NULL,NULL,''),
1208 (3254,980,'gi0/0/40',1,24,NULL,NULL,''),
1209 (3255,980,'gi0/0/41',1,24,NULL,NULL,''),
1210 (3256,980,'gi0/0/42',1,24,NULL,NULL,''),
1211 (3257,980,'gi0/0/43',1,24,NULL,NULL,''),
1212 (3258,980,'gi0/0/44',1,24,NULL,NULL,''),
1213 (3259,980,'gi0/0/45',1,24,NULL,NULL,''),
1214 (3260,980,'gi0/0/46',1,24,NULL,NULL,''),
1215 (3261,980,'gi0/0/47',1,24,NULL,NULL,''),
1216 (3262,980,'gi0/0/48',1,24,NULL,NULL,''),
1217 (3263,981,'gi0/1',1,24,NULL,NULL,''),
1218 (3264,981,'gi0/2',1,24,NULL,NULL,''),
1219 (3265,981,'gi0/3',1,24,NULL,NULL,''),
1220 (3266,981,'gi0/4',1,24,NULL,NULL,''),
1221 (3267,981,'gi0/5',1,24,NULL,NULL,''),
1222 (3268,981,'gi0/6',1,24,NULL,NULL,''),
1223 (3269,981,'gi0/7',1,24,NULL,NULL,''),
1224 (3270,981,'gi0/8',1,24,NULL,NULL,''),
1225 (3271,981,'gi0/9',1,24,NULL,NULL,''),
1226 (3272,981,'gi0/10',1,24,NULL,NULL,''),
1227 (3273,981,'gi0/11',1,24,NULL,NULL,''),
1228 (3274,981,'gi0/12',1,24,NULL,NULL,'');
1229
1230 INSERT INTO `Link` (`porta`, `portb`) VALUES
1231 (3057,3071),
1232 (3058,3084),
1233 (3059,3069),
1234 (3062,3094),
1235 (3063,3079),
1236 (3070,3083),
1237 (3072,3080),
1238 (3073,3086),
1239 (3074,3088),
1240 (3075,3090),
1241 (3076,3092),
1242 (3077,3097),
1243 (3078,3095),
1244 (3082,3085),
1245 (3099,3112),
1246 (3101,3113),
1247 (3102,3114),
1248 (3103,3115),
1249 (3104,3116),
1250 (3105,3117),
1251 (3106,3118),
1252 (3142,3160),
1253 (3159,3161),
1254 (3134,3143),
1255 (3119,3147),
1256 (3131,3148),
1257 (3137,3151),
1258 (3140,3154),
1259 (3128,3158),
1260 (3127,3162),
1261 (3130,3163),
1262 (3133,3164),
1263 (3136,3165),
1264 (3139,3168),
1265 (3145,3171),
1266 (3124,3126),
1267 (3181,3186),
1268 (3182,3187),
1269 (3183,3190),
1270 (3184,3188),
1271 (3185,3189),
1272 (3096,3219),
1273 (3098,3191),
1274 (3214,3263),
1275 (3262,3265);
1276
1277 INSERT INTO `IPv4NAT` (`object_id`, `proto`, `localip`, `localport`, `remoteip`, `remoteport`, `description`) VALUES
1278 (915,'TCP',180879675,80,180879681,80,''),
1279 (915,'TCP',180879675,80,180879682,80,''),
1280 (915,'TCP',180879675,80,180879683,80,''),
1281 (915,'UDP',180879676,53,180879684,53,''),
1282 (915,'UDP',180879676,53,180879685,53,''),
1283 (915,'TCP',180879677,443,180879686,443,''),
1284 (915,'TCP',180879677,443,180879687,443,'');
1285
1286 INSERT INTO `RackSpace` (`rack_id`, `unit_no`, `atom`, `state`, `object_id`) VALUES
1287 (968,9,'interior','T',905),
1288 (968,9,'front','T',905),
1289 (968,10,'interior','T',905),
1290 (968,10,'front','T',905),
1291 (968,11,'interior','T',905),
1292 (968,11,'front','T',905),
1293 (968,7,'front','T',906),
1294 (968,7,'interior','T',906),
1295 (970,16,'interior','T',907),
1296 (970,16,'rear','T',907),
1297 (970,15,'interior','T',907),
1298 (970,15,'rear','T',907),
1299 (970,14,'interior','T',907),
1300 (970,14,'rear','T',907),
1301 (974,15,'interior','T',909),
1302 (974,15,'rear','T',909),
1303 (974,14,'interior','T',909),
1304 (974,14,'rear','T',909),
1305 (974,13,'interior','T',909),
1306 (974,13,'rear','T',909),
1307 (972,20,'interior','T',908),
1308 (972,20,'rear','T',908),
1309 (972,19,'interior','T',908),
1310 (972,19,'rear','T',908),
1311 (972,18,'interior','T',908),
1312 (972,18,'rear','T',908),
1313 (967,2,'front','T',910),
1314 (967,2,'interior','T',910),
1315 (967,2,'rear','T',910),
1316 (967,4,'front','T',911),
1317 (967,4,'interior','T',911),
1318 (967,4,'rear','T',911),
1319 (967,6,'front','T',912),
1320 (967,6,'interior','T',912),
1321 (967,6,'rear','T',912),
1322 (967,8,'front','T',913),
1323 (967,8,'interior','T',913),
1324 (967,8,'rear','T',913),
1325 (967,10,'front','T',914),
1326 (967,10,'interior','T',914),
1327 (967,10,'rear','T',914),
1328 (967,23,'rear','T',916),
1329 (967,23,'interior','T',916),
1330 (967,23,'front','T',916),
1331 (968,5,'front','T',915),
1332 (968,5,'interior','T',915),
1333 (968,4,'interior','T',915),
1334 (968,4,'front','T',915),
1335 (967,22,'front','T',916),
1336 (967,22,'interior','T',916),
1337 (967,22,'rear','T',916),
1338 (969,7,'front','T',918),
1339 (969,7,'interior','T',918),
1340 (969,7,'rear','T',918),
1341 (969,6,'front','T',918),
1342 (969,6,'interior','T',918),
1343 (969,6,'rear','T',918),
1344 (969,5,'front','T',918),
1345 (969,5,'interior','T',918),
1346 (969,5,'rear','T',918),
1347 (969,4,'front','T',918),
1348 (969,4,'interior','T',918),
1349 (969,4,'rear','T',918),
1350 (969,3,'front','T',918),
1351 (969,3,'interior','T',918),
1352 (969,3,'rear','T',918),
1353 (969,13,'front','T',919),
1354 (969,13,'interior','T',919),
1355 (969,13,'rear','T',919),
1356 (969,12,'front','T',919),
1357 (969,12,'interior','T',919),
1358 (969,12,'rear','T',919),
1359 (969,11,'front','T',919),
1360 (969,11,'interior','T',919),
1361 (969,11,'rear','T',919),
1362 (969,10,'front','T',919),
1363 (969,10,'interior','T',919),
1364 (969,10,'rear','T',919),
1365 (969,9,'front','T',919),
1366 (969,9,'interior','T',919),
1367 (969,9,'rear','T',919),
1368 (969,37,'front','T',920),
1369 (969,37,'interior','T',920),
1370 (969,37,'rear','T',920),
1371 (969,36,'front','T',920),
1372 (969,36,'interior','T',920),
1373 (969,36,'rear','T',920),
1374 (969,35,'front','T',920),
1375 (969,35,'interior','T',920),
1376 (969,35,'rear','T',920),
1377 (969,34,'front','T',920),
1378 (969,34,'interior','T',920),
1379 (969,34,'rear','T',920),
1380 (969,33,'front','T',920),
1381 (969,33,'interior','T',920),
1382 (969,33,'rear','T',920),
1383 (969,32,'front','T',920),
1384 (969,32,'interior','T',920),
1385 (969,32,'rear','T',920),
1386 (969,31,'front','T',920),
1387 (969,31,'interior','T',920),
1388 (969,31,'rear','T',920),
1389 (969,30,'front','T',920),
1390 (969,30,'interior','T',920),
1391 (969,30,'rear','T',920),
1392 (969,16,'front','T',921),
1393 (969,16,'interior','T',921),
1394 (969,16,'rear','T',921),
1395 (969,15,'front','T',921),
1396 (969,15,'interior','T',921),
1397 (969,15,'rear','T',921),
1398 (969,18,'front','T',922),
1399 (969,18,'interior','T',922),
1400 (969,18,'rear','T',922),
1401 (969,17,'front','T',922),
1402 (969,17,'interior','T',922),
1403 (969,17,'rear','T',922),
1404 (974,11,'interior','T',926),
1405 (974,11,'rear','T',926),
1406 (974,1,'front','T',923),
1407 (974,1,'interior','T',923),
1408 (974,1,'rear','T',923),
1409 (974,3,'front','T',924),
1410 (974,3,'interior','T',924),
1411 (974,3,'rear','T',924),
1412 (974,5,'front','T',925),
1413 (974,5,'interior','T',925),
1414 (974,5,'rear','T',925),
1415 (970,12,'interior','T',927),
1416 (970,12,'rear','T',927),
1417 (970,11,'interior','T',927),
1418 (970,11,'rear','T',927),
1419 (970,10,'interior','T',927),
1420 (970,10,'rear','T',927),
1421 (970,2,'front','T',944),
1422 (970,2,'interior','T',944),
1423 (970,2,'rear','T',944),
1424 (970,1,'front','T',944),
1425 (970,1,'interior','T',944),
1426 (970,1,'rear','T',944),
1427 (971,5,'front','T',942),
1428 (971,5,'interior','T',942),
1429 (971,5,'rear','T',942),
1430 (971,4,'front','T',942),
1431 (971,4,'interior','T',942),
1432 (971,4,'rear','T',942),
1433 (971,3,'front','T',942),
1434 (971,3,'interior','T',942),
1435 (971,3,'rear','T',942),
1436 (971,2,'front','T',942),
1437 (971,2,'interior','T',942),
1438 (971,2,'rear','T',942),
1439 (971,1,'front','T',942),
1440 (971,1,'interior','T',942),
1441 (971,1,'rear','T',942),
1442 (973,5,'front','T',943),
1443 (973,5,'interior','T',943),
1444 (973,5,'rear','T',943),
1445 (973,4,'front','T',943),
1446 (973,4,'interior','T',943),
1447 (973,4,'rear','T',943),
1448 (973,3,'front','T',943),
1449 (973,3,'interior','T',943),
1450 (973,3,'rear','T',943),
1451 (973,2,'front','T',943),
1452 (973,2,'interior','T',943),
1453 (973,2,'rear','T',943),
1454 (973,1,'front','T',943),
1455 (973,1,'interior','T',943),
1456 (973,1,'rear','T',943),
1457 (971,6,'front','U',NULL),
1458 (971,6,'interior','U',NULL),
1459 (971,6,'rear','U',NULL),
1460 (973,6,'front','U',NULL),
1461 (973,6,'interior','U',NULL),
1462 (973,6,'rear','U',NULL),
1463 (973,17,'rear','T',954),
1464 (972,20,'front','T',953),
1465 (968,6,'front','T',952),
1466 (967,1,'rear','T',949),
1467 (973,37,'rear','T',931),
1468 (973,37,'interior','T',931),
1469 (973,40,'rear','T',929),
1470 (973,40,'interior','T',929),
1471 (973,15,'rear','T',941),
1472 (973,15,'interior','T',941),
1473 (973,15,'front','T',941),
1474 (973,13,'front','T',939),
1475 (973,11,'rear','T',937),
1476 (973,11,'interior','T',937),
1477 (973,9,'interior','T',935),
1478 (973,7,'interior','T',933),
1479 (974,16,'rear','T',946),
1480 (971,38,'rear','T',930),
1481 (971,40,'interior','T',928),
1482 (971,15,'rear','T',940),
1483 (971,13,'rear','T',938),
1484 (971,11,'rear','T',936),
1485 (971,9,'rear','T',934),
1486 (971,7,'rear','T',932),
1487 (968,12,'rear','A',NULL),
1488 (968,11,'rear','A',NULL),
1489 (968,10,'rear','A',NULL),
1490 (968,9,'rear','A',NULL),
1491 (968,8,'rear','A',NULL),
1492 (968,7,'rear','A',NULL),
1493 (968,6,'rear','A',NULL),
1494 (968,5,'rear','A',NULL),
1495 (968,4,'rear','A',NULL),
1496 (968,3,'rear','A',NULL),
1497 (968,2,'rear','A',NULL),
1498 (968,1,'rear','A',NULL),
1499 (974,9,'rear','T',955),
1500 (971,17,'rear','T',951),
1501 (970,9,'rear','T',948),
1502 (969,14,'rear','T',950),
1503 (969,2,'rear','T',947),
1504 (973,38,'rear','T',931),
1505 (973,38,'interior','T',931),
1506 (973,41,'rear','T',929),
1507 (973,41,'interior','T',929),
1508 (973,13,'rear','T',939),
1509 (973,13,'interior','T',939),
1510 (973,11,'front','T',937),
1511 (973,9,'rear','T',935),
1512 (973,9,'front','T',935),
1513 (973,7,'rear','T',933),
1514 (973,7,'front','T',933),
1515 (970,13,'rear','T',945),
1516 (971,37,'rear','T',930),
1517 (971,37,'interior','T',930),
1518 (971,38,'interior','T',930),
1519 (971,40,'rear','T',928),
1520 (971,41,'rear','T',928),
1521 (971,41,'interior','T',928),
1522 (971,15,'interior','T',940),
1523 (971,15,'front','T',940),
1524 (971,13,'interior','T',938),
1525 (971,13,'front','T',938),
1526 (971,11,'interior','T',936),
1527 (971,11,'front','T',936),
1528 (971,9,'interior','T',934),
1529 (971,9,'front','T',934),
1530 (971,7,'interior','T',932),
1531 (971,7,'front','T',932),
1532 (968,2,'front','T',917),
1533 (968,2,'interior','T',917),
1534 (968,1,'front','T',917),
1535 (968,1,'interior','T',917),
1536 (972,2,'front','T',956),
1537 (972,2,'interior','T',956),
1538 (972,2,'rear','T',956),
1539 (972,4,'front','T',957),
1540 (972,4,'interior','T',957),
1541 (972,4,'rear','T',957),
1542 (972,6,'front','T',958),
1543 (972,6,'interior','T',958),
1544 (972,6,'rear','T',958),
1545 (972,8,'front','T',959),
1546 (972,8,'interior','T',959),
1547 (972,8,'rear','T',959),
1548 (972,10,'front','T',960),
1549 (972,10,'interior','T',960),
1550 (972,10,'rear','T',960),
1551 (972,35,'interior','T',961),
1552 (972,35,'rear','T',961),
1553 (972,34,'interior','T',962),
1554 (972,34,'rear','T',962),
1555 (967,35,'front','T',981),
1556 (967,35,'interior','T',981);
1557
1558 INSERT INTO `Script` (`script_name`, `script_text`) VALUES
1559 ('DefaultRSConfig','CONNECT_TIMEOUT=1\nCONNECT_PORT=%RSPORT%\nCHECK_TCP=`TCP_CHECK {\n connect_port %CONNECT_PORT%\n connect_timeout %CONNECT_TIMEOUT% \n}\'\n%CHECK%\n'),
1560 ('DefaultVSConfig','METHOD=NAT\nlvs_method %METHOD%\n');
1561
1562 INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES
1563 (1,NULL,'testing'),
1564 (2,NULL,'production'),
1565 (10,NULL,'network'),
1566 (5,10,'WAN link'),
1567 (6,NULL,'racks'),
1568 (7,6,'tall racks'),
1569 (8,6,'low racks'),
1570 (9,NULL,'load balancer'),
1571 (11,10,'small network'),
1572 (12,10,'medium network'),
1573 (16,NULL,'XKCD'),
1574 (17,16,'romance'),
1575 (18,16,'sarcasm'),
1576 (19,16,'math'),
1577 (20,16,'language'),
1578 (21,NULL,'vlan template'),
1579 (22,21,'access switch template'),
1580 (23,21,'distribution switch template');
1581
1582 INSERT INTO `TagStorage` (`entity_realm`, `entity_id`, `tag_id`, `user`, `date`) VALUES
1583 ('object',905,1,'john_doe','2012-06-01'),
1584 ('object',908,2,'john_doe','2012-06-01'),
1585 ('object',909,1,'john_doe','2012-06-01'),
1586 ('object',928,9,'john_doe','2012-06-01'),
1587 ('object',929,9,'john_doe','2012-06-01'),
1588 ('object',956,2,'john_doe','2012-06-01'),
1589 ('object',957,2,'john_doe','2012-06-01'),
1590 ('object',958,2,'john_doe','2012-06-01'),
1591 ('object',959,2,'john_doe','2012-06-01'),
1592 ('object',960,2,'john_doe','2012-06-01'),
1593 ('object',961,2,'john_doe','2012-06-01'),
1594 ('object',962,2,'john_doe','2012-06-01'),
1595 ('ipv4net',96,12,'john_doe','2012-06-01'),
1596 ('ipv4net',97,12,'john_doe','2012-06-01'),
1597 ('ipv4net',98,12,'john_doe','2012-06-01'),
1598 ('ipv4net',99,12,'john_doe','2012-06-01'),
1599 ('ipv4net',102,5,'john_doe','2012-06-01'),
1600 ('ipv4net',102,11,'john_doe','2012-06-01'),
1601 ('ipv4net',103,5,'john_doe','2012-06-01'),
1602 ('ipv4net',103,11,'john_doe','2012-06-01'),
1603 ('ipv4net',104,5,'john_doe','2012-06-01'),
1604 ('ipv4net',104,11,'john_doe','2012-06-01'),
1605 ('ipv4net',105,5,'john_doe','2012-06-01'),
1606 ('ipv4net',105,11,'john_doe','2012-06-01'),
1607 ('ipv4net',106,12,'john_doe','2012-06-01'),
1608 ('ipv4net',107,12,'john_doe','2012-06-01'),
1609 ('ipv4net',108,12,'john_doe','2012-06-01'),
1610 ('rack',967,7,'john_doe','2012-06-01'),
1611 ('rack',968,8,'john_doe','2012-06-01'),
1612 ('rack',969,7,'john_doe','2012-06-01'),
1613 ('rack',970,8,'john_doe','2012-06-01'),
1614 ('rack',971,7,'john_doe','2012-06-01'),
1615 ('rack',972,7,'john_doe','2012-06-01'),
1616 ('rack',973,7,'john_doe','2012-06-01'),
1617 ('rack',974,8,'john_doe','2012-06-01'),
1618 ('ipv6net','1','10','john_doe','2012-06-01'),
1619 ('ipv6net','2','12','john_doe','2012-06-01'),
1620 ('ipv6net','3','12','john_doe','2012-06-01'),
1621 ('ipv6net','4','18','john_doe','2012-06-01'),
1622 ('ipv6net','5','18','john_doe','2012-06-01'),
1623 ('object',979,12,'john_doe','2012-06-01'),
1624 ('object',980,12,'john_doe','2012-06-01'),
1625 ('object',981,12,'john_doe','2012-06-01'),
1626 ('vst',1,22,'john_doe','2012-06-01'),
1627 ('vst',2,22,'john_doe','2012-06-01'),
1628 ('vst',3,23,'john_doe','2012-06-01');
1629
1630 INSERT INTO `VLANDomain` (`id`, `description`) VALUES
1631 (2,'English'),
1632 (1,'русский'),
1633 (3,'українська'),
1634 (4,'日本語');
1635
1636 INSERT INTO `VLANDescription` (`domain_id`, `vlan_id`, `vlan_type`, `vlan_descr`) VALUES
1637 (1,1,'compulsory','default'),
1638 (1,2,'ondemand','второй'),
1639 (1,3,'ondemand','третий'),
1640 (1,4,'ondemand','четвёртый'),
1641 (1,5,'ondemand','пятый'),
1642 (1,6,'ondemand','шестой'),
1643 (1,7,'ondemand','седьмой'),
1644 (1,8,'ondemand','восьмой'),
1645 (1,9,'ondemand','девятый'),
1646 (1,10,'ondemand','десятый'),
1647 (1,11,'ondemand','одиннадцатый'),
1648 (1,12,'ondemand','двенадцатый'),
1649 (1,13,'ondemand','тринадцатый'),
1650 (1,14,'ondemand','четырнадцатый'),
1651 (1,15,'ondemand','пятнадцатый'),
1652 (2,1,'compulsory','default'),
1653 (2,2,'ondemand','second'),
1654 (2,3,'ondemand','third'),
1655 (2,4,'ondemand','fourth'),
1656 (2,5,'ondemand','fifth'),
1657 (2,6,'ondemand','sixth'),
1658 (2,7,'ondemand','seventh'),
1659 (2,8,'ondemand','eighth'),
1660 (2,9,'ondemand','ninth'),
1661 (2,10,'ondemand','tenth'),
1662 (2,11,'ondemand','eleventh'),
1663 (2,12,'ondemand','twelfth'),
1664 (2,13,'ondemand','thirteenth'),
1665 (2,14,'ondemand','fourteenth'),
1666 (2,15,'ondemand','fifteenth'),
1667 (3,1,'compulsory','default'),
1668 (3,2,'ondemand','другий'),
1669 (3,3,'ondemand','третій'),
1670 (3,4,'ondemand','четвертий'),
1671 (3,5,'ondemand','п\'ятий'),
1672 (3,6,'ondemand','шостий'),
1673 (3,7,'ondemand','сьомий'),
1674 (3,8,'ondemand','восьмий'),
1675 (3,9,'ondemand','дев\'ятий'),
1676 (3,10,'ondemand','десятий'),
1677 (3,11,'ondemand','одинадцятий'),
1678 (3,12,'ondemand','дванадцятий'),
1679 (3,13,'ondemand','тринадцятий'),
1680 (3,14,'ondemand','чотирнадцятий'),
1681 (3,15,'ondemand','п\'ятнадцятий'),
1682 (4,1,'compulsory','default'),
1683 (4,2,'ondemand','第二'),
1684 (4,3,'ondemand','第三'),
1685 (4,4,'ondemand','第四'),
1686 (4,5,'ondemand','第五'),
1687 (4,6,'ondemand','第六'),
1688 (4,7,'ondemand','第七'),
1689 (4,8,'ondemand','第八'),
1690 (4,9,'ondemand','第九'),
1691 (4,10,'ondemand','第十'),
1692 (4,11,'ondemand','第十一'),
1693 (4,12,'ondemand','第十二'),
1694 (4,13,'ondemand','第十三'),
1695 (4,14,'ondemand','第十四'),
1696 (4,15,'ondemand','第十五');
1697
1698 INSERT INTO `VLANSwitchTemplate` (`id`, `mutex_rev`, `description`, `saved_by`) VALUES
1699 (1,1,'24 ports switch','admin'),
1700 (2,1,'48 ports switch','admin'),
1701 (3,1,'distribution switch','admin');
1702
1703 INSERT INTO `VLANSTRule` (`vst_id`, `rule_no`, `port_pcre`, `port_role`, `wrt_vlans`, `description`) VALUES
1704 (1,100,'#[^\\d]24#','uplink','','uplink'),
1705 (1,999,'#.#','anymode','','user-defined'),
1706 (2,100,'#[^\\d]48#','uplink','','uplink'),
1707 (2,999,'#.#','anymode','','user-defined'),
1708 (3,999,'/./','downlink','','access switches');
1709
1710 INSERT INTO `VLANSwitch` (`object_id`, `domain_id`, `template_id`, `mutex_rev`, `out_of_sync`, `last_errno`, `last_change`, `last_push_started`, `last_push_finished`, `last_error_ts`) VALUES
1711 (979,2,1,4,'no',0,'2012-09-09 16:11:57','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00'),
1712 (980,2,2,4,'no',0,'2012-09-09 16:16:22','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00'),
1713 (981,2,3,1,'no',0,'2012-09-09 16:16:53','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00');