Changeset 748 for trunk/admin/UpdateTrace.php

Timestamp:

Jan 12, 2014, 10:50:33 PM (11 years ago)

Author:

maron

Message:

• Added: Simple forum for Translators

File:

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

trunk/admin/UpdateTrace.php

@@ -2732 +2732 @@
 
 
+function UpdateTo748($Manager)
+{
+
+$Manager->Execute('CREATE TABLE IF NOT EXISTS `ForumText` (
+  `ID` int(11) NOT NULL AUTO_INCREMENT,
+  `User` int(11) DEFAULT NULL,
+  `UserName` text NOT NULL,
+  `Text` text NOT NULL,
+  `Date` datetime NOT NULL,
+  `IP` text NOT NULL,
+  `Thread` int(11) DEFAULT NULL,
+  PRIMARY KEY (`ID`),
+  KEY `date` (`Date`),
+  KEY `User` (`User`),
+  KEY `Thread` (`Thread`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+');
+
+$Manager->Execute('CREATE TABLE IF NOT EXISTS `ForumThread` (
+  `ID` int(11) NOT NULL AUTO_INCREMENT,
+  `User` int(11) DEFAULT NULL,
+  `UserName` text NOT NULL,
+  `Text` text NOT NULL,
+  `Date` datetime NOT NULL,
+  `IP` text NOT NULL,
+  PRIMARY KEY (`ID`),
+  KEY `date` (`Date`),
+  KEY `User` (`User`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+');
+
+$Manager->Execute('ALTER TABLE `ForumText`
+  ADD CONSTRAINT `ForumText_ibfk_1` FOREIGN KEY (`User`) REFERENCES `User` (`ID`);');
+$Manager->Execute('ALTER TABLE `ForumText`
+  ADD CONSTRAINT `ForumThread_ibfk_1` FOREIGN KEY (`User`) REFERENCES `User` (`ID`);');
+$Manager->Execute('ALTER TABLE `ForumText`
+  ADD CONSTRAINT `ForumText_ibfk_2` FOREIGN KEY (`Thread`) REFERENCES `ForumThread` (`ID`);');
+
+}
+
+
 $Updates = array(
         498 => array('Revision' => 506, 'Function' => 'UpdateTo506'),
@@ -2756 +2797 @@
         725 => array('Revision' => 731 , 'Function' => 'UpdateTo731'),
         731 => array('Revision' => 732 , 'Function' => 'UpdateTo732'),
+        732 => array('Revision' => 748 , 'Function' => 'UpdateTo748'),
 );