{ "query": "CREATE TABLE `aa` (\n `id` int(11) NOT NULL,\n `rTime` timestamp(3) NOT NULL DEFAULT '0000-00-00 00:00:00.000' ON UPDATE CURRENT_TIMESTAMP(3),\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": "CREATE TABLE `aa` (\n `id` int(11) NOT NULL,\n `rTime` timestamp(3) NOT NULL DEFAULT '0000-00-00 00:00:00.000' ON UPDATE CURRENT_TIMESTAMP(3),\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;", "len": 203, "last": 203, "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": "`aa`", "value": "aa", "keyword": null, "type": 8, "flags": 2, "position": 13 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 17 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 18 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 19 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`id`", "value": "id", "keyword": null, "type": 8, "flags": 2, "position": 22 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 26 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "int", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 27 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 30 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "11", "value": 11, "keyword": null, "type": 6, "flags": 0, "position": 31 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 33 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 34 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT NULL", "value": "NOT NULL", "keyword": "NOT NULL", "type": 1, "flags": 7, "position": 35 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 43 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 44 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`rTime`", "value": "rTime", "keyword": null, "type": 8, "flags": 2, "position": 47 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 54 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "timestamp", "value": "timestamp", "keyword": "TIMESTAMP", "type": 1, "flags": 41, "position": 55 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 64 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "3", "value": 3, "keyword": null, "type": 6, "flags": 0, "position": 65 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 66 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 67 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT NULL", "value": "NOT NULL", "keyword": "NOT NULL", "type": 1, "flags": 7, "position": 68 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 76 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT", "value": "DEFAULT", "keyword": "DEFAULT", "type": 1, "flags": 35, "position": 77 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 84 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'0000-00-00 00:00:00.000'", "value": "0000-00-00 00:00:00.000", "keyword": null, "type": 7, "flags": 1, "position": 85 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 110 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ON UPDATE", "value": "ON UPDATE", "keyword": "ON UPDATE", "type": 1, "flags": 7, "position": 111 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 120 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CURRENT_TIMESTAMP", "value": "CURRENT_TIMESTAMP", "keyword": "CURRENT_TIMESTAMP", "type": 1, "flags": 35, "position": 121 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 138 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "3", "value": 3, "keyword": null, "type": 6, "flags": 0, "position": 139 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 140 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 141 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 142 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "PRIMARY KEY", "value": "PRIMARY KEY", "keyword": "PRIMARY KEY", "type": 1, "flags": 23, "position": 145 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 156 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 157 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`id`", "value": "id", "keyword": null, "type": 8, "flags": 2, "position": 158 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 162 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 163 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 164 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 165 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ENGINE", "value": "ENGINE", "keyword": "ENGINE", "type": 1, "flags": 1, "position": 166 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 172 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "InnoDB", "value": "InnoDB", "keyword": null, "type": 0, "flags": 0, "position": 173 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 179 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT CHARSET", "value": "DEFAULT CHARSET", "keyword": "DEFAULT CHARSET", "type": 1, "flags": 7, "position": 180 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 195 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "latin1", "value": "latin1", "keyword": null, "type": 0, "flags": 0, "position": 196 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 202 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 56, "idx": 56 }, "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": "aa", "column": null, "expr": "`aa`", "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": "latin1", "value": "latin1" } } }, "fields": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "id", "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": { "1": "NOT NULL" } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "rTime", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "TIMESTAMP", "parameters": [ "3" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "NOT NULL", "2": { "name": "DEFAULT", "equals": false, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": "0000-00-00 00:00:00.000", "expr": "'0000-00-00 00:00:00.000'", "alias": null, "function": null, "subquery": null }, "value": "'0000-00-00 00:00:00.000'" }, "7": { "name": "ON UPDATE", "equals": false, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "CURRENT_TIMESTAMP(3)", "alias": null, "function": "CURRENT_TIMESTAMP", "subquery": null }, "value": "CURRENT_TIMESTAMP(3)" } } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": null, "isConstraint": null, "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 } ], "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": 54 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }