Server : ApacheSystem : Linux host.digitalbabaji.in 4.18.0-513.11.1.el8_9.x86_64 #1 SMP Wed Jan 17 02:00:40 EST 2024 x86_64 User : addictionfreeind ( 1003) PHP Version : 7.2.34 Disable Function : exec,passthru,shell_exec,system Directory : /home/addictionfreeind/www/admin1/vendor/phpmyadmin/sql-parser/tests/data/bugs/ |
Upload File : |
{
"query": "CREATE TABLE `jos_core_acl_aro` (\n `id` int(11) NOT NULL,\n `section_value` varchar(240) NOT NULL DEFAULT '0',\n `value` varchar(240) NOT NULL DEFAULT '',\n `order_value` int(11) NOT NULL DEFAULT '0',\n `name` varchar(255) NOT NULL DEFAULT '',\n `hidden` int(11) NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n UNIQUE KEY `jos_section_value_value_aro` (`section_value`(100),`value`(15)) USING BTREE,\n KEY `jos_gacl_hidden_aro` (`hidden`)\n) ENGINE=InnoDB DEFAULT CHARSET=latin1",
"lexer": {
"@type": "PhpMyAdmin\\SqlParser\\Lexer",
"str": "CREATE TABLE `jos_core_acl_aro` (\n `id` int(11) NOT NULL,\n `section_value` varchar(240) NOT NULL DEFAULT '0',\n `value` varchar(240) NOT NULL DEFAULT '',\n `order_value` int(11) NOT NULL DEFAULT '0',\n `name` varchar(255) NOT NULL DEFAULT '',\n `hidden` int(11) NOT NULL DEFAULT '0',\n PRIMARY KEY (`id`),\n UNIQUE KEY `jos_section_value_value_aro` (`section_value`(100),`value`(15)) USING BTREE,\n KEY `jos_gacl_hidden_aro` (`hidden`)\n) ENGINE=InnoDB DEFAULT CHARSET=latin1",
"len": 476,
"last": 476,
"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": "`jos_core_acl_aro`",
"value": "jos_core_acl_aro",
"keyword": null,
"type": 8,
"flags": 2,
"position": 13
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 31
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 32
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 33
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`id`",
"value": "id",
"keyword": null,
"type": 8,
"flags": 2,
"position": 36
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 40
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "int",
"value": "INT",
"keyword": "INT",
"type": 1,
"flags": 11,
"position": 41
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 44
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "11",
"value": 11,
"keyword": null,
"type": 6,
"flags": 0,
"position": 45
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 47
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 48
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "NOT NULL",
"value": "NOT NULL",
"keyword": "NOT NULL",
"type": 1,
"flags": 7,
"position": 49
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 57
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 58
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`section_value`",
"value": "section_value",
"keyword": null,
"type": 8,
"flags": 2,
"position": 61
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 76
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "varchar",
"value": "VARCHAR",
"keyword": "VARCHAR",
"type": 1,
"flags": 11,
"position": 77
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 84
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "240",
"value": 240,
"keyword": null,
"type": 6,
"flags": 0,
"position": 85
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 88
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 89
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "NOT NULL",
"value": "NOT NULL",
"keyword": "NOT NULL",
"type": 1,
"flags": 7,
"position": 90
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 98
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "DEFAULT",
"value": "DEFAULT",
"keyword": "DEFAULT",
"type": 1,
"flags": 35,
"position": 99
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 106
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'0'",
"value": "0",
"keyword": null,
"type": 7,
"flags": 1,
"position": 107
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 110
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 111
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`value`",
"value": "value",
"keyword": null,
"type": 8,
"flags": 2,
"position": 114
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 121
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "varchar",
"value": "VARCHAR",
"keyword": "VARCHAR",
"type": 1,
"flags": 11,
"position": 122
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 129
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "240",
"value": 240,
"keyword": null,
"type": 6,
"flags": 0,
"position": 130
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 133
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 134
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "NOT NULL",
"value": "NOT NULL",
"keyword": "NOT NULL",
"type": 1,
"flags": 7,
"position": 135
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 143
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "DEFAULT",
"value": "DEFAULT",
"keyword": "DEFAULT",
"type": 1,
"flags": 35,
"position": 144
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 151
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "''",
"value": "",
"keyword": null,
"type": 7,
"flags": 1,
"position": 152
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 154
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 155
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`order_value`",
"value": "order_value",
"keyword": null,
"type": 8,
"flags": 2,
"position": 158
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 171
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "int",
"value": "INT",
"keyword": "INT",
"type": 1,
"flags": 11,
"position": 172
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 175
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "11",
"value": 11,
"keyword": null,
"type": 6,
"flags": 0,
"position": 176
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 178
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 179
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "NOT NULL",
"value": "NOT NULL",
"keyword": "NOT NULL",
"type": 1,
"flags": 7,
"position": 180
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 188
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "DEFAULT",
"value": "DEFAULT",
"keyword": "DEFAULT",
"type": 1,
"flags": 35,
"position": 189
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 196
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'0'",
"value": "0",
"keyword": null,
"type": 7,
"flags": 1,
"position": 197
},
{
"@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": "`name`",
"value": "name",
"keyword": null,
"type": 8,
"flags": 2,
"position": 204
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 210
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "varchar",
"value": "VARCHAR",
"keyword": "VARCHAR",
"type": 1,
"flags": 11,
"position": 211
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 218
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "255",
"value": 255,
"keyword": null,
"type": 6,
"flags": 0,
"position": 219
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 222
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 223
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "NOT NULL",
"value": "NOT NULL",
"keyword": "NOT NULL",
"type": 1,
"flags": 7,
"position": 224
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 232
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "DEFAULT",
"value": "DEFAULT",
"keyword": "DEFAULT",
"type": 1,
"flags": 35,
"position": 233
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 240
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "''",
"value": "",
"keyword": null,
"type": 7,
"flags": 1,
"position": 241
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 243
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 244
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`hidden`",
"value": "hidden",
"keyword": null,
"type": 8,
"flags": 2,
"position": 247
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 255
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "int",
"value": "INT",
"keyword": "INT",
"type": 1,
"flags": 11,
"position": 256
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 259
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "11",
"value": 11,
"keyword": null,
"type": 6,
"flags": 0,
"position": 260
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 262
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 263
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "NOT NULL",
"value": "NOT NULL",
"keyword": "NOT NULL",
"type": 1,
"flags": 7,
"position": 264
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 272
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "DEFAULT",
"value": "DEFAULT",
"keyword": "DEFAULT",
"type": 1,
"flags": 35,
"position": 273
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 280
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "'0'",
"value": "0",
"keyword": null,
"type": 7,
"flags": 1,
"position": 281
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 284
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 285
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "PRIMARY KEY",
"value": "PRIMARY KEY",
"keyword": "PRIMARY KEY",
"type": 1,
"flags": 23,
"position": 288
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 299
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 300
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`id`",
"value": "id",
"keyword": null,
"type": 8,
"flags": 2,
"position": 301
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 305
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 306
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 307
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "UNIQUE KEY",
"value": "UNIQUE KEY",
"keyword": "UNIQUE KEY",
"type": 1,
"flags": 23,
"position": 310
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 320
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`jos_section_value_value_aro`",
"value": "jos_section_value_value_aro",
"keyword": null,
"type": 8,
"flags": 2,
"position": 321
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 350
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 351
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`section_value`",
"value": "section_value",
"keyword": null,
"type": 8,
"flags": 2,
"position": 352
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 367
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "100",
"value": 100,
"keyword": null,
"type": 6,
"flags": 0,
"position": 368
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 371
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 372
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`value`",
"value": "value",
"keyword": null,
"type": 8,
"flags": 2,
"position": 373
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 380
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "15",
"value": 15,
"keyword": null,
"type": 6,
"flags": 0,
"position": 381
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 383
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 384
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 385
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "USING",
"value": "USING",
"keyword": "USING",
"type": 1,
"flags": 3,
"position": 386
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 391
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "BTREE",
"value": "BTREE",
"keyword": "BTREE",
"type": 1,
"flags": 1,
"position": 392
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ",",
"value": ",",
"keyword": null,
"type": 2,
"flags": 16,
"position": 397
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 398
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "KEY",
"value": "KEY",
"keyword": "KEY",
"type": 1,
"flags": 19,
"position": 401
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 404
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`jos_gacl_hidden_aro`",
"value": "jos_gacl_hidden_aro",
"keyword": null,
"type": 8,
"flags": 2,
"position": 405
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 426
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "(",
"value": "(",
"keyword": null,
"type": 2,
"flags": 16,
"position": 427
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "`hidden`",
"value": "hidden",
"keyword": null,
"type": 8,
"flags": 2,
"position": 428
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 436
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "\n",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 437
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ")",
"value": ")",
"keyword": null,
"type": 2,
"flags": 16,
"position": 438
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 439
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "ENGINE",
"value": "ENGINE",
"keyword": "ENGINE",
"type": 1,
"flags": 1,
"position": 440
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 446
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "InnoDB",
"value": "InnoDB",
"keyword": null,
"type": 0,
"flags": 0,
"position": 447
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": " ",
"value": " ",
"keyword": null,
"type": 3,
"flags": 0,
"position": 453
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "DEFAULT CHARSET",
"value": "DEFAULT CHARSET",
"keyword": "DEFAULT CHARSET",
"type": 1,
"flags": 7,
"position": 454
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "=",
"value": "=",
"keyword": null,
"type": 2,
"flags": 2,
"position": 469
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": "latin1",
"value": "latin1",
"keyword": null,
"type": 0,
"flags": 0,
"position": 470
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": null,
"value": null,
"keyword": null,
"type": 9,
"flags": 0,
"position": null
}
],
"count": 134,
"idx": 134
},
"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": "jos_core_acl_aro",
"column": null,
"expr": "`jos_core_acl_aro`",
"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": "section_value",
"isConstraint": null,
"type": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\DataType",
"name": "VARCHAR",
"parameters": [
"240"
],
"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": "0",
"expr": "'0'",
"alias": null,
"function": null,
"subquery": null
},
"value": "'0'"
}
}
}
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
"name": "value",
"isConstraint": null,
"type": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\DataType",
"name": "VARCHAR",
"parameters": [
"240"
],
"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": "",
"expr": "''",
"alias": null,
"function": null,
"subquery": null
},
"value": "''"
}
}
}
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
"name": "order_value",
"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",
"2": {
"name": "DEFAULT",
"equals": false,
"expr": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": null,
"column": "0",
"expr": "'0'",
"alias": null,
"function": null,
"subquery": null
},
"value": "'0'"
}
}
}
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
"name": "name",
"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": {
"1": "NOT NULL",
"2": {
"name": "DEFAULT",
"equals": false,
"expr": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": null,
"column": "",
"expr": "''",
"alias": null,
"function": null,
"subquery": null
},
"value": "''"
}
}
}
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
"name": "hidden",
"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",
"2": {
"name": "DEFAULT",
"equals": false,
"expr": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
"database": null,
"table": null,
"column": "0",
"expr": "'0'",
"alias": null,
"function": null,
"subquery": null
},
"value": "'0'"
}
}
}
},
{
"@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
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
"name": null,
"isConstraint": null,
"type": null,
"key": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\Key",
"name": "jos_section_value_value_aro",
"columns": [
{
"name": "section_value",
"length": 100
},
{
"name": "value",
"length": 15
}
],
"type": "UNIQUE KEY",
"expr": null,
"options": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
"options": {
"2": {
"name": "USING",
"equals": false,
"expr": "BTREE",
"value": "BTREE"
}
}
}
},
"references": null,
"options": null
},
{
"@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition",
"name": null,
"isConstraint": null,
"type": null,
"key": {
"@type": "PhpMyAdmin\\SqlParser\\Components\\Key",
"name": "jos_gacl_hidden_aro",
"columns": [
{
"name": "hidden"
}
],
"type": "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": 133
}
],
"brackets": 0,
"strict": false,
"errors": []
},
"errors": {
"lexer": [],
"parser": []
}
}