From ad39ff0a07b2b96ca87ac8e969b2d0c91637fad9 Mon Sep 17 00:00:00 2001
From: root
Date: Tue, 18 Feb 2014 00:39:48 +0100
Subject: mime support

---
 blob/database_schema | 2 +-
 www/register.php     | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/blob/database_schema b/blob/database_schema
index 94ac055..5cb7d99 100644
--- a/blob/database_schema
+++ b/blob/database_schema
@@ -3,4 +3,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 $name (id INTEGER PRIMARY KEY, folder INTEGER, name TEXT, type TEXT, public TEXT);
+CREATE TABLE $safe_name (id INTEGER PRIMARY KEY, folder INTEGER, name TEXT, type TEXT, mime TEXT, size INTEGER, public TEXT);
diff --git a/www/register.php b/www/register.php
index 1f34f26..87c2e90 100644
--- a/www/register.php
+++ b/www/register.php
@@ -56,7 +56,7 @@ if($_SERVER['REQUEST_METHOD'] == 'POST') {
 	        if($db->exec("
 			BEGIN TRANSACTION;
 			UPDATE user SET name='$safe_name', salt='$salt', password='$hash_password', status=1, invites=5 WHERE email='$safe_email';
-			CREATE TABLE $safe_name (id INTEGER PRIMARY KEY, folder INTEGER, name TEXT, type TEXT, public TEXT);
+			CREATE TABLE $safe_name (id INTEGER PRIMARY KEY, folder INTEGER, name TEXT, type TEXT, mime TEXT, size INTEGER, public TEXT);
 			INSERT INTO $safe_name (id, folder, name, type, public) VALUES (NULL, 0, '/', 'FOLDER', 'HIDDEN');
 			COMMIT;")
 		){
-- 
cgit v1.2.3