Mambo API

[Summary view] [Print] [Text view]

   1  <?php
   2  /*************************************************************************************
   3   * sql.php
   4   * -------
   5   * Author: Nigel McNie (nigel@geshi.org)
   6   * Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter)
   7   * Release Version: 1.0.7.20
   8   * Date Started: 2004/06/04
   9   *
  10   * SQL language file for GeSHi.
  11   *
  12   * CHANGES
  13   * -------
  14   * 2004/11/27 (1.0.3)
  15   *  -  Added support for multiple object splitters
  16   * 2004/10/27 (1.0.2)
  17   *  -  Added "`" string delimiter
  18   *  -  Added "#" single comment starter
  19   * 2004/08/05 (1.0.1)
  20   *  -  Added support for symbols
  21   *  -  Added many more keywords (mostly MYSQL keywords)
  22   * 2004/07/14 (1.0.0)
  23   *  -  First Release
  24   *
  25   * TODO (updated 2004/11/27)
  26   * -------------------------
  27   * * Add all keywords
  28   * * Split this to several sql files - mysql-sql, ansi-sql etc
  29   *
  30   *************************************************************************************
  31   *
  32   *     This file is part of GeSHi.
  33   *
  34   *   GeSHi is free software; you can redistribute it and/or modify
  35   *   it under the terms of the GNU General Public License as published by
  36   *   the Free Software Foundation; either version 2 of the License, or
  37   *   (at your option) any later version.
  38   *
  39   *   GeSHi is distributed in the hope that it will be useful,
  40   *   but WITHOUT ANY WARRANTY; without even the implied warranty of
  41   *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  42   *   GNU General Public License for more details.
  43   *
  44   *   You should have received a copy of the GNU General Public License
  45   *   along with GeSHi; if not, write to the Free Software
  46   *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  47   *
  48   ************************************************************************************/
  49  
  50  $language_data = array (
  51      'LANG_NAME' => 'SQL',
  52      'COMMENT_SINGLE' => array(1 =>'--', 2 => '#'),
  53      'COMMENT_MULTI' => array('/*' => '*/'),
  54      'CASE_KEYWORDS' => 1,
  55      'QUOTEMARKS' => array("'", '"', '`'),
  56      'ESCAPE_CHAR' => '\\',
  57      'KEYWORDS' => array(
  58          1 => array(
  59              'ALL', 'ASC', 'AS',  'ALTER', 'AND', 'ADD', 'AUTO_INCREMENT',
  60              'BETWEEN', 'BINARY', 'BOTH', 'BY', 'BOOLEAN',
  61              'CHANGE', 'CHECK', 'COLUMNS', 'COLUMN', 'CROSS','CREATE',
  62              'DATABASES', 'DATABASE', 'DATA', 'DELAYED', 'DESCRIBE', 'DESC',  'DISTINCT', 'DELETE', 'DROP', 'DEFAULT',
  63              'ENCLOSED', 'ESCAPED', 'EXISTS', 'EXPLAIN',
  64              'FIELDS', 'FIELD', 'FLUSH', 'FOR', 'FOREIGN', 'FUNCTION', 'FROM',
  65              'GROUP', 'GRANT',
  66              'HAVING',
  67              'IGNORE', 'INDEX', 'INFILE', 'INSERT', 'INNER', 'INTO', 'IDENTIFIED', 'IN', 'IS', 'IF',
  68              'JOIN',
  69              'KEYS', 'KILL','KEY',
  70              'LEADING', 'LIKE', 'LIMIT', 'LINES', 'LOAD', 'LOCAL', 'LOCK', 'LOW_PRIORITY', 'LEFT', 'LANGUAGE',
  71              'MODIFY',
  72              'NATURAL', 'NOT', 'NULL', 'NEXTVAL',
  73              'OPTIMIZE', 'OPTION', 'OPTIONALLY', 'ORDER', 'OUTFILE', 'OR', 'OUTER', 'ON',
  74              'PROCEEDURE','PROCEDURAL', 'PRIMARY',
  75              'READ', 'REFERENCES', 'REGEXP', 'RENAME', 'REPLACE', 'RETURN', 'REVOKE', 'RLIKE', 'RIGHT',
  76              'SHOW', 'SONAME', 'STATUS', 'STRAIGHT_JOIN', 'SELECT', 'SETVAL', 'SET',
  77              'TABLES', 'TEMINATED', 'TO', 'TRAILING','TRUNCATE', 'TABLE', 'TEMPORARY', 'TRIGGER', 'TRUSTED',
  78              'UNIQUE', 'UNLOCK', 'USE', 'USING', 'UPDATE', 'UNSIGNED',
  79              'VALUES', 'VARIABLES', 'VIEW',
  80              'WITH', 'WRITE', 'WHERE',
  81              'ZEROFILL',
  82              'XOR',
  83              )
  84          ),
  85      'SYMBOLS' => array(
  86          '(', ')', '=', '<', '>', '|'
  87          ),
  88      'CASE_SENSITIVE' => array(
  89          GESHI_COMMENTS => false,
  90          1 => false
  91          ),
  92      'STYLES' => array(
  93          'KEYWORDS' => array(
  94              1 => 'color: #993333; font-weight: bold;'
  95              ),
  96          'COMMENTS' => array(
  97              1 => 'color: #808080; font-style: italic;',
  98              2 => 'color: #808080; font-style: italic;',
  99              'MULTI' => 'color: #808080; font-style: italic;'
 100              ),
 101          'ESCAPE_CHAR' => array(
 102              0 => 'color: #000099; font-weight: bold;'
 103              ),
 104          'BRACKETS' => array(
 105              0 => 'color: #66cc66;'
 106              ),
 107          'STRINGS' => array(
 108              0 => 'color: #ff0000;'
 109              ),
 110          'NUMBERS' => array(
 111              0 => 'color: #cc66cc;'
 112              ),
 113          'METHODS' => array(
 114              ),
 115          'SYMBOLS' => array(
 116              0 => 'color: #66cc66;'
 117              ),
 118          'SCRIPT' => array(
 119              ),
 120          'REGEXPS' => array(
 121              )
 122          ),
 123      'OOLANG' => false,
 124      'OBJECT_SPLITTERS' => array(
 125          ),
 126      'REGEXPS' => array(
 127          ),
 128      'STRICT_MODE_APPLIES' => GESHI_NEVER,
 129      'SCRIPT_DELIMITERS' => array(
 130          ),
 131      'HIGHLIGHT_STRICT_BLOCK' => array(
 132          )
 133  );
 134  
 135  ?>