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