From d73dd37027e5d9b53cd56481c78d43c0942d2d68 Mon Sep 17 00:00:00 2001 From: Alexander Kavon 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