From 359783fca404e2a80aa79eddc10c19f8148137c5 Mon Sep 17 00:00:00 2001
From: Horus3
Date: Tue, 18 Feb 2014 17:36:03 +0100
Subject: database schema

---
 blob/database_schema | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

(limited to 'blob')

diff --git a/blob/database_schema b/blob/database_schema
index 5cb7d99..1e7091f 100644
--- a/blob/database_schema
+++ b/blob/database_schema
@@ -2,5 +2,4 @@
 
 CREATE TABLE IF NOT EXISTS user (id INTEGER PRIMARY KEY, name TEXT UIQUE, senpai INTEGER, key TEXT, status INTEGER, invites INTEGER, salt TEXT, password TEXT, email TEXT UNIQUE);
 
-#Create table dynamically for every user, where $name=user
-CREATE TABLE $safe_name (id INTEGER PRIMARY KEY, folder INTEGER, name TEXT, type TEXT, mime TEXT, size INTEGER, public TEXT);
+CREATE TABLE files (id INTEGER PRIMARY KEY, owner INTEGER, folder INTEGER, name TEXT, type TEXT, mime TEXT, size INTEGER, public TEXT, FOREIGN KEY(owner) REFERENCES user(id));
-- 
cgit v1.2.3