includes/geshi/geshi/sql.php

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