Changeset 770 for trunk/Common/Setup/Updates.php

Timestamp:

Dec 24, 2015, 12:46:37 AM (9 years ago)

Author:

chronos

Message:

• Added: Some VPS related tables.

File:

• trunk/Common/Setup/Updates.php (modified) (2 diffs)

trunk/Common/Setup/Updates.php

@@ -1673 +1673 @@
   $Manager->Execute('ALTER TABLE `NetworkDomainView`
   ADD FOREIGN KEY (`Domain`) REFERENCES `NetworkDomainView`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
+}
+
+function UpdateTo770($Manager)
+{
+  $Manager->Execute("CREATE TABLE IF NOT EXISTS `OS` (
+      `Id` int(11) NOT NULL AUTO_INCREMENT,
+      `Name` varchar(255) NOT NULL,
+      `Subject` int(11) DEFAULT NULL,
+      `Web` varchar(255) NOT NULL,
+      PRIMARY KEY (`Id`),
+      KEY `Subject` (`Subject`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
+
+  $Manager->Execute("INSERT INTO `OS` (`Id`, `Name`, `Subject`, `Web`) VALUES
+  (3, 'Ubuntu', NULL, 'http://www.ubuntu.com/'),
+  (4, 'Fedora', NULL, 'https://getfedora.org/'),
+  (5, 'OpenSUSE', NULL, 'https://www.opensuse.org/'),
+  (6, 'Arch Linux', NULL, 'https://www.archlinux.org/'),
+  (7, 'Debian', NULL, 'https://www.debian.org/');");
+
+  $Manager->Execute("CREATE TABLE IF NOT EXISTS `OSArchitecture` (
+      `Id` int(11) NOT NULL AUTO_INCREMENT,
+      `Name` varchar(255) NOT NULL,
+      PRIMARY KEY (`Id`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
+
+  $Manager->Execute("INSERT INTO `OSArchitecture` (`Id`, `Name`) VALUES
+  (1, 'i386'),
+  (2, 'x86_64,amd64');");
+
+  $Manager->Execute("CREATE TABLE IF NOT EXISTS `OSTemplate` (
+      `Id` int(11) NOT NULL AUTO_INCREMENT,
+      `Name` varchar(255) NOT NULL,
+      `Type` int(11) NOT NULL,
+      `Size` bigint(11) NOT NULL,
+      `OSVersion` int(11) NOT NULL,
+      `Public` int(11) NOT NULL,
+      `Architecture` int(11) NOT NULL,
+      PRIMARY KEY (`Id`),
+      KEY `OSVersion` (`OSVersion`),
+      KEY `Architecture` (`Architecture`),
+      KEY `Type` (`Type`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
+
+  $Manager->Execute("INSERT INTO `OSTemplate` (`Id`, `Name`, `Type`, `Size`, `OSVersion`, `Public`, `Architecture`) VALUES
+  (2, 'Ubuntu 15.10 i386', 1, 200000000, 1, 1, 1);");
+
+  $Manager->Execute("CREATE TABLE IF NOT EXISTS `OSVersion` (
+      `Id` int(11) NOT NULL AUTO_INCREMENT,
+      `Name` varchar(255) NOT NULL,
+      `OS` int(11) NOT NULL,
+      `Version` varchar(255) NOT NULL,
+      `ReleaseDate` date NOT NULL,
+      `CodeName` varchar(255) NOT NULL,
+      `EndOfLife` date DEFAULT NULL,
+      PRIMARY KEY (`Id`),
+      KEY `OS` (`OS`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
+
+  $Manager->Execute("INSERT INTO `OSVersion` (`Id`, `Name`, `OS`, `Version`, `ReleaseDate`, `CodeName`, `EndOfLife`) VALUES
+  (1, 'Ubuntu 15.10', 3, '15.10', '2015-10-23', 'Wily Werewolf', NULL),
+  (2, 'Ubuntu 14.04', 3, '14.04', '2014-04-17', 'Trusty Tahr', NULL);");
+
+  $Manager->Execute("CREATE TABLE IF NOT EXISTS `OSVirtType` (
+      `Id` int(11) NOT NULL AUTO_INCREMENT,
+      `Name` varchar(255) NOT NULL,
+      PRIMARY KEY (`Id`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
+
+  $Manager->Execute("INSERT INTO `OSVirtType` (`Id`, `Name`) VALUES
+  (1, 'LXC'),
+  (2, 'OpenVZ'),
+  (3, 'KVM'),
+  (4, 'Xen'),
+  (5, 'Hardware');");
+
+  $Manager->Execute("CREATE TABLE IF NOT EXISTS `VPS` (
+      `Id` int(11) NOT NULL AUTO_INCREMENT,
+      `Name` varchar(255) NOT NULL,
+      `NetworkDevice` int(11) NOT NULL,
+      `OSTemplate` int(11) NOT NULL,
+      `Limits` int(11) NOT NULL,
+      `AutoStart` int(11) NOT NULL,
+      PRIMARY KEY (`Id`),
+      KEY `NetworkDevice` (`NetworkDevice`),
+      KEY `OSTemplate` (`OSTemplate`),
+      KEY `Limit` (`Limits`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
+
+  $Manager->Execute("CREATE TABLE IF NOT EXISTS `VPSLimit` (
+      `Id` int(11) NOT NULL AUTO_INCREMENT,
+      `Name` varchar(255) NOT NULL,
+      `Memory` bigint(11) NOT NULL,
+      `Storage` bigint(11) NOT NULL,
+      `NetworkDown` int(11) NOT NULL,
+      `NetworkUp` int(11) NOT NULL,
+      `CPUSockets` int(11) NOT NULL,
+      PRIMARY KEY (`Id`)
+  ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
+
+  $Manager->Execute("ALTER TABLE `OS`
+  ADD CONSTRAINT `OS_ibfk_1` FOREIGN KEY (`Subject`) REFERENCES `Subject` (`Id`);");
+
+  $Manager->Execute("ALTER TABLE `OSTemplate`
+  ADD CONSTRAINT `OSTemplate_ibfk_1` FOREIGN KEY (`OSVersion`) REFERENCES `OSVersion` (`Id`),
+  ADD CONSTRAINT `OSTemplate_ibfk_2` FOREIGN KEY (`Architecture`) REFERENCES `OSArchitecture` (`Id`),
+  ADD CONSTRAINT `OSTemplate_ibfk_3` FOREIGN KEY (`Type`) REFERENCES `OSVirtType` (`Id`);");
+
+  $Manager->Execute("ALTER TABLE `OSVersion`
+  ADD CONSTRAINT `OSVersion_ibfk_1` FOREIGN KEY (`OS`) REFERENCES `OS` (`Id`);");
+
+  $Manager->Execute("ALTER TABLE `VPS`
+  ADD CONSTRAINT `VPS_ibfk_1` FOREIGN KEY (`NetworkDevice`) REFERENCES `NetworkDevice` (`Id`),
+  ADD CONSTRAINT `VPS_ibfk_2` FOREIGN KEY (`OSTemplate`) REFERENCES `OSTemplate` (`Id`),
+  ADD CONSTRAINT `VPS_ibfk_3` FOREIGN KEY (`Limits`) REFERENCES `VPSLimit` (`Id`);");
 }
 
@@ -1754 +1869 @@
       763 => array('Revision' => 765, 'Function' => 'UpdateTo765'),
       765 => array('Revision' => 768, 'Function' => 'UpdateTo768'),
+      768 => array('Revision' => 770, 'Function' => 'UpdateTo770'),
     ));
   }