Changeset 934 for trunk/Application/UpdateTrace.php

Timestamp:

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

Author:

chronos

Message:

• Added: System names for Permission groups.

File:

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

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