[Summary view] [Print] [Text view]

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