diff options
| -rw-r--r-- | blob/database_schema | 2 | ||||
| -rw-r--r-- | www/functions/func_register.php | 1 | ||||
| -rw-r--r-- | www/setup.php | 2 |
3 files changed, 3 insertions, 2 deletions
diff --git a/blob/database_schema b/blob/database_schema index 939ddb4..37d0ec7 100644 --- a/blob/database_schema +++ b/blob/database_schema @@ -1,6 +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, password TEXT, email TEXT UNIQUE, invites INTEGER, senpai INTEGER, key TEXT, status INTEGER, register TEXT); +CREATE TABLE IF NOT EXISTS user (id INTEGER PRIMARY KEY, name TEXT UNIQUE, password TEXT, email TEXT UNIQUE, invites INTEGER, senpai INTEGER, key TEXT, status INTEGER, register TEXT); CREATE TABLE IF NOT EXISTS files (id INTEGER PRIMARY KEY, parent INTEGER, owner INTEGER, name TEXT, folder TEXT, mime TEXT, size INTEGER, share TEXT, hash TEXT, FOREIGN KEY(owner) REFERENCES user(id)); diff --git a/www/functions/func_register.php b/www/functions/func_register.php index 30f31c0..ae784cf 100644 --- a/www/functions/func_register.php +++ b/www/functions/func_register.php @@ -59,6 +59,7 @@ function register($db){ $_SESSION["login"] = true; $_SESSION["username"] = $name; + header("Refresh: 0; /") return true; } else { diff --git a/www/setup.php b/www/setup.php index c848a80..28cec00 100644 --- a/www/setup.php +++ b/www/setup.php @@ -40,7 +40,7 @@ if($bool){ if($db->exec(" BEGIN TRANSACTION; - CREATE TABLE IF NOT EXISTS user (id INTEGER PRIMARY KEY, name TEXT UIQUE, password TEXT, email TEXT UNIQUE, invites INTEGER, senpai INTEGER, key TEXT, status INTEGER, register TEXT); + CREATE TABLE IF NOT EXISTS user (id INTEGER PRIMARY KEY, name TEXT UNIQUE, password TEXT, email TEXT UNIQUE, invites INTEGER, senpai INTEGER, key TEXT, status INTEGER, register TEXT); INSERT INTO user (id, name, senpai, key, status, invites, password, email, register) VALUES (NULL, 'admin', 0, '11111', 1, 5, '" . $hash_password . "', '" . $email . "', (SELECT datetime()) ); CREATE TABLE IF NOT EXISTS files (id INTEGER PRIMARY KEY, parent INTEGER, owner INTEGER, name TEXT, folder TEXT, mime TEXT, size INTEGER, share TEXT, hash TEXT, FOREIGN KEY(owner) REFERENCES user(id)); INSERT INTO files (id, parent, owner, name, folder, size, share, hash) VALUES (NULL, 0, 1, '/', 'DIRECTORY', 0, 'HIDDEN', ''); |