aboutsummaryrefslogtreecommitdiff
path: root/blob/database_schema
diff options
context:
space:
mode:
authorHorus32014-09-25 10:33:47 +0200
committerHorus32014-09-25 10:33:47 +0200
commit1fe76ba743a3418da9a0883b29756d442384d0bc (patch)
tree091910ffd183d94c0f8b70a8f4c362f733033b03 /blob/database_schema
parent2036626b560f22efd59673187a2de3b1319fcf8a (diff)
downloadjungegemeinde-1fe76ba743a3418da9a0883b29756d442384d0bc.tar.gz
init
Diffstat (limited to 'blob/database_schema')
-rw-r--r--blob/database_schema9
1 files changed, 0 insertions, 9 deletions
diff --git a/blob/database_schema b/blob/database_schema
deleted file mode 100644
index f83e2d9..0000000
--- a/blob/database_schema
+++ /dev/null
@@ -1,9 +0,0 @@
-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);