From b7c3e058e9b161065b9024458fc7be0b3c5e8cb5 Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Sat, 10 Apr 2021 20:11:35 +0200
Subject: Implemented a user table and the CreateUser function

---
 pkg/database/migrations.go | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'pkg/database/migrations.go')

diff --git a/pkg/database/migrations.go b/pkg/database/migrations.go
index cec3c41..8d23ed2 100644
--- a/pkg/database/migrations.go
+++ b/pkg/database/migrations.go
@@ -9,6 +9,14 @@ var allMigrations = []func(tx *sql.Tx) error{
 		sql := `
 			CREATE TABLE schema_version (
 				version INTEGER NOT NULL
+			);
+			CREATE TABLE users (
+				id INTEGER PRIMARY KEY,
+				username TEXT NOT NULL UNIQUE,
+				password TEXT,
+				email TEXT,
+				created_at DATE DEFAULT (datetime('now')),
+				last_login_at DATE DEFAULT NULL
 			);`
 		_, err = tx.Exec(sql)
 		return err
-- 
cgit v1.2.3