summaryrefslogtreecommitdiffstats
path: root/sql/perm_rename.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--sql/perm_rename.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/perm_rename.sql b/sql/perm_rename.sql
new file mode 100644
index 0000000..6d0010a
--- /dev/null
+++ b/sql/perm_rename.sql
@@ -0,0 +1,5 @@
+update perm_channel set perm_id = :new_perm_name: where perm_id = :old_perm_name:;
+update perm_channel_clients set perm_id = :new_perm_name: where perm_id = :old_perm_name:;
+update perm_channel_groups set perm_id = :new_perm_name: where perm_id = :old_perm_name:;
+update perm_client set perm_id = :new_perm_name: where perm_id = :old_perm_name:;
+update perm_server_group set perm_id = :new_perm_name: where perm_id = :old_perm_name:; \ No newline at end of file