From 56234d02ad16ace826a42530d1e428a69368f60d Mon Sep 17 00:00:00 2001
From: Alexander Sulfrian <alexander@sulfrian.net>
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

