From 56234d02ad16ace826a42530d1e428a69368f60d Mon Sep 17 00:00:00 2001 From: Alexander Sulfrian Date: Wed, 16 May 2012 04:07:38 +0200 Subject: sql: update to version 19 (ts3-v3.0.5) --- sql/create_pg/create_tables.sql | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) (limited to 'sql/create_pg/create_tables.sql') diff --git a/sql/create_pg/create_tables.sql b/sql/create_pg/create_tables.sql index 9923c67..df69d38 100644 --- a/sql/create_pg/create_tables.sql +++ b/sql/create_pg/create_tables.sql @@ -34,10 +34,10 @@ CREATE TABLE clients ( client_login_password text, client_lastconnected bigint, client_totalconnections bigint default 0, - client_month_upload bigint default 0, - client_month_download bigint default 0, - client_total_upload bigint default 0, - client_total_download bigint default 0, + client_month_upload NUMERIC(20) default 0, + client_month_download NUMERIC(20) default 0, + client_total_upload NUMERIC(20) default 0, + client_total_download NUMERIC(20) default 0, client_lastip text ); CREATE INDEX index_clients_id ON clients (client_id); @@ -159,14 +159,14 @@ CREATE TABLE servers ( server_port bigint, server_autostart bigint, server_machine_id text, - server_month_upload bigint Default 0, - server_month_download bigint Default 0, - server_total_upload bigint Default 0, - server_total_download bigint Default 0 + server_month_upload NUMERIC(20) Default 0, + server_month_download NUMERIC(20) Default 0, + server_total_upload NUMERIC(20) Default 0, + server_total_download NUMERIC(20) Default 0 ); CREATE INDEX index_servers_serverid ON servers (server_id); CREATE INDEX index_servers_port ON servers (server_port); - + CREATE TABLE tokens ( server_id bigint, token_key text NOT NULL, -- cgit v1.2.3