From 9c8fc9f997a42926dedffedaaead5bdd6e9fc96f Mon Sep 17 00:00:00 2001 From: Joel Kronqvist Date: Sat, 22 Jan 2022 20:54:27 +0200 Subject: Fixed bug in day mechanics for the food search Making monday first (0) instead of sunday was done twice, resulting with tuesday becoming first. --- README.md | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'README.md') diff --git a/README.md b/README.md index c593e02..4195255 100644 --- a/README.md +++ b/README.md @@ -6,6 +6,7 @@ You will need a SSL certificate if you want to use https. You need to install node.js and MySQL (+ npm install mysql2). You will need to update the server with the help of the food shift message and a tab separated list of classes (just copypaste from excel from the Kurssitarjotin) You probably want to set up cron to run some cronjobs from crontab_add.txt. +Also, some of the code depends on the github repo JoelHMikael/funcs, so go ahead and clone them. You need to provide the login info to the MySQL DB in ../dblogin.txt. Logging in as root was found problematic on Mint, but feel free to try if you want to. You should create the following tables, because the server code wont do it for you. @@ -33,3 +34,15 @@ CREATE TABLE devs ( description VARCHAR(128), contact VARCHAR(40) ); +CREATE TABLE stats ( + start DATE PRIMARY KEY, + uptime INT, + requests INT, + requests_per_day INT +); +CREATE TABLE exams ( + start DATE, + end DATE, + message VARCHAR(256), + PRIMARY KEY (start, end) +); \ No newline at end of file -- cgit v1.2.3