summaryrefslogblamecommitdiffstats
path: root/sql/update_12.sql
blob: 17e553ed512c683dd4f13ad1f35a7869f2f8d842 (plain) (tree)
1
2
3
4
5
6
7
8
9
10
11
12
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);