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