From 76a782599b4ecc4ecb9b0ce7acc6420ed9e1ec8e Mon Sep 17 00:00:00 2001
From: "Adam T. Carpenter" <atc@53hor.net>
Date: Tue, 20 Oct 2020 09:50:08 -0400
Subject: back to basics -- working on the most-required functionality first,
 like handlers

---
 dichroism/migrations/2020-10-09-210247_photo_sets/up.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100644 dichroism/migrations/2020-10-09-210247_photo_sets/up.sql

(limited to 'dichroism/migrations/2020-10-09-210247_photo_sets/up.sql')

diff --git a/dichroism/migrations/2020-10-09-210247_photo_sets/up.sql b/dichroism/migrations/2020-10-09-210247_photo_sets/up.sql
new file mode 100644
index 0000000..98e6050
--- /dev/null
+++ b/dichroism/migrations/2020-10-09-210247_photo_sets/up.sql
@@ -0,0 +1,12 @@
+CREATE TABLE "photo_sets" (
+	"id"	INTEGER NOT NULL,
+	"base"	INTEGER NOT NULL,
+	"fullsize"	INTEGER NOT NULL,
+	"thumbnail"	INTEGER NOT NULL,
+	"original"	INTEGER NOT NULL,
+	FOREIGN KEY("thumbnail") REFERENCES "photos"("id"),
+	FOREIGN KEY("original") REFERENCES "photos"("id"),
+	FOREIGN KEY("base") REFERENCES "photos"("id"),
+	FOREIGN KEY("fullsize") REFERENCES "photos"("id"),
+	PRIMARY KEY("id")
+)
-- 
cgit v1.2.3

