[chronojump-server] Tables changed to allow an rfid of six numbers

[Xavier de Blas <xaviblas src gnome org>]

commit 764eb9b30618f7d880c0a9fd1d766a320f366686
Author: Xavier de Blas <xaviblas gmail com>
Date:   Mon May 8 21:09:54 2017 +0200

    Tables changed to allow an rfid of six numbers

 tables.txt |    3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)
---
diff --git a/tables.txt b/tables.txt
index d398ca4..1d0eb66 100644
--- a/tables.txt
+++ b/tables.txt
@@ -7,7 +7,8 @@ CREATE TABLE machine(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name CHAR(30));
 
 CREATE TABLE rfid(dt TIMESTAMP DEFAULT CURRENT_TIMESTAMP, personID INT NOT NULL, rfid CHAR(30));
 
-CREATE TABLE person(uniqueID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name CHAR(30), weight FLOAT, rfid 
CHAR(15));
+#rfid can be six numbers long (of three digits each), separated by commas
+CREATE TABLE person(uniqueID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name CHAR(30), weight FLOAT, rfid 
CHAR(23));
 
 NO USAR: aquesta és la del client
 CREATE TABLE person(uniqueID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name CHAR(30), sex CHAR(20), dateborn 
CHAR(20), race INT, countryID INT, description CHAR(20), future1 CHAR(20), future2 CHAR(20), serverUniqueID 
INT);