-- CreateTable
CREATE TABLE "Settings" (
    "id" INTEGER NOT NULL PRIMARY KEY DEFAULT 1,
    "nomCommercial" TEXT NOT NULL DEFAULT 'ISPM',
    "logoFilename" TEXT,
    "updatedAt" DATETIME NOT NULL
);

-- Insert singleton row
INSERT INTO "Settings" ("id", "nomCommercial", "logoFilename", "updatedAt")
VALUES (1, 'ISPM', NULL, CURRENT_TIMESTAMP);