[Summary view] [Print] [Text view]

   1  <?php
   2  /*************************************************************************************
   3   * sql.php
   4   * -------
   5   * Author: Nigel McNie (nigel@geshi.org)
   6   * Contributors:
   7   *  - Jürgen Thomas (Juergen.Thomas@vs-polis.de)
   8   * Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter)
   9   * Release Version: 1.0.9.1
  10   * Date Started: 2004/06/04
  11   *
  12   * SQL language file for GeSHi.
  13   *
  14   * CHANGES
  15   * -------
  16   * 2010/07/19 (1.0.8.9)
  17   *  -  Added many more keywords
  18   * 2008/05/23 (1.0.7.22)
  19   *  -  Added additional symbols for highlighting
  20   * 2004/11/27 (1.0.3)
  21   *  -  Added support for multiple object splitters
  22   * 2004/10/27 (1.0.2)
  23   *  -  Added "`" string delimiter
  24   *  -  Added "#" single comment starter
  25   * 2004/08/05 (1.0.1)
  26   *  -  Added support for symbols
  27   *  -  Added many more keywords (mostly MYSQL keywords)
  28   * 2004/07/14 (1.0.0)
  29   *  -  First Release
  30   *
  31   * TODO (updated 2004/11/27)
  32   * -------------------------
  33   * * Add all keywords
  34   * * Split this to several sql files - mysql-sql, ansi-sql etc
  35   *
  36   *************************************************************************************
  37   *
  38   *     This file is part of GeSHi.
  39   *
  40   *   GeSHi is free software; you can redistribute it and/or modify
  41   *   it under the terms of the GNU General Public License as published by
  42   *   the Free Software Foundation; either version 2 of the License, or
  43   *   (at your option) any later version.
  44   *
  45   *   GeSHi is distributed in the hope that it will be useful,
  46   *   but WITHOUT ANY WARRANTY; without even the implied warranty of
  47   *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  48   *   GNU General Public License for more details.
  49   *
  50   *   You should have received a copy of the GNU General Public License
  51   *   along with GeSHi; if not, write to the Free Software
  52   *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  53   *
  54   ************************************************************************************/
  55  
  56  $language_data = array (
  57      'LANG_NAME' => 'SQL',
  58      'COMMENT_SINGLE' => array(1 =>'--'),
  59      'COMMENT_MULTI' => array('/*' => '*/'),
  60      'CASE_KEYWORDS' => 1,
  61      'QUOTEMARKS' => array("'", '"', '`'),
  62      'ESCAPE_CHAR' => '\\',
  63      'KEYWORDS' => array(
  64          1 => array(
  65              'ADD', 'ALL', 'ALTER', 'AND', 'AS', 'ASC', 'AUTO_INCREMENT',
  66              'BEFORE', 'BEGIN', 'BETWEEN', 'BIGINT', 'BINARY', 'BLOB', 'BOOLEAN', 'BOTH', 'BY',
  67              'CALL', 'CASE', 'CAST', 'CEIL', 'CEILING', 'CHANGE', 'CHAR', 'CHAR_LENGTH', 'CHARACTER',
  68              'CHARACTER_LENGTH', 'CHECK', 'CLOB', 'COALESCE', 'COLLATE', 'COLUMN', 'COLUMNS',
  69              'CONNECT', 'CONSTRAINT', 'CONVERT', 'COUNT', 'CREATE', 'CROSS', 'CURRENT',
  70              'CURRENT_DATE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'CURRENT_USER',
  71              'DATA', 'DATABASE', 'DATABASES', 'DATE', 'DAY', 'DEC', 'DECIMAL', 'DECLARE',
  72              'DEFAULT', 'DEFERRABLE', 'DEFERRED', 'DELAYED', 'DELETE', 'DESC', 'DESCRIBE', 'DISTINCT', 'DOUBLE',
  73              'DOMAIN', 'DROP',
  74              'ELSE', 'ELSEIF', 'ENCLOSED', 'END', 'ESCAPED', 'EXCEPT', 'EXEC', 'EXECUTE', 'EXISTS',
  75              'EXP', 'EXPLAIN', 'EXTRACT',
  76              'FALSE', 'FIELD', 'FIELDS', 'FILTER', 'FIRST', 'FLOAT', 'FLOOR', 'FLUSH', 'FOR',
  77              'FOREIGN', 'FROM', 'FULL', 'FUNCTION',
  78              'GET', 'GROUP', 'GROUPING', 'GO', 'GOTO', 'GRANT', 'GRANTED',
  79              'HAVING', 'HOUR',
  80              'IDENTIFIED', 'IDENTITY', 'IF', 'IGNORE', 'IMMEDIATE', 'IN', 'INCREMENT', 'INDEX', 'INFILE', 'INITIALLY', 'INNER',
  81              'INOUT', 'INPUT', 'INSERT', 'INT', 'INTEGER', 'INTERSECT', 'INTERSECTION', 'INTERVAL',
  82              'INTO', 'IS',
  83              'JOIN',
  84              'KEY', 'KEYS', 'KILL',
  85              'LANGUAGE', 'LARGE', 'LAST', 'LEADING', 'LEFT', 'LENGTH', 'LIKE', 'LIMIT', 'LINES', 'LOAD',
  86              'LOCAL', 'LOCK', 'LOW_PRIORITY', 'LOWER',
  87              'MATCH', 'MAX', 'MERGE', 'MIN', 'MINUTE', 'MOD', 'MODIFIES', 'MODIFY', 'MONTH',
  88              'NATIONAL', 'NATURAL', 'NCHAR', 'NEW', 'NEXT', 'NEXTVAL', 'NONE', 'NOT',
  89              'NULL', 'NULLABLE', 'NULLIF', 'NULLS', 'NUMBER', 'NUMERIC',
  90              'OF', 'OLD', 'ON', 'ONLY', 'OPEN', 'OPTIMIZE', 'OPTION',
  91              'OPTIONALLY', 'OR', 'ORDER', 'OUT', 'OUTER', 'OUTFILE', 'OVER',
  92              'POSITION', 'POWER', 'PRECISION', 'PREPARE', 'PRIMARY', 'PROCEDURAL', 'PROCEDURE',
  93              'READ', 'REAL', 'REF', 'REFERENCES', 'REFERENCING', 'REGEXP', 'RENAME', 'REPLACE',
  94              'RESULT', 'RETURN', 'RETURNS', 'REVOKE', 'RIGHT', 'RLIKE', 'ROLLBACK', 'ROW',
  95              'ROW_NUMBER', 'ROWS', 'RESTRICT', 'ROLE', 'ROUTINE', 'ROW_COUNT',
  96              'SAVEPOINT', 'SEARCH', 'SECOND', 'SECTION', 'SELECT', 'SELF', 'SEQUENCE',
  97              'SESSION', 'SET', 'SETVAL', 'SHOW', 'SIMILAR', 'SIZE', 'SMALLINT', 'SOME',
  98              'SONAME', 'SOURCE', 'SPACE', 'SQL', 'SQRT', 'START', 'STATUS',
  99              'STRAIGHT_JOIN', 'STRUCTURE', 'STYLE', 'SUBSTRING', 'SUM',
 100              'TABLE', 'TABLE_NAME', 'TABLES', 'TERMINATED', 'TEMPORARY', 'THEN', 'TIME',
 101              'TIMESTAMP', 'TO', 'TRAILING', 'TRANSACTION', 'TRIGGER', 'TRIM', 'TRUE', 'TRUNCATE',
 102              'TRUSTED', 'TYPE',
 103              'UNDER', 'UNION', 'UNIQUE', 'UNKNOWN', 'UNLOCK', 'UNSIGNED',
 104              'UPDATE', 'UPPER', 'USE', 'USER', 'USING',
 105              'VALUE', 'VALUES', 'VARCHAR', 'VARIABLES', 'VARYING', 'VIEW',
 106              'WHEN', 'WHERE', 'WITH', 'WITHIN', 'WITHOUT', 'WORK', 'WRITE',
 107              'XOR',
 108              'YEAR',
 109              'ZEROFILL'
 110              )
 111          ),
 112      'SYMBOLS' => array(
 113          '(', ')', '=', '<', '>', '|', ',', '.', '+', '-', '*', '/'
 114          ),
 115      'CASE_SENSITIVE' => array(
 116          GESHI_COMMENTS => false,
 117          1 => false
 118          ),
 119      'STYLES' => array(
 120          'KEYWORDS' => array(
 121              1 => 'color: #993333; font-weight: bold;'
 122              ),
 123          'COMMENTS' => array(
 124              1 => 'color: #808080; font-style: italic;',
 125              //2 => 'color: #808080; font-style: italic;',
 126              'MULTI' => 'color: #808080; font-style: italic;'
 127              ),
 128          'ESCAPE_CHAR' => array(
 129              0 => 'color: #000099; font-weight: bold;'
 130              ),
 131          'BRACKETS' => array(
 132              0 => 'color: #66cc66;'
 133              ),
 134          'STRINGS' => array(
 135              0 => 'color: #ff0000;'
 136              ),
 137          'NUMBERS' => array(
 138              0 => 'color: #cc66cc;'
 139              ),
 140          'METHODS' => array(
 141              ),
 142          'SYMBOLS' => array(
 143              0 => 'color: #66cc66;'
 144              ),
 145          'SCRIPT' => array(
 146              ),
 147          'REGEXPS' => array(
 148              )
 149          ),
 150      'URLS' => array(
 151          1 => ''
 152          ),
 153      'OOLANG' => false,
 154      'OBJECT_SPLITTERS' => array(
 155          ),
 156      'REGEXPS' => array(
 157          ),
 158      'STRICT_MODE_APPLIES' => GESHI_NEVER,
 159      'SCRIPT_DELIMITERS' => array(
 160          ),
 161      'HIGHLIGHT_STRICT_BLOCK' => array(
 162          ),
 163      'PARSER_CONTROL' => array(
 164          'KEYWORDS' => array( //'
 165              'DISALLOWED_BEFORE' => "(?<![a-zA-Z0-9\$_\.\|\#|^&])"
 166              )
 167          )
 168  );