summaryrefslogtreecommitdiff
path: root/dichroism/migrations/2020-10-09-210247_photo_sets/up.sql
blob: 98e6050cebad0b292b379d1e1f9c2420e0f229e3 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
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")
)