/************************************************************************************* * sql.php * ------- * Author: Nigel McNie (nigel@geshi.org) * Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter) * Release Version: 1.0.7.16 * CVS Revision Version: $Revision: 1.15.2.6 $ * Date Started: 2004/06/04 * Last Modified: $Date: 2006/10/29 11:08:58 $ * * SQL language file for GeSHi. * * CHANGES * ------- * 2004/11/27 (1.0.3) * - Added support for multiple object splitters * 2004/10/27 (1.0.2) * - Added "`" string delimiter * - Added "#" single comment starter * 2004/08/05 (1.0.1) * - Added support for symbols * - Added many more keywords (mostly MYSQL keywords) * 2004/07/14 (1.0.0) * - First Release * * TODO (updated 2004/11/27) * ------------------------- * * Add all keywords * * Split this to several sql files - mysql-sql, ansi-sql etc * ************************************************************************************* * * This file is part of GeSHi. * * GeSHi is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * * GeSHi is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with GeSHi; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * ************************************************************************************/ $language_data = array ( 'LANG_NAME' => 'SQL', 'COMMENT_SINGLE' => array(1 =>'--', 2 => '#'), 'COMMENT_MULTI' => array('/*' => '*/'), 'CASE_KEYWORDS' => 1, 'QUOTEMARKS' => array("'", '"', '`'), 'ESCAPE_CHAR' => '\\', 'KEYWORDS' => array( 1 => array( 'ALL', 'ASC', 'AS', 'ALTER', 'AND', 'ADD', 'AUTO_INCREMENT', 'BETWEEN', 'BINARY', 'BOTH', 'BY', 'BOOLEAN', 'CHANGE', 'CHECK', 'COLUMNS', 'COLUMN', 'CROSS','CREATE', 'DATABASES', 'DATABASE', 'DATA', 'DELAYED', 'DESCRIBE', 'DESC', 'DISTINCT', 'DELETE', 'DROP', 'DEFAULT', 'ENCLOSED', 'ESCAPED', 'EXISTS', 'EXPLAIN', 'FIELDS', 'FIELD', 'FLUSH', 'FOR', 'FOREIGN', 'FUNCTION', 'FROM', 'GROUP', 'GRANT', 'HAVING', 'IGNORE', 'INDEX', 'INFILE', 'INSERT', 'INNER', 'INTO', 'IDENTIFIED', 'IN', 'IS', 'IF', 'JOIN', 'KEYS', 'KILL','KEY', 'LEADING', 'LIKE', 'LIMIT', 'LINES', 'LOAD', 'LOCAL', 'LOCK', 'LOW_PRIORITY', 'LEFT', 'LANGUAGE', 'MODIFY', 'NATURAL', 'NOT', 'NULL', 'NEXTVAL', 'OPTIMIZE', 'OPTION', 'OPTIONALLY', 'ORDER', 'OUTFILE', 'OR', 'OUTER', 'ON', 'PROCEEDURE','PROCEDURAL', 'PRIMARY', 'READ', 'REFERENCES', 'REGEXP', 'RENAME', 'REPLACE', 'RETURN', 'REVOKE', 'RLIKE', 'RIGHT', 'SHOW', 'SONAME', 'STATUS', 'STRAIGHT_JOIN', 'SELECT', 'SETVAL', 'SET', 'TABLES', 'TEMINATED', 'TO', 'TRAILING','TRUNCATE', 'TABLE', 'TEMPORARY', 'TRIGGER', 'TRUSTED', 'UNIQUE', 'UNLOCK', 'USE', 'USING', 'UPDATE', 'UNSIGNED', 'VALUES', 'VARIABLES', 'VIEW', 'WITH', 'WRITE', 'WHERE', 'ZEROFILL', 'XOR', ) ), 'SYMBOLS' => array( '(', ')', '=', '', '|' ), 'CASE_SENSITIVE' => array( GESHI_COMMENTS => false, 1 => false ), 'STYLES' => array( 'KEYWORDS' => array( 1 => 'color: #993333; font-weight: bold;' ), 'COMMENTS' => array( 1 => 'color: #808080; font-style: italic;', 2 => 'color: #808080; font-style: italic;', 'MULTI' => 'color: #808080; font-style: italic;' ), 'ESCAPE_CHAR' => array( 0 => 'color: #000099; font-weight: bold;' ), 'BRACKETS' => array( 0 => 'color: #66cc66;' ), 'STRINGS' => array( 0 => 'color: #ff0000;' ), 'NUMBERS' => array( 0 => 'color: #cc66cc;' ), 'METHODS' => array( ), 'SYMBOLS' => array( 0 => 'color: #66cc66;' ), 'SCRIPT' => array( ), 'REGEXPS' => array( ) ), 'OOLANG' => false, 'OBJECT_SPLITTERS' => array( ), 'REGEXPS' => array( ), 'STRICT_MODE_APPLIES' => GESHI_NEVER, 'SCRIPT_DELIMITERS' => array( ), 'HIGHLIGHT_STRICT_BLOCK' => array( ) ); ?>
