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,