init-sample-racks.sql: VSG sample added
[racktables] / 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),
83(981,'sw-d1',NULL,8,NULL,'no',NULL);
9b8174d7 84
968743bc
DO
85INSERT INTO `Atom` (`molecule_id`, `rack_id`, `unit_no`, `atom`) VALUES
86(1,967,35,'front'),
87(1,967,35,'interior');
bbf4cf4f 88
9b8174d7 89INSERT INTO `EntityLink` (`parent_entity_type`, `parent_entity_id`, `child_entity_type`, `child_entity_id`) VALUES
e1add254
AD
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),
0978a2b9
AA
101('location',978,'row',966),
102('rack',968,'object',979),
103('rack',969,'object',980);
cafd4cf3 104
968743bc
DO
105INSERT 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);
0978a2b9 175
968743bc
DO
176INSERT 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');
0978a2b9 309
968743bc
DO
310INSERT 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);
0978a2b9 464
968743bc
DO
465INSERT 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);
0978a2b9 594
968743bc
DO
595INSERT 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');
0978a2b9 680
968743bc
DO
681INSERT 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);
0978a2b9 787
968743bc
DO
788INSERT 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);
e673ee24 869
968743bc
DO
870INSERT 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');
e673ee24 906
968743bc
DO
907INSERT 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');
1365dddb 963
968743bc
DO
964INSERT INTO `IPv6Allocation` (`object_id`, `ip`, `name`, `type`) VALUES
965('908', 0xFC0014500001BEEF0000000000000001, 'fa1/0', 'router'),
966('919', 0xFC0014500001DEAD0000000000000001, 'bge1', 'router');
20ac2076 967
968743bc
DO
968INSERT 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');
e673ee24 980
968743bc
DO
981INSERT 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);
20ac2076 987
968743bc
DO
988INSERT INTO `IPv4RSPool` (`id`, `name`, `vsconfig`, `rsconfig`) VALUES
989(1,'Apache servers',NULL,NULL),
990(2,'Resin servers',NULL,NULL);
4d87feaf 991
968743bc
DO
992INSERT 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%');
cafd4cf3 996
968743bc
DO
997INSERT 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);
cafd4cf3 1001
968743bc
DO
1002INSERT 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);
1365dddb 1013
968743bc 1014INSERT INTO `PortInterfaceCompat` (`iif_id`, `oif_id`) VALUES
fc8e1110 1015(1,32);
e673ee24 1016
968743bc
DO
1017INSERT 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,'');
f000e1cd 1229
968743bc
DO
1230INSERT 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);
e673ee24 1276
968743bc
DO
1277INSERT 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,'');
0978a2b9 1285
968743bc
DO
1286INSERT 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);
e673ee24 1557
968743bc
DO
1558INSERT 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
c266ea77
AA
1562REPLACE INTO `Config` VALUES ('IPV4LB_LISTSRC','{load balancer}','string','yes','no','no','List source: IPv4 load balancers');
1563
1564INSERT INTO `VS` VALUES
1565(1,'service1',NULL,NULL);
1566
968743bc
DO
1567INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES
1568(1,NULL,'testing'),
1569(2,NULL,'production'),
1570(10,NULL,'network'),
1571(5,10,'WAN link'),
1572(6,NULL,'racks'),
1573(7,6,'tall racks'),
1574(8,6,'low racks'),
1575(9,NULL,'load balancer'),
1576(11,10,'small network'),
1577(12,10,'medium network'),
1578(16,NULL,'XKCD'),
1579(17,16,'romance'),
1580(18,16,'sarcasm'),
1581(19,16,'math'),
1582(20,16,'language'),
1583(21,NULL,'vlan template'),
1584(22,21,'access switch template'),
1585(23,21,'distribution switch template');
41497dbe 1586
c746d690
DO
1587INSERT INTO `TagStorage` (`entity_realm`, `entity_id`, `tag_id`, `user`, `date`) VALUES
1588('object',905,1,'john_doe','2012-06-01'),
1589('object',908,2,'john_doe','2012-06-01'),
1590('object',909,1,'john_doe','2012-06-01'),
1591('object',928,9,'john_doe','2012-06-01'),
1592('object',929,9,'john_doe','2012-06-01'),
1593('object',956,2,'john_doe','2012-06-01'),
1594('object',957,2,'john_doe','2012-06-01'),
1595('object',958,2,'john_doe','2012-06-01'),
1596('object',959,2,'john_doe','2012-06-01'),
1597('object',960,2,'john_doe','2012-06-01'),
1598('object',961,2,'john_doe','2012-06-01'),
1599('object',962,2,'john_doe','2012-06-01'),
1600('ipv4net',96,12,'john_doe','2012-06-01'),
1601('ipv4net',97,12,'john_doe','2012-06-01'),
1602('ipv4net',98,12,'john_doe','2012-06-01'),
1603('ipv4net',99,12,'john_doe','2012-06-01'),
1604('ipv4net',102,5,'john_doe','2012-06-01'),
1605('ipv4net',102,11,'john_doe','2012-06-01'),
1606('ipv4net',103,5,'john_doe','2012-06-01'),
1607('ipv4net',103,11,'john_doe','2012-06-01'),
1608('ipv4net',104,5,'john_doe','2012-06-01'),
1609('ipv4net',104,11,'john_doe','2012-06-01'),
1610('ipv4net',105,5,'john_doe','2012-06-01'),
1611('ipv4net',105,11,'john_doe','2012-06-01'),
1612('ipv4net',106,12,'john_doe','2012-06-01'),
1613('ipv4net',107,12,'john_doe','2012-06-01'),
1614('ipv4net',108,12,'john_doe','2012-06-01'),
1615('rack',967,7,'john_doe','2012-06-01'),
1616('rack',968,8,'john_doe','2012-06-01'),
1617('rack',969,7,'john_doe','2012-06-01'),
1618('rack',970,8,'john_doe','2012-06-01'),
1619('rack',971,7,'john_doe','2012-06-01'),
1620('rack',972,7,'john_doe','2012-06-01'),
1621('rack',973,7,'john_doe','2012-06-01'),
1622('rack',974,8,'john_doe','2012-06-01'),
1623('ipv6net','1','10','john_doe','2012-06-01'),
1624('ipv6net','2','12','john_doe','2012-06-01'),
1625('ipv6net','3','12','john_doe','2012-06-01'),
1626('ipv6net','4','18','john_doe','2012-06-01'),
1627('ipv6net','5','18','john_doe','2012-06-01'),
1628('object',979,12,'john_doe','2012-06-01'),
1629('object',980,12,'john_doe','2012-06-01'),
1630('object',981,12,'john_doe','2012-06-01'),
1631('vst',1,22,'john_doe','2012-06-01'),
1632('vst',2,22,'john_doe','2012-06-01'),
c266ea77
AA
1633('vst',3,23,'john_doe','2012-06-01'),
1634('ipvs',1,2,'admin','2013-06-23 23:48:52');
b1808b2a 1635
968743bc 1636INSERT INTO `VLANDomain` (`id`, `description`) VALUES
b1808b2a
DO
1637(2,'English'),
1638(1,'русский'),
1639(3,'українська'),
1640(4,'日本語');
1641
968743bc 1642INSERT INTO `VLANDescription` (`domain_id`, `vlan_id`, `vlan_type`, `vlan_descr`) VALUES
b1808b2a
DO
1643(1,1,'compulsory','default'),
1644(1,2,'ondemand','второй'),
1645(1,3,'ondemand','третий'),
1646(1,4,'ondemand','четвёртый'),
1647(1,5,'ondemand','пятый'),
1648(1,6,'ondemand','шестой'),
1649(1,7,'ondemand','седьмой'),
1650(1,8,'ondemand','восьмой'),
1651(1,9,'ondemand','девятый'),
1652(1,10,'ondemand','десятый'),
1653(1,11,'ondemand','одиннадцатый'),
1654(1,12,'ondemand','двенадцатый'),
1655(1,13,'ondemand','тринадцатый'),
1656(1,14,'ondemand','четырнадцатый'),
1657(1,15,'ondemand','пятнадцатый'),
1658(2,1,'compulsory','default'),
1659(2,2,'ondemand','second'),
1660(2,3,'ondemand','third'),
1661(2,4,'ondemand','fourth'),
1662(2,5,'ondemand','fifth'),
1663(2,6,'ondemand','sixth'),
1664(2,7,'ondemand','seventh'),
1665(2,8,'ondemand','eighth'),
1666(2,9,'ondemand','ninth'),
1667(2,10,'ondemand','tenth'),
1668(2,11,'ondemand','eleventh'),
1669(2,12,'ondemand','twelfth'),
1670(2,13,'ondemand','thirteenth'),
1671(2,14,'ondemand','fourteenth'),
1672(2,15,'ondemand','fifteenth'),
1673(3,1,'compulsory','default'),
1674(3,2,'ondemand','другий'),
1675(3,3,'ondemand','третій'),
1676(3,4,'ondemand','четвертий'),
1677(3,5,'ondemand','п\'ятий'),
1678(3,6,'ondemand','шостий'),
1679(3,7,'ondemand','сьомий'),
1680(3,8,'ondemand','восьмий'),
1681(3,9,'ondemand','дев\'ятий'),
1682(3,10,'ondemand','десятий'),
1683(3,11,'ondemand','одинадцятий'),
1684(3,12,'ondemand','дванадцятий'),
1685(3,13,'ondemand','тринадцятий'),
1686(3,14,'ondemand','чотирнадцятий'),
1687(3,15,'ondemand','п\'ятнадцятий'),
1688(4,1,'compulsory','default'),
1689(4,2,'ondemand','第二'),
1690(4,3,'ondemand','第三'),
1691(4,4,'ondemand','第四'),
1692(4,5,'ondemand','第五'),
1693(4,6,'ondemand','第六'),
1694(4,7,'ondemand','第七'),
1695(4,8,'ondemand','第八'),
1696(4,9,'ondemand','第九'),
1697(4,10,'ondemand','第十'),
1698(4,11,'ondemand','第十一'),
1699(4,12,'ondemand','第十二'),
1700(4,13,'ondemand','第十三'),
1701(4,14,'ondemand','第十四'),
1702(4,15,'ondemand','第十五');
0978a2b9 1703
968743bc
DO
1704INSERT INTO `VLANSwitchTemplate` (`id`, `mutex_rev`, `description`, `saved_by`) VALUES
1705(1,1,'24 ports switch','admin'),
1706(2,1,'48 ports switch','admin'),
1707(3,1,'distribution switch','admin');
0978a2b9 1708
968743bc
DO
1709INSERT INTO `VLANSTRule` (`vst_id`, `rule_no`, `port_pcre`, `port_role`, `wrt_vlans`, `description`) VALUES
1710(1,100,'#[^\\d]24#','uplink','','uplink'),
1711(1,999,'#.#','anymode','','user-defined'),
1712(2,100,'#[^\\d]48#','uplink','','uplink'),
1713(2,999,'#.#','anymode','','user-defined'),
1714(3,999,'/./','downlink','','access switches');
0978a2b9 1715
968743bc
DO
1716INSERT 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
1717(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'),
1718(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'),
1719(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
1720
1721INSERT INTO `VSIPs` VALUES (1,0x0AC80139,NULL,NULL);
1722INSERT INTO `VSIPs` VALUES (1,0x0AC8013A,NULL,NULL);
1723INSERT INTO `VSIPs` VALUES (1,0xFC001450000200000000000000000039,NULL,NULL);
1724INSERT INTO `VSEnabledIPs` VALUES (928,1,0x0AC80139,1,'100',NULL,NULL);
1725INSERT INTO `VSEnabledIPs` VALUES (928,1,0x0AC8013A,1,'200',NULL,NULL);
1726INSERT INTO `VSEnabledIPs` VALUES (928,1,0xFC001450000200000000000000000039,1,NULL,NULL,NULL);
1727INSERT INTO `VSEnabledIPs` VALUES (929,1,0x0AC80139,1,'200',NULL,NULL);
1728INSERT INTO `VSEnabledIPs` VALUES (929,1,0x0AC8013A,1,'100',NULL,NULL);
1729INSERT INTO `VSEnabledIPs` VALUES (929,1,0xFC001450000200000000000000000039,1,NULL,NULL,NULL);
1730INSERT INTO `VSPorts` VALUES (1,'TCP',80,NULL,'CHECK_HTTP {\n url /ping\n status_code 200\n}');
1731INSERT INTO `VSPorts` VALUES (1,'TCP',443,NULL,'CHECK_SSL {\n url /ping\n status_code 200\n}');
1732INSERT INTO `VSEnabledPorts` VALUES (928,1,'TCP',80,1,NULL,NULL);
1733INSERT INTO `VSEnabledPorts` VALUES (928,1,'TCP',443,1,NULL,NULL);
1734INSERT INTO `VSEnabledPorts` VALUES (929,1,'TCP',80,1,NULL,NULL);
1735INSERT INTO `VSEnabledPorts` VALUES (929,1,'TCP',443,1,NULL,NULL);