summaryrefslogblamecommitdiff
path: root/dichroism/src/migrations/products.sql
blob: 0603a5cbf0294f6ed4b8562acbe109f3e275fb4b (plain) (tree)
1
2
3
4
5
6
7
8
9
                                       






                                         
                                 
                          
                                                              
 
CREATE TABLE IF NOT EXISTS "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")
);