3.3

1 files changed, 0 insertions, 1296 deletions

diff --git a/libraries/sqlparser.data.php b/libraries/sqlparser.data.php
deleted file mode 100644
index 7b29453d91..0000000000
--- a/libraries/sqlparser.data.php
+++ /dev/null
@@ -1,1296 +0,0 @@
-<?php
-/* vim: set expandtab sw=4 ts=4 sts=4: */
-/**
- * SQL Parser Matching Data
- *
- * Copyright 2002 Robin Johnson <robbat2@users.sourceforge.net>
- * 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$
- * @package phpMyAdmin
- */
-if (! defined('PHPMYADMIN')) {
-    exit;
-}
-
-if (! isset($GLOBALS['sql_delimiter'])) {
-        $GLOBALS['sql_delimiter'] = ';';
-}
-
-/**
- * @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<pre>';
-    print_r($PMA_SQPdata_function_name);
-    echo '</pre>';
-}
- */
-
-/**
- * @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
-    'MARIA',            // 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 = 30;
-
-/**
- * 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',
-    'INVOKER',
-    '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',
-    'MARIA',                // 5.1 ?
-    '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',
-    'PAGE',                 // 5.1-maria ?
-    'PARTIAL',
-    'PARTITION',            // 5.1
-    'PARTITIONS',           // 5.1
-    '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',
-    'TRANSACTIONAL',    // 5.1 ?
-    '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 = 289;
-/**
- * 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 '<pre>';
-print_r($difference);
-echo '</pre>';
-echo '<pre>';
-print_r($PMA_SQPdata_reserved_word);
-echo '</pre>';
-*/
-
-/**
- * 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',               // alias 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) . '<br />' : '';
-}
- */
-?>