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 ++++++
 blob/files.conf      | 50 --------------------------------------------------
 2 files changed, 6 insertions(+), 50 deletions(-)
 create mode 100644 blob/database_schema
 delete mode 100644 blob/files.conf

(limited to 'blob')

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);
diff --git a/blob/files.conf b/blob/files.conf
deleted file mode 100644
index 9b7ab95..0000000
--- a/blob/files.conf
+++ /dev/null
@@ -1,50 +0,0 @@
-server {
-	listen 80;
-	server_name             files.iamfabulous.de;
-	index 			index.html;
-	root                    /var/www/files/www;
-        #location / {
-        #        autoindex               on;
-        #}
-
-        error_page 404          /lolrndm.php;
-        error_page 401          /lolrndm.php;
-
-        location ~* \.php {
-              	fastcgi_pass    unix:/var/run/php5-fpm.sock;
-              	include         fastcgi_params;# SCRIPT_FILENAME $document_root$fastcgi_script_name;
-#		fastcgi_param SCRIPT_FILENAME $request_filename;
-        }
-
-	#try_files		$URI /files.php;
-
-        location ~* ^/?login(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? {
-                rewrite ^/?login(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)?    /login.php?$1 last;
-        }
-
-	location ~* ^/?register(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? {
-		rewrite ^/?register(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)?	/register.php?$1 last;
-	}
-
-	location ~* ^/?invite(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? {
-		rewrite ^/?invite(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)?	/invite.php?$1 last;
-	}
-
-	location ~* \.php(\?[0-9a-zA-Z]*(=[0-9a-zA-Z]*)?)? {
-	}
-
-	location / {
-		rewrite ^/([0-9a-zA-Z-_]*)/(.*)	/index.php?name=$1&folder=$2 last;
-		rewrite ^/([0-9a-zA-Z-_]*)	/index.php?name=$1&folder=$2 last;
-		break;
-	}
-
-	#rewrite ^/(.*)		/files.php?$1 break;
-	#rewrite ^/(.*)          https://$server_name/$1 permanent; 
-
-#        location /admin {
-#                autoindex               on;
-#                auth_basic              "protected";
-#                auth_basic_user_file    /etc/nginx/claudio.passwd;
-#        }
-}
-- 
cgit v1.2.3