Changeset 891 for trunk/Packages/Common/Setup.php

Timestamp:

Dec 30, 2020, 11:52:07 PM (3 years ago)

Author:

chronos

Message:

• Added: More modules models installation.

File:

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

trunk/Packages/Common/Setup.php

@@ -412 +412 @@
 
     $this->Database->query('CREATE TABLE IF NOT EXISTS `'.$this->UpdateManager->VersionTable.'` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Revision` int(11) NOT NULL,
-  PRIMARY KEY (`Id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+      `Id` int(11) NOT NULL AUTO_INCREMENT,
+      `Revision` int(11) NOT NULL,
+      PRIMARY KEY (`Id`)
+    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
     $this->Database->query("INSERT INTO `".$this->UpdateManager->VersionTable."` (`Id`, `Revision`) VALUES
       (1, ".$DatabaseRevision.");");
     $this->Database->query("CREATE TABLE IF NOT EXISTS `Module` (
-  `Id` int(11) NOT NULL AUTO_INCREMENT,
-  `Name` varchar(255) NOT NULL,
-  `Title` varchar(255) NOT NULL,
-  PRIMARY KEY (`Id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
+      `Id` int(11) NOT NULL AUTO_INCREMENT,
+      `Name` varchar(255) NOT NULL,
+      `Title` varchar(255) NOT NULL,
+      PRIMARY KEY (`Id`)
+    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
+    $this->Database->query("CREATE TABLE IF NOT EXISTS `ModuleModel` (
+      `Id` int(11) NOT NULL AUTO_INCREMENT,
+      `Name` varchar(255) NOT NULL,
+      `Module` int(11) NOT NULL,
+      PRIMARY KEY (`Id`)
+    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
+    $this->Database->query('ALTER TABLE `ModuleModel`
+      ADD CONSTRAINT `ModuleModel_ibfk_1` FOREIGN KEY (`Module`) REFERENCES `Module` (`Id`);');
+    $this->Database->query("CREATE TABLE IF NOT EXISTS `ModuleModelProperty` (
+      `Id` int(11) NOT NULL AUTO_INCREMENT,
+      `Name` varchar(255) NOT NULL,
+      `Model` int(11) NOT NULL,
+      `Type` int(11) NOT NULL,
+      `Nullable` tinyint(1) NOT NULL,
+      PRIMARY KEY (`Id`)
+    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;");
+    $this->Database->query('ALTER TABLE `ModuleModelProperty`
+      ADD CONSTRAINT `ModuleModelProperty_ibfk_1` FOREIGN KEY (`Model`) REFERENCES `ModuleModel` (`Id`);');
   }
 
@@ -429 +447 @@
   {
     $this->System->ModuleManager->UninstallAll();
+    $this->Database->query('DROP TABLE `ModuleModelProperty`');
+    $this->Database->query('DROP TABLE `ModuleModel`');
     $this->Database->query('DROP TABLE `Module`');
     $this->Database->query('DROP TABLE `'.$this->UpdateManager->VersionTable.'`');