summaryrefslogtreecommitdiff
path: root/meta/setup.sql
diff options
context:
space:
mode:
Diffstat (limited to 'meta/setup.sql')
-rw-r--r--meta/setup.sql2
1 files changed, 2 insertions, 0 deletions
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)
);