Changeset 695 for trunk/admin/UpdateTrace.php

Timestamp:

Jan 3, 2014, 11:09:37 AM (11 years ago)

Author:

maron

Message:

• Added: selection groupitems in export

File:

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

trunk/admin/UpdateTrace.php

@@ -2684 +2684 @@
 }
 
+function UpdateTo695($Manager)
+{
+        $Manager->Execute('CREATE TABLE IF NOT EXISTS `ExportGroupItem` (`Id` int(11) NOT NULL AUTO_INCREMENT,'.
+  '`Export` int(11) NOT NULL,`GroupItem` int(11) NOT NULL, PRIMARY KEY (`Id`), KEY `Export` (`Export`),'.
+  ' KEY `GroupItem` (`GroupItem`)) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;');   
+        $Manager->Execute('ALTER TABLE `ExportGroupItem`'.
+  'ADD CONSTRAINT `ExportGroupItem_ibfk_1` FOREIGN KEY (`Export`) REFERENCES `Export` (`Id`),'.
+  'ADD CONSTRAINT `ExportGroupItem_ibfk_2` FOREIGN KEY (`GroupItem`) REFERENCES `GroupItem` (`Id`);');   
+}
 
 $Updates = array(
@@ -2703 +2712 @@
         646 => array('Revision' => 666 , 'Function' => 'UpdateTo666'),
         666 => array('Revision' => 678 , 'Function' => 'UpdateTo678'),
+        678 => array('Revision' => 695 , 'Function' => 'UpdateTo695'),
 );