Changeset 401 for branches/Modular/Common/Module.php

Timestamp:

Mar 30, 2012, 2:02:51 PM (12 years ago)

Author:

chronos

Message:

• Upraveno: Instalace a odinstalace je nyní spravována samostatným skriptem install.php.
• Upraveno: Částečné řešení odstranění cizích klíčů v průběhu odinstalace před odstraněním samotných tabulek.

File:

• branches/Modular/Common/Module.php (modified) (5 diffs)

branches/Modular/Common/Module.php

@@ -120 +120 @@
   {
     //DebugLog('Installing modular system core...');
+    $this->Database->query('CREATE TABLE IF NOT EXISTS `SystemVersion` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `Version` varchar(255) COLLATE utf8_czech_ci NOT NULL,
+  `Description` datetime NOT NULL,
+  PRIMARY KEY (`Id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1;');
     $this->Database->query('CREATE TABLE IF NOT EXISTS `SystemModule` (
   `Id` int(11) NOT NULL AUTO_INCREMENT,
@@ -140 +146 @@
   UNIQUE (`Module` , `DependencyModule`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1;');
-    $this->Database->query('ALTER TABLE `SystemModuleDependency` ADD FOREIGN KEY ( `Module` ) REFERENCES `SystemModule` (`Id`)');
-    $this->Database->query('ALTER TABLE `SystemModuleDependency` ADD FOREIGN KEY ( `DependencyModule` ) REFERENCES `SystemModule` (`Id`)');
+    $this->Database->query('ALTER TABLE `SystemModuleDependency` ADD CONSTRAINT `SystemModuleDependency_ibfk_1` FOREIGN KEY ( `Module` ) REFERENCES `SystemModule` (`Id`)');
+    $this->Database->query('ALTER TABLE `SystemModuleDependency` ADD CONSTRAINT `SystemModuleDependency_ibfk_2` FOREIGN KEY ( `DependencyModule` ) REFERENCES `SystemModule` (`Id`)');
     
     $this->Database->query('CREATE TABLE IF NOT EXISTS `SystemModel` (
@@ -150 +156 @@
   PRIMARY KEY (`Id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1;');
-    $this->Database->query('ALTER TABLE `SystemModel` ADD FOREIGN KEY ( `Module` ) REFERENCES `SystemModule` (`Id`)');
+    $this->Database->query('ALTER TABLE `SystemModel` ADD CONSTRAINT `SystemModel_ibfk_1` FOREIGN KEY ( `Module` ) REFERENCES `SystemModule` (`Id`)');
     
     $this->Database->query('CREATE TABLE IF NOT EXISTS `SystemModelProperty` (
@@ -160 +166 @@
   PRIMARY KEY (`Id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1;');
-    $this->Database->query('ALTER TABLE `SystemModelProperty` ADD FOREIGN KEY ( `Model` ) REFERENCES `SystemModel` (`Id`)');
+    $this->Database->query('ALTER TABLE `SystemModelProperty` ADD CONSTRAINT `SystemModelProperty_ibfk_1` FOREIGN KEY ( `Model` ) REFERENCES `SystemModel` (`Id`)');
     
     $this->ReloadList();
@@ -178 +184 @@
     
     // Delete tables with reverse order
+    $this->Database->query('ALTER TABLE `SystemModelProperty` DROP FOREIGN KEY `SystemModelProperty_ibfk_1`');
     $this->Database->query('DROP TABLE IF EXISTS `SystemModelProperty`');
+    $this->Database->query('ALTER TABLE `SystemModel` DROP FOREIGN KEY `SystemModel_ibfk_1`');
     $this->Database->query('DROP TABLE IF EXISTS `SystemModel`');
+    $this->Database->query('ALTER TABLE `SystemModuleDependency` DROP FOREIGN KEY `SystemModuleDependency_ibfk_1`');
+    $this->Database->query('ALTER TABLE `SystemModuleDependency` DROP FOREIGN KEY `SystemModuleDependency_ibfk_2`');
     $this->Database->query('DROP TABLE IF EXISTS `SystemModuleDependency`');
     $this->Database->query('DROP TABLE IF EXISTS `SystemModule`');
+    $this->Database->query('DROP TABLE IF EXISTS `SystemVersion`');
+  }
+  
+  function IsInstalled()
+  {
+    $DbResult = $this->Database->query('SELECT table_name FROM information_schema.tables
+WHERE table_schema = "'.$this->Database->Database.'" AND table_name = "SystemVersion";');    
+    if($DbResult->num_rows > 0) return(true); 
+      else return(false);
   }