aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAqua-sama <aqua@iserlohn-fortress.net>2021-04-30 10:22:09 +0300
committerAqua-sama <aqua@iserlohn-fortress.net>2021-04-30 10:22:09 +0300
commit5ba6e3d9fb722e6c3969664062d028c5d0daf7cd (patch)
treed56ec320a9b42ae76ebf3a6d003386326552fcb1
parentRemove debug print_r (diff)
downloadbugtracker-5ba6e3d9fb722e6c3969664062d028c5d0daf7cd.tar.xz
Make username and email uniqueHEADmaster
-rw-r--r--etc/setup.sql4
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
);