blob: 584b7b44c474b23eb9b25226f714bf6e2301b020 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
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;
|
