phpmyadmin working

1 files changed, 367 insertions, 0 deletions

diff --git a/srcs/phpmyadmin/js/doclinks.js b/srcs/phpmyadmin/js/doclinks.js
new file mode 100644
index 0000000..bb3eb92
--- /dev/null
+++ b/srcs/phpmyadmin/js/doclinks.js
@@ -0,0 +1,367 @@
+/**
+ * Definition of links to MySQL documentation.
+ */
+
+// eslint-disable-next-line no-unused-vars
+var mysqlDocKeyword = {
+    /* Multi word */
+    'CHARACTER SET': ['charset'],
+    'SHOW AUTHORS': ['show-authors'],
+    'SHOW BINARY LOGS': ['show-binary-logs'],
+    'SHOW BINLOG EVENTS': ['show-binlog-events'],
+    'SHOW CHARACTER SET': ['show-character-set'],
+    'SHOW COLLATION': ['show-collation'],
+    'SHOW COLUMNS': ['show-columns'],
+    'SHOW CONTRIBUTORS': ['show-contributors'],
+    'SHOW CREATE DATABASE': ['show-create-database'],
+    'SHOW CREATE EVENT': ['show-create-event'],
+    'SHOW CREATE FUNCTION': ['show-create-function'],
+    'SHOW CREATE PROCEDURE': ['show-create-procedure'],
+    'SHOW CREATE TABLE': ['show-create-table'],
+    'SHOW CREATE TRIGGER': ['show-create-trigger'],
+    'SHOW CREATE VIEW': ['show-create-view'],
+    'SHOW DATABASES': ['show-databases'],
+    'SHOW ENGINE': ['show-engine'],
+    'SHOW ENGINES': ['show-engines'],
+    'SHOW ERRORS': ['show-errors'],
+    'SHOW EVENTS': ['show-events'],
+    'SHOW FUNCTION CODE': ['show-function-code'],
+    'SHOW FUNCTION STATUS': ['show-function-status'],
+    'SHOW GRANTS': ['show-grants'],
+    'SHOW INDEX': ['show-index'],
+    'SHOW MASTER STATUS': ['show-master-status'],
+    'SHOW OPEN TABLES': ['show-open-tables'],
+    'SHOW PLUGINS': ['show-plugins'],
+    'SHOW PRIVILEGES': ['show-privileges'],
+    'SHOW PROCEDURE CODE': ['show-procedure-code'],
+    'SHOW PROCEDURE STATUS': ['show-procedure-status'],
+    'SHOW PROCESSLIST': ['show-processlist'],
+    'SHOW PROFILE': ['show-profile'],
+    'SHOW PROFILES': ['show-profiles'],
+    'SHOW RELAYLOG EVENTS': ['show-relaylog-events'],
+    'SHOW SLAVE HOSTS': ['show-slave-hosts'],
+    'SHOW SLAVE STATUS': ['show-slave-status'],
+    'SHOW STATUS': ['show-status'],
+    'SHOW TABLE STATUS': ['show-table-status'],
+    'SHOW TABLES': ['show-tables'],
+    'SHOW TRIGGERS': ['show-triggers'],
+    'SHOW VARIABLES': ['show-variables'],
+    'SHOW WARNINGS': ['show-warnings'],
+    'LOAD DATA INFILE': ['load-data'],
+    'LOAD XML': ['load-xml'],
+    'LOCK TABLES': ['lock-tables'],
+    'UNLOCK TABLES': ['lock-tables'],
+    'ALTER DATABASE': ['alter-database'],
+    'ALTER EVENT': ['alter-event'],
+    'ALTER LOGFILE GROUP': ['alter-logfile-group'],
+    'ALTER FUNCTION': ['alter-function'],
+    'ALTER PROCEDURE': ['alter-procedure'],
+    'ALTER SERVER': ['alter-server'],
+    'ALTER TABLE': ['alter-table'],
+    'ALTER TABLESPACE': ['alter-tablespace'],
+    'ALTER VIEW': ['alter-view'],
+    'CREATE DATABASE': ['create-database'],
+    'CREATE EVENT': ['create-event'],
+    'CREATE FUNCTION': ['create-function'],
+    'CREATE INDEX': ['create-index'],
+    'CREATE LOGFILE GROUP': ['create-logfile-group'],
+    'CREATE PROCEDURE': ['create-procedure'],
+    'CREATE SERVER': ['create-server'],
+    'CREATE TABLE': ['create-table'],
+    'CREATE TABLESPACE': ['create-tablespace'],
+    'CREATE TRIGGER': ['create-trigger'],
+    'CREATE VIEW': ['create-view'],
+    'DROP DATABASE': ['drop-database'],
+    'DROP EVENT': ['drop-event'],
+    'DROP FUNCTION': ['drop-function'],
+    'DROP INDEX': ['drop-index'],
+    'DROP LOGFILE GROUP': ['drop-logfile-group'],
+    'DROP PROCEDURE': ['drop-procedure'],
+    'DROP SERVER': ['drop-server'],
+    'DROP TABLE': ['drop-table'],
+    'DROP TABLESPACE': ['drop-tablespace'],
+    'DROP TRIGGER': ['drop-trigger'],
+    'DROP VIEW': ['drop-view'],
+    'RENAME TABLE': ['rename-table'],
+    'TRUNCATE TABLE': ['truncate-table'],
+
+    /* Statements */
+    'SELECT': ['select'],
+    'SET': ['set'],
+    'EXPLAIN': ['explain'],
+    'DESCRIBE': ['describe'],
+    'DELETE': ['delete'],
+    'SHOW': ['show'],
+    'UPDATE': ['update'],
+    'INSERT': ['insert'],
+    'REPLACE': ['replace'],
+    'CALL': ['call'],
+    'DO': ['do'],
+    'HANDLER': ['handler'],
+    'COLLATE': ['charset-collations'],
+
+    /* Functions */
+    'ABS': ['mathematical-functions', 'function_abs'],
+    'ACOS': ['mathematical-functions', 'function_acos'],
+    'ADDDATE': ['date-and-time-functions', 'function_adddate'],
+    'ADDTIME': ['date-and-time-functions', 'function_addtime'],
+    'AES_DECRYPT': ['encryption-functions', 'function_aes_decrypt'],
+    'AES_ENCRYPT': ['encryption-functions', 'function_aes_encrypt'],
+    'AND': ['logical-operators', 'operator_and'],
+    'ASCII': ['string-functions', 'function_ascii'],
+    'ASIN': ['mathematical-functions', 'function_asin'],
+    'ATAN2': ['mathematical-functions', 'function_atan2'],
+    'ATAN': ['mathematical-functions', 'function_atan'],
+    'AVG': ['group-by-functions', 'function_avg'],
+    'BENCHMARK': ['information-functions', 'function_benchmark'],
+    'BIN': ['string-functions', 'function_bin'],
+    'BINARY': ['cast-functions', 'operator_binary'],
+    'BIT_AND': ['group-by-functions', 'function_bit_and'],
+    'BIT_COUNT': ['bit-functions', 'function_bit_count'],
+    'BIT_LENGTH': ['string-functions', 'function_bit_length'],
+    'BIT_OR': ['group-by-functions', 'function_bit_or'],
+    'BIT_XOR': ['group-by-functions', 'function_bit_xor'],
+    'CASE': ['control-flow-functions', 'operator_case'],
+    'CAST': ['cast-functions', 'function_cast'],
+    'CEIL': ['mathematical-functions', 'function_ceil'],
+    'CEILING': ['mathematical-functions', 'function_ceiling'],
+    'CHAR_LENGTH': ['string-functions', 'function_char_length'],
+    'CHAR': ['string-functions', 'function_char'],
+    'CHARACTER_LENGTH': ['string-functions', 'function_character_length'],
+    'CHARSET': ['information-functions', 'function_charset'],
+    'COALESCE': ['comparison-operators', 'function_coalesce'],
+    'COERCIBILITY': ['information-functions', 'function_coercibility'],
+    'COLLATION': ['information-functions', 'function_collation'],
+    'COMPRESS': ['encryption-functions', 'function_compress'],
+    'CONCAT_WS': ['string-functions', 'function_concat_ws'],
+    'CONCAT': ['string-functions', 'function_concat'],
+    'CONNECTION_ID': ['information-functions', 'function_connection_id'],
+    'CONV': ['mathematical-functions', 'function_conv'],
+    'CONVERT_TZ': ['date-and-time-functions', 'function_convert_tz'],
+    'Convert': ['cast-functions', 'function_convert'],
+    'COS': ['mathematical-functions', 'function_cos'],
+    'COT': ['mathematical-functions', 'function_cot'],
+    'COUNT': ['group-by-functions', 'function_count'],
+    'CRC32': ['mathematical-functions', 'function_crc32'],
+    'CURDATE': ['date-and-time-functions', 'function_curdate'],
+    'CURRENT_DATE': ['date-and-time-functions', 'function_current_date'],
+    'CURRENT_TIME': ['date-and-time-functions', 'function_current_time'],
+    'CURRENT_TIMESTAMP': ['date-and-time-functions', 'function_current_timestamp'],
+    'CURRENT_USER': ['information-functions', 'function_current_user'],
+    'CURTIME': ['date-and-time-functions', 'function_curtime'],
+    'DATABASE': ['information-functions', 'function_database'],
+    'DATE_ADD': ['date-and-time-functions', 'function_date_add'],
+    'DATE_FORMAT': ['date-and-time-functions', 'function_date_format'],
+    'DATE_SUB': ['date-and-time-functions', 'function_date_sub'],
+    'DATE': ['date-and-time-functions', 'function_date'],
+    'DATEDIFF': ['date-and-time-functions', 'function_datediff'],
+    'DAY': ['date-and-time-functions', 'function_day'],
+    'DAYNAME': ['date-and-time-functions', 'function_dayname'],
+    'DAYOFMONTH': ['date-and-time-functions', 'function_dayofmonth'],
+    'DAYOFWEEK': ['date-and-time-functions', 'function_dayofweek'],
+    'DAYOFYEAR': ['date-and-time-functions', 'function_dayofyear'],
+    'DECLARE': ['declare', 'declare'],
+    'DECODE': ['encryption-functions', 'function_decode'],
+    'DEFAULT': ['miscellaneous-functions', 'function_default'],
+    'DEGREES': ['mathematical-functions', 'function_degrees'],
+    'DES_DECRYPT': ['encryption-functions', 'function_des_decrypt'],
+    'DES_ENCRYPT': ['encryption-functions', 'function_des_encrypt'],
+    'DIV': ['arithmetic-functions', 'operator_div'],
+    'ELT': ['string-functions', 'function_elt'],
+    'ENCODE': ['encryption-functions', 'function_encode'],
+    'ENCRYPT': ['encryption-functions', 'function_encrypt'],
+    'EXP': ['mathematical-functions', 'function_exp'],
+    'EXPORT_SET': ['string-functions', 'function_export_set'],
+    'EXTRACT': ['date-and-time-functions', 'function_extract'],
+    'ExtractValue': ['xml-functions', 'function_extractvalue'],
+    'FIELD': ['string-functions', 'function_field'],
+    'FIND_IN_SET': ['string-functions', 'function_find_in_set'],
+    'FLOOR': ['mathematical-functions', 'function_floor'],
+    'FORMAT': ['string-functions', 'function_format'],
+    'FOUND_ROWS': ['information-functions', 'function_found_rows'],
+    'FROM_DAYS': ['date-and-time-functions', 'function_from_days'],
+    'FROM_UNIXTIME': ['date-and-time-functions', 'function_from_unixtime'],
+    'GET_FORMAT': ['date-and-time-functions', 'function_get_format'],
+    'GET_LOCK': ['miscellaneous-functions', 'function_get_lock'],
+    'GREATEST': ['comparison-operators', 'function_greatest'],
+    'GROUP_CONCAT': ['group-by-functions', 'function_group_concat'],
+    'HEX': ['string-functions', 'function_hex'],
+    'HOUR': ['date-and-time-functions', 'function_hour'],
+    'IF': ['control-flow-functions', 'function_if'],
+    'IFNULL': ['control-flow-functions', 'function_ifnull'],
+    'IN': ['comparison-operators', 'function_in'],
+    'INET_ATON': ['miscellaneous-functions', 'function_inet_aton'],
+    'INET_NTOA': ['miscellaneous-functions', 'function_inet_ntoa'],
+    'INSTR': ['string-functions', 'function_instr'],
+    'INTERVAL': ['comparison-operators', 'function_interval'],
+    'IS_FREE_LOCK': ['miscellaneous-functions', 'function_is_free_lock'],
+    'IS_USED_LOCK': ['miscellaneous-functions', 'function_is_used_lock'],
+    'IS': ['comparison-operators', 'operator_is'],
+    'ISNULL': ['comparison-operators', 'function_isnull'],
+    'LAST_DAY': ['date-and-time-functions', 'function_last_day'],
+    'LAST_INSERT_ID': ['information-functions', 'function_last_insert_id'],
+    'LCASE': ['string-functions', 'function_lcase'],
+    'LEAST': ['comparison-operators', 'function_least'],
+    'LEFT': ['string-functions', 'function_left'],
+    'LENGTH': ['string-functions', 'function_length'],
+    'LIKE': ['string-comparison-functions', 'operator_like'],
+    'LN': ['mathematical-functions', 'function_ln'],
+    'LOAD_FILE': ['string-functions', 'function_load_file'],
+    'LOCALTIME': ['date-and-time-functions', 'function_localtime'],
+    'LOCALTIMESTAMP': ['date-and-time-functions', 'function_localtimestamp'],
+    'LOCATE': ['string-functions', 'function_locate'],
+    'LOG10': ['mathematical-functions', 'function_log10'],
+    'LOG2': ['mathematical-functions', 'function_log2'],
+    'LOG': ['mathematical-functions', 'function_log'],
+    'LOWER': ['string-functions', 'function_lower'],
+    'LPAD': ['string-functions', 'function_lpad'],
+    'LTRIM': ['string-functions', 'function_ltrim'],
+    'MAKE_SET': ['string-functions', 'function_make_set'],
+    'MAKEDATE': ['date-and-time-functions', 'function_makedate'],
+    'MAKETIME': ['date-and-time-functions', 'function_maketime'],
+    'MASTER_POS_WAIT': ['miscellaneous-functions', 'function_master_pos_wait'],
+    'MATCH': ['fulltext-search', 'function_match'],
+    'MAX': ['group-by-functions', 'function_max'],
+    'MD5': ['encryption-functions', 'function_md5'],
+    'MICROSECOND': ['date-and-time-functions', 'function_microsecond'],
+    'MID': ['string-functions', 'function_mid'],
+    'MIN': ['group-by-functions', 'function_min'],
+    'MINUTE': ['date-and-time-functions', 'function_minute'],
+    'MOD': ['mathematical-functions', 'function_mod'],
+    'MONTH': ['date-and-time-functions', 'function_month'],
+    'MONTHNAME': ['date-and-time-functions', 'function_monthname'],
+    'NAME_CONST': ['miscellaneous-functions', 'function_name_const'],
+    'NOT': ['logical-operators', 'operator_not'],
+    'NOW': ['date-and-time-functions', 'function_now'],
+    'NULLIF': ['control-flow-functions', 'function_nullif'],
+    'OCT': ['mathematical-functions', 'function_oct'],
+    'OCTET_LENGTH': ['string-functions', 'function_octet_length'],
+    'OLD_PASSWORD': ['encryption-functions', 'function_old_password'],
+    'OR': ['logical-operators', 'operator_or'],
+    'ORD': ['string-functions', 'function_ord'],
+    'PASSWORD': ['encryption-functions', 'function_password'],
+    'PERIOD_ADD': ['date-and-time-functions', 'function_period_add'],
+    'PERIOD_DIFF': ['date-and-time-functions', 'function_period_diff'],
+    'PI': ['mathematical-functions', 'function_pi'],
+    'POSITION': ['string-functions', 'function_position'],
+    'POW': ['mathematical-functions', 'function_pow'],
+    'POWER': ['mathematical-functions', 'function_power'],
+    'QUARTER': ['date-and-time-functions', 'function_quarter'],
+    'QUOTE': ['string-functions', 'function_quote'],
+    'RADIANS': ['mathematical-functions', 'function_radians'],
+    'RAND': ['mathematical-functions', 'function_rand'],
+    'REGEXP': ['regexp', 'operator_regexp'],
+    'RELEASE_LOCK': ['miscellaneous-functions', 'function_release_lock'],
+    'REPEAT': ['string-functions', 'function_repeat'],
+    'REVERSE': ['string-functions', 'function_reverse'],
+    'RIGHT': ['string-functions', 'function_right'],
+    'RLIKE': ['regexp', 'operator_rlike'],
+    'ROUND': ['mathematical-functions', 'function_round'],
+    'ROW_COUNT': ['information-functions', 'function_row_count'],
+    'RPAD': ['string-functions', 'function_rpad'],
+    'RTRIM': ['string-functions', 'function_rtrim'],
+    'SCHEMA': ['information-functions', 'function_schema'],
+    'SEC_TO_TIME': ['date-and-time-functions', 'function_sec_to_time'],
+    'SECOND': ['date-and-time-functions', 'function_second'],
+    'SESSION_USER': ['information-functions', 'function_session_user'],
+    'SHA': ['encryption-functions', 'function_sha1'],
+    'SHA1': ['encryption-functions', 'function_sha1'],
+    'SIGN': ['mathematical-functions', 'function_sign'],
+    'SIN': ['mathematical-functions', 'function_sin'],
+    'SLEEP': ['miscellaneous-functions', 'function_sleep'],
+    'SOUNDEX': ['string-functions', 'function_soundex'],
+    'SPACE': ['string-functions', 'function_space'],
+    'SQRT': ['mathematical-functions', 'function_sqrt'],
+    'STD': ['group-by-functions', 'function_std'],
+    'STDDEV_POP': ['group-by-functions', 'function_stddev_pop'],
+    'STDDEV_SAMP': ['group-by-functions', 'function_stddev_samp'],
+    'STDDEV': ['group-by-functions', 'function_stddev'],
+    'STR_TO_DATE': ['date-and-time-functions', 'function_str_to_date'],
+    'STRCMP': ['string-comparison-functions', 'function_strcmp'],
+    'SUBDATE': ['date-and-time-functions', 'function_subdate'],
+    'SUBSTR': ['string-functions', 'function_substr'],
+    'SUBSTRING_INDEX': ['string-functions', 'function_substring_index'],
+    'SUBSTRING': ['string-functions', 'function_substring'],
+    'SUBTIME': ['date-and-time-functions', 'function_subtime'],
+    'SUM': ['group-by-functions', 'function_sum'],
+    'SYSDATE': ['date-and-time-functions', 'function_sysdate'],
+    'SYSTEM_USER': ['information-functions', 'function_system_user'],
+    'TAN': ['mathematical-functions', 'function_tan'],
+    'TIME_FORMAT': ['date-and-time-functions', 'function_time_format'],
+    'TIME_TO_SEC': ['date-and-time-functions', 'function_time_to_sec'],
+    'TIME': ['date-and-time-functions', 'function_time'],
+    'TIMEDIFF': ['date-and-time-functions', 'function_timediff'],
+    'TIMESTAMP': ['date-and-time-functions', 'function_timestamp'],
+    'TIMESTAMPADD': ['date-and-time-functions', 'function_timestampadd'],
+    'TIMESTAMPDIFF': ['date-and-time-functions', 'function_timestampdiff'],
+    'TO_DAYS': ['date-and-time-functions', 'function_to_days'],
+    'TRIM': ['string-functions', 'function_trim'],
+    'TRUNCATE': ['mathematical-functions', 'function_truncate'],
+    'UCASE': ['string-functions', 'function_ucase'],
+    'UNCOMPRESS': ['encryption-functions', 'function_uncompress'],
+    'UNCOMPRESSED_LENGTH': ['encryption-functions', 'function_uncompressed_length'],
+    'UNHEX': ['string-functions', 'function_unhex'],
+    'UNIX_TIMESTAMP': ['date-and-time-functions', 'function_unix_timestamp'],
+    'UpdateXML': ['xml-functions', 'function_updatexml'],
+    'UPPER': ['string-functions', 'function_upper'],
+    'USER': ['information-functions', 'function_user'],
+    'UTC_DATE': ['date-and-time-functions', 'function_utc_date'],
+    'UTC_TIME': ['date-and-time-functions', 'function_utc_time'],
+    'UTC_TIMESTAMP': ['date-and-time-functions', 'function_utc_timestamp'],
+    'UUID_SHORT': ['miscellaneous-functions', 'function_uuid_short'],
+    'UUID': ['miscellaneous-functions', 'function_uuid'],
+    'VALUES': ['miscellaneous-functions', 'function_values'],
+    'VAR_POP': ['group-by-functions', 'function_var_pop'],
+    'VAR_SAMP': ['group-by-functions', 'function_var_samp'],
+    'VARIANCE': ['group-by-functions', 'function_variance'],
+    'VERSION': ['information-functions', 'function_version'],
+    'WEEK': ['date-and-time-functions', 'function_week'],
+    'WEEKDAY': ['date-and-time-functions', 'function_weekday'],
+    'WEEKOFYEAR': ['date-and-time-functions', 'function_weekofyear'],
+    'XOR': ['logical-operators', 'operator_xor'],
+    'YEAR': ['date-and-time-functions', 'function_year'],
+    'YEARWEEK': ['date-and-time-functions', 'function_yearweek'],
+    'SOUNDS_LIKE': ['string-functions', 'operator_sounds-like'],
+    'IS_NOT_NULL': ['comparison-operators', 'operator_is-not-null'],
+    'IS_NOT': ['comparison-operators', 'operator_is-not'],
+    'IS_NULL': ['comparison-operators', 'operator_is-null'],
+    'NOT_LIKE': ['string-comparison-functions', 'operator_not-like'],
+    'NOT_REGEXP': ['regexp', 'operator_not-regexp'],
+    'COUNT_DISTINCT': ['group-by-functions', 'function_count-distinct'],
+    'NOT_IN': ['comparison-operators', 'function_not-in']
+};
+
+// eslint-disable-next-line no-unused-vars
+var mysqlDocBuiltin = {
+    'TINYINT': ['numeric-types'],
+    'SMALLINT': ['numeric-types'],
+    'MEDIUMINT': ['numeric-types'],
+    'INT': ['numeric-types'],
+    'BIGINT': ['numeric-types'],
+    'DECIMAL': ['numeric-types'],
+    'FLOAT': ['numeric-types'],
+    'DOUBLE': ['numeric-types'],
+    'REAL': ['numeric-types'],
+    'BIT': ['numeric-types'],
+    'BOOLEAN': ['numeric-types'],
+    'SERIAL': ['numeric-types'],
+    'DATE': ['date-and-time-types'],
+    'DATETIME': ['date-and-time-types'],
+    'TIMESTAMP': ['date-and-time-types'],
+    'TIME': ['date-and-time-types'],
+    'YEAR': ['date-and-time-types'],
+    'CHAR': ['string-types'],
+    'VARCHAR': ['string-types'],
+    'TINYTEXT': ['string-types'],
+    'TEXT': ['string-types'],
+    'MEDIUMTEXT': ['string-types'],
+    'LONGTEXT': ['string-types'],
+    'BINARY': ['string-types'],
+    'VARBINARY': ['string-types'],
+    'TINYBLOB': ['string-types'],
+    'MEDIUMBLOB': ['string-types'],
+    'BLOB': ['string-types'],
+    'LONGBLOB': ['string-types'],
+    'ENUM': ['string-types'],
+    'SET': ['string-types']
+};