diff --git a/htdocs/sql/libraries/sqlparser.data.php b/htdocs/sql/libraries/sqlparser.data.php deleted file mode 100755 --- a/htdocs/sql/libraries/sqlparser.data.php +++ /dev/null @@ -1,1283 +0,0 @@ - - * http://www.orbis-terrarum.net/?l=people.robbat2 - * - * This data is used by the SQL Parser to recognize keywords - * - * It has been extracted from the lex.h file in the MySQL BK tree - * (around 4.0.2) as well as the MySQL documentation. - * - * Note: before adding a value in the arrays, ensure that you respect - * proper sorting, especially with underscores. And don't forget to - * update the _cnt variable at the end of each array. - * (It's slower to have PHP do the count). - * - * It's easier to use only uppercase for proper sorting. In case of - * doubt, use the DEBUG code after this function's definition. - * - * @version$Id: sqlparser.data.php 11345 2008-06-24 17:51:49Z lem9 $ - */ -if (! defined('PHPMYADMIN')) { - exit; -} - -/** - * @global array MySQL function names - */ -$PMA_SQPdata_function_name = array ( - 'ABS', - 'ACOS', - 'ADDDATE', - 'ADDTIME', - 'AES_DECRYPT', - 'AES_ENCRYPT', - 'AREA', // Area() polygon-property-functions.html - 'ASBINARY', // AsBinary() - 'ASCII', - 'ASIN', - 'ASTEXT', // AsText() - 'ATAN', - 'ATAN2', - 'AVG', - 'BDMPOLYFROMTEXT', // BdMPolyFromText() - 'BDMPOLYFROMWKB', // BdMPolyFromWKB() - 'BDPOLYFROMTEXT', // BdPolyFromText() - 'BDPOLYFROMWKB', // BdPolyFromWKB() - 'BENCHMARK', - 'BIN', - 'BIT_AND', - 'BIT_COUNT', - 'BIT_LENGTH', - 'BIT_OR', - 'BIT_XOR', // group-by-functions.html - 'BOUNDARY', // Boundary() general-geometry-property-functions.html - 'BUFFER', // Buffer() - 'CAST', - 'CEIL', - 'CEILING', - 'CENTROID', // Centroid() multipolygon-property-functions.html - 'CHAR', // string-functions.html - 'CHARACTER_LENGTH', - 'CHARSET', // information-functions.html - 'CHAR_LENGTH', - 'COALESCE', - 'COERCIBILITY', // information-functions.html - 'COLLATION', // information-functions.html - 'COMPRESS', // string-functions.html - 'CONCAT', - 'CONCAT_WS', - 'CONNECTION_ID', - 'CONTAINS', // Contains() - 'CONV', - 'CONVERT', - 'CONVERT_TZ', - 'CONVEXHULL', // ConvexHull() - 'COS', - 'COT', - 'COUNT', - 'CRC32', // mathematical-functions.html - 'CROSSES', // Crosses() - 'CURDATE', - 'CURRENT_DATE', - 'CURRENT_TIME', - 'CURRENT_TIMESTAMP', - 'CURRENT_USER', - 'CURTIME', - 'DATABASE', - 'DATE', // date-and-time-functions.html - 'DATEDIFF', // date-and-time-functions.html - 'DATE_ADD', - 'DATE_DIFF', - 'DATE_FORMAT', - 'DATE_SUB', - 'DAY', - 'DAYNAME', - 'DAYOFMONTH', - 'DAYOFWEEK', - 'DAYOFYEAR', - 'DECODE', - 'DEFAULT', // miscellaneous-functions.html - 'DEGREES', - 'DES_DECRYPT', - 'DES_ENCRYPT', - 'DIFFERENCE', // Difference() - 'DIMENSION', // Dimension() general-geometry-property-functions.html - 'DISJOINT', // Disjoint() - 'DISTANCE', // Distance() - 'ELT', - 'ENCODE', - 'ENCRYPT', - 'ENDPOINT', // EndPoint() linestring-property-functions.html - 'ENVELOPE', // Envelope() general-geometry-property-functions.html - 'EQUALS', // Equals() - 'EXP', - 'EXPORT_SET', - 'EXTERIORRING', // ExteriorRing() polygon-property-functions.html - 'EXTRACT', - 'EXTRACTVALUE', // ExtractValue() xml-functions.html - 'FIELD', - 'FIND_IN_SET', - 'FLOOR', - 'FORMAT', - 'FOUND_ROWS', - 'FROM_DAYS', - 'FROM_UNIXTIME', - 'GEOMCOLLFROMTEXT', // GeomCollFromText() - 'GEOMCOLLFROMWKB', // GeomCollFromWKB() - 'GEOMETRYCOLLECTION', // GeometryCollection() - 'GEOMETRYCOLLECTIONFROMTEXT', // GeometryCollectionFromText() - 'GEOMETRYCOLLECTIONFROMWKB', // GeometryCollectionFromWKB() - 'GEOMETRYFROMTEXT', // GeometryFromText() - 'GEOMETRYFROMWKB', // GeometryFromWKB() - 'GEOMETRYN', // GeometryN() geometrycollection-property-functions.html - 'GEOMETRYTYPE', // GeometryType() general-geometry-property-functions.html - 'GEOMFROMTEXT', // GeomFromText() - 'GEOMFROMWKB', // GeomFromWKB() - 'GET_FORMAT', - 'GET_LOCK', - 'GLENGTH', // GLength() linestring-property-functions.html - 'GREATEST', - 'GROUP_CONCAT', - 'GROUP_UNIQUE_USERS', - 'HEX', - 'HOUR', - 'IF', //control-flow-functions.html - 'IFNULL', - 'INET_ATON', - 'INET_NTOA', - 'INSERT', // string-functions.html - 'INSTR', - 'INTERIORRINGN', // InteriorRingN() polygon-property-functions.html - 'INTERSECTION', // Intersection() - 'INTERSECTS', // Intersects() - 'INTERVAL', - 'ISCLOSED', // IsClosed() multilinestring-property-functions.html - 'ISEMPTY', // IsEmpty() general-geometry-property-functions.html - 'ISNULL', - 'ISRING', // IsRing() linestring-property-functions.html - 'ISSIMPLE', // IsSimple() general-geometry-property-functions.html - 'IS_FREE_LOCK', - 'IS_USED_LOCK', // miscellaneous-functions.html - 'LAST_DAY', - 'LAST_INSERT_ID', - 'LCASE', - 'LEAST', - 'LEFT', - 'LENGTH', - 'LINEFROMTEXT', // LineFromText() - 'LINEFROMWKB', // LineFromWKB() - 'LINESTRING', // LineString() - 'LINESTRINGFROMTEXT', // LineStringFromText() - 'LINESTRINGFROMWKB', // LineStringFromWKB() - 'LN', - 'LOAD_FILE', - 'LOCALTIME', - 'LOCALTIMESTAMP', - 'LOCATE', - 'LOG', - 'LOG10', - 'LOG2', - 'LOWER', - 'LPAD', - 'LTRIM', - 'MAKEDATE', - 'MAKETIME', - 'MAKE_SET', - 'MASTER_POS_WAIT', - 'MAX', - 'MBRCONTAINS', // MBRContains() - 'MBRDISJOINT', // MBRDisjoint() - 'MBREQUAL', // MBREqual() - 'MBRINTERSECTS', // MBRIntersects() - 'MBROVERLAPS', // MBROverlaps() - 'MBRTOUCHES', // MBRTouches() - 'MBRWITHIN', // MBRWithin() - 'MD5', - 'MICROSECOND', - 'MID', - 'MIN', - 'MINUTE', - 'MLINEFROMTEXT', // MLineFromText() - 'MLINEFROMWKB', // MLineFromWKB() - 'MOD', - 'MONTH', - 'MONTHNAME', - 'NOW', - 'MPOINTFROMTEXT', // MPointFromText() - 'MPOINTFROMWKB', // MPointFromWKB() - 'MPOLYFROMTEXT', // MPolyFromText() - 'MPOLYFROMWKB', // MPolyFromWKB() - 'MULTILINESTRING', // MultiLineString() - 'MULTILINESTRINGFROMTEXT', // MultiLineStringFromText() - 'MULTILINESTRINGFROMWKB', // MultiLineStringFromWKB() - 'MULTIPOINT', // MultiPoint() - 'MULTIPOINTFROMTEXT', // MultiPointFromText() - 'MULTIPOINTFROMWKB', // MultiPointFromWKB() - 'MULTIPOLYGON', // MultiPolygon() - 'MULTIPOLYGONFROMTEXT', // MultiPolygonFromText() - 'MULTIPOLYGONFROMWKB', // MultiPolygonFromWKB() - 'NAME_CONST', // NAME_CONST() - 'NOW', // NOW() - 'NULLIF', - 'NUMGEOMETRIES', // NumGeometries() geometrycollection-property-functions.html - 'NUMINTERIORRINGS', // NumInteriorRings() polygon-property-functions.html - 'NUMPOINTS', // NumPoints() linestring-property-functions.html - 'OCT', - 'OCTET_LENGTH', - 'OLD_PASSWORD', - 'ORD', - 'OVERLAPS', // Overlaps() - 'PASSWORD', - 'PERIOD_ADD', - 'PERIOD_DIFF', - 'PI', - 'POINT', // Point() - 'POINTFROMTEXT', // PointFromText() - 'POINTFROMWKB', // PointFromWKB() - 'POINTN', // PointN() inestring-property-functions.html - 'POINTONSURFACE', // PointOnSurface() multipolygon-property-functions.html - 'POLYFROMTEXT', // PolyFromText() - 'POLYFROMWKB', // PolyFromWKB() - 'POLYGON', // Polygon() - 'POLYGONFROMTEXT', // PolygonFromText() - 'POLYGONFROMWKB', // PolygonFromWKB() - 'POSITION', - 'POW', - 'POWER', - 'QUARTER', - 'QUOTE', - 'RADIANS', - 'RAND', - 'RELATED', // Related() - 'RELEASE_LOCK', - 'REPEAT', - 'REPLACE', // string-functions.html - 'REVERSE', - 'RIGHT', - 'ROUND', - 'ROW_COUNT', // information-functions.html - 'RPAD', - 'RTRIM', - 'SCHEMA', // information-functions.html - 'SECOND', - 'SEC_TO_TIME', - 'SESSION_USER', - 'SHA', - 'SHA1', - 'SIGN', - 'SIN', - 'SLEEP', // miscellaneous-functions.html - 'SOUNDEX', - 'SPACE', - 'SQRT', - 'SRID', // general-geometry-property-functions.html - 'STARTPOINT', // StartPoint() linestring-property-functions.html - 'STD', - 'STDDEV', - 'STDDEV_POP', // group-by-functions.html - 'STDDEV_SAMP', // group-by-functions.html - 'STRCMP', - 'STR_TO_DATE', - 'SUBDATE', - 'SUBSTR', - 'SUBSTRING', - 'SUBSTRING_INDEX', - 'SUBTIME', - 'SUM', - 'SYMDIFFERENCE', // SymDifference() - 'SYSDATE', - 'SYSTEM_USER', - 'TAN', - 'TIME', - 'TIMEDIFF', - 'TIMESTAMP', - 'TIMESTAMPADD', - 'TIMESTAMPDIFF', - 'TIME_FORMAT', - 'TIME_TO_SEC', - 'TOUCHES', // Touches() - 'TO_DAYS', - 'TRIM', - 'TRUNCATE', // mathematical-functions.html - 'UCASE', - 'UNCOMPRESS', // string-functions.html - 'UNCOMPRESSED_LENGTH', // string-functions.html - 'UNHEX', // string-functions.html - 'UNIQUE_USERS', - 'UNIX_TIMESTAMP', - 'UPDATEXML', // UpdateXML() xml-functions.html - 'UPPER', - 'USER', - 'UTC_DATE', - 'UTC_TIME', - 'UTC_TIMESTAMP', - 'UUID', // miscellaneous-functions.html - 'VARIANCE', // group-by-functions.html - 'VAR_POP', // group-by-functions.html - 'VAR_SAMP', // group-by-functions.html - 'VERSION', - 'WEEK', - 'WEEKDAY', - 'WEEKOFYEAR', - 'WITHIN', // Within() - 'X', // point-property-functions.html - 'Y', // point-property-functions.html - 'YEAR', - 'YEARWEEK' -); -/** - * $PMA_SQPdata_function_name_cnt = count($PMA_SQPdata_function_name); - * - * @global integer MySQL attributes count - */ -$PMA_SQPdata_function_name_cnt = 299; - -/* - * DEBUG -$test_PMA_SQPdata_function_name = $PMA_SQPdata_function_name; -sort($PMA_SQPdata_function_name); -if ($PMA_SQPdata_function_name != $test_PMA_SQPdata_function_name) { - echo 'sort properly like this
'; - print_r($PMA_SQPdata_function_name); - echo ''; -} - */ - -/** - * @global array MySQL attributes - */ -$PMA_SQPdata_column_attrib = array ( - 'ARCHIVE', // Engine - 'ASCII', - 'AUTO_INCREMENT', - 'BDB', // Engine - 'BERKELEYDB', // Engine alias BDB - 'BINARY', - 'BLACKHOLE', // Engine - 'CSV', // Engine - 'DEFAULT', - 'EXAMPLE', // Engine - 'FEDERATED', // Engine - 'HEAP', // Engine - 'INNOBASE', // Engine alias InnoDB - 'INNODB', // Engine InnoDB - 'ISAM', // Engine - 'MEMORY', // Engine alias HEAP, but preferred - 'MERGE', // Engine - 'MRG_ISAM', // Engine - 'MRG_MYISAM', // Engine alias MERGE - 'MYISAM', // Engine MyISAM - 'NATIONAL', - 'NDB', // Engine alias NDBCLUSTER - 'NDBCLUSTER', // Engine - 'PRECISION', - 'UNDEFINED', - 'UNICODE', - 'UNSIGNED', - 'VARYING', - 'ZEROFILL' -); -/** - * $PMA_SQPdata_column_attrib_cnt = count($PMA_SQPdata_column_attrib); - * - * @global integer MySQL attributes count - */ -$PMA_SQPdata_column_attrib_cnt = 29; - -/** - * words that are reserved by MySQL and may not be used as identifiers without quotes - * - * @see http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html - * - * @global array MySQL reserved words - */ -$PMA_SQPdata_reserved_word = array ( - 'ACCESSIBLE', // 5.1 - 'ACTION', - 'ADD', - 'AFTER', - 'AGAINST', - 'AGGREGATE', - 'ALGORITHM', - 'ALL', - 'ALTER', - 'ANALYSE', - 'ANALYZE', - 'AND', - 'AS', - 'ASC', - 'AUTOCOMMIT', - 'AUTO_INCREMENT', - 'AVG_ROW_LENGTH', - 'BACKUP', - 'BEGIN', - 'BETWEEN', - 'BINLOG', - 'BOTH', - 'BY', - 'CASCADE', - 'CASE', - 'CHANGE', - 'CHANGED', - 'CHARSET', - 'CHECK', - 'CHECKSUM', - 'COLLATE', - 'COLLATION', - 'COLUMN', - 'COLUMNS', - 'COMMENT', - 'COMMIT', - 'COMMITTED', - 'COMPRESSED', - 'CONCURRENT', - 'CONSTRAINT', - 'CONTAINS', - 'CONVERT', - 'CREATE', - 'CROSS', - 'CURRENT_TIMESTAMP', - 'DATA', - 'DATABASE', - 'DATABASES', - 'DAY', - 'DAY_HOUR', - 'DAY_MINUTE', - 'DAY_SECOND', - 'DEFINER', - 'DELAYED', - 'DELAY_KEY_WRITE', - 'DELETE', - 'DESC', - 'DESCRIBE', - 'DETERMINISTIC', - 'DISTINCT', - 'DISTINCTROW', - 'DIV', - 'DO', - 'DROP', - 'DUMPFILE', - 'DUPLICATE', - 'DYNAMIC', - 'ELSE', - 'ENCLOSED', - 'END', - 'ENGINE', - 'ENGINES', - 'ESCAPE', - 'ESCAPED', - 'EVENTS', - 'EXECUTE', - 'EXISTS', - 'EXPLAIN', - 'EXTENDED', - 'FAST', - 'FIELDS', - 'FILE', - 'FIRST', - 'FIXED', - 'FLUSH', - 'FOR', - 'FORCE', - 'FOREIGN', - 'FROM', - 'FULL', - 'FULLTEXT', - 'FUNCTION', - 'GEMINI', - 'GEMINI_SPIN_RETRIES', - 'GLOBAL', - 'GRANT', - 'GRANTS', - 'GROUP', - 'HAVING', - 'HEAP', - 'HIGH_PRIORITY', - 'HOSTS', - 'HOUR', - 'HOUR_MINUTE', - 'HOUR_SECOND', - 'IDENTIFIED', - 'IF', - 'IGNORE', - 'IN', - 'INDEX', - 'INDEXES', - 'INFILE', - 'INNER', - 'INSERT', - 'INSERT_ID', - 'INSERT_METHOD', - 'INTERVAL', - 'INTO', - 'IS', - 'ISOLATION', - 'JOIN', - 'KEY', - 'KEYS', - 'KILL', - 'LAST_INSERT_ID', - 'LEADING', - 'LEFT', - 'LEVEL', - 'LIKE', - 'LIMIT', - 'LINEAR', // 5.1 - 'LINES', - 'LOAD', - 'LOCAL', - 'LOCK', - 'LOCKS', - 'LOGS', - 'LOW_PRIORITY', - 'MASTER', - 'MASTER_CONNECT_RETRY', - 'MASTER_HOST', - 'MASTER_LOG_FILE', - 'MASTER_LOG_POS', - 'MASTER_PASSWORD', - 'MASTER_PORT', - 'MASTER_USER', - 'MATCH', - 'MAX_CONNECTIONS_PER_HOUR', - 'MAX_QUERIES_PER_HOUR', - 'MAX_ROWS', - 'MAX_UPDATES_PER_HOUR', - 'MAX_USER_CONNECTIONS', - 'MEDIUM', - 'MERGE', - 'MINUTE', - 'MINUTE_SECOND', - 'MIN_ROWS', - 'MODE', - 'MODIFY', - 'MONTH', - 'MRG_MYISAM', - 'MYISAM', - 'NAMES', - 'NATURAL', - // 'NO' is not allowed in SQL-99 but is allowed in MySQL - //'NO', - 'NOT', - 'NULL', - 'OFFSET', - 'ON', - 'OPEN', - 'OPTIMIZE', - 'OPTION', - 'OPTIONALLY', - 'OR', - 'ORDER', - 'OUTER', - 'OUTFILE', - 'PACK_KEYS', - 'PARTIAL', - 'PASSWORD', - 'PRIMARY', - 'PRIVILEGES', - 'PROCEDURE', - 'PROCESS', - 'PROCESSLIST', - 'PURGE', - 'QUICK', - 'RAID0', - 'RAID_CHUNKS', - 'RAID_CHUNKSIZE', - 'RAID_TYPE', - 'RANGE', // 5.1 - 'READ', - 'READ_ONLY', // 5.1 - 'READ_WRITE', // 5.1 - 'REFERENCES', - 'REGEXP', - 'RELOAD', - 'RENAME', - 'REPAIR', - 'REPEATABLE', - 'REPLACE', - 'REPLICATION', - 'RESET', - 'RESTORE', - 'RESTRICT', - 'RETURN', - 'RETURNS', - 'REVOKE', - 'RIGHT', - 'RLIKE', - 'ROLLBACK', - 'ROW', - 'ROWS', - 'ROW_FORMAT', - 'SECOND', - 'SECURITY', - 'SELECT', - 'SEPARATOR', - 'SERIALIZABLE', - 'SESSION', - 'SHARE', - 'SHOW', - 'SHUTDOWN', - 'SLAVE', - 'SONAME', - 'SOUNDS', // string-functions.html - 'SQL', - 'SQL_AUTO_IS_NULL', - 'SQL_BIG_RESULT', - 'SQL_BIG_SELECTS', - 'SQL_BIG_TABLES', - 'SQL_BUFFER_RESULT', - 'SQL_CACHE', - 'SQL_CALC_FOUND_ROWS', - 'SQL_LOG_BIN', - 'SQL_LOG_OFF', - 'SQL_LOG_UPDATE', - 'SQL_LOW_PRIORITY_UPDATES', - 'SQL_MAX_JOIN_SIZE', - 'SQL_NO_CACHE', - 'SQL_QUOTE_SHOW_CREATE', - 'SQL_SAFE_UPDATES', - 'SQL_SELECT_LIMIT', - 'SQL_SLAVE_SKIP_COUNTER', - 'SQL_SMALL_RESULT', - 'SQL_WARNINGS', - 'START', - 'STARTING', - 'STATUS', - 'STOP', - 'STORAGE', - 'STRAIGHT_JOIN', - 'STRING', - 'STRIPED', - 'SUPER', - 'TABLE', - 'TABLES', - 'TEMPORARY', - 'TERMINATED', - 'THEN', - 'TO', - 'TRAILING', - 'TRUNCATE', - 'TYPE', - 'TYPES', - 'UNCOMMITTED', - 'UNION', - 'UNIQUE', - 'UNLOCK', - 'UPDATE', - 'USAGE', - 'USE', - 'USING', - 'VALUES', - 'VARIABLES', - 'VIEW', - 'WHEN', - 'WHERE', - 'WITH', - 'WORK', - 'WRITE', - 'XOR', - 'YEAR_MONTH' -); -/** - * $PMA_SQPdata_reserved_word_cnt = count($PMA_SQPdata_reserved_word); - * - * @global integer MySQL reserved words count - */ -$PMA_SQPdata_reserved_word_cnt = 283; -/** - * The previous array must be sorted so that the binary search work. - * Sometimes a word is not added in the correct order, so - * this debugging code shows the problem. The same should be - * done for all arrays. - */ -/* -$original = $PMA_SQPdata_reserved_word; -sort($PMA_SQPdata_reserved_word); -$difference = array_diff_assoc($original, $PMA_SQPdata_reserved_word); -echo '
'; -print_r($difference); -echo ''; -echo '
'; -print_r($PMA_SQPdata_reserved_word); -echo ''; -*/ -/** - * words forbidden to be used as column or table name wihtout quotes - * as seen in http://dev.mysql.com/doc/mysql/en/reserved-words.html - * - * @global array MySQL forbidden words - */ -$PMA_SQPdata_forbidden_word = array ( - 'ACCESSIBLE', // 5.1 - 'ACTION', - 'ADD', - 'AFTER', - 'AGAINST', - 'AGGREGATE', - 'ALGORITHM', - 'ALL', - 'ALTER', - 'ANALYZE', - 'AND', - 'ANY', - 'AS', - 'ASC', - 'ASCII', - 'ASENSITIVE', - 'AUTO_INCREMENT', - 'AVG', - 'AVG_ROW_LENGTH', - 'BACKUP', - 'BDB', - 'BEFORE', - 'BEGIN', - 'BERKELEYDB', - 'BETWEEN', - 'BIGINT', - 'BINARY', - 'BINLOG', - 'BIT', - 'BLOB', - 'BOOL', - 'BOOLEAN', - 'BOTH', - 'BTREE', - 'BY', - 'BYTE', - 'CACHE', - 'CALL', - 'CASCADE', - 'CASCADED', - 'CASE', - 'CHAIN', - 'CHANGE', - 'CHANGED', - 'CHAR', - 'CHARACTER', - 'CHARSET', - 'CHECK', - 'CHECKSUM', - 'CIPHER', - 'CLOSE', - 'COLLATE', - 'COLLATION', - 'COLUMN', - 'COLUMNS', - 'COMMENT', - 'COMMIT', - 'COMMITTED', - 'COMPACT', - 'COMPRESSED', - 'CONCURRENT', - 'CONDITION', - 'CONNECTION', - 'CONSISTENT', - 'CONSTRAINT', - 'CONTAINS', - 'CONTINUE', - 'CONVERT', - 'CREATE', - 'CROSS', - 'CUBE', - 'CURRENT_DATE', - 'CURRENT_TIME', - 'CURRENT_TIMESTAMP', - 'CURRENT_USER', - 'CURSOR', - 'DATA', - 'DATABASE', - 'DATABASES', - 'DATE', - 'DATETIME', - 'DAY', - 'DAY_HOUR', - 'DAY_MICROSECOND', - 'DAY_MINUTE', - 'DAY_SECOND', - 'DEALLOCATE', - 'DEC', - 'DECIMAL', - 'DECLARE', - 'DEFAULT', - 'DEFINER', - 'DELAYED', - 'DELAY_KEY_WRITE', - 'DELETE', - 'DESC', - 'DESCRIBE', - 'DES_KEY_FILE', - 'DETERMINISTIC', - 'DIRECTORY', - 'DISABLE', - 'DISCARD', - 'DISTINCT', - 'DISTINCTROW', - 'DIV', - 'DO', - 'DOUBLE', - 'DROP', - 'DUAL', - 'DUMPFILE', - 'DUPLICATE', - 'DYNAMIC', - 'EACH', - 'ELSE', - 'ELSEIF', - 'ENABLE', - 'ENCLOSED', - 'END', - 'ENGINE', - 'ENGINES', - 'ENUM', - 'ERRORS', - 'ESCAPE', - 'ESCAPED', - 'EVENTS', - 'EXECUTE', - 'EXISTS', - 'EXIT', - 'EXPANSION', - 'EXPLAIN', - 'EXTENDED', - 'FALSE', - 'FAST', - 'FETCH', - 'FIELDS', - 'FILE', - 'FIRST', - 'FIXED', - 'FLOAT', - 'FLOAT4', - 'FLOAT8', - 'FLUSH', - 'FOR', - 'FORCE', - 'FOREIGN', - 'FOUND', - 'FRAC_SECOND', - 'FROM', - 'FULL', - 'FULLTEXT', - 'FUNCTION', - 'GEOMETRY', - 'GEOMETRYCOLLECTION', - 'GET_FORMAT', - 'GLOBAL', - 'GOTO', - 'GRANT', - 'GRANTS', - 'GROUP', - 'HANDLER', - 'HASH', - 'HAVING', - 'HELP', - 'HIGH_PRIORITY', - 'HOSTS', - 'HOUR', - 'HOUR_MICROSECOND', - 'HOUR_MINUTE', - 'HOUR_SECOND', - 'IDENTIFIED', - 'IF', - 'IGNORE', - 'IMPORT', - 'IN', - 'INDEX', - 'INDEXES', - 'INFILE', - 'INNER', - 'INNOBASE', - 'INNODB', - 'INOUT', - 'INSENSITIVE', - 'INSERT', - 'INSERT_METHOD', - 'INT', - 'INT1', - 'INT2', - 'INT3', - 'INT4', - 'INT8', - 'INTEGER', - 'INTERVAL', - 'INTO', - 'INVOKER', - 'IO_THREAD', - 'IS', - 'ISOLATION', - 'ISSUER', - 'ITERATE', - 'JOIN', - 'KEY', - 'KEYS', - 'KILL', - 'LABEL', - 'LANGUAGE', - 'LAST', - 'LEADING', - 'LEAVE', - 'LEAVES', - 'LEFT', - 'LEVEL', - 'LIKE', - 'LIMIT', - 'LINEAR', // 5.1 - 'LINES', - 'LINESTRING', - 'LOAD', - 'LOCAL', - 'LOCALTIME', - 'LOCALTIMESTAMP', - 'LOCK', - 'LOCKS', - 'LOGS', - 'LONG', - 'LONGBLOB', - 'LONGTEXT', - 'LOOP', - 'LOW_PRIORITY', - 'MASTER', - 'MASTER_CONNECT_RETRY', - 'MASTER_HOST', - 'MASTER_LOG_FILE', - 'MASTER_LOG_POS', - 'MASTER_PASSWORD', - 'MASTER_PORT', - 'MASTER_SERVER_ID', - 'MASTER_SSL', - 'MASTER_SSL_CA', - 'MASTER_SSL_CAPATH', - 'MASTER_SSL_CERT', - 'MASTER_SSL_CIPHER', - 'MASTER_SSL_KEY', - 'MASTER_USER', - 'MATCH', - 'MAX_CONNECTIONS_PER_HOUR', - 'MAX_QUERIES_PER_HOUR', - 'MAX_ROWS', - 'MAX_UPDATES_PER_HOUR', - 'MAX_USER_CONNECTIONS', - 'MEDIUM', - 'MEDIUMBLOB', - 'MEDIUMINT', - 'MEDIUMTEXT', - 'MERGE', - 'MICROSECOND', - 'MIDDLEINT', - 'MIGRATE', - 'MINUTE', - 'MINUTE_MICROSECOND', - 'MINUTE_SECOND', - 'MIN_ROWS', - 'MOD', - 'MODE', - 'MODIFIES', - 'MODIFY', - 'MONTH', - 'MULTILINESTRING', - 'MULTIPOINT', - 'MULTIPOLYGON', - 'MUTEX', - 'NAME', - 'NAMES', - 'NATIONAL', - 'NATURAL', - 'NCHAR', - 'NDB', - 'NDBCLUSTER', - 'NEW', - 'NEXT', - 'NO', - 'NONE', - 'NOT', - 'NO_WRITE_TO_BINLOG', - 'NULL', - 'NUMERIC', - 'NVARCHAR', - 'OFFSET', - 'OLD_PASSWORD', - 'ON', - 'ONE', - 'ONE_SHOT', - 'OPEN', - 'OPTIMIZE', - 'OPTION', - 'OPTIONALLY', - 'OR', - 'ORDER', - 'OUT', - 'OUTER', - 'OUTFILE', - 'PACK_KEYS', - 'PARTIAL', - 'PASSWORD', - 'PHASE', - 'POINT', - 'POLYGON', - 'PRECISION', - 'PREPARE', - 'PREV', - 'PRIMARY', - 'PRIVILEGES', - 'PROCEDURE', - 'PROCESSLIST', - 'PURGE', - 'QUARTER', - 'QUERY', - 'QUICK', - 'RAID0', - 'RAID_CHUNKS', - 'RAID_CHUNKSIZE', - 'RAID_TYPE', - 'RANGE', // 5.1 - 'READ', - 'READ_ONLY', // 5.1 - 'READ_WRITE', // 5.1 - 'READS', - 'REAL', - 'RECOVER', - 'REDUNDANT', - 'REFERENCES', - 'REGEXP', - 'RELAY_LOG_FILE', - 'RELAY_LOG_POS', - 'RELAY_THREAD', - 'RELEASE', - 'RELOAD', - 'RENAME', - 'REPAIR', - 'REPEAT', - 'REPEATABLE', - 'REPLACE', - 'REPLICATION', - 'REQUIRE', - 'RESET', - 'RESTORE', - 'RESTRICT', - 'RESUME', - 'RETURN', - 'RETURNS', - 'REVOKE', - 'RIGHT', - 'RLIKE', - 'ROLLBACK', - 'ROLLUP', - 'ROUTINE', - 'ROW', - 'ROWS', - 'ROW_FORMAT', - 'RTREE', - 'SAVEPOINT', - 'SCHEMA', - 'SCHEMAS', - 'SECOND', - 'SECOND_MICROSECOND', - 'SECURITY', - 'SELECT', - 'SENSITIVE', - 'SEPARATOR', - 'SERIAL', - 'SERIALIZABLE', - 'SESSION', - 'SET', - 'SHARE', - 'SHOW', - 'SHUTDOWN', - 'SIGNED', - 'SIMPLE', - 'SLAVE', - 'SMALLINT', - 'SNAPSHOT', - 'SOME', - 'SONAME', - 'SOUNDS', - 'SPATIAL', - 'SPECIFIC', - 'SQL', - 'SQLEXCEPTION', - 'SQLSTATE', - 'SQLWARNING', - 'SQL_BIG_RESULT', - 'SQL_BUFFER_RESULT', - 'SQL_CACHE', - 'SQL_CALC_FOUND_ROWS', - 'SQL_NO_CACHE', - 'SQL_SMALL_RESULT', - 'SQL_THREAD', - 'SQL_TSI_DAY', - 'SQL_TSI_FRAC_SECOND', - 'SQL_TSI_HOUR', - 'SQL_TSI_MINUTE', - 'SQL_TSI_MONTH', - 'SQL_TSI_QUARTER', - 'SQL_TSI_SECOND', - 'SQL_TSI_WEEK', - 'SQL_TSI_YEAR', - 'SSL', - 'START', - 'STARTING', - 'STATUS', - 'STOP', - 'STORAGE', - 'STRAIGHT_JOIN', - 'STRING', - 'STRIPED', - 'SUBJECT', - 'SUPER', - 'SUSPEND', - 'TABLE', - 'TABLES', - 'TABLESPACE', - 'TEMPORARY', - 'TEMPTABLE', - 'TERMINATED', - 'TEXT', - 'THEN', - 'TIME', - 'TIMESTAMP', - 'TIMESTAMPADD', - 'TIMESTAMPDIFF', - 'TINYBLOB', - 'TINYINT', - 'TINYTEXT', - 'TO', - 'TRAILING', - 'TRANSACTION', - 'TRIGGER', - 'TRIGGERS', - 'TRUE', - 'TRUNCATE', - 'TYPE', - 'TYPES', - 'UNCOMMITTED', - 'UNDEFINED', - 'UNDO', - 'UNICODE', - 'UNION', - 'UNIQUE', - 'UNKNOWN', - 'UNLOCK', - 'UNSIGNED', - 'UNTIL', - 'UPDATE', - 'USAGE', - 'USE', - 'USER', - 'USER_RESOURCES', - 'USE_FRM', - 'USING', - 'UTC_DATE', - 'UTC_TIME', - 'UTC_TIMESTAMP', - 'VALUE', - 'VALUES', - 'VARBINARY', - 'VARCHAR', - 'VARCHARACTER', - 'VARIABLES', - 'VARYING', - 'VIEW', - 'WARNINGS', - 'WEEK', - 'WHEN', - 'WHERE', - 'WHILE', - 'WITH', - 'WORK', - 'WRITE', - 'X509', - 'XA', - 'XOR', - 'YEAR', - 'YEAR_MONTH', - 'ZEROFILL' -); -/** - * count($PMA_SQPdata_forbidden_word); - * - * @global integer MySQL forbidden words count - */ -$PMA_SQPdata_forbidden_word_cnt = 483; - -/** - * the MySQL column/data types - * - * @see http://dev.mysql.com/doc/refman/5.1/en/data-types.html - * @see http://dev.mysql.com/doc/refman/5.1/en/mysql-spatial-datatypes.html - * - * @global array MySQL column types - */ -$PMA_SQPdata_column_type = array ( - 'BIGINT', - 'BINARY', - 'BIT', - 'BLOB', - 'BOOL', - 'BOOLEAN', // numeric-type-overview.html - 'CHAR', - 'CHARACTER', - 'DATE', - 'DATETIME', - 'DEC', - 'DECIMAL', - 'DOUBLE', - 'ENUM', - 'FLOAT', - 'FLOAT4', - 'FLOAT8', - 'GEOMETRY', // spatial - 'GEOMETRYCOLLECTION', // spatial - 'INT', - 'INT1', - 'INT2', - 'INT3', - 'INT4', - 'INT8', - 'INTEGER', - 'LINESTRING', // spatial - 'LONG', - 'LONGBLOB', - 'LONGTEXT', - 'MEDIUMBLOB', - 'MEDIUMINT', - 'MEDIUMTEXT', - 'MIDDLEINT', - 'MULTILINESTRING', // spatial - 'MULTIPOINT', // spatial - 'MULTIPOLYGON', // spatial - 'NCHAR', - 'NUMERIC', - 'POINT', // spatial - 'POLYGON', // spatial - 'REAL', - 'SERIAL', // alsias for BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY - 'SET', - 'SMALLINT', - 'TEXT', - 'TIME', - 'TIMESTAMP', - 'TINYBLOB', - 'TINYINT', - 'TINYTEXT', - 'VARBINARY', - 'VARCHAR', - 'YEAR' -); -/** - * $PMA_SQPdata_column_type_cnt = count($PMA_SQPdata_column_type); - * - * @global integer MySQL column types count - */ -$PMA_SQPdata_column_type_cnt = 54; - -/* - * check counts -foreach ($GLOBALS as $n => $a) { - echo is_array($a) ? $n . ': ' . count($a) . '