diff options
| -rw-r--r-- | blob/database_schema | 2 | ||||
| -rw-r--r-- | 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;") ){ |