initial commit

new website repo yay!!!

1 files changed, 22 insertions, 0 deletions

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
+);