From 2c6434e0b89e93ab6bdddb28bcd059b48638cb0d Mon Sep 17 00:00:00 2001
From: Santo Cariotti <santo@dcariotti.me>
Date: Sat, 3 Sep 2022 12:10:20 +0200
Subject: Users has username and use it for login

---
 migrations/20220822142548_add-users-table.sql | 6 ------
 migrations/20220903093057_add-users-table.sql | 7 +++++++
 2 files changed, 7 insertions(+), 6 deletions(-)
 delete mode 100644 migrations/20220822142548_add-users-table.sql
 create mode 100644 migrations/20220903093057_add-users-table.sql

(limited to 'migrations')

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
+);
-- 
cgit v1.2.3-71-g8e6c