blob: 6cb3cba07de852609a66b6717eee0aec8527a169 (
about) (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
-- Deploy life-archive:photo.photos to pg
-- requires: photo
BEGIN;
CREATE TABLE photo.photos (
id SERIAL PRIMARY KEY,
url TEXT NOT NULL,
taken_at timestamp NOT NULL,
place TEXT NOT NULL,
note TEXT CHECK (note <> ''),
created_at TIMESTAMP NOT NULL DEFAULT NOW(),
updated_at TIMESTAMP NOT NULL DEFAULT NOW()
);
COMMIT;
|