database schema

1 files changed, 1 insertions, 2 deletions

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));