[chronojump-server] Updated tables

[Xavier de Blas <xaviblas src gnome org>]

commit b5e05d392de7a85a31fccf018df9dfd749f91bd0
Author: Xavier de Blas <xaviblas gmail com>
Date:   Thu Jun 8 12:42:07 2017 -0300

    Updated tables

 tables.txt |   11 +++++++++--
 1 files changed, 9 insertions(+), 2 deletions(-)
---
diff --git a/tables.txt b/tables.txt
index 74bb9e0..fc59518 100644
--- a/tables.txt
+++ b/tables.txt
@@ -16,7 +16,14 @@ CREATE TABLE rfid(dt TIMESTAMP DEFAULT CURRENT_TIMESTAMP, personId INT NOT NULL,
 #rfid can be six numbers long (of three digits each), separated by commas
 CREATE TABLE person(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name CHAR(30), weight FLOAT, height FLOAT, 
rfid CHAR(23), imageName CHAR(50));
 
-CREATE TABLE task(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, dt TIMESTAMP DEFAULT CURRENT_TIMESTAMP, 
personId INT, comment CHAR(200), bool done default 0);
+CREATE TABLE task(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, dt TIMESTAMP DEFAULT CURRENT_TIMESTAMP, 
personId INT, stationID INT, exerciseID INT, load FLOAT, laterality CHAR(3), comment CHAR(200), bool done 
default 0);
+#laterality can have these values:
+'RL' is done by both arms or legs at the same tim
+'R,L' is done first by right and later left (will be two sets on client)
+'R' only right
+'L' only left
+
+CREATE TABLE exercise(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name CHAR(40), percentBodyWeight INT, 
ressistance CHAR(30), description CHAR(200), speed1RM FLOAT)
 
 #CREATE TABLE image(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, personId INT NOT NULL, image BLOB, FOREIGN 
KEY (personId) REFERENCES person(id));
 
@@ -44,4 +51,4 @@ INSERT INTO results VALUES(NULL, NULL, 1, 2, "press de banca", 45.2 , 9,
                "");
 #INSERT INTO results VALUES(NULL, NULL, 1, 1, 2, "sprint", NULL, NULL, "5 segons");
 
-INSERT INTO task VALUES(NULL, NULL, 1, "Mig squat amb 45 Kg, 3 series de 8 repeticions a 1,1 m/s. 
Desplaçaments laterals amb la inercial de 800 W");
+#INSERT INTO task VALUES(NULL, NULL, 1, "Mig squat amb 45 Kg, 3 series de 8 repeticions a 1,1 m/s. 
Desplaçaments laterals amb la inercial de 800 W");