diff options
Diffstat (limited to 'sql/create_pg')
-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, |