diff options
| author | Alexander Sulfrian <alexander@sulfrian.net> | 2012-05-16 04:07:38 +0200 |
|---|---|---|
| committer | Alexander Sulfrian <alexander@sulfrian.net> | 2012-05-16 04:07:38 +0200 |
| commit | 56234d02ad16ace826a42530d1e428a69368f60d (patch) | |
| tree | 4c83f2b66e08a200e1bb4de4ac6f85656ea9280a /sql/create_pg/create_tables.sql | |
| parent | 0787aec18d9b879791c5d6f9d75209d242aba708 (diff) | |
| download | ts3db_postgres-56234d02ad16ace826a42530d1e428a69368f60d.tar.gz ts3db_postgres-56234d02ad16ace826a42530d1e428a69368f60d.tar.xz ts3db_postgres-56234d02ad16ace826a42530d1e428a69368f60d.zip | |
sql: update to version 19 (ts3-v3.0.5)
Diffstat (limited to '')
| -rw-r--r-- | sql/create_pg/create_tables.sql | 18 |
1 files changed, 9 insertions, 9 deletions
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, |