Changeset 565 for trunk/admin/Updates.php

Timestamp:

Sep 1, 2013, 11:37:27 PM (11 years ago)

Author:

chronos

Message:

• Upraveno: Třída Module nahrazena třídami Model, View, Controller.
• Přidáno: Modul Wiki.

File:

• trunk/admin/Updates.php (modified) (2 diffs)

trunk/admin/Updates.php

@@ -343 +343 @@
 }
 
+function UpdateTo565($Manager)
+{  
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `WikiPage` (
+    `Id` int(11) NOT NULL AUTO_INCREMENT,
+    `Name` varchar(255) NOT NULL,
+    `NormalizedName` varchar(255) NOT NULL,
+    `VisibleInMenu` int(11) NOT NULL,
+    PRIMARY KEY (`Id`),
+    UNIQUE KEY `Name` (`Name`),
+    KEY `VisibleInMenu` (`VisibleInMenu`)
+    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `WikiPageContent` (
+    `Id` int(11) NOT NULL AUTO_INCREMENT,
+    `Page` int(11) NOT NULL,
+    `Time` datetime NOT NULL,
+    `Content` text NOT NULL,
+    `User` int(11) NOT NULL,
+    PRIMARY KEY (`Id`),
+    KEY `User` (`User`),
+        KEY `Page` (`Page`)
+    ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+    $Manager->Execute('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`);');
+}
 
 $Updates = array(
@@ -363 +388 @@
   549 => array('Revision' => 550, 'Function' => 'UpdateTo550'),
   550 => array('Revision' => 551, 'Function' => 'UpdateTo551'),
+  551 => array('Revision' => 565, 'Function' => 'UpdateTo565'),
 );