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