summaryrefslogtreecommitdiff
path: root/dichroism/migrations/2020-10-23-010929_products/up.sql
blob: 36e3a8217b99db6e47bc5e4d421158e08dc33783 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
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,
	"category" TEXT NOT NULL,
	PRIMARY KEY("id"),
	FOREIGN KEY("photo_set") REFERENCES "photo_sets"("id")
)