{
    "query": "CREATE TABLE `ts` (\n  `id` int(11) DEFAULT NULL,\n  `purchased` date DEFAULT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4\nPARTITION BY RANGE (YEAR(purchased))\nSUBPARTITION BY HASH (TO_DAYS(purchased))\n(\nPARTITION p0 VALUES LESS THAN (1990)  (\nSUBPARTITION s0 ENGINE=InnoDB,\nSUBPARTITION s1 ENGINE=InnoDB\n),\nPARTITION p1 VALUES LESS THAN (2000)  (\nSUBPARTITION s2 ENGINE=InnoDB,\nSUBPARTITION s3 ENGINE=InnoDB\n),\nPARTITION p2 VALUES LESS THAN MAXVALUE  (\nSUBPARTITION s4 ENGINE=InnoDB,\nSUBPARTITION s5 ENGINE=InnoDB\n)\n);\n",
    "lexer": {
        "@type": "PhpMyAdmin\\SqlParser\\Lexer",
        "str": "CREATE TABLE `ts` (\n  `id` int(11) DEFAULT NULL,\n  `purchased` date DEFAULT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4\nPARTITION BY RANGE (YEAR(purchased))\nSUBPARTITION BY HASH (TO_DAYS(purchased))\n(\nPARTITION p0 VALUES LESS THAN (1990)  (\nSUBPARTITION s0 ENGINE=InnoDB,\nSUBPARTITION s1 ENGINE=InnoDB\n),\nPARTITION p1 VALUES LESS THAN (2000)  (\nSUBPARTITION s2 ENGINE=InnoDB,\nSUBPARTITION s3 ENGINE=InnoDB\n),\nPARTITION p2 VALUES LESS THAN MAXVALUE  (\nSUBPARTITION s4 ENGINE=InnoDB,\nSUBPARTITION s5 ENGINE=InnoDB\n)\n);\n",
        "len": 518,
        "last": 518,
        "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": "`ts`",
                    "value": "ts",
                    "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": "DEFAULT",
                    "value": "DEFAULT",
                    "keyword": "DEFAULT",
                    "type": 1,
                    "flags": 35,
                    "position": 35
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 42
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "NULL",
                    "value": "NULL",
                    "keyword": "NULL",
                    "type": 1,
                    "flags": 3,
                    "position": 43
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 47
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 48
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`purchased`",
                    "value": "purchased",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 51
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 62
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "date",
                    "value": "date",
                    "keyword": "DATE",
                    "type": 1,
                    "flags": 41,
                    "position": 63
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 67
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "DEFAULT",
                    "value": "DEFAULT",
                    "keyword": "DEFAULT",
                    "type": 1,
                    "flags": 35,
                    "position": 68
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 75
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "NULL",
                    "value": "NULL",
                    "keyword": "NULL",
                    "type": 1,
                    "flags": 3,
                    "position": 76
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 80
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 81
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 82
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ENGINE",
                    "value": "ENGINE",
                    "keyword": "ENGINE",
                    "type": 1,
                    "flags": 1,
                    "position": 83
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 89
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "InnoDB",
                    "value": "InnoDB",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 90
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 96
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "DEFAULT CHARSET",
                    "value": "DEFAULT CHARSET",
                    "keyword": "DEFAULT CHARSET",
                    "type": 1,
                    "flags": 7,
                    "position": 97
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 112
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "utf8mb4",
                    "value": "utf8mb4",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 113
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 120
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "PARTITION BY",
                    "value": "PARTITION BY",
                    "keyword": "PARTITION BY",
                    "type": 1,
                    "flags": 7,
                    "position": 121
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 133
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "RANGE",
                    "value": "RANGE",
                    "keyword": "RANGE",
                    "type": 1,
                    "flags": 3,
                    "position": 134
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 139
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 140
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "YEAR",
                    "value": "YEAR",
                    "keyword": "YEAR",
                    "type": 1,
                    "flags": 41,
                    "position": 141
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 145
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "purchased",
                    "value": "purchased",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 146
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 155
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 156
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 157
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "SUBPARTITION BY",
                    "value": "SUBPARTITION BY",
                    "keyword": "SUBPARTITION BY",
                    "type": 1,
                    "flags": 7,
                    "position": 158
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 173
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "HASH",
                    "value": "HASH",
                    "keyword": "HASH",
                    "type": 1,
                    "flags": 1,
                    "position": 174
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 178
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 179
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "TO_DAYS",
                    "value": "TO_DAYS",
                    "keyword": "TO_DAYS",
                    "type": 1,
                    "flags": 33,
                    "position": 180
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 187
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "purchased",
                    "value": "purchased",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 188
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 197
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 198
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 199
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 200
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 201
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "PARTITION",
                    "value": "PARTITION",
                    "keyword": "PARTITION",
                    "type": 1,
                    "flags": 3,
                    "position": 202
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 211
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "p0",
                    "value": "p0",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 212
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 214
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "VALUES",
                    "value": "VALUES",
                    "keyword": "VALUES",
                    "type": 1,
                    "flags": 35,
                    "position": 215
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 221
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "LESS THAN",
                    "value": "LESS THAN",
                    "keyword": "LESS THAN",
                    "type": 1,
                    "flags": 7,
                    "position": 222
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 231
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 232
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "1990",
                    "value": 1990,
                    "keyword": null,
                    "type": 6,
                    "flags": 0,
                    "position": 233
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 237
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 238
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 240
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 241
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "SUBPARTITION",
                    "value": "SUBPARTITION",
                    "keyword": "SUBPARTITION",
                    "type": 1,
                    "flags": 1,
                    "position": 242
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 254
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "s0",
                    "value": "s0",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 255
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 257
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ENGINE",
                    "value": "ENGINE",
                    "keyword": "ENGINE",
                    "type": 1,
                    "flags": 1,
                    "position": 258
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 264
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "InnoDB",
                    "value": "InnoDB",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 265
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 271
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 272
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "SUBPARTITION",
                    "value": "SUBPARTITION",
                    "keyword": "SUBPARTITION",
                    "type": 1,
                    "flags": 1,
                    "position": 273
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 285
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "s1",
                    "value": "s1",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 286
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 288
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ENGINE",
                    "value": "ENGINE",
                    "keyword": "ENGINE",
                    "type": 1,
                    "flags": 1,
                    "position": 289
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 295
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "InnoDB",
                    "value": "InnoDB",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 296
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 302
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 303
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 304
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 305
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "PARTITION",
                    "value": "PARTITION",
                    "keyword": "PARTITION",
                    "type": 1,
                    "flags": 3,
                    "position": 306
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 315
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "p1",
                    "value": "p1",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 316
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 318
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "VALUES",
                    "value": "VALUES",
                    "keyword": "VALUES",
                    "type": 1,
                    "flags": 35,
                    "position": 319
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 325
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "LESS THAN",
                    "value": "LESS THAN",
                    "keyword": "LESS THAN",
                    "type": 1,
                    "flags": 7,
                    "position": 326
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 335
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 336
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "2000",
                    "value": 2000,
                    "keyword": null,
                    "type": 6,
                    "flags": 0,
                    "position": 337
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 341
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 342
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 344
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 345
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "SUBPARTITION",
                    "value": "SUBPARTITION",
                    "keyword": "SUBPARTITION",
                    "type": 1,
                    "flags": 1,
                    "position": 346
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 358
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "s2",
                    "value": "s2",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 359
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 361
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ENGINE",
                    "value": "ENGINE",
                    "keyword": "ENGINE",
                    "type": 1,
                    "flags": 1,
                    "position": 362
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 368
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "InnoDB",
                    "value": "InnoDB",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 369
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 375
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 376
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "SUBPARTITION",
                    "value": "SUBPARTITION",
                    "keyword": "SUBPARTITION",
                    "type": 1,
                    "flags": 1,
                    "position": 377
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 389
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "s3",
                    "value": "s3",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 390
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 392
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ENGINE",
                    "value": "ENGINE",
                    "keyword": "ENGINE",
                    "type": 1,
                    "flags": 1,
                    "position": 393
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 399
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "InnoDB",
                    "value": "InnoDB",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 400
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 406
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 407
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 408
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 409
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "PARTITION",
                    "value": "PARTITION",
                    "keyword": "PARTITION",
                    "type": 1,
                    "flags": 3,
                    "position": 410
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 419
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "p2",
                    "value": "p2",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 420
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 422
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "VALUES",
                    "value": "VALUES",
                    "keyword": "VALUES",
                    "type": 1,
                    "flags": 35,
                    "position": 423
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 429
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "LESS THAN",
                    "value": "LESS THAN",
                    "keyword": "LESS THAN",
                    "type": 1,
                    "flags": 7,
                    "position": 430
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 439
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "MAXVALUE",
                    "value": "MAXVALUE",
                    "keyword": "MAXVALUE",
                    "type": 1,
                    "flags": 3,
                    "position": 440
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 448
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 450
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 451
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "SUBPARTITION",
                    "value": "SUBPARTITION",
                    "keyword": "SUBPARTITION",
                    "type": 1,
                    "flags": 1,
                    "position": 452
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 464
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "s4",
                    "value": "s4",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 465
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 467
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ENGINE",
                    "value": "ENGINE",
                    "keyword": "ENGINE",
                    "type": 1,
                    "flags": 1,
                    "position": 468
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 474
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "InnoDB",
                    "value": "InnoDB",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 475
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 481
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 482
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "SUBPARTITION",
                    "value": "SUBPARTITION",
                    "keyword": "SUBPARTITION",
                    "type": 1,
                    "flags": 1,
                    "position": 483
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 495
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "s5",
                    "value": "s5",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 496
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 498
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ENGINE",
                    "value": "ENGINE",
                    "keyword": "ENGINE",
                    "type": 1,
                    "flags": 1,
                    "position": 499
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 505
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "InnoDB",
                    "value": "InnoDB",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 506
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 512
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 513
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 514
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 515
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ";",
                    "value": ";",
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": 516
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 517
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": null,
                    "value": null,
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": null
                }
            ],
            "count": 165,
            "idx": 165
        },
        "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": "ts",
                    "column": null,
                    "expr": "`ts`",
                    "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"
                        }
                    }
                },
                "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": {
                                "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": "purchased",
                        "isConstraint": null,
                        "type": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType",
                            "name": "DATE",
                            "parameters": [],
                            "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"
                                }
                            }
                        }
                    }
                ],
                "with": null,
                "select": null,
                "like": null,
                "partitionBy": "RANGE (YEAR(purchased))",
                "partitionsNum": null,
                "subpartitionBy": "HASH (TO_DAYS(purchased))",
                "subpartitionsNum": null,
                "partitions": [
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition",
                        "isSubpartition": false,
                        "name": "p0",
                        "type": "LESS THAN",
                        "expr": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                            "database": null,
                            "table": null,
                            "column": null,
                            "expr": "(1990)",
                            "alias": null,
                            "function": null,
                            "subquery": null
                        },
                        "subpartitions": [
                            {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition",
                                "isSubpartition": true,
                                "name": "s0",
                                "type": null,
                                "expr": null,
                                "subpartitions": null,
                                "options": {
                                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                    "options": {
                                        "1": {
                                            "name": "ENGINE",
                                            "equals": true,
                                            "expr": "InnoDB",
                                            "value": "InnoDB"
                                        }
                                    }
                                }
                            },
                            {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition",
                                "isSubpartition": true,
                                "name": "s1",
                                "type": null,
                                "expr": null,
                                "subpartitions": null,
                                "options": {
                                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                    "options": {
                                        "1": {
                                            "name": "ENGINE",
                                            "equals": true,
                                            "expr": "InnoDB",
                                            "value": "InnoDB"
                                        }
                                    }
                                }
                            }
                        ],
                        "options": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                            "options": []
                        }
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition",
                        "isSubpartition": false,
                        "name": "p1",
                        "type": "LESS THAN",
                        "expr": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                            "database": null,
                            "table": null,
                            "column": null,
                            "expr": "(2000)",
                            "alias": null,
                            "function": null,
                            "subquery": null
                        },
                        "subpartitions": [
                            {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition",
                                "isSubpartition": true,
                                "name": "s2",
                                "type": null,
                                "expr": null,
                                "subpartitions": null,
                                "options": {
                                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                    "options": {
                                        "1": {
                                            "name": "ENGINE",
                                            "equals": true,
                                            "expr": "InnoDB",
                                            "value": "InnoDB"
                                        }
                                    }
                                }
                            },
                            {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition",
                                "isSubpartition": true,
                                "name": "s3",
                                "type": null,
                                "expr": null,
                                "subpartitions": null,
                                "options": {
                                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                    "options": {
                                        "1": {
                                            "name": "ENGINE",
                                            "equals": true,
                                            "expr": "InnoDB",
                                            "value": "InnoDB"
                                        }
                                    }
                                }
                            }
                        ],
                        "options": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                            "options": []
                        }
                    },
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition",
                        "isSubpartition": false,
                        "name": "p2",
                        "type": "LESS THAN",
                        "expr": "MAXVALUE",
                        "subpartitions": [
                            {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition",
                                "isSubpartition": true,
                                "name": "s4",
                                "type": null,
                                "expr": null,
                                "subpartitions": null,
                                "options": {
                                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                    "options": {
                                        "1": {
                                            "name": "ENGINE",
                                            "equals": true,
                                            "expr": "InnoDB",
                                            "value": "InnoDB"
                                        }
                                    }
                                }
                            },
                            {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition",
                                "isSubpartition": true,
                                "name": "s5",
                                "type": null,
                                "expr": null,
                                "subpartitions": null,
                                "options": {
                                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                    "options": {
                                        "1": {
                                            "name": "ENGINE",
                                            "equals": true,
                                            "expr": "InnoDB",
                                            "value": "InnoDB"
                                        }
                                    }
                                }
                            }
                        ],
                        "options": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                            "options": []
                        }
                    }
                ],
                "table": null,
                "return": null,
                "parameters": null,
                "body": [],
                "options": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                    "options": {
                        "6": "TABLE"
                    }
                },
                "first": 0,
                "last": 161
            }
        ],
        "brackets": 0,
        "strict": false,
        "errors": []
    },
    "errors": {
        "lexer": [],
        "parser": []
    }
}