Rev Author Line No. Line
250 kaklik 1 <?php
2 /* $Id: sqlparser.data.php,v 2.23.4.1 2006/03/26 11:54:14 lem9 Exp $ */
3 // vim: expandtab sw=4 ts=4 sts=4:
4  
5  
6 /** SQL Parser Matching Data
7 *
8 * Copyright 2002 Robin Johnson <robbat2@users.sourceforge.net>
9 * http://www.orbis-terrarum.net/?l=people.robbat2
10 *
11 * This data is used by the SQL Parser to recognize keywords
12 *
13 * It has been extracted from the lex.h file in the MySQL BK tree
14 * (around 4.0.2) as well as the MySQL documentation.
15 *
16 * Note: before adding a value in the arrays, ensure that you respect
17 * proper sorting, especially with underscores. And don't forget to
18 * update the _cnt variable at the end of each array.
19 */
20  
21 $PMA_SQPdata_function_name = array (
22 'ABS',
23 'ACOS',
24 'ADDDATE',
25 'ADDTIME',
26 'AES_DECRYPT',
27 'AES_ENCRYPT',
28 'Area', // polygon-property-functions.html
29 'ASCII',
30 'ASIN',
31 'ATAN',
32 'ATAN2',
33 'AVG',
34 'BENCHMARK',
35 'BIN',
36 'BIT_AND',
37 'BIT_COUNT',
38 'BIT_LENGTH',
39 'BIT_OR',
40 'BIT_XOR', // group-by-functions.html
41 'Boundary', // general-geometry-property-functions.html
42 'CAST',
43 'CEIL',
44 'CEILING',
45 'Centroid', // multipolygon-property-functions.html
46 'CHAR', // string-functions.html
47 'CHARACTER_LENGTH',
48 'CHARSET', // information-functions.html
49 'CHAR_LENGTH',
50 'COALESCE',
51 'COERCIBILITY', // information-functions.html
52 'COLLATION', // information-functions.html
53 'COMPRESS', // string-functions.html
54 'CONCAT',
55 'CONCAT_WS',
56 'CONNECTION_ID',
57 'CONV',
58 'CONVERT',
59 'CONVERT_TZ',
60 'COS',
61 'COT',
62 'COUNT',
63 'CRC32', // mathematical-functions.html
64 'CURDATE',
65 'CURRENT_DATE',
66 'CURRENT_TIME',
67 'CURRENT_TIMESTAMP',
68 'CURRENT_USER',
69 'CURTIME',
70 'DATABASE',
71 'DATE', // date-and-time-functions.html
72 'DATEDIFF', // date-and-time-functions.html
73 'DATE_ADD',
74 'DATE_DIFF',
75 'DATE_FORMAT',
76 'DATE_SUB',
77 'DAY',
78 'DAYNAME',
79 'DAYOFMONTH',
80 'DAYOFWEEK',
81 'DAYOFYEAR',
82 'DECODE',
83 'DEFAULT', // miscellaneous-functions.html
84 'DEGREES',
85 'DES_DECRYPT',
86 'DES_ENCRYPT',
87 'Dimension', // general-geometry-property-functions.html
88 'ELT',
89 'ENCODE',
90 'ENCRYPT',
91 'EndPoint', // linestring-property-functions.html
92 'Envelope', // general-geometry-property-functions.html
93 'EXP',
94 'EXPORT_SET',
95 'ExteriorRing', // polygon-property-functions.html
96 'EXTRACT',
97 'FIELD',
98 'FIND_IN_SET',
99 'FLOOR',
100 'FORMAT',
101 'FOUND_ROWS',
102 'FROM_DAYS',
103 'FROM_UNIXTIME',
104 'GeometryN', // geometrycollection-property-functions.html
105 'GeometryType', // general-geometry-property-functions.html
106 'GET_FORMAT',
107 'GET_LOCK',
108 'GLength', // linestring-property-functions.html
109 'GREATEST',
110 'GROUP_CONCAT',
111 'GROUP_UNIQUE_USERS',
112 'HEX',
113 'HOUR',
114 'IF', //control-flow-functions.html
115 'IFNULL',
116 'INET_ATON',
117 'INET_NTOA',
118 'INSERT', // string-functions.html
119 'INSTR',
120 'InteriorRingN', // polygon-property-functions.html
121 'INTERVAL',
122 'ISNULL',
123 'IsClosed', // multilinestring-property-functions.html
124 'IsEmpty', // general-geometry-property-functions.html
125 'IsRing', // linestring-property-functions.html
126 'IsSimple', // general-geometry-property-functions.html
127 'IS_FREE_LOCK',
128 'IS_USED_LOCK', // miscellaneous-functions.html
129 'LAST_DAY',
130 'LAST_INSERT_ID',
131 'LCASE',
132 'LEAST',
133 'LEFT',
134 'LENGTH',
135 'LN',
136 'LOAD_FILE',
137 'LOCALTIME',
138 'LOCALTIMESTAMP',
139 'LOCATE',
140 'LOG',
141 'LOG10',
142 'LOG2',
143 'LOWER',
144 'LPAD',
145 'LTRIM',
146 'MAKEDATE',
147 'MAKETIME',
148 'MAKE_SET',
149 'MASTER_POS_WAIT',
150 'MAX',
151 'MD5',
152 'MICROSECOND',
153 'MID',
154 'MIN',
155 'MINUTE',
156 'MOD',
157 'MONTH',
158 'MONTHNAME',
159 'NOW',
160 'NULLIF',
161 'NumGeometries', // geometrycollection-property-functions.html
162 'NumInteriorRings', // polygon-property-functions.html
163 'NumPoints', // linestring-property-functions.html
164 'OCT',
165 'OCTET_LENGTH',
166 'OLD_PASSWORD',
167 'ORD',
168 'PASSWORD',
169 'PERIOD_ADD',
170 'PERIOD_DIFF',
171 'PI',
172 'PointN', // linestring-property-functions.html
173 'PointOnSurface', // multipolygon-property-functions.html
174 'POSITION',
175 'POW',
176 'POWER',
177 'QUARTER',
178 'QUOTE',
179 'RADIANS',
180 'RAND',
181 'RELEASE_LOCK',
182 'REPEAT',
183 'REPLACE', // string-functions.html
184 'REVERSE',
185 'RIGHT',
186 'ROUND',
187 'ROW_COUNT', // information-functions.html
188 'RPAD',
189 'RTRIM',
190 'SCHEMA', // information-functions.html
191 'SECOND',
192 'SEC_TO_TIME',
193 'SESSION_USER',
194 'SHA',
195 'SHA1',
196 'SIGN',
197 'SIN',
198 'SLEEP', // miscellaneous-functions.html
199 'SOUNDEX',
200 'SPACE',
201 'SQRT',
202 'SRID', // general-geometry-property-functions.html
203 'StartPoint', // linestring-property-functions.html
204 'STD',
205 'STDDEV',
206 'STDDEV_POP', // group-by-functions.html
207 'STDDEV_SAMP', // group-by-functions.html
208 'STRCMP',
209 'STR_TO_DATE',
210 'SUBDATE',
211 'SUBSTRING',
212 'SUBSTRING_INDEX',
213 'SUBTIME',
214 'SUM',
215 'SYSDATE',
216 'SYSTEM_USER',
217 'TAN',
218 'TIME',
219 'TIMEDIFF',
220 'TIMESTAMP',
221 'TIMESTAMPADD',
222 'TIMESTAMPDIFF',
223 'TIME_FORMAT',
224 'TIME_TO_SEC',
225 'TO_DAYS',
226 'TRIM',
227 'TRUNCATE', // mathematical-functions.html
228 'UCASE',
229 'UNCOMPRESS', // string-functions.html
230 'UNCOMPRESSED_LENGTH', // string-functions.html
231 'UNHEX', // string-functions.html
232 'UNIQUE_USERS',
233 'UNIX_TIMESTAMP',
234 'UPPER',
235 'USER',
236 'UTC_DATE',
237 'UTC_TIME',
238 'UTC_TIMESTAMP',
239 'UUID', // miscellaneous-functions.html
240 'VARIANCE', // group-by-functions.html
241 'VAR_POP', // group-by-functions.html
242 'VAR_SAMP', // group-by-functions.html
243 'VERSION',
244 'WEEK',
245 'WEEKDAY',
246 'WEEKOFYEAR',
247 'X', // point-property-functions.html
248 'Y', // point-property-functions.html
249 'YEAR',
250 'YEARWEEK'
251 );
252 //$PMA_SQPdata_function_name_cnt = count($PMA_SQPdata_function_name);
253 $PMA_SQPdata_function_name_cnt = 229;
254  
255 $PMA_SQPdata_column_attrib = array (
256 'ARCHIVE', // Engine
257 'ASCII',
258 'AUTO_INCREMENT',
259 'BDB', // Engine
260 'BERKELEYDB', // Engine alias BDB
261 'BINARY',
262 'BLACKHOLE', // Engine
263 'CSV', // Engine
264 'DEFAULT',
265 'EXAMPLE', // Engine
266 'FEDERATED', // Engine
267 'HEAP', // Engine
268 'INNOBASE', // Engine alias InnoDB
269 'INNODB', // Engine InnoDB
270 'ISAM', // Engine
271 'MEMORY', // Engine alias HEAP, but preferred
272 'MERGE', // Engine
273 'MRG_ISAM', // Engine
274 'MRG_MYISAM', // Engine alias MERGE
275 'MYISAM', // Engine MyISAM
276 'NATIONAL',
277 'NDB', // Engine alias NDBCLUSTER
278 'NDBCLUSTER', // Engine
279 'PRECISION',
280 'UNDEFINED',
281 'UNICODE',
282 'UNSIGNED',
283 'VARYING',
284 'ZEROFILL'
285 );
286 //$PMA_SQPdata_column_attrib_cnt = count($PMA_SQPdata_column_attrib);
287 $PMA_SQPdata_column_attrib_cnt = 29;
288  
289 $PMA_SQPdata_reserved_word = array (
290 'ACTION',
291 'ADD',
292 'AFTER',
293 'AGAINST',
294 'AGGREGATE',
295 'ALGORITHM',
296 'ALL',
297 'ALTER',
298 'ANALYSE',
299 'ANALYZE',
300 'AND',
301 'AS',
302 'ASC',
303 'AUTOCOMMIT',
304 'AUTO_INCREMENT',
305 'AVG_ROW_LENGTH',
306 'BACKUP',
307 'BEGIN',
308 'BETWEEN',
309 'BINLOG',
310 'BOTH',
311 'BY',
312 'CASCADE',
313 'CASE',
314 'CHANGE',
315 'CHANGED',
316 'CHARSET',
317 'CHECK',
318 'CHECKSUM',
319 'CLIENT',
320 'COLLATE',
321 'COLLATION',
322 'COLUMN',
323 'COLUMNS',
324 'COMMENT',
325 'COMMIT',
326 'COMMITTED',
327 'COMPRESSED',
328 'CONCURRENT',
329 'CONSTRAINT',
330 'CONVERT',
331 'CREATE',
332 'CROSS',
333 'CURRENT_TIMESTAMP',
334 'DATA',
335 'DATABASE',
336 'DATABASES',
337 'DAY',
338 'DAY_HOUR',
339 'DAY_MINUTE',
340 'DAY_SECOND',
341 'DELAYED',
342 'DELAY_KEY_WRITE',
343 'DELETE',
344 'DESC',
345 'DESCRIBE',
346 'DISTINCT',
347 'DISTINCTROW',
348 'DIV',
349 'DO',
350 'DROP',
351 'DUMPFILE',
352 'DYNAMIC',
353 'ELSE',
354 'ENCLOSED',
355 'END',
356 'ENGINE',
357 'ENGINES',
358 'ESCAPE',
359 'ESCAPED',
360 'EVENTS',
361 'EXECUTE',
362 'EXISTS',
363 'EXPLAIN',
364 'EXTENDED',
365 'FAST',
366 'FIELDS',
367 'FILE',
368 'FIRST',
369 'FIXED',
370 'FLUSH',
371 'FOR',
372 'FORCE',
373 'FOREIGN',
374 'FROM',
375 'FULL',
376 'FULLTEXT',
377 'FUNCTION',
378 'GEMINI',
379 'GEMINI_SPIN_RETRIES',
380 'GLOBAL',
381 'GRANT',
382 'GRANTS',
383 'GROUP',
384 'HAVING',
385 'HEAP',
386 'HIGH_PRIORITY',
387 'HOSTS',
388 'HOUR',
389 'HOUR_MINUTE',
390 'HOUR_SECOND',
391 'IDENTIFIED',
392 'IF',
393 'IGNORE',
394 'IN',
395 'INDEX',
396 'INDEXES',
397 'INFILE',
398 'INNER',
399 'INSERT',
400 'INSERT_ID',
401 'INSERT_METHOD',
402 'INTERVAL',
403 'INTO',
404 'IS',
405 'ISOLATION',
406 'JOIN',
407 'KEY',
408 'KEYS',
409 'KILL',
410 'LAST_INSERT_ID',
411 'LEADING',
412 'LEFT',
413 'LEVEL',
414 'LIKE',
415 'LIMIT',
416 'LINES',
417 'LOAD',
418 'LOCAL',
419 'LOCK',
420 'LOCKS',
421 'LOGS',
422 'LOW_PRIORITY',
423 'MASTER',
424 'MASTER_CONNECT_RETRY',
425 'MASTER_HOST',
426 'MASTER_LOG_FILE',
427 'MASTER_LOG_POS',
428 'MASTER_PASSWORD',
429 'MASTER_PORT',
430 'MASTER_USER',
431 'MATCH',
432 'MAX_CONNECTIONS_PER_HOUR',
433 'MAX_QUERIES_PER_HOUR',
434 'MAX_ROWS',
435 'MAX_UPDATES_PER_HOUR',
436 'MAX_USER_CONNECTIONS',
437 'MEDIUM',
438 'MERGE',
439 'MIN_ROWS',
440 'MINUTE',
441 'MINUTE_SECOND',
442 'MODE',
443 'MODIFY',
444 'MONTH',
445 'MRG_MYISAM',
446 'MYISAM',
447 'NAMES',
448 'NATURAL',
449 // 'NO' is not allowed in SQL-99 but is allowed in MySQL
450 //'NO',
451 'NOT',
452 'NULL',
453 'OFFSET',
454 'ON',
455 'OPEN',
456 'OPTIMIZE',
457 'OPTION',
458 'OPTIONALLY',
459 'OR',
460 'ORDER',
461 'OUTER',
462 'OUTFILE',
463 'PACK_KEYS',
464 'PARTIAL',
465 'PASSWORD',
466 'PRIMARY',
467 'PRIVILEGES',
468 'PROCEDURE',
469 'PROCESS',
470 'PROCESSLIST',
471 'PURGE',
472 'QUICK',
473 'RAID0',
474 'RAID_CHUNKS',
475 'RAID_CHUNKSIZE',
476 'RAID_TYPE',
477 'READ',
478 'REFERENCES',
479 'REGEXP',
480 'RELOAD',
481 'RENAME',
482 'REPAIR',
483 'REPEATABLE',
484 'REPLACE',
485 'REPLICATION',
486 'RESET',
487 'RESTORE',
488 'RESTRICT',
489 'RETURN',
490 'RETURNS',
491 'REVOKE',
492 'RIGHT',
493 'RLIKE',
494 'ROLLBACK',
495 'ROW',
496 'ROW_FORMAT',
497 'ROWS',
498 'SECOND',
499 'SELECT',
500 'SEPARATOR',
501 'SERIALIZABLE',
502 'SESSION',
503 'SHARE',
504 'SHOW',
505 'SHUTDOWN',
506 'SLAVE',
507 'SONAME',
508 'SOUNDS', // string-functions.html
509 'SQL_AUTO_IS_NULL',
510 'SQL_BIG_RESULT',
511 'SQL_BIG_SELECTS',
512 'SQL_BIG_TABLES',
513 'SQL_BUFFER_RESULT',
514 'SQL_CACHE',
515 'SQL_CALC_FOUND_ROWS',
516 'SQL_LOG_BIN',
517 'SQL_LOG_OFF',
518 'SQL_LOG_UPDATE',
519 'SQL_LOW_PRIORITY_UPDATES',
520 'SQL_MAX_JOIN_SIZE',
521 'SQL_NO_CACHE',
522 'SQL_QUOTE_SHOW_CREATE',
523 'SQL_SAFE_UPDATES',
524 'SQL_SELECT_LIMIT',
525 'SQL_SLAVE_SKIP_COUNTER',
526 'SQL_SMALL_RESULT',
527 'SQL_WARNINGS',
528 'START',
529 'STARTING',
530 'STATUS',
531 'STOP',
532 'STORAGE',
533 'STRAIGHT_JOIN',
534 'STRING',
535 'STRIPED',
536 'SUPER',
537 'TABLE',
538 'TABLES',
539 'TEMPORARY',
540 'TERMINATED',
541 'THEN',
542 'TO',
543 'TRAILING',
544 'TRUNCATE',
545 'TYPE',
546 'TYPES',
547 'UNCOMMITTED',
548 'UNION',
549 'UNIQUE',
550 'UNLOCK',
551 'UPDATE',
552 'USAGE',
553 'USE',
554 'USING',
555 'VALUES',
556 'VARIABLES',
557 'VIEW',
558 'WHEN',
559 'WHERE',
560 'WITH',
561 'WORK',
562 'WRITE',
563 'XOR',
564 'YEAR_MONTH'
565 );
566 //$PMA_SQPdata_reserved_word_cnt = count($PMA_SQPdata_reserved_word);
567 $PMA_SQPdata_reserved_word_cnt = 273;
568  
569 // words forbidden to be used as column or table name,
570 // as seen in http://dev.mysql.com/doc/mysql/en/reserved-words.html
571 $PMA_SQPdata_forbidden_word = array (
572 'ACTION',
573 'ADD',
574 'AFTER',
575 'AGAINST',
576 'AGGREGATE',
577 'ALGORITHM',
578 'ALL',
579 'ALTER',
580 'ANALYZE',
581 'AND',
582 'ANY',
583 'AS',
584 'ASC',
585 'ASCII',
586 'ASENSITIVE',
587 'AUTO_INCREMENT',
588 'AVG',
589 'AVG_ROW_LENGTH',
590 'BACKUP',
591 'BDB',
592 'BEFORE',
593 'BEGIN',
594 'BERKELEYDB',
595 'BETWEEN',
596 'BIGINT',
597 'BINARY',
598 'BINLOG',
599 'BIT',
600 'BLOB',
601 'BOOL',
602 'BOOLEAN',
603 'BOTH',
604 'BTREE',
605 'BY',
606 'BYTE',
607 'CACHE',
608 'CALL',
609 'CASCADE',
610 'CASCADED',
611 'CASE',
612 'CHAIN',
613 'CHANGE',
614 'CHANGED',
615 'CHAR',
616 'CHARACTER',
617 'CHARSET',
618 'CHECK',
619 'CHECKSUM',
620 'CIPHER',
621 'CLIENT',
622 'CLOSE',
623 'COLLATE',
624 'COLLATION',
625 'COLUMN',
626 'COLUMNS',
627 'COMMENT',
628 'COMMIT',
629 'COMMITTED',
630 'COMPACT',
631 'COMPRESSED',
632 'CONCURRENT',
633 'CONDITION',
634 'CONNECTION',
635 'CONSISTENT',
636 'CONSTRAINT',
637 'CONTAINS',
638 'CONTINUE',
639 'CONVERT',
640 'CREATE',
641 'CROSS',
642 'CUBE',
643 'CURRENT_DATE',
644 'CURRENT_TIME',
645 'CURRENT_TIMESTAMP',
646 'CURRENT_USER',
647 'CURSOR',
648 'DATA',
649 'DATABASE',
650 'DATABASES',
651 'DATE',
652 'DATETIME',
653 'DAY',
654 'DAY_HOUR',
655 'DAY_MICROSECOND',
656 'DAY_MINUTE',
657 'DAY_SECOND',
658 'DEALLOCATE',
659 'DEC',
660 'DECIMAL',
661 'DECLARE',
662 'DEFAULT',
663 'DEFINER',
664 'DELAYED',
665 'DELAY_KEY_WRITE',
666 'DELETE',
667 'DESC',
668 'DESCRIBE',
669 'DES_KEY_FILE',
670 'DETERMINISTIC',
671 'DIRECTORY',
672 'DISABLE',
673 'DISCARD',
674 'DISTINCT',
675 'DISTINCTROW',
676 'DIV',
677 'DO',
678 'DOUBLE',
679 'DROP',
680 'DUAL',
681 'DUMPFILE',
682 'DUPLICATE',
683 'DYNAMIC',
684 'EACH',
685 'ELSE',
686 'ELSEIF',
687 'ENABLE',
688 'ENCLOSED',
689 'END',
690 'ENGINE',
691 'ENGINES',
692 'ENUM',
693 'ERRORS',
694 'ESCAPE',
695 'ESCAPED',
696 'EVENTS',
697 'EXECUTE',
698 'EXISTS',
699 'EXIT',
700 'EXPANSION',
701 'EXPLAIN',
702 'EXTENDED',
703 'FALSE',
704 'FAST',
705 'FETCH',
706 'FIELDS',
707 'FILE',
708 'FIRST',
709 'FIXED',
710 'FLOAT',
711 'FLOAT4',
712 'FLOAT8',
713 'FLUSH',
714 'FOR',
715 'FORCE',
716 'FOREIGN',
717 'FOUND',
718 'FRAC_SECOND',
719 'FROM',
720 'FULL',
721 'FULLTEXT',
722 'FUNCTION',
723 'GEOMETRY',
724 'GEOMETRYCOLLECTION',
725 'GET_FORMAT',
726 'GLOBAL',
727 'GOTO',
728 'GRANT',
729 'GRANTS',
730 'GROUP',
731 'HANDLER',
732 'HASH',
733 'HAVING',
734 'HELP',
735 'HIGH_PRIORITY',
736 'HOSTS',
737 'HOUR',
738 'HOUR_MICROSECOND',
739 'HOUR_MINUTE',
740 'HOUR_SECOND',
741 'IDENTIFIED',
742 'IF',
743 'IGNORE',
744 'IMPORT',
745 'IN',
746 'INDEX',
747 'INDEXES',
748 'INFILE',
749 'INNER',
750 'INNOBASE',
751 'INNODB',
752 'INOUT',
753 'INSENSITIVE',
754 'INSERT',
755 'INSERT_METHOD',
756 'INT',
757 'INT1',
758 'INT2',
759 'INT3',
760 'INT4',
761 'INT8',
762 'INTEGER',
763 'INTERVAL',
764 'INTO',
765 'INVOKER',
766 'IO_THREAD',
767 'IS',
768 'ISOLATION',
769 'ISSUER',
770 'ITERATE',
771 'JOIN',
772 'KEY',
773 'KEYS',
774 'KILL',
775 'LABEL',
776 'LANGUAGE',
777 'LAST',
778 'LEADING',
779 'LEAVE',
780 'LEAVES',
781 'LEFT',
782 'LEVEL',
783 'LIKE',
784 'LIMIT',
785 'LINES',
786 'LINESTRING',
787 'LOAD',
788 'LOCAL',
789 'LOCALTIME',
790 'LOCALTIMESTAMP',
791 'LOCK',
792 'LOCKS',
793 'LOGS',
794 'LONG',
795 'LONGBLOB',
796 'LONGTEXT',
797 'LOOP',
798 'LOW_PRIORITY',
799 'MASTER',
800 'MASTER_CONNECT_RETRY',
801 'MASTER_HOST',
802 'MASTER_LOG_FILE',
803 'MASTER_LOG_POS',
804 'MASTER_PASSWORD',
805 'MASTER_PORT',
806 'MASTER_SERVER_ID',
807 'MASTER_SSL',
808 'MASTER_SSL_CA',
809 'MASTER_SSL_CAPATH',
810 'MASTER_SSL_CERT',
811 'MASTER_SSL_CIPHER',
812 'MASTER_SSL_KEY',
813 'MASTER_USER',
814 'MATCH',
815 'MAX_CONNECTIONS_PER_HOUR',
816 'MAX_QUERIES_PER_HOUR',
817 'MAX_ROWS',
818 'MAX_UPDATES_PER_HOUR',
819 'MAX_USER_CONNECTIONS',
820 'MEDIUM',
821 'MEDIUMBLOB',
822 'MEDIUMINT',
823 'MEDIUMTEXT',
824 'MERGE',
825 'MICROSECOND',
826 'MIDDLEINT',
827 'MIGRATE',
828 'MINUTE',
829 'MINUTE_MICROSECOND',
830 'MINUTE_SECOND',
831 'MIN_ROWS',
832 'MOD',
833 'MODE',
834 'MODIFIES',
835 'MODIFY',
836 'MONTH',
837 'MULTILINESTRING',
838 'MULTIPOINT',
839 'MULTIPOLYGON',
840 'MUTEX',
841 'NAME',
842 'NAMES',
843 'NATIONAL',
844 'NATURAL',
845 'NCHAR',
846 'NDB',
847 'NDBCLUSTER',
848 'NEW',
849 'NEXT',
850 'NO',
851 'NONE',
852 'NOT',
853 'NO_WRITE_TO_BINLOG',
854 'NULL',
855 'NUMERIC',
856 'NVARCHAR',
857 'OFFSET',
858 'OLD_PASSWORD',
859 'ON',
860 'ONE',
861 'ONE_SHOT',
862 'OPEN',
863 'OPTIMIZE',
864 'OPTION',
865 'OPTIONALLY',
866 'OR',
867 'ORDER',
868 'OUT',
869 'OUTER',
870 'OUTFILE',
871 'PACK_KEYS',
872 'PARTIAL',
873 'PASSWORD',
874 'PHASE',
875 'POINT',
876 'POLYGON',
877 'PRECISION',
878 'PREPARE',
879 'PREV',
880 'PRIMARY',
881 'PRIVILEGES',
882 'PROCEDURE',
883 'PROCESSLIST',
884 'PURGE',
885 'QUARTER',
886 'QUERY',
887 'QUICK',
888 'RAID0',
889 'RAID_CHUNKS',
890 'RAID_CHUNKSIZE',
891 'RAID_TYPE',
892 'READ',
893 'READS',
894 'REAL',
895 'RECOVER',
896 'REDUNDANT',
897 'REFERENCES',
898 'REGEXP',
899 'RELAY_LOG_FILE',
900 'RELAY_LOG_POS',
901 'RELAY_THREAD',
902 'RELEASE',
903 'RELOAD',
904 'RENAME',
905 'REPAIR',
906 'REPEAT',
907 'REPEATABLE',
908 'REPLACE',
909 'REPLICATION',
910 'REQUIRE',
911 'RESET',
912 'RESTORE',
913 'RESTRICT',
914 'RESUME',
915 'RETURN',
916 'RETURNS',
917 'REVOKE',
918 'RIGHT',
919 'RLIKE',
920 'ROLLBACK',
921 'ROLLUP',
922 'ROUTINE',
923 'ROW',
924 'ROWS',
925 'ROW_FORMAT',
926 'RTREE',
927 'SAVEPOINT',
928 'SCHEMA',
929 'SCHEMAS',
930 'SECOND',
931 'SECOND_MICROSECOND',
932 'SECURITY',
933 'SELECT',
934 'SENSITIVE',
935 'SEPARATOR',
936 'SERIAL',
937 'SERIALIZABLE',
938 'SESSION',
939 'SET',
940 'SHARE',
941 'SHOW',
942 'SHUTDOWN',
943 'SIGNED',
944 'SIMPLE',
945 'SLAVE',
946 'SMALLINT',
947 'SNAPSHOT',
948 'SOME',
949 'SONAME',
950 'SOUNDS',
951 'SPATIAL',
952 'SPECIFIC',
953 'SQL',
954 'SQLEXCEPTION',
955 'SQLSTATE',
956 'SQLWARNING',
957 'SQL_BIG_RESULT',
958 'SQL_BUFFER_RESULT',
959 'SQL_CACHE',
960 'SQL_CALC_FOUND_ROWS',
961 'SQL_NO_CACHE',
962 'SQL_SMALL_RESULT',
963 'SQL_THREAD',
964 'SQL_TSI_DAY',
965 'SQL_TSI_FRAC_SECOND',
966 'SQL_TSI_HOUR',
967 'SQL_TSI_MINUTE',
968 'SQL_TSI_MONTH',
969 'SQL_TSI_QUARTER',
970 'SQL_TSI_SECOND',
971 'SQL_TSI_WEEK',
972 'SQL_TSI_YEAR',
973 'SSL',
974 'START',
975 'STARTING',
976 'STATUS',
977 'STOP',
978 'STORAGE',
979 'STRAIGHT_JOIN',
980 'STRING',
981 'STRIPED',
982 'SUBJECT',
983 'SUPER',
984 'SUSPEND',
985 'TABLE',
986 'TABLES',
987 'TABLESPACE',
988 'TEMPORARY',
989 'TEMPTABLE',
990 'TERMINATED',
991 'TEXT',
992 'THEN',
993 'TIME',
994 'TIMESTAMP',
995 'TIMESTAMPADD',
996 'TIMESTAMPDIFF',
997 'TINYBLOB',
998 'TINYINT',
999 'TINYTEXT',
1000 'TO',
1001 'TRAILING',
1002 'TRANSACTION',
1003 'TRIGGER',
1004 'TRIGGERS',
1005 'TRUE',
1006 'TRUNCATE',
1007 'TYPE',
1008 'TYPES',
1009 'UNCOMMITTED',
1010 'UNDEFINED',
1011 'UNDO',
1012 'UNICODE',
1013 'UNION',
1014 'UNIQUE',
1015 'UNKNOWN',
1016 'UNLOCK',
1017 'UNSIGNED',
1018 'UNTIL',
1019 'UPDATE',
1020 'USAGE',
1021 'USE',
1022 'USER',
1023 'USER_RESOURCES',
1024 'USE_FRM',
1025 'USING',
1026 'UTC_DATE',
1027 'UTC_TIME',
1028 'UTC_TIMESTAMP',
1029 'VALUE',
1030 'VALUES',
1031 'VARBINARY',
1032 'VARCHAR',
1033 'VARCHARACTER',
1034 'VARIABLES',
1035 'VARYING',
1036 'VIEW',
1037 'WARNINGS',
1038 'WEEK',
1039 'WHEN',
1040 'WHERE',
1041 'WHILE',
1042 'WITH',
1043 'WORK',
1044 'WRITE',
1045 'X509',
1046 'XA',
1047 'XOR',
1048 'YEAR',
1049 'YEAR_MONTH',
1050 'ZEROFILL'
1051 );
1052 // echo count($PMA_SQPdata_forbidden_word);
1053 $PMA_SQPdata_forbidden_word_cnt = 479;
1054  
1055 $PMA_SQPdata_column_type = array (
1056 'BIGINT',
1057 'BINARY',
1058 'BIT',
1059 'BLOB',
1060 'BOOL',
1061 'BOOLEAN', // numeric-type-overview.html
1062 'CHAR',
1063 'CHARACTER',
1064 'DATE',
1065 'DATETIME',
1066 'DEC',
1067 'DECIMAL',
1068 'DOUBLE',
1069 'ENUM',
1070 'FLOAT',
1071 'FLOAT4',
1072 'FLOAT8',
1073 'INT',
1074 'INT1',
1075 'INT2',
1076 'INT3',
1077 'INT4',
1078 'INT8',
1079 'INTEGER',
1080 'LONG',
1081 'LONGBLOB',
1082 'LONGTEXT',
1083 'MEDIUMBLOB',
1084 'MEDIUMINT',
1085 'MEDIUMTEXT',
1086 'MIDDLEINT',
1087 'NCHAR',
1088 'NUMERIC',
1089 'REAL',
1090 'SERIAL', //BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE
1091 'SET',
1092 'SMALLINT',
1093 'TEXT',
1094 'TIME',
1095 'TIMESTAMP',
1096 'TINYBLOB',
1097 'TINYINT',
1098 'TINYTEXT',
1099 'VARBINARY',
1100 'VARCHAR',
1101 'YEAR'
1102 );
1103 //$PMA_SQPdata_column_type_cnt = count($PMA_SQPdata_column_type);
1104 $PMA_SQPdata_column_type_cnt = 46;
1105  
1106 // check counts
1107 /*
1108 foreach ( $GLOBALS as $n => $a ) {
1109 echo is_array( $a ) ? $n . ': ' . count( $a ) . '<br />' : '';
1110 }
1111 */
1112 ?>