summaryrefslogtreecommitdiff
path: root/revert/photos@v1.0.0-alpha1.sql
diff options
context:
space:
mode:
authorMasaya Tojo <masaya@tojo.tokyo>2023-11-11 16:13:41 +0900
committerMasaya Tojo <masaya@tojo.tokyo>2023-11-11 16:13:41 +0900
commit9c8cbed6cdd725ed1153a260ab0844971b685fbf (patch)
tree9564f59e51d53764de04e6a685dabee1bf0c9149 /revert/photos@v1.0.0-alpha1.sql
parent46389b3d0d929d74048a5e2e0431641622f17e1a (diff)
Change taken_at column type to timestamptz
Diffstat (limited to 'revert/photos@v1.0.0-alpha1.sql')
-rw-r--r--revert/photos@v1.0.0-alpha1.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/revert/photos@v1.0.0-alpha1.sql b/revert/photos@v1.0.0-alpha1.sql
new file mode 100644
index 0000000..7fb3606
--- /dev/null
+++ b/revert/photos@v1.0.0-alpha1.sql
@@ -0,0 +1,9 @@
+-- Revert photos:photos from pg
+
+BEGIN;
+
+SET search_path to photos;
+
+DROP TABLE photos;
+
+COMMIT;