Changeset 849 for trunk/Application

Timestamp:

Jan 17, 2016, 6:19:06 PM (9 years ago)

Author:

chronos

Message:

• Added: Prepared database tables for import module. Every executed import should be recorded and should be allowed to remove it.
• Modified: More translatable strings.

Location:

trunk/Application

Files:

• UpdateTrace.php (modified) (2 diffs)
• Version.php (modified) (1 diff)

trunk/Application/UpdateTrace.php

@@ -2900 +2900 @@
 }
 
+function UpdateTo849($Manager)
+{
+  // Group item names
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `Import` (
+    `Id` int(11) NOT NULL AUTO_INCREMENT,
+    `ClientVersion` int(11) NOT NULL,
+    `Time` datetime NOT NULL,
+    `User` int(11) NOT NULL,
+    PRIMARY KEY (`Id`),
+    KEY (`User`),
+    KEY (`ClientVersion`)
+    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
+  $Manager->Execute('ALTER TABLE `Import` ADD FOREIGN KEY (`ClientVersion`) REFERENCES `ClientVersion`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
+  $Manager->Execute('ALTER TABLE `Import` ADD FOREIGN KEY (`User`) REFERENCES `User`(`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `ImportGroup` (
+    `Id` int(11) NOT NULL AUTO_INCREMENT,
+    `Import` int(11) NOT NULL,
+    `Group` int(11) NOT NULL,
+    PRIMARY KEY (`Id`),
+    KEY (`Import`),
+    KEY (`Group`)
+    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
+  $Manager->Execute('ALTER TABLE `ImportGroup` ADD FOREIGN KEY (`Import`) REFERENCES `Import`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
+  $Manager->Execute('ALTER TABLE `ImportGroup` ADD FOREIGN KEY (`Group`) REFERENCES `Group`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
+}
+
+
 $Updates = array(
   498 => array('Revision' => 506, 'Function' => 'UpdateTo506'),
@@ -2930 +2957 @@
   811 => array('Revision' => 846, 'Function' => 'UpdateTo846'),
   846 => array('Revision' => 848, 'Function' => 'UpdateTo848'),
+  848 => array('Revision' => 849, 'Function' => 'UpdateTo849'),
 );

trunk/Application/Version.php

@@ -6 +6 @@
 // and system will need database update.
 
-$Revision = 848; // Subversion revision
-$DatabaseRevision = 848; // Database structure revision
+$Revision = 849; // Subversion revision
+$DatabaseRevision = 849; // Database structure revision
 $ReleaseTime = '2016-01-17';