diff options
| author | Marvin Borner | 2020-09-30 22:56:00 +0200 |
|---|---|---|
| committer | Marvin Borner | 2020-09-30 22:56:00 +0200 |
| commit | bda5305e995023d8c2382754d9761ac92a76db88 (patch) | |
| tree | 9428d5310cc169eb42be01d4b571617eb8fe6416 | |
| parent | 25f43e12bd6b3713b633ec3fec524c6199a68dfa (diff) | |
Started authentication
| -rw-r--r-- | app.js | 2 | ||||
| -rw-r--r-- | auth/index.js | 14 | ||||
| -rw-r--r-- | auth/public/index.html | 9 | ||||
| -rw-r--r-- | tables.sql | 37 |
4 files changed, 62 insertions, 0 deletions
@@ -2,6 +2,7 @@ require("dotenv").config(); const express = require("express"); const motto = require("./motto"); +const auth = require("./auth"); const app = express(); @@ -10,5 +11,6 @@ app.use(express.json()); app.get("/", (req, res) => res.redirect("/motto")); app.use("/motto", motto); +app.use("/auth", auth); app.listen(5005, () => console.log("Server started on http://localhost:5005")); diff --git a/auth/index.js b/auth/index.js new file mode 100644 index 0000000..9bc3f58 --- /dev/null +++ b/auth/index.js @@ -0,0 +1,14 @@ +const express = require("express"); +const db = require("../db"); +const app = express.Router(); + +// TODO: Name list parser (teachers + pupils) +// TODO: Add users (OTP) +// TODO: Change passwords +// TODO: Login (+ Frontend, cookie, etc) + +app.use("/", express.static(__dirname + "/public")); + +app.get("/api/list", (req, res) => {}); + +module.exports = app; diff --git a/auth/public/index.html b/auth/public/index.html new file mode 100644 index 0000000..c290ab0 --- /dev/null +++ b/auth/public/index.html @@ -0,0 +1,9 @@ +<!DOCTYPE html> +<html> + <head> + <meta charset="UTF-8" /> + <meta name="viewport" content="width=device-width" /> + <title>Auth</title> + </head> + <body></body> +</html> @@ -9,3 +9,40 @@ CREATE TABLE IF NOT EXISTS theme( UNIQUE KEY main (main, description) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- TODO: Remove dropping +DROP TABLE IF EXISTS teachers; +DROP TABLE IF EXISTS users; +DROP TABLE IF EXISTS class; + +CREATE TABLE IF NOT EXISTS teachers( + id INTEGER PRIMARY KEY AUTO_INCREMENT, + username VARCHAR(255) NOT NULL, + name VARCHAR(255) NOT NULL, + middlename VARCHAR(255) NOT NULL, + surname VARCHAR(255) NOT NULL, + password VARCHAR(255) NOT NULL, + + UNIQUE KEY uk_name (name, middlename, surname) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +CREATE TABLE IF NOT EXISTS class( + id INTEGER PRIMARY KEY AUTO_INCREMENT, + name VARCHAR(255) NOT NULL, + teacher_id INTEGER NOT NULL, + + CONSTRAINT `fk_teacher_class` FOREIGN KEY (teacher_id) REFERENCES teachers (id) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +CREATE TABLE IF NOT EXISTS users( + id INTEGER PRIMARY KEY AUTO_INCREMENT, + username VARCHAR(255) NOT NULL, + name VARCHAR(255) NOT NULL, + middlename VARCHAR(255) NOT NULL, + surname VARCHAR(255) NOT NULL, + password VARCHAR(255) NOT NULL, + class_id INTEGER NOT NULL, + + UNIQUE KEY uk_name (name, middlename, surname), + CONSTRAINT `fk_class_user` FOREIGN KEY (class_id) REFERENCES class (id) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; |