blob: a561a05bd9f3ee084874cdc9c0c9061f15ed9fc2 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
CREATE TABLE users(
id SERIAL NOT NULL PRIMARY KEY,
username VARCHAR(50) NOT NULL,
secret VARCHAR(255) NOT NULL,
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);
CREATE TRIGGER set_timestamp
BEFORE UPDATE ON users
FOR EACH ROW
EXECUTE PROCEDURE trigger_set_timestamp();
---- create above / drop below ----
DROP TABLE users;
|
