summaryrefslogtreecommitdiff
path: root/deploy/photos.sql
blob: a0231ee5e3214b3eaa5d1119cb3b0e59d47aeff5 (about) (plain)
1
2
3
4
5
6
7
8
9
10
11
-- Deploy photos:photos to pg
-- requires: schema

BEGIN;

SET search_path to photos;

ALTER TABLE photos
  ALTER COLUMN taken_at TYPE timestamptz USING (date + taken_at) AT TIME ZONE 'Asia/Tokyo';

COMMIT;