1<?php
2/*************************************************************************************
3 * sql.php
4 * -------
5 * Author: Nigel McNie (nigel@geshi.org)
6 * Contributors:
7 *  - Jürgen Thomas (Juergen.Thomas@vs-polis.de)
8 * Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter)
9 * Release Version: 1.0.9.1
10 * Date Started: 2004/06/04
11 *
12 * SQL language file for GeSHi.
13 *
14 * CHANGES
15 * -------
16 * 2010/07/19 (1.0.8.9)
17 *  -  Added many more keywords
18 * 2008/05/23 (1.0.7.22)
19 *  -  Added additional symbols for highlighting
20 * 2004/11/27 (1.0.3)
21 *  -  Added support for multiple object splitters
22 * 2004/10/27 (1.0.2)
23 *  -  Added "`" string delimiter
24 *  -  Added "#" single comment starter
25 * 2004/08/05 (1.0.1)
26 *  -  Added support for symbols
27 *  -  Added many more keywords (mostly MYSQL keywords)
28 * 2004/07/14 (1.0.0)
29 *  -  First Release
30 *
31 * TODO (updated 2004/11/27)
32 * -------------------------
33 * * Add all keywords
34 * * Split this to several sql files - mysql-sql, ansi-sql etc
35 *
36 *************************************************************************************
37 *
38 *     This file is part of GeSHi.
39 *
40 *   GeSHi is free software; you can redistribute it and/or modify
41 *   it under the terms of the GNU General Public License as published by
42 *   the Free Software Foundation; either version 2 of the License, or
43 *   (at your option) any later version.
44 *
45 *   GeSHi is distributed in the hope that it will be useful,
46 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
47 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
48 *   GNU General Public License for more details.
49 *
50 *   You should have received a copy of the GNU General Public License
51 *   along with GeSHi; if not, write to the Free Software
52 *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
53 *
54 ************************************************************************************/
55
56$language_data = array (
57    'LANG_NAME' => 'SQL',
58    'COMMENT_SINGLE' => array(1 =>'--'),
59    'COMMENT_MULTI' => array('/*' => '*/'),
60    'CASE_KEYWORDS' => 1,
61    'QUOTEMARKS' => array("'", '"', '`'),
62    'ESCAPE_CHAR' => '\\',
63    'KEYWORDS' => array(
64        1 => array(
65            'ADD', 'ALL', 'ALTER', 'AND', 'AS', 'ASC', 'AUTO_INCREMENT',
66            'BEFORE', 'BEGIN', 'BETWEEN', 'BIGINT', 'BINARY', 'BLOB', 'BOOLEAN', 'BOTH', 'BY',
67            'CALL', 'CASE', 'CAST', 'CEIL', 'CEILING', 'CHANGE', 'CHAR', 'CHAR_LENGTH', 'CHARACTER',
68            'CHARACTER_LENGTH', 'CHECK', 'CLOB', 'COALESCE', 'COLLATE', 'COLUMN', 'COLUMNS',
69            'CONNECT', 'CONSTRAINT', 'CONVERT', 'COUNT', 'CREATE', 'CROSS', 'CURRENT',
70            'CURRENT_DATE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'CURRENT_USER',
71            'DATA', 'DATABASE', 'DATABASES', 'DATE', 'DAY', 'DEC', 'DECIMAL', 'DECLARE',
72            'DEFAULT', 'DEFERRABLE', 'DEFERRED', 'DELAYED', 'DELETE', 'DESC', 'DESCRIBE', 'DISTINCT', 'DOUBLE',
73            'DOMAIN', 'DROP',
74            'ELSE', 'ELSEIF', 'ENCLOSED', 'END', 'ESCAPED', 'EXCEPT', 'EXEC', 'EXECUTE', 'EXISTS',
75            'EXP', 'EXPLAIN', 'EXTRACT',
76            'FALSE', 'FIELD', 'FIELDS', 'FILTER', 'FIRST', 'FLOAT', 'FLOOR', 'FLUSH', 'FOR',
77            'FOREIGN', 'FROM', 'FULL', 'FUNCTION',
78            'GET', 'GROUP', 'GROUPING', 'GO', 'GOTO', 'GRANT', 'GRANTED',
79            'HAVING', 'HOUR',
80            'IDENTIFIED', 'IDENTITY', 'IF', 'IGNORE', 'IMMEDIATE', 'IN', 'INCREMENT', 'INDEX', 'INFILE', 'INITIALLY', 'INNER',
81            'INOUT', 'INPUT', 'INSERT', 'INT', 'INTEGER', 'INTERSECT', 'INTERSECTION', 'INTERVAL',
82            'INTO', 'IS',
83            'JOIN',
84            'KEY', 'KEYS', 'KILL',
85            'LANGUAGE', 'LARGE', 'LAST', 'LEADING', 'LEFT', 'LENGTH', 'LIKE', 'LIMIT', 'LINES', 'LOAD',
86            'LOCAL', 'LOCK', 'LOW_PRIORITY', 'LOWER',
87            'MATCH', 'MAX', 'MERGE', 'MIN', 'MINUTE', 'MOD', 'MODIFIES', 'MODIFY', 'MONTH',
88            'NATIONAL', 'NATURAL', 'NCHAR', 'NEW', 'NEXT', 'NEXTVAL', 'NONE', 'NOT',
89            'NULL', 'NULLABLE', 'NULLIF', 'NULLS', 'NUMBER', 'NUMERIC',
90            'OF', 'OLD', 'ON', 'ONLY', 'OPEN', 'OPTIMIZE', 'OPTION',
91            'OPTIONALLY', 'OR', 'ORDER', 'OUT', 'OUTER', 'OUTFILE', 'OVER',
92            'POSITION', 'POWER', 'PRECISION', 'PREPARE', 'PRIMARY', 'PROCEDURAL', 'PROCEDURE',
93            'READ', 'REAL', 'REF', 'REFERENCES', 'REFERENCING', 'REGEXP', 'RENAME', 'REPLACE',
94            'RESULT', 'RETURN', 'RETURNS', 'REVOKE', 'RIGHT', 'RLIKE', 'ROLLBACK', 'ROW',
95            'ROW_NUMBER', 'ROWS', 'RESTRICT', 'ROLE', 'ROUTINE', 'ROW_COUNT',
96            'SAVEPOINT', 'SEARCH', 'SECOND', 'SECTION', 'SELECT', 'SELF', 'SEQUENCE',
97            'SESSION', 'SET', 'SETVAL', 'SHOW', 'SIMILAR', 'SIZE', 'SMALLINT', 'SOME',
98            'SONAME', 'SOURCE', 'SPACE', 'SQL', 'SQRT', 'START', 'STATUS',
99            'STRAIGHT_JOIN', 'STRUCTURE', 'STYLE', 'SUBSTRING', 'SUM',
100            'TABLE', 'TABLE_NAME', 'TABLES', 'TERMINATED', 'TEMPORARY', 'THEN', 'TIME',
101            'TIMESTAMP', 'TO', 'TRAILING', 'TRANSACTION', 'TRIGGER', 'TRIM', 'TRUE', 'TRUNCATE',
102            'TRUSTED', 'TYPE',
103            'UNDER', 'UNION', 'UNIQUE', 'UNKNOWN', 'UNLOCK', 'UNSIGNED',
104            'UPDATE', 'UPPER', 'USE', 'USER', 'USING',
105            'VALUE', 'VALUES', 'VARCHAR', 'VARIABLES', 'VARYING', 'VIEW',
106            'WHEN', 'WHERE', 'WITH', 'WITHIN', 'WITHOUT', 'WORK', 'WRITE',
107            'XOR',
108            'YEAR',
109            'ZEROFILL'
110            )
111        ),
112    'SYMBOLS' => array(
113        '(', ')', '=', '<', '>', '|', ',', '.', '+', '-', '*', '/'
114        ),
115    'CASE_SENSITIVE' => array(
116        GESHI_COMMENTS => false,
117        1 => false
118        ),
119    'STYLES' => array(
120        'KEYWORDS' => array(
121            1 => 'color: #993333; font-weight: bold;'
122            ),
123        'COMMENTS' => array(
124            1 => 'color: #808080; font-style: italic;',
125            //2 => 'color: #808080; font-style: italic;',
126            'MULTI' => 'color: #808080; font-style: italic;'
127            ),
128        'ESCAPE_CHAR' => array(
129            0 => 'color: #000099; font-weight: bold;'
130            ),
131        'BRACKETS' => array(
132            0 => 'color: #66cc66;'
133            ),
134        'STRINGS' => array(
135            0 => 'color: #ff0000;'
136            ),
137        'NUMBERS' => array(
138            0 => 'color: #cc66cc;'
139            ),
140        'METHODS' => array(
141            ),
142        'SYMBOLS' => array(
143            0 => 'color: #66cc66;'
144            ),
145        'SCRIPT' => array(
146            ),
147        'REGEXPS' => array(
148            )
149        ),
150    'URLS' => array(
151        1 => ''
152        ),
153    'OOLANG' => false,
154    'OBJECT_SPLITTERS' => array(
155        ),
156    'REGEXPS' => array(
157        ),
158    'STRICT_MODE_APPLIES' => GESHI_NEVER,
159    'SCRIPT_DELIMITERS' => array(
160        ),
161    'HIGHLIGHT_STRICT_BLOCK' => array(
162        ),
163    'PARSER_CONTROL' => array(
164        'KEYWORDS' => array( //'
165            'DISALLOWED_BEFORE' => "(?<![a-zA-Z0-9\$_\.\|\#|^&])"
166            )
167        )
168);
169