libraries/sqlparser.data.php3

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5
   6 /** SQL Parser Matching Data
   7  *
   8  * Copyright 2002 Robin Johnson <robbat2@users.sourceforge.net>
   9  * http://www.orbis-terrarum.net/?l=people.robbat2
  10  *
  11  * This data is used by the SQL Parser to recognize keywords
  12  *
  13  * It has been extracted from the lex.h file in the MySQL BK tree
  14  * (around 4.0.2) as well as the MySQL documentation.
  15  */
  16
  17 if (!defined('PMA_SQP_DATA_INCLUDED')) {
  18     define('PMA_SQP_DATA_INCLUDED', 1);
  19
  20     $PMA_SQPdata_function_name = array (
  21         'ABS',
  22         'ACOS',
  23         'ADDDATE',
  24         'AES_ENCRYPT',
  25         'AES_DECRYPT',
  26         'ASCII',
  27         'ASIN',
  28         'ATAN',
  29         'ATAN2',
  30         'AVG',
  31         'BENCHMARK',
  32         'BIN',
  33         'BIT_AND',
  34         'BIT_COUNT',
  35         'BIT_LENGTH',
  36         'BIT_OR',
  37         'CAST',
  38         'CEIL',
  39         'CEILING',
  40         'CHAR_LENGTH',
  41         'CHARACTER_LENGTH',
  42         'COALESCE',
  43         'CONCAT',
  44         'CONCAT_WS',
  45         'CONNECTION_ID',
  46         'CONV',
  47         'CONVERT',
  48         'COS',
  49         'COT',
  50         'COUNT',
  51         'CURDATE',
  52         'CURRENT_DATE',
  53         'CURRENT_TIME',
  54         'CURRENT_TIMESTAMP',
  55         'CURRENT_USER',
  56         'CURTIME',
  57         'DATABASE',
  58         'DATE_ADD',
  59         'DATE_FORMAT',
  60         'DATE_SUB',
  61         'DAYNAME',
  62         'DAYOFMONTH',
  63         'DAYOFWEEK',
  64         'DAYOFYEAR',
  65         'DECODE',
  66         'DEGREES',
  67         'DES_ENCRYPT',
  68         'DES_DECRYPT',
  69         'ELT',
  70         'ENCODE',
  71         'ENCRYPT',
  72         'EXP',
  73         'EXPORT_SET',
  74         'EXTRACT',
  75         'FIELD',
  76         'FIND_IN_SET',
  77         'FLOOR',
  78         'FORMAT',
  79         'FOUND_ROWS',
  80         'FROM_DAYS',
  81         'FROM_UNIXTIME',
  82         'GET_LOCK',
  83         'GREATEST',
  84         'GROUP_UNIQUE_USERS',
  85         'HEX',
  86         'IFNULL',
  87         'INET_ATON',
  88         'INET_NTOA',
  89         'INSTR',
  90         'INTERVAL',
  91         'IS_FREE_LOCK',
  92         'ISNULL',
  93         'LAST_INSERT_ID',
  94         'LCASE',
  95         'LEAST',
  96         'LEFT',
  97         'LENGTH',
  98         'LN',
  99         'LOAD_FILE',
 100         'LOCATE',
 101         'LOG',
 102         'LOG2',
 103         'LOG10',
 104         'LOWER',
 105         'LPAD',
 106         'LTRIM',
 107         'MAKE_SET',
 108         'MASTER_POS_WAIT',
 109         'MAX',
 110         'MD5',
 111         'MID',
 112         'MIN',
 113         'MOD',
 114         'MONTHNAME',
 115         'NOW',
 116         'NULLIF',
 117         'OCT',
 118         'OCTET_LENGTH',
 119         'ORD',
 120         'PASSWORD',
 121         'PERIOD_ADD',
 122         'PERIOD_DIFF',
 123         'PI',
 124         'POSITION',
 125         'POW',
 126         'POWER',
 127         'QUARTER',
 128         'QUOTE',
 129         'RADIANS',
 130         'RAND',
 131         'RELEASE_LOCK',
 132         'REPEAT',
 133         'REVERSE',
 134         'RIGHT',
 135         'ROUND',
 136         'RPAD',
 137         'RTRIM',
 138         'SEC_TO_TIME',
 139         'SESSION_USER',
 140         'SHA',
 141         'SHA1',
 142         'SIGN',
 143         'SIN',
 144         'SOUNDEX',
 145         'SPACE',
 146         'SQRT',
 147         'STD',
 148         'STDDEV',
 149         'STRCMP',
 150         'SUBDATE',
 151         'SUBSTRING',
 152         'SUBSTRING_INDEX',
 153         'SUM',
 154         'SYSDATE',
 155         'SYSTEM_USER',
 156         'TAN',
 157         'TIME_FORMAT',
 158         'TIME_TO_SEC',
 159         'TO_DAYS',
 160         'TRIM',
 161         'UCASE',
 162         'UNIQUE_USERS',
 163         'UNIX_TIMESTAMP',
 164         'UPPER',
 165         'USER',
 166         'VERSION',
 167         'WEEK',
 168         'WEEKDAY',
 169         'YEARWEEK'
 170     );
 171     //$PMA_SQPdata_function_name_cnt = count($PMA_SQPdata_function_name);
 172     $PMA_SQPdata_function_name_cnt = 149;
 173
 174     $PMA_SQPdata_column_attrib = array (
 175         'AUTO_INCREMENT',
 176         'BDB',
 177         'BERKELEYDB',
 178         'BINARY',
 179         'DEFAULT',
 180         'INNOBASE',
 181         'INNODB',
 182         'ISAM',
 183         'MRG_MYISAM',
 184         'MYISAM',
 185         'NATIONAL',
 186         'PRECISION',
 187         'UNSIGNED',
 188         'VARYING',
 189         'ZEROFILL'
 190     );
 191     //$PMA_SQPdata_column_attrib_cnt = count($PMA_SQPdata_column_attrib);
 192     $PMA_SQPdata_column_attrib_cnt = 15;
 193
 194     $PMA_SQPdata_reserved_word = array (
 195         'ACTION',
 196         'ADD',
 197         'AFTER',
 198         'AGAINST',
 199         'AGGREGATE',
 200         'ALL',
 201         'ALTER',
 202         'ANALYSE',
 203         'ANALYZE',
 204         'AND',
 205         'AS',
 206         'ASC',
 207         'AUTOCOMMIT',
 208         'AVG_ROW_LENGTH',
 209         'BACKUP',
 210         'BEGIN',
 211         'BETWEEN',
 212         'BOTH',
 213         'BY',
 214         'CASCADE',
 215         'CASE',
 216         'CHANGE',
 217         'CHANGED',
 218         'CHECK',
 219         'CHECKSUM',
 220         'CLIENT',
 221         'COLUMN',
 222         'COLUMNS',
 223         'COMMENT',
 224         'COMMIT',
 225         'COMMITTED',
 226         'COMPRESSED',
 227         'CONCURRENT',
 228         'CONSTRAINT',
 229         'CREATE',
 230         'CROSS',
 231         'DATA',
 232         'DATABASE',
 233         'DATABASES',
 234         'DAY',
 235         'DAY_HOUR',
 236         'DAY_MINUTE',
 237         'DAY_SECOND',
 238         'DELAYED',
 239         'DELAY_KEY_WRITE',
 240         'DELETE',
 241         'DESC',
 242         'DESCRIBE',
 243         'DISTINCT',
 244         'DISTINCTROW',
 245         'DO',
 246         'DROP',
 247         'DUMPFILE',
 248         'DYNAMIC',
 249         'ELSE',
 250         'ENCLOSED',
 251         'END',
 252         'ESCAPE',
 253         'ESCAPED',
 254         'EXECUTE',
 255         'EXISTS',
 256         'EXPLAIN',
 257         'EXTENDED',
 258         'FAST',
 259         'FIELDS',
 260         'FILE',
 261         'FIRST',
 262         'FIXED',
 263         'FLUSH',
 264         'FOR',
 265         'FOREIGN',
 266         'FROM',
 267         'FULL',
 268         'FULLTEXT',
 269         'FUNCTION',
 270         'GEMINI',
 271         'GEMINI_SPIN_RETRIES',
 272         'GLOBAL',
 273         'GRANT',
 274         'GRANTS',
 275         'GROUP',
 276         'HAVING',
 277         'HEAP',
 278         'HIGH_PRIORITY',
 279         'HOSTS',
 280         'HOUR',
 281         'HOUR_MINUTE',
 282         'HOUR_SECOND',
 283         'IDENTIFIED',
 284         'IF',
 285         'IGNORE',
 286         'IN',
 287         'INDEX',
 288         'INDEXES',
 289         'INFILE',
 290         'INNER',
 291         'INSERT',
 292         'INSERT_ID',
 293         'INSERT_METHOD',
 294         'INTERVAL',
 295         'INTO',
 296         'IS',
 297         'ISOLATION',
 298         'JOIN',
 299         'KEY',
 300         'KEYS',
 301         'KILL',
 302         'LAST_INSERT_ID',
 303         'LEADING',
 304         'LEFT',
 305         'LEVEL',
 306         'LIKE',
 307         'LIMIT',
 308         'LINES',
 309         'LOAD',
 310         'LOCAL',
 311         'LOCK',
 312         'LOCKS',
 313         'LOGS',
 314         'LOW_PRIORITY',
 315         'MASTER',
 316         'MASTER_CONNECT_RETRY',
 317         'MASTER_HOST',
 318         'MASTER_LOG_FILE',
 319         'MASTER_LOG_POS',
 320         'MASTER_PASSWORD',
 321         'MASTER_PORT',
 322         'MASTER_USER',
 323         'MATCH',
 324         'MAX_CONNECTIONS_PER_HOUR',
 325         'MAX_QUERIES_PER_HOUR',
 326         'MAX_ROWS',
 327         'MAX_UPDATES_PER_HOUR',
 328         'MEDIUM',
 329         'MERGE',
 330         'MIN_ROWS',
 331         'MINUTE',
 332         'MINUTE_SECOND',
 333         'MODE',
 334         'MODIFY',
 335         'MONTH',
 336         'MRG_MYISAM',
 337         'MYISAM',
 338         'NATURAL',
 339         // 'NO' is not allowed in SQL-99 but is allowed in MySQL
 340         //'NO',
 341         'NOT',
 342         'NULL',
 343         'ON',
 344         'OPEN',
 345         'OPTIMIZE',
 346         'OPTION',
 347         'OPTIONALLY',
 348         'OR',
 349         'ORDER',
 350         'OUTER',
 351         'OUTFILE',
 352         'PACK_KEYS',
 353         'PARTIAL',
 354         'PASSWORD',
 355         'PRIMARY',
 356         'PRIVILEGES',
 357         'PROCEDURE',
 358         'PROCESS',
 359         'PROCESSLIST',
 360         'PURGE',
 361         'QUICK',
 362         'RAID0',
 363         'RAID_CHUNKS',
 364         'RAID_CHUNKSIZE',
 365         'RAID_TYPE',
 366         'READ',
 367         'REFERENCES',
 368         'REGEXP',
 369         'RELOAD',
 370         'RENAME',
 371         'REPAIR',
 372         'REPEATABLE',
 373         'REPLACE',
 374         'REPLICATION',
 375         'RESET',
 376         'RESTORE',
 377         'RESTRICT',
 378         'RETURNS',
 379         'REVOKE',
 380         'RIGHT',
 381         'RLIKE',
 382         'ROLLBACK',
 383         'ROW',
 384         'ROW_FORMAT',
 385         'ROWS',
 386         'SECOND',
 387         'SELECT',
 388         'SERIALIZABLE',
 389         'SESSION',
 390         'SHARE',
 391         'SHOW',
 392         'SHUTDOWN',
 393         'SLAVE',
 394         'SONAME',
 395         'SQL_AUTO_IS_NULL',
 396         'SQL_BIG_RESULT',
 397         'SQL_BIG_SELECTS',
 398         'SQL_BIG_TABLES',
 399         'SQL_BUFFER_RESULT',
 400         'SQL_LOG_BIN',
 401         'SQL_LOG_OFF',
 402         'SQL_LOG_UPDATE',
 403         'SQL_LOW_PRIORITY_UPDATES',
 404         'SQL_MAX_JOIN_SIZE',
 405         'SQL_QUOTE_SHOW_CREATE',
 406         'SQL_SAFE_UPDATES',
 407         'SQL_SELECT_LIMIT',
 408         'SQL_SLAVE_SKIP_COUNTER',
 409         'SQL_SMALL_RESULT',
 410         'SQL_WARNINGS',
 411         'START',
 412         'STARTING',
 413         'STATUS',
 414         'STOP',
 415         'STRAIGHT_JOIN',
 416         'STRING',
 417         'STRIPED',
 418         'SUPER',
 419         'TABLE',
 420         'TABLES',
 421         'TEMPORARY',
 422         'TERMINATED',
 423         'THEN',
 424         'TO',
 425         'TRAILING',
 426         'TRUNCATE',
 427         'TYPE',
 428         'UNCOMMITTED',
 429         'UNION',
 430         'UNIQUE',
 431         'UNLOCK',
 432         'UPDATE',
 433         'USAGE',
 434         'USE',
 435         'USING',
 436         'VALUES',
 437         'VARIABLES',
 438         'WHEN',
 439         'WHERE',
 440         'WITH',
 441         'WORK',
 442         'WRITE',
 443         'XOR',
 444         'YEAR_MONTH'
 445     );
 446     //$PMA_SQPdata_reserved_word_cnt = count($PMA_SQPdata_reserved_word);
 447     $PMA_SQPdata_reserved_word_cnt = 248;
 448
 449     $PMA_SQPdata_column_type = array (
 450         'BIGINT',
 451         'BIT',
 452         'BLOB',
 453         'BOOL',
 454         'CHAR',
 455         'CHARACTER',
 456         'DATE',
 457         'DATETIME',
 458         'DEC',
 459         'DECIMAL',
 460         'DOUBLE',
 461         'ENUM',
 462         'FLOAT',
 463         'FLOAT4',
 464         'FLOAT8',
 465         'INT',
 466         'INT1',
 467         'INT2',
 468         'INT3',
 469         'INT4',
 470         'INT8',
 471         'INTEGER',
 472         'LONG',
 473         'LONGBLOB',
 474         'LONGTEXT',
 475         'MEDIUMBLOB',
 476         'MEDIUMINT',
 477         'MEDIUMTEXT',
 478         'MIDDLEINT',
 479         'NCHAR',
 480         'NUMERIC',
 481         'REAL',
 482         'SET',
 483         'SMALLINT',
 484         'TEXT',
 485         'TIME',
 486         'TIMESTAMP',
 487         'TINYBLOB',
 488         'TINYINT',
 489         'TINYTEXT',
 490         'VARBINARY',
 491         'VARCHAR',
 492         'YEAR'
 493     );
 494     //$PMA_SQPdata_column_type_cnt = count($PMA_SQPdata_column_type);
 495     $PMA_SQPdata_column_type_cnt = 43;
 496
 497 } // $__PMA_SQP_DATA__
 498 ?>