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