turn SLB demo data into binary format
[racktables] / scripts / init-sample-racks.sql
CommitLineData
58652ac1
DY
1set names 'utf8';
2
9b8174d7 3INSERT INTO `Object` (id, name, label, objtype_id, asset_no, has_problems, comment) VALUES
e1add254
AD
4(905,'london router','bbrtr1',7,'net247','no',NULL),
5(906,'londonswitch1','',8,NULL,'no',NULL),
6(907,'New-York router 1','bbrtr2a',7,'net55','no',NULL),
81659c05
AD
7(908,'moscow router','bbrtr3',7,NULL,'no',NULL),
8(909,'tokyo router','bbrtr4',7,NULL,'no',NULL),
e1add254
AD
9(910,'London server 1','lserver01',4,'srv500','no',NULL),
10(911,'London server 2','lserver02',4,'srv501','no',NULL),
11(912,'London server 3','lserver03',4,'srv502','no',NULL),
81659c05 12(913,'London server 4','lserver04',4,'srv503','yes','this one needs replacement'),
e1add254
AD
13(914,'London server 5','lserver05',4,'srv504','no',NULL),
14(915,'london LB','llb',8,'net1000','no',NULL),
15(916,'shared storage','',5,NULL,'no',NULL),
16(917,'london-NAS','',7,'net1001','no',NULL),
81659c05
AD
17(918,'London server 6','lserver06',4,'srv505','no',NULL),
18(919,'London server 7','lserver07',4,'srv506','no',NULL),
19(920,'backup library','lbackup',6,'misc200','no',NULL),
20(921,'lserver06 array','lserver06 array',5,NULL,'no',NULL),
21(922,'lserver07 array','lserver07 array',5,NULL,'no',NULL),
22(923,'Tokyo server 1','tserver01',4,'srv654','no',NULL),
23(924,'Tokyo server 2','tserver02',4,'srv848','no',NULL),
24(925,'Tokyo server 3','tserver03',4,'srv139','no',NULL),
25(926,'Tokyo switch','tswitch',8,'net385','no',NULL),
26(927,'New-York router 2','bbrtr2b',7,'net498','no',NULL),
27(928,'New-York IPVS LB A','nylba',4,'net554','no',NULL),
28(929,'New-York IPVS LB B','nylbb',4,'net555','no',NULL),
29(930,'New-York server switch A','nyswitcha',8,'net084','no',NULL),
30(931,'New-York server switch B','nyswitchb',8,'net486','no',NULL),
31(932,'New-York server 1A','nysrv1a',4,'srv287','no',NULL),
32(933,'New-York server 1B','nysrv1b',4,'srv288','no',NULL),
33(934,'New-York server 2A','nysrv2a',4,NULL,'no',NULL),
34(935,'New-York server 2B','nysrv2b',4,NULL,'no',NULL),
35(936,'New-York server 3A','nysrv3a',4,NULL,'no',NULL),
36(937,'New-York server 3B','nysrv3b',4,NULL,'no',NULL),
37(938,'New-York server 4A','nysrv4a',4,NULL,'no',NULL),
38(939,'New-York server 4B','nysrv4b',4,NULL,'no',NULL),
39(940,'New-York server 5A','nysrv5a',4,NULL,'no',NULL),
40(941,'New-York server 5B','nysrv5b',4,NULL,'no',NULL),
e1add254
AD
41(942,'wing A UPS',NULL,12,NULL,'no',NULL),
42(943,'wing B UPS',NULL,12,NULL,'no',NULL),
43(944,'network UPS',NULL,12,NULL,'no',NULL),
44(945,NULL,NULL,9,NULL,'no',NULL),
45(946,NULL,NULL,9,NULL,'no',NULL),
46(947,NULL,NULL,2,NULL,'no',NULL),
47(948,NULL,NULL,2,NULL,'no',NULL),
48(949,NULL,NULL,2,NULL,'no',NULL),
49(950,NULL,NULL,2,NULL,'no',NULL),
50(951,NULL,NULL,2,NULL,'no',NULL),
51(952,NULL,NULL,2,NULL,'no',NULL),
52(953,NULL,NULL,2,NULL,'no',NULL),
53(954,NULL,NULL,2,NULL,'no',NULL),
54(955,NULL,NULL,2,NULL,'no',NULL),
55(956,'mps1',NULL,4,NULL,'no',NULL),
56(957,'mps2',NULL,4,NULL,'no',NULL),
57(958,'mps3',NULL,4,NULL,'no',NULL),
58(959,'mps4',NULL,4,NULL,'no',NULL),
59(960,'mps5',NULL,4,NULL,'no',NULL),
60(961,'mskswitch',NULL,8,'sw0001','no',NULL),
61(962,'moscow kvm switch',NULL,445,'sw0002','no',NULL),
62(963,'Row 1',NULL,1561,NULL,'no',NULL),
63(964,'Row A',NULL,1561,NULL,'no',NULL),
64(965,'CF-4',NULL,1561,NULL,'no',NULL),
65(966,'Row 1',NULL,1561,NULL,'no',NULL),
66(967,'L01',NULL,1560,NULL,'no','test'),
67(968,'L02',NULL,1560,NULL,'no','network equipment mini-rack'),
68(969,'L03',NULL,1560,NULL,'no',NULL),
69(970,'NY100',NULL,1560,NULL,'no',NULL),
70(971,'NY101',NULL,1560,NULL,'no','server farm wing A'),
71(972,'M01',NULL,1560,NULL,'no',NULL),
72(973,'NY102',NULL,1560,NULL,'no','server farm wing B'),
73(974,'T01',NULL,1560,NULL,'no',NULL),
74(975,'Moscow',NULL,1562,NULL,'no',NULL),
75(976,'Tokyo',NULL,1562,NULL,'no',NULL),
76(977,'New-York',NULL,1562,NULL,'no',NULL),
77(978,'London',NULL,1562,NULL,'no',NULL);
9b8174d7
AD
78
79INSERT INTO `EntityLink` (`parent_entity_type`, `parent_entity_id`, `child_entity_type`, `child_entity_id`) VALUES
e1add254
AD
80('row',966,'rack',967),
81('row',966,'rack',968),
82('row',966,'rack',969),
83('row',965,'rack',970),
84('row',965,'rack',971),
85('row',963,'rack',972),
86('row',965,'rack',973),
87('row',964,'rack',974),
88('location',975,'row',963),
89('location',976,'row',964),
90('location',977,'row',965),
91('location',978,'row',966);
cafd4cf3 92
3e74655e
DO
93INSERT INTO `AttributeValue` VALUES (905,7,2,NULL,269,NULL);
94INSERT INTO `AttributeValue` VALUES (906,8,2,NULL,165,NULL);
95INSERT INTO `AttributeValue` VALUES (915,8,2,NULL,118,NULL);
96INSERT INTO `AttributeValue` VALUES (915,8,4,NULL,245,NULL);
97INSERT INTO `AttributeValue` VALUES (917,7,2,NULL,267,NULL);
98INSERT INTO `AttributeValue` VALUES (916,5,2,NULL,320,NULL);
99INSERT INTO `AttributeValue` VALUES (910,4,2,NULL,57,NULL);
100INSERT INTO `AttributeValue` VALUES (910,4,4,NULL,220,NULL);
101INSERT INTO `AttributeValue` VALUES (911,4,4,NULL,220,NULL);
102INSERT INTO `AttributeValue` VALUES (911,4,2,NULL,57,NULL);
103INSERT INTO `AttributeValue` VALUES (912,4,4,NULL,220,NULL);
104INSERT INTO `AttributeValue` VALUES (912,4,2,NULL,57,NULL);
105INSERT INTO `AttributeValue` VALUES (913,4,2,NULL,57,NULL);
106INSERT INTO `AttributeValue` VALUES (913,4,4,NULL,220,NULL);
107INSERT INTO `AttributeValue` VALUES (914,4,2,NULL,57,NULL);
108INSERT INTO `AttributeValue` VALUES (914,4,4,NULL,220,NULL);
109INSERT INTO `AttributeValue` VALUES (918,4,2,NULL,88,NULL);
110INSERT INTO `AttributeValue` VALUES (918,4,4,NULL,220,NULL);
111INSERT INTO `AttributeValue` VALUES (919,4,2,NULL,88,NULL);
112INSERT INTO `AttributeValue` VALUES (919,4,4,NULL,220,NULL);
113INSERT INTO `AttributeValue` VALUES (920,6,2,NULL,326,NULL);
114INSERT INTO `AttributeValue` VALUES (921,5,2,NULL,318,NULL);
115INSERT INTO `AttributeValue` VALUES (922,5,2,NULL,318,NULL);
116INSERT INTO `AttributeValue` VALUES (923,4,2,NULL,102,NULL);
117INSERT INTO `AttributeValue` VALUES (923,4,4,NULL,233,NULL);
118INSERT INTO `AttributeValue` VALUES (926,8,2,NULL,126,NULL);
119INSERT INTO `AttributeValue` VALUES (926,8,4,NULL,244,NULL);
120INSERT INTO `AttributeValue` VALUES (925,4,2,NULL,102,NULL);
121INSERT INTO `AttributeValue` VALUES (925,4,4,NULL,233,NULL);
122INSERT INTO `AttributeValue` VALUES (924,4,2,NULL,102,NULL);
123INSERT INTO `AttributeValue` VALUES (924,4,4,NULL,233,NULL);
124INSERT INTO `AttributeValue` VALUES (907,7,2,NULL,269,NULL);
125INSERT INTO `AttributeValue` VALUES (907,7,4,NULL,258,NULL);
126INSERT INTO `AttributeValue` VALUES (927,7,2,NULL,269,NULL);
127INSERT INTO `AttributeValue` VALUES (927,7,4,NULL,258,NULL);
128INSERT INTO `AttributeValue` VALUES (956,4,2,NULL,62,NULL);
129INSERT INTO `AttributeValue` VALUES (956,4,4,NULL,791,NULL);
130INSERT INTO `AttributeValue` VALUES (957,4,2,NULL,62,NULL);
131INSERT INTO `AttributeValue` VALUES (957,4,4,NULL,791,NULL);
132INSERT INTO `AttributeValue` VALUES (958,4,2,NULL,62,NULL);
133INSERT INTO `AttributeValue` VALUES (958,4,4,NULL,791,NULL);
134INSERT INTO `AttributeValue` VALUES (959,4,2,NULL,62,NULL);
135INSERT INTO `AttributeValue` VALUES (959,4,4,NULL,791,NULL);
136INSERT INTO `AttributeValue` VALUES (960,4,2,NULL,62,NULL);
137INSERT INTO `AttributeValue` VALUES (960,4,4,NULL,791,NULL);
138INSERT INTO `AttributeValue` VALUES (961,8,2,NULL,755,NULL);
139INSERT INTO `AttributeValue` VALUES (962,445,2,NULL,470,NULL);
140INSERT INTO `AttributeValue` VALUES (967,1560,27,NULL,42,NULL);
42504426 141INSERT INTO `AttributeValue` VALUES (967,1560,29,NULL,1,NULL);
3e74655e 142INSERT INTO `AttributeValue` VALUES (968,1560,27,NULL,12,NULL);
42504426 143INSERT INTO `AttributeValue` VALUES (968,1560,29,NULL,2,NULL);
3e74655e 144INSERT INTO `AttributeValue` VALUES (969,1560,27,NULL,42,NULL);
42504426 145INSERT INTO `AttributeValue` VALUES (969,1560,29,NULL,3,NULL);
3e74655e 146INSERT INTO `AttributeValue` VALUES (970,1560,27,NULL,16,NULL);
42504426 147INSERT INTO `AttributeValue` VALUES (970,1560,29,NULL,1,NULL);
3e74655e 148INSERT INTO `AttributeValue` VALUES (971,1560,27,NULL,42,NULL);
42504426 149INSERT INTO `AttributeValue` VALUES (971,1560,29,NULL,2,NULL);
3e74655e 150INSERT INTO `AttributeValue` VALUES (972,1560,27,NULL,42,NULL);
42504426 151INSERT INTO `AttributeValue` VALUES (972,1560,29,NULL,1,NULL);
3e74655e 152INSERT INTO `AttributeValue` VALUES (973,1560,27,NULL,42,NULL);
42504426 153INSERT INTO `AttributeValue` VALUES (973,1560,29,NULL,3,NULL);
3e74655e 154INSERT INTO `AttributeValue` VALUES (974,1560,27,NULL,16,NULL);
42504426 155INSERT INTO `AttributeValue` VALUES (974,1560,29,NULL,1,NULL);
e673ee24 156
cc2fa820
AD
157INSERT INTO `IPv4Address` VALUES (180879678,'default gw','','no');
158INSERT INTO `IPv4Address` VALUES (180879617,'','',NULL);
159INSERT INTO `IPv4Address` VALUES (180879680,'network','','yes');
160INSERT INTO `IPv4Address` VALUES (180879743,'broadcast','','yes');
161INSERT INTO `IPv4Address` VALUES (180879681,'','',NULL);
162INSERT INTO `IPv4Address` VALUES (180879683,'','',NULL);
163INSERT INTO `IPv4Address` VALUES (180879684,'','',NULL);
164INSERT INTO `IPv4Address` VALUES (180879685,'','',NULL);
165INSERT INTO `IPv4Address` VALUES (180879616,'network','','yes');
166INSERT INTO `IPv4Address` VALUES (180879679,'broadcast','','yes');
167INSERT INTO `IPv4Address` VALUES (180879686,'','',NULL);
168INSERT INTO `IPv4Address` VALUES (180879687,'','',NULL);
169INSERT INTO `IPv4Address` VALUES (180879360,'','',NULL);
170INSERT INTO `IPv4Address` VALUES (180879361,'','',NULL);
171INSERT INTO `IPv4Address` VALUES (180880192,'network','','yes');
172INSERT INTO `IPv4Address` VALUES (180880255,'broadcast','','yes');
173INSERT INTO `IPv4Address` VALUES (180880448,'network','','yes');
174INSERT INTO `IPv4Address` VALUES (180880511,'broadcast','','yes');
175INSERT INTO `IPv4Address` VALUES (180880384,'network','','yes');
176INSERT INTO `IPv4Address` VALUES (180880447,'broadcast','','yes');
177INSERT INTO `IPv4Address` VALUES (180880128,'network','','no');
178INSERT INTO `IPv4Address` VALUES (180880191,'broadcast','','no');
179INSERT INTO `IPv4Address` VALUES (180879936,'network','','yes');
180INSERT INTO `IPv4Address` VALUES (180879999,'broadcast','','yes');
181INSERT INTO `IPv4Address` VALUES (180879872,'network','','yes');
182INSERT INTO `IPv4Address` VALUES (180879935,'broadcast','','yes');
183INSERT INTO `IPv4Address` VALUES (180880193,'','',NULL);
184INSERT INTO `IPv4Address` VALUES (180880194,'','',NULL);
185INSERT INTO `IPv4Address` VALUES (180880195,'','',NULL);
186INSERT INTO `IPv4Address` VALUES (180879618,'','',NULL);
187INSERT INTO `IPv4Address` VALUES (180879677,'','',NULL);
188INSERT INTO `IPv4Address` VALUES (180879676,'','',NULL);
189INSERT INTO `IPv4Address` VALUES (180879675,'','',NULL);
190INSERT INTO `IPv4Address` VALUES (180880254,'','',NULL);
191INSERT INTO `IPv4Address` VALUES (180880504,'for field engineer','','yes');
e673ee24 192
706ce117
DO
193INSERT INTO `IPv4Allocation` VALUES (905,180879678,'fa2/0','router');
194INSERT INTO `IPv4Allocation` VALUES (906,180879617,'','regular');
195INSERT INTO `IPv4Allocation` VALUES (910,180879681,'eth0','regular');
196INSERT INTO `IPv4Allocation` VALUES (911,180879682,'eth0','regular');
197INSERT INTO `IPv4Allocation` VALUES (912,180879683,'eth0','regular');
198INSERT INTO `IPv4Allocation` VALUES (913,180879684,'eth0','regular');
199INSERT INTO `IPv4Allocation` VALUES (914,180879685,'eth0','regular');
200INSERT INTO `IPv4Allocation` VALUES (918,180879686,'bge0','regular');
201INSERT INTO `IPv4Allocation` VALUES (919,180879687,'bge0','regular');
202INSERT INTO `IPv4Allocation` VALUES (908,180879360,'se1/0','regular');
203INSERT INTO `IPv4Allocation` VALUES (905,180879361,'se1/1','regular');
204INSERT INTO `IPv4Allocation` VALUES (923,180880193,'eth0','regular');
205INSERT INTO `IPv4Allocation` VALUES (924,180880194,'eth0','regular');
206INSERT INTO `IPv4Allocation` VALUES (925,180880195,'eth0','regular');
207INSERT INTO `IPv4Allocation` VALUES (915,180879618,'telnet access','regular');
208INSERT INTO `IPv4Allocation` VALUES (915,180879677,'VIP3','regular');
209INSERT INTO `IPv4Allocation` VALUES (915,180879676,'VIP2','regular');
210INSERT INTO `IPv4Allocation` VALUES (915,180879675,'VIP1','regular');
211INSERT INTO `IPv4Allocation` VALUES (910,180879675,'','virtual');
212INSERT INTO `IPv4Allocation` VALUES (911,180879675,'','virtual');
213INSERT INTO `IPv4Allocation` VALUES (912,180879675,'','virtual');
214INSERT INTO `IPv4Allocation` VALUES (919,180879677,'','virtual');
215INSERT INTO `IPv4Allocation` VALUES (918,180879677,'','virtual');
216INSERT INTO `IPv4Allocation` VALUES (909,180880254,'fa2/0','router');
217INSERT INTO `IPv4Allocation` VALUES (907,180879363,'se1/1','regular');
218INSERT INTO `IPv4Allocation` VALUES (905,180879362,'se1/0','regular');
219INSERT INTO `IPv4Allocation` VALUES (914,180879676,'','virtual');
220INSERT INTO `IPv4Allocation` VALUES (913,180879676,'','virtual');
221INSERT INTO `IPv4Allocation` VALUES (932,180879973,'','regular');
222INSERT INTO `IPv4Allocation` VALUES (934,180879974,'','regular');
223INSERT INTO `IPv4Allocation` VALUES (936,180879975,'','regular');
224INSERT INTO `IPv4Allocation` VALUES (938,180879976,'','regular');
225INSERT INTO `IPv4Allocation` VALUES (940,180879977,'','regular');
226INSERT INTO `IPv4Allocation` VALUES (933,180879978,'','regular');
227INSERT INTO `IPv4Allocation` VALUES (935,180879979,'','regular');
228INSERT INTO `IPv4Allocation` VALUES (937,180879980,'','regular');
229INSERT INTO `IPv4Allocation` VALUES (939,180879981,'','regular');
230INSERT INTO `IPv4Allocation` VALUES (941,180879982,'','regular');
231INSERT INTO `IPv4Allocation` VALUES (928,180879877,'','regular');
232INSERT INTO `IPv4Allocation` VALUES (929,180879878,'','regular');
233INSERT INTO `IPv4Allocation` VALUES (956,180880449,'eth0','regular');
234INSERT INTO `IPv4Allocation` VALUES (957,180880450,'eth0','regular');
235INSERT INTO `IPv4Allocation` VALUES (958,180880451,'eth0','regular');
236INSERT INTO `IPv4Allocation` VALUES (959,180880452,'eth0','regular');
237INSERT INTO `IPv4Allocation` VALUES (960,180880453,'eth0','regular');
238INSERT INTO `IPv4Allocation` VALUES (908,180880510,'fa2/0','router');
239INSERT INTO `IPv4Allocation` VALUES (962,180880386,'','regular');
240INSERT INTO `IPv4Allocation` VALUES (909,180879366,'se1/0','regular');
241INSERT INTO `IPv4Allocation` VALUES (908,180879367,'se1/1','regular');
242INSERT INTO `IPv4Allocation` VALUES (909,180879365,'se1/1','regular');
243INSERT INTO `IPv4Allocation` VALUES (907,180879364,'se1/0','regular');
244INSERT INTO `IPv4Allocation` VALUES (907,180879998,'','shared');
245INSERT INTO `IPv4Allocation` VALUES (927,180879998,'','shared');
246INSERT INTO `IPv4Allocation` VALUES (908,180880446,'fa1/0','router');
247INSERT INTO `IPv4Allocation` VALUES (961,180880385,'','regular');
1365dddb 248
ce1f34ef
AA
249INSERT INTO `IPv6Allocation` VALUES ('908', 0xFC0014500001BEEF0000000000000001, 'fa1/0', 'router');
250INSERT INTO `IPv6Allocation` VALUES ('919', 0xFC0014500001DEAD0000000000000001, 'bge1', 'router');
20ac2076 251
706ce117
DO
252INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (96,180879616,26,'London network devices and VIPs');
253INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (97,180879680,26,'London HA server farm');
254INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (98,180879872,26,'New-York network devices');
255INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (99,180879936,26,'New-York servers');
256INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (108,180880192,26,'Tokyo server farm');
257INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (102,180879360,31,'M-L P2P');
258INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (103,180879362,31,'L-NY P2P');
259INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (104,180879364,31,'NY-T P2P');
260INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (105,180879366,31,'T-M P2P');
261INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (106,180880384,26,'Moscow network devices');
262INSERT INTO `IPv4Network` (`id`, `ip`, `mask`, `name`) VALUES (107,180880448,26,'Moscow servers');
e673ee24 263
ce1f34ef
AA
264INSERT INTO `IPv6Network` (`id`, `ip`, `mask`, `last_ip`, `name`, `comment`) VALUES ('1', 0xFC000000000000000000000000000000, '7', 0xFDFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF, 'Local IPv6', null);
265INSERT INTO `IPv6Network` (`id`, `ip`, `mask`, `last_ip`, `name`, `comment`) VALUES ('2', 0xFC001450000100000000000000000000, '48', 0xFC0014500001FFFFFFFFFFFFFFFFFFFF, 'v6 Suballoc 1', null);
266INSERT INTO `IPv6Network` (`id`, `ip`, `mask`, `last_ip`, `name`, `comment`) VALUES ('3', 0xFC001450000200000000000000000000, '48', 0xFC0014500002FFFFFFFFFFFFFFFFFFFF, 'v6 Suballoc 2', null);
267INSERT INTO `IPv6Network` (`id`, `ip`, `mask`, `last_ip`, `name`, `comment`) VALUES ('4', 0xFC0014500001DEAD0000000000000000, '64', 0xFC0014500001DEADFFFFFFFFFFFFFFFF, 'dead net', null);
268INSERT INTO `IPv6Network` (`id`, `ip`, `mask`, `last_ip`, `name`, `comment`) VALUES ('5', 0xFC0014500001BEEF0000000000000000, '64', 0xFC0014500001BEEFFFFFFFFFFFFFFFFF, 'beef net', null);
20ac2076 269
4d87feaf
DO
270INSERT INTO `IPv4RSPool` VALUES (1,'Apache servers',NULL,NULL);
271INSERT INTO `IPv4RSPool` VALUES (2,'Resin servers',NULL,NULL);
272
77fed2de
AA
273INSERT INTO `IPv4VS` VALUES (1,0x0AC80205,80,'TCP','virtual web','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# this is a comment\r\n# VS name is %VNAME%\r\n#\r\n','HTTP_GET {\r\nurl {\r\npath /\r\nstatus_code 200\r\n}\r\nconnect_timeout 1\r\n}');
274INSERT 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}');
cafd4cf3 275
92ee2b01
AA
276INSERT INTO `IPv4LB` VALUES (928,1,1,NULL,NULL,NULL);
277INSERT INTO `IPv4LB` VALUES (929,1,1,NULL,NULL,NULL);
278INSERT INTO `IPv4LB` VALUES (929,2,2,NULL,NULL,NULL);
cafd4cf3 279
77fed2de
AA
280INSERT INTO `IPv4RS` VALUES (1,'yes',0x0AC80265,80,1,NULL,NULL);
281INSERT INTO `IPv4RS` VALUES (2,'yes',0x0AC80266,80,1,NULL,NULL);
282INSERT INTO `IPv4RS` VALUES (3,'no',0x0AC80267,80,1,NULL,NULL);
283INSERT INTO `IPv4RS` VALUES (4,'yes',0x0AC80268,80,1,NULL,NULL);
284INSERT INTO `IPv4RS` VALUES (5,'yes',0x0AC80269,80,1,NULL,NULL);
285INSERT INTO `IPv4RS` VALUES (6,'no',0x0AC8026A,8080,2,NULL,NULL);
286INSERT INTO `IPv4RS` VALUES (7,'yes',0x0AC8026B,8080,2,NULL,NULL);
287INSERT INTO `IPv4RS` VALUES (8,'yes',0x0AC8026C,8080,2,NULL,NULL);
288INSERT INTO `IPv4RS` VALUES (9,'yes',0x0AC8026D,8080,2,NULL,NULL);
289INSERT INTO `IPv4RS` VALUES (10,'yes',0x0AC8026E,8080,2,NULL,NULL);
1365dddb 290
fc8e1110
DO
291INSERT INTO PortInterfaceCompat (iif_id, oif_id) VALUES
292(1,32);
09d6afa4
DO
293INSERT INTO `Port` VALUES (3057,905,'se1/0',1,32,NULL,NULL,'');
294INSERT INTO `Port` VALUES (3058,905,'se1/1',1,32,NULL,NULL,'');
295INSERT INTO `Port` VALUES (3059,905,'fa2/0',1,19,'00000000A001',NULL,'');
296INSERT INTO `Port` VALUES (3060,905,'fa2/1',1,19,'00000000A002','ISP uplink','');
297INSERT INTO `Port` VALUES (3063,906,'gi1',1,24,'00000000B001',NULL,'1');
298INSERT INTO `Port` VALUES (3062,906,'gi2',1,24,'00000000B002',NULL,'2');
299INSERT INTO `Port` VALUES (3064,906,'gi3',1,24,'00000000B003',NULL,'3');
300INSERT INTO `Port` VALUES (3065,906,'gi4',1,24,'00000000B004',NULL,'4');
301INSERT INTO `Port` VALUES (3066,906,'gi5',1,24,'00000000B005',NULL,'5');
302INSERT INTO `Port` VALUES (3067,906,'gi6',1,24,'00000000B006',NULL,'6');
303INSERT INTO `Port` VALUES (3068,906,'gi7',1,24,'00000000B007',NULL,'7');
304INSERT INTO `Port` VALUES (3069,906,'gi8',1,24,'00000000B008',NULL,'8');
305INSERT INTO `Port` VALUES (3070,907,'se1/0',1,32,NULL,NULL,'');
306INSERT INTO `Port` VALUES (3071,907,'se1/1',1,32,NULL,NULL,'');
307INSERT INTO `Port` VALUES (3072,915,'e1',1,19,NULL,NULL,'1');
308INSERT INTO `Port` VALUES (3073,915,'e2',1,19,NULL,NULL,'2');
309INSERT INTO `Port` VALUES (3074,915,'e3',1,19,NULL,NULL,'3');
310INSERT INTO `Port` VALUES (3075,915,'e4',1,19,NULL,NULL,'4');
311INSERT INTO `Port` VALUES (3076,915,'e5',1,19,NULL,NULL,'5');
312INSERT INTO `Port` VALUES (3077,915,'e6',1,19,NULL,NULL,'6');
313INSERT INTO `Port` VALUES (3078,915,'e7',1,19,NULL,NULL,'7');
314INSERT INTO `Port` VALUES (3079,915,'e8',1,19,NULL,NULL,'8');
315INSERT INTO `Port` VALUES (3080,910,'eth0',1,24,NULL,NULL,'1');
316INSERT INTO `Port` VALUES (3081,910,'eth1',1,24,NULL,NULL,'2');
317INSERT INTO `Port` VALUES (3082,909,'se1/0',1,32,NULL,NULL,'');
318INSERT INTO `Port` VALUES (3083,909,'se1/1',1,32,NULL,NULL,'');
319INSERT INTO `Port` VALUES (3084,908,'se1/0',1,32,NULL,NULL,'');
320INSERT INTO `Port` VALUES (3085,908,'se1/1',1,32,NULL,NULL,'');
321INSERT INTO `Port` VALUES (3086,911,'eth0',1,24,NULL,NULL,'1');
322INSERT INTO `Port` VALUES (3087,911,'eth1',1,24,NULL,NULL,'2');
323INSERT INTO `Port` VALUES (3088,912,'eth0',1,24,NULL,NULL,'1');
324INSERT INTO `Port` VALUES (3089,912,'eth1',1,24,NULL,NULL,'2');
325INSERT INTO `Port` VALUES (3090,913,'eth0',1,24,NULL,NULL,'1');
326INSERT INTO `Port` VALUES (3091,913,'eth1',1,24,NULL,NULL,'2');
327INSERT INTO `Port` VALUES (3092,914,'eth0',1,24,NULL,NULL,'1');
328INSERT INTO `Port` VALUES (3093,914,'eth1',1,24,NULL,NULL,'2');
329INSERT INTO `Port` VALUES (3094,917,'fa0/0',1,19,NULL,NULL,'');
330INSERT INTO `Port` VALUES (3095,919,'bge0',1,24,NULL,NULL,'');
331INSERT INTO `Port` VALUES (3096,919,'bge1',1,24,NULL,NULL,'');
332INSERT INTO `Port` VALUES (3097,918,'bge0',1,24,NULL,NULL,'');
333INSERT INTO `Port` VALUES (3098,918,'bge1',1,24,NULL,NULL,'');
334INSERT INTO `Port` VALUES (3099,909,'fa2/0',1,19,NULL,NULL,'');
335INSERT INTO `Port` VALUES (3100,909,'fa2/1',1,19,NULL,'ISP uplink','');
336INSERT INTO `Port` VALUES (3101,926,'fa1',1,19,NULL,NULL,'1');
337INSERT INTO `Port` VALUES (3102,926,'fa2',1,19,NULL,NULL,'2');
338INSERT INTO `Port` VALUES (3103,926,'fa3',1,19,NULL,NULL,'3');
339INSERT INTO `Port` VALUES (3104,926,'fa4',1,19,NULL,NULL,'4');
340INSERT INTO `Port` VALUES (3105,926,'fa5',1,19,NULL,NULL,'5');
341INSERT INTO `Port` VALUES (3106,926,'fa6',1,19,NULL,NULL,'6');
342INSERT INTO `Port` VALUES (3107,926,'fa7',1,19,NULL,NULL,'7');
343INSERT INTO `Port` VALUES (3108,926,'fa8',1,19,NULL,NULL,'8');
344INSERT INTO `Port` VALUES (3109,926,'fa9',1,19,NULL,NULL,'9');
345INSERT INTO `Port` VALUES (3110,926,'fa10',1,19,NULL,NULL,'10');
346INSERT INTO `Port` VALUES (3111,926,'fa11',1,19,NULL,NULL,'11');
347INSERT INTO `Port` VALUES (3112,926,'fa12',1,19,NULL,NULL,'12');
348INSERT INTO `Port` VALUES (3113,923,'eth0',1,24,NULL,NULL,'1');
349INSERT INTO `Port` VALUES (3114,923,'eth1',1,24,NULL,NULL,'2');
350INSERT INTO `Port` VALUES (3115,924,'eth0',1,24,NULL,NULL,'1');
351INSERT INTO `Port` VALUES (3116,924,'eth1',1,24,NULL,NULL,'2');
352INSERT INTO `Port` VALUES (3117,925,'eth0',1,24,NULL,NULL,'1');
353INSERT INTO `Port` VALUES (3118,925,'eth1',1,24,NULL,NULL,'2');
354INSERT INTO `Port` VALUES (3119,908,'fa2/0',1,19,NULL,NULL,'');
355INSERT INTO `Port` VALUES (3120,908,'fa2/1',1,19,NULL,'ISP uplink','');
356INSERT INTO `Port` VALUES (3121,907,'fa2/0',1,19,NULL,NULL,'');
357INSERT INTO `Port` VALUES (3122,907,'fa2/1',1,19,NULL,NULL,'');
fc8e1110
DO
358INSERT INTO `Port` VALUES (3123,927,'gi3/0',3,1202,NULL,'ISP uplink','');
359INSERT INTO `Port` VALUES (3124,927,'gi4/0',3,1202,NULL,NULL,'');
360INSERT INTO `Port` VALUES (3125,907,'gi3/0',3,1202,NULL,'ISP uplink','');
361INSERT INTO `Port` VALUES (3126,907,'gi4/0',3,1202,NULL,NULL,'');
09d6afa4
DO
362INSERT INTO `Port` VALUES (3127,956,'kvm',1,33,NULL,NULL,'');
363INSERT INTO `Port` VALUES (3128,956,'eth0',1,24,NULL,NULL,'');
364INSERT INTO `Port` VALUES (3129,956,'eth1',1,24,NULL,NULL,'');
365INSERT INTO `Port` VALUES (3130,957,'kvm',1,33,NULL,NULL,'');
366INSERT INTO `Port` VALUES (3131,957,'eth0',1,24,NULL,NULL,'');
367INSERT INTO `Port` VALUES (3132,957,'eth1',1,24,NULL,NULL,'');
368INSERT INTO `Port` VALUES (3133,958,'kvm',1,33,NULL,NULL,'');
369INSERT INTO `Port` VALUES (3134,958,'eth0',1,24,NULL,NULL,'');
370INSERT INTO `Port` VALUES (3135,958,'eth1',1,24,NULL,NULL,'');
371INSERT INTO `Port` VALUES (3136,959,'kvm',1,33,NULL,NULL,'');
372INSERT INTO `Port` VALUES (3137,959,'eth0',1,24,NULL,NULL,'');
373INSERT INTO `Port` VALUES (3138,959,'eth1',1,24,NULL,NULL,'');
374INSERT INTO `Port` VALUES (3139,960,'kvm',1,33,NULL,NULL,'');
375INSERT INTO `Port` VALUES (3140,960,'eth0',1,24,NULL,NULL,'');
376INSERT INTO `Port` VALUES (3141,960,'eth1',1,24,NULL,NULL,'');
377INSERT INTO `Port` VALUES (3142,908,'con0',1,29,NULL,NULL,'console');
378INSERT INTO `Port` VALUES (3143,961,'1',1,24,'01040104AA00',NULL,'');
379INSERT INTO `Port` VALUES (3144,961,'2',1,24,'01040104AA01','for field engineer','');
380INSERT INTO `Port` VALUES (3145,961,'3',1,24,'01040104AA02',NULL,'');
381INSERT INTO `Port` VALUES (3146,961,'4',1,24,'01040104AA03',NULL,'');
382INSERT INTO `Port` VALUES (3147,961,'5',1,24,'01040104AA04',NULL,'');
383INSERT INTO `Port` VALUES (3148,961,'6',1,24,'01040104AA05',NULL,'');
384INSERT INTO `Port` VALUES (3149,961,'7',1,24,'01040104AA06',NULL,'');
385INSERT INTO `Port` VALUES (3150,961,'8',1,24,'01040104AA07',NULL,'');
386INSERT INTO `Port` VALUES (3151,961,'9',1,24,'01040104AA08',NULL,'');
387INSERT INTO `Port` VALUES (3152,961,'10',1,24,'01040104AA09',NULL,'');
388INSERT INTO `Port` VALUES (3153,961,'11',1,24,'01040104AA0A',NULL,'');
389INSERT INTO `Port` VALUES (3154,961,'12',1,24,'01040104AA0B',NULL,'');
390INSERT INTO `Port` VALUES (3155,961,'13',1,24,'01040104AA0C',NULL,'');
391INSERT INTO `Port` VALUES (3156,961,'14',1,24,'01040104AA0D',NULL,'');
392INSERT INTO `Port` VALUES (3157,961,'15',1,24,'01040104AA0E',NULL,'');
393INSERT INTO `Port` VALUES (3158,961,'16',1,24,'01040104AA0F',NULL,'');
394INSERT INTO `Port` VALUES (3159,961,'con',1,681,NULL,NULL,'console');
395INSERT INTO `Port` VALUES (3160,956,'ttyS0',1,681,NULL,NULL,'serial A');
396INSERT INTO `Port` VALUES (3161,956,'ttyS1',1,681,NULL,NULL,'serial B');
397INSERT INTO `Port` VALUES (3162,962,'tail1',1,446,NULL,NULL,'');
398INSERT INTO `Port` VALUES (3163,962,'tail2',1,446,NULL,NULL,'');
399INSERT INTO `Port` VALUES (3164,962,'tail3',1,446,NULL,NULL,'');
400INSERT INTO `Port` VALUES (3165,962,'tail4',1,446,NULL,NULL,'');
401INSERT INTO `Port` VALUES (3166,962,'tail5',1,446,NULL,NULL,'');
402INSERT INTO `Port` VALUES (3167,962,'tail6',1,446,NULL,NULL,'');
403INSERT INTO `Port` VALUES (3168,962,'tail7',1,446,NULL,NULL,'');
404INSERT INTO `Port` VALUES (3169,962,'tail8',1,446,NULL,NULL,'');
405INSERT INTO `Port` VALUES (3170,962,'head',1,33,NULL,'monitor connected','');
406INSERT INTO `Port` VALUES (3171,962,'net',1,19,'020002003333',NULL,'');
407INSERT INTO `Port` VALUES (3178,927,'fa1/0',1,19,NULL,NULL,'');
408INSERT INTO `Port` VALUES (3179,908,'fa1/0',1,19,NULL,NULL,'');
69323c6c
DO
409INSERT INTO `Port` VALUES (3180,955,'in',1,16,NULL,'from local distribution','');
410INSERT INTO `Port` VALUES (3181,955,'out1',1,1322,NULL,NULL,'');
411INSERT INTO `Port` VALUES (3182,955,'out2',1,1322,NULL,NULL,'');
412INSERT INTO `Port` VALUES (3183,955,'out3',1,1322,NULL,NULL,'');
413INSERT INTO `Port` VALUES (3184,955,'out4',1,1322,NULL,NULL,'');
414INSERT INTO `Port` VALUES (3185,955,'out5',1,1322,NULL,NULL,'');
415INSERT INTO `Port` VALUES (3186,923,'ps',1,16,NULL,NULL,'');
416INSERT INTO `Port` VALUES (3187,924,'ps',1,16,NULL,NULL,'');
417INSERT INTO `Port` VALUES (3188,925,'ps',1,16,NULL,NULL,'');
418INSERT INTO `Port` VALUES (3189,926,'ps',1,16,NULL,NULL,'');
419INSERT INTO `Port` VALUES (3190,909,'ps',1,16,NULL,NULL,'');
e673ee24 420
d344ae81
DO
421INSERT INTO `Link` VALUES (3057,3071,NULL);
422INSERT INTO `Link` VALUES (3058,3084,NULL);
423INSERT INTO `Link` VALUES (3059,3069,NULL);
424INSERT INTO `Link` VALUES (3062,3094,NULL);
425INSERT INTO `Link` VALUES (3063,3079,NULL);
426INSERT INTO `Link` VALUES (3070,3083,NULL);
427INSERT INTO `Link` VALUES (3072,3080,NULL);
428INSERT INTO `Link` VALUES (3073,3086,NULL);
429INSERT INTO `Link` VALUES (3074,3088,NULL);
430INSERT INTO `Link` VALUES (3075,3090,NULL);
431INSERT INTO `Link` VALUES (3076,3092,NULL);
432INSERT INTO `Link` VALUES (3077,3097,NULL);
433INSERT INTO `Link` VALUES (3078,3095,NULL);
434INSERT INTO `Link` VALUES (3082,3085,NULL);
435INSERT INTO `Link` VALUES (3099,3112,NULL);
436INSERT INTO `Link` VALUES (3101,3113,NULL);
437INSERT INTO `Link` VALUES (3102,3114,NULL);
438INSERT INTO `Link` VALUES (3103,3115,NULL);
439INSERT INTO `Link` VALUES (3104,3116,NULL);
440INSERT INTO `Link` VALUES (3105,3117,NULL);
441INSERT INTO `Link` VALUES (3106,3118,NULL);
442INSERT INTO `Link` VALUES (3142,3160,NULL);
443INSERT INTO `Link` VALUES (3159,3161,NULL);
444INSERT INTO `Link` VALUES (3134,3143,NULL);
445INSERT INTO `Link` VALUES (3119,3147,NULL);
446INSERT INTO `Link` VALUES (3131,3148,NULL);
447INSERT INTO `Link` VALUES (3137,3151,NULL);
448INSERT INTO `Link` VALUES (3140,3154,NULL);
449INSERT INTO `Link` VALUES (3128,3158,NULL);
450INSERT INTO `Link` VALUES (3127,3162,NULL);
451INSERT INTO `Link` VALUES (3130,3163,NULL);
452INSERT INTO `Link` VALUES (3133,3164,NULL);
453INSERT INTO `Link` VALUES (3136,3165,NULL);
454INSERT INTO `Link` VALUES (3139,3168,NULL);
455INSERT INTO `Link` VALUES (3145,3171,NULL);
456INSERT INTO `Link` VALUES (3124,3126,NULL);
457INSERT INTO `Link` VALUES (3181,3186,NULL);
458INSERT INTO `Link` VALUES (3182,3187,NULL);
459INSERT INTO `Link` VALUES (3183,3190,NULL);
460INSERT INTO `Link` VALUES (3184,3188,NULL);
461INSERT INTO `Link` VALUES (3185,3189,NULL);
f000e1cd 462
706ce117
DO
463INSERT INTO `IPv4NAT` (`object_id`, `proto`, `localip`, `localport`, `remoteip`, `remoteport`, `description`) VALUES (915,'TCP',180879675,80,180879681,80,'');
464INSERT INTO `IPv4NAT` (`object_id`, `proto`, `localip`, `localport`, `remoteip`, `remoteport`, `description`) VALUES (915,'TCP',180879675,80,180879682,80,'');
465INSERT INTO `IPv4NAT` (`object_id`, `proto`, `localip`, `localport`, `remoteip`, `remoteport`, `description`) VALUES (915,'TCP',180879675,80,180879683,80,'');
466INSERT INTO `IPv4NAT` (`object_id`, `proto`, `localip`, `localport`, `remoteip`, `remoteport`, `description`) VALUES (915,'UDP',180879676,53,180879684,53,'');
467INSERT INTO `IPv4NAT` (`object_id`, `proto`, `localip`, `localport`, `remoteip`, `remoteport`, `description`) VALUES (915,'UDP',180879676,53,180879685,53,'');
468INSERT INTO `IPv4NAT` (`object_id`, `proto`, `localip`, `localport`, `remoteip`, `remoteport`, `description`) VALUES (915,'TCP',180879677,443,180879686,443,'');
469INSERT INTO `IPv4NAT` (`object_id`, `proto`, `localip`, `localport`, `remoteip`, `remoteport`, `description`) VALUES (915,'TCP',180879677,443,180879687,443,'');
e673ee24 470
9b8174d7
AD
471INSERT INTO `RackSpace` VALUES (968,9,'interior','T',905);
472INSERT INTO `RackSpace` VALUES (968,9,'front','T',905);
473INSERT INTO `RackSpace` VALUES (968,10,'interior','T',905);
474INSERT INTO `RackSpace` VALUES (968,10,'front','T',905);
475INSERT INTO `RackSpace` VALUES (968,11,'interior','T',905);
476INSERT INTO `RackSpace` VALUES (968,11,'front','T',905);
477INSERT INTO `RackSpace` VALUES (968,7,'front','T',906);
478INSERT INTO `RackSpace` VALUES (968,7,'interior','T',906);
479INSERT INTO `RackSpace` VALUES (970,16,'interior','T',907);
480INSERT INTO `RackSpace` VALUES (970,16,'rear','T',907);
481INSERT INTO `RackSpace` VALUES (970,15,'interior','T',907);
482INSERT INTO `RackSpace` VALUES (970,15,'rear','T',907);
483INSERT INTO `RackSpace` VALUES (970,14,'interior','T',907);
484INSERT INTO `RackSpace` VALUES (970,14,'rear','T',907);
485INSERT INTO `RackSpace` VALUES (974,15,'interior','T',909);
486INSERT INTO `RackSpace` VALUES (974,15,'rear','T',909);
487INSERT INTO `RackSpace` VALUES (974,14,'interior','T',909);
488INSERT INTO `RackSpace` VALUES (974,14,'rear','T',909);
489INSERT INTO `RackSpace` VALUES (974,13,'interior','T',909);
490INSERT INTO `RackSpace` VALUES (974,13,'rear','T',909);
491INSERT INTO `RackSpace` VALUES (972,20,'interior','T',908);
492INSERT INTO `RackSpace` VALUES (972,20,'rear','T',908);
493INSERT INTO `RackSpace` VALUES (972,19,'interior','T',908);
494INSERT INTO `RackSpace` VALUES (972,19,'rear','T',908);
495INSERT INTO `RackSpace` VALUES (972,18,'interior','T',908);
496INSERT INTO `RackSpace` VALUES (972,18,'rear','T',908);
497INSERT INTO `RackSpace` VALUES (967,2,'front','T',910);
498INSERT INTO `RackSpace` VALUES (967,2,'interior','T',910);
499INSERT INTO `RackSpace` VALUES (967,2,'rear','T',910);
500INSERT INTO `RackSpace` VALUES (967,4,'front','T',911);
501INSERT INTO `RackSpace` VALUES (967,4,'interior','T',911);
502INSERT INTO `RackSpace` VALUES (967,4,'rear','T',911);
503INSERT INTO `RackSpace` VALUES (967,6,'front','T',912);
504INSERT INTO `RackSpace` VALUES (967,6,'interior','T',912);
505INSERT INTO `RackSpace` VALUES (967,6,'rear','T',912);
506INSERT INTO `RackSpace` VALUES (967,8,'front','T',913);
507INSERT INTO `RackSpace` VALUES (967,8,'interior','T',913);
508INSERT INTO `RackSpace` VALUES (967,8,'rear','T',913);
509INSERT INTO `RackSpace` VALUES (967,10,'front','T',914);
510INSERT INTO `RackSpace` VALUES (967,10,'interior','T',914);
511INSERT INTO `RackSpace` VALUES (967,10,'rear','T',914);
512INSERT INTO `RackSpace` VALUES (967,23,'rear','T',916);
513INSERT INTO `RackSpace` VALUES (967,23,'interior','T',916);
514INSERT INTO `RackSpace` VALUES (967,23,'front','T',916);
515INSERT INTO `RackSpace` VALUES (968,5,'front','T',915);
516INSERT INTO `RackSpace` VALUES (968,5,'interior','T',915);
517INSERT INTO `RackSpace` VALUES (968,4,'interior','T',915);
518INSERT INTO `RackSpace` VALUES (968,4,'front','T',915);
519INSERT INTO `RackSpace` VALUES (967,22,'front','T',916);
520INSERT INTO `RackSpace` VALUES (967,22,'interior','T',916);
521INSERT INTO `RackSpace` VALUES (967,22,'rear','T',916);
522INSERT INTO `RackSpace` VALUES (969,7,'front','T',918);
523INSERT INTO `RackSpace` VALUES (969,7,'interior','T',918);
524INSERT INTO `RackSpace` VALUES (969,7,'rear','T',918);
525INSERT INTO `RackSpace` VALUES (969,6,'front','T',918);
526INSERT INTO `RackSpace` VALUES (969,6,'interior','T',918);
527INSERT INTO `RackSpace` VALUES (969,6,'rear','T',918);
528INSERT INTO `RackSpace` VALUES (969,5,'front','T',918);
529INSERT INTO `RackSpace` VALUES (969,5,'interior','T',918);
530INSERT INTO `RackSpace` VALUES (969,5,'rear','T',918);
531INSERT INTO `RackSpace` VALUES (969,4,'front','T',918);
532INSERT INTO `RackSpace` VALUES (969,4,'interior','T',918);
533INSERT INTO `RackSpace` VALUES (969,4,'rear','T',918);
534INSERT INTO `RackSpace` VALUES (969,3,'front','T',918);
535INSERT INTO `RackSpace` VALUES (969,3,'interior','T',918);
536INSERT INTO `RackSpace` VALUES (969,3,'rear','T',918);
537INSERT INTO `RackSpace` VALUES (969,13,'front','T',919);
538INSERT INTO `RackSpace` VALUES (969,13,'interior','T',919);
539INSERT INTO `RackSpace` VALUES (969,13,'rear','T',919);
540INSERT INTO `RackSpace` VALUES (969,12,'front','T',919);
541INSERT INTO `RackSpace` VALUES (969,12,'interior','T',919);
542INSERT INTO `RackSpace` VALUES (969,12,'rear','T',919);
543INSERT INTO `RackSpace` VALUES (969,11,'front','T',919);
544INSERT INTO `RackSpace` VALUES (969,11,'interior','T',919);
545INSERT INTO `RackSpace` VALUES (969,11,'rear','T',919);
546INSERT INTO `RackSpace` VALUES (969,10,'front','T',919);
547INSERT INTO `RackSpace` VALUES (969,10,'interior','T',919);
548INSERT INTO `RackSpace` VALUES (969,10,'rear','T',919);
549INSERT INTO `RackSpace` VALUES (969,9,'front','T',919);
550INSERT INTO `RackSpace` VALUES (969,9,'interior','T',919);
551INSERT INTO `RackSpace` VALUES (969,9,'rear','T',919);
552INSERT INTO `RackSpace` VALUES (969,37,'front','T',920);
553INSERT INTO `RackSpace` VALUES (969,37,'interior','T',920);
554INSERT INTO `RackSpace` VALUES (969,37,'rear','T',920);
555INSERT INTO `RackSpace` VALUES (969,36,'front','T',920);
556INSERT INTO `RackSpace` VALUES (969,36,'interior','T',920);
557INSERT INTO `RackSpace` VALUES (969,36,'rear','T',920);
558INSERT INTO `RackSpace` VALUES (969,35,'front','T',920);
559INSERT INTO `RackSpace` VALUES (969,35,'interior','T',920);
560INSERT INTO `RackSpace` VALUES (969,35,'rear','T',920);
561INSERT INTO `RackSpace` VALUES (969,34,'front','T',920);
562INSERT INTO `RackSpace` VALUES (969,34,'interior','T',920);
563INSERT INTO `RackSpace` VALUES (969,34,'rear','T',920);
564INSERT INTO `RackSpace` VALUES (969,33,'front','T',920);
565INSERT INTO `RackSpace` VALUES (969,33,'interior','T',920);
566INSERT INTO `RackSpace` VALUES (969,33,'rear','T',920);
567INSERT INTO `RackSpace` VALUES (969,32,'front','T',920);
568INSERT INTO `RackSpace` VALUES (969,32,'interior','T',920);
569INSERT INTO `RackSpace` VALUES (969,32,'rear','T',920);
570INSERT INTO `RackSpace` VALUES (969,31,'front','T',920);
571INSERT INTO `RackSpace` VALUES (969,31,'interior','T',920);
572INSERT INTO `RackSpace` VALUES (969,31,'rear','T',920);
573INSERT INTO `RackSpace` VALUES (969,30,'front','T',920);
574INSERT INTO `RackSpace` VALUES (969,30,'interior','T',920);
575INSERT INTO `RackSpace` VALUES (969,30,'rear','T',920);
576INSERT INTO `RackSpace` VALUES (969,16,'front','T',921);
577INSERT INTO `RackSpace` VALUES (969,16,'interior','T',921);
578INSERT INTO `RackSpace` VALUES (969,16,'rear','T',921);
579INSERT INTO `RackSpace` VALUES (969,15,'front','T',921);
580INSERT INTO `RackSpace` VALUES (969,15,'interior','T',921);
581INSERT INTO `RackSpace` VALUES (969,15,'rear','T',921);
582INSERT INTO `RackSpace` VALUES (969,18,'front','T',922);
583INSERT INTO `RackSpace` VALUES (969,18,'interior','T',922);
584INSERT INTO `RackSpace` VALUES (969,18,'rear','T',922);
585INSERT INTO `RackSpace` VALUES (969,17,'front','T',922);
586INSERT INTO `RackSpace` VALUES (969,17,'interior','T',922);
587INSERT INTO `RackSpace` VALUES (969,17,'rear','T',922);
588INSERT INTO `RackSpace` VALUES (974,11,'interior','T',926);
589INSERT INTO `RackSpace` VALUES (974,11,'rear','T',926);
590INSERT INTO `RackSpace` VALUES (974,1,'front','T',923);
591INSERT INTO `RackSpace` VALUES (974,1,'interior','T',923);
592INSERT INTO `RackSpace` VALUES (974,1,'rear','T',923);
593INSERT INTO `RackSpace` VALUES (974,3,'front','T',924);
594INSERT INTO `RackSpace` VALUES (974,3,'interior','T',924);
595INSERT INTO `RackSpace` VALUES (974,3,'rear','T',924);
596INSERT INTO `RackSpace` VALUES (974,5,'front','T',925);
597INSERT INTO `RackSpace` VALUES (974,5,'interior','T',925);
598INSERT INTO `RackSpace` VALUES (974,5,'rear','T',925);
599INSERT INTO `RackSpace` VALUES (970,12,'interior','T',927);
600INSERT INTO `RackSpace` VALUES (970,12,'rear','T',927);
601INSERT INTO `RackSpace` VALUES (970,11,'interior','T',927);
602INSERT INTO `RackSpace` VALUES (970,11,'rear','T',927);
603INSERT INTO `RackSpace` VALUES (970,10,'interior','T',927);
604INSERT INTO `RackSpace` VALUES (970,10,'rear','T',927);
605INSERT INTO `RackSpace` VALUES (970,2,'front','T',944);
606INSERT INTO `RackSpace` VALUES (970,2,'interior','T',944);
607INSERT INTO `RackSpace` VALUES (970,2,'rear','T',944);
608INSERT INTO `RackSpace` VALUES (970,1,'front','T',944);
609INSERT INTO `RackSpace` VALUES (970,1,'interior','T',944);
610INSERT INTO `RackSpace` VALUES (970,1,'rear','T',944);
611INSERT INTO `RackSpace` VALUES (971,5,'front','T',942);
612INSERT INTO `RackSpace` VALUES (971,5,'interior','T',942);
613INSERT INTO `RackSpace` VALUES (971,5,'rear','T',942);
614INSERT INTO `RackSpace` VALUES (971,4,'front','T',942);
615INSERT INTO `RackSpace` VALUES (971,4,'interior','T',942);
616INSERT INTO `RackSpace` VALUES (971,4,'rear','T',942);
617INSERT INTO `RackSpace` VALUES (971,3,'front','T',942);
618INSERT INTO `RackSpace` VALUES (971,3,'interior','T',942);
619INSERT INTO `RackSpace` VALUES (971,3,'rear','T',942);
620INSERT INTO `RackSpace` VALUES (971,2,'front','T',942);
621INSERT INTO `RackSpace` VALUES (971,2,'interior','T',942);
622INSERT INTO `RackSpace` VALUES (971,2,'rear','T',942);
623INSERT INTO `RackSpace` VALUES (971,1,'front','T',942);
624INSERT INTO `RackSpace` VALUES (971,1,'interior','T',942);
625INSERT INTO `RackSpace` VALUES (971,1,'rear','T',942);
626INSERT INTO `RackSpace` VALUES (973,5,'front','T',943);
627INSERT INTO `RackSpace` VALUES (973,5,'interior','T',943);
628INSERT INTO `RackSpace` VALUES (973,5,'rear','T',943);
629INSERT INTO `RackSpace` VALUES (973,4,'front','T',943);
630INSERT INTO `RackSpace` VALUES (973,4,'interior','T',943);
631INSERT INTO `RackSpace` VALUES (973,4,'rear','T',943);
632INSERT INTO `RackSpace` VALUES (973,3,'front','T',943);
633INSERT INTO `RackSpace` VALUES (973,3,'interior','T',943);
634INSERT INTO `RackSpace` VALUES (973,3,'rear','T',943);
635INSERT INTO `RackSpace` VALUES (973,2,'front','T',943);
636INSERT INTO `RackSpace` VALUES (973,2,'interior','T',943);
637INSERT INTO `RackSpace` VALUES (973,2,'rear','T',943);
638INSERT INTO `RackSpace` VALUES (973,1,'front','T',943);
639INSERT INTO `RackSpace` VALUES (973,1,'interior','T',943);
640INSERT INTO `RackSpace` VALUES (973,1,'rear','T',943);
641INSERT INTO `RackSpace` VALUES (971,6,'front','U',NULL);
642INSERT INTO `RackSpace` VALUES (971,6,'interior','U',NULL);
643INSERT INTO `RackSpace` VALUES (971,6,'rear','U',NULL);
644INSERT INTO `RackSpace` VALUES (973,6,'front','U',NULL);
645INSERT INTO `RackSpace` VALUES (973,6,'interior','U',NULL);
646INSERT INTO `RackSpace` VALUES (973,6,'rear','U',NULL);
647INSERT INTO `RackSpace` VALUES (973,17,'rear','T',954);
648INSERT INTO `RackSpace` VALUES (972,20,'front','T',953);
649INSERT INTO `RackSpace` VALUES (968,6,'front','T',952);
650INSERT INTO `RackSpace` VALUES (967,1,'rear','T',949);
651INSERT INTO `RackSpace` VALUES (973,37,'rear','T',931);
652INSERT INTO `RackSpace` VALUES (973,37,'interior','T',931);
653INSERT INTO `RackSpace` VALUES (973,40,'rear','T',929);
654INSERT INTO `RackSpace` VALUES (973,40,'interior','T',929);
655INSERT INTO `RackSpace` VALUES (973,15,'rear','T',941);
656INSERT INTO `RackSpace` VALUES (973,15,'interior','T',941);
657INSERT INTO `RackSpace` VALUES (973,15,'front','T',941);
658INSERT INTO `RackSpace` VALUES (973,13,'front','T',939);
659INSERT INTO `RackSpace` VALUES (973,11,'rear','T',937);
660INSERT INTO `RackSpace` VALUES (973,11,'interior','T',937);
661INSERT INTO `RackSpace` VALUES (973,9,'interior','T',935);
662INSERT INTO `RackSpace` VALUES (973,7,'interior','T',933);
663INSERT INTO `RackSpace` VALUES (974,16,'rear','T',946);
664INSERT INTO `RackSpace` VALUES (971,38,'rear','T',930);
665INSERT INTO `RackSpace` VALUES (971,40,'interior','T',928);
666INSERT INTO `RackSpace` VALUES (971,15,'rear','T',940);
667INSERT INTO `RackSpace` VALUES (971,13,'rear','T',938);
668INSERT INTO `RackSpace` VALUES (971,11,'rear','T',936);
669INSERT INTO `RackSpace` VALUES (971,9,'rear','T',934);
670INSERT INTO `RackSpace` VALUES (971,7,'rear','T',932);
671INSERT INTO `RackSpace` VALUES (968,12,'rear','A',NULL);
672INSERT INTO `RackSpace` VALUES (968,11,'rear','A',NULL);
673INSERT INTO `RackSpace` VALUES (968,10,'rear','A',NULL);
674INSERT INTO `RackSpace` VALUES (968,9,'rear','A',NULL);
675INSERT INTO `RackSpace` VALUES (968,8,'rear','A',NULL);
676INSERT INTO `RackSpace` VALUES (968,7,'rear','A',NULL);
677INSERT INTO `RackSpace` VALUES (968,6,'rear','A',NULL);
678INSERT INTO `RackSpace` VALUES (968,5,'rear','A',NULL);
679INSERT INTO `RackSpace` VALUES (968,4,'rear','A',NULL);
680INSERT INTO `RackSpace` VALUES (968,3,'rear','A',NULL);
681INSERT INTO `RackSpace` VALUES (968,2,'rear','A',NULL);
682INSERT INTO `RackSpace` VALUES (968,1,'rear','A',NULL);
683INSERT INTO `RackSpace` VALUES (974,9,'rear','T',955);
684INSERT INTO `RackSpace` VALUES (971,17,'rear','T',951);
685INSERT INTO `RackSpace` VALUES (970,9,'rear','T',948);
686INSERT INTO `RackSpace` VALUES (969,14,'rear','T',950);
687INSERT INTO `RackSpace` VALUES (969,2,'rear','T',947);
688INSERT INTO `RackSpace` VALUES (973,38,'rear','T',931);
689INSERT INTO `RackSpace` VALUES (973,38,'interior','T',931);
690INSERT INTO `RackSpace` VALUES (973,41,'rear','T',929);
691INSERT INTO `RackSpace` VALUES (973,41,'interior','T',929);
692INSERT INTO `RackSpace` VALUES (973,13,'rear','T',939);
693INSERT INTO `RackSpace` VALUES (973,13,'interior','T',939);
694INSERT INTO `RackSpace` VALUES (973,11,'front','T',937);
695INSERT INTO `RackSpace` VALUES (973,9,'rear','T',935);
696INSERT INTO `RackSpace` VALUES (973,9,'front','T',935);
697INSERT INTO `RackSpace` VALUES (973,7,'rear','T',933);
698INSERT INTO `RackSpace` VALUES (973,7,'front','T',933);
699INSERT INTO `RackSpace` VALUES (970,13,'rear','T',945);
700INSERT INTO `RackSpace` VALUES (971,37,'rear','T',930);
701INSERT INTO `RackSpace` VALUES (971,37,'interior','T',930);
702INSERT INTO `RackSpace` VALUES (971,38,'interior','T',930);
703INSERT INTO `RackSpace` VALUES (971,40,'rear','T',928);
704INSERT INTO `RackSpace` VALUES (971,41,'rear','T',928);
705INSERT INTO `RackSpace` VALUES (971,41,'interior','T',928);
706INSERT INTO `RackSpace` VALUES (971,15,'interior','T',940);
707INSERT INTO `RackSpace` VALUES (971,15,'front','T',940);
708INSERT INTO `RackSpace` VALUES (971,13,'interior','T',938);
709INSERT INTO `RackSpace` VALUES (971,13,'front','T',938);
710INSERT INTO `RackSpace` VALUES (971,11,'interior','T',936);
711INSERT INTO `RackSpace` VALUES (971,11,'front','T',936);
712INSERT INTO `RackSpace` VALUES (971,9,'interior','T',934);
713INSERT INTO `RackSpace` VALUES (971,9,'front','T',934);
714INSERT INTO `RackSpace` VALUES (971,7,'interior','T',932);
715INSERT INTO `RackSpace` VALUES (971,7,'front','T',932);
716INSERT INTO `RackSpace` VALUES (968,2,'front','T',917);
717INSERT INTO `RackSpace` VALUES (968,2,'interior','T',917);
718INSERT INTO `RackSpace` VALUES (968,1,'front','T',917);
719INSERT INTO `RackSpace` VALUES (968,1,'interior','T',917);
720INSERT INTO `RackSpace` VALUES (972,2,'front','T',956);
721INSERT INTO `RackSpace` VALUES (972,2,'interior','T',956);
722INSERT INTO `RackSpace` VALUES (972,2,'rear','T',956);
723INSERT INTO `RackSpace` VALUES (972,4,'front','T',957);
724INSERT INTO `RackSpace` VALUES (972,4,'interior','T',957);
725INSERT INTO `RackSpace` VALUES (972,4,'rear','T',957);
726INSERT INTO `RackSpace` VALUES (972,6,'front','T',958);
727INSERT INTO `RackSpace` VALUES (972,6,'interior','T',958);
728INSERT INTO `RackSpace` VALUES (972,6,'rear','T',958);
729INSERT INTO `RackSpace` VALUES (972,8,'front','T',959);
730INSERT INTO `RackSpace` VALUES (972,8,'interior','T',959);
731INSERT INTO `RackSpace` VALUES (972,8,'rear','T',959);
732INSERT INTO `RackSpace` VALUES (972,10,'front','T',960);
733INSERT INTO `RackSpace` VALUES (972,10,'interior','T',960);
734INSERT INTO `RackSpace` VALUES (972,10,'rear','T',960);
735INSERT INTO `RackSpace` VALUES (972,35,'interior','T',961);
736INSERT INTO `RackSpace` VALUES (972,35,'rear','T',961);
737INSERT INTO `RackSpace` VALUES (972,34,'interior','T',962);
738INSERT INTO `RackSpace` VALUES (972,34,'rear','T',962);
e673ee24 739
e1add254
AD
740INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (1,NULL,'testing');
741INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (2,NULL,'production');
742INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (10,NULL,'network');
743INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (5,10,'WAN link');
744INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (6,NULL,'racks');
745INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (7,6,'tall racks');
746INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (8,6,'low racks');
747INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (9,NULL,'load balancer');
748INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (11,10,'small network');
749INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (12,10,'medium network');
750INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (16,NULL,'XKCD');
751INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (17,16,'romance');
752INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (18,16,'sarcasm');
753INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (19,16,'math');
754INSERT INTO `TagTree` (`id`, `parent_id`, `tag`) VALUES (20,16,'language');
41497dbe 755
e1add254
AD
756INSERT INTO `TagStorage` VALUES ('object',905,1,NULL,NULL);
757INSERT INTO `TagStorage` VALUES ('object',908,2,NULL,NULL);
758INSERT INTO `TagStorage` VALUES ('object',909,1,NULL,NULL);
03c5a938 759INSERT INTO `TagStorage` VALUES ('object',928,9,NULL,NULL);
03c5a938 760INSERT INTO `TagStorage` VALUES ('object',929,9,NULL,NULL);
e1add254
AD
761INSERT INTO `TagStorage` VALUES ('object',956,2,NULL,NULL);
762INSERT INTO `TagStorage` VALUES ('object',957,2,NULL,NULL);
763INSERT INTO `TagStorage` VALUES ('object',958,2,NULL,NULL);
764INSERT INTO `TagStorage` VALUES ('object',959,2,NULL,NULL);
765INSERT INTO `TagStorage` VALUES ('object',960,2,NULL,NULL);
766INSERT INTO `TagStorage` VALUES ('object',961,2,NULL,NULL);
767INSERT INTO `TagStorage` VALUES ('object',962,2,NULL,NULL);
768INSERT INTO `TagStorage` VALUES ('ipv4net',96,12,NULL,NULL);
769INSERT INTO `TagStorage` VALUES ('ipv4net',97,12,NULL,NULL);
770INSERT INTO `TagStorage` VALUES ('ipv4net',98,12,NULL,NULL);
771INSERT INTO `TagStorage` VALUES ('ipv4net',99,12,NULL,NULL);
772INSERT INTO `TagStorage` VALUES ('ipv4net',102,5,NULL,NULL);
03c5a938 773INSERT INTO `TagStorage` VALUES ('ipv4net',102,11,NULL,NULL);
e1add254 774INSERT INTO `TagStorage` VALUES ('ipv4net',103,5,NULL,NULL);
03c5a938 775INSERT INTO `TagStorage` VALUES ('ipv4net',103,11,NULL,NULL);
e1add254 776INSERT INTO `TagStorage` VALUES ('ipv4net',104,5,NULL,NULL);
03c5a938 777INSERT INTO `TagStorage` VALUES ('ipv4net',104,11,NULL,NULL);
e1add254 778INSERT INTO `TagStorage` VALUES ('ipv4net',105,5,NULL,NULL);
03c5a938 779INSERT INTO `TagStorage` VALUES ('ipv4net',105,11,NULL,NULL);
e1add254
AD
780INSERT INTO `TagStorage` VALUES ('ipv4net',106,12,NULL,NULL);
781INSERT INTO `TagStorage` VALUES ('ipv4net',107,12,NULL,NULL);
782INSERT INTO `TagStorage` VALUES ('ipv4net',108,12,NULL,NULL);
783INSERT INTO `TagStorage` VALUES ('rack',967,7,NULL,NULL);
03c5a938 784INSERT INTO `TagStorage` VALUES ('rack',968,8,NULL,NULL);
e1add254
AD
785INSERT INTO `TagStorage` VALUES ('rack',969,7,NULL,NULL);
786INSERT INTO `TagStorage` VALUES ('rack',970,8,NULL,NULL);
787INSERT INTO `TagStorage` VALUES ('rack',971,7,NULL,NULL);
03c5a938 788INSERT INTO `TagStorage` VALUES ('rack',972,7,NULL,NULL);
e1add254
AD
789INSERT INTO `TagStorage` VALUES ('rack',973,7,NULL,NULL);
790INSERT INTO `TagStorage` VALUES ('rack',974,8,NULL,NULL);
791INSERT INTO `TagStorage` VALUES ('ipv6net','1','10',NULL,NULL);
792INSERT INTO `TagStorage` VALUES ('ipv6net','2','12',NULL,NULL);
793INSERT INTO `TagStorage` VALUES ('ipv6net','3','12',NULL,NULL);
03c5a938 794INSERT INTO `TagStorage` VALUES ('ipv6net','4','18',NULL,NULL);
03c5a938 795INSERT INTO `TagStorage` VALUES ('ipv6net','5','18',NULL,NULL);
b1808b2a
DO
796
797INSERT INTO `VLANDomain` VALUES
798(2,'English'),
799(1,'русский'),
800(3,'українська'),
801(4,'日本語');
802
803INSERT INTO `VLANDescription` VALUES
804(1,1,'compulsory','default'),
805(1,2,'ondemand','второй'),
806(1,3,'ondemand','третий'),
807(1,4,'ondemand','четвёртый'),
808(1,5,'ondemand','пятый'),
809(1,6,'ondemand','шестой'),
810(1,7,'ondemand','седьмой'),
811(1,8,'ondemand','восьмой'),
812(1,9,'ondemand','девятый'),
813(1,10,'ondemand','десятый'),
814(1,11,'ondemand','одиннадцатый'),
815(1,12,'ondemand','двенадцатый'),
816(1,13,'ondemand','тринадцатый'),
817(1,14,'ondemand','четырнадцатый'),
818(1,15,'ondemand','пятнадцатый'),
819(2,1,'compulsory','default'),
820(2,2,'ondemand','second'),
821(2,3,'ondemand','third'),
822(2,4,'ondemand','fourth'),
823(2,5,'ondemand','fifth'),
824(2,6,'ondemand','sixth'),
825(2,7,'ondemand','seventh'),
826(2,8,'ondemand','eighth'),
827(2,9,'ondemand','ninth'),
828(2,10,'ondemand','tenth'),
829(2,11,'ondemand','eleventh'),
830(2,12,'ondemand','twelfth'),
831(2,13,'ondemand','thirteenth'),
832(2,14,'ondemand','fourteenth'),
833(2,15,'ondemand','fifteenth'),
834(3,1,'compulsory','default'),
835(3,2,'ondemand','другий'),
836(3,3,'ondemand','третій'),
837(3,4,'ondemand','четвертий'),
838(3,5,'ondemand','п\'ятий'),
839(3,6,'ondemand','шостий'),
840(3,7,'ondemand','сьомий'),
841(3,8,'ondemand','восьмий'),
842(3,9,'ondemand','дев\'ятий'),
843(3,10,'ondemand','десятий'),
844(3,11,'ondemand','одинадцятий'),
845(3,12,'ondemand','дванадцятий'),
846(3,13,'ondemand','тринадцятий'),
847(3,14,'ondemand','чотирнадцятий'),
848(3,15,'ondemand','п\'ятнадцятий'),
849(4,1,'compulsory','default'),
850(4,2,'ondemand','第二'),
851(4,3,'ondemand','第三'),
852(4,4,'ondemand','第四'),
853(4,5,'ondemand','第五'),
854(4,6,'ondemand','第六'),
855(4,7,'ondemand','第七'),
856(4,8,'ondemand','第八'),
857(4,9,'ondemand','第九'),
858(4,10,'ondemand','第十'),
859(4,11,'ondemand','第十一'),
860(4,12,'ondemand','第十二'),
861(4,13,'ondemand','第十三'),
862(4,14,'ondemand','第十四'),
863(4,15,'ondemand','第十五');