blob: 714f3b0017ac7c7f3e9d61cd49f32c9b68fbb95e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
-- Deploy photos:photos to pg
-- requires: schema
BEGIN;
SET client_min_messages = 'warning';
SET search_path to photos;
CREATE TABLE photos(
id UUID PRIMARY KEY,
path TEXT NOT NULL,
is_receipt BOOLEAN NOT NULL DEFAULT FALSE,
note TEXT CHECK (note <> ''),
taken_at TIME,
camera_name TEXT,
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);
COMMIT;
|