commit 59ba3435708ad5277e7e2e7c0e20063f7d050548
author avm99963 <me@avm99963.com> Mon Sep 28 19:03:29 2020 +0200
committer avm99963 <me@avm99963.com> Mon Sep 28 19:03:29 2020 +0200
tree b05e5b19e7edd2ab47dc6f6b33960d343446a638
parent 282af722a37da7e4843bc6c68ca18b34cb57c8da

Canvi de date a timestamp a la taula classes

Ara les columnes 'begins' i 'ends' contindran enters en comptes de
dates, per solventar un problema existent amb la diferència de zones
horàries. Els enters seran UNIX timestamps.

Change-Id: I460b9b33447e21f05349107d68eb61bd36304780

utils/db_structure.sql

diff --git a/utils/db_structure.sql b/utils/db_structure.sql
index b22a6dd..64837a6 100644
--- a/utils/db_structure.sql
+++ b/utils/db_structure.sql
@@ -29,9 +29,9 @@
   calendar_name VARCHAR(100) NOT NULL,
   INDEX(calendar_name),
   room VARCHAR(10) NOT NULL,
-  begins DATETIME NOT NULL,
+  begins INT NOT NULL, -- UNIX timestamp de l'hora d'inici
   INDEX(begins),
-  ends DATETIME NOT NULL,
+  ends INT NOT NULL, -- UNIX timestamp de l'hora de fi
   INDEX(ends)
 );