From dee922a5de5108174e747dde547e366a6e3381ef Mon Sep 17 00:00:00 2001
From: Horus3
Date: Mon, 17 Feb 2014 21:59:01 +0100
Subject: added database schema

---
 blob/database_schema | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 blob/database_schema

(limited to 'blob/database_schema')

diff --git a/blob/database_schema b/blob/database_schema
new file mode 100644
index 0000000..94ac055
--- /dev/null
+++ b/blob/database_schema
@@ -0,0 +1,6 @@
+#Database schema for SQLite3 database, stored in "../database/sqlite.db", based on the "www" directory
+
+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 $name (id INTEGER PRIMARY KEY, folder INTEGER, name TEXT, type TEXT, public TEXT);
-- 
cgit v1.2.3