<cfsetting showdebugoutput="false">
<cfsetting enablecfoutputonly="true">
<cfcontent type="application/json; charset=utf-8" reset="true">

<cfscript>
// Creates QuickTaskTemplates table if not exists
// Public endpoint for setup

function apiAbort(required struct payload) {
    writeOutput(serializeJSON(payload));
    abort;
}

try {
    // Create QuickTaskTemplates table
    queryExecute("
        CREATE TABLE IF NOT EXISTS QuickTaskTemplates (
            QuickTaskTemplateID INT AUTO_INCREMENT PRIMARY KEY,
            QuickTaskTemplateBusinessID INT NOT NULL,
            QuickTaskTemplateName VARCHAR(100) NOT NULL,
            QuickTaskTemplateCategoryID INT NULL,
            QuickTaskTemplateTypeID INT NULL,
            QuickTaskTemplateTitle VARCHAR(255) NOT NULL,
            QuickTaskTemplateDetails TEXT NULL,
            QuickTaskTemplateIcon VARCHAR(30) DEFAULT 'add_box',
            QuickTaskTemplateColor VARCHAR(20) DEFAULT '##6366f1',
            QuickTaskTemplateSortOrder INT DEFAULT 0,
            QuickTaskTemplateIsActive BIT(1) DEFAULT b'1',
            QuickTaskTemplateCreatedOn DATETIME DEFAULT CURRENT_TIMESTAMP,
            INDEX idx_business_active (QuickTaskTemplateBusinessID, QuickTaskTemplateIsActive),
            INDEX idx_sort (QuickTaskTemplateBusinessID, QuickTaskTemplateSortOrder)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
    ", [], { datasource: "payfrit" });

    apiAbort({
        "OK": true,
        "MESSAGE": "QuickTaskTemplates table created/verified"
    });

} catch (any e) {
    apiAbort({
        "OK": false,
        "ERROR": "server_error",
        "MESSAGE": e.message
    });
}
</cfscript>