Changeset 907 for trunk/Application

Timestamp:

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

Author:

chronos

Message:

• Modified: Support AddressPlace in Member.

Location:

trunk/Application

Files:

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

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'),
     );
   }

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 906; // Subversion revision
-$DatabaseRevision = 901; // SQL structure revision
-$ReleaseTime = strtotime('2021-02-19');
+$Revision = 907; // Subversion revision
+$DatabaseRevision = 907; // SQL structure revision
+$ReleaseTime = strtotime('2021-03-24');