add more 40G and 100G standards
authorDenis Ovsienko <infrastation@yandex.ru>
Sat, 10 May 2014 18:12:09 +0000 (22:12 +0400)
committerDenis Ovsienko <infrastation@yandex.ru>
Sat, 10 May 2014 18:12:09 +0000 (22:12 +0400)
wwwroot/inc/install.php
wwwroot/inc/upgrade.php

index 4a1447d..2148d14 100644 (file)
@@ -1748,13 +1748,18 @@ WHERE O.objtype_id = 1562";
 (1603,'1000Base-T (HP c-Class)'),
 (1604,'100Base-TX (HP c-Class)'),
 (1642,'10GBase-T'),
+(1660,'40GBase-FR'),
 (1661,'40GBase-KR4'),
+(1662,'40GBase-ER4'),
 (1663,'40GBase-SR4'),
 (1664,'40GBase-LR4'),
 (1668,'empty CFP'),
 (1669,'100GBase-SR10'),
 (1670,'100GBase-LR4'),
 (1671,'100GBase-ER4'),
+(1672,'100GBase-SR4'),
+(1673,'100GBase-KR4'),
+(1674,'100GBase-KP4'),
 (1999,'10GBase-KR')
 ";
 // Add new outer interface types with id < 2000. Values 2000 and up are for
@@ -1783,8 +1788,8 @@ WHERE O.objtype_id = 1562";
 (7,1081),(7,30),(7,35),(7,36),(7,37),(7,38),(7,39),(7,40),
 (8,1082),(8,30),(8,35),(8,36),(8,37),(8,38),(8,39),(8,40),
 (9,1084),(9,30),(9,35),(9,36),(9,37),(9,38),(9,39),(9,40),
-(10,1588),(10,1663),(10,1664),
-(11,1668),(11,1669),(11,1670),(11,1671),
+(10,1588),(10,1660),(10,1662),(10,1663),(10,1664),
+(11,1668),(11,1669),(11,1670),(11,1671),(11,1672),(11,1673),(11,1674),
 (1,16),(1,19),(1,24),(1,29),(1,31),(1,33),(1,446),(1,681),(1,682),(1,1322),(1,1399),(1,1469)";
 
                $query[] = "INSERT INTO `PortCompat` (`type1`, `type2`) VALUES
@@ -1978,13 +1983,18 @@ WHERE O.objtype_id = 1562";
 (1399,1399),
 (1588,1588),
 (1603,1603),
+(1660,1660),
 (1661,1661),
+(1662,1662),
 (1663,1663),
 (1664,1664),
 (1668,1668),
 (1669,1669),
 (1670,1670),
 (1671,1671),
+(1672,1672),
+(1673,1673),
+(1674,1674),
 (1642,1642),
 (1999,1999)";
 
index 80aa86e..770ffb1 100644 (file)
@@ -1633,6 +1633,25 @@ CREATE TABLE `PortOuterInterface` (
                        $query[] = "ALTER TABLE PortInterfaceCompat ADD CONSTRAINT `PortInterfaceCompat-FK-oif_id` FOREIGN KEY (oif_id) REFERENCES PortOuterInterface (id)";
                        $query[] = "ALTER TABLE PortCompat ADD CONSTRAINT `PortCompat-FK-oif_id1` FOREIGN KEY (type1) REFERENCES PortOuterInterface (id)";
                        $query[] = "ALTER TABLE PortCompat ADD CONSTRAINT `PortCompat-FK-oif_id2` FOREIGN KEY (type2) REFERENCES PortOuterInterface (id)";
+                       // Add more 40G and 100G standards.
+                       $query[] = "INSERT INTO PortOuterInterface (id, oif_name) VALUES
+(1660,'40GBase-FR'),
+(1662,'40GBase-ER4'),
+(1672,'100GBase-SR4'),
+(1673,'100GBase-KR4'),
+(1674,'100GBase-KP4')";
+                       $query[] = "INSERT INTO PortInterfaceCompat (iif_id, oif_id) VALUES
+(10,1660),
+(10,1662),
+(11,1672),
+(11,1673),
+(11,1674)";
+                       $query[] = "INSERT INTO PortCompat (type1, type2) VALUES
+(1660,1660),
+(1662,1662),
+(1672,1672),
+(1673,1673),
+(1674,1674)";
                        $query[] = "UPDATE Config SET varvalue = '0.20.8' WHERE varname = 'DB_VERSION'";
                        break;
                case '0.21.0':