{
    "1": {
        "method": "insert",
        "params": [
            "nexus_gateways",
            {
                "g_key": "stripe",
                "g_name": "Stripe",
                "g_testmode": 0,
                "g_position": null,
                "g_payout": 0
            }
        ]
    },
    "2": {
        "method": "createTable",
        "params": [
            {
                "name": "nexus_fraud_rules",
                "columns": {
                    "f_id": {
                        "allow_null": false,
                        "auto_increment": true,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 10,
                        "name": "f_id",
                        "type": "INT",
                        "unsigned": true,
                        "values": [],
                        "zerofill": false
                    },
                    "f_name": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 255,
                        "name": "f_name",
                        "type": "VARCHAR",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_groups": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 0,
                        "name": "f_groups",
                        "type": "TEXT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_amount": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "f_amount",
                        "type": "CHAR",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_amount_unit": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 3,
                        "name": "f_amount_unit",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_methods": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 0,
                        "name": "f_methods",
                        "type": "TEXT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_voucher": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "f_voucher",
                        "type": "TINYINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_email": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": "",
                        "length": 1,
                        "name": "f_email",
                        "type": "CHAR",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_email_unit": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 255,
                        "name": "f_email_unit",
                        "type": "VARCHAR",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_country": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 0,
                        "name": "f_country",
                        "type": "TEXT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_maxmind": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "f_maxmind",
                        "type": "CHAR",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_maxmind_unit": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 3,
                        "name": "f_maxmind_unit",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_maxmind_address_valid": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "f_maxmind_address_valid",
                        "type": "TINYINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_maxmind_address_match": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "f_maxmind_address_match",
                        "type": "TINYINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_maxmind_proxy": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "f_maxmind_proxy",
                        "type": "CHAR",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_maxmind_proxy_unit": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 2,
                        "name": "f_maxmind_proxy_unit",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_maxmind_freeemail": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "f_maxmind_freeemail",
                        "type": "TINYINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_maxmind_phone_match": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "f_maxmind_phone_match",
                        "type": "TINYINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_maxmind_riskyemail": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "f_maxmind_riskyemail",
                        "type": "TINYINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_maxmind_riskyusername": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "f_maxmind_riskyusername",
                        "type": "TINYINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_trans_okay": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "f_trans_okay",
                        "type": "CHAR",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_trans_okay_unit": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 3,
                        "name": "f_trans_okay_unit",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_trans_fraud": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "f_trans_fraud",
                        "type": "CHAR",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_trans_fraud_unit": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 3,
                        "name": "f_trans_fraud_unit",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_action": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 4,
                        "name": "f_action",
                        "type": "CHAR",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_action_ban": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "f_action_ban",
                        "type": "TINYINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "f_order": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 10,
                        "name": "f_order",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    }
                },
                "indexes": {
                    "PRIMARY": {
                        "type": "primary",
                        "name": "PRIMARY",
                        "length": [
                            null
                        ],
                        "columns": [
                            "f_id"
                        ]
                    }
                },
                "collation": "utf8mb4_unicode_ci"
            }
        ]
    },
    "3": {
        "method": "addColumn",
        "params": [
            "nexus_transactions",
            {
                "name": "t_fraud_blocked",
                "type": "INT",
                "length": 10,
                "allow_null": false,
                "default": 0
            }
        ]
    },
    "4": {
        "method": "addColumn",
        "params": [
            "nexus_transactions",
            {
                "name": "t_fraud_checked",
                "type": "TINYINT",
                "length": 1,
                "allow_null": false,
                "default": 0
            }
        ]
    },
    "5": {
        "method": "addIndex",
        "params": [
            "nexus_transactions",
            {
                "type": "key",
                "name": "t_invoice",
                "columns": [
                    "t_invoice"
                ]
            }
        ]
    },
    "6": {
        "method": "addIndex",
        "params": [
            "nexus_transactions",
            {
                "type": "key",
                "name": "t_member",
                "columns": [
                    "t_member",
                    "t_status"
                ]
            }
        ]
    },
    "7": {
        "method": "addIndex",
        "params": [
            "nexus_transactions",
            {
                "type": "key",
                "name": "t_member2",
                "columns": [
                    "t_member",
                    "t_status",
                    "t_fraud_blocked"
                ]
            }
        ]
    },
    "8": {
        "method": "addColumn",
        "params": [
            "nexus_packages",
            {
                "name": "p_methods",
                "type": "TEXT",
                "allow_null": true
            }
        ]
    },
    "9": {
        "method": "createTable",
        "params": [
            {
                "name": "nexus_referral_rules",
                "columns": {
                    "rrule_id": {
                        "allow_null": false,
                        "auto_increment": true,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 10,
                        "name": "rrule_id",
                        "type": "INT",
                        "unsigned": true,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_name": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 255,
                        "name": "rrule_name",
                        "type": "VARCHAR",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_by_purchases_type": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "rrule_by_purchases_type",
                        "type": "CHAR",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_by_purchases_op": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "rrule_by_purchases_op",
                        "type": "CHAR",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_by_purchases_unit": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 10,
                        "name": "rrule_by_purchases_unit",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_by_group": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 0,
                        "name": "rrule_by_group",
                        "type": "TEXT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_for_purchases_type": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "rrule_for_purchases_type",
                        "type": "CHAR",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_for_purchases_op": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "rrule_for_purchases_op",
                        "type": "CHAR",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_for_purchases_unit": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 10,
                        "name": "rrule_for_purchases_unit",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_for_group": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 0,
                        "name": "rrule_for_group",
                        "type": "TEXT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_purchase_packages": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 0,
                        "name": "rrule_purchase_packages",
                        "type": "TEXT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_purchase_any": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "rrule_purchase_any",
                        "type": "TINYINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_purchase_package_limit": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "rrule_purchase_package_limit",
                        "type": "TINYINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_purchase_renewal": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "rrule_purchase_renewal",
                        "type": "TINYINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_purchase_amount_op": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "rrule_purchase_amount_op",
                        "type": "CHAR",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_purchase_amount_unit": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 10,
                        "name": "rrule_purchase_amount_unit",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_commission": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 3,
                        "name": "rrule_commission",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rrule_commission_limit": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 10,
                        "name": "rrule_commission_limit",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    }
                },
                "indexes": {
                    "PRIMARY": {
                        "type": "primary",
                        "name": "PRIMARY",
                        "length": [
                            null
                        ],
                        "columns": [
                            "rrule_id"
                        ]
                    }
                },
                "collation": "utf8mb4_unicode_ci"
            }
        ]
    },
    "10": {
        "method": "addColumn",
        "params": [
            "nexus_support_departments",
            {
                "name": "dpt_ppi",
                "type": "FLOAT",
                "allow_null": false,
                "default": 0
            }
        ]
    },
    "11": {
        "method": "addColumn",
        "params": [
            "nexus_support_tracker",
            {
                "name": "notify",
                "type": "TINYINT",
                "length": 1,
                "allow_null": false,
                "default": 0
            }
        ]
    },
    "12": {
        "method": "addColumn",
        "params": [
            "nexus_support_replies",
            {
                "name": "reply_textformat",
                "type": "CHAR",
                "length": 1,
                "allow_null": false,
                "default": ""
            }
        ]
    },
    "13": {
        "method": "createTable",
        "params": [
            {
                "name": "nexus_support_ratings",
                "columns": {
                    "rating_reply": {
                        "allow_null": false,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": "0",
                        "length": 10,
                        "name": "rating_reply",
                        "type": "INT",
                        "unsigned": true,
                        "values": [],
                        "zerofill": false
                    },
                    "rating_rating": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 1,
                        "name": "rating_rating",
                        "type": "SMALLINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rating_from": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 8,
                        "name": "rating_from",
                        "type": "MEDIUMINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rating_staff": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 8,
                        "name": "rating_staff",
                        "type": "MEDIUMINT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rating_note": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 0,
                        "name": "rating_note",
                        "type": "TEXT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    },
                    "rating_date": {
                        "allow_null": true,
                        "auto_increment": false,
                        "binary": false,
                        "comment": "",
                        "decimals": null,
                        "default": null,
                        "length": 10,
                        "name": "rating_date",
                        "type": "INT",
                        "unsigned": false,
                        "values": [],
                        "zerofill": false
                    }
                },
                "indexes": {
                    "PRIMARY": {
                        "type": "primary",
                        "name": "PRIMARY",
                        "length": [
                            null
                        ],
                        "columns": [
                            "rating_reply"
                        ]
                    },
                    "rating_staff": {
                        "type": "key",
                        "name": "rating_staff",
                        "length": [
                            null
                        ],
                        "columns": [
                            "rating_staff"
                        ]
                    },
                    "rating_date": {
                        "type": "key",
                        "name": "rating_date",
                        "length": [
                            null
                        ],
                        "columns": [
                            "rating_date"
                        ]
                    }
                },
                "collation": "utf8mb4_unicode_ci"
            }
        ]
    }
}