mysql.php 5.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286
  1. <?php /* vim: se et ts=4 sw=4 sts=4 fdm=marker tw=80: */
  2. /**
  3. * Copyright (c) 1998-2010 Manuel Lemos, Tomas V.V.Cox,
  4. * Stig. S. Bakken, Lukas Smith, Igor Feghali
  5. * All rights reserved.
  6. *
  7. * MDB2_Schema enables users to maintain RDBMS independant schema files
  8. * in XML that can be used to manipulate both data and database schemas
  9. * This LICENSE is in the BSD license style.
  10. *
  11. * Redistribution and use in source and binary forms, with or without
  12. * modification, are permitted provided that the following conditions
  13. * are met:
  14. *
  15. * Redistributions of source code must retain the above copyright
  16. * notice, this list of conditions and the following disclaimer.
  17. *
  18. * Redistributions in binary form must reproduce the above copyright
  19. * notice, this list of conditions and the following disclaimer in the
  20. * documentation and/or other materials provided with the distribution.
  21. *
  22. * Neither the name of Manuel Lemos, Tomas V.V.Cox, Stig. S. Bakken,
  23. * Lukas Smith, Igor Feghali nor the names of his contributors may be
  24. * used to endorse or promote products derived from this software
  25. * without specific prior written permission.
  26. *
  27. * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
  28. * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
  29. * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
  30. * FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
  31. * REGENTS OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
  32. * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
  33. * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS
  34. * OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED
  35. * AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
  36. * LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY
  37. * WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
  38. * POSSIBILITY OF SUCH DAMAGE.
  39. *
  40. * PHP version 5
  41. *
  42. * @category Database
  43. * @package MDB2_Schema
  44. * @author David Coallier <davidc@php.net>
  45. * @license BSD http://www.opensource.org/licenses/bsd-license.php
  46. * @version SVN: $Id$
  47. * @link http://pear.php.net/packages/MDB2_Schema
  48. */
  49. // {{{ $GLOBALS['_MDB2_Schema_Reserved']['mysql']
  50. /**
  51. * Has a list of reserved words of mysql
  52. *
  53. * @package MDB2_Schema
  54. * @category Database
  55. * @access protected
  56. * @author David Coalier <davidc@php.net>
  57. */
  58. $GLOBALS['_MDB2_Schema_Reserved']['mysql'] = array(
  59. 'ADD',
  60. 'ALL',
  61. 'ALTER',
  62. 'ANALYZE',
  63. 'AND',
  64. 'AS',
  65. 'ASC',
  66. 'ASENSITIVE',
  67. 'BEFORE',
  68. 'BETWEEN',
  69. 'BIGINT',
  70. 'BINARY',
  71. 'BLOB',
  72. 'BOTH',
  73. 'BY',
  74. 'CALL',
  75. 'CASCADE',
  76. 'CASE',
  77. 'CHANGE',
  78. 'CHAR',
  79. 'CHARACTER',
  80. 'CHECK',
  81. 'COLLATE',
  82. 'COLUMN',
  83. 'CONDITION',
  84. 'CONNECTION',
  85. 'CONSTRAINT',
  86. 'CONTINUE',
  87. 'CONVERT',
  88. 'CREATE',
  89. 'CROSS',
  90. 'CURRENT_DATE',
  91. 'CURRENT_TIME',
  92. 'CURRENT_TIMESTAMP',
  93. 'CURRENT_USER',
  94. 'CURSOR',
  95. 'DATABASE',
  96. 'DATABASES',
  97. 'DAY_HOUR',
  98. 'DAY_MICROSECOND',
  99. 'DAY_MINUTE',
  100. 'DAY_SECOND',
  101. 'DEC',
  102. 'DECIMAL',
  103. 'DECLARE',
  104. 'DEFAULT',
  105. 'DELAYED',
  106. 'DELETE',
  107. 'DESC',
  108. 'DESCRIBE',
  109. 'DETERMINISTIC',
  110. 'DISTINCT',
  111. 'DISTINCTROW',
  112. 'DIV',
  113. 'DOUBLE',
  114. 'DROP',
  115. 'DUAL',
  116. 'EACH',
  117. 'ELSE',
  118. 'ELSEIF',
  119. 'ENCLOSED',
  120. 'ESCAPED',
  121. 'EXISTS',
  122. 'EXIT',
  123. 'EXPLAIN',
  124. 'FALSE',
  125. 'FETCH',
  126. 'FLOAT',
  127. 'FLOAT4',
  128. 'FLOAT8',
  129. 'FOR',
  130. 'FORCE',
  131. 'FOREIGN',
  132. 'FROM',
  133. 'FULLTEXT',
  134. 'GOTO',
  135. 'GRANT',
  136. 'GROUP',
  137. 'HAVING',
  138. 'HIGH_PRIORITY',
  139. 'HOUR_MICROSECOND',
  140. 'HOUR_MINUTE',
  141. 'HOUR_SECOND',
  142. 'IF',
  143. 'IGNORE',
  144. 'IN',
  145. 'INDEX',
  146. 'INFILE',
  147. 'INNER',
  148. 'INOUT',
  149. 'INSENSITIVE',
  150. 'INSERT',
  151. 'INT',
  152. 'INT1',
  153. 'INT2',
  154. 'INT3',
  155. 'INT4',
  156. 'INT8',
  157. 'INTEGER',
  158. 'INTERVAL',
  159. 'INTO',
  160. 'IS',
  161. 'ITERATE',
  162. 'JOIN',
  163. 'KEY',
  164. 'KEYS',
  165. 'KILL',
  166. 'LABEL',
  167. 'LEADING',
  168. 'LEAVE',
  169. 'LEFT',
  170. 'LIKE',
  171. 'LIMIT',
  172. 'LINES',
  173. 'LOAD',
  174. 'LOCALTIME',
  175. 'LOCALTIMESTAMP',
  176. 'LOCK',
  177. 'LONG',
  178. 'LONGBLOB',
  179. 'LONGTEXT',
  180. 'LOOP',
  181. 'LOW_PRIORITY',
  182. 'MATCH',
  183. 'MEDIUMBLOB',
  184. 'MEDIUMINT',
  185. 'MEDIUMTEXT',
  186. 'MIDDLEINT',
  187. 'MINUTE_MICROSECOND',
  188. 'MINUTE_SECOND',
  189. 'MOD',
  190. 'MODIFIES',
  191. 'NATURAL',
  192. 'NOT',
  193. 'NO_WRITE_TO_BINLOG',
  194. 'NULL',
  195. 'NUMERIC',
  196. 'ON',
  197. 'OPTIMIZE',
  198. 'OPTION',
  199. 'OPTIONALLY',
  200. 'OR',
  201. 'ORDER',
  202. 'OUT',
  203. 'OUTER',
  204. 'OUTFILE',
  205. 'PRECISION',
  206. 'PRIMARY',
  207. 'PROCEDURE',
  208. 'PURGE',
  209. 'RAID0',
  210. 'READ',
  211. 'READS',
  212. 'REAL',
  213. 'REFERENCES',
  214. 'REGEXP',
  215. 'RELEASE',
  216. 'RENAME',
  217. 'REPEAT',
  218. 'REPLACE',
  219. 'REQUIRE',
  220. 'RESTRICT',
  221. 'RETURN',
  222. 'REVOKE',
  223. 'RIGHT',
  224. 'RLIKE',
  225. 'SCHEMA',
  226. 'SCHEMAS',
  227. 'SECOND_MICROSECOND',
  228. 'SELECT',
  229. 'SENSITIVE',
  230. 'SEPARATOR',
  231. 'SET',
  232. 'SHOW',
  233. 'SMALLINT',
  234. 'SONAME',
  235. 'SPATIAL',
  236. 'SPECIFIC',
  237. 'SQL',
  238. 'SQLEXCEPTION',
  239. 'SQLSTATE',
  240. 'SQLWARNING',
  241. 'SQL_BIG_RESULT',
  242. 'SQL_CALC_FOUND_ROWS',
  243. 'SQL_SMALL_RESULT',
  244. 'SSL',
  245. 'STARTING',
  246. 'STRAIGHT_JOIN',
  247. 'TABLE',
  248. 'TERMINATED',
  249. 'THEN',
  250. 'TINYBLOB',
  251. 'TINYINT',
  252. 'TINYTEXT',
  253. 'TO',
  254. 'TRAILING',
  255. 'TRIGGER',
  256. 'TRUE',
  257. 'UNDO',
  258. 'UNION',
  259. 'UNIQUE',
  260. 'UNLOCK',
  261. 'UNSIGNED',
  262. 'UPDATE',
  263. 'USAGE',
  264. 'USE',
  265. 'USING',
  266. 'UTC_DATE',
  267. 'UTC_TIME',
  268. 'UTC_TIMESTAMP',
  269. 'VALUES',
  270. 'VARBINARY',
  271. 'VARCHAR',
  272. 'VARCHARACTER',
  273. 'VARYING',
  274. 'WHEN',
  275. 'WHERE',
  276. 'WHILE',
  277. 'WITH',
  278. 'WRITE',
  279. 'X509',
  280. 'XOR',
  281. 'YEAR_MONTH',
  282. 'ZEROFILL',
  283. );
  284. // }}}