PageRenderTime 39ms CodeModel.GetById 13ms RepoModel.GetById 1ms app.codeStats 0ms

/libraries/geshi/geshi/sql.php

https://bitbucket.org/asosso/joomla15
PHP | 168 lines | 110 code | 3 blank | 55 comment | 0 complexity | 160900b82ea31462614ed2a93f837419 MD5 | raw file
Possible License(s): LGPL-2.1, Apache-2.0
  1. <?php
  2. // no direct access
  3. defined('_JEXEC') or die;
  4. /*************************************************************************************
  5. * sql.php
  6. * -------
  7. * Author: Nigel McNie (nigel@geshi.org)
  8. * Contributors:
  9. * - Jürgen Thomas (Juergen.Thomas@vs-polis.de)
  10. * Copyright: (c) 2004 Nigel McNie (http://qbnz.com/highlighter)
  11. * Release Version: 1.0.8.10
  12. * Date Started: 2004/06/04
  13. *
  14. * SQL language file for GeSHi.
  15. *
  16. * CHANGES
  17. * -------
  18. * 2010/07/19 (1.0.8.9)
  19. * - Added many more keywords
  20. * 2008/05/23 (1.0.7.22)
  21. * - Added additional symbols for highlighting
  22. * 2004/11/27 (1.0.3)
  23. * - Added support for multiple object splitters
  24. * 2004/10/27 (1.0.2)
  25. * - Added "`" string delimiter
  26. * - Added "#" single comment starter
  27. * 2004/08/05 (1.0.1)
  28. * - Added support for symbols
  29. * - Added many more keywords (mostly MYSQL keywords)
  30. * 2004/07/14 (1.0.0)
  31. * - First Release
  32. *
  33. * TODO (updated 2004/11/27)
  34. * -------------------------
  35. * * Add all keywords
  36. * * Split this to several sql files - mysql-sql, ansi-sql etc
  37. *
  38. *************************************************************************************
  39. *
  40. * This file is part of GeSHi.
  41. *
  42. * GeSHi is free software; you can redistribute it and/or modify
  43. * it under the terms of the GNU General Public License as published by
  44. * the Free Software Foundation; either version 2 of the License, or
  45. * (at your option) any later version.
  46. *
  47. * GeSHi is distributed in the hope that it will be useful,
  48. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  49. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  50. * GNU General Public License for more details.
  51. *
  52. * You should have received a copy of the GNU General Public License
  53. * along with GeSHi; if not, write to the Free Software
  54. * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
  55. *
  56. ************************************************************************************/
  57. $language_data = array (
  58. 'LANG_NAME' => 'SQL',
  59. 'COMMENT_SINGLE' => array(1 =>'--'),
  60. 'COMMENT_MULTI' => array('/*' => '*/'),
  61. 'CASE_KEYWORDS' => 1,
  62. 'QUOTEMARKS' => array("'", '"', '`'),
  63. 'ESCAPE_CHAR' => '\\',
  64. 'KEYWORDS' => array(
  65. 1 => array(
  66. 'ADD', 'ALL', 'ALTER', 'AND', 'AS', 'ASC', 'AUTO_INCREMENT',
  67. 'BEFORE', 'BEGIN', 'BETWEEN', 'BIGINT', 'BINARY', 'BLOB', 'BOOLEAN', 'BOTH', 'BY',
  68. 'CALL', 'CASE', 'CAST', 'CEIL', 'CEILING', 'CHANGE', 'CHAR', 'CHAR_LENGTH', 'CHARACTER',
  69. 'CHARACTER_LENGTH', 'CHECK', 'CLOB', 'COALESCE', 'COLLATE', 'COLUMN', 'COLUMNS',
  70. 'CONNECT', 'CONSTRAINT', 'CONVERT', 'COUNT', 'CREATE', 'CROSS', 'CURRENT',
  71. 'CURRENT_DATE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'CURRENT_USER',
  72. 'DATA', 'DATABASE', 'DATABASES', 'DATE', 'DAY', 'DEC', 'DECIMAL', 'DECLARE',
  73. 'DEFAULT', 'DELAYED', 'DELETE', 'DESC', 'DESCRIBE', 'DISTINCT', 'DOUBLE',
  74. 'DOMAIN', 'DROP',
  75. 'ELSE', 'ENCLOSED', 'END', 'ESCAPED', 'EXCEPT', 'EXEC', 'EXECUTE', 'EXISTS', 'EXP',
  76. 'EXPLAIN', 'EXTRACT',
  77. 'FALSE', 'FIELD', 'FIELDS', 'FILTER', 'FIRST', 'FLOAT', 'FLOOR', 'FLUSH', 'FOR',
  78. 'FOREIGN', 'FROM', 'FULL', 'FUNCTION',
  79. 'GET', 'GROUP', 'GROUPING', 'GO', 'GOTO', 'GRANT', 'GRANTED',
  80. 'HAVING', 'HOUR',
  81. 'IDENTIFIED', 'IDENTITY', 'IF', 'IGNORE', 'IN', 'INCREMENT', 'INDEX', 'INFILE', 'INNER',
  82. 'INOUT', 'INPUT', 'INSERT', 'INT', 'INTEGER', 'INTERSECT', 'INTERSECTION', 'INTERVAL',
  83. 'INTO', 'IS',
  84. 'JOIN',
  85. 'KEY', 'KEYS', 'KILL',
  86. 'LANGUAGE', 'LARGE', 'LAST', 'LEADING', 'LEFT', 'LENGTH', 'LIKE', 'LIMIT', 'LINES', 'LOAD',
  87. 'LOCAL', 'LOCK', 'LOW_PRIORITY', 'LOWER',
  88. 'MATCH', 'MAX', 'MERGE', 'MIN', 'MINUTE', 'MOD', 'MODIFIES', 'MODIFY', 'MONTH',
  89. 'NATIONAL', 'NATURAL', 'NCHAR', 'NEW', 'NEXT', 'NEXTVAL', 'NONE', 'NOT',
  90. 'NULL', 'NULLABLE', 'NULLIF', 'NULLS', 'NUMBER', 'NUMERIC',
  91. 'OF', 'OLD', 'ON', 'ONLY', 'OPEN', 'OPTIMIZE', 'OPTION',
  92. 'OPTIONALLY', 'OR', 'ORDER', 'OUT', 'OUTER', 'OUTFILE', 'OVER',
  93. 'POSITION', 'POWER', 'PRECISION', 'PREPARE', 'PRIMARY', 'PROCEDURAL', 'PROCEDURE',
  94. 'READ', 'REAL', 'REF', 'REFERENCES', 'REFERENCING', 'REGEXP', 'RENAME', 'REPLACE',
  95. 'RESULT', 'RETURN', 'RETURNS', 'REVOKE', 'RIGHT', 'RLIKE', 'ROLLBACK', 'ROW',
  96. 'ROW_NUMBER', 'ROWS', 'RESTRICT', 'ROLE', 'ROUTINE', 'ROW_COUNT',
  97. 'SAVEPOINT', 'SEARCH', 'SECOND', 'SECTION', 'SELECT', 'SELF', 'SEQUENCE',
  98. 'SESSION', 'SET', 'SETVAL', 'SHOW', 'SIMILAR', 'SIZE', 'SMALLINT', 'SOME',
  99. 'SONAME', 'SOURCE', 'SPACE', 'SQL', 'SQRT', 'START', 'STATUS',
  100. 'STRAIGHT_JOIN', 'STRUCTURE', 'STYLE', 'SUBSTRING', 'SUM',
  101. 'TABLE', 'TABLE_NAME', 'TABLES', 'TERMINATED', 'TEMPORARY', 'THEN', 'TIME',
  102. 'TIMESTAMP', 'TO', 'TRAILING', 'TRANSACTION', 'TRIGGER', 'TRIM', 'TRUE', 'TRUNCATE',
  103. 'TRUSTED', 'TYPE',
  104. 'UNDER', 'UNION', 'UNIQUE', 'UNKNOWN', 'UNLOCK', 'UNSIGNED',
  105. 'UPDATE', 'UPPER', 'USE', 'USER', 'USING',
  106. 'VALUE', 'VALUES', 'VARCHAR', 'VARIABLES', 'VARYING', 'VIEW',
  107. 'WHEN', 'WHERE', 'WITH', 'WITHIN', 'WITHOUT', 'WORK', 'WRITE',
  108. 'XOR',
  109. 'YEAR',
  110. 'ZEROFILL'
  111. )
  112. ),
  113. 'SYMBOLS' => array(
  114. '(', ')', '=', '<', '>', '|', ',', '.', '+', '-', '*', '/'
  115. ),
  116. 'CASE_SENSITIVE' => array(
  117. GESHI_COMMENTS => false,
  118. 1 => false
  119. ),
  120. 'STYLES' => array(
  121. 'KEYWORDS' => array(
  122. 1 => 'color: #993333; font-weight: bold;'
  123. ),
  124. 'COMMENTS' => array(
  125. 1 => 'color: #808080; font-style: italic;',
  126. //2 => 'color: #808080; font-style: italic;',
  127. 'MULTI' => 'color: #808080; font-style: italic;'
  128. ),
  129. 'ESCAPE_CHAR' => array(
  130. 0 => 'color: #000099; font-weight: bold;'
  131. ),
  132. 'BRACKETS' => array(
  133. 0 => 'color: #66cc66;'
  134. ),
  135. 'STRINGS' => array(
  136. 0 => 'color: #ff0000;'
  137. ),
  138. 'NUMBERS' => array(
  139. 0 => 'color: #cc66cc;'
  140. ),
  141. 'METHODS' => array(
  142. ),
  143. 'SYMBOLS' => array(
  144. 0 => 'color: #66cc66;'
  145. ),
  146. 'SCRIPT' => array(
  147. ),
  148. 'REGEXPS' => array(
  149. )
  150. ),
  151. 'URLS' => array(
  152. 1 => ''
  153. ),
  154. 'OOLANG' => false,
  155. 'OBJECT_SPLITTERS' => array(
  156. ),
  157. 'REGEXPS' => array(
  158. ),
  159. 'STRICT_MODE_APPLIES' => GESHI_NEVER,
  160. 'SCRIPT_DELIMITERS' => array(
  161. ),
  162. 'HIGHLIGHT_STRICT_BLOCK' => array(
  163. )
  164. );
  165. ?>