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/20220903093057_add-users-table.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 migrations/20220903093057_add-users-table.sql

(limited to 'migrations/20220903093057_add-users-table.sql')

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

