{ "query": "CREATE TABLE `mytable` (\n `column_one` VARCHAR(255) DEFAULT NULL,\n FULLTEXT KEY `fulltext_index` (`column_one`) /*!50100 WITH PARSER `ngram` */,\n CONSTRAINT `my_constraint_1` FOREIGN KEY (`column_one`) REFERENCES `other_table` (`column_two`) ON DELETE RESTRICT ON UPDATE RESTRICT\n)\n", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": "CREATE TABLE `mytable` (\n `column_one` VARCHAR(255) DEFAULT NULL,\n FULLTEXT KEY `fulltext_index` (`column_one`) /*!50100 WITH PARSER `ngram` */,\n CONSTRAINT `my_constraint_1` FOREIGN KEY (`column_one`) REFERENCES `other_table` (`column_two`) ON DELETE RESTRICT ON UPDATE RESTRICT\n)\n", "len": 285, "last": 285, "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": "`mytable`", "value": "mytable", "keyword": null, "type": 8, "flags": 2, "position": 13 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 22 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 23 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 24 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`column_one`", "value": "column_one", "keyword": null, "type": 8, "flags": 2, "position": 27 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 39 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VARCHAR", "value": "VARCHAR", "keyword": "VARCHAR", "type": 1, "flags": 11, "position": 40 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 47 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "255", "value": 255, "keyword": null, "type": 6, "flags": 0, "position": 48 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 51 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 52 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT", "value": "DEFAULT", "keyword": "DEFAULT", "type": 1, "flags": 35, "position": 53 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 60 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NULL", "value": "NULL", "keyword": "NULL", "type": 1, "flags": 3, "position": 61 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 65 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 66 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FULLTEXT KEY", "value": "FULLTEXT KEY", "keyword": "FULLTEXT KEY", "type": 1, "flags": 23, "position": 69 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 81 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`fulltext_index`", "value": "fulltext_index", "keyword": null, "type": 8, "flags": 2, "position": 82 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 98 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 99 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`column_one`", "value": "column_one", "keyword": null, "type": 8, "flags": 2, "position": 100 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 112 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 113 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "/*!50100", "value": "/*!50100", "keyword": null, "type": 4, "flags": 10, "position": 114 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 122 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WITH PARSER", "value": "WITH PARSER", "keyword": "WITH PARSER", "type": 1, "flags": 7, "position": 123 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 134 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`ngram`", "value": "ngram", "keyword": null, "type": 8, "flags": 2, "position": 135 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 142 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "*/", "value": "*/", "keyword": null, "type": 4, "flags": 2, "position": 143 }, { "@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": "CONSTRAINT", "value": "CONSTRAINT", "keyword": "CONSTRAINT", "type": 1, "flags": 3, "position": 149 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 159 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`my_constraint_1`", "value": "my_constraint_1", "keyword": null, "type": 8, "flags": 2, "position": 160 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 177 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FOREIGN KEY", "value": "FOREIGN KEY", "keyword": "FOREIGN KEY", "type": 1, "flags": 23, "position": 178 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 189 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 190 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`column_one`", "value": "column_one", "keyword": null, "type": 8, "flags": 2, "position": 191 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 203 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 204 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "REFERENCES", "value": "REFERENCES", "keyword": "REFERENCES", "type": 1, "flags": 3, "position": 205 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 215 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`other_table`", "value": "other_table", "keyword": null, "type": 8, "flags": 2, "position": 216 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 229 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 230 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`column_two`", "value": "column_two", "keyword": null, "type": 8, "flags": 2, "position": 231 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 243 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 244 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ON DELETE", "value": "ON DELETE", "keyword": "ON DELETE", "type": 1, "flags": 7, "position": 245 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 254 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "RESTRICT", "value": "RESTRICT", "keyword": "RESTRICT", "type": 1, "flags": 3, "position": 255 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 263 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ON UPDATE", "value": "ON UPDATE", "keyword": "ON UPDATE", "type": 1, "flags": 7, "position": 264 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 273 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "RESTRICT", "value": "RESTRICT", "keyword": "RESTRICT", "type": 1, "flags": 3, "position": 274 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 282 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 283 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 284 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 66, "idx": 66 }, "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": "mytable", "column": null, "expr": "`mytable`", "alias": null, "function": null, "subquery": null }, "entityOptions": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "fields": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "column_one", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "VARCHAR", "parameters": [ "255" ], "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": null, "isConstraint": null, "type": null, "key": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Key", "name": "fulltext_index", "columns": [ { "name": "column_one" } ], "type": "FULLTEXT KEY", "expr": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "3": { "name": "WITH PARSER", "equals": false, "expr": "`ngram`", "value": "ngram" } } } }, "references": null, "options": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "my_constraint_1", "isConstraint": true, "type": null, "key": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Key", "name": null, "columns": [ { "name": "column_one" } ], "type": "FOREIGN KEY", "expr": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "references": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Reference", "table": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "other_table", "column": null, "expr": "`other_table`", "alias": null, "function": null, "subquery": null }, "columns": [ "column_two" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "2": { "name": "ON DELETE", "equals": false, "expr": "RESTRICT", "value": "RESTRICT" }, "3": { "name": "ON UPDATE", "equals": false, "expr": "RESTRICT", "value": "RESTRICT" } } } }, "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": 65 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }