1 | 1 | simandl | <?php |
2 | | | /************************************************************************************* |
3 | | | * mysql.php |
4 | | | * --------- |
5 | | | * Author: Carl F�rstenberg (azatoth@gmail.com) |
6 | | | * Copyright: (c) 2005 Carl F�rstenberg, Nigel McNie (http://qbnz.com/highlighter) |
7 | | | * Release Version: 1.0.8.1 |
8 | | | * Date Started: 2004/06/04 |
9 | | | * |
10 | | | * MySQL language file for GeSHi. |
11 | | | * |
12 | | | * |
13 | | | ************************************************************************************* |
14 | | | * |
15 | | | * This file is part of GeSHi. |
16 | | | * |
17 | | | * GeSHi is free software; you can redistribute it and/or modify |
18 | | | * it under the terms of the GNU General Public License as published by |
19 | | | * the Free Software Foundation; either version 2 of the License, or |
20 | | | * (at your option) any later version. |
21 | | | * |
22 | | | * GeSHi is distributed in the hope that it will be useful, |
23 | | | * but WITHOUT ANY WARRANTY; without even the implied warranty of |
24 | | | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
25 | | | * GNU General Public License for more details. |
26 | | | * |
27 | | | * You should have received a copy of the GNU General Public License |
28 | | | * along with GeSHi; if not, write to the Free Software |
29 | | | * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |
30 | | | * |
31 | | | ************************************************************************************/ |
32 | | | |
33 | | | $language_data = array ( |
34 | | | 'LANG_NAME' => 'MySQL', |
35 | | | 'COMMENT_SINGLE' => array(1 =>'--', 2 => '#'), |
36 | | | 'COMMENT_MULTI' => array('/*' => '*/'), |
37 | | | 'CASE_KEYWORDS' => GESHI_CAPS_UPPER, |
38 | | | 'QUOTEMARKS' => array("'", '"', '`'), |
39 | | | 'ESCAPE_CHAR' => '\\', |
40 | | | 'NUMBERS' => |
41 | | | GESHI_NUMBER_INT_BASIC | |
42 | | | GESHI_NUMBER_OCT_PREFIX | |
43 | | | GESHI_NUMBER_HEX_PREFIX | |
44 | | | GESHI_NUMBER_FLT_NONSCI | |
45 | | | GESHI_NUMBER_FLT_SCI_SHORT | |
46 | | | GESHI_NUMBER_FLT_SCI_ZERO, |
47 | | | 'KEYWORDS' => array( |
48 | | | 1 => array( |
49 | | | /* Mix */ |
50 | | | 'ACTION','ADD','ALTER','ANALYZE','ASC','BDB','BEGIN','BERKELEYDB', |
51 | | | 'BTREE','BY','CALL','CASCADE','CHECK','COLUMN','COLUMNS','COMMIT', |
52 | | | 'CONSTRAINT','CREATE','CROSS','DATA','DATABASE','DATABASES', |
53 | | | 'DECLARE','DELAYED','DELETE','DESC','DESCRIBE','DISTINCT', |
54 | | | 'DISTINCTROW','DO','DROP','ENCLOSED','END','ENGINE','ELSE','ERRORS', |
55 | | | 'ESCAPED','EXISTS','EXPLAIN','FALSE','FIELDS','FORCE','FOREIGN', |
56 | | | 'FROM','FULLTEXT','FUNCTION','GEOMETRY','GRANT','GROUP','HANDLER', |
57 | | | 'HASH','HAVING','HELP','HIGH_PRIORITY','IGNORE','INDEX','INFILE', |
58 | | | 'INNER','INNODB','INSERT','INTERVAL','INTO','JOIN','KEY','KEYS', |
59 | | | 'KILL','LIMIT','LINES','LOAD','LOCK','LOW_PRIORITY', |
60 | | | 'MASTER_SERVER_ID','MATCH','MIDDLEINT','MODIFY','MRG_MYISAM', |
61 | | | 'NATURAL','NO','ON','OPTIMIZE','OPTION','OPTIONALLY','ORDER', |
62 | | | 'OUTER','OUTFILE','PRIMARY','PRIVILEGES','PROCEDURE','PURGE','READ', |
63 | | | 'REFERENCES','RENAME','REPLACE','REQUIRE','RESTRICT','RETURNS', |
64 | | | 'REVOKE','RLIKE','ROLLBACK','ROUTINE','RTREE','SAVEPOINT','SCHEMA', |
65 | | | 'SELECT','SET','SHOW','SOME','SONAME','SPATIAL','SQL_BIG_RESULT', |
66 | | | 'SQL_CALC_FOUND_ROWS','SQL_SMALL_RESULT','SSL','START','STARTING', |
67 | | | 'STATUS','STRAIGHT_JOIN','STRIPED','TABLE','TABLES','TERMINATED', |
68 | | | 'TO','TRANSACTIONS','TRANSACTION','TRUE','TRUNCATE','TYPES','UNION', |
69 | | | 'UNLOCK_TABLES','UPDATE','USAGE','USE','USER_RESOURCES','USING', |
70 | | | 'VALUES','VARCHARACTER','WARNINGS','WHEN','WHERE','WRITE', |
71 | | | |
72 | | | /* Control Flow Functions */ |
73 | | | 'CASE','IF','THEN', |
74 | | | ), |
75 | | | 2 => array( |
76 | | | 'BIGINT','BINARY','BIT','BLOB','BOOLEAN','CHAR','CHARACTER VARYING', |
77 | | | 'DATE','DATETIME','DEC','DECIMAL','DOUBLE','ENUM','FIXED','FLOAT', |
78 | | | 'INT','INTEGER','LONGBLOB','LONGTEXT','MEDIUMBLOB','MEDIUMINT', |
79 | | | 'MEDIUMTEXT','NUMERIC','PRECISION','REAL','SERIAL DEFAULT VALUE', |
80 | | | 'SERIAL','SET','SMALLINT','TEXT','TIME','TIMESTAMP','TINYBLOB', |
81 | | | 'TINYINT','TINYTEXT','VARBINARY','VARCHAR' |
82 | | | ), |
83 | | | 3 => array( |
84 | | | 'ASCII','AUTO_INCREMENT','BOTH','CHARACTER','CHARSET','DEFAULT', |
85 | | | 'LEADING','NATIONAL','NULL','TRAILING','UNICODE','UNIQUE', |
86 | | | 'UNSIGNED','ZEROFILL' |
87 | | | ), |
88 | | | 4 => array( |
89 | | | 'DAY','DAY_HOUR','DAY_MICROSECOND','DAY_MINUTE','DAY_SECOND','HOUR', |
90 | | | 'HOUR_MICROSECOND','HOUR_MINUTE','HOUR_SECOND','MICROSECOND', |
91 | | | 'MINUTE','MINUTE_MICROSECOND','MINUTE_SECOND','MONTH','QUARTER', |
92 | | | 'SECOND','SECOND_MICROSECOND','WEEK','YEAR','YEAR_MONTH' |
93 | | | ), |
94 | | | 5 => array( |
95 | | | 'AND','BETWEEN','BINARY','COLLATE','DIV','IN','IS','LIKE', |
96 | | | 'MOD','NOT','OFFSET','OR','REGEXP','XOR' |
97 | | | ), |
98 | | | 6 => array( |
99 | | | /* String Functions */ |
100 | | | 'BIN','BIT_LENGTH','CHAR_LENGTH','CHARACTER_LENGTH','COMPRESS', |
101 | | | 'CONCAT','CONCAT_WS','CONV','ELT','EXPORT_SET','FIELD', |
102 | | | 'FIND_IN_SET','FORMAT','HEX','INSTR','LCASE','LEFT','LENGTH', |
103 | | | 'LOAD_FILE','LOCATE','LOWER','LPAD','LTRIM','MAKE_SET','MD5','MID', |
104 | | | 'OCT','OCTET_LENGTH','ORD','POSITION','QUOTE','REPEAT','REVERSE', |
105 | | | 'RIGHT','RPAD','RTRIM','SHA1','SOUNDEX','SPACE','SUBSTRING', |
106 | | | 'SUBSTRING_INDEX','TRIM','UCASE','UNCOMPRESS','UNCOMPRESSD_LENGTH', |
107 | | | 'UNHEX','UPPER', |
108 | | | ), |
109 | | | 7 => array( |
110 | | | /* Numeric Functions */ |
111 | | | 'ABS','ACOS','ASIN','ATAN','ATAN2','AVG','CEILING','CEIL','COS', |
112 | | | 'COT','CRC32','DEGREES','EXP','FLOOR','LN','LOG','LOG2','LOG10', |
113 | | | 'MIN','MAX','PI','POW','POWER','RADIANS','RAND','ROUND','SIGN', |
114 | | | 'SIN','SQRT','SUM','TAN', |
115 | | | ), |
116 | | | 8 => array( |
117 | | | /* Date and Time Functions */ |
118 | | | 'ADDDATE','ADDTIME','CONVERT_TZ','CURDATE','CURRENT_DATE', |
119 | | | 'CURRENT_TIME','CURRENT_TIMESTAMP','CURTIME','DATE_ADD', |
120 | | | 'DATE_FORMAT','DATE_SUB','DATEDIFF','DAY','DAYNAME','DAYOFMONTH', |
121 | | | 'DAYOFWEEK','DAYOFYEAR','EXTRACT','FROM_DAYS','FROM_UNIXTIME', |
122 | | | 'GET_FORMAT','LAST_DAY','LOCALTIME','LOCALTIMESTAMP','MAKEDATE', |
123 | | | 'MAKETIME','MICROSECOND','MONTHNAME','NOW','PERIOD_ADD', |
124 | | | 'PERIOD_DIFF','QUARTER','SEC_TO_TIME','SECOND','STR_TO_DATE', |
125 | | | 'SUBDATE','SUBTIME','SYSDATE','TIME','TIME_FORMAT','TIME_TO_SEC', |
126 | | | 'TIMEDIFF','TIMESTAMP','TIMESTAMPADD','TIMESTAMPDIFF','TO_DAYS', |
127 | | | 'UNIX_TIMESTAMP','UTC_DATE','UTC_TIME','UTC_TIMESTAMP','WEEKDAY', |
128 | | | 'WEEKOFYEAR','YEARWEEK', |
129 | | | ), |
130 | | | ), |
131 | | | 'SYMBOLS' => array( |
132 | | | ':=', |
133 | | | '||', |
134 | | | '&&', |
135 | | | '=', '<=>', '>=', '>', '<=', '<', '<>', '!=', |
136 | | | '|', |
137 | | | '&', |
138 | | | '<<', '>>', |
139 | | | '-', '+', |
140 | | | '*', '/', '%', |
141 | | | '^', |
142 | | | '~', |
143 | | | '!', |
144 | | | '(', ')', |
145 | | | ',', ';' |
146 | | | ), |
147 | | | 'CASE_SENSITIVE' => array( |
148 | | | GESHI_COMMENTS => false, |
149 | | | 1 => false, |
150 | | | 2 => false, |
151 | | | 3 => false, |
152 | | | 4 => false, |
153 | | | 5 => false, |
154 | | | 6 => false, |
155 | | | 7 => false, |
156 | | | 8 => false |
157 | | | ), |
158 | | | 'STYLES' => array( |
159 | | | 'KEYWORDS' => array( |
160 | | | 1 => 'color: #990099; font-weight: bold;', |
161 | | | 2 => 'color: #FF9900; font-weight: bold;', |
162 | | | 3 => 'color: #9900FF; font-weight: bold;', |
163 | | | 4 => 'color: #990099; font-weight: bold;', |
164 | | | 5 => 'color: #CC0099; font-weight: bold;', |
165 | | | 6 => 'color: #000099; font-weight: bold;', |
166 | | | 7 => 'color: #000099; font-weight: bold;', |
167 | | | 8 => 'color: #000099; font-weight: bold;' |
168 | | | ), |
169 | | | 'COMMENTS' => array( |
170 | | | 'MULTI' => 'color: #808000; font-style: italic;', |
171 | | | 1 => 'color: #808000; font-style: italic;', |
172 | | | 2 => 'color: #808000; font-style: italic;' |
173 | | | ), |
174 | | | 'ESCAPE_CHAR' => array( |
175 | | | |
176 | | | ), |
177 | | | 'BRACKETS' => array( |
178 | | | |
179 | | | ), |
180 | | | 'STRINGS' => array( |
181 | | | |
182 | | | ), |
183 | | | 'NUMBERS' => array( |
184 | | | |
185 | | | ), |
186 | | | 'METHODS' => array( |
187 | | | ), |
188 | | | 'SYMBOLS' => array( |
189 | | | |
190 | | | ), |
191 | | | 'SCRIPT' => array( |
192 | | | ), |
193 | | | 'REGEXPS' => array( |
194 | | | ) |
195 | | | ), |
196 | | | 'URLS' => array( |
197 | | | 1 => '', |
198 | | | 2 => '', |
199 | | | 3 => '', |
200 | | | 4 => '', |
201 | | | 5 => '', |
202 | | | 6 => '', |
203 | | | 7 => '', |
204 | | | 8 => '' |
205 | | | ), |
206 | | | 'OOLANG' => false, |
207 | | | 'OBJECT_SPLITTERS' => array( |
208 | | | ), |
209 | | | 'REGEXPS' => array( |
210 | | | ), |
211 | | | 'STRICT_MODE_APPLIES' => GESHI_NEVER, |
212 | | | 'SCRIPT_DELIMITERS' => array( |
213 | | | ), |
214 | | | 'HIGHLIGHT_STRICT_BLOCK' => array( |
215 | | | ) |
216 | | | ); |
217 | | | |
218 | | | ?> |