{ "query": "DELIMITER $$\nCREATE DEFINER=`user`@`localhost` PROCEDURE `multiDBqueryRun_V12`(IN `query` TEXT, IN `table_name_var` VARCHAR(255), IN `columns_used_var` TEXT, IN `where_text_var` TEXT, IN `separator_value_var` VARCHAR(255)) COMMENT 'Query: SingleDB → MultiDB (All DBs) + run it' NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER BEGIN\nSET @TABLE_NAME = table_name_var;\nSET @WHERE_TEXT = where_text_var;\nSET @COLUMNS_USED = columns_used_var;\nSET @MULTIDB_QUERY = CONCAT('SELECT \"$MULTIDB\" FROM `$MULTIDB`.', @TABLE_NAME, @WHERE_TEXT);\n\n-- EXECUTION --\nCREATE TEMPORARY TABLE `MULTIDB_TEMP_DB_TBL_COLS` AS\nSELECT * FROM (\n SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME\n FROM INFORMATION_SCHEMA.COLUMNS\n WHERE\n TABLE_SCHEMA NOT IN('mysql', 'test', 'tmp', 'information_schema', 'sys', 'performance_schema') AND\n TABLE_NAME = @TABLE_NAME AND\n FIND_IN_SET(COLUMN_NAME, @COLUMNS_USED)\n) tbl\nGROUP BY\n TABLE_SCHEMA,\n TABLE_NAME;\n\nSELECT GROUP_CONCAT(REPLACE(@MULTIDB_QUERY, '$MULTIDB', CONCAT('', TABLE_SCHEMA, '')) SEPARATOR \"\\nUNION ALL\\n\")\nINTO @stmt_sql\nFROM `MULTIDB_TEMP_DB_TBL_COLS`;\n\nPREPARE stmt FROM @stmt_sql;\nEXECUTE stmt;\nDEALLOCATE PREPARE stmt;\nEND$$\n\n--\n-- Functions\n--\nDELIMITER $$\nCREATE DEFINER=`root`@`localhost` FUNCTION `attrParentShiftIds` (`parent_id` TEXT, `option_id_shift` INT, `option_value_id_shift` INT) RETURNS TEXT CHARSET utf8mb4 COLLATE utf8mb4_unicode_520_ci DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER BEGIN\n DECLARE i INT UNSIGNED DEFAULT 0;\n DECLARE pair_count INT UNSIGNED;\n DECLARE result TEXT DEFAULT '';\n\n DECLARE pair VARCHAR(255) DEFAULT '';\n DECLARE oid INT DEFAULT '';\n DECLARE vid INT DEFAULT '';\n\n SET pair_count = substrCount(parent_id, ',') + 1;\n\n WHILE i < pair_count DO\n SET result = CONCAT(result, IF(i <= 0, '', ','));\n\n SET pair = split(parent_id, ',', i + 1);\n\n SET oid = split(pair, '-', 1) + option_id_shift;\n SET vid = split(pair, '-', 2) + option_value_id_shift;\n\n SET pair = CONCAT(oid, '-', vid);\n SET result = CONCAT(result, pair);\n\n SET i = i + 1;\n END WHILE;\n\n RETURN result;\nEND$$\n\nDELIMITER $$\nCREATE DEFINER=`user`@`localhost` FUNCTION `split` (`string` TEXT, `delim` TEXT, `n` INT) RETURNS TEXT CHARSET utf8mb4 COLLATE utf8mb4_unicode_520_ci DETERMINISTIC SQL SECURITY INVOKER RETURN IF(\n (LENGTH(string) - LENGTH(REPLACE(string, delim, ''))) / LENGTH(delim) < n - 1,\n NULL,\n SUBSTRING_INDEX(SUBSTRING_INDEX(string, delim, n), delim, -1)\n)$$\n\nDELIMITER $$\nCREATE DEFINER=`root`@`localhost` FUNCTION `substrCount` (`s` VARCHAR(255), `ss` VARCHAR(255)) RETURNS TINYINT(3) UNSIGNED DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER BEGIN\nDECLARE COUNT TINYINT(3) UNSIGNED;\nDECLARE OFFSET_I TINYINT(3) UNSIGNED;\nDECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET s = NULL;\n\nSET COUNT = 0;\nSET OFFSET_I = 1;\n\nREPEAT\nIF NOT ISNULL(s) AND OFFSET_I > 0 THEN\nSET OFFSET_I = LOCATE(ss, s, OFFSET_I);\nIF OFFSET_I > 0 THEN\nSET COUNT = COUNT + 1;\nSET OFFSET_I = OFFSET_I + 1;\nEND IF;\nEND IF;\nUNTIL ISNULL(s) OR OFFSET_I = 0 END REPEAT;\n\nRETURN COUNT;\nEND$$\n\nDELIMITER ;\n\n", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": { "@type": "PhpMyAdmin\\SqlParser\\UtfString", "str": "DELIMITER $$\nCREATE DEFINER=`user`@`localhost` PROCEDURE `multiDBqueryRun_V12`(IN `query` TEXT, IN `table_name_var` VARCHAR(255), IN `columns_used_var` TEXT, IN `where_text_var` TEXT, IN `separator_value_var` VARCHAR(255)) COMMENT 'Query: SingleDB → MultiDB (All DBs) + run it' NOT DETERMINISTIC MODIFIES SQL DATA SQL SECURITY INVOKER BEGIN\nSET @TABLE_NAME = table_name_var;\nSET @WHERE_TEXT = where_text_var;\nSET @COLUMNS_USED = columns_used_var;\nSET @MULTIDB_QUERY = CONCAT('SELECT \"$MULTIDB\" FROM `$MULTIDB`.', @TABLE_NAME, @WHERE_TEXT);\n\n-- EXECUTION --\nCREATE TEMPORARY TABLE `MULTIDB_TEMP_DB_TBL_COLS` AS\nSELECT * FROM (\n SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME\n FROM INFORMATION_SCHEMA.COLUMNS\n WHERE\n TABLE_SCHEMA NOT IN('mysql', 'test', 'tmp', 'information_schema', 'sys', 'performance_schema') AND\n TABLE_NAME = @TABLE_NAME AND\n FIND_IN_SET(COLUMN_NAME, @COLUMNS_USED)\n) tbl\nGROUP BY\n TABLE_SCHEMA,\n TABLE_NAME;\n\nSELECT GROUP_CONCAT(REPLACE(@MULTIDB_QUERY, '$MULTIDB', CONCAT('', TABLE_SCHEMA, '')) SEPARATOR \"\\nUNION ALL\\n\")\nINTO @stmt_sql\nFROM `MULTIDB_TEMP_DB_TBL_COLS`;\n\nPREPARE stmt FROM @stmt_sql;\nEXECUTE stmt;\nDEALLOCATE PREPARE stmt;\nEND$$\n\n--\n-- Functions\n--\nDELIMITER $$\nCREATE DEFINER=`root`@`localhost` FUNCTION `attrParentShiftIds` (`parent_id` TEXT, `option_id_shift` INT, `option_value_id_shift` INT) RETURNS TEXT CHARSET utf8mb4 COLLATE utf8mb4_unicode_520_ci DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER BEGIN\n DECLARE i INT UNSIGNED DEFAULT 0;\n DECLARE pair_count INT UNSIGNED;\n DECLARE result TEXT DEFAULT '';\n\n DECLARE pair VARCHAR(255) DEFAULT '';\n DECLARE oid INT DEFAULT '';\n DECLARE vid INT DEFAULT '';\n\n SET pair_count = substrCount(parent_id, ',') + 1;\n\n WHILE i < pair_count DO\n SET result = CONCAT(result, IF(i <= 0, '', ','));\n\n SET pair = split(parent_id, ',', i + 1);\n\n SET oid = split(pair, '-', 1) + option_id_shift;\n SET vid = split(pair, '-', 2) + option_value_id_shift;\n\n SET pair = CONCAT(oid, '-', vid);\n SET result = CONCAT(result, pair);\n\n SET i = i + 1;\n END WHILE;\n\n RETURN result;\nEND$$\n\nDELIMITER $$\nCREATE DEFINER=`user`@`localhost` FUNCTION `split` (`string` TEXT, `delim` TEXT, `n` INT) RETURNS TEXT CHARSET utf8mb4 COLLATE utf8mb4_unicode_520_ci DETERMINISTIC SQL SECURITY INVOKER RETURN IF(\n (LENGTH(string) - LENGTH(REPLACE(string, delim, ''))) / LENGTH(delim) < n - 1,\n NULL,\n SUBSTRING_INDEX(SUBSTRING_INDEX(string, delim, n), delim, -1)\n)$$\n\nDELIMITER $$\nCREATE DEFINER=`root`@`localhost` FUNCTION `substrCount` (`s` VARCHAR(255), `ss` VARCHAR(255)) RETURNS TINYINT(3) UNSIGNED DETERMINISTIC READS SQL DATA SQL SECURITY INVOKER BEGIN\nDECLARE COUNT TINYINT(3) UNSIGNED;\nDECLARE OFFSET_I TINYINT(3) UNSIGNED;\nDECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET s = NULL;\n\nSET COUNT = 0;\nSET OFFSET_I = 1;\n\nREPEAT\nIF NOT ISNULL(s) AND OFFSET_I > 0 THEN\nSET OFFSET_I = LOCATE(ss, s, OFFSET_I);\nIF OFFSET_I > 0 THEN\nSET COUNT = COUNT + 1;\nSET OFFSET_I = OFFSET_I + 1;\nEND IF;\nEND IF;\nUNTIL ISNULL(s) OR OFFSET_I = 0 END REPEAT;\n\nRETURN COUNT;\nEND$$\n\nDELIMITER ;\n\n", "byteIdx": 3084, "charIdx": 3082, "byteLen": 3085, "charLen": 3083 }, "len": 3083, "last": 3083, "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DELIMITER", "value": "DELIMITER", "keyword": null, "type": 0, "flags": 0, "position": 0 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 9 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "$$", "value": "$$", "keyword": null, "type": 9, "flags": 0, "position": 10 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 12 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CREATE", "value": "CREATE", "keyword": "CREATE", "type": 1, "flags": 3, "position": 13 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 19 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFINER", "value": "DEFINER", "keyword": "DEFINER", "type": 1, "flags": 1, "position": 20 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 27 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`user`@`localhost`", "value": "user@localhost", "keyword": null, "type": 8, "flags": 4, "position": 28 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 46 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "PROCEDURE", "value": "PROCEDURE", "keyword": "PROCEDURE", "type": 1, "flags": 3, "position": 47 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 56 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`multiDBqueryRun_V12`", "value": "multiDBqueryRun_V12", "keyword": null, "type": 8, "flags": 2, "position": 57 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 78 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "IN", "value": "IN", "keyword": "IN", "type": 1, "flags": 35, "position": 79 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 81 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`query`", "value": "query", "keyword": null, "type": 8, "flags": 2, "position": 82 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 89 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TEXT", "value": "TEXT", "keyword": "TEXT", "type": 1, "flags": 9, "position": 90 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 94 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 95 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "IN", "value": "IN", "keyword": "IN", "type": 1, "flags": 35, "position": 96 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 98 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`table_name_var`", "value": "table_name_var", "keyword": null, "type": 8, "flags": 2, "position": 99 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 115 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VARCHAR", "value": "VARCHAR", "keyword": "VARCHAR", "type": 1, "flags": 11, "position": 116 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 123 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "255", "value": 255, "keyword": null, "type": 6, "flags": 0, "position": 124 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 127 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 128 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 129 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "IN", "value": "IN", "keyword": "IN", "type": 1, "flags": 35, "position": 130 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 132 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`columns_used_var`", "value": "columns_used_var", "keyword": null, "type": 8, "flags": 2, "position": 133 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 151 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TEXT", "value": "TEXT", "keyword": "TEXT", "type": 1, "flags": 9, "position": 152 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 156 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 157 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "IN", "value": "IN", "keyword": "IN", "type": 1, "flags": 35, "position": 158 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 160 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`where_text_var`", "value": "where_text_var", "keyword": null, "type": 8, "flags": 2, "position": 161 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 177 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TEXT", "value": "TEXT", "keyword": "TEXT", "type": 1, "flags": 9, "position": 178 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 182 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 183 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "IN", "value": "IN", "keyword": "IN", "type": 1, "flags": 35, "position": 184 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 186 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`separator_value_var`", "value": "separator_value_var", "keyword": null, "type": 8, "flags": 2, "position": 187 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 208 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VARCHAR", "value": "VARCHAR", "keyword": "VARCHAR", "type": 1, "flags": 11, "position": 209 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 216 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "255", "value": 255, "keyword": null, "type": 6, "flags": 0, "position": 217 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 220 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 221 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 222 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COMMENT", "value": "COMMENT", "keyword": "COMMENT", "type": 1, "flags": 1, "position": 223 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 230 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'Query: SingleDB → MultiDB (All DBs) + run it'", "value": "Query: SingleDB → MultiDB (All DBs) + run it", "keyword": null, "type": 7, "flags": 1, "position": 231 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 277 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT", "value": "NOT", "keyword": "NOT", "type": 1, "flags": 3, "position": 278 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 281 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DETERMINISTIC", "value": "DETERMINISTIC", "keyword": "DETERMINISTIC", "type": 1, "flags": 3, "position": 282 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 295 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "MODIFIES SQL DATA", "value": "MODIFIES SQL DATA", "keyword": "MODIFIES SQL DATA", "type": 1, "flags": 7, "position": 296 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 313 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SQL SECURITY", "value": "SQL SECURITY", "keyword": "SQL SECURITY", "type": 1, "flags": 7, "position": 314 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 326 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INVOKER", "value": "INVOKER", "keyword": "INVOKER", "type": 1, "flags": 1, "position": 327 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 334 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "BEGIN", "value": "BEGIN", "keyword": "BEGIN", "type": 1, "flags": 1, "position": 335 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 340 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 341 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 344 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@TABLE_NAME", "value": "TABLE_NAME", "keyword": null, "type": 8, "flags": 1, "position": 345 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 356 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 357 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 358 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "table_name_var", "value": "table_name_var", "keyword": null, "type": 0, "flags": 0, "position": 359 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 373 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 374 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 375 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 378 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@WHERE_TEXT", "value": "WHERE_TEXT", "keyword": null, "type": 8, "flags": 1, "position": 379 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 390 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 391 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 392 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "where_text_var", "value": "where_text_var", "keyword": null, "type": 0, "flags": 0, "position": 393 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 407 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 408 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 409 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 412 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@COLUMNS_USED", "value": "COLUMNS_USED", "keyword": null, "type": 8, "flags": 1, "position": 413 }, { "@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": 2, "position": 427 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 428 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "columns_used_var", "value": "columns_used_var", "keyword": null, "type": 0, "flags": 0, "position": 429 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 445 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 446 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 447 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 450 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@MULTIDB_QUERY", "value": "MULTIDB_QUERY", "keyword": null, "type": 8, "flags": 1, "position": 451 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 465 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 466 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 467 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CONCAT", "value": "CONCAT", "keyword": "CONCAT", "type": 1, "flags": 33, "position": 468 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 474 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'SELECT \"$MULTIDB\" FROM `$MULTIDB`.'", "value": "SELECT \"$MULTIDB\" FROM `$MULTIDB`.", "keyword": null, "type": 7, "flags": 1, "position": 475 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 511 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 512 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@TABLE_NAME", "value": "TABLE_NAME", "keyword": null, "type": 8, "flags": 1, "position": 513 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 524 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 525 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@WHERE_TEXT", "value": "WHERE_TEXT", "keyword": null, "type": 8, "flags": 1, "position": 526 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 537 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 538 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 539 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- EXECUTION --", "value": "-- EXECUTION --", "keyword": null, "type": 4, "flags": 4, "position": 541 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 556 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CREATE", "value": "CREATE", "keyword": "CREATE", "type": 1, "flags": 3, "position": 557 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 563 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TEMPORARY", "value": "TEMPORARY", "keyword": "TEMPORARY", "type": 1, "flags": 1, "position": 564 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 573 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TABLE", "value": "TABLE", "keyword": "TABLE", "type": 1, "flags": 3, "position": 574 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 579 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`MULTIDB_TEMP_DB_TBL_COLS`", "value": "MULTIDB_TEMP_DB_TBL_COLS", "keyword": null, "type": 8, "flags": 2, "position": 580 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 606 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 607 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 609 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 610 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 616 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "*", "value": "*", "keyword": null, "type": 2, "flags": 16, "position": 617 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 618 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 619 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 623 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 624 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 625 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 628 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 634 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TABLE_SCHEMA", "value": "TABLE_SCHEMA", "keyword": null, "type": 0, "flags": 0, "position": 635 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 647 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 648 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TABLE_NAME", "value": "TABLE_NAME", "keyword": "TABLE_NAME", "type": 1, "flags": 1, "position": 649 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 659 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 660 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COLUMN_NAME", "value": "COLUMN_NAME", "keyword": "COLUMN_NAME", "type": 1, "flags": 1, "position": 661 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 672 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 675 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 679 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INFORMATION_SCHEMA", "value": "INFORMATION_SCHEMA", "keyword": null, "type": 0, "flags": 0, "position": 680 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 698 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COLUMNS", "value": "COLUMNS", "keyword": "COLUMNS", "type": 0, "flags": 0, "position": 699 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 706 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WHERE", "value": "WHERE", "keyword": "WHERE", "type": 1, "flags": 3, "position": 709 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 714 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TABLE_SCHEMA", "value": "TABLE_SCHEMA", "keyword": null, "type": 0, "flags": 0, "position": 719 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 731 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT IN", "value": "NOT IN", "keyword": "NOT IN", "type": 1, "flags": 39, "position": 732 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 738 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'mysql'", "value": "mysql", "keyword": null, "type": 7, "flags": 1, "position": 739 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 746 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 747 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'test'", "value": "test", "keyword": null, "type": 7, "flags": 1, "position": 748 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 754 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 755 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'tmp'", "value": "tmp", "keyword": null, "type": 7, "flags": 1, "position": 756 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 761 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 762 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'information_schema'", "value": "information_schema", "keyword": null, "type": 7, "flags": 1, "position": 763 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 783 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 784 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'sys'", "value": "sys", "keyword": null, "type": 7, "flags": 1, "position": 785 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 790 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 791 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'performance_schema'", "value": "performance_schema", "keyword": null, "type": 7, "flags": 1, "position": 792 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 812 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 813 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AND", "value": "AND", "keyword": "AND", "type": 1, "flags": 3, "position": 814 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 817 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TABLE_NAME", "value": "TABLE_NAME", "keyword": "TABLE_NAME", "type": 1, "flags": 1, "position": 822 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 832 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 833 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 834 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@TABLE_NAME", "value": "TABLE_NAME", "keyword": null, "type": 8, "flags": 1, "position": 835 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 846 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AND", "value": "AND", "keyword": "AND", "type": 1, "flags": 3, "position": 847 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 850 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FIND_IN_SET", "value": "FIND_IN_SET", "keyword": "FIND_IN_SET", "type": 1, "flags": 33, "position": 855 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 866 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COLUMN_NAME", "value": "COLUMN_NAME", "keyword": "COLUMN_NAME", "type": 1, "flags": 1, "position": 867 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 878 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 879 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@COLUMNS_USED", "value": "COLUMNS_USED", "keyword": null, "type": 8, "flags": 1, "position": 880 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 893 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 894 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 895 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 896 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "tbl", "value": "tbl", "keyword": null, "type": 0, "flags": 0, "position": 897 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 900 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "GROUP BY", "value": "GROUP BY", "keyword": "GROUP BY", "type": 1, "flags": 7, "position": 901 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 909 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TABLE_SCHEMA", "value": "TABLE_SCHEMA", "keyword": null, "type": 0, "flags": 0, "position": 912 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 924 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 925 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TABLE_NAME", "value": "TABLE_NAME", "keyword": "TABLE_NAME", "type": 1, "flags": 1, "position": 928 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 938 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 939 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 941 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 947 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "GROUP_CONCAT", "value": "GROUP_CONCAT", "keyword": "GROUP_CONCAT", "type": 1, "flags": 33, "position": 948 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 960 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "REPLACE", "value": "REPLACE", "keyword": "REPLACE", "type": 1, "flags": 35, "position": 961 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 968 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@MULTIDB_QUERY", "value": "MULTIDB_QUERY", "keyword": null, "type": 8, "flags": 1, "position": 969 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 983 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 984 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'$MULTIDB'", "value": "$MULTIDB", "keyword": null, "type": 7, "flags": 1, "position": 985 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 995 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 996 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CONCAT", "value": "CONCAT", "keyword": "CONCAT", "type": 1, "flags": 33, "position": 997 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 1003 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "''", "value": "", "keyword": null, "type": 7, "flags": 1, "position": 1004 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1006 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1007 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TABLE_SCHEMA", "value": "TABLE_SCHEMA", "keyword": null, "type": 0, "flags": 0, "position": 1008 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1020 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1021 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "''", "value": "", "keyword": null, "type": 7, "flags": 1, "position": 1022 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 1024 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 1025 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1026 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SEPARATOR", "value": "SEPARATOR", "keyword": "SEPARATOR", "type": 1, "flags": 3, "position": 1027 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1036 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\"\\nUNION ALL\\n\"", "value": "\nUNION ALL\n", "keyword": null, "type": 7, "flags": 2, "position": 1037 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 1052 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1053 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INTO", "value": "INTO", "keyword": "INTO", "type": 1, "flags": 3, "position": 1054 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1058 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@stmt_sql", "value": "stmt_sql", "keyword": null, "type": 8, "flags": 1, "position": 1059 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1068 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 1069 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1073 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`MULTIDB_TEMP_DB_TBL_COLS`", "value": "MULTIDB_TEMP_DB_TBL_COLS", "keyword": null, "type": 8, "flags": 2, "position": 1074 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1100 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1101 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "PREPARE", "value": "PREPARE", "keyword": "PREPARE", "type": 1, "flags": 1, "position": 1103 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1110 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "stmt", "value": "stmt", "keyword": null, "type": 0, "flags": 0, "position": 1111 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1115 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 1116 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1120 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@stmt_sql", "value": "stmt_sql", "keyword": null, "type": 8, "flags": 1, "position": 1121 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1130 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1131 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "EXECUTE", "value": "EXECUTE", "keyword": "EXECUTE", "type": 1, "flags": 1, "position": 1132 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1139 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "stmt", "value": "stmt", "keyword": null, "type": 0, "flags": 0, "position": 1140 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1144 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1145 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEALLOCATE", "value": "DEALLOCATE", "keyword": "DEALLOCATE", "type": 1, "flags": 1, "position": 1146 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1156 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "PREPARE", "value": "PREPARE", "keyword": "PREPARE", "type": 1, "flags": 1, "position": 1157 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1164 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "stmt", "value": "stmt", "keyword": null, "type": 0, "flags": 0, "position": 1165 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1169 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1170 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "END", "value": "END", "keyword": null, "type": 0, "flags": 0, "position": 1171 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "$$", "value": "$$", "keyword": null, "type": 9, "flags": 0, "position": 1174 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1176 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 1178 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1180 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-- Functions", "value": "-- Functions", "keyword": null, "type": 4, "flags": 4, "position": 1181 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1193 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "--\n", "value": "--\n", "keyword": null, "type": 4, "flags": 4, "position": 1194 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1196 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DELIMITER", "value": "DELIMITER", "keyword": null, "type": 0, "flags": 0, "position": 1197 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1206 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "$$", "value": "$$", "keyword": null, "type": 9, "flags": 0, "position": 1207 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1209 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CREATE", "value": "CREATE", "keyword": "CREATE", "type": 1, "flags": 3, "position": 1210 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1216 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFINER", "value": "DEFINER", "keyword": "DEFINER", "type": 1, "flags": 1, "position": 1217 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1224 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`root`@`localhost`", "value": "root@localhost", "keyword": null, "type": 8, "flags": 4, "position": 1225 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1243 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FUNCTION", "value": "FUNCTION", "keyword": "FUNCTION", "type": 1, "flags": 1, "position": 1244 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1252 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`attrParentShiftIds`", "value": "attrParentShiftIds", "keyword": null, "type": 8, "flags": 2, "position": 1253 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1273 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 1274 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`parent_id`", "value": "parent_id", "keyword": null, "type": 8, "flags": 2, "position": 1275 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1286 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TEXT", "value": "TEXT", "keyword": "TEXT", "type": 1, "flags": 9, "position": 1287 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1291 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1292 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`option_id_shift`", "value": "option_id_shift", "keyword": null, "type": 8, "flags": 2, "position": 1293 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1310 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INT", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 1311 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1314 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1315 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`option_value_id_shift`", "value": "option_value_id_shift", "keyword": null, "type": 8, "flags": 2, "position": 1316 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1339 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INT", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 1340 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 1343 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1344 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "RETURNS", "value": "RETURNS", "keyword": "RETURNS", "type": 1, "flags": 1, "position": 1345 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1352 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TEXT", "value": "TEXT", "keyword": "TEXT", "type": 1, "flags": 9, "position": 1353 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1357 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CHARSET", "value": "CHARSET", "keyword": "CHARSET", "type": 1, "flags": 33, "position": 1358 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1365 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "utf8mb4", "value": "utf8mb4", "keyword": null, "type": 0, "flags": 0, "position": 1366 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1373 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COLLATE", "value": "COLLATE", "keyword": "COLLATE", "type": 1, "flags": 3, "position": 1374 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1381 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "utf8mb4_unicode_520_ci", "value": "utf8mb4_unicode_520_ci", "keyword": null, "type": 0, "flags": 0, "position": 1382 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1404 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DETERMINISTIC", "value": "DETERMINISTIC", "keyword": "DETERMINISTIC", "type": 1, "flags": 3, "position": 1405 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1418 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "READS SQL DATA", "value": "READS SQL DATA", "keyword": "READS SQL DATA", "type": 1, "flags": 7, "position": 1419 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1433 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SQL SECURITY", "value": "SQL SECURITY", "keyword": "SQL SECURITY", "type": 1, "flags": 7, "position": 1434 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1446 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INVOKER", "value": "INVOKER", "keyword": "INVOKER", "type": 1, "flags": 1, "position": 1447 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1454 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "BEGIN", "value": "BEGIN", "keyword": "BEGIN", "type": 1, "flags": 1, "position": 1455 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1460 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DECLARE", "value": "DECLARE", "keyword": "DECLARE", "type": 1, "flags": 3, "position": 1463 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1470 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "i", "value": "i", "keyword": null, "type": 0, "flags": 0, "position": 1471 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1472 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INT", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 1473 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1476 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "UNSIGNED", "value": "UNSIGNED", "keyword": "UNSIGNED", "type": 1, "flags": 3, "position": 1477 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1485 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT", "value": "DEFAULT", "keyword": "DEFAULT", "type": 1, "flags": 35, "position": 1486 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1493 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "0", "value": 0, "keyword": null, "type": 6, "flags": 0, "position": 1494 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1495 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1496 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DECLARE", "value": "DECLARE", "keyword": "DECLARE", "type": 1, "flags": 3, "position": 1499 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1506 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "pair_count", "value": "pair_count", "keyword": null, "type": 0, "flags": 0, "position": 1507 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1517 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INT", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 1518 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1521 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "UNSIGNED", "value": "UNSIGNED", "keyword": "UNSIGNED", "type": 1, "flags": 3, "position": 1522 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1530 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1531 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DECLARE", "value": "DECLARE", "keyword": "DECLARE", "type": 1, "flags": 3, "position": 1534 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1541 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "result", "value": "result", "keyword": null, "type": 0, "flags": 0, "position": 1542 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1548 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TEXT", "value": "TEXT", "keyword": "TEXT", "type": 1, "flags": 9, "position": 1549 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1553 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT", "value": "DEFAULT", "keyword": "DEFAULT", "type": 1, "flags": 35, "position": 1554 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1561 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "''", "value": "", "keyword": null, "type": 7, "flags": 1, "position": 1562 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1564 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1565 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DECLARE", "value": "DECLARE", "keyword": "DECLARE", "type": 1, "flags": 3, "position": 1569 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1576 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "pair", "value": "pair", "keyword": null, "type": 0, "flags": 0, "position": 1577 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1581 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VARCHAR", "value": "VARCHAR", "keyword": "VARCHAR", "type": 1, "flags": 11, "position": 1582 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 1589 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "255", "value": 255, "keyword": null, "type": 6, "flags": 0, "position": 1590 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 1593 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1594 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT", "value": "DEFAULT", "keyword": "DEFAULT", "type": 1, "flags": 35, "position": 1595 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1602 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "''", "value": "", "keyword": null, "type": 7, "flags": 1, "position": 1603 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1605 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1606 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DECLARE", "value": "DECLARE", "keyword": "DECLARE", "type": 1, "flags": 3, "position": 1609 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1616 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "oid", "value": "oid", "keyword": null, "type": 0, "flags": 0, "position": 1617 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1620 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INT", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 1621 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1624 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT", "value": "DEFAULT", "keyword": "DEFAULT", "type": 1, "flags": 35, "position": 1625 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1632 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "''", "value": "", "keyword": null, "type": 7, "flags": 1, "position": 1633 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1635 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1636 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DECLARE", "value": "DECLARE", "keyword": "DECLARE", "type": 1, "flags": 3, "position": 1639 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1646 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "vid", "value": "vid", "keyword": null, "type": 0, "flags": 0, "position": 1647 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1650 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INT", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 1651 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1654 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFAULT", "value": "DEFAULT", "keyword": "DEFAULT", "type": 1, "flags": 35, "position": 1655 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1662 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "''", "value": "", "keyword": null, "type": 7, "flags": 1, "position": 1663 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1665 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1666 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 1670 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1673 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "pair_count", "value": "pair_count", "keyword": null, "type": 0, "flags": 0, "position": 1674 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1684 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1685 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1686 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "substrCount", "value": "substrCount", "keyword": null, "type": 0, "flags": 0, "position": 1687 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 1698 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "parent_id", "value": "parent_id", "keyword": null, "type": 0, "flags": 0, "position": 1699 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1708 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1709 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "','", "value": ",", "keyword": null, "type": 7, "flags": 1, "position": 1710 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 1713 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1714 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "+", "value": "+", "keyword": null, "type": 2, "flags": 1, "position": 1715 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1716 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1", "value": 1, "keyword": null, "type": 6, "flags": 0, "position": 1717 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1718 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1719 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WHILE", "value": "WHILE", "keyword": "WHILE", "type": 1, "flags": 3, "position": 1723 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1728 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "i", "value": "i", "keyword": null, "type": 0, "flags": 0, "position": 1729 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1730 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "<", "value": "<", "keyword": null, "type": 2, "flags": 2, "position": 1731 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1732 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "pair_count", "value": "pair_count", "keyword": null, "type": 0, "flags": 0, "position": 1733 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1743 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DO", "value": "DO", "keyword": "DO", "type": 1, "flags": 1, "position": 1744 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1746 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 1751 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1754 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "result", "value": "result", "keyword": null, "type": 0, "flags": 0, "position": 1755 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1761 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1762 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1763 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CONCAT", "value": "CONCAT", "keyword": "CONCAT", "type": 1, "flags": 33, "position": 1764 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 1770 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "result", "value": "result", "keyword": null, "type": 0, "flags": 0, "position": 1771 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1777 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1778 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "IF", "value": "IF", "keyword": "IF", "type": 1, "flags": 35, "position": 1779 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 1781 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "i", "value": "i", "keyword": null, "type": 0, "flags": 0, "position": 1782 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1783 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "<=", "value": "<=", "keyword": null, "type": 2, "flags": 2, "position": 1784 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1786 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "0", "value": 0, "keyword": null, "type": 6, "flags": 0, "position": 1787 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1788 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1789 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "''", "value": "", "keyword": null, "type": 7, "flags": 1, "position": 1790 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1792 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1793 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "','", "value": ",", "keyword": null, "type": 7, "flags": 1, "position": 1794 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 1797 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 1798 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1799 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1800 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 1806 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1809 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "pair", "value": "pair", "keyword": null, "type": 0, "flags": 0, "position": 1810 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1814 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1815 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1816 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "split", "value": "split", "keyword": null, "type": 0, "flags": 0, "position": 1817 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 1822 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "parent_id", "value": "parent_id", "keyword": null, "type": 0, "flags": 0, "position": 1823 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1832 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1833 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "','", "value": ",", "keyword": null, "type": 7, "flags": 1, "position": 1834 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1837 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1838 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "i", "value": "i", "keyword": null, "type": 0, "flags": 0, "position": 1839 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1840 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "+", "value": "+", "keyword": null, "type": 2, "flags": 1, "position": 1841 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1842 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1", "value": 1, "keyword": null, "type": 6, "flags": 0, "position": 1843 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 1844 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1845 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1846 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 1852 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1855 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "oid", "value": "oid", "keyword": null, "type": 0, "flags": 0, "position": 1856 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1859 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1860 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1861 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "split", "value": "split", "keyword": null, "type": 0, "flags": 0, "position": 1862 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 1867 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "pair", "value": "pair", "keyword": null, "type": 0, "flags": 0, "position": 1868 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1872 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1873 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'-'", "value": "-", "keyword": null, "type": 7, "flags": 1, "position": 1874 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1877 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1878 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1", "value": 1, "keyword": null, "type": 6, "flags": 0, "position": 1879 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 1880 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1881 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "+", "value": "+", "keyword": null, "type": 2, "flags": 1, "position": 1882 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1883 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "option_id_shift", "value": "option_id_shift", "keyword": null, "type": 0, "flags": 0, "position": 1884 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1899 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1900 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 1905 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1908 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "vid", "value": "vid", "keyword": null, "type": 0, "flags": 0, "position": 1909 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1912 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1913 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1914 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "split", "value": "split", "keyword": null, "type": 0, "flags": 0, "position": 1915 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 1920 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "pair", "value": "pair", "keyword": null, "type": 0, "flags": 0, "position": 1921 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1925 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1926 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'-'", "value": "-", "keyword": null, "type": 7, "flags": 1, "position": 1927 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1930 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1931 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "2", "value": 2, "keyword": null, "type": 6, "flags": 0, "position": 1932 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 1933 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1934 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "+", "value": "+", "keyword": null, "type": 2, "flags": 1, "position": 1935 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1936 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "option_value_id_shift", "value": "option_value_id_shift", "keyword": null, "type": 0, "flags": 0, "position": 1937 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1958 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1959 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 1965 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1968 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "pair", "value": "pair", "keyword": null, "type": 0, "flags": 0, "position": 1969 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1973 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 1974 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1975 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CONCAT", "value": "CONCAT", "keyword": "CONCAT", "type": 1, "flags": 33, "position": 1976 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 1982 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "oid", "value": "oid", "keyword": null, "type": 0, "flags": 0, "position": 1983 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1986 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1987 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'-'", "value": "-", "keyword": null, "type": 7, "flags": 1, "position": 1988 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 1991 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1992 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "vid", "value": "vid", "keyword": null, "type": 0, "flags": 0, "position": 1993 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 1996 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 1997 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 1998 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 2003 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2006 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "result", "value": "result", "keyword": null, "type": 0, "flags": 0, "position": 2007 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2013 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 2014 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2015 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CONCAT", "value": "CONCAT", "keyword": "CONCAT", "type": 1, "flags": 33, "position": 2016 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2022 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "result", "value": "result", "keyword": null, "type": 0, "flags": 0, "position": 2023 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2029 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2030 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "pair", "value": "pair", "keyword": null, "type": 0, "flags": 0, "position": 2031 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2035 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 2036 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2037 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 2043 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2046 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "i", "value": "i", "keyword": null, "type": 0, "flags": 0, "position": 2047 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2048 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 2049 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2050 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "i", "value": "i", "keyword": null, "type": 0, "flags": 0, "position": 2051 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2052 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "+", "value": "+", "keyword": null, "type": 2, "flags": 1, "position": 2053 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2054 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1", "value": 1, "keyword": null, "type": 6, "flags": 0, "position": 2055 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 2056 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2057 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "END", "value": "END", "keyword": "END", "type": 1, "flags": 1, "position": 2060 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2063 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WHILE", "value": "WHILE", "keyword": "WHILE", "type": 1, "flags": 3, "position": 2064 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 2069 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2070 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "RETURN", "value": "RETURN", "keyword": "RETURN", "type": 1, "flags": 3, "position": 2074 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2080 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "result", "value": "result", "keyword": null, "type": 0, "flags": 0, "position": 2081 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 2087 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2088 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "END", "value": "END", "keyword": null, "type": 0, "flags": 0, "position": 2089 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "$$", "value": "$$", "keyword": null, "type": 9, "flags": 0, "position": 2092 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2094 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DELIMITER", "value": "DELIMITER", "keyword": null, "type": 0, "flags": 0, "position": 2096 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2105 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "$$", "value": "$$", "keyword": null, "type": 9, "flags": 0, "position": 2106 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2108 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CREATE", "value": "CREATE", "keyword": "CREATE", "type": 1, "flags": 3, "position": 2109 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2115 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFINER", "value": "DEFINER", "keyword": "DEFINER", "type": 1, "flags": 1, "position": 2116 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 2123 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`user`@`localhost`", "value": "user@localhost", "keyword": null, "type": 8, "flags": 4, "position": 2124 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2142 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FUNCTION", "value": "FUNCTION", "keyword": "FUNCTION", "type": 1, "flags": 1, "position": 2143 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2151 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`split`", "value": "split", "keyword": null, "type": 8, "flags": 2, "position": 2152 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2159 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2160 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`string`", "value": "string", "keyword": null, "type": 8, "flags": 2, "position": 2161 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2169 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TEXT", "value": "TEXT", "keyword": "TEXT", "type": 1, "flags": 9, "position": 2170 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2174 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2175 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`delim`", "value": "delim", "keyword": null, "type": 8, "flags": 2, "position": 2176 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2183 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TEXT", "value": "TEXT", "keyword": "TEXT", "type": 1, "flags": 9, "position": 2184 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2188 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2189 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`n`", "value": "n", "keyword": null, "type": 8, "flags": 2, "position": 2190 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2193 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INT", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 2194 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2197 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2198 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "RETURNS", "value": "RETURNS", "keyword": "RETURNS", "type": 1, "flags": 1, "position": 2199 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2206 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TEXT", "value": "TEXT", "keyword": "TEXT", "type": 1, "flags": 9, "position": 2207 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2211 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CHARSET", "value": "CHARSET", "keyword": "CHARSET", "type": 1, "flags": 33, "position": 2212 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2219 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "utf8mb4", "value": "utf8mb4", "keyword": null, "type": 0, "flags": 0, "position": 2220 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2227 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COLLATE", "value": "COLLATE", "keyword": "COLLATE", "type": 1, "flags": 3, "position": 2228 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2235 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "utf8mb4_unicode_520_ci", "value": "utf8mb4_unicode_520_ci", "keyword": null, "type": 0, "flags": 0, "position": 2236 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2258 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DETERMINISTIC", "value": "DETERMINISTIC", "keyword": "DETERMINISTIC", "type": 1, "flags": 3, "position": 2259 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2272 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SQL SECURITY", "value": "SQL SECURITY", "keyword": "SQL SECURITY", "type": 1, "flags": 7, "position": 2273 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2285 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INVOKER", "value": "INVOKER", "keyword": "INVOKER", "type": 1, "flags": 1, "position": 2286 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2293 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "RETURN", "value": "RETURN", "keyword": "RETURN", "type": 1, "flags": 3, "position": 2294 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2300 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "IF", "value": "IF", "keyword": "IF", "type": 1, "flags": 35, "position": 2301 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2303 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2304 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2309 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "LENGTH", "value": "LENGTH", "keyword": "LENGTH", "type": 1, "flags": 33, "position": 2310 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2316 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "string", "value": "string", "keyword": "STRING", "type": 1, "flags": 1, "position": 2317 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2323 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2324 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-", "value": "-", "keyword": null, "type": 2, "flags": 1, "position": 2325 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2326 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "LENGTH", "value": "LENGTH", "keyword": "LENGTH", "type": 1, "flags": 33, "position": 2327 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2333 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "REPLACE", "value": "REPLACE", "keyword": "REPLACE", "type": 1, "flags": 35, "position": 2334 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2341 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "string", "value": "string", "keyword": "STRING", "type": 1, "flags": 1, "position": 2342 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2348 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2349 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "delim", "value": "delim", "keyword": null, "type": 0, "flags": 0, "position": 2350 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2355 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2356 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "''", "value": "", "keyword": null, "type": 7, "flags": 1, "position": 2357 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2359 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2360 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2361 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2362 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "/", "value": "/", "keyword": null, "type": 2, "flags": 1, "position": 2363 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2364 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "LENGTH", "value": "LENGTH", "keyword": "LENGTH", "type": 1, "flags": 33, "position": 2365 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2371 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "delim", "value": "delim", "keyword": null, "type": 0, "flags": 0, "position": 2372 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2377 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2378 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "<", "value": "<", "keyword": null, "type": 2, "flags": 2, "position": 2379 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2380 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "n", "value": "n", "keyword": null, "type": 0, "flags": 0, "position": 2381 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2382 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-", "value": "-", "keyword": null, "type": 2, "flags": 1, "position": 2383 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2384 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1", "value": 1, "keyword": null, "type": 6, "flags": 0, "position": 2385 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2386 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2387 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NULL", "value": "NULL", "keyword": "NULL", "type": 1, "flags": 3, "position": 2392 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2396 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2397 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SUBSTRING_INDEX", "value": "SUBSTRING_INDEX", "keyword": "SUBSTRING_INDEX", "type": 1, "flags": 33, "position": 2402 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2417 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SUBSTRING_INDEX", "value": "SUBSTRING_INDEX", "keyword": "SUBSTRING_INDEX", "type": 1, "flags": 33, "position": 2418 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2433 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "string", "value": "string", "keyword": "STRING", "type": 1, "flags": 1, "position": 2434 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2440 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2441 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "delim", "value": "delim", "keyword": null, "type": 0, "flags": 0, "position": 2442 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2447 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2448 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "n", "value": "n", "keyword": null, "type": 0, "flags": 0, "position": 2449 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2450 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2451 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2452 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "delim", "value": "delim", "keyword": null, "type": 0, "flags": 0, "position": 2453 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2458 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2459 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "-1", "value": -1, "keyword": null, "type": 6, "flags": 8, "position": 2460 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2462 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2463 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2464 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "$$", "value": "$$", "keyword": null, "type": 9, "flags": 0, "position": 2465 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2467 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DELIMITER", "value": "DELIMITER", "keyword": null, "type": 0, "flags": 0, "position": 2469 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2478 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "$$", "value": "$$", "keyword": null, "type": 9, "flags": 0, "position": 2479 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2481 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CREATE", "value": "CREATE", "keyword": "CREATE", "type": 1, "flags": 3, "position": 2482 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2488 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DEFINER", "value": "DEFINER", "keyword": "DEFINER", "type": 1, "flags": 1, "position": 2489 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 2496 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`root`@`localhost`", "value": "root@localhost", "keyword": null, "type": 8, "flags": 4, "position": 2497 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2515 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FUNCTION", "value": "FUNCTION", "keyword": "FUNCTION", "type": 1, "flags": 1, "position": 2516 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2524 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`substrCount`", "value": "substrCount", "keyword": null, "type": 8, "flags": 2, "position": 2525 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2538 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2539 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`s`", "value": "s", "keyword": null, "type": 8, "flags": 2, "position": 2540 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2543 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VARCHAR", "value": "VARCHAR", "keyword": "VARCHAR", "type": 1, "flags": 11, "position": 2544 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2551 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "255", "value": 255, "keyword": null, "type": 6, "flags": 0, "position": 2552 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2555 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2556 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2557 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`ss`", "value": "ss", "keyword": null, "type": 8, "flags": 2, "position": 2558 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2562 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VARCHAR", "value": "VARCHAR", "keyword": "VARCHAR", "type": 1, "flags": 11, "position": 2563 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2570 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "255", "value": 255, "keyword": null, "type": 6, "flags": 0, "position": 2571 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2574 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2575 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2576 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "RETURNS", "value": "RETURNS", "keyword": "RETURNS", "type": 1, "flags": 1, "position": 2577 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2584 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TINYINT", "value": "TINYINT", "keyword": "TINYINT", "type": 1, "flags": 11, "position": 2585 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2592 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "3", "value": 3, "keyword": null, "type": 6, "flags": 0, "position": 2593 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2594 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2595 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "UNSIGNED", "value": "UNSIGNED", "keyword": "UNSIGNED", "type": 1, "flags": 3, "position": 2596 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2604 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DETERMINISTIC", "value": "DETERMINISTIC", "keyword": "DETERMINISTIC", "type": 1, "flags": 3, "position": 2605 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2618 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "READS SQL DATA", "value": "READS SQL DATA", "keyword": "READS SQL DATA", "type": 1, "flags": 7, "position": 2619 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2633 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SQL SECURITY", "value": "SQL SECURITY", "keyword": "SQL SECURITY", "type": 1, "flags": 7, "position": 2634 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2646 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INVOKER", "value": "INVOKER", "keyword": "INVOKER", "type": 1, "flags": 1, "position": 2647 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2654 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "BEGIN", "value": "BEGIN", "keyword": "BEGIN", "type": 1, "flags": 1, "position": 2655 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2660 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DECLARE", "value": "DECLARE", "keyword": "DECLARE", "type": 1, "flags": 3, "position": 2661 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2668 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COUNT", "value": "COUNT", "keyword": "COUNT", "type": 1, "flags": 33, "position": 2669 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2674 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TINYINT", "value": "TINYINT", "keyword": "TINYINT", "type": 1, "flags": 11, "position": 2675 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2682 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "3", "value": 3, "keyword": null, "type": 6, "flags": 0, "position": 2683 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2684 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2685 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "UNSIGNED", "value": "UNSIGNED", "keyword": "UNSIGNED", "type": 1, "flags": 3, "position": 2686 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 2694 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2695 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DECLARE", "value": "DECLARE", "keyword": "DECLARE", "type": 1, "flags": 3, "position": 2696 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2703 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "OFFSET_I", "value": "OFFSET_I", "keyword": null, "type": 0, "flags": 0, "position": 2704 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2712 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TINYINT", "value": "TINYINT", "keyword": "TINYINT", "type": 1, "flags": 11, "position": 2713 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2720 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "3", "value": 3, "keyword": null, "type": 6, "flags": 0, "position": 2721 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2722 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2723 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "UNSIGNED", "value": "UNSIGNED", "keyword": "UNSIGNED", "type": 1, "flags": 3, "position": 2724 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 2732 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2733 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DECLARE", "value": "DECLARE", "keyword": "DECLARE", "type": 1, "flags": 3, "position": 2734 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2741 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CONTINUE", "value": "CONTINUE", "keyword": "CONTINUE", "type": 1, "flags": 3, "position": 2742 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2750 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "HANDLER", "value": "HANDLER", "keyword": "HANDLER", "type": 1, "flags": 1, "position": 2751 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2758 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FOR", "value": "FOR", "keyword": "FOR", "type": 1, "flags": 3, "position": 2759 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2762 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SQLSTATE", "value": "SQLSTATE", "keyword": "SQLSTATE", "type": 1, "flags": 3, "position": 2763 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2771 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'02000'", "value": "02000", "keyword": null, "type": 7, "flags": 1, "position": 2772 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2779 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 2780 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2783 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "s", "value": "s", "keyword": null, "type": 0, "flags": 0, "position": 2784 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2785 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 2786 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2787 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NULL", "value": "NULL", "keyword": "NULL", "type": 1, "flags": 3, "position": 2788 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 2792 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2793 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 2795 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2798 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COUNT", "value": "COUNT", "keyword": "COUNT", "type": 1, "flags": 33, "position": 2799 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2804 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 2805 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2806 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "0", "value": 0, "keyword": null, "type": 6, "flags": 0, "position": 2807 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 2808 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2809 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 2810 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2813 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "OFFSET_I", "value": "OFFSET_I", "keyword": null, "type": 0, "flags": 0, "position": 2814 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2822 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 2823 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2824 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1", "value": 1, "keyword": null, "type": 6, "flags": 0, "position": 2825 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 2826 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2827 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "REPEAT", "value": "REPEAT", "keyword": "REPEAT", "type": 1, "flags": 35, "position": 2829 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2835 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "IF", "value": "IF", "keyword": "IF", "type": 1, "flags": 35, "position": 2836 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2838 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT", "value": "NOT", "keyword": "NOT", "type": 1, "flags": 3, "position": 2839 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2842 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ISNULL", "value": "ISNULL", "keyword": "ISNULL", "type": 1, "flags": 33, "position": 2843 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2849 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "s", "value": "s", "keyword": null, "type": 0, "flags": 0, "position": 2850 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2851 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2852 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AND", "value": "AND", "keyword": "AND", "type": 1, "flags": 3, "position": 2853 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2856 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "OFFSET_I", "value": "OFFSET_I", "keyword": null, "type": 0, "flags": 0, "position": 2857 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2865 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ">", "value": ">", "keyword": null, "type": 2, "flags": 2, "position": 2866 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2867 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "0", "value": 0, "keyword": null, "type": 6, "flags": 0, "position": 2868 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2869 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "THEN", "value": "THEN", "keyword": "THEN", "type": 1, "flags": 3, "position": 2870 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2874 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 2875 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2878 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "OFFSET_I", "value": "OFFSET_I", "keyword": null, "type": 0, "flags": 0, "position": 2879 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2887 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 2888 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2889 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "LOCATE", "value": "LOCATE", "keyword": "LOCATE", "type": 1, "flags": 33, "position": 2890 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 2896 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ss", "value": "ss", "keyword": null, "type": 0, "flags": 0, "position": 2897 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2899 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2900 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "s", "value": "s", "keyword": null, "type": 0, "flags": 0, "position": 2901 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 2902 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2903 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "OFFSET_I", "value": "OFFSET_I", "keyword": null, "type": 0, "flags": 0, "position": 2904 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 2912 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 2913 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2914 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "IF", "value": "IF", "keyword": "IF", "type": 1, "flags": 35, "position": 2915 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2917 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "OFFSET_I", "value": "OFFSET_I", "keyword": null, "type": 0, "flags": 0, "position": 2918 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2926 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ">", "value": ">", "keyword": null, "type": 2, "flags": 2, "position": 2927 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2928 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "0", "value": 0, "keyword": null, "type": 6, "flags": 0, "position": 2929 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2930 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "THEN", "value": "THEN", "keyword": "THEN", "type": 1, "flags": 3, "position": 2931 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2935 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 2936 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2939 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COUNT", "value": "COUNT", "keyword": "COUNT", "type": 1, "flags": 33, "position": 2940 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2945 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 2946 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2947 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COUNT", "value": "COUNT", "keyword": "COUNT", "type": 1, "flags": 33, "position": 2948 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2953 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "+", "value": "+", "keyword": null, "type": 2, "flags": 1, "position": 2954 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2955 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1", "value": 1, "keyword": null, "type": 6, "flags": 0, "position": 2956 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 2957 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2958 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SET", "value": "SET", "keyword": "SET", "type": 1, "flags": 11, "position": 2959 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2962 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "OFFSET_I", "value": "OFFSET_I", "keyword": null, "type": 0, "flags": 0, "position": 2963 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2971 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 2972 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2973 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "OFFSET_I", "value": "OFFSET_I", "keyword": null, "type": 0, "flags": 0, "position": 2974 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2982 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "+", "value": "+", "keyword": null, "type": 2, "flags": 1, "position": 2983 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2984 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1", "value": 1, "keyword": null, "type": 6, "flags": 0, "position": 2985 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 2986 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2987 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "END", "value": "END", "keyword": "END", "type": 1, "flags": 1, "position": 2988 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2991 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "IF", "value": "IF", "keyword": "IF", "type": 1, "flags": 35, "position": 2992 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 2994 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2995 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "END", "value": "END", "keyword": "END", "type": 1, "flags": 1, "position": 2996 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 2999 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "IF", "value": "IF", "keyword": "IF", "type": 1, "flags": 35, "position": 3000 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 3002 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 3003 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "UNTIL", "value": "UNTIL", "keyword": "UNTIL", "type": 1, "flags": 1, "position": 3004 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 3009 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ISNULL", "value": "ISNULL", "keyword": "ISNULL", "type": 1, "flags": 33, "position": 3010 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 3016 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "s", "value": "s", "keyword": null, "type": 0, "flags": 0, "position": 3017 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 3018 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 3019 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "OR", "value": "OR", "keyword": "OR", "type": 1, "flags": 3, "position": 3020 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 3022 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "OFFSET_I", "value": "OFFSET_I", "keyword": null, "type": 0, "flags": 0, "position": 3023 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 3031 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 3032 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 3033 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "0", "value": 0, "keyword": null, "type": 6, "flags": 0, "position": 3034 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 3035 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "END", "value": "END", "keyword": "END", "type": 1, "flags": 1, "position": 3036 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 3039 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "REPEAT", "value": "REPEAT", "keyword": "REPEAT", "type": 1, "flags": 35, "position": 3040 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 3046 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 3047 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "RETURN", "value": "RETURN", "keyword": "RETURN", "type": 1, "flags": 3, "position": 3049 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 3055 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "COUNT", "value": "COUNT", "keyword": "COUNT", "type": 1, "flags": 33, "position": 3056 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 2, "flags": 16, "position": 3061 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 3062 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "END", "value": "END", "keyword": null, "type": 0, "flags": 0, "position": 3063 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "$$", "value": "$$", "keyword": null, "type": 9, "flags": 0, "position": 3066 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 3068 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DELIMITER", "value": "DELIMITER", "keyword": null, "type": 0, "flags": 0, "position": 3070 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 3079 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 3080 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 3081 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 926, "idx": 926 }, "delimiter": ";", "delimiterLen": 1, "strict": false, "errors": [] }, "parser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "@2" }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement", "name": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "multiDBqueryRun_V12", "column": null, "expr": "`multiDBqueryRun_V12`", "alias": null, "function": null, "subquery": null }, "entityOptions": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "2": { "name": "NOT", "equals": false, "expr": "DETERMINISTIC", "value": "DETERMINISTIC" }, "4": "MODIFIES SQL DATA", "6": { "name": "SQL SECURITY", "equals": false, "expr": "INVOKER", "value": "INVOKER" }, "8": { "name": "COMMENT", "equals": false, "expr": "'Query: SingleDB → MultiDB (All DBs) + run it'", "value": "Query: SingleDB → MultiDB (All DBs) + run it" } } }, "fields": null, "with": null, "select": null, "like": null, "partitionBy": null, "partitionsNum": null, "subpartitionBy": null, "subpartitionsNum": null, "partitions": null, "table": null, "return": null, "parameters": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\ParameterDefinition", "name": "query", "inOut": "IN", "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "TEXT", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\ParameterDefinition", "name": "table_name_var", "inOut": "IN", "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "VARCHAR", "parameters": [ "255" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\ParameterDefinition", "name": "columns_used_var", "inOut": "IN", "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "TEXT", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\ParameterDefinition", "name": "where_text_var", "inOut": "IN", "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "TEXT", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\ParameterDefinition", "name": "separator_value_var", "inOut": "IN", "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "VARCHAR", "parameters": [ "255" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } } ], "body": [ { "@type": "@72" }, { "@type": "@73" }, { "@type": "@74" }, { "@type": "@75" }, { "@type": "@76" }, { "@type": "@77" }, { "@type": "@78" }, { "@type": "@79" }, { "@type": "@80" }, { "@type": "@81" }, { "@type": "@82" }, { "@type": "@83" }, { "@type": "@84" }, { "@type": "@85" }, { "@type": "@86" }, { "@type": "@87" }, { "@type": "@88" }, { "@type": "@89" }, { "@type": "@90" }, { "@type": "@91" }, { "@type": "@92" }, { "@type": "@93" }, { "@type": "@94" }, { "@type": "@95" }, { "@type": "@96" }, { "@type": "@97" }, { "@type": "@98" }, { "@type": "@99" }, { "@type": "@100" }, { "@type": "@101" }, { "@type": "@102" }, { "@type": "@103" }, { "@type": "@104" }, { "@type": "@105" }, { "@type": "@106" }, { "@type": "@107" }, { "@type": "@108" }, { "@type": "@109" }, { "@type": "@110" }, { "@type": "@111" }, { "@type": "@112" }, { "@type": "@113" }, { "@type": "@114" }, { "@type": "@115" }, { "@type": "@116" }, { "@type": "@117" }, { "@type": "@118" }, { "@type": "@119" }, { "@type": "@120" }, { "@type": "@121" }, { "@type": "@122" }, { "@type": "@123" }, { "@type": "@124" }, { "@type": "@125" }, { "@type": "@126" }, { "@type": "@127" }, { "@type": "@128" }, { "@type": "@129" }, { "@type": "@130" }, { "@type": "@131" }, { "@type": "@132" }, { "@type": "@133" }, { "@type": "@134" }, { "@type": "@135" }, { "@type": "@136" }, { "@type": "@137" }, { "@type": "@138" }, { "@type": "@139" }, { "@type": "@140" }, { "@type": "@141" }, { "@type": "@142" }, { "@type": "@143" }, { "@type": "@144" }, { "@type": "@145" }, { "@type": "@146" }, { "@type": "@147" }, { "@type": "@148" }, { "@type": "@149" }, { "@type": "@150" }, { "@type": "@151" }, { "@type": "@152" }, { "@type": "@153" }, { "@type": "@154" }, { "@type": "@155" }, { "@type": "@156" }, { "@type": "@157" }, { "@type": "@158" }, { "@type": "@159" }, { "@type": "@160" }, { "@type": "@161" }, { "@type": "@162" }, { "@type": "@163" }, { "@type": "@164" }, { "@type": "@165" }, { "@type": "@166" }, { "@type": "@167" }, { "@type": "@168" }, { "@type": "@169" }, { "@type": "@170" }, { "@type": "@171" }, { "@type": "@172" }, { "@type": "@173" }, { "@type": "@174" }, { "@type": "@175" }, { "@type": "@176" }, { "@type": "@177" }, { "@type": "@178" }, { "@type": "@179" }, { "@type": "@180" }, { "@type": "@181" }, { "@type": "@182" }, { "@type": "@183" }, { "@type": "@184" }, { "@type": "@185" }, { "@type": "@186" }, { "@type": "@187" }, { "@type": "@188" }, { "@type": "@189" }, { "@type": "@190" }, { "@type": "@191" }, { "@type": "@192" }, { "@type": "@193" }, { "@type": "@194" }, { "@type": "@195" }, { "@type": "@196" }, { "@type": "@197" }, { "@type": "@198" }, { "@type": "@199" }, { "@type": "@200" }, { "@type": "@201" }, { "@type": "@202" }, { "@type": "@203" }, { "@type": "@204" }, { "@type": "@205" }, { "@type": "@206" }, { "@type": "@207" }, { "@type": "@208" }, { "@type": "@209" }, { "@type": "@210" }, { "@type": "@211" }, { "@type": "@212" }, { "@type": "@213" }, { "@type": "@214" }, { "@type": "@215" }, { "@type": "@216" }, { "@type": "@217" }, { "@type": "@218" }, { "@type": "@219" }, { "@type": "@220" }, { "@type": "@221" }, { "@type": "@222" }, { "@type": "@223" }, { "@type": "@224" }, { "@type": "@225" }, { "@type": "@226" }, { "@type": "@227" }, { "@type": "@228" }, { "@type": "@229" }, { "@type": "@230" }, { "@type": "@231" }, { "@type": "@232" }, { "@type": "@233" }, { "@type": "@234" }, { "@type": "@235" }, { "@type": "@236" }, { "@type": "@237" }, { "@type": "@238" }, { "@type": "@239" }, { "@type": "@240" }, { "@type": "@241" }, { "@type": "@242" }, { "@type": "@243" }, { "@type": "@244" }, { "@type": "@245" }, { "@type": "@246" }, { "@type": "@247" }, { "@type": "@248" }, { "@type": "@249" }, { "@type": "@250" }, { "@type": "@251" }, { "@type": "@252" }, { "@type": "@253" }, { "@type": "@254" }, { "@type": "@255" }, { "@type": "@256" }, { "@type": "@257" }, { "@type": "@258" }, { "@type": "@259" }, { "@type": "@260" }, { "@type": "@261" }, { "@type": "@262" }, { "@type": "@263" }, { "@type": "@264" }, { "@type": "@265" }, { "@type": "@266" }, { "@type": "@267" }, { "@type": "@268" } ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "4": { "name": "DEFINER", "equals": true, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": "user@localhost", "expr": "`user`@`localhost`", "alias": null, "function": null, "subquery": null }, "value": "`user`@`localhost`" }, "6": "PROCEDURE" } }, "first": 4, "last": 266 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement", "name": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "attrParentShiftIds", "column": null, "expr": "`attrParentShiftIds`", "alias": null, "function": null, "subquery": null }, "entityOptions": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "2": "DETERMINISTIC", "4": "READS SQL DATA", "6": { "name": "SQL SECURITY", "equals": false, "expr": "INVOKER", "value": "INVOKER" } } }, "fields": null, "with": null, "select": null, "like": null, "partitionBy": null, "partitionsNum": null, "subpartitionBy": null, "subpartitionsNum": null, "partitions": null, "table": null, "return": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "TEXT", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "2": { "name": "CHARSET", "equals": false, "expr": "utf8mb4", "value": "utf8mb4" }, "3": { "name": "COLLATE", "equals": false, "expr": "utf8mb4_unicode_520_ci", "value": "utf8mb4_unicode_520_ci" } } } }, "parameters": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\ParameterDefinition", "name": "parent_id", "inOut": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "TEXT", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\ParameterDefinition", "name": "option_id_shift", "inOut": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "INT", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\ParameterDefinition", "name": "option_value_id_shift", "inOut": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "INT", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } } ], "body": [ { "@type": "@327" }, { "@type": "@328" }, { "@type": "@329" }, { "@type": "@330" }, { "@type": "@331" }, { "@type": "@332" }, { "@type": "@333" }, { "@type": "@334" }, { "@type": "@335" }, { "@type": "@336" }, { "@type": "@337" }, { "@type": "@338" }, { "@type": "@339" }, { "@type": "@340" }, { "@type": "@341" }, { "@type": "@342" }, { "@type": "@343" }, { "@type": "@344" }, { "@type": "@345" }, { "@type": "@346" }, { "@type": "@347" }, { "@type": "@348" }, { "@type": "@349" }, { "@type": "@350" }, { "@type": "@351" }, { "@type": "@352" }, { "@type": "@353" }, { "@type": "@354" }, { "@type": "@355" }, { "@type": "@356" }, { "@type": "@357" }, { "@type": "@358" }, { "@type": "@359" }, { "@type": "@360" }, { "@type": "@361" }, { "@type": "@362" }, { "@type": "@363" }, { "@type": "@364" }, { "@type": "@365" }, { "@type": "@366" }, { "@type": "@367" }, { "@type": "@368" }, { "@type": "@369" }, { "@type": "@370" }, { "@type": "@371" }, { "@type": "@372" }, { "@type": "@373" }, { "@type": "@374" }, { "@type": "@375" }, { "@type": "@376" }, { "@type": "@377" }, { "@type": "@378" }, { "@type": "@379" }, { "@type": "@380" }, { "@type": "@381" }, { "@type": "@382" }, { "@type": "@383" }, { "@type": "@384" }, { "@type": "@385" }, { "@type": "@386" }, { "@type": "@387" }, { "@type": "@388" }, { "@type": "@389" }, { "@type": "@390" }, { "@type": "@391" }, { "@type": "@392" }, { "@type": "@393" }, { "@type": "@394" }, { "@type": "@395" }, { "@type": "@396" }, { "@type": "@397" }, { "@type": "@398" }, { "@type": "@399" }, { "@type": "@400" }, { "@type": "@401" }, { "@type": "@402" }, { "@type": "@403" }, { "@type": "@404" }, { "@type": "@405" }, { "@type": "@406" }, { "@type": "@407" }, { "@type": "@408" }, { "@type": "@409" }, { "@type": "@410" }, { "@type": "@411" }, { "@type": "@412" }, { "@type": "@413" }, { "@type": "@414" }, { "@type": "@415" }, { "@type": "@416" }, { "@type": "@417" }, { "@type": "@418" }, { "@type": "@419" }, { "@type": "@420" }, { "@type": "@421" }, { "@type": "@422" }, { "@type": "@423" }, { "@type": "@424" }, { "@type": "@425" }, { "@type": "@426" }, { "@type": "@427" }, { "@type": "@428" }, { "@type": "@429" }, { "@type": "@430" }, { "@type": "@431" }, { "@type": "@432" }, { "@type": "@433" }, { "@type": "@434" }, { "@type": "@435" }, { "@type": "@436" }, { "@type": "@437" }, { "@type": "@438" }, { "@type": "@439" }, { "@type": "@440" }, { "@type": "@441" }, { "@type": "@442" }, { "@type": "@443" }, { "@type": "@444" }, { "@type": "@445" }, { "@type": "@446" }, { "@type": "@447" }, { "@type": "@448" }, { "@type": "@449" }, { "@type": "@450" }, { "@type": "@451" }, { "@type": "@452" }, { "@type": "@453" }, { "@type": "@454" }, { "@type": "@455" }, { "@type": "@456" }, { "@type": "@457" }, { "@type": "@458" }, { "@type": "@459" }, { "@type": "@460" }, { "@type": "@461" }, { "@type": "@462" }, { "@type": "@463" }, { "@type": "@464" }, { "@type": "@465" }, { "@type": "@466" }, { "@type": "@467" }, { "@type": "@468" }, { "@type": "@469" }, { "@type": "@470" }, { "@type": "@471" }, { "@type": "@472" }, { "@type": "@473" }, { "@type": "@474" }, { "@type": "@475" }, { "@type": "@476" }, { "@type": "@477" }, { "@type": "@478" }, { "@type": "@479" }, { "@type": "@480" }, { "@type": "@481" }, { "@type": "@482" }, { "@type": "@483" }, { "@type": "@484" }, { "@type": "@485" }, { "@type": "@486" }, { "@type": "@487" }, { "@type": "@488" }, { "@type": "@489" }, { "@type": "@490" }, { "@type": "@491" }, { "@type": "@492" }, { "@type": "@493" }, { "@type": "@494" }, { "@type": "@495" }, { "@type": "@496" }, { "@type": "@497" }, { "@type": "@498" }, { "@type": "@499" }, { "@type": "@500" }, { "@type": "@501" }, { "@type": "@502" }, { "@type": "@503" }, { "@type": "@504" }, { "@type": "@505" }, { "@type": "@506" }, { "@type": "@507" }, { "@type": "@508" }, { "@type": "@509" }, { "@type": "@510" }, { "@type": "@511" }, { "@type": "@512" }, { "@type": "@513" }, { "@type": "@514" }, { "@type": "@515" }, { "@type": "@516" }, { "@type": "@517" }, { "@type": "@518" }, { "@type": "@519" }, { "@type": "@520" }, { "@type": "@521" }, { "@type": "@522" }, { "@type": "@523" }, { "@type": "@524" }, { "@type": "@525" }, { "@type": "@526" }, { "@type": "@527" }, { "@type": "@528" }, { "@type": "@529" }, { "@type": "@530" }, { "@type": "@531" }, { "@type": "@532" }, { "@type": "@533" }, { "@type": "@534" }, { "@type": "@535" }, { "@type": "@536" }, { "@type": "@537" }, { "@type": "@538" }, { "@type": "@539" }, { "@type": "@540" }, { "@type": "@541" }, { "@type": "@542" }, { "@type": "@543" }, { "@type": "@544" }, { "@type": "@545" }, { "@type": "@546" }, { "@type": "@547" }, { "@type": "@548" }, { "@type": "@549" }, { "@type": "@550" }, { "@type": "@551" }, { "@type": "@552" }, { "@type": "@553" }, { "@type": "@554" }, { "@type": "@555" }, { "@type": "@556" }, { "@type": "@557" }, { "@type": "@558" }, { "@type": "@559" }, { "@type": "@560" }, { "@type": "@561" }, { "@type": "@562" }, { "@type": "@563" }, { "@type": "@564" }, { "@type": "@565" }, { "@type": "@566" }, { "@type": "@567" }, { "@type": "@568" }, { "@type": "@569" }, { "@type": "@570" }, { "@type": "@571" }, { "@type": "@572" }, { "@type": "@573" }, { "@type": "@574" }, { "@type": "@575" }, { "@type": "@576" }, { "@type": "@577" } ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "4": { "name": "DEFINER", "equals": true, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": "root@localhost", "expr": "`root`@`localhost`", "alias": null, "function": null, "subquery": null }, "value": "`root`@`localhost`" }, "6": "FUNCTION" } }, "first": 278, "last": 575 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement", "name": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "split", "column": null, "expr": "`split`", "alias": null, "function": null, "subquery": null }, "entityOptions": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "2": "DETERMINISTIC", "6": { "name": "SQL SECURITY", "equals": false, "expr": "INVOKER", "value": "INVOKER" } } }, "fields": null, "with": null, "select": null, "like": null, "partitionBy": null, "partitionsNum": null, "subpartitionBy": null, "subpartitionsNum": null, "partitions": null, "table": null, "return": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "TEXT", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "2": { "name": "CHARSET", "equals": false, "expr": "utf8mb4", "value": "utf8mb4" }, "3": { "name": "COLLATE", "equals": false, "expr": "utf8mb4_unicode_520_ci", "value": "utf8mb4_unicode_520_ci" } } } }, "parameters": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\ParameterDefinition", "name": "string", "inOut": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "TEXT", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\ParameterDefinition", "name": "delim", "inOut": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "TEXT", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\ParameterDefinition", "name": "n", "inOut": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "INT", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } } ], "body": [ { "@type": "@628" }, { "@type": "@629" }, { "@type": "@630" }, { "@type": "@631" }, { "@type": "@632" }, { "@type": "@633" }, { "@type": "@634" }, { "@type": "@635" }, { "@type": "@636" }, { "@type": "@637" }, { "@type": "@638" }, { "@type": "@639" }, { "@type": "@640" }, { "@type": "@641" }, { "@type": "@642" }, { "@type": "@643" }, { "@type": "@644" }, { "@type": "@645" }, { "@type": "@646" }, { "@type": "@647" }, { "@type": "@648" }, { "@type": "@649" }, { "@type": "@650" }, { "@type": "@651" }, { "@type": "@652" }, { "@type": "@653" }, { "@type": "@654" }, { "@type": "@655" }, { "@type": "@656" }, { "@type": "@657" }, { "@type": "@658" }, { "@type": "@659" }, { "@type": "@660" }, { "@type": "@661" }, { "@type": "@662" }, { "@type": "@663" }, { "@type": "@664" }, { "@type": "@665" }, { "@type": "@666" }, { "@type": "@667" }, { "@type": "@668" }, { "@type": "@669" }, { "@type": "@670" }, { "@type": "@671" }, { "@type": "@672" }, { "@type": "@673" }, { "@type": "@674" }, { "@type": "@675" }, { "@type": "@676" }, { "@type": "@677" }, { "@type": "@678" }, { "@type": "@679" }, { "@type": "@680" }, { "@type": "@681" }, { "@type": "@682" }, { "@type": "@683" }, { "@type": "@684" }, { "@type": "@685" }, { "@type": "@686" }, { "@type": "@687" }, { "@type": "@688" }, { "@type": "@689" }, { "@type": "@690" }, { "@type": "@691" }, { "@type": "@692" }, { "@type": "@693" }, { "@type": "@694" }, { "@type": "@695" } ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "4": { "name": "DEFINER", "equals": true, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": "user@localhost", "expr": "`user`@`localhost`", "alias": null, "function": null, "subquery": null }, "value": "`user`@`localhost`" }, "6": "FUNCTION" } }, "first": 581, "last": 693 }, { "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement", "name": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "substrCount", "column": null, "expr": "`substrCount`", "alias": null, "function": null, "subquery": null }, "entityOptions": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "2": "DETERMINISTIC", "4": "READS SQL DATA", "6": { "name": "SQL SECURITY", "equals": false, "expr": "INVOKER", "value": "INVOKER" } } }, "fields": null, "with": null, "select": null, "like": null, "partitionBy": null, "partitionsNum": null, "subpartitionBy": null, "subpartitionsNum": null, "partitions": null, "table": null, "return": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "TINYINT", "parameters": [ "3" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "4": "UNSIGNED" } } }, "parameters": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\ParameterDefinition", "name": "s", "inOut": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "VARCHAR", "parameters": [ "255" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\ParameterDefinition", "name": "ss", "inOut": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "VARCHAR", "parameters": [ "255" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } } ], "body": [ { "@type": "@746" }, { "@type": "@747" }, { "@type": "@748" }, { "@type": "@749" }, { "@type": "@750" }, { "@type": "@751" }, { "@type": "@752" }, { "@type": "@753" }, { "@type": "@754" }, { "@type": "@755" }, { "@type": "@756" }, { "@type": "@757" }, { "@type": "@758" }, { "@type": "@759" }, { "@type": "@760" }, { "@type": "@761" }, { "@type": "@762" }, { "@type": "@763" }, { "@type": "@764" }, { "@type": "@765" }, { "@type": "@766" }, { "@type": "@767" }, { "@type": "@768" }, { "@type": "@769" }, { "@type": "@770" }, { "@type": "@771" }, { "@type": "@772" }, { "@type": "@773" }, { "@type": "@774" }, { "@type": "@775" }, { "@type": "@776" }, { "@type": "@777" }, { "@type": "@778" }, { "@type": "@779" }, { "@type": "@780" }, { "@type": "@781" }, { "@type": "@782" }, { "@type": "@783" }, { "@type": "@784" }, { "@type": "@785" }, { "@type": "@786" }, { "@type": "@787" }, { "@type": "@788" }, { "@type": "@789" }, { "@type": "@790" }, { "@type": "@791" }, { "@type": "@792" }, { "@type": "@793" }, { "@type": "@794" }, { "@type": "@795" }, { "@type": "@796" }, { "@type": "@797" }, { "@type": "@798" }, { "@type": "@799" }, { "@type": "@800" }, { "@type": "@801" }, { "@type": "@802" }, { "@type": "@803" }, { "@type": "@804" }, { "@type": "@805" }, { "@type": "@806" }, { "@type": "@807" }, { "@type": "@808" }, { "@type": "@809" }, { "@type": "@810" }, { "@type": "@811" }, { "@type": "@812" }, { "@type": "@813" }, { "@type": "@814" }, { "@type": "@815" }, { "@type": "@816" }, { "@type": "@817" }, { "@type": "@818" }, { "@type": "@819" }, { "@type": "@820" }, { "@type": "@821" }, { "@type": "@822" }, { "@type": "@823" }, { "@type": "@824" }, { "@type": "@825" }, { "@type": "@826" }, { "@type": "@827" }, { "@type": "@828" }, { "@type": "@829" }, { "@type": "@830" }, { "@type": "@831" }, { "@type": "@832" }, { "@type": "@833" }, { "@type": "@834" }, { "@type": "@835" }, { "@type": "@836" }, { "@type": "@837" }, { "@type": "@838" }, { "@type": "@839" }, { "@type": "@840" }, { "@type": "@841" }, { "@type": "@842" }, { "@type": "@843" }, { "@type": "@844" }, { "@type": "@845" }, { "@type": "@846" }, { "@type": "@847" }, { "@type": "@848" }, { "@type": "@849" }, { "@type": "@850" }, { "@type": "@851" }, { "@type": "@852" }, { "@type": "@853" }, { "@type": "@854" }, { "@type": "@855" }, { "@type": "@856" }, { "@type": "@857" }, { "@type": "@858" }, { "@type": "@859" }, { "@type": "@860" }, { "@type": "@861" }, { "@type": "@862" }, { "@type": "@863" }, { "@type": "@864" }, { "@type": "@865" }, { "@type": "@866" }, { "@type": "@867" }, { "@type": "@868" }, { "@type": "@869" }, { "@type": "@870" }, { "@type": "@871" }, { "@type": "@872" }, { "@type": "@873" }, { "@type": "@874" }, { "@type": "@875" }, { "@type": "@876" }, { "@type": "@877" }, { "@type": "@878" }, { "@type": "@879" }, { "@type": "@880" }, { "@type": "@881" }, { "@type": "@882" }, { "@type": "@883" }, { "@type": "@884" }, { "@type": "@885" }, { "@type": "@886" }, { "@type": "@887" }, { "@type": "@888" }, { "@type": "@889" }, { "@type": "@890" }, { "@type": "@891" }, { "@type": "@892" }, { "@type": "@893" }, { "@type": "@894" }, { "@type": "@895" }, { "@type": "@896" }, { "@type": "@897" }, { "@type": "@898" }, { "@type": "@899" }, { "@type": "@900" }, { "@type": "@901" }, { "@type": "@902" }, { "@type": "@903" }, { "@type": "@904" }, { "@type": "@905" }, { "@type": "@906" }, { "@type": "@907" }, { "@type": "@908" }, { "@type": "@909" }, { "@type": "@910" }, { "@type": "@911" }, { "@type": "@912" }, { "@type": "@913" }, { "@type": "@914" }, { "@type": "@915" }, { "@type": "@916" }, { "@type": "@917" }, { "@type": "@918" }, { "@type": "@919" }, { "@type": "@920" }, { "@type": "@921" } ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "4": { "name": "DEFINER", "equals": true, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": "root@localhost", "expr": "`root`@`localhost`", "alias": null, "function": null, "subquery": null }, "value": "`root`@`localhost`" }, "6": "FUNCTION" } }, "first": 699, "last": 919 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }