aboutsummaryrefslogtreecommitdiff
path: root/src/db/tables.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/db/tables.sql')
-rw-r--r--src/db/tables.sql30
1 files changed, 17 insertions, 13 deletions
diff --git a/src/db/tables.sql b/src/db/tables.sql
index a0c9eef..a7c3838 100644
--- a/src/db/tables.sql
+++ b/src/db/tables.sql
@@ -1,19 +1,23 @@
# DROP TABLE IF EXISTS access;
# DROP TABLE IF EXISTS users;
-CREATE TABLE IF NOT EXISTS users (
- id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
- email VARCHAR(48) NOT NULL UNIQUE,
- username VARCHAR(24) NOT NULL UNIQUE,
- password VARCHAR(64) NOT NULL,
+CREATE TABLE IF NOT EXISTS users
+(
+ id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
+ email VARCHAR(48) NOT NULL UNIQUE,
+ username VARCHAR(24) NOT NULL UNIQUE,
+ password VARCHAR(64) NOT NULL,
verification VARCHAR(64) NOT NULL UNIQUE,
- dark_theme BOOLEAN NOT NULL DEFAULT true,
- is_admin BOOLEAN NOT NULL DEFAULT false
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+ dark_theme BOOLEAN NOT NULL DEFAULT true,
+ is_admin BOOLEAN NOT NULL DEFAULT false
+) ENGINE = InnoDB
+ DEFAULT CHARSET = utf8;
-CREATE TABLE IF NOT EXISTS access (
- id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
- uid INT(6) UNSIGNED,
+CREATE TABLE IF NOT EXISTS access
+(
+ id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
+ uid INT(6) UNSIGNED,
path VARCHAR(64) NOT NULL,
- FOREIGN KEY (uid) REFERENCES users(id) ON DELETE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+ FOREIGN KEY (uid) REFERENCES users (id) ON DELETE CASCADE
+) ENGINE = InnoDB
+ DEFAULT CHARSET = utf8;