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