Changeset 907 for trunk/Application/UpdateTrace.php

Timestamp:

Apr 16, 2021, 9:57:28 PM (4 years ago)

Author:

chronos

Message:

• Modified: Support AddressPlace in Member.

File:

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

trunk/Application/UpdateTrace.php

@@ -2152 +2152 @@
   $Manager->Execute("INSERT INTO `PermissionOperation` (`Id`, `Module`, `Operation`, `Item`, `ItemId`) VALUES (NULL, '4', 'DownloadById', '', '0');");
   $Manager->Execute("INSERT INTO `PermissionGroupAssignment` (`Id`, `Group`, `AssignedGroup`, `AssignedOperation`) VALUES (NULL, '4', NULL, '53');");
+}
+
+function UpdateTo907(UpdateManager $Manager): void
+{
+  $Manager->Execute('CREATE TABLE `AddressPlace` (
+  `Id` int(11) NOT NULL,
+  `Town` varchar(255) NOT NULL,
+  `Street` varchar(255) NOT NULL,
+  `HouseNumber` int(11) NOT NULL,
+  `HouseNumberType` int(11) NOT NULL,
+  `Psc` int(11) NOT NULL,
+  `RuianCode` int(11) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
+  $Manager->Execute('ALTER TABLE `AddressPlace` ADD PRIMARY KEY (`Id`);');
+  $Manager->Execute('ALTER TABLE `AddressPlace` MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;');
+  $Manager->Execute('ALTER TABLE `Member` ADD `AddressPlace` INT NULL AFTER `Subject`;');
+  $Manager->Execute('ALTER TABLE `Member` ADD KEY (`AddressPlace`);');
+  $Manager->Execute('ALTER TABLE `Member` ADD FOREIGN KEY (`AddressPlace`) REFERENCES `AddressPlace`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
 }
 
@@ -2259 +2277 @@
       882 => array('Revision' => 885, 'Function' => 'UpdateTo885'),
       885 => array('Revision' => 901, 'Function' => 'UpdateTo901'),
+      907 => array('Revision' => 907, 'Function' => 'UpdateTo907'),
     );
   }