diff options
author | Aqua-sama <aqua@iserlohn-fortress.net> | 2021-04-30 10:22:09 +0300 |
---|---|---|
committer | Aqua-sama <aqua@iserlohn-fortress.net> | 2021-04-30 10:22:09 +0300 |
commit | 5ba6e3d9fb722e6c3969664062d028c5d0daf7cd (patch) | |
tree | d56ec320a9b42ae76ebf3a6d003386326552fcb1 | |
parent | Remove debug print_r (diff) | |
download | bugtracker-5ba6e3d9fb722e6c3969664062d028c5d0daf7cd.tar.xz |
-rw-r--r-- | etc/setup.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/etc/setup.sql b/etc/setup.sql index 5ca866f..697f2bd 100644 --- a/etc/setup.sql +++ b/etc/setup.sql @@ -1,9 +1,9 @@ -- users table CREATE TABLE users ( id SERIAL PRIMARY KEY, -username varchar(50) NOT NULL, +username varchar(50) NOT NULL UNIQUE, password varchar(255) NOT NULL, -email varchar(50) NOT NULL, +email varchar(50) NOT NULL UNIQUE, can_edit_bugs boolean DEFAULT true, can_edit_reports boolean DEFAULT true ); |