aboutsummaryrefslogtreecommitdiff
path: root/migrations/003_create_posts_table.sql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/003_create_posts_table.sql.sql')
-rw-r--r--migrations/003_create_posts_table.sql.sql18
1 files changed, 0 insertions, 18 deletions
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;