PRAGMA foreign_keys=ON;

CREATE TABLE aplication (
    aplication_id INTEGER PRIMARY KEY AUTOINCREMENT,
    aplication_name TEXT NOT NULL,
    aplication_flag TEXT NOT NULL,
    aplication_url TEXT NOT NULL,  -- Nova coluna para senha hasheada
    aplication_auth_method TEXT NOT NULL DEFAULT 'external_jwt' -- values: external_jwt | jwt | hmac
);