From d73dd37027e5d9b53cd56481c78d43c0942d2d68 Mon Sep 17 00:00:00 2001
From: Alexander Kavon <me+git@alexkavon.com>
Date: Wed, 24 Jan 2024 04:11:59 -0500
Subject: remove .sql.sql file extension for migration files, drop type enum on
 migrate down

---
 migrations/003_create_posts_table.sql.sql | 18 ------------------
 1 file changed, 18 deletions(-)
 delete mode 100644 migrations/003_create_posts_table.sql.sql

(limited to 'migrations/003_create_posts_table.sql.sql')

diff --git a/migrations/003_create_posts_table.sql.sql b/migrations/003_create_posts_table.sql.sql
deleted file mode 100644
index 584b7b4..0000000
--- a/migrations/003_create_posts_table.sql.sql
+++ /dev/null
@@ -1,18 +0,0 @@
-CREATE TABLE posts(
-    id SERIAL NOT NULL PRIMARY KEY,
-    title VARCHAR(100) NOT NULL,
-    description TEXT,
-    url VARCHAR(255) UNIQUE,
-    user_id INT NOT NULL REFERENCES users(id),
-    created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
-    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
-);
-
-CREATE TRIGGER set_timestamp
-BEFORE UPDATE ON posts
-FOR EACH ROW
-EXECUTE PROCEDURE trigger_set_timestamp();
-
----- create above / drop below ----
-
-DROP TABLE posts;
-- 
cgit v1.2.3

