From 0af7fafcd5a61eb1bd81c21eb93a99e3a4374648 Mon Sep 17 00:00:00 2001
From: Horus3
Date: Tue, 15 Apr 2014 15:14:05 +0200
Subject: Logs every failed log in attempt. Allows log in from special user
 using a specific email.

---
 blob/database_schema | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'blob/database_schema')

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);
-- 
cgit v1.2.3