ILIAS
release_5-3 Revision v5.3.23-19-g915713cf615
◀ ilDoc Overview
sql.php
Go to the documentation of this file.
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.0
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
);
php
An exception for terminatinating execution or to throw for unit testing.
GESHI_COMMENTS
const GESHI_COMMENTS
Used in language files to mark comments.
Definition:
geshi.php:149
GESHI_NEVER
const GESHI_NEVER
#+ @access private
Definition:
geshi.php:123
$language_data
$language_data
Definition:
sql.php:56
libs
composer
vendor
geshi
geshi
src
geshi
sql.php
Generated on Sat Oct 4 2025 19:00:54 for ILIAS by
1.9.4 (using
Doxyfile
)