PageRenderTime 60ms CodeModel.GetById 28ms RepoModel.GetById 0ms app.codeStats 0ms

/mambots/content/geshi/geshi/sql.php

https://bitbucket.org/dgough/annamaria-daneswood-25102012
PHP | 137 lines | 86 code | 2 blank | 49 comment | 0 complexity | 18f45bd6fe7e6ec1aef13d7141844190 MD5 | raw file
Possible License(s): GPL-2.0, LGPL-2.1
  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.8
  8. * CVS Revision Version: $Revision: 2968 $
  9. * Date Started: 2004/06/04
  10. * Last Modified: $Date: 2006/02/25 00:46:33 $
  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. ************************************************************************************/
  51. $language_data = array (
  52. 'LANG_NAME' => 'SQL',
  53. 'COMMENT_SINGLE' => array(1 =>'--', 2 => '#'),
  54. 'COMMENT_MULTI' => array('/*' => '*/'),
  55. 'CASE_KEYWORDS' => 1,
  56. 'QUOTEMARKS' => array("'", '"', '`'),
  57. 'ESCAPE_CHAR' => '\\',
  58. 'KEYWORDS' => array(
  59. 1 => array(
  60. 'ALL', 'ASC', 'AS', 'ALTER', 'AND', 'ADD', 'AUTO_INCREMENT',
  61. 'BETWEEN', 'BINARY', 'BOTH', 'BY', 'BOOLEAN',
  62. 'CHANGE', 'CHECK', 'COLUMNS', 'COLUMN', 'CROSS','CREATE',
  63. 'DATABASES', 'DATABASE', 'DATA', 'DELAYED', 'DESCRIBE', 'DESC', 'DISTINCT', 'DELETE', 'DROP', 'DEFAULT',
  64. 'ENCLOSED', 'ESCAPED', 'EXISTS', 'EXPLAIN',
  65. 'FIELDS', 'FIELD', 'FLUSH', 'FOR', 'FOREIGN', 'FUNCTION', 'FROM',
  66. 'GROUP', 'GRANT',
  67. 'HAVING',
  68. 'IGNORE', 'INDEX', 'INFILE', 'INSERT', 'INNER', 'INTO', 'IDENTIFIED', 'IN', 'IS', 'IF',
  69. 'JOIN',
  70. 'KEYS', 'KILL','KEY',
  71. 'LEADING', 'LIKE', 'LIMIT', 'LINES', 'LOAD', 'LOCAL', 'LOCK', 'LOW_PRIORITY', 'LEFT', 'LANGUAGE',
  72. 'MODIFY',
  73. 'NATURAL', 'NOT', 'NULL', 'NEXTVAL',
  74. 'OPTIMIZE', 'OPTION', 'OPTIONALLY', 'ORDER', 'OUTFILE', 'OR', 'OUTER', 'ON',
  75. 'PROCEEDURE','PROCEDURAL', 'PRIMARY',
  76. 'READ', 'REFERENCES', 'REGEXP', 'RENAME', 'REPLACE', 'RETURN', 'REVOKE', 'RLIKE', 'RIGHT',
  77. 'SHOW', 'SONAME', 'STATUS', 'STRAIGHT_JOIN', 'SELECT', 'SETVAL', 'SET',
  78. 'TABLES', 'TEMINATED', 'TO', 'TRAILING','TRUNCATE', 'TABLE', 'TEMPORARY', 'TRIGGER', 'TRUSTED',
  79. 'UNIQUE', 'UNLOCK', 'USE', 'USING', 'UPDATE', 'UNSIGNED',
  80. 'VALUES', 'VARIABLES', 'VIEW',
  81. 'WITH', 'WRITE', 'WHERE',
  82. 'ZEROFILL',
  83. 'XOR',
  84. )
  85. ),
  86. 'SYMBOLS' => array(
  87. '(', ')', '=', '<', '>', '|'
  88. ),
  89. 'CASE_SENSITIVE' => array(
  90. GESHI_COMMENTS => false,
  91. 1 => false
  92. ),
  93. 'STYLES' => array(
  94. 'KEYWORDS' => array(
  95. 1 => 'color: #993333; font-weight: bold;'
  96. ),
  97. 'COMMENTS' => array(
  98. 1 => 'color: #808080; font-style: italic;',
  99. 2 => 'color: #808080; font-style: italic;',
  100. 'MULTI' => '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. ?>