diff options
Diffstat (limited to 'migrations/003_create_posts_table.sql.sql')
| -rw-r--r-- | migrations/003_create_posts_table.sql.sql | 18 |
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; |
