Changeset 787

Timestamp:

Jan 11, 2016, 12:08:17 AM (9 years ago)

Author:

chronos

Message:

• Fixed: Not saved SQL update trace file from previous commit.

File:

• trunk/Application/UpdateTrace.php (modified) (1 diff)

trunk/Application/UpdateTrace.php

@@ -1799 +1799 @@
   $Manager->Execute('ALTER TABLE `Member` DROP FOREIGN KEY Member_ibfk_28;');
   $Manager->Execute('ALTER TABLE `Member` DROP `BillingPeriodNext`;');
-  $Manager->Execute('ALTER TABLE `Member` ADD `Action` ENUM( "add", "modify", "remove" ) NULL');
+  /* Add table change action */
+  $Manager->Execute('ALTER TABLE `Member` ADD `ChangeAction` ENUM( "add", "modify", "remove" ) NULL');
   $Manager->Execute('ALTER TABLE `Member` ADD `ChangeTime` DATETIME NULL');
-  $Manager->Execute('ALTER TABLE `Member` ADD `ReplaceId` `ChangeReplaceId` INT(11) NULL DEFAULT NULL;');
+  $Manager->Execute('ALTER TABLE `Member` ADD `ChangeReplaceId` INT(11) NULL DEFAULT NULL;');
   $Manager->Execute('ALTER TABLE `Member` ADD FOREIGN KEY (`ChangeReplaceId`) REFERENCES `Member`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
 }