Logs every failed log in attempt. Allows log in from special user using a specific email.

1 files changed, 9 insertions, 0 deletions

diff --git a/blob/database_schema b/blob/database_schema
index e69de29..f83e2d9 100644
--- a/blob/database_schema
+++ b/blob/database_schema
@@ -0,0 +1,9 @@
+CREATE TABLE banned_user (id INTEGER PRIMARY KEY, login_attempts INTEGER, ip TEXT, session_id TEXT, time INTEGER, user INTEGER);
+
+CREATE TABLE jg(id INTEGER PRIMARY KEY, name TEXT, adresse TEXT, telefonnummer INTEGER, handynummer INTEGER, email TEXT, geburtstag TEXT);
+
+CREATE TABLE log (id INTEGER PRIMARY KEY, user INTEGER, login INTEGER, FOREIGN KEY(user) REFERENCES user(id));
+
+CREATE TABLE sprueche(id INTEGER PRIMARY KEY, spruch TEXT);
+
+CREATE TABLE user (id INTEGER PRIMARY KEY, name TEXT UNIQUE, password TEXT, email TEXT UNIQUE, status INTEGER, register INTEGER);