plugins/geshi/geshi/sql.php
changeset 2 9e3258dfae15
parent 0 441963e5b07a
child 3 f3e2bbbd2155
equal deleted inserted replaced
1:c715631f809a 2:9e3258dfae15
     2 /*************************************************************************************
     2 /*************************************************************************************
     3  * sql.php
     3  * sql.php
     4  * -------
     4  * -------
     5  * Author: Nigel McNie (nigel@geshi.org)
     5  * Author: Nigel McNie (nigel@geshi.org)
     6  * Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter)
     6  * Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter)
     7  * Release Version: 1.0.7.20
     7  * Release Version: 1.0.8.2
     8  * Date Started: 2004/06/04
     8  * Date Started: 2004/06/04
     9  *
     9  *
    10  * SQL language file for GeSHi.
    10  * SQL language file for GeSHi.
    11  *
    11  *
    12  * CHANGES
    12  * CHANGES
    13  * -------
    13  * -------
       
    14  * 2008/05/23 (1.0.7.22)
       
    15  *  -  Added additional symbols for highlighting
    14  * 2004/11/27 (1.0.3)
    16  * 2004/11/27 (1.0.3)
    15  *  -  Added support for multiple object splitters
    17  *  -  Added support for multiple object splitters
    16  * 2004/10/27 (1.0.2)
    18  * 2004/10/27 (1.0.2)
    17  *  -  Added "`" string delimiter
    19  *  -  Added "`" string delimiter
    18  *  -  Added "#" single comment starter
    20  *  -  Added "#" single comment starter
    46  *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
    48  *   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
    47  *
    49  *
    48  ************************************************************************************/
    50  ************************************************************************************/
    49 
    51 
    50 $language_data = array (
    52 $language_data = array (
    51 	'LANG_NAME' => 'SQL',
    53     'LANG_NAME' => 'SQL',
    52 	'COMMENT_SINGLE' => array(1 =>'--', 2 => '#'),
    54     'COMMENT_SINGLE' => array(1 =>'--', 2 => '#'),
    53 	'COMMENT_MULTI' => array('/*' => '*/'),
    55     'COMMENT_MULTI' => array('/*' => '*/'),
    54 	'CASE_KEYWORDS' => 1,
    56     'CASE_KEYWORDS' => 1,
    55 	'QUOTEMARKS' => array("'", '"', '`'),
    57     'QUOTEMARKS' => array("'", '"', '`'),
    56 	'ESCAPE_CHAR' => '\\',
    58     'ESCAPE_CHAR' => '\\',
    57 	'KEYWORDS' => array(
    59     'KEYWORDS' => array(
    58 		1 => array(
    60         1 => array(
    59 			'ALL', 'ASC', 'AS',  'ALTER', 'AND', 'ADD', 'AUTO_INCREMENT',
    61             'ADD', 'ALL', 'ALTER', 'AND', 'AS', 'ASC',
    60 			'BETWEEN', 'BINARY', 'BOTH', 'BY', 'BOOLEAN',
    62             'AUTO_INCREMENT', 'BETWEEN', 'BINARY', 'BOOLEAN',
    61 			'CHANGE', 'CHECK', 'COLUMNS', 'COLUMN', 'CROSS','CREATE',
    63             'BOTH', 'BY', 'CHANGE', 'CHECK', 'COLUMN', 'COLUMNS',
    62 			'DATABASES', 'DATABASE', 'DATA', 'DELAYED', 'DESCRIBE', 'DESC',  'DISTINCT', 'DELETE', 'DROP', 'DEFAULT',
    64             'CREATE', 'CROSS', 'DATA', 'DATABASE', 'DATABASES',
    63 			'ENCLOSED', 'ESCAPED', 'EXISTS', 'EXPLAIN',
    65             'DEFAULT', 'DELAYED', 'DELETE', 'DESC', 'DESCRIBE',
    64 			'FIELDS', 'FIELD', 'FLUSH', 'FOR', 'FOREIGN', 'FUNCTION', 'FROM',
    66             'DISTINCT', 'DROP', 'ENCLOSED', 'ESCAPED', 'EXISTS',
    65 			'GROUP', 'GRANT',
    67             'EXPLAIN', 'FIELD', 'FIELDS', 'FLUSH', 'FOR',
    66 			'HAVING',
    68             'FOREIGN', 'FROM', 'FULL', 'FUNCTION', 'GRANT',
    67 			'IGNORE', 'INDEX', 'INFILE', 'INSERT', 'INNER', 'INTO', 'IDENTIFIED', 'IN', 'IS', 'IF',
    69             'GROUP', 'HAVING', 'IDENTIFIED', 'IF', 'IGNORE',
    68 			'JOIN',
    70             'IN', 'INDEX', 'INFILE', 'INNER', 'INSERT', 'INTO',
    69 			'KEYS', 'KILL','KEY',
    71             'IS', 'JOIN', 'KEY', 'KEYS', 'KILL', 'LANGUAGE',
    70 			'LEADING', 'LIKE', 'LIMIT', 'LINES', 'LOAD', 'LOCAL', 'LOCK', 'LOW_PRIORITY', 'LEFT', 'LANGUAGE',
    72             'LEADING', 'LEFT', 'LIKE', 'LIMIT', 'LINES', 'LOAD',
    71 			'MODIFY',
    73             'LOCAL', 'LOCK', 'LOW_PRIORITY', 'MODIFY', 'NATURAL',
    72 			'NATURAL', 'NOT', 'NULL', 'NEXTVAL',
    74             'NEXTVAL', 'NOT', 'NULL', 'ON', 'OPTIMIZE', 'OPTION',
    73 			'OPTIMIZE', 'OPTION', 'OPTIONALLY', 'ORDER', 'OUTFILE', 'OR', 'OUTER', 'ON',
    75             'OPTIONALLY', 'OR', 'ORDER', 'OUTER', 'OUTFILE',
    74 			'PROCEEDURE','PROCEDURAL', 'PRIMARY',
    76             'PRIMARY', 'PROCEDURAL', 'PROCEEDURE', 'READ',
    75 			'READ', 'REFERENCES', 'REGEXP', 'RENAME', 'REPLACE', 'RETURN', 'REVOKE', 'RLIKE', 'RIGHT',
    77             'REFERENCES', 'REGEXP', 'RENAME', 'REPLACE',
    76 			'SHOW', 'SONAME', 'STATUS', 'STRAIGHT_JOIN', 'SELECT', 'SETVAL', 'SET',
    78             'RETURN', 'REVOKE', 'RIGHT', 'RLIKE', 'SELECT',
    77 			'TABLES', 'TEMINATED', 'TO', 'TRAILING','TRUNCATE', 'TABLE', 'TEMPORARY', 'TRIGGER', 'TRUSTED',
    79             'SET', 'SETVAL', 'SHOW', 'SONAME', 'STATUS',
    78 			'UNIQUE', 'UNLOCK', 'USE', 'USING', 'UPDATE', 'UNSIGNED',
    80             'STRAIGHT_JOIN', 'TABLE', 'TABLES', 'TEMINATED',
    79 			'VALUES', 'VARIABLES', 'VIEW',
    81             'TEMPORARY', 'TO', 'TRAILING', 'TRIGGER', 'TRUNCATE',
    80 			'WITH', 'WRITE', 'WHERE',
    82             'TRUSTED', 'UNION', 'UNIQUE', 'UNLOCK', 'UNSIGNED',
    81 			'ZEROFILL',
    83             'UPDATE', 'USE', 'USING', 'VALUES', 'VARIABLES',
    82 			'XOR',
    84             'VIEW', 'WHERE', 'WITH', 'WRITE', 'XOR', 'ZEROFILL'
    83 			)
    85             )
    84 		),
    86         ),
    85 	'SYMBOLS' => array(
    87     'SYMBOLS' => array(
    86 		'(', ')', '=', '<', '>', '|'
    88         '(', ')', '=', '<', '>', '|', ',', '.', '+', '-', '*', '/'
    87 		),
    89         ),
    88 	'CASE_SENSITIVE' => array(
    90     'CASE_SENSITIVE' => array(
    89 		GESHI_COMMENTS => false,
    91         GESHI_COMMENTS => false,
    90 		1 => false
    92         1 => false
    91 		),
    93         ),
    92 	'STYLES' => array(
    94     'STYLES' => array(
    93 		'KEYWORDS' => array(
    95         'KEYWORDS' => array(
    94 			1 => 'color: #993333; font-weight: bold;'
    96             1 => 'color: #993333; font-weight: bold;'
    95 			),
    97             ),
    96 		'COMMENTS' => array(
    98         'COMMENTS' => array(
    97 			1 => 'color: #808080; font-style: italic;',
    99             1 => 'color: #808080; font-style: italic;',
    98 			2 => 'color: #808080; font-style: italic;',
   100             2 => 'color: #808080; font-style: italic;',
    99             'MULTI' => 'color: #808080; font-style: italic;'
   101             'MULTI' => 'color: #808080; font-style: italic;'
   100 			),
   102             ),
   101 		'ESCAPE_CHAR' => array(
   103         'ESCAPE_CHAR' => array(
   102 			0 => 'color: #000099; font-weight: bold;'
   104             0 => 'color: #000099; font-weight: bold;'
   103 			),
   105             ),
   104 		'BRACKETS' => array(
   106         'BRACKETS' => array(
   105 			0 => 'color: #66cc66;'
   107             0 => 'color: #66cc66;'
   106 			),
   108             ),
   107 		'STRINGS' => array(
   109         'STRINGS' => array(
   108 			0 => 'color: #ff0000;'
   110             0 => 'color: #ff0000;'
   109 			),
   111             ),
   110 		'NUMBERS' => array(
   112         'NUMBERS' => array(
   111 			0 => 'color: #cc66cc;'
   113             0 => 'color: #cc66cc;'
   112 			),
   114             ),
   113 		'METHODS' => array(
   115         'METHODS' => array(
   114 			),
   116             ),
   115 		'SYMBOLS' => array(
   117         'SYMBOLS' => array(
   116 			0 => 'color: #66cc66;'
   118             0 => 'color: #66cc66;'
   117 			),
   119             ),
   118 		'SCRIPT' => array(
   120         'SCRIPT' => array(
   119 			),
   121             ),
   120 		'REGEXPS' => array(
   122         'REGEXPS' => array(
   121 			)
   123             )
   122 		),
   124         ),
   123 	'OOLANG' => false,
   125     'URLS' => array(
   124 	'OBJECT_SPLITTERS' => array(
   126         1 => ''
   125 		),
   127         ),
   126 	'REGEXPS' => array(
   128     'OOLANG' => false,
   127 		),
   129     'OBJECT_SPLITTERS' => array(
   128 	'STRICT_MODE_APPLIES' => GESHI_NEVER,
   130         ),
   129 	'SCRIPT_DELIMITERS' => array(
   131     'REGEXPS' => array(
   130 		),
   132         ),
   131 	'HIGHLIGHT_STRICT_BLOCK' => array(
   133     'STRICT_MODE_APPLIES' => GESHI_NEVER,
   132 		)
   134     'SCRIPT_DELIMITERS' => array(
       
   135         ),
       
   136     'HIGHLIGHT_STRICT_BLOCK' => array(
       
   137         )
   133 );
   138 );
   134 
   139 
   135 ?>
   140 ?>