{
    "query": "CREATE TABLE IF NOT EXISTS users (\n    `id` INT NOT NULL AUTO_INCREMENT,\n    username VARCHAR(64) NULL,\n    `password` VARCHAR(256) DEFAULT '123456',\n    CONSTRAINT pk_id PRIMARY KEY (`id`),\n    UNIQUE (username)\n) ENGINE=InnoDB;",
    "lexer": {
        "@type": "PhpMyAdmin\\SqlParser\\Lexer",
        "str": "CREATE TABLE IF NOT EXISTS users (\n    `id` INT NOT NULL AUTO_INCREMENT,\n    username VARCHAR(64) NULL,\n    `password` VARCHAR(256) DEFAULT '123456',\n    CONSTRAINT pk_id PRIMARY KEY (`id`),\n    UNIQUE (username)\n) ENGINE=InnoDB;",
        "len": 229,
        "last": 229,
        "list": {
            "@type": "PhpMyAdmin\\SqlParser\\TokensList",
            "tokens": [
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "CREATE",
                    "value": "CREATE",
                    "keyword": "CREATE",
                    "type": 1,
                    "flags": 3,
                    "position": 0
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 6
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "TABLE",
                    "value": "TABLE",
                    "keyword": "TABLE",
                    "type": 1,
                    "flags": 3,
                    "position": 7
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 12
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "IF NOT EXISTS",
                    "value": "IF NOT EXISTS",
                    "keyword": "IF NOT EXISTS",
                    "type": 1,
                    "flags": 7,
                    "position": 13
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 26
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "users",
                    "value": "users",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 27
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 32
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 33
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n    ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 34
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`id`",
                    "value": "id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 39
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 43
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "INT",
                    "value": "INT",
                    "keyword": "INT",
                    "type": 1,
                    "flags": 11,
                    "position": 44
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 47
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "NOT NULL",
                    "value": "NOT NULL",
                    "keyword": "NOT NULL",
                    "type": 1,
                    "flags": 7,
                    "position": 48
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 56
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "AUTO_INCREMENT",
                    "value": "AUTO_INCREMENT",
                    "keyword": "AUTO_INCREMENT",
                    "type": 1,
                    "flags": 1,
                    "position": 57
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 71
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n    ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 72
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "username",
                    "value": "username",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 77
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 85
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "VARCHAR",
                    "value": "VARCHAR",
                    "keyword": "VARCHAR",
                    "type": 1,
                    "flags": 11,
                    "position": 86
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 93
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "64",
                    "value": 64,
                    "keyword": null,
                    "type": 6,
                    "flags": 0,
                    "position": 94
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 96
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 97
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "NULL",
                    "value": "NULL",
                    "keyword": "NULL",
                    "type": 1,
                    "flags": 3,
                    "position": 98
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 102
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n    ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 103
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`password`",
                    "value": "password",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 108
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 118
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "VARCHAR",
                    "value": "VARCHAR",
                    "keyword": "VARCHAR",
                    "type": 1,
                    "flags": 11,
                    "position": 119
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 126
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "256",
                    "value": 256,
                    "keyword": null,
                    "type": 6,
                    "flags": 0,
                    "position": 127
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 130
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 131
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "DEFAULT",
                    "value": "DEFAULT",
                    "keyword": "DEFAULT",
                    "type": 1,
                    "flags": 35,
                    "position": 132
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 139
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "'123456'",
                    "value": "123456",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 140
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 148
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n    ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 149
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "CONSTRAINT",
                    "value": "CONSTRAINT",
                    "keyword": "CONSTRAINT",
                    "type": 1,
                    "flags": 3,
                    "position": 154
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 164
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "pk_id",
                    "value": "pk_id",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 165
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 170
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "PRIMARY KEY",
                    "value": "PRIMARY KEY",
                    "keyword": "PRIMARY KEY",
                    "type": 1,
                    "flags": 23,
                    "position": 171
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 182
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 183
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`id`",
                    "value": "id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 184
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 188
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 189
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n    ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 190
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "UNIQUE",
                    "value": "UNIQUE",
                    "keyword": "UNIQUE",
                    "type": 1,
                    "flags": 19,
                    "position": 195
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 201
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 202
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "username",
                    "value": "username",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 203
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 211
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 212
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 213
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 214
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ENGINE",
                    "value": "ENGINE",
                    "keyword": "ENGINE",
                    "type": 1,
                    "flags": 1,
                    "position": 215
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 221
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "InnoDB",
                    "value": "InnoDB",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 222
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ";",
                    "value": ";",
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": 228
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": null,
                    "value": null,
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": null
                }
            ],
            "count": 65,
            "idx": 65
        },
        "delimiter": ";",
        "delimiterLen": 1,
        "strict": false,
        "errors": []
    },
    "parser": {
        "@type": "PhpMyAdmin\\SqlParser\\Parser",
        "list": {
            "@type": "@1"
        },
        "statements": [
            {
                "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement",
                "name": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                    "database": null,
                    "table": "users",
                    "column": null,
                    "expr": "users",
                    "alias": null,
                    "function": null,
                    "subquery": null
                },
                "entityOptions": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                    "options": {
                        "1": {
                            "name": "ENGINE",
                            "equals": true,
                            "expr": "InnoDB",
                            "value": "InnoDB"
                        }
                    }
                },
                "fields": [
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
                        "name": "id",
                        "isConstraint": null,
                        "type": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType",
                            "name": "INT",
                            "parameters": [],
                            "options": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                "options": []
                            }
                        },
                        "key": null,
                        "references": null,
                        "options": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                            "options": {
                                "1": "NOT NULL",
                                "3": "AUTO_INCREMENT"
                            }
                        }
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
                        "name": "username",
                        "isConstraint": null,
                        "type": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType",
                            "name": "VARCHAR",
                            "parameters": [
                                "64"
                            ],
                            "options": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                "options": []
                            }
                        },
                        "key": null,
                        "references": null,
                        "options": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                            "options": {
                                "1": "NULL"
                            }
                        }
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
                        "name": "password",
                        "isConstraint": null,
                        "type": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType",
                            "name": "VARCHAR",
                            "parameters": [
                                "256"
                            ],
                            "options": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                "options": []
                            }
                        },
                        "key": null,
                        "references": null,
                        "options": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                            "options": {
                                "2": {
                                    "name": "DEFAULT",
                                    "equals": false,
                                    "expr": {
                                        "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                                        "database": null,
                                        "table": null,
                                        "column": "123456",
                                        "expr": "'123456'",
                                        "alias": null,
                                        "function": null,
                                        "subquery": null
                                    },
                                    "value": "'123456'"
                                }
                            }
                        }
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
                        "name": "pk_id",
                        "isConstraint": true,
                        "type": null,
                        "key": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Key",
                            "name": null,
                            "columns": [
                                {
                                    "name": "id"
                                }
                            ],
                            "type": "PRIMARY KEY",
                            "expr": null,
                            "options": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                "options": []
                            }
                        },
                        "references": null,
                        "options": null
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
                        "name": null,
                        "isConstraint": null,
                        "type": null,
                        "key": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Key",
                            "name": null,
                            "columns": [
                                {
                                    "name": "username"
                                }
                            ],
                            "type": "UNIQUE",
                            "expr": null,
                            "options": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                "options": []
                            }
                        },
                        "references": null,
                        "options": null
                    }
                ],
                "with": null,
                "select": null,
                "like": null,
                "partitionBy": null,
                "partitionsNum": null,
                "subpartitionBy": null,
                "subpartitionsNum": null,
                "partitions": null,
                "table": null,
                "return": null,
                "parameters": null,
                "body": [],
                "options": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                    "options": {
                        "6": "TABLE",
                        "7": "IF NOT EXISTS"
                    }
                },
                "first": 0,
                "last": 63
            }
        ],
        "brackets": 0,
        "strict": false,
        "errors": []
    },
    "errors": {
        "lexer": [],
        "parser": []
    }
}