openrat-cms

Unnamed repository; edit this file 'description' to name the repository.
Log | Files | Refs | README

sql.php (4257B)

      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 ?>