added database schema

1 files changed, 6 insertions, 0 deletions

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