libraries/sqlparser.data.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * SQL Parser Matching Data
   5  *
   6  * Copyright 2002 Robin Johnson <robbat2@users.sourceforge.net>
   7  * http://www.orbis-terrarum.net/?l=people.robbat2
   8  *
   9  * This data is used by the SQL Parser to recognize keywords
  10  *
  11  * It has been extracted from the lex.h file in the MySQL BK tree
  12  * (around 4.0.2) as well as the MySQL documentation.
  13  *
  14  * It's easier to use only uppercase for proper sorting. In case of
  15  * doubt, use the test case to verify.
  16  *
  17  * @package PhpMyAdmin
  18  */
  19 if (! defined('PHPMYADMIN')) {
  20     exit;
  21 }
  22
  23 if (! isset($GLOBALS['sql_delimiter'])) {
  24         $GLOBALS['sql_delimiter'] = ';';
  25 }
  26
  27 /**
  28  * @global array MySQL function names
  29  */
  30 $PMA_SQPdata_function_name = array (
  31     'ABS',
  32     'ACOS',
  33     'ADDDATE',
  34     'ADDTIME',
  35     'AES_DECRYPT',
  36     'AES_ENCRYPT',
  37     'AREA',                     // polygon-property-functions.html
  38     'ASBINARY',
  39     'ASCII',
  40     'ASIN',
  41     'ASTEXT',
  42     'ATAN',
  43     'ATAN2',
  44     'AVG',
  45     'BDMPOLYFROMTEXT',
  46     'BDMPOLYFROMWKB',
  47     'BDPOLYFROMTEXT',
  48     'BDPOLYFROMWKB',
  49     'BENCHMARK',
  50     'BIN',
  51     'BIT_AND',
  52     'BIT_COUNT',
  53     'BIT_LENGTH',
  54     'BIT_OR',
  55     'BIT_XOR',                  // group-by-functions.html
  56     'BOUNDARY',                 // general-geometry-property-functions.html
  57     'BUFFER',
  58     'CAST',
  59     'CEIL',
  60     'CEILING',
  61     'CENTROID',                 // multipolygon-property-functions.html
  62     'CHAR',                     // string-functions.html
  63     'CHARACTER_LENGTH',
  64     'CHARSET',                  // information-functions.html
  65     'CHAR_LENGTH',
  66     'COALESCE',
  67     'COERCIBILITY',             // information-functions.html
  68     'COLLATION',                // information-functions.html
  69     'COMPRESS',                 // string-functions.html
  70     'CONCAT',
  71     'CONCAT_WS',
  72     'CONNECTION_ID',
  73     'CONTAINS',
  74     'CONV',
  75     'CONVERT',
  76     'CONVERT_TZ',
  77     'CONVEXHULL',
  78     'COS',
  79     'COT',
  80     'COUNT',
  81     'CRC32',                    // mathematical-functions.html
  82     'CROSSES',
  83     'CURDATE',
  84     'CURRENT_DATE',
  85     'CURRENT_TIME',
  86     'CURRENT_TIMESTAMP',
  87     'CURRENT_USER',
  88     'CURTIME',
  89     'DATABASE',
  90     'DATE',                     // date-and-time-functions.html
  91     'DATEDIFF',                 // date-and-time-functions.html
  92     'DATE_ADD',
  93     'DATE_DIFF',
  94     'DATE_FORMAT',
  95     'DATE_SUB',
  96     'DAY',
  97     'DAYNAME',
  98     'DAYOFMONTH',
  99     'DAYOFWEEK',
 100     'DAYOFYEAR',
 101     'DECODE',
 102     'DEFAULT',                  // miscellaneous-functions.html
 103     'DEGREES',
 104     'DES_DECRYPT',
 105     'DES_ENCRYPT',
 106     'DIFFERENCE',
 107     'DIMENSION',                // general-geometry-property-functions.html
 108     'DISJOINT',
 109     'DISTANCE',
 110     'ELT',
 111     'ENCODE',
 112     'ENCRYPT',
 113     'ENDPOINT',                 // linestring-property-functions.html
 114     'ENVELOPE',                 // general-geometry-property-functions.html
 115     'EQUALS',
 116     'EXP',
 117     'EXPORT_SET',
 118     'EXTERIORRING',             // polygon-property-functions.html
 119     'EXTRACT',
 120     'EXTRACTVALUE',             // xml-functions.html
 121     'FIELD',
 122     'FIND_IN_SET',
 123     'FLOOR',
 124     'FORMAT',
 125     'FOUND_ROWS',
 126     'FROM_DAYS',
 127     'FROM_UNIXTIME',
 128     'GEOMCOLLFROMTEXT',
 129     'GEOMCOLLFROMWKB',
 130     'GEOMETRYCOLLECTION',
 131     'GEOMETRYCOLLECTIONFROMTEXT',
 132     'GEOMETRYCOLLECTIONFROMWKB',
 133     'GEOMETRYFROMTEXT',
 134     'GEOMETRYFROMWKB',
 135     'GEOMETRYN',                // geometrycollection-property-functions.html
 136     'GEOMETRYTYPE',             // general-geometry-property-functions.html
 137     'GEOMFROMTEXT',
 138     'GEOMFROMWKB',
 139     'GET_FORMAT',
 140     'GET_LOCK',
 141     'GLENGTH',                  // linestring-property-functions.html
 142     'GREATEST',
 143     'GROUP_CONCAT',
 144     'GROUP_UNIQUE_USERS',
 145     'HEX',
 146     'HOUR',
 147     'IF',                       //control-flow-functions.html
 148     'IFNULL',
 149     'INET_ATON',
 150     'INET_NTOA',
 151     'INSERT',                   // string-functions.html
 152     'INSTR',
 153     'INTERIORRINGN',            // polygon-property-functions.html
 154     'INTERSECTION',
 155     'INTERSECTS',
 156     'INTERVAL',
 157     'ISCLOSED',                 // multilinestring-property-functions.html
 158     'ISEMPTY',                  // general-geometry-property-functions.html
 159     'ISNULL',
 160     'ISRING',                   // linestring-property-functions.html
 161     'ISSIMPLE',                 // general-geometry-property-functions.html
 162     'IS_FREE_LOCK',
 163     'IS_USED_LOCK',             // miscellaneous-functions.html
 164     'LAST_DAY',
 165     'LAST_INSERT_ID',
 166     'LCASE',
 167     'LEAST',
 168     'LEFT',
 169     'LENGTH',
 170     'LINEFROMTEXT',
 171     'LINEFROMWKB',
 172     'LINESTRING',
 173     'LINESTRINGFROMTEXT',
 174     'LINESTRINGFROMWKB',
 175     'LN',
 176     'LOAD_FILE',
 177     'LOCALTIME',
 178     'LOCALTIMESTAMP',
 179     'LOCATE',
 180     'LOG',
 181     'LOG10',
 182     'LOG2',
 183     'LOWER',
 184     'LPAD',
 185     'LTRIM',
 186     'MAKEDATE',
 187     'MAKETIME',
 188     'MAKE_SET',
 189     'MASTER_POS_WAIT',
 190     'MAX',
 191     'MBRCONTAINS',
 192     'MBRDISJOINT',
 193     'MBREQUAL',
 194     'MBRINTERSECTS',
 195     'MBROVERLAPS',
 196     'MBRTOUCHES',
 197     'MBRWITHIN',
 198     'MD5',
 199     'MICROSECOND',
 200     'MID',
 201     'MIN',
 202     'MINUTE',
 203     'MLINEFROMTEXT',
 204     'MLINEFROMWKB',
 205     'MOD',
 206     'MONTH',
 207     'MONTHNAME',
 208     'MPOINTFROMTEXT',
 209     'MPOINTFROMWKB',
 210     'MPOLYFROMTEXT',
 211     'MPOLYFROMWKB',
 212     'MULTILINESTRING',
 213     'MULTILINESTRINGFROMTEXT',
 214     'MULTILINESTRINGFROMWKB',
 215     'MULTIPOINT',
 216     'MULTIPOINTFROMTEXT',
 217     'MULTIPOINTFROMWKB',
 218     'MULTIPOLYGON',
 219     'MULTIPOLYGONFROMTEXT',
 220     'MULTIPOLYGONFROMWKB',
 221     'NAME_CONST',               // NAME_CONST()
 222     'NOW',
 223     'NULLIF',
 224     'NUMGEOMETRIES',            // geometrycollection-property-functions.html
 225     'NUMINTERIORRINGS',         // polygon-property-functions.html
 226     'NUMPOINTS',                // linestring-property-functions.html
 227     'OCT',
 228     'OCTET_LENGTH',
 229     'OLD_PASSWORD',
 230     'ORD',
 231     'OVERLAPS',
 232     'PASSWORD',
 233     'PERIOD_ADD',
 234     'PERIOD_DIFF',
 235     'PI',
 236     'POINT',
 237     'POINTFROMTEXT',
 238     'POINTFROMWKB',
 239     'POINTN',                   // inestring-property-functions.html
 240     'POINTONSURFACE',           // multipolygon-property-functions.html
 241     'POLYFROMTEXT',
 242     'POLYFROMWKB',
 243     'POLYGON',
 244     'POLYGONFROMTEXT',
 245     'POLYGONFROMWKB',
 246     'POSITION',
 247     'POW',
 248     'POWER',
 249     'QUARTER',
 250     'QUOTE',
 251     'RADIANS',
 252     'RAND',
 253     'RELATED',
 254     'RELEASE_LOCK',
 255     'REPEAT',
 256     'REPLACE',                  // string-functions.html
 257     'REVERSE',
 258     'RIGHT',
 259     'ROUND',
 260     'ROW_COUNT',                // information-functions.html
 261     'RPAD',
 262     'RTRIM',
 263     'SCHEMA',                   // information-functions.html
 264     'SECOND',
 265     'SEC_TO_TIME',
 266     'SESSION_USER',
 267     'SHA',
 268     'SHA1',
 269     'SIGN',
 270     'SIN',
 271     'SLEEP',                    // miscellaneous-functions.html
 272     'SOUNDEX',
 273     'SPACE',
 274     'SQRT',
 275     'SRID',                     // general-geometry-property-functions.html
 276     'STARTPOINT',               // linestring-property-functions.html
 277     'STD',
 278     'STDDEV',
 279     'STDDEV_POP',               // group-by-functions.html
 280     'STDDEV_SAMP',              // group-by-functions.html
 281     'STRCMP',
 282     'STR_TO_DATE',
 283     'SUBDATE',
 284     'SUBSTR',
 285     'SUBSTRING',
 286     'SUBSTRING_INDEX',
 287     'SUBTIME',
 288     'SUM',
 289     'SYMDIFFERENCE',
 290     'SYSDATE',
 291     'SYSTEM_USER',
 292     'TAN',
 293     'TIME',
 294     'TIMEDIFF',
 295     'TIMESTAMP',
 296     'TIMESTAMPADD',
 297     'TIMESTAMPDIFF',
 298     'TIME_FORMAT',
 299     'TIME_TO_SEC',
 300     'TOUCHES',
 301     'TO_DAYS',
 302     'TRIM',
 303     'TRUNCATE',                 // mathematical-functions.html
 304     'UCASE',
 305     'UNCOMPRESS',               // string-functions.html
 306     'UNCOMPRESSED_LENGTH',      // string-functions.html
 307     'UNHEX',                    // string-functions.html
 308     'UNIQUE_USERS',
 309     'UNIX_TIMESTAMP',
 310     'UPDATEXML',                // xml-functions.html
 311     'UPPER',
 312     'USER',
 313     'UTC_DATE',
 314     'UTC_TIME',
 315     'UTC_TIMESTAMP',
 316     'UUID',                     // miscellaneous-functions.html
 317     'VARIANCE',                 // group-by-functions.html
 318     'VAR_POP',                  // group-by-functions.html
 319     'VAR_SAMP',                 // group-by-functions.html
 320     'VERSION',
 321     'WEEK',
 322     'WEEKDAY',
 323     'WEEKOFYEAR',
 324     'WITHIN',
 325     'X',                        // point-property-functions.html
 326     'Y',                        // point-property-functions.html
 327     'YEAR',
 328     'YEARWEEK'
 329 );
 330
 331 /**
 332  * @global array MySQL attributes
 333  */
 334 $PMA_SQPdata_column_attrib = array (
 335     'ARCHIVE',          // Engine
 336     'ASCII',
 337     'AUTO_INCREMENT',
 338     'BDB',              // Engine
 339     'BERKELEYDB',       // Engine alias BDB
 340     'BINARY',
 341     'BLACKHOLE',        // Engine
 342     'CSV',              // Engine
 343     'DEFAULT',
 344     'EXAMPLE',          // Engine
 345     'FEDERATED',        // Engine
 346     'HEAP',             // Engine
 347     'INNOBASE',         // Engine alias InnoDB
 348     'INNODB',           // Engine InnoDB
 349     'ISAM',             // Engine
 350     'MARIA',            // Engine
 351     'MEMORY',           // Engine alias HEAP, but preferred
 352     'MERGE',            // Engine
 353     'MRG_ISAM',         // Engine
 354     'MRG_MYISAM',       // Engine alias MERGE
 355     'MYISAM',           // Engine MyISAM
 356     'NATIONAL',
 357     'NDB',              // Engine alias NDBCLUSTER
 358     'NDBCLUSTER',       // Engine
 359     'PRECISION',
 360     'UNDEFINED',
 361     'UNICODE',
 362     'UNSIGNED',
 363     'VARYING',
 364     'ZEROFILL'
 365 );
 366
 367 /**
 368  * words that are reserved by MySQL and may not be used as identifiers without
 369  * quotes
 370  *
 371  * @see http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html
 372  *
 373  * @global array MySQL reserved words
 374  */
 375 $PMA_SQPdata_reserved_word = array (
 376     'ACCESSIBLE',       // 5.1
 377     'ACTION',
 378     'ADD',
 379     'AFTER',
 380     'AGAINST',
 381     'AGGREGATE',
 382     'ALGORITHM',
 383     'ALL',
 384     'ALTER',
 385     'ANALYSE',
 386     'ANALYZE',
 387     'AND',
 388     'AS',
 389     'ASC',
 390     'AUTOCOMMIT',
 391     'AUTO_INCREMENT',
 392     'AVG_ROW_LENGTH',
 393     'BACKUP',
 394     'BEFORE',
 395     'BEGIN',
 396     'BETWEEN',
 397     'BINLOG',
 398     'BOTH',
 399     'BY',
 400     'CALL',
 401     'CASCADE',
 402     'CASE',
 403     'CHANGE',
 404     'CHANGED',
 405     'CHARSET',
 406     'CHECK',
 407     'CHECKSUM',
 408     'COLLATE',
 409     'COLLATION',
 410     'COLUMN',
 411     'COLUMNS',
 412     'COMMENT',
 413     'COMMIT',
 414     'COMMITTED',
 415     'COMPRESSED',
 416     'CONCURRENT',
 417     'CONSTRAINT',
 418     'CONTAINS',
 419     'CONVERT',
 420     'CREATE',
 421     'CROSS',
 422     'CURRENT_TIMESTAMP',
 423     'DATABASE',
 424     'DATABASES',
 425     'DAY',
 426     'DAY_HOUR',
 427     'DAY_MINUTE',
 428     'DAY_SECOND',
 429     'DECLARE',
 430     'DEFINER',
 431     'DELAYED',
 432     'DELAY_KEY_WRITE',
 433     'DELETE',
 434     'DESC',
 435     'DESCRIBE',
 436     'DETERMINISTIC',
 437     'DISTINCT',
 438     'DISTINCTROW',
 439     'DIV',
 440     'DO',
 441     'DROP',
 442     'DUMPFILE',
 443     'DUPLICATE',
 444     'DYNAMIC',
 445     'EACH',
 446     'ELSE',
 447     'ELSEIF',
 448     'ENCLOSED',
 449     'END',
 450     'ENGINE',
 451     'ENGINES',
 452     'ESCAPE',
 453     'ESCAPED',
 454     'EVENTS',
 455     'EXECUTE',
 456     'EXISTS',
 457     'EXIT',
 458     'EXPLAIN',
 459     'EXTENDED',
 460     'FALSE',
 461     'FAST',
 462     'FIELDS',
 463     'FILE',
 464     'FIRST',
 465     'FIXED',
 466     'FLUSH',
 467     'FOR',
 468     'FORCE',
 469     'FOREIGN',
 470     'FROM',
 471     'FULL',
 472     'FULLTEXT',
 473     'FUNCTION',
 474     'GEMINI',
 475     'GEMINI_SPIN_RETRIES',
 476     'GENERAL',
 477     'GLOBAL',
 478     'GRANT',
 479     'GRANTS',
 480     'GROUP',
 481     'HAVING',
 482     'HEAP',
 483     'HIGH_PRIORITY',
 484     'HOSTS',
 485     'HOUR',
 486     'HOUR_MINUTE',
 487     'HOUR_SECOND',
 488     'IDENTIFIED',
 489     'IF',
 490     'IGNORE',
 491     'IGNORE_SERVER_IDS',
 492     'IN',
 493     'INDEX',
 494     'INDEXES',
 495     'INFILE',
 496     'INNER',
 497     'INOUT',
 498     'INSERT',
 499     'INSERT_ID',
 500     'INSERT_METHOD',
 501     'INTERVAL',
 502     'INTO',
 503     'INVOKER',
 504     'IS',
 505     'ISOLATION',
 506     'JOIN',
 507     'KEY',
 508     'KEYS',
 509     'KILL',
 510     'LAST_INSERT_ID',
 511     'LEADING',
 512     'LEFT',
 513     'LIKE',
 514     'LIMIT',
 515     'LINEAR',               // 5.1
 516     'LINES',
 517     'LOAD',
 518     'LOCAL',
 519     'LOCK',
 520     'LOCKS',
 521     'LOGS',
 522     'LOW_PRIORITY',
 523     'MARIA',                // 5.1 ?
 524     'MASTER_CONNECT_RETRY',
 525     'MASTER_HEARTBEAT_PERIOD',
 526     'MASTER_HOST',
 527     'MASTER_LOG_FILE',
 528     'MASTER_LOG_POS',
 529     'MASTER_PASSWORD',
 530     'MASTER_PORT',
 531     'MASTER_USER',
 532     'MATCH',
 533     'MAXVALUE',
 534     'MAX_CONNECTIONS_PER_HOUR',
 535     'MAX_QUERIES_PER_HOUR',
 536     'MAX_ROWS',
 537     'MAX_UPDATES_PER_HOUR',
 538     'MAX_USER_CONNECTIONS',
 539     'MEDIUM',
 540     'MERGE',
 541     'MINUTE',
 542     'MINUTE_SECOND',
 543     'MIN_ROWS',
 544     'MODE',
 545     'MODIFIES',
 546     'MODIFY',
 547     'MONTH',
 548     'MRG_MYISAM',
 549     'MYISAM',
 550     'NAMES',
 551     'NATURAL',
 552     // 'NO' is not allowed in SQL-99 but is allowed in MySQL
 553     //'NO',
 554     'NOT',
 555     'NULL',
 556     'OFFSET',
 557     'ON',
 558     'OPEN',
 559     'OPTIMIZE',
 560     'OPTION',
 561     'OPTIONALLY',
 562     'OR',
 563     'ORDER',
 564     'OUT',
 565     'OUTER',
 566     'OUTFILE',
 567     'PACK_KEYS',
 568     'PAGE',                 // 5.1-maria ?
 569     'PAGE_CHECKSUM',        // 5.1
 570     'PARTIAL',
 571     'PARTITION',            // 5.1
 572     'PARTITIONS',           // 5.1
 573     'PASSWORD',
 574     'PRIMARY',
 575     'PRIVILEGES',
 576     'PROCEDURE',
 577     'PROCESS',
 578     'PROCESSLIST',
 579     'PURGE',
 580     'QUICK',
 581     'RAID0',
 582     'RAID_CHUNKS',
 583     'RAID_CHUNKSIZE',
 584     'RAID_TYPE',
 585     'RANGE',                // 5.1
 586     'READ',
 587     'READS',
 588     'READ_ONLY',            // 5.1
 589     'READ_WRITE',           // 5.1
 590     'REFERENCES',
 591     'REGEXP',
 592     'RELOAD',
 593     'RENAME',
 594     'REPAIR',
 595     'REPEATABLE',
 596     'REPLACE',
 597     'REPLICATION',
 598     'RESET',
 599     'RESIGNAL',
 600     'RESTORE',
 601     'RESTRICT',
 602     'RETURN',
 603     'RETURNS',
 604     'REVOKE',
 605     'RIGHT',
 606     'RLIKE',
 607     'ROLLBACK',
 608     'ROW',
 609     'ROWS',
 610     'ROW_FORMAT',
 611     'SECOND',
 612     'SECURITY',
 613     'SELECT',
 614     'SEPARATOR',
 615     'SERIALIZABLE',
 616     'SESSION',
 617     'SHARE',
 618     'SHOW',
 619     'SHUTDOWN',
 620     'SIGNAL',
 621     'SLAVE',
 622     'SLOW',
 623     'SONAME',
 624     'SOUNDS',                   // string-functions.html
 625     'SQL',
 626     'SQL_AUTO_IS_NULL',
 627     'SQL_BIG_RESULT',
 628     'SQL_BIG_SELECTS',
 629     'SQL_BIG_TABLES',
 630     'SQL_BUFFER_RESULT',
 631     'SQL_CACHE',
 632     'SQL_CALC_FOUND_ROWS',
 633     'SQL_LOG_BIN',
 634     'SQL_LOG_OFF',
 635     'SQL_LOG_UPDATE',
 636     'SQL_LOW_PRIORITY_UPDATES',
 637     'SQL_MAX_JOIN_SIZE',
 638     'SQL_NO_CACHE',
 639     'SQL_QUOTE_SHOW_CREATE',
 640     'SQL_SAFE_UPDATES',
 641     'SQL_SELECT_LIMIT',
 642     'SQL_SLAVE_SKIP_COUNTER',
 643     'SQL_SMALL_RESULT',
 644     'SQL_WARNINGS',
 645     'START',
 646     'STARTING',
 647     'STATUS',
 648     'STOP',
 649     'STORAGE',
 650     'STRAIGHT_JOIN',
 651     'STRING',
 652     'STRIPED',
 653     'SUPER',
 654     'TABLE',
 655     'TABLES',
 656     'TEMPORARY',
 657     'TERMINATED',
 658     'THEN',
 659     'TO',
 660     'TRAILING',
 661     'TRANSACTIONAL',    // 5.1 ?
 662     'TRIGGER',
 663     'TRUE',
 664     'TRUNCATE',
 665     'TYPE',
 666     'TYPES',
 667     'UNCOMMITTED',
 668     'UNION',
 669     'UNIQUE',
 670     'UNLOCK',
 671     'UPDATE',
 672     'USAGE',
 673     'USE',
 674     'USING',
 675     'VALUES',
 676     'VARIABLES',
 677     'VIEW',
 678     'WHEN',
 679     'WHERE',
 680     'WITH',
 681     'WORK',
 682     'WRITE',
 683     'XOR',
 684     'YEAR_MONTH'
 685 );
 686
 687 /**
 688  * words forbidden to be used as column or table name without quotes
 689  * as seen in http://dev.mysql.com/doc/refman/5.6/en/reserved-words.html
 690  *
 691  * @global array MySQL forbidden words
 692  */
 693 $PMA_SQPdata_forbidden_word = array (
 694     'ACCESSIBLE',
 695     'ADD',
 696     'ALL',
 697     'ALTER',
 698     'ANALYZE',
 699     'AND',
 700     'AS',
 701     'ASC',
 702     'ASENSITIVE',
 703     'BEFORE',
 704     'BETWEEN',
 705     'BIGINT',
 706     'BINARY',
 707     'BLOB',
 708     'BOTH',
 709     'BY',
 710     'CALL',
 711     'CASCADE',
 712     'CASE',
 713     'CHANGE',
 714     'CHAR',
 715     'CHARACTER',
 716     'CHECK',
 717     'COLLATE',
 718     'COLUMN',
 719     'CONDITION',
 720     'CONSTRAINT',
 721     'CONTINUE',
 722     'CONVERT',
 723     'CREATE',
 724     'CROSS',
 725     'CURRENT_DATE',
 726     'CURRENT_TIME',
 727     'CURRENT_TIMESTAMP',
 728     'CURRENT_USER',
 729     'CURSOR',
 730     'DATABASE',
 731     'DATABASES',
 732     'DAY_HOUR',
 733     'DAY_MICROSECOND',
 734     'DAY_MINUTE',
 735     'DAY_SECOND',
 736     'DEC',
 737     'DECIMAL',
 738     'DECLARE',
 739     'DEFAULT',
 740     'DELAYED',
 741     'DELETE',
 742     'DESC',
 743     'DESCRIBE',
 744     'DETERMINISTIC',
 745     'DISTINCT',
 746     'DISTINCTROW',
 747     'DIV',
 748     'DOUBLE',
 749     'DROP',
 750     'DUAL',
 751     'EACH',
 752     'ELSE',
 753     'ELSEIF',
 754     'ENCLOSED',
 755     'ESCAPED',
 756     'EXISTS',
 757     'EXIT',
 758     'EXPLAIN',
 759     'FALSE',
 760     'FETCH',
 761     'FLOAT',
 762     'FLOAT4',
 763     'FLOAT8',
 764     'FOR',
 765     'FORCE',
 766     'FOREIGN',
 767     'FROM',
 768     'FULLTEXT',
 769     'GENERAL',
 770     'GET',
 771     'GRANT',
 772     'GROUP',
 773     'HAVING',
 774     'HIGH_PRIORITY',
 775     'HOUR_MICROSECOND',
 776     'HOUR_MINUTE',
 777     'HOUR_SECOND',
 778     'IF',
 779     'IGNORE',
 780     'IGNORE_SERVER_IDS',
 781     'IN',
 782     'INDEX',
 783     'INFILE',
 784     'INNER',
 785     'INOUT',
 786     'INSENSITIVE',
 787     'INSERT',
 788     'INT',
 789     'INT1',
 790     'INT2',
 791     'INT3',
 792     'INT4',
 793     'INT8',
 794     'INTEGER',
 795     'INTERVAL',
 796     'INTO',
 797     'IO_AFTER_GTIDS',
 798     'IO_BEFORE_GTIDS',
 799     'IS',
 800     'ITERATE',
 801     'JOIN',
 802     'KEY',
 803     'KEYS',
 804     'KILL',
 805     'LEADING',
 806     'LEAVE',
 807     'LEFT',
 808     'LIKE',
 809     'LIMIT',
 810     'LINEAR',
 811     'LINES',
 812     'LOAD',
 813     'LOCALTIME',
 814     'LOCALTIMESTAMP',
 815     'LOCK',
 816     'LONG',
 817     'LONGBLOB',
 818     'LONGTEXT',
 819     'LOOP',
 820     'LOW_PRIORITY',
 821     'MASTER_BIND',
 822     'MASTER_HEARTBEAT_PERIOD',
 823     'MASTER_SSL_VERIFY_SERVER_CERT',
 824     'MATCH',
 825     'MAXVALUE',
 826     'MEDIUMBLOB',
 827     'MEDIUMINT',
 828     'MEDIUMTEXT',
 829     'MIDDLEINT',
 830     'MINUTE_MICROSECOND',
 831     'MINUTE_SECOND',
 832     'MOD',
 833     'MODIFIES',
 834     'NATURAL',
 835     'NOT',
 836     'NO_WRITE_TO_BINLOG',
 837     'NULL',
 838     'NUMERIC',
 839     'ON',
 840     'ONE_SHOT',
 841     'OPTIMIZE',
 842     'OPTION',
 843     'OPTIONALLY',
 844     'OR',
 845     'ORDER',
 846     'OUT',
 847     'OUTER',
 848     'OUTFILE',
 849     'PARTITION',
 850     'PRECISION',
 851     'PRIMARY',
 852     'PROCEDURE',
 853     'PURGE',
 854     'RANGE',
 855     'READ',
 856     'READS',
 857     'READ_WRITE',
 858     'REAL',
 859     'REFERENCES',
 860     'REGEXP',
 861     'RELEASE',
 862     'RENAME',
 863     'REPEAT',
 864     'REPLACE',
 865     'REQUIRE',
 866     'RESIGNAL',
 867     'RESTRICT',
 868     'RETURN',
 869     'REVOKE',
 870     'RIGHT',
 871     'RLIKE',
 872     'SCHEMA',
 873     'SCHEMAS',
 874     'SECOND_MICROSECOND',
 875     'SELECT',
 876     'SENSITIVE',
 877     'SEPARATOR',
 878     'SET',
 879     'SHOW',
 880     'SIGNAL',
 881     'SLOW',
 882     'SMALLINT',
 883     'SPATIAL',
 884     'SPECIFIC',
 885     'SQL',
 886     'SQLEXCEPTION',
 887     'SQLSTATE',
 888     'SQLWARNING',
 889     'SQL_AFTER_GTIDS',
 890     'SQL_BEFORE_GTIDS',
 891     'SQL_BIG_RESULT',
 892     'SQL_CALC_FOUND_ROWS',
 893     'SQL_SMALL_RESULT',
 894     'SSL',
 895     'STARTING',
 896     'STRAIGHT_JOIN',
 897     'TABLE',
 898     'TERMINATED',
 899     'THEN',
 900     'TINYBLOB',
 901     'TINYINT',
 902     'TINYTEXT',
 903     'TO',
 904     'TRAILING',
 905     'TRIGGER',
 906     'TRUE',
 907     'UNDO',
 908     'UNION',
 909     'UNIQUE',
 910     'UNLOCK',
 911     'UNSIGNED',
 912     'UPDATE',
 913     'USAGE',
 914     'USE',
 915     'USING',
 916     'UTC_DATE',
 917     'UTC_TIME',
 918     'UTC_TIMESTAMP',
 919     'VALUES',
 920     'VARBINARY',
 921     'VARCHAR',
 922     'VARCHARACTER',
 923     'VARYING',
 924     'WHEN',
 925     'WHERE',
 926     'WHILE',
 927     'WITH',
 928     'WRITE',
 929     'XOR',
 930     'YEAR_MONTH',
 931     'ZEROFILL'
 932 );
 933
 934 /**
 935  * the MySQL column/data types
 936  *
 937  * @see http://dev.mysql.com/doc/refman/5.1/en/data-types.html
 938  * @see http://dev.mysql.com/doc/refman/5.1/en/mysql-spatial-datatypes.html
 939  *
 940  * @global array MySQL column types
 941  */
 942 $PMA_SQPdata_column_type = array (
 943     'BIGINT',
 944     'BINARY',
 945     'BIT',
 946     'BLOB',
 947     'BOOL',
 948     'BOOLEAN',              // numeric-type-overview.html
 949     'CHAR',
 950     'CHARACTER',
 951     'DATE',
 952     'DATETIME',
 953     'DEC',
 954     'DECIMAL',
 955     'DOUBLE',
 956     'ENUM',
 957     'FLOAT',
 958     'FLOAT4',
 959     'FLOAT8',
 960     'GEOMETRY',             // spatial
 961     'GEOMETRYCOLLECTION',   // spatial
 962     'INT',
 963     'INT1',
 964     'INT2',
 965     'INT3',
 966     'INT4',
 967     'INT8',
 968     'INTEGER',
 969     'LINESTRING',           // spatial
 970     'LONG',
 971     'LONGBLOB',
 972     'LONGTEXT',
 973     'MEDIUMBLOB',
 974     'MEDIUMINT',
 975     'MEDIUMTEXT',
 976     'MIDDLEINT',
 977     'MULTILINESTRING',      // spatial
 978     'MULTIPOINT',           // spatial
 979     'MULTIPOLYGON',         // spatial
 980     'NCHAR',
 981     'NUMERIC',
 982     'POINT',                // spatial
 983     'POLYGON',              // spatial
 984     'REAL',
 985     'SERIAL',               // alias
 986     'SET',
 987     'SMALLINT',
 988     'TEXT',
 989     'TIME',
 990     'TIMESTAMP',
 991     'TINYBLOB',
 992     'TINYINT',
 993     'TINYTEXT',
 994     'VARBINARY',
 995     'VARCHAR',
 996     'YEAR'
 997 );
 998
 999 ?>