From 39081f84a402aebb52d98a43e4675c90135cea9b Mon Sep 17 00:00:00 2001
From: Alexander Sulfrian <alexander@sulfrian.net>
Date: Wed, 7 Dec 2011 19:06:52 +0100
Subject: added sql files

---
 sql/update_12.sql | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 sql/update_12.sql

(limited to 'sql/update_12.sql')

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);
-- 
cgit v1.2.3

