[chronojump-server] Updated howtos

[Xavier de Blas <xaviblas src gnome org>]

commit 489051fb687b2866c76612d56bc0377ea25a9d0a
Author: Xavier de Blas <xaviblas gmail com>
Date:   Fri Feb 23 14:30:18 2018 +0100

    Updated howtos

 howto_compujump_server.txt |   33 ++++++++++++++++++++++++++++++---
 tables.txt                 |    9 +++++++++
 2 files changed, 39 insertions(+), 3 deletions(-)
---
diff --git a/howto_compujump_server.txt b/howto_compujump_server.txt
index 81f6821..f11db1f 100644
--- a/howto_compujump_server.txt
+++ b/howto_compujump_server.txt
@@ -115,9 +115,9 @@ NO: /srv/api-app/chronojump-flask$ . venv/bin/activate
 
 FLASK_APP="chronojumpserver" /srv/api-app/venv/bin/flask run --host 0.0.0.0
 
-/srv/api-app$ virtualenv venv
-/srv/api-app$ source venv/bin/activate
-pip install -e .
+/srv/api-app$ virtualenv venv #create venv
+/srv/api-app$ source venv/bin/activate  #activates (get into) venv
+pip install -e . #install stuff if requirements.txt changed
 
 copy logo_club.png to /srv/api-app/chronojumpserver/static/images
 
@@ -150,3 +150,30 @@ copy services/flask.service to /etc/systemd/system/
 # apt-get install mono-mcs
 cd /srv/api-app/chronojumpserver/rfid-csharp
 mono RFID.cs
+
+--------------------------------
+5. Update code
+--------------------------------
+
+/srv/api-app$ virtualenv venv #create venv
+/srv/api-app$ source venv/bin/activate  #activates (get into) venv
+pip install -e . #install stuff if requirements.txt changed
+
+SQL stuff recents
+-------------------
+insert into user(username, password, user_type) values ('myuser', MD5('mypass'), 'admin');
+alter table person add org_id int(11) DEFAULT null;
+alter table task add column lossBySpeed int(11) DEFAULT null;
+alter table task add column lossByPower int(11) DEFAULT null;
+ALTER TABLE STATION ADD COLUMN gym_id INT not null default 1;
+
+#potser no calen:
+alter table `group` rename group_;
+alter table resultSprint add column t1 float
+alter table resultSprint add column t2 float
+alter table resultSprint add column t3 float
+alter table resultSprint add column t4 float
+alter table resultSprint drop column times;
+
+
+
diff --git a/tables.txt b/tables.txt
index fc59518..779ddfe 100644
--- a/tables.txt
+++ b/tables.txt
@@ -52,3 +52,12 @@ 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");
+
+#Afegir lossByPower i lossBySpeed:
+alter table task add column lossBySpeed int(11) DEFAULT null;
+alter table task add column lossByPower int(11) DEFAULT null;
+
+#canvis de player i de group (revisar)
+alter table `group` rename group_;
+alter table person add org_id int(11) DEFAULT null;
+ALTER TABLE station ADD COLUMN gym_id INT not null default 1;