diff options
author | Masaya Tojo <masaya@tojo.tokyo> | 2023-11-11 16:13:41 +0900 |
---|---|---|
committer | Masaya Tojo <masaya@tojo.tokyo> | 2023-11-11 16:13:41 +0900 |
commit | 9c8cbed6cdd725ed1153a260ab0844971b685fbf (patch) | |
tree | 9564f59e51d53764de04e6a685dabee1bf0c9149 /verify | |
parent | 46389b3d0d929d74048a5e2e0431641622f17e1a (diff) |
Change taken_at column type to timestamptz
Diffstat (limited to 'verify')
-rw-r--r-- | verify/photos@v1.0.0-alpha1.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/verify/photos@v1.0.0-alpha1.sql b/verify/photos@v1.0.0-alpha1.sql new file mode 100644 index 0000000..b073ca6 --- /dev/null +++ b/verify/photos@v1.0.0-alpha1.sql @@ -0,0 +1,11 @@ +-- Verify photos:photos on pg + +BEGIN; + +SET search_path to photos; + +SELECT id, path, is_video, is_receipt, note, date, taken_at, camera_name, created_at, updated_at + FROM photos + WHERE FALSE; + +ROLLBACK; |