From e32f683d2d339b33341a072b4674c4def90a51e5 Mon Sep 17 00:00:00 2001
From: Cflip <36554078+cflip@users.noreply.github.com>
Date: Sat, 23 Jan 2021 00:41:52 -0700
Subject: Fix indentation in setup.sql

---
 setup.sql | 37 ++++++++++++++++++-------------------
 1 file changed, 18 insertions(+), 19 deletions(-)

(limited to 'setup.sql')

diff --git a/setup.sql b/setup.sql
index b43ebf2..642c46a 100644
--- a/setup.sql
+++ b/setup.sql
@@ -1,40 +1,39 @@
 CREATE TABLE users (
-	user_id		INT(8) NOT NULL AUTO_INCREMENT,
-	user_name	VARCHAR(30) NOT NULL,
-	user_pass	VARCHAR(255) NOT NULL,
-	user_date	DATETIME NOT NULL,
+	user_id INT(8) NOT NULL AUTO_INCREMENT,
+	user_name VARCHAR(30) NOT NULL,
+	user_pass VARCHAR(255) NOT NULL,
+	user_date DATETIME NOT NULL,
 	UNIQUE INDEX user_name_unique (user_name),
 	PRIMARY KEY (user_id)
 ) ENGINE = InnoDB;
 
 CREATE TABLE categories (
-	cat_id			INT(8) NOT NULL AUTO_INCREMENT,
-	cat_name		VARCHAR(255) NOT NULL,
-	cat_description	VARCHAR(255) NOT NULL,
+	cat_id INT(8) NOT NULL AUTO_INCREMENT,
+	cat_name VARCHAR(255) NOT NULL,
+	cat_description VARCHAR(255) NOT NULL,
 	UNIQUE INDEX cat_name_unique (cat_name),
 	PRIMARY KEY (cat_id)
 ) ENGINE = InnoDB;
 
 CREATE TABLE topics (
-	topic_id		INT(8) NOT NULL AUTO_INCREMENT,
-	topic_subject	VARCHAR(255) NOT NULL,
-	topic_date		DATETIME NOT NULL,
-	topic_cat		INT(8) NOT NULL,
-	topic_author	INT(8) NOT NULL,
+	topic_id INT(8) NOT NULL AUTO_INCREMENT,
+	topic_subject VARCHAR(255) NOT NULL,
+	topic_date DATETIME NOT NULL,
+	topic_cat INT(8) NOT NULL,
+	topic_author INT(8) NOT NULL,
 	PRIMARY KEY (topic_id)
 ) ENGINE = InnoDB;
 
 CREATE TABLE posts (
-post_id INT(8) NOT NULL AUTO_INCREMENT,
-post_content TEXT NOT NULL,
-post_date DATETIME NOT NULL,
-post_topic INT(8) NOT NULL,
-post_author INT(8) NOT NULL,
-PRIMARY KEY (post_id)
+	post_id INT(8) NOT NULL AUTO_INCREMENT,
+	post_content TEXT NOT NULL,
+	post_date DATETIME NOT NULL,
+	post_topic INT(8) NOT NULL,
+	post_author INT(8) NOT NULL,
+	PRIMARY KEY (post_id)
 ) ENGINE = InnoDB;
 
 ALTER TABLE topics ADD FOREIGN KEY(topic_cat) REFERENCES categories(cat_id) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE topics ADD FOREIGN KEY(topic_author) REFERENCES users(user_id) ON DELETE RESTRICT ON UPDATE CASCADE;
 ALTER TABLE posts ADD FOREIGN KEY(post_topic) REFERENCES topics(topic_id) ON DELETE CASCADE ON UPDATE CASCADE;
 ALTER TABLE posts ADD FOREIGN KEY(post_author) REFERENCES users(user_id) ON DELETE RESTRICT ON UPDATE CASCADE;
-
-- 
cgit v1.2.3

