2 /*************************************************************************************
5 * Author: Nigel McNie (nigel@geshi.org)
6 * Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter)
7 * Release Version: 1.0.8.3
8 * Date Started: 2004/06/04
10 * SQL language file for GeSHi.
14 * 2008/05/23 (1.0.7.22)
15 * - Added additional symbols for highlighting
17 * - Added support for multiple object splitters
19 * - Added "`" string delimiter
20 * - Added "#" single comment starter
22 * - Added support for symbols
23 * - Added many more keywords (mostly MYSQL keywords)
27 * TODO (updated 2004/11/27)
28 * -------------------------
30 * * Split this to several sql files - mysql-sql, ansi-sql etc
32 *************************************************************************************
34 * This file is part of GeSHi.
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.
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.
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
50 ************************************************************************************/
52 $language_data = array (
54 'COMMENT_SINGLE' => array(1 =>'--', 2 => '#'),
55 'COMMENT_MULTI' => array('/*' => '*/'),
57 'QUOTEMARKS' => array("'", '"', '`'),
58 'ESCAPE_CHAR' => '\\',
61 'ADD', 'ALL', 'ALTER', 'AND', 'AS', 'ASC',
62 'AUTO_INCREMENT', 'BETWEEN', 'BINARY', 'BOOLEAN',
63 'BOTH', 'BY', 'CHANGE', 'CHECK', 'COLUMN', 'COLUMNS',
64 'CREATE', 'CROSS', 'DATA', 'DATABASE', 'DATABASES',
65 'DEFAULT', 'DELAYED', 'DELETE', 'DESC', 'DESCRIBE',
66 'DISTINCT', 'DROP', 'ENCLOSED', 'ESCAPED', 'EXISTS',
67 'EXPLAIN', 'FIELD', 'FIELDS', 'FLUSH', 'FOR',
68 'FOREIGN', 'FROM', 'FULL', 'FUNCTION', 'GRANT',
69 'GROUP', 'HAVING', 'IDENTIFIED', 'IF', 'IGNORE',
70 'IN', 'INDEX', 'INFILE', 'INNER', 'INSERT', 'INTO',
71 'IS', 'JOIN', 'KEY', 'KEYS', 'KILL', 'LANGUAGE',
72 'LEADING', 'LEFT', 'LIKE', 'LIMIT', 'LINES', 'LOAD',
73 'LOCAL', 'LOCK', 'LOW_PRIORITY', 'MODIFY', 'NATURAL',
74 'NEXTVAL', 'NOT', 'NULL', 'ON', 'OPTIMIZE', 'OPTION',
75 'OPTIONALLY', 'OR', 'ORDER', 'OUTER', 'OUTFILE',
76 'PRIMARY', 'PROCEDURAL', 'PROCEEDURE', 'READ',
77 'REFERENCES', 'REGEXP', 'RENAME', 'REPLACE',
78 'RETURN', 'REVOKE', 'RIGHT', 'RLIKE', 'SELECT',
79 'SET', 'SETVAL', 'SHOW', 'SONAME', 'STATUS',
80 'STRAIGHT_JOIN', 'TABLE', 'TABLES', 'TEMINATED',
81 'TEMPORARY', 'TO', 'TRAILING', 'TRIGGER', 'TRUNCATE',
82 'TRUSTED', 'UNION', 'UNIQUE', 'UNLOCK', 'UNSIGNED',
83 'UPDATE', 'USE', 'USING', 'VALUES', 'VARIABLES',
84 'VIEW', 'WHERE', 'WITH', 'WRITE', 'XOR', 'ZEROFILL'
88 '(', ')', '=', '<', '>', '|', ',', '.', '+', '-', '*', '/'
90 'CASE_SENSITIVE' => array(
91 GESHI_COMMENTS => false,
96 1 => 'color: #993333; font-weight: bold;'
99 1 => 'color: #808080; font-style: italic;',
100 2 => 'color: #808080; font-style: italic;',
101 'MULTI' => 'color: #808080; font-style: italic;'
103 'ESCAPE_CHAR' => array(
104 0 => 'color: #000099; font-weight: bold;'
107 0 => 'color: #66cc66;'
110 0 => 'color: #ff0000;'
113 0 => 'color: #cc66cc;'
118 0 => 'color: #66cc66;'
129 'OBJECT_SPLITTERS' => array(
133 'STRICT_MODE_APPLIES' => GESHI_NEVER,
134 'SCRIPT_DELIMITERS' => array(
136 'HIGHLIGHT_STRICT_BLOCK' => array(