[scheme] Initial gallery API

1 files changed, 18 insertions, 0 deletions

diff --git a/dynamic/schema-gallery.sql b/dynamic/schema-gallery.sql
new file mode 100644
index 0000000..bad4100
--- /dev/null
+++ b/dynamic/schema-gallery.sql
@@ -0,0 +1,18 @@
+CREATE TABLE IF NOT EXISTS galleries (
+  id SERIAL,
+  vanity char(12) NOT NULL,
+  title varchar(128),
+  description varchar(4096) NOT NULL,
+  datetime timestamp with time zone NOT NULL,
+  PRIMARY KEY (id)
+);
+
+CREATE TABLE IF NOT EXISTS images (
+  id SERIAL,
+  vanity char(12) NOT NULL,
+  title varchar(128),
+  filename varchar(64) NOT NULL,
+  thumb_filename varchar(64) NOT NULL,
+  datetime timestamp with time zone NOT NULL,
+  PRIMARY KEY (id)
+);