From c00b690bd6f600554a1404e692bd9e4373325d27 Mon Sep 17 00:00:00 2001
From: Leonardo Bishop <me@leonardobishop.com>
Date: Fri, 17 Jan 2025 13:21:24 +0000
Subject: Initial commit

---
 pkg/database/migrations/0001_initial.sql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 pkg/database/migrations/0001_initial.sql

(limited to 'pkg/database/migrations/0001_initial.sql')

diff --git a/pkg/database/migrations/0001_initial.sql b/pkg/database/migrations/0001_initial.sql
new file mode 100644
index 0000000..eea0a73
--- /dev/null
+++ b/pkg/database/migrations/0001_initial.sql
@@ -0,0 +1,17 @@
+-- +goose Up
+CREATE TABLE users (
+    id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
+    username varchar(20) UNIQUE NOT NULL,
+    password char(60) NOT NULL
+);
+
+CREATE TABLE favourites (
+    id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
+    user_id int NOT NULL,
+    event_guid uuid,
+    event_id int,
+    UNIQUE(user_id, event_guid, event_id),
+    CONSTRAINT chk_favourites CHECK (event_guid IS NOT NULL OR event_id IS NOT NULL),
+    FOREIGN KEY (user_id) REFERENCES users(id)
+);
+
-- 
cgit v1.2.3-70-g09d2

