From 7a33856a527aebbd8d2a624c6d5937c25c9a1d90 Mon Sep 17 00:00:00 2001 From: Emma Terzioglu 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