summaryrefslogtreecommitdiff
path: root/dichroism/migrations/2020-10-21-221149_products/up.sql
blob: 9e9c696cb995b4a2b174dc29a72d25f6b9fad2f3 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
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")
)