Changeset 934 for trunk/Application

Timestamp:

May 11, 2022, 10:07:18 PM (2 years ago)

Author:

chronos

Message:

• Added: System names for Permission groups.

Location:

trunk/Application

Files:

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

trunk/Application/UpdateTrace.php

@@ -2207 +2207 @@
         "VALUES (NULL , 'Fyzické adresy', ".$DbRow['Id'].", '".$ActionId."', '1');");
   }
+}
+
+function UpdateTo933(UpdateManager $Manager): void
+{
+  $Manager->Execute('ALTER TABLE `PermissionGroup` ADD `SysName` VARCHAR(255) NULL DEFAULT "" AFTER `Description`;');
+  $Manager->Execute('UPDATE `PermissionGroup` SET `SysName`="admins" WHERE `Description`="Systémoví administrátoři"');
+  $Manager->Execute('UPDATE `PermissionGroup` SET `SysName`="network-admins" WHERE `Description`="Správci sítě"');
+  $Manager->Execute('UPDATE `PermissionGroup` SET `SysName`="registered-users" WHERE `Description`="Registrovaní uživatelé"');
+  $Manager->Execute('UPDATE `PermissionGroup` SET `SysName`="other-users" WHERE `Description`="Ostatní"');
+  $Manager->Execute('UPDATE `PermissionGroup` SET `SysName`="customers" WHERE `Description`="Zákazníci"');
 }
 
@@ -2317 +2327 @@
       907 => array('Revision' => 911, 'Function' => 'UpdateTo911'),
       911 => array('Revision' => 921, 'Function' => 'UpdateTo921'),
+      921 => array('Revision' => 933, 'Function' => 'UpdateTo933'),
     );
   }

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 922; // Subversion revision
-$DatabaseRevision = 921; // SQL structure revision
-$ReleaseTime = strtotime('2022-02-28');
+$Revision = 933; // Subversion revision
+$DatabaseRevision = 933; // SQL structure revision
+$ReleaseTime = strtotime('2022-05-11');