|
0
|
1 |
<?php
|
|
|
2 |
/*************************************************************************************
|
|
|
3 |
* sql.php
|
|
|
4 |
* -------
|
|
|
5 |
* Author: Nigel McNie (nigel@geshi.org)
|
|
|
6 |
* Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter)
|
|
3
|
7 |
* Release Version: 1.0.8.4
|
|
0
|
8 |
* Date Started: 2004/06/04
|
|
|
9 |
*
|
|
|
10 |
* SQL language file for GeSHi.
|
|
|
11 |
*
|
|
|
12 |
* CHANGES
|
|
|
13 |
* -------
|
|
2
|
14 |
* 2008/05/23 (1.0.7.22)
|
|
|
15 |
* - Added additional symbols for highlighting
|
|
0
|
16 |
* 2004/11/27 (1.0.3)
|
|
|
17 |
* - Added support for multiple object splitters
|
|
|
18 |
* 2004/10/27 (1.0.2)
|
|
|
19 |
* - Added "`" string delimiter
|
|
|
20 |
* - Added "#" single comment starter
|
|
|
21 |
* 2004/08/05 (1.0.1)
|
|
|
22 |
* - Added support for symbols
|
|
|
23 |
* - Added many more keywords (mostly MYSQL keywords)
|
|
|
24 |
* 2004/07/14 (1.0.0)
|
|
|
25 |
* - First Release
|
|
|
26 |
*
|
|
|
27 |
* TODO (updated 2004/11/27)
|
|
|
28 |
* -------------------------
|
|
|
29 |
* * Add all keywords
|
|
|
30 |
* * Split this to several sql files - mysql-sql, ansi-sql etc
|
|
|
31 |
*
|
|
|
32 |
*************************************************************************************
|
|
|
33 |
*
|
|
|
34 |
* This file is part of GeSHi.
|
|
|
35 |
*
|
|
|
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.
|
|
|
40 |
*
|
|
|
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.
|
|
|
45 |
*
|
|
|
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
|
|
|
49 |
*
|
|
|
50 |
************************************************************************************/
|
|
|
51 |
|
|
|
52 |
$language_data = array (
|
|
2
|
53 |
'LANG_NAME' => 'SQL',
|
|
|
54 |
'COMMENT_SINGLE' => array(1 =>'--', 2 => '#'),
|
|
|
55 |
'COMMENT_MULTI' => array('/*' => '*/'),
|
|
|
56 |
'CASE_KEYWORDS' => 1,
|
|
|
57 |
'QUOTEMARKS' => array("'", '"', '`'),
|
|
|
58 |
'ESCAPE_CHAR' => '\\',
|
|
|
59 |
'KEYWORDS' => array(
|
|
|
60 |
1 => array(
|
|
|
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'
|
|
|
85 |
)
|
|
|
86 |
),
|
|
|
87 |
'SYMBOLS' => array(
|
|
|
88 |
'(', ')', '=', '<', '>', '|', ',', '.', '+', '-', '*', '/'
|
|
|
89 |
),
|
|
|
90 |
'CASE_SENSITIVE' => array(
|
|
|
91 |
GESHI_COMMENTS => false,
|
|
|
92 |
1 => false
|
|
|
93 |
),
|
|
|
94 |
'STYLES' => array(
|
|
|
95 |
'KEYWORDS' => array(
|
|
|
96 |
1 => 'color: #993333; font-weight: bold;'
|
|
|
97 |
),
|
|
|
98 |
'COMMENTS' => array(
|
|
|
99 |
1 => 'color: #808080; font-style: italic;',
|
|
|
100 |
2 => 'color: #808080; font-style: italic;',
|
|
0
|
101 |
'MULTI' => 'color: #808080; font-style: italic;'
|
|
2
|
102 |
),
|
|
|
103 |
'ESCAPE_CHAR' => array(
|
|
|
104 |
0 => 'color: #000099; font-weight: bold;'
|
|
|
105 |
),
|
|
|
106 |
'BRACKETS' => array(
|
|
|
107 |
0 => 'color: #66cc66;'
|
|
|
108 |
),
|
|
|
109 |
'STRINGS' => array(
|
|
|
110 |
0 => 'color: #ff0000;'
|
|
|
111 |
),
|
|
|
112 |
'NUMBERS' => array(
|
|
|
113 |
0 => 'color: #cc66cc;'
|
|
|
114 |
),
|
|
|
115 |
'METHODS' => array(
|
|
|
116 |
),
|
|
|
117 |
'SYMBOLS' => array(
|
|
|
118 |
0 => 'color: #66cc66;'
|
|
|
119 |
),
|
|
|
120 |
'SCRIPT' => array(
|
|
|
121 |
),
|
|
|
122 |
'REGEXPS' => array(
|
|
|
123 |
)
|
|
|
124 |
),
|
|
|
125 |
'URLS' => array(
|
|
|
126 |
1 => ''
|
|
|
127 |
),
|
|
|
128 |
'OOLANG' => false,
|
|
|
129 |
'OBJECT_SPLITTERS' => array(
|
|
|
130 |
),
|
|
|
131 |
'REGEXPS' => array(
|
|
|
132 |
),
|
|
|
133 |
'STRICT_MODE_APPLIES' => GESHI_NEVER,
|
|
|
134 |
'SCRIPT_DELIMITERS' => array(
|
|
|
135 |
),
|
|
|
136 |
'HIGHLIGHT_STRICT_BLOCK' => array(
|
|
|
137 |
)
|
|
0
|
138 |
);
|
|
|
139 |
|
|
|
140 |
?>
|