From 7a33856a527aebbd8d2a624c6d5937c25c9a1d90 Mon Sep 17 00:00:00 2001
From: Emma Terzioglu <emreterzioglu49@gmail.com>
Date: Fri, 13 Mar 2026 13:49:15 -0700
Subject: initial commit

new website repo yay!!!
---
 migrations/20260220_initial_up_54f544.sql | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100644 migrations/20260220_initial_up_54f544.sql

(limited to 'migrations/20260220_initial_up_54f544.sql')

diff --git a/migrations/20260220_initial_up_54f544.sql b/migrations/20260220_initial_up_54f544.sql
new file mode 100644
index 0000000..2aa3686
--- /dev/null
+++ b/migrations/20260220_initial_up_54f544.sql
@@ -0,0 +1,22 @@
+CREATE TABLE IF NOT EXISTS posts (
+    id UUID PRIMARY KEY DEFAULT uuidv7(),
+    text TEXT NOT NULL,
+    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+);
+
+CREATE TABLE IF NOT EXISTS videos (
+    id UUID PRIMARY KEY DEFAULT uuidv7(),
+    source TEXT NOT NULL,
+    title TEXT NOT NULL,
+    description TEXT,
+    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+);
+
+CREATE TABLE IF NOT EXISTS comments (
+    id UUID PRIMARY KEY DEFAULT uuidv7(),
+    post_id UUID REFERENCES posts,
+    video_id UUID REFERENCES videos,
+    author TEXT NOT NULL,
+    text TEXT NOT NULL,
+    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+);
-- 
cgit v1.2.3

