{
    "1": {
        "method": "addColumn",
        "params": [
            "nexus_packages",
            {
                "name": "p_email_purchase",
                "type": "MEDIUMTEXT",
                "length": null,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": null,
                "comment": "Email to send on new purchase",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            }
        ]
    },
    "2": {
        "method": "addColumn",
        "params": [
            "nexus_packages",
            {
                "name": "p_email_expire_soon",
                "type": "MEDIUMTEXT",
                "length": null,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": null,
                "comment": "Email to send when purchase will expire soon",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            }
        ]
    },
    "3": {
        "method": "addColumn",
        "params": [
            "nexus_packages",
            {
                "name": "p_email_expire",
                "type": "MEDIUMTEXT",
                "length": null,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": null,
                "comment": "Email to send when purchase expires",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            }
        ]
    },
    "4": {
        "method": "addColumn",
        "params": [
            "nexus_packages",
            {
                "name": "p_email_purchase_type",
                "type": "VARCHAR",
                "length": 16,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            }
        ]
    },
    "5": {
        "method": "addColumn",
        "params": [
            "nexus_packages",
            {
                "name": "p_email_expire_soon_type",
                "type": "VARCHAR",
                "length": 16,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            }
        ]
    },
    "6": {
        "method": "addColumn",
        "params": [
            "nexus_packages",
            {
                "name": "p_email_expire_type",
                "type": "VARCHAR",
                "length": 16,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            }
        ]
    },
    "7": {
        "method": "delete",
        "params": [
            "core_sys_conf_settings",
            [
                "conf_key=?",
                "nexus_https"
            ]
        ]
    },
    "8": {
        "method": "delete",
        "params": [
            "core_sys_lang_words",
            [
                "word_app=? AND ( word_key IN  (  'nexus_https', 'nexus_https_desc', 'nexus_https_err' ) )",
                "nexus"
            ]
        ]
    },
    "9": {
        "method": "addColumn",
        "params": [
            "nexus_packages",
            {
                "name": "p_date_updated",
                "type": "INT",
                "length": 10,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": "",
                "comment": "",
                "unsigned": true,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            }
        ]
    },
    "10": {
        "method": "update",
        "params": [
            "nexus_packages",
            "p_date_updated=p_date_added"
        ]
    },
    "11": {
        "method": "addColumn",
        "params": [
            "nexus_reviews",
            {
                "name": "review_author_response",
                "type": "MEDIUMTEXT",
                "length": null,
                "decimals": null,
                "values": null,
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            }
        ]
    },
    "12": {
        "method": "addColumn",
        "params": [
            "nexus_purchases",
            {
                "name": "ps_fee",
                "type": "DECIMAL",
                "length": 20,
                "decimals": 2,
                "values": null,
                "allow_null": true,
                "default": null,
                "comment": "",
                "unsigned": true,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            }
        ]
    },
    "13": {
        "method": "delete",
        "params": [
            "core_sys_lang_words",
            [
                "word_app=? AND word_key=?",
                "nexus",
                "support"
            ]
        ]
    },
    "14": {
        "method": "createTable",
        "params": [
            {
                "name": "nexus_member_subscription_packages",
                "columns": {
                    "sp_id": {
                        "allow_null": false,
                        "auto_increment": true,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 10,
                        "name": "sp_id",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sp_enabled": {
                        "allow_null": false,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": "1",
                        "length": 1,
                        "name": "sp_enabled",
                        "type": "TINYINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sp_tax": {
                        "allow_null": false,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": "0",
                        "length": 5,
                        "name": "sp_tax",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sp_gateways": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 0,
                        "name": "sp_gateways",
                        "type": "TEXT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sp_price": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 0,
                        "name": "sp_price",
                        "type": "TEXT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sp_primary_group": {
                        "allow_null": false,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": "0",
                        "length": 10,
                        "name": "sp_primary_group",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sp_secondary_group": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 0,
                        "name": "sp_secondary_group",
                        "type": "TEXT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sp_position": {
                        "allow_null": false,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": "0",
                        "length": 10,
                        "name": "sp_position",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sp_renew_options": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 0,
                        "name": "sp_renew_options",
                        "type": "TEXT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sp_reg_show": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": "0",
                        "length": 1,
                        "name": "sp_reg_show",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sp_featured": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": "0",
                        "length": 1,
                        "name": "sp_featured",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sp_count_active": {
                        "allow_null": false,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": "0",
                        "length": 10,
                        "name": "sp_count_active",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sp_count_inactive": {
                        "allow_null": false,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": "0",
                        "length": 10,
                        "name": "sp_count_inactive",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sp_return_primary": {
                        "name": "sp_return_primary",
                        "type": "TINYINT",
                        "length": 1,
                        "decimals": null,
                        "values": null,
                        "allow_null": false,
                        "default": "0",
                        "comment": "",
                        "unsigned": true,
                        "zerofill": false,
                        "auto_increment": false,
                        "binary": false
                    },
                    "sp_image": {
                        "name": "sp_image",
                        "type": "TEXT",
                        "length": null,
                        "decimals": null,
                        "values": null,
                        "allow_null": true,
                        "default": null,
                        "comment": "",
                        "unsigned": false,
                        "zerofill": false,
                        "auto_increment": false,
                        "binary": false
                    }
                },
                "indexes": {
                    "PRIMARY": {
                        "type": "primary",
                        "name": "PRIMARY",
                        "length": [
                            null
                        ],
                        "columns": [
                            "sp_id"
                        ]
                    },
                    "sp_enabled": {
                        "type": "key",
                        "name": "sp_enabled",
                        "length": [
                            null
                        ],
                        "columns": [
                            "sp_enabled"
                        ]
                    }
                },
                "collation": "utf8_general_ci",
                "engine": "InnoDB"
            }
        ]
    },
    "15": {
        "method": "createTable",
        "params": [
            {
                "name": "nexus_member_subscriptions",
                "columns": {
                    "sub_id": {
                        "allow_null": false,
                        "auto_increment": true,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 10,
                        "name": "sub_id",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sub_member_id": {
                        "allow_null": false,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": "0",
                        "length": 20,
                        "name": "sub_member_id",
                        "type": "BIGINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sub_active": {
                        "allow_null": false,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": "0",
                        "length": 1,
                        "name": "sub_active",
                        "type": "TINYINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sub_cancelled": {
                        "allow_null": false,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": "0",
                        "length": 1,
                        "name": "sub_cancelled",
                        "type": "TINYINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sub_start": {
                        "allow_null": false,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": "0",
                        "length": 10,
                        "name": "sub_start",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sub_expire": {
                        "allow_null": false,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": "0",
                        "length": 10,
                        "name": "sub_expire",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "sub_package_id": {
                        "name": "sub_package_id",
                        "type": "INT",
                        "length": 10,
                        "decimals": null,
                        "values": null,
                        "allow_null": false,
                        "default": "0",
                        "comment": "",
                        "unsigned": true,
                        "zerofill": false,
                        "auto_increment": false,
                        "binary": false
                    },
                    "sub_previous_group": {
                        "name": "sub_previous_group",
                        "type": "INT",
                        "length": 10,
                        "decimals": null,
                        "values": null,
                        "allow_null": false,
                        "default": "0",
                        "comment": "",
                        "unsigned": true,
                        "zerofill": false,
                        "auto_increment": false,
                        "binary": false
                    },
                    "sub_previous_secondary_groups": {
                        "name": "sub_previous_secondary_groups",
                        "type": "TEXT",
                        "length": null,
                        "decimals": null,
                        "values": null,
                        "allow_null": true,
                        "default": null,
                        "comment": "",
                        "unsigned": false,
                        "zerofill": false,
                        "auto_increment": false,
                        "binary": false
                    },
                    "sub_renews": {
                        "name": "sub_renews",
                        "type": "TINYINT",
                        "length": 1,
                        "decimals": null,
                        "values": null,
                        "allow_null": false,
                        "default": "0",
                        "comment": "",
                        "unsigned": true,
                        "zerofill": false,
                        "auto_increment": false,
                        "binary": false
                    },
                    "sub_invoice_id": {
                        "name": "sub_invoice_id",
                        "type": "BIGINT",
                        "length": 20,
                        "decimals": null,
                        "values": null,
                        "allow_null": false,
                        "default": "0",
                        "comment": "",
                        "unsigned": true,
                        "zerofill": false,
                        "auto_increment": false,
                        "binary": false
                    },
                    "sub_purchase_id": {
                        "name": "sub_purchase_id",
                        "type": "BIGINT",
                        "length": 20,
                        "decimals": null,
                        "values": null,
                        "allow_null": false,
                        "default": "0",
                        "comment": "",
                        "unsigned": true,
                        "zerofill": false,
                        "auto_increment": false,
                        "binary": false
                    },
                    "sub_added_manually": {
                        "name": "sub_added_manually",
                        "type": "TINYINT",
                        "length": 1,
                        "decimals": null,
                        "values": null,
                        "allow_null": false,
                        "default": "0",
                        "comment": "",
                        "unsigned": true,
                        "zerofill": false,
                        "auto_increment": false,
                        "binary": false
                    }
                },
                "indexes": {
                    "PRIMARY": {
                        "type": "primary",
                        "name": "PRIMARY",
                        "length": [
                            null
                        ],
                        "columns": [
                            "sub_id"
                        ]
                    },
                    "sub_active": {
                        "type": "key",
                        "name": "sub_active",
                        "length": [
                            null
                        ],
                        "columns": [
                            "sub_active"
                        ]
                    },
                    "sub_cancelled": {
                        "type": "key",
                        "name": "sub_cancelled",
                        "length": [
                            null
                        ],
                        "columns": [
                            "sub_cancelled"
                        ]
                    },
                    "sub_expire": {
                        "type": "key",
                        "name": "sub_expire",
                        "length": [
                            null
                        ],
                        "columns": [
                            "sub_expire"
                        ]
                    },
                    "member_sub_id": {
                        "type": "key",
                        "name": "member_sub_id",
                        "columns": [
                            "sub_member_id",
                            "sub_package_id"
                        ],
                        "length": [
                            null,
                            null
                        ]
                    }
                },
                "collation": "utf8_general_ci",
                "engine": "InnoDB"
            }
        ]
    },
    "16": {
        "method": "changeColumn",
        "params": [
            "nexus_support_requests",
            "r_status",
            {
                "name": "r_status",
                "type": "INT",
                "length": 5,
                "decimals": null,
                "values": [],
                "allow_null": false,
                "default": "0",
                "comment": "",
                "unsigned": false,
                "zerofill": false,
                "auto_increment": false,
                "binary": false
            }
        ]
    },
    "17": {
        "method": "addIndex",
        "params": [
            "nexus_packages",
            {
                "type": "key",
                "name": "p_group",
                "columns": [
                    "p_group"
                ],
                "length": [
                    null
                ]
            }
        ]
    },
    "18": {
        "method": "addIndex",
        "params": [
            "nexus_support_requests",
            {
                "type": "key",
                "name": "status_and_department",
                "columns": [
                    "r_status",
                    "r_department"
                ],
                "length": [
                    null,
                    null
                ]
            }
        ]
    },
    "19": {
        "method": "addIndex",
        "params": [
            "nexus_alternate_contacts",
            {
                "type": "key",
                "name": "alt_id",
                "columns": [
                    "alt_id"
                ],
                "length": [
                    null
                ]
            }
        ]
    },
    "20": {
        "method": "changeIndex",
        "params": [
            "nexus_support_replies",
            "reply_request",
            {
                "type": "key",
                "name": "reply_request",
                "columns": [
                    "reply_request",
                    "reply_hidden",
                    "reply_date"
                ],
                "length": [
                    null,
                    null,
                    null
                ]
            }
        ]
    },
    "21": {
        "method": "addIndex",
        "params": [
            "nexus_support_tracker",
            {
                "type": "key",
                "name": "notifications",
                "columns": [
                    "request_id",
                    "notify"
                ],
                "length": [
                    null,
                    null
                ]
            }
        ]
    },
    "22": {
        "method": "addIndex",
        "params": [
            "nexus_support_statuses",
            {
                "type": "key",
                "name": "member_default",
                "columns": [
                    "status_default_member"
                ],
                "length": [
                    null
                ]
            }
        ]
    },
    "23": {
        "method": "addIndex",
        "params": [
            "nexus_payouts",
            {
                "type": "key",
                "name": "po_member",
                "columns": [
                    "po_member",
                    "po_date"
                ],
                "length": [
                    null,
                    null
                ]
            }
        ]
    }
}