From ea8083d7162a099a8a2e1a7976ecd1e5278a5558 Mon Sep 17 00:00:00 2001
From: root
Date: Fri, 28 Mar 2014 21:54:15 +0100
Subject: Added new database layout.

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

(limited to 'blob/database_schema')

diff --git a/blob/database_schema b/blob/database_schema
index eef9aec..c994910 100755
--- a/blob/database_schema
+++ b/blob/database_schema
@@ -6,4 +6,6 @@ CREATE TABLE IF NOT EXISTS files (id INTEGER PRIMARY KEY, parent INTEGER, owner
 
 CREATE TABLE IF NOT EXISTS log (id INTEGER PRIMARY KEY, user INTEGER, login TEXT, FOREIGN KEY(user) REFERENCES user(id));
 
+CREATE TABLE IF NOT EXISTS banned_user (id INTEGER PRIMARY KEY, ip TEXT, session_id TEXT, time INTEGER);
+
 CREATE TRIGGER IF NOT EXISTS delete_files AFTER DELETE ON user FOR EACH ROW BEGIN DELETE FROM files WHERE owner=OLD.id; END;
-- 
cgit v1.2.3