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