{
    "schema": "https:\/\/raw.githubusercontent.com\/VitexSoftware\/php-vitexsoftware-multiflexi-core\/refs\/heads\/main\/schema\/credential-prototype.json",
    "version": "1.0",
    "uuid": "cd2b27a0-dc5a-45b4-a48e-e4f532260d52",
    "code": "DatabaseConnection",
    "name": {
        "en": "Database Connection (PDO)"
    },
    "description": {
        "en": "PDO database connection credentials for MySQL, PostgreSQL, SQLite, SQL Server"
    },
    "logo": "DatabaseConnection.svg",
    "fields": [
        {
            "keyword": "DB_CONNECTION",
            "name": {
                "en": "Database Connection"
            },
            "type": "string",
            "description": {
                "en": "PDO driver (mysql, pgsql, sqlsrv, sqlite)"
            },
            "required": false,
            "hint": "mysql"
        },
        {
            "keyword": "DB_DATABASE",
            "name": {
                "en": "Database Name"
            },
            "type": "string",
            "description": {
                "en": "Name of the database"
            },
            "required": false,
            "hint": "mydatabase"
        },
        {
            "keyword": "DB_HOST",
            "name": {
                "en": "Database Host"
            },
            "type": "string",
            "description": {
                "en": "Hostname or IP address of the database server"
            },
            "required": false,
            "hint": "localhost"
        },
        {
            "keyword": "DB_PASSWORD",
            "name": {
                "en": "Database Password"
            },
            "type": "password",
            "description": {
                "en": "Password for database authentication"
            },
            "required": false,
            "hint": "secret"
        },
        {
            "keyword": "DB_PORT",
            "name": {
                "en": "Database Port"
            },
            "type": "string",
            "description": {
                "en": "Port number (default: 3306 for MySQL, 5432 for PostgreSQL, 1433 for SQL Server)"
            },
            "required": false,
            "hint": "3306"
        },
        {
            "keyword": "DB_SETTINGS",
            "name": {
                "en": "Database Settings"
            },
            "type": "string",
            "description": {
                "en": "Additional DSN settings (e.g. ;TrustServerCertificate=true)"
            },
            "required": false
        },
        {
            "keyword": "DB_USERNAME",
            "name": {
                "en": "Database Username"
            },
            "type": "string",
            "description": {
                "en": "Username for database authentication"
            },
            "required": false,
            "hint": "dbuser"
        }
    ]
}