# Source for file sql.php

Documentation is available at sql.php

    1     <?php
    2     /***********************************************************************************
    3      * sql.php
    4      * -------
    5      * Author: Nigel McNie (oracle.shinoda@gmail.com)
    6      * Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter)
    7      * Release Version: 1.0.7.3
    8      * CVS Revision Version: $Revision: 1.1 $
    9      * Date Started: 2004/06/04
    10     * Last Modified: $Date: 2006/01/23 09:27:29 $
    11     *
    12     * SQL language file for GeSHi.
    13     *
    14     * CHANGES
    15     * -------
    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     ************************************************************************************/
    50
    51
    52    $language_data = array (
    53        'LANG_NAME' => 'SQL',
    54        'COMMENT_SINGLE' => array(1 =>'--', 2 => '#'),
    55        'COMMENT_MULTI' => array('/*' => '*/'),
    56        'CASE_KEYWORDS' => 1,
    57        'QUOTEMARKS' => array("'", '"', '`'),
    58        'ESCAPE_CHAR' => '\\',
    59        'KEYWORDS' => array(
    60            1 => array(
    61                'ALL', 'ASC', 'AS',  'ALTER', 'AND', 'ADD', 'AUTO_INCREMENT',
    62                'BETWEEN', 'BINARY', 'BOTH', 'BY', 'BOOLEAN',
    63                'CHANGE', 'CHECK', 'COLUMNS', 'COLUMN', 'CROSS','CREATE',
    64                'DATABASES', 'DATABASE', 'DATA', 'DELAYED', 'DESCRIBE', 'DESC',  'DISTINCT', 'DELETE', 'DROP', 'DEFAULT',
    65                'ENCLOSED', 'ESCAPED', 'EXISTS', 'EXPLAIN',
    66                'FIELDS', 'FIELD', 'FLUSH', 'FOR', 'FOREIGN', 'FUNCTION', 'FROM',
    67                'GROUP', 'GRANT',
    68                'HAVING',
    69                'IGNORE', 'INDEX', 'INFILE', 'INSERT', 'INNER', 'INTO', 'IDENTIFIED', 'IN', 'IS', 'IF',
    70                'JOIN',
    71                'KEYS', 'KILL','KEY',
    72                'LEADING', 'LIKE', 'LIMIT', 'LINES', 'LOAD', 'LOCAL', 'LOCK', 'LOW_PRIORITY', 'LEFT', 'LANGUAGE',
    73                'MODIFY',
    74                'NATURAL', 'NOT', 'NULL', 'NEXTVAL',
    75                'OPTIMIZE', 'OPTION', 'OPTIONALLY', 'ORDER', 'OUTFILE', 'OR', 'OUTER', 'ON',
    76                'PROCEEDURE','PROCEDURAL', 'PRIMARY',
    77                'READ', 'REFERENCES', 'REGEXP', 'RENAME', 'REPLACE', 'RETURN', 'REVOKE', 'RLIKE', 'RIGHT',
    78                'SHOW', 'SONAME', 'STATUS', 'STRAIGHT_JOIN', 'SELECT', 'SETVAL', 'SET',
    79                'TABLES', 'TEMINATED', 'TO', 'TRAILING','TRUNCATE', 'TABLE', 'TEMPORARY', 'TRIGGER', 'TRUSTED',
    80                'UNIQUE', 'UNLOCK', 'USE', 'USING', 'UPDATE', 'UNSIGNED',
    81                'VALUES', 'VARIABLES', 'VIEW',
    82                'WITH', 'WRITE', 'WHERE',
    83                'ZEROFILL',
    84                'XOR',
    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               ),
    102           'ESCAPE_CHAR' => array(
    103               0 => 'color: #000099; font-weight: bold;'
    104               ),
    105           'BRACKETS' => array(
    106               0 => 'color: #66cc66;'
    107               ),
    108           'STRINGS' => array(
    109               0 => 'color: #ff0000;'
    110               ),
    111           'NUMBERS' => array(
    112               0 => 'color: #cc66cc;'
    113               ),
    114           'METHODS' => array(
    115               ),
    116           'SYMBOLS' => array(
    117               0 => 'color: #66cc66;'
    118               ),
    119           'SCRIPT' => array(
    120               ),
    121           'REGEXPS' => array(
    122               )
    123           ),
    124       'OOLANG' => false,
    125       'OBJECT_SPLITTERS' => array(
    126           ),
    127       'REGEXPS' => array(
    128           ),
    129       'STRICT_MODE_APPLIES' => GESHI_NEVER,
    130       'SCRIPT_DELIMITERS' => array(
    131           ),
    132       'HIGHLIGHT_STRICT_BLOCK' => array(
    133           )
    134   );
    135
    136   ?>

Documentation generated on Thu, 22 Sep 2005 13:48:06 +1200 by phpDocumentor 1.2.3