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