mime support

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