summaryrefslogtreecommitdiffstats
path: root/sql/update_12.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/update_12.sql')
-rw-r--r--sql/update_12.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/update_12.sql b/sql/update_12.sql
new file mode 100644
index 0000000..17e553e
--- /dev/null
+++ b/sql/update_12.sql
@@ -0,0 +1,13 @@
+CREATE TABLE custom_fields (
+ server_id integer unsigned,
+ client_id integer unsigned,
+ ident varchar(100) NOT NULL,
+ value varchar(255)
+);
+CREATE INDEX index_custom_fields_serverid ON custom_fields (server_id);
+CREATE INDEX index_custom_fields_client_id ON custom_fields (client_id);
+CREATE INDEX index_custom_fields_ident ON custom_fields (ident);
+
+ALTER TABLE tokens ADD COLUMN token_created integer unsigned;
+ALTER TABLE tokens ADD COLUMN token_description varchar(255);
+ALTER TABLE tokens ADD COLUMN token_customset varchar(255);