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