{
    "query": "CREATE TABLE IF NOT EXISTS `public_areas` (\n  `id` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,\n  `kind` enum('COUNTRY','REGION','DEPARTMENT','MUNICIPALITY') NOT NULL,\n  `area` geometry NOT NULL SRID 4326,\n  `properties` json NOT NULL,\n  `title` varchar(100) NOT NULL\n);",
    "lexer": {
        "@type": "PhpMyAdmin\\SqlParser\\Lexer",
        "str": "CREATE TABLE IF NOT EXISTS `public_areas` (\n  `id` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,\n  `kind` enum('COUNTRY','REGION','DEPARTMENT','MUNICIPALITY') NOT NULL,\n  `area` geometry NOT NULL SRID 4326,\n  `properties` json NOT NULL,\n  `title` varchar(100) NOT NULL\n);",
        "len": 275,
        "last": 275,
        "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": "`public_areas`",
                    "value": "public_areas",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 27
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 41
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 42
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 43
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`id`",
                    "value": "id",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 46
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 50
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "INT",
                    "value": "INT",
                    "keyword": "INT",
                    "type": 1,
                    "flags": 11,
                    "position": 51
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 54
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "UNSIGNED",
                    "value": "UNSIGNED",
                    "keyword": "UNSIGNED",
                    "type": 1,
                    "flags": 3,
                    "position": 55
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 63
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "NOT NULL",
                    "value": "NOT NULL",
                    "keyword": "NOT NULL",
                    "type": 1,
                    "flags": 7,
                    "position": 64
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 72
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "PRIMARY KEY",
                    "value": "PRIMARY KEY",
                    "keyword": "PRIMARY KEY",
                    "type": 1,
                    "flags": 23,
                    "position": 73
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 84
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "AUTO_INCREMENT",
                    "value": "AUTO_INCREMENT",
                    "keyword": "AUTO_INCREMENT",
                    "type": 1,
                    "flags": 1,
                    "position": 85
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 99
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 100
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`kind`",
                    "value": "kind",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 103
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 109
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "enum",
                    "value": "enum",
                    "keyword": "ENUM",
                    "type": 1,
                    "flags": 9,
                    "position": 110
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 114
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "'COUNTRY'",
                    "value": "COUNTRY",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 115
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 124
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "'REGION'",
                    "value": "REGION",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 125
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 133
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "'DEPARTMENT'",
                    "value": "DEPARTMENT",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 134
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 146
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "'MUNICIPALITY'",
                    "value": "MUNICIPALITY",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 147
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 161
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 162
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "NOT NULL",
                    "value": "NOT NULL",
                    "keyword": "NOT NULL",
                    "type": 1,
                    "flags": 7,
                    "position": 163
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 171
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 172
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`area`",
                    "value": "area",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 175
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 181
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "geometry",
                    "value": "geometry",
                    "keyword": "GEOMETRY",
                    "type": 1,
                    "flags": 9,
                    "position": 182
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 190
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "NOT NULL",
                    "value": "NOT NULL",
                    "keyword": "NOT NULL",
                    "type": 1,
                    "flags": 7,
                    "position": 191
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 199
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "SRID",
                    "value": "SRID",
                    "keyword": "SRID",
                    "type": 1,
                    "flags": 33,
                    "position": 200
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 204
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "4326",
                    "value": 4326,
                    "keyword": null,
                    "type": 6,
                    "flags": 0,
                    "position": 205
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 209
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 210
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`properties`",
                    "value": "properties",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 213
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 225
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "json",
                    "value": "json",
                    "keyword": "JSON",
                    "type": 1,
                    "flags": 9,
                    "position": 226
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 230
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "NOT NULL",
                    "value": "NOT NULL",
                    "keyword": "NOT NULL",
                    "type": 1,
                    "flags": 7,
                    "position": 231
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 239
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 240
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`title`",
                    "value": "title",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 243
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 250
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "varchar",
                    "value": "VARCHAR",
                    "keyword": "VARCHAR",
                    "type": 1,
                    "flags": 11,
                    "position": 251
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 258
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "100",
                    "value": 100,
                    "keyword": null,
                    "type": 6,
                    "flags": 0,
                    "position": 259
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 262
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 263
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "NOT NULL",
                    "value": "NOT NULL",
                    "keyword": "NOT NULL",
                    "type": 1,
                    "flags": 7,
                    "position": 264
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 272
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 273
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ";",
                    "value": ";",
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": 274
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": null,
                    "value": null,
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": null
                }
            ],
            "count": 69,
            "idx": 69
        },
        "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": "public_areas",
                    "column": null,
                    "expr": "`public_areas`",
                    "alias": null,
                    "function": null,
                    "subquery": null
                },
                "entityOptions": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                    "options": []
                },
                "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": {
                                    "4": "UNSIGNED"
                                }
                            }
                        },
                        "key": null,
                        "references": null,
                        "options": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                            "options": {
                                "1": "NOT NULL",
                                "4": "PRIMARY KEY",
                                "3": "AUTO_INCREMENT"
                            }
                        }
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
                        "name": "kind",
                        "isConstraint": null,
                        "type": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType",
                            "name": "ENUM",
                            "parameters": [
                                "'COUNTRY'",
                                "'REGION'",
                                "'DEPARTMENT'",
                                "'MUNICIPALITY'"
                            ],
                            "options": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                "options": []
                            }
                        },
                        "key": null,
                        "references": null,
                        "options": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                            "options": {
                                "1": "NOT NULL"
                            }
                        }
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
                        "name": "area",
                        "isConstraint": null,
                        "type": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType",
                            "name": "GEOMETRY",
                            "parameters": [],
                            "options": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                "options": []
                            }
                        },
                        "key": null,
                        "references": null,
                        "options": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                            "options": {
                                "1": "NOT NULL",
                                "17": {
                                    "name": "SRID",
                                    "equals": false,
                                    "expr": "4326",
                                    "value": "4326"
                                }
                            }
                        }
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
                        "name": "properties",
                        "isConstraint": null,
                        "type": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType",
                            "name": "JSON",
                            "parameters": [],
                            "options": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                "options": []
                            }
                        },
                        "key": null,
                        "references": null,
                        "options": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                            "options": {
                                "1": "NOT NULL"
                            }
                        }
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
                        "name": "title",
                        "isConstraint": null,
                        "type": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType",
                            "name": "VARCHAR",
                            "parameters": [
                                "100"
                            ],
                            "options": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                "options": []
                            }
                        },
                        "key": null,
                        "references": null,
                        "options": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                            "options": {
                                "1": "NOT 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": 67
            }
        ],
        "brackets": 0,
        "strict": false,
        "errors": []
    },
    "errors": {
        "lexer": [],
        "parser": []
    }
}