{
    "1": {
        "method": "update",
        "params": [
            "core_members",
            {
                "pp_thumb_photo": null
            },
            [
                "pp_photo_type=?",
                "letter"
            ]
        ]
    },
    "2": {
        "method": "changeIndex",
        "params": [
            "core_javascript",
            "javascript_lookup",
            {
                "type": "unique",
                "name": "javascript_lookup",
                "columns": [
                    "javascript_app",
                    "javascript_location",
                    "javascript_path",
                    "javascript_name"
                ],
                "length": [
                    null,
                    null,
                    null,
                    null
                ]
            }
        ]
    },
    "3": {
        "method": "changeIndex",
        "params": [
            "core_members_known_devices",
            "member_id",
            {
                "type": "key",
                "name": "member_id",
                "columns": [
                    "member_id",
                    "last_seen"
                ],
                "length": [
                    null,
                    null
                ]
            }
        ]
    },
    "4": {
        "method": "addIndex",
        "params": [
            "core_members_known_ip_addresses",
            {
                "type": "key",
                "name": "member_id",
                "columns": [
                    "member_id",
                    "last_seen"
                ],
                "length": [
                    null,
                    null
                ]
            }
        ]
    },
    "5": {
        "method": "delete",
        "params": [
            "core_sys_lang_words",
            [
                "word_app IS NOT NULL AND word_app NOT IN(?)",
                {
                    "query": "SELECT app_directory FROM `core_applications` AS `core_applications`",
                    "binds": []
                }
            ]
        ]
    }
}
