mirror of
https://github.com/BillyOutlast/stash-box.git
synced 2026-02-06 11:51:22 +01:00
7 lines
303 B
SQL
7 lines
303 B
SQL
ALTER TABLE "images" ADD COLUMN "checksum" varchar(255) NOT NULL;
|
|
ALTER TABLE "images" ALTER COLUMN "url" DROP NOT NULL;
|
|
ALTER TABLE "images" ALTER COLUMN "width" SET NOT NULL;
|
|
ALTER TABLE "images" ALTER COLUMN "height" SET NOT NULL;
|
|
|
|
CREATE UNIQUE INDEX "images_checksum_idx" ON "images" ("checksum");
|