summaryrefslogtreecommitdiffstats
path: root/sql/update_14.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_14.sql
parent2397764dd0e5efa2b613fd22f6bf9c183d07160b (diff)
downloadts3db_postgres-39081f84a402aebb52d98a43e4675c90135cea9b.tar.gz
ts3db_postgres-39081f84a402aebb52d98a43e4675c90135cea9b.tar.xz
ts3db_postgres-39081f84a402aebb52d98a43e4675c90135cea9b.zip
added sql files
Diffstat (limited to '')
-rw-r--r--sql/update_14.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/update_14.sql b/sql/update_14.sql
new file mode 100644
index 0000000..67a6159
--- /dev/null
+++ b/sql/update_14.sql
@@ -0,0 +1,5 @@
+CREATE INDEX index_group_server_to_client_id1 ON group_server_to_client (id1);
+CREATE INDEX index_group_channel_to_client_id1 ON group_channel_to_client (id1);
+CREATE INDEX index_group_channel_to_client_id2 ON group_channel_to_client (id2);
+CREATE INDEX index_clients_lastconnectedserverid ON clients (client_lastconnected, server_id);
+CREATE INDEX index_log_serverid_logid ON log (server_id, log_id);