revert/photos.sql


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 time USING (taken_at  AT TIME ZONE 'Asia/Tokyo')::time;

COMMIT;