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