diff options
| author | cflip <36554078+cflip@users.noreply.github.com> | 2021-08-11 16:29:51 -0600 |
|---|---|---|
| committer | cflip <36554078+cflip@users.noreply.github.com> | 2021-08-11 16:29:51 -0600 |
| commit | 946fd6a6c2f402bc8e663c2c9d41bbac25b49971 (patch) | |
| tree | 1565fd3230dad24f6df90dc4e3e3d5101d1127b7 /meta/setup.sql | |
| parent | 2458ca6964401c0bd2cd809d303dfbcaea3ead90 (diff) | |
Implement invite codes for user registration
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) ); |