Changeset 745

Timestamp:

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

Author:

chronos

Message:

• Added: More appmodule install/uninstallation.

Location:

trunk/Modules

Files:

• Map/Map.php (modified) (1 diff)
• Subject/Subject.php (modified) (2 diffs)
• Wiki/Wiki.php (modified) (4 diffs)

trunk/Modules/Map/Map.php

@@ -231 +231 @@
       'Filter' => '1',
     ));
-
-  }
-}
+  }
+
+  function DoInstall()
+  {
+    $this->System->Database->query("CREATE TABLE IF NOT EXISTS `MapPosition` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Name` varchar(255) NOT NULL,
+  `Pos` varchar(255) NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;");
+  }
+
+  function DoUninstall()
+  {
+    $this->Database->query('DROP TABLE `MapPosition`');
+  }
+}

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`');
+  }
 }

trunk/Modules/Wiki/Wiki.php

@@ -18 +18 @@
   {
     parent::Install();
-    $this->Database->Query("'CREATE TABLE IF NOT EXISTS `WikiPage` (
+    $this->Database->Query('CREATE TABLE IF NOT EXISTS `WikiPage` (
     `Id` int(11) NOT NULL AUTO_INCREMENT,
     `Name` varchar(255) NOT NULL,
@@ -26 +26 @@
     UNIQUE KEY `Name` (`Name`),
     KEY `VisibleInMenu` (`VisibleInMenu`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-    CREATE TABLE IF NOT EXISTS `WikiPageContent` (
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1');
+    $this->Database->Query('CREATE TABLE IF NOT EXISTS `WikiPageContent` (
     `Id` int(11) NOT NULL AUTO_INCREMENT,
     `Page` int(11) NOT NULL,
@@ -36 +36 @@
     KEY `User` (`User`),
     KEY `Page` (`Page`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-    ALTER TABLE `WikiPageContent`
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1');
+    $this->Database->Query('ALTER TABLE `WikiPageContent`
 ADD CONSTRAINT `WikiPageContent_ibfk_2` FOREIGN KEY (`Page`) REFERENCES `WikiPage` (`Id`),
-ADD CONSTRAINT `WikiPageContent_ibfk_1` FOREIGN KEY (`User`) REFERENCES `User` (`ID`);'");
+ADD CONSTRAINT `WikiPageContent_ibfk_1` FOREIGN KEY (`User`) REFERENCES `User` (`ID`)');
   }
 
   function DoUnInstall()
   {
-    $this->Database->query("DELETE TABLE `WikiPageContent`; '.
-      'DELETE TABLE `WikiPage`;");
-    parent::UnInstall();
+    $this->Database->query('DELETE TABLE `WikiPageContent`');
+    $this->Database->query('DELETE TABLE `WikiPage`;');
   }
 
@@ -65 +64 @@
       $this->System->RegisterPage($DbRow['NormalizedName'], 'PageWiki');
       $this->System->RegisterMenuItem(array(
-          'Title' => $DbRow['Name'],
-          'Hint' => '',
-          'Link' => $this->System->Link('/'.$DbRow['NormalizedName'].'/'),
-          'Permission' => LICENCE_ANONYMOUS,
-          'Icon' => '',
+        'Title' => $DbRow['Name'],
+        'Hint' => '',
+        'Link' => $this->System->Link('/'.$DbRow['NormalizedName'].'/'),
+        'Permission' => LICENCE_ANONYMOUS,
+        'Icon' => '',
       ), 2);
     }