diff options
Diffstat (limited to 'src/db/tables.sql')
-rw-r--r-- | src/db/tables.sql | 30 |
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; |