Users has username and use it for login

2 files changed, 7 insertions, 6 deletions

diff --git a/migrations/20220822142548_add-users-table.sql b/migrations/20220822142548_add-users-table.sql
deleted file mode 100644
index 4798d7e..0000000
--- a/migrations/20220822142548_add-users-table.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-create table users (
-    id serial unique,
-    email varchar(100) unique not null,
-    password varchar(100) not null,
-    is_staff boolean default false
-);
diff --git a/migrations/20220903093057_add-users-table.sql b/migrations/20220903093057_add-users-table.sql
new file mode 100644
index 0000000..0fb83c4
--- /dev/null
+++ b/migrations/20220903093057_add-users-table.sql
@@ -0,0 +1,7 @@
+CREATE TABLE USERS (
+    id SERIAL UNIQUE PRIMARY KEY,
+    email VARCHAR(100) UNIQUE NOT NULL,
+    username VARCHAR(100) UNIQUE NOT NULL,
+    password VARCHAR(100) NOT NULL,
+    is_staff BOOLEAN DEFAULT FALSE
+);