-- CreateTable
CREATE TABLE "albums" (
    "id" TEXT NOT NULL PRIMARY KEY,
    "title" TEXT NOT NULL,
    "artist" TEXT NOT NULL,
    "article" TEXT,
    "image_url" TEXT,
    "spotify_link" TEXT,
    "genres" TEXT NOT NULL DEFAULT '',
    "release_date" DATETIME,
    "status" TEXT NOT NULL DEFAULT 'published',
    "display_order" INTEGER NOT NULL DEFAULT 0,
    "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updated_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);

-- CreateIndex
CREATE INDEX "albums_display_order_idx" ON "albums"("display_order");

-- CreateIndex
CREATE INDEX "albums_status_idx" ON "albums"("status");