-- User-submitted "please track this source" requests, decided by an operator.
CREATE TABLE "tweak_requests" (
    "id" SERIAL NOT NULL,
    "install_id" TEXT NOT NULL,
    "tweak_name" TEXT NOT NULL,
    "source_type" TEXT NOT NULL,
    "source_id" TEXT NOT NULL,
    "raw_input" TEXT NOT NULL,
    "note" TEXT,
    "status" TEXT NOT NULL DEFAULT 'pending',
    "decision_reason" TEXT,
    "decided_at" TIMESTAMP(3),
    "decided_by_user_id" INTEGER,
    "client_version" TEXT,
    "created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updated_at" TIMESTAMP(3) NOT NULL,

    CONSTRAINT "tweak_requests_pkey" PRIMARY KEY ("id")
);

CREATE INDEX "tweak_requests_status_created_at_idx" ON "tweak_requests"("status", "created_at");
CREATE INDEX "tweak_requests_install_id_created_at_idx" ON "tweak_requests"("install_id", "created_at");
CREATE INDEX "tweak_requests_source_id_idx" ON "tweak_requests"("source_id");