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