From 5cb0869b94fc8b9aff564055af9a60046de7b028 Mon Sep 17 00:00:00 2001
From: "Adam T. Carpenter" <atc@53hor.net>
Date: Thu, 22 Oct 2020 22:09:46 -0400
Subject: Skipped separate photo table; working handler for get all products
 (lacking cats)

---
 dichroism/migrations/2020-10-23-010929_products/up.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 dichroism/migrations/2020-10-23-010929_products/up.sql

(limited to 'dichroism/migrations/2020-10-23-010929_products/up.sql')

diff --git a/dichroism/migrations/2020-10-23-010929_products/up.sql b/dichroism/migrations/2020-10-23-010929_products/up.sql
new file mode 100644
index 0000000..9e9c696
--- /dev/null
+++ b/dichroism/migrations/2020-10-23-010929_products/up.sql
@@ -0,0 +1,11 @@
+CREATE TABLE "products" (
+	"id"	INTEGER NOT NULL,
+	"photo_set"	INTEGER NOT NULL,
+	"cents"	INTEGER NOT NULL,
+	"quantity"	INTEGER NOT NULL,
+	"name"	TEXT NOT NULL,
+	"description"	TEXT NOT NULL,
+	"featured"	INTEGER NOT NULL,
+	PRIMARY KEY("id"),
+	FOREIGN KEY("photo_set") REFERENCES "photo_sets"("id")
+)
-- 
cgit v1.2.3

