Changeset 745 for trunk/Modules/Subject/Subject.php

Timestamp:

Sep 10, 2015, 9:51:23 PM (9 years ago)

Author:

chronos

Message:

• Added: More appmodule install/uninstallation.

File:

• trunk/Modules/Subject/Subject.php (modified) (2 diffs)

trunk/Modules/Subject/Subject.php

@@ -11 +11 @@
     $this->License = 'GNU/GPL';
     $this->Description = 'Subject management';
-    $this->Dependencies = array('User');
+    $this->Dependencies = array('User', 'Map');
   }
 
@@ -116 +116 @@
     ));
   }
+
+  function DoInstall()
+  {
+    $this->Database->query("CREATE TABLE IF NOT EXISTS `Subject` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(64) NOT NULL DEFAULT '',
+  `AddressStreet` varchar(64) NOT NULL DEFAULT '',
+  `AddressTown` varchar(64) NOT NULL DEFAULT '',
+  `AddressPSC` int(11) NOT NULL DEFAULT '0',
+  `AddressCountry` int(11) NOT NULL,
+  `IC` varchar(32) NOT NULL,
+  `DIC` varchar(32) NOT NULL DEFAULT '',
+  `PayVAT` int(11) NOT NULL,
+  `MapPosition` int(11) DEFAULT NULL,
+  `WWW` varchar(255) NOT NULL,
+  `Note` varchar(255) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
+    $this->Database->query("CREATE TABLE IF NOT EXISTS `Contact` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Category` int(11) NOT NULL,
+  `Value` varchar(255) NOT NULL,
+  `Subject` int(11) DEFAULT NULL,
+  `User` int(11) DEFAULT NULL,
+  `Description` varchar(255) NOT NULL,
+  `Receive` tinyint(1) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
+    $this->System->Database->query("CREATE TABLE IF NOT EXISTS `ContactCategory` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
+
+    $this->Database->query("ALTER TABLE `Subject`
+ADD CONSTRAINT `Subject_ibfk_1` FOREIGN KEY (`AddressCountry`) REFERENCES `Country` (`Id`),
+ADD CONSTRAINT `Subject_ibfk_2` FOREIGN KEY (`MapPosition`) REFERENCES `MapPosition` (`Id`);");
+    $this->Database->query("ALTER TABLE `Contact`
+    ADD CONSTRAINT `Contact_ibfk_1` FOREIGN KEY (`Category`) REFERENCES `ContactCategory` (`Id`),
+    ADD CONSTRAINT `Contact_ibfk_2` FOREIGN KEY (`Subject`) REFERENCES `Subject` (`Id`),
+    ADD CONSTRAINT `Contact_ibfk_3` FOREIGN KEY (`User`) REFERENCES `User` (`Id`);");
+  }
+
+  function DoUninstall()
+  {
+    $this->Database->query('DROP TABLE `Contact`');
+    $this->Database->query('DROP TABLE `ContactCategory`');
+    $this->Database->query('DROP TABLE `Subject`');
+  }
 }