summaryrefslogtreecommitdiffstats
path: root/sql/update_permissions_12.sql
diff options
context:
space:
mode:
authorAlexander Sulfrian <alexander@sulfrian.net>2011-12-07 19:06:52 +0100
committerAlexander Sulfrian <alexander@sulfrian.net>2011-12-07 19:06:52 +0100
commit39081f84a402aebb52d98a43e4675c90135cea9b (patch)
tree9c188a70367774c721b745818b74d059f9ce119c /sql/update_permissions_12.sql
parent2397764dd0e5efa2b613fd22f6bf9c183d07160b (diff)
downloadts3db_postgres-39081f84a402aebb52d98a43e4675c90135cea9b.tar.gz
ts3db_postgres-39081f84a402aebb52d98a43e4675c90135cea9b.tar.xz
ts3db_postgres-39081f84a402aebb52d98a43e4675c90135cea9b.zip
added sql files
Diffstat (limited to 'sql/update_permissions_12.sql')
-rw-r--r--sql/update_permissions_12.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/update_permissions_12.sql b/sql/update_permissions_12.sql
new file mode 100644
index 0000000..9ddea98
--- /dev/null
+++ b/sql/update_permissions_12.sql
@@ -0,0 +1,9 @@
+update perm_server_group set perm_value = 20 where perm_id = 'i_group_auto_update_type' and perm_value = 0;
+update perm_server_group set perm_value = 50 where perm_id = 'i_group_auto_update_type' and perm_value = 1;
+update perm_server_group set perm_value = 45 where perm_id = 'i_group_auto_update_type' and perm_value = 2;
+update perm_server_group set perm_value = 30 where perm_id = 'i_group_auto_update_type' and perm_value = 3;
+update perm_server_group set perm_value = 15 where perm_id = 'i_group_auto_update_type' and perm_value = 4;
+update perm_channel_groups set perm_value = 40 where perm_id = 'i_group_auto_update_type' and perm_value = 5;
+update perm_channel_groups set perm_value = 35 where perm_id = 'i_group_auto_update_type' and perm_value = 6;
+update perm_channel_groups set perm_value = 25 where perm_id = 'i_group_auto_update_type' and perm_value = 7;
+update perm_channel_groups set perm_value = 10 where perm_id = 'i_group_auto_update_type' and perm_value = 8; \ No newline at end of file