1 | <?php
|
---|
2 | /*************************************************************************************
|
---|
3 | * sql.php
|
---|
4 | * -------
|
---|
5 | * Author: Nigel McNie ([email protected])
|
---|
6 | * Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter)
|
---|
7 | * Release Version: 1.0.8.8
|
---|
8 | * Date Started: 2004/06/04
|
---|
9 | *
|
---|
10 | * SQL language file for GeSHi.
|
---|
11 | *
|
---|
12 | * CHANGES
|
---|
13 | * -------
|
---|
14 | * 2008/05/23 (1.0.7.22)
|
---|
15 | * - Added additional symbols for highlighting
|
---|
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 (
|
---|
53 | 'LANG_NAME' => 'SQL',
|
---|
54 | 'COMMENT_SINGLE' => array(1 =>'--'),
|
---|
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;',
|
---|
101 | 'MULTI' => 'color: #808080; font-style: italic;'
|
---|
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 | )
|
---|
138 | );
|
---|
139 |
|
---|
140 | ?> |
---|