r4550 added sample 802.1Q data
authorDenis Ovsienko <infrastation@yandex.ru>
Wed, 8 Jun 2011 14:51:55 +0000 (14:51 +0000)
committerDenis Ovsienko <infrastation@yandex.ru>
Wed, 8 Jun 2011 14:51:55 +0000 (14:51 +0000)
scripts/init-sample-racks.sql

index 2b66ef9..ca35db4 100644 (file)
@@ -846,3 +846,71 @@ INSERT INTO `TagStorage` VALUES ('ipv6net','4','8');
 INSERT INTO `TagStorage` VALUES ('ipv6net','4','18');
 INSERT INTO `TagStorage` VALUES ('ipv6net','5','7');
 INSERT INTO `TagStorage` VALUES ('ipv6net','5','18');
+
+INSERT INTO `VLANDomain` VALUES
+(2,'English'),
+(1,'русский'),
+(3,'українська'),
+(4,'日本語');
+
+INSERT INTO `VLANDescription` VALUES
+(1,1,'compulsory','default'),
+(1,2,'ondemand','второй'),
+(1,3,'ondemand','третий'),
+(1,4,'ondemand','четвёртый'),
+(1,5,'ondemand','пятый'),
+(1,6,'ondemand','шестой'),
+(1,7,'ondemand','седьмой'),
+(1,8,'ondemand','восьмой'),
+(1,9,'ondemand','девятый'),
+(1,10,'ondemand','десятый'),
+(1,11,'ondemand','одиннадцатый'),
+(1,12,'ondemand','двенадцатый'),
+(1,13,'ondemand','тринадцатый'),
+(1,14,'ondemand','четырнадцатый'),
+(1,15,'ondemand','пятнадцатый'),
+(2,1,'compulsory','default'),
+(2,2,'ondemand','second'),
+(2,3,'ondemand','third'),
+(2,4,'ondemand','fourth'),
+(2,5,'ondemand','fifth'),
+(2,6,'ondemand','sixth'),
+(2,7,'ondemand','seventh'),
+(2,8,'ondemand','eighth'),
+(2,9,'ondemand','ninth'),
+(2,10,'ondemand','tenth'),
+(2,11,'ondemand','eleventh'),
+(2,12,'ondemand','twelfth'),
+(2,13,'ondemand','thirteenth'),
+(2,14,'ondemand','fourteenth'),
+(2,15,'ondemand','fifteenth'),
+(3,1,'compulsory','default'),
+(3,2,'ondemand','другий'),
+(3,3,'ondemand','третій'),
+(3,4,'ondemand','четвертий'),
+(3,5,'ondemand','п\'ятий'),
+(3,6,'ondemand','шостий'),
+(3,7,'ondemand','сьомий'),
+(3,8,'ondemand','восьмий'),
+(3,9,'ondemand','дев\'ятий'),
+(3,10,'ondemand','десятий'),
+(3,11,'ondemand','одинадцятий'),
+(3,12,'ondemand','дванадцятий'),
+(3,13,'ondemand','тринадцятий'),
+(3,14,'ondemand','чотирнадцятий'),
+(3,15,'ondemand','п\'ятнадцятий'),
+(4,1,'compulsory','default'),
+(4,2,'ondemand','第二'),
+(4,3,'ondemand','第三'),
+(4,4,'ondemand','第四'),
+(4,5,'ondemand','第五'),
+(4,6,'ondemand','第六'),
+(4,7,'ondemand','第七'),
+(4,8,'ondemand','第八'),
+(4,9,'ondemand','第九'),
+(4,10,'ondemand','第十'),
+(4,11,'ondemand','第十一'),
+(4,12,'ondemand','第十二'),
+(4,13,'ondemand','第十三'),
+(4,14,'ondemand','第十四'),
+(4,15,'ondemand','第十五');