136 lines
4.2 KiB
PHP
136 lines
4.2 KiB
PHP
|
<?php
|
||
|
|
/*************************************************************************************
|
||
|
|
* sql.php
|
||
|
|
* -------
|
||
|
|
* Author: Nigel McNie (nigel@geshi.org)
|
||
|
|
* Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter)
|
||
|
|
* Release Version: 1.0.7.21
|
||
|
|
* Date Started: 2004/06/04
|
||
|
|
*
|
||
|
|
* SQL language file for GeSHi.
|
||
|
|
*
|
||
|
|
* CHANGES
|
||
|
|
* -------
|
||
|
|
* 2004/11/27 (1.0.3)
|
||
|
|
* - Added support for multiple object splitters
|
||
|
|
* 2004/10/27 (1.0.2)
|
||
|
|
* - Added "`" string delimiter
|
||
|
|
* - Added "#" single comment starter
|
||
|
|
* 2004/08/05 (1.0.1)
|
||
|
|
* - Added support for symbols
|
||
|
|
* - Added many more keywords (mostly MYSQL keywords)
|
||
|
|
* 2004/07/14 (1.0.0)
|
||
|
|
* - First Release
|
||
|
|
*
|
||
|
|
* TODO (updated 2004/11/27)
|
||
|
|
* -------------------------
|
||
|
|
* * Add all keywords
|
||
|
|
* * Split this to several sql files - mysql-sql, ansi-sql etc
|
||
|
|
*
|
||
|
|
*************************************************************************************
|
||
|
|
*
|
||
|
|
* This file is part of GeSHi.
|
||
|
|
*
|
||
|
|
* GeSHi is free software; you can redistribute it and/or modify
|
||
|
|
* it under the terms of the GNU General Public License as published by
|
||
|
|
* the Free Software Foundation; either version 2 of the License, or
|
||
|
|
* (at your option) any later version.
|
||
|
|
*
|
||
|
|
* GeSHi is distributed in the hope that it will be useful,
|
||
|
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
||
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
||
|
|
* GNU General Public License for more details.
|
||
|
|
*
|
||
|
|
* You should have received a copy of the GNU General Public License
|
||
|
|
* along with GeSHi; if not, write to the Free Software
|
||
|
|
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
|
||
|
|
*
|
||
|
|
************************************************************************************/
|
||
|
|
|
||
|
|
$language_data = array (
|
||
|
|
'LANG_NAME' => 'SQL',
|
||
|
|
'COMMENT_SINGLE' => array(1 =>'--', 2 => '#'),
|
||
|
|
'COMMENT_MULTI' => array('/*' => '*/'),
|
||
|
|
'CASE_KEYWORDS' => 1,
|
||
|
|
'QUOTEMARKS' => array("'", '"', '`'),
|
||
|
|
'ESCAPE_CHAR' => '\\',
|
||
|
|
'KEYWORDS' => array(
|
||
|
|
1 => array(
|
||
|
|
'ALL', 'ASC', 'AS', 'ALTER', 'AND', 'ADD', 'AUTO_INCREMENT',
|
||
|
|
'BETWEEN', 'BINARY', 'BOTH', 'BY', 'BOOLEAN',
|
||
|
|
'CHANGE', 'CHECK', 'COLUMNS', 'COLUMN', 'CROSS','CREATE',
|
||
|
|
'DATABASES', 'DATABASE', 'DATA', 'DELAYED', 'DESCRIBE', 'DESC', 'DISTINCT', 'DELETE', 'DROP', 'DEFAULT',
|
||
|
|
'ENCLOSED', 'ESCAPED', 'EXISTS', 'EXPLAIN',
|
||
|
|
'FIELDS', 'FIELD', 'FLUSH', 'FOR', 'FOREIGN', 'FUNCTION', 'FROM',
|
||
|
|
'GROUP', 'GRANT',
|
||
|
|
'HAVING',
|
||
|
|
'IGNORE', 'INDEX', 'INFILE', 'INSERT', 'INNER', 'INTO', 'IDENTIFIED', 'IN', 'IS', 'IF',
|
||
|
|
'JOIN',
|
||
|
|
'KEYS', 'KILL','KEY',
|
||
|
|
'LEADING', 'LIKE', 'LIMIT', 'LINES', 'LOAD', 'LOCAL', 'LOCK', 'LOW_PRIORITY', 'LEFT', 'LANGUAGE',
|
||
|
|
'MODIFY',
|
||
|
|
'NATURAL', 'NOT', 'NULL', 'NEXTVAL',
|
||
|
|
'OPTIMIZE', 'OPTION', 'OPTIONALLY', 'ORDER', 'OUTFILE', 'OR', 'OUTER', 'ON',
|
||
|
|
'PROCEEDURE','PROCEDURAL', 'PRIMARY',
|
||
|
|
'READ', 'REFERENCES', 'REGEXP', 'RENAME', 'REPLACE', 'RETURN', 'REVOKE', 'RLIKE', 'RIGHT',
|
||
|
|
'SHOW', 'SONAME', 'STATUS', 'STRAIGHT_JOIN', 'SELECT', 'SETVAL', 'SET',
|
||
|
|
'TABLES', 'TEMINATED', 'TO', 'TRAILING','TRUNCATE', 'TABLE', 'TEMPORARY', 'TRIGGER', 'TRUSTED',
|
||
|
|
'UNIQUE', 'UNLOCK', 'USE', 'USING', 'UPDATE', 'UNSIGNED',
|
||
|
|
'VALUES', 'VARIABLES', 'VIEW',
|
||
|
|
'WITH', 'WRITE', 'WHERE',
|
||
|
|
'ZEROFILL',
|
||
|
|
'XOR',
|
||
|
|
)
|
||
|
|
),
|
||
|
|
'SYMBOLS' => array(
|
||
|
|
'(', ')', '=', '<', '>', '|'
|
||
|
|
),
|
||
|
|
'CASE_SENSITIVE' => array(
|
||
|
|
GESHI_COMMENTS => false,
|
||
|
|
1 => false
|
||
|
|
),
|
||
|
|
'STYLES' => array(
|
||
|
|
'KEYWORDS' => array(
|
||
|
|
1 => 'color: #993333; font-weight: bold;'
|
||
|
|
),
|
||
|
|
'COMMENTS' => array(
|
||
|
|
1 => 'color: #808080; font-style: italic;',
|
||
|
|
2 => 'color: #808080; font-style: italic;',
|
||
|
|
'MULTI' => 'color: #808080; font-style: italic;'
|
||
|
|
),
|
||
|
|
'ESCAPE_CHAR' => array(
|
||
|
|
0 => 'color: #000099; font-weight: bold;'
|
||
|
|
),
|
||
|
|
'BRACKETS' => array(
|
||
|
|
0 => 'color: #66cc66;'
|
||
|
|
),
|
||
|
|
'STRINGS' => array(
|
||
|
|
0 => 'color: #ff0000;'
|
||
|
|
),
|
||
|
|
'NUMBERS' => array(
|
||
|
|
0 => 'color: #cc66cc;'
|
||
|
|
),
|
||
|
|
'METHODS' => array(
|
||
|
|
),
|
||
|
|
'SYMBOLS' => array(
|
||
|
|
0 => 'color: #66cc66;'
|
||
|
|
),
|
||
|
|
'SCRIPT' => array(
|
||
|
|
),
|
||
|
|
'REGEXPS' => array(
|
||
|
|
)
|
||
|
|
),
|
||
|
|
'OOLANG' => false,
|
||
|
|
'OBJECT_SPLITTERS' => array(
|
||
|
|
),
|
||
|
|
'REGEXPS' => array(
|
||
|
|
),
|
||
|
|
'STRICT_MODE_APPLIES' => GESHI_NEVER,
|
||
|
|
'SCRIPT_DELIMITERS' => array(
|
||
|
|
),
|
||
|
|
'HIGHLIGHT_STRICT_BLOCK' => array(
|
||
|
|
)
|
||
|
|
);
|
||
|
|
|
||
|
|
?>
|