Changeset 574 for trunk/admin/UpdateTrace.php

Timestamp:

Aug 27, 2013, 11:02:00 PM (11 years ago)

Author:

chronos

Message:

• Added: Missing SQL update for Wiki module.

File:

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

trunk/admin/UpdateTrace.php

@@ -2572 +2572 @@
 }
 
+function UpdateTo574($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(
         498 => array('Revision' => 506, 'Function' => 'UpdateTo506'),
@@ -2580 +2609 @@
         539 => array('Revision' => 543, 'Function' => 'UpdateTo543'),
         543 => array('Revision' => 567, 'Function' => 'UpdateTo567'),
+        567 => array('Revision' => 574, 'Function' => 'UpdateTo574'),
 );