{ "query": "CREATE TABLE `autos8` (\n `auto_id` int(10) UNSIGNED NOT NULL UNIQUE KEY,\n `make` varchar(128) DEFAULT NULL,\n `year` int(11) DEFAULT NULL,\n `mileage` int(11) DEFAULT NULL,\n `city` point NOT NULL,\n SPATIAL INDEX `city_index` (`city`)\n) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": "CREATE TABLE `autos8` (\n `auto_id` int(10) UNSIGNED NOT NULL UNIQUE KEY,\n `make` varchar(128) DEFAULT NULL,\n `year` int(11) DEFAULT NULL,\n `mileage` int(11) DEFAULT NULL,\n `city` point NOT NULL,\n SPATIAL INDEX `city_index` (`city`)\n) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci;", "len": 323, "last": 323, "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": "`autos8`", "value": "autos8", "keyword": null, "type": 8, "flags": 2, "position": 13 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 21 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 22 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 23 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`auto_id`", "value": "auto_id", "keyword": null, "type": 8, "flags": 2, "position": 28 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 37 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "int", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 38 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 41 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "10", "value": 10, "keyword": null, "type": 6, "flags": 0, "position": 42 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 44 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 45 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "UNSIGNED", "value": "UNSIGNED", "keyword": "UNSIGNED", "type": 1, "flags": 3, "position": 46 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 54 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT NULL", "value": "NOT NULL", "keyword": "NOT NULL", "type": 1, "flags": 7, "position": 55 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 63 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "UNIQUE KEY", "value": "UNIQUE KEY", "keyword": "UNIQUE KEY", "type": 1, "flags": 23, "position": 64 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 74 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 75 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`make`", "value": "make", "keyword": null, "type": 8, "flags": 2, "position": 80 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 86 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "varchar", "value": "VARCHAR", "keyword": "VARCHAR", "type": 1, "flags": 11, "position": 87 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 94 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "128", "value": 128, "keyword": null, "type": 6, "flags": 0, "position": 95 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 98 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 99 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT", "value": "DEFAULT", "keyword": "DEFAULT", "type": 1, "flags": 35, "position": 100 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 107 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NULL", "value": "NULL", "keyword": "NULL", "type": 1, "flags": 3, "position": 108 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 112 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 113 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`year`", "value": "year", "keyword": null, "type": 8, "flags": 2, "position": 118 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 124 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "int", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 125 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 128 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "11", "value": 11, "keyword": null, "type": 6, "flags": 0, "position": 129 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 131 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 132 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT", "value": "DEFAULT", "keyword": "DEFAULT", "type": 1, "flags": 35, "position": 133 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 140 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NULL", "value": "NULL", "keyword": "NULL", "type": 1, "flags": 3, "position": 141 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 145 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 146 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`mileage`", "value": "mileage", "keyword": null, "type": 8, "flags": 2, "position": 151 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 160 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "int", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 161 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 164 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "11", "value": 11, "keyword": null, "type": 6, "flags": 0, "position": 165 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 167 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 168 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT", "value": "DEFAULT", "keyword": "DEFAULT", "type": 1, "flags": 35, "position": 169 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 176 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NULL", "value": "NULL", "keyword": "NULL", "type": 1, "flags": 3, "position": 177 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 181 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 182 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`city`", "value": "city", "keyword": null, "type": 8, "flags": 2, "position": 187 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 193 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "point", "value": "point", "keyword": "POINT", "type": 1, "flags": 41, "position": 194 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 199 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT NULL", "value": "NOT NULL", "keyword": "NOT NULL", "type": 1, "flags": 7, "position": 200 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 208 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 209 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SPATIAL INDEX", "value": "SPATIAL INDEX", "keyword": "SPATIAL INDEX", "type": 1, "flags": 23, "position": 214 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 227 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`city_index`", "value": "city_index", "keyword": null, "type": 8, "flags": 2, "position": 228 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 240 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 241 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`city`", "value": "city", "keyword": null, "type": 8, "flags": 2, "position": 242 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 248 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 249 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 250 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 251 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ENGINE", "value": "ENGINE", "keyword": "ENGINE", "type": 1, "flags": 1, "position": 252 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 258 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 259 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 260 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "InnoDB", "value": "InnoDB", "keyword": null, "type": 0, "flags": 0, "position": 261 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 267 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT CHARSET", "value": "DEFAULT CHARSET", "keyword": "DEFAULT CHARSET", "type": 1, "flags": 7, "position": 268 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 283 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 284 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 285 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "utf8mb4", "value": "utf8mb4", "keyword": null, "type": 0, "flags": 0, "position": 286 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 293 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COLLATE", "value": "COLLATE", "keyword": "COLLATE", "type": 1, "flags": 3, "position": 294 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 301 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 302 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 303 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "utf8mb4_general_ci", "value": "utf8mb4_general_ci", "keyword": null, "type": 0, "flags": 0, "position": 304 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 322 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 94, "idx": 94 }, "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": "autos8", "column": null, "expr": "`autos8`", "alias": null, "function": null, "subquery": null }, "entityOptions": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": { "name": "ENGINE", "equals": true, "expr": "InnoDB", "value": "InnoDB" }, "4": { "name": "DEFAULT CHARSET", "equals": true, "expr": "utf8mb4", "value": "utf8mb4" }, "6": { "name": "COLLATE", "equals": true, "expr": "utf8mb4_general_ci", "value": "utf8mb4_general_ci" } } }, "fields": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "auto_id", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "INT", "parameters": [ "10" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "4": "UNSIGNED" } } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "NOT NULL", "4": "UNIQUE KEY" } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "make", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "VARCHAR", "parameters": [ "128" ], "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": null, "expr": "NULL", "alias": null, "function": null, "subquery": null }, "value": "NULL" } } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "year", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "INT", "parameters": [ "11" ], "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": null, "expr": "NULL", "alias": null, "function": null, "subquery": null }, "value": "NULL" } } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "mileage", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "INT", "parameters": [ "11" ], "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": null, "expr": "NULL", "alias": null, "function": null, "subquery": null }, "value": "NULL" } } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "city", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "POINT", "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": null, "isConstraint": null, "type": null, "key": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Key", "name": "city_index", "columns": [ { "name": "city" } ], "type": "SPATIAL INDEX", "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" } }, "first": 0, "last": 92 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }