diff options
Diffstat (limited to 'meta/setup.sql')
-rw-r--r-- | meta/setup.sql | 2 |
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) ); |