Weight-Tracker-Diary

Setup:

1. Install XAMPP
2. Open the XAMPP Control Panel and start Apache and MySQL (click "Start" next to it)
3. Navigate to the XAMPPs installation folder (for Windows "C:\xampp") and open the folder: htdocs
4. Clone this Github repository into the htdocs folder
5. For creating and using the Database do the following:

   • Install phpMyAdmin -> during the installation choose as Host "localhost" and as User "root"

   • Navigate to: http://localhost/phpmyadmin/

   • Click the "Database" tab at the top

   • Under "Create database" type in "weight-tracker-diary" in the text box and select "utf8_general_ci" as the collation

   • Click create

   • Now perform the following SQL comands unter the tab "SQL":

     CREATE TABLE `accounts` (
     `id` int(11) NOT NULL AUTO_INCREMENT,
     `username` varchar(50) NOT NULL,
     `password` varchar(255) NOT NULL,
     `email` varchar(100) NOT NULL,
     PRIMARY KEY (`id`)
     ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8

     CREATE TABLE `diary_entries` (
     `user_id` int(11) NOT NULL,
     `date` date NOT NULL,
     `feeling` int(11) DEFAULT NULL,
     `sleep` int(11) DEFAULT NULL,
     `sleep_time` int(11) DEFAULT NULL,
     `sports` tinyint(1) DEFAULT NULL,
     `sports_kind` int(11) DEFAULT NULL,
     `weight` decimal(10,2) DEFAULT NULL,
     `individual_entry` varchar(500) DEFAULT NULL,
     `score` decimal(10,2) DEFAULT NULL,
     PRIMARY KEY (`user_id`,`date`),
     KEY `feeling` (`feeling`),
     KEY `sleep` (`sleep`),
     KEY `sports_kind` (`sports_kind`),
     CONSTRAINT `diary_entries_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
     CONSTRAINT `diary_entries_ibfk_2` FOREIGN KEY (`feeling`) REFERENCES `rating` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
     CONSTRAINT `diary_entries_ibfk_3` FOREIGN KEY (`sleep`) REFERENCES `rating` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
     CONSTRAINT `diary_entries_ibfk_4` FOREIGN KEY (`sports_kind`) REFERENCES `sports` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

     CREATE TABLE `rating` (
      `id` int(11) NOT NULL,
      `rating` char(10) DEFAULT NULL,
      PRIMARY KEY (`id`)
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

     CREATE TABLE `sports` (
      `id` int(11) NOT NULL,
      `sports_kind` char(20) DEFAULT NULL,
      PRIMARY KEY (`id`)
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

     INSERT INTO rating(id, rating) VALUES(1, 'bad')
     INSERT INTO rating(id, rating) VALUES(2, 'moderate')
     INSERT INTO rating(id, rating) VALUES(3, 'okay')
     INSERT INTO rating(id, rating) VALUES(4, 'good')

     INSERT INTO sports(id, sports_kind) VALUES(1, 'biking')
     INSERT INTO sports(id, sports_kind) VALUES(2, 'swimming')
     INSERT INTO sports(id, sports_kind) VALUES(3, 'lifting weights')
     INSERT INTO sports(id, sports_kind) VALUES(4, 'running')