path: root/dichroism/migrations/2020-10-09-210247_photo_sets/up.sql

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")
)