From 4b01ac4021c26c05141f0fbeae20a1c50adbaabf Mon Sep 17 00:00:00 2001
From: cflip <36554078+cflip@users.noreply.github.com>
Date: Wed, 23 Jun 2021 15:18:25 -0600
Subject: Move some files into separate directory

---
 README.md               |  9 ---------
 config.example.ini      |  5 -----
 meta/README.md          |  9 +++++++++
 meta/config.example.ini |  5 +++++
 meta/setup.sql          | 44 ++++++++++++++++++++++++++++++++++++++++++++
 setup.sql               | 44 --------------------------------------------
 6 files changed, 58 insertions(+), 58 deletions(-)
 delete mode 100644 README.md
 delete mode 100644 config.example.ini
 create mode 100644 meta/README.md
 create mode 100644 meta/config.example.ini
 create mode 100644 meta/setup.sql
 delete mode 100644 setup.sql

diff --git a/README.md b/README.md
deleted file mode 100644
index 80c9d54..0000000
--- a/README.md
+++ /dev/null
@@ -1,9 +0,0 @@
-# cflip.net forums
-The source code to my first PHP project, a forum system.
-
-## Requirements
-This project requires PHP 7.0 or newer
-
-## Setup
-- Create a `config.ini` file and put your MySQL credentials in (see `config.example.ini`)
-- `setup.sql` has the SQL script to set up your database.
diff --git a/config.example.ini b/config.example.ini
deleted file mode 100644
index c587a63..0000000
--- a/config.example.ini
+++ /dev/null
@@ -1,5 +0,0 @@
-[mysql_credentials]
-server = ""
-database = ""
-user = ""
-password = ""
\ No newline at end of file
diff --git a/meta/README.md b/meta/README.md
new file mode 100644
index 0000000..80c9d54
--- /dev/null
+++ b/meta/README.md
@@ -0,0 +1,9 @@
+# cflip.net forums
+The source code to my first PHP project, a forum system.
+
+## Requirements
+This project requires PHP 7.0 or newer
+
+## Setup
+- Create a `config.ini` file and put your MySQL credentials in (see `config.example.ini`)
+- `setup.sql` has the SQL script to set up your database.
diff --git a/meta/config.example.ini b/meta/config.example.ini
new file mode 100644
index 0000000..c587a63
--- /dev/null
+++ b/meta/config.example.ini
@@ -0,0 +1,5 @@
+[mysql_credentials]
+server = ""
+database = ""
+user = ""
+password = ""
\ No newline at end of file
diff --git a/meta/setup.sql b/meta/setup.sql
new file mode 100644
index 0000000..6a96b8a
--- /dev/null
+++ b/meta/setup.sql
@@ -0,0 +1,44 @@
+CREATE TABLE users (
+	user_id INT(8) NOT NULL AUTO_INCREMENT,
+	user_name VARCHAR(30) NOT NULL,
+	user_pass VARCHAR(255) NOT NULL,
+	user_level INT(8) NOT NULL DEFAULT 0,
+	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_thread_count INT(8) NOT NULL DEFAULT 0,
+	cat_post_count INT(8) NOT NULL DEFAULT 0,
+	UNIQUE INDEX cat_name_unique (cat_name),
+	PRIMARY KEY (cat_id)
+) ENGINE = InnoDB;
+
+CREATE TABLE threads (
+	thread_id INT(8) NOT NULL AUTO_INCREMENT,
+	thread_subject VARCHAR(255) NOT NULL,
+	thread_date_created DATETIME NOT NULL,
+	thread_date_lastpost DATETIME NOT NULL,
+	thread_category INT(8) NOT NULL,
+	thread_author INT(8) NOT NULL,
+	PRIMARY KEY (thread_id)
+) ENGINE = InnoDB;
+
+CREATE TABLE posts (
+	post_id INT(8) NOT NULL AUTO_INCREMENT,
+	post_content TEXT NOT NULL,
+	post_date_created DATETIME NOT NULL,
+	post_date_edited DATETIME,
+	post_thread INT(8) NOT NULL,
+	post_author INT(8) NOT NULL,
+	PRIMARY KEY (post_id)
+) ENGINE = InnoDB;
+
+ALTER TABLE threads ADD FOREIGN KEY(thread_category) REFERENCES categories(cat_id) ON DELETE CASCADE ON UPDATE CASCADE;
+ALTER TABLE threads ADD FOREIGN KEY(thread_author) REFERENCES users(user_id) ON DELETE RESTRICT ON UPDATE CASCADE;
+ALTER TABLE posts ADD FOREIGN KEY(post_thread) REFERENCES threads(thread_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;
diff --git a/setup.sql b/setup.sql
deleted file mode 100644
index 6a96b8a..0000000
--- a/setup.sql
+++ /dev/null
@@ -1,44 +0,0 @@
-CREATE TABLE users (
-	user_id INT(8) NOT NULL AUTO_INCREMENT,
-	user_name VARCHAR(30) NOT NULL,
-	user_pass VARCHAR(255) NOT NULL,
-	user_level INT(8) NOT NULL DEFAULT 0,
-	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_thread_count INT(8) NOT NULL DEFAULT 0,
-	cat_post_count INT(8) NOT NULL DEFAULT 0,
-	UNIQUE INDEX cat_name_unique (cat_name),
-	PRIMARY KEY (cat_id)
-) ENGINE = InnoDB;
-
-CREATE TABLE threads (
-	thread_id INT(8) NOT NULL AUTO_INCREMENT,
-	thread_subject VARCHAR(255) NOT NULL,
-	thread_date_created DATETIME NOT NULL,
-	thread_date_lastpost DATETIME NOT NULL,
-	thread_category INT(8) NOT NULL,
-	thread_author INT(8) NOT NULL,
-	PRIMARY KEY (thread_id)
-) ENGINE = InnoDB;
-
-CREATE TABLE posts (
-	post_id INT(8) NOT NULL AUTO_INCREMENT,
-	post_content TEXT NOT NULL,
-	post_date_created DATETIME NOT NULL,
-	post_date_edited DATETIME,
-	post_thread INT(8) NOT NULL,
-	post_author INT(8) NOT NULL,
-	PRIMARY KEY (post_id)
-) ENGINE = InnoDB;
-
-ALTER TABLE threads ADD FOREIGN KEY(thread_category) REFERENCES categories(cat_id) ON DELETE CASCADE ON UPDATE CASCADE;
-ALTER TABLE threads ADD FOREIGN KEY(thread_author) REFERENCES users(user_id) ON DELETE RESTRICT ON UPDATE CASCADE;
-ALTER TABLE posts ADD FOREIGN KEY(post_thread) REFERENCES threads(thread_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