Added some more user db functions

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;