From 14aea28ac22e5d2e9e510c5986daca1bef1c43ae Mon Sep 17 00:00:00 2001
From: LarsVomMars
Date: Thu, 30 Jul 2020 20:03:19 +0200
Subject: Added some more user db functions

---
 src/db/tables.sql | 30 +++++++++++++++++-------------
 1 file changed, 17 insertions(+), 13 deletions(-)

(limited to 'src/db/tables.sql')

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;
-- 
cgit v1.2.3