Add table for tracking photos.

1 files changed, 16 insertions, 0 deletions

diff --git a/deploy/photo.photos.sql b/deploy/photo.photos.sql
new file mode 100644
index 0000000..6cb3cba
--- /dev/null
+++ b/deploy/photo.photos.sql
@@ -0,0 +1,16 @@
+-- Deploy life-archive:photo.photos to pg
+-- requires: photo
+
+BEGIN;
+
+CREATE TABLE photo.photos (
+  id SERIAL PRIMARY KEY,
+  url TEXT NOT NULL,
+  taken_at timestamp NOT NULL,
+  place TEXT NOT NULL,
+  note TEXT CHECK (note <> ''),
+  created_at TIMESTAMP NOT NULL DEFAULT NOW(),
+  updated_at TIMESTAMP NOT NULL DEFAULT NOW()
+);
+
+COMMIT;