summaryrefslogtreecommitdiff
path: root/setup.sql
diff options
context:
space:
mode:
authorcflip <36554078+cflip@users.noreply.github.com>2021-04-12 09:55:45 -0600
committercflip <36554078+cflip@users.noreply.github.com>2021-04-12 09:55:45 -0600
commit10280968b8b45fe130bc50e2ede4ce3cabfe1e58 (patch)
tree643eb523ecd595d5a6bac58ddae6e2166aea6bac /setup.sql
parent18d8821073699ac12113e8dac91914d0a3c32cc8 (diff)
Add user_level property to user
Diffstat (limited to 'setup.sql')
-rw-r--r--setup.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/setup.sql b/setup.sql
index a826cd3..b362798 100644
--- a/setup.sql
+++ b/setup.sql
@@ -2,6 +2,7 @@ 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)