From 946fd6a6c2f402bc8e663c2c9d41bbac25b49971 Mon Sep 17 00:00:00 2001
From: cflip <36554078+cflip@users.noreply.github.com>
Date: Wed, 11 Aug 2021 16:29:51 -0600
Subject: Implement invite codes for user registration

---
 meta/setup.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'meta/setup.sql')

diff --git a/meta/setup.sql b/meta/setup.sql
index cb7df23..5d63ff7 100644
--- a/meta/setup.sql
+++ b/meta/setup.sql
@@ -4,7 +4,9 @@ CREATE TABLE users (
     user_password VARCHAR(255) NOT NULL,
     user_level ENUM('user', 'moderator', 'administrator') NOT NULL DEFAULT 'user',
     user_date_registered DATETIME NOT NULL,
+    user_invite_code VARCHAR(8) NOT NULL,
     UNIQUE INDEX user_name_unique (user_name),
+    UNIQUE INDEX user_invite_unique (user_invite_code),
 	PRIMARY KEY (user_id)
 );
 
-- 
cgit v1.2.3

