• keyword update for syntax highlighting

• keyword update for completion

1 files changed, 323 insertions, 2 deletions

diff --git a/Source/CMTextView.m b/Source/CMTextView.m
index b61159f7..53be88c7 100644
--- a/Source/CMTextView.m
+++ b/Source/CMTextView.m
@@ -563,8 +563,15 @@ YY_BUFFER_STATE yy_scan_string (const char *);
 -(NSArray *)keywords
 {
 	return [NSArray arrayWithObjects:
+	@"ACCESSIBLE",
+	@"ACTION",
 	@"ADD",
+	@"AFTER",
+	@"AGAINST",
+	@"AGGREGATE",
+	@"ALGORITHM",
 	@"ALL",
+	@"ALTER",
 	@"ALTER TABLE",
 	@"ALTER VIEW",
 	@"ALTER SCHEMA",
@@ -575,29 +582,70 @@ YY_BUFFER_STATE yy_scan_string (const char *);
 	@"ALTER PROCEDURE",
 	@"ANALYZE",
 	@"AND",
+	@"ANY",
+	@"AS",
 	@"ASC",
+	@"ASCII",
 	@"ASENSITIVE",
+	@"AT",
+	@"AUTHORS",
+	@"AUTOEXTEND_SIZE",
+	@"AUTO_INCREMENT",
+	@"AVG",
+	@"AVG_ROW_LENGTH",
+	@"BACKUP",
 	@"BEFORE",
+	@"BEGIN",
 	@"BETWEEN",
 	@"BIGINT",
 	@"BINARY",
+	@"BINLOG",
+	@"BIT",
 	@"BLOB",
+	@"BOOL",
+	@"BOOLEAN",
 	@"BOTH",
+	@"BTREE",
+	@"BY",
+	@"BYTE",
+	@"CACHE",
 	@"CALL",
 	@"CASCADE",
+	@"CASCADED",
 	@"CASE",
+	@"CHAIN",
 	@"CHANGE",
+	@"CHANGED",
 	@"CHAR",
 	@"CHARACTER",
+	@"CHARSET",
 	@"CHECK",
+	@"CHECKSUM",
+	@"CIPHER",
+	@"CLIENT",
+	@"CLOSE",
+	@"COALESCE",
+	@"CODE",
 	@"COLLATE",
+	@"COLLATION",
 	@"COLUMN",
 	@"COLUMNS",
+	@"COMMENT",
+	@"COMMIT",
+	@"COMMITTED",
+	@"COMPACT",
+	@"COMPLETION",
+	@"COMPRESSED",
+	@"CONCURRENT",
 	@"CONDITION",
 	@"CONNECTION",
+	@"CONSISTENT",
 	@"CONSTRAINT",
+	@"CONTAINS",
 	@"CONTINUE",
+	@"CONTRIBUTORS",
 	@"CONVERT",
+	@"CREATE",
 	@"CREATE VIEW",
 	@"CREATE INDEX",
 	@"CREATE FUNCTION",
@@ -608,30 +656,46 @@ YY_BUFFER_STATE yy_scan_string (const char *);
 	@"CREATE TABLE",
 	@"CREATE USER",
 	@"CROSS",
+	@"CUBE",
 	@"CURRENT_DATE",
 	@"CURRENT_TIME",
 	@"CURRENT_TIMESTAMP",
 	@"CURRENT_USER",
 	@"CURSOR",
+	@"DATA",
 	@"DATABASE",
 	@"DATABASES",
+	@"DATAFILE",
+	@"DATE",
+	@"DATETIME",
+	@"DAY",
 	@"DAY_HOUR",
 	@"DAY_MICROSECOND",
 	@"DAY_MINUTE",
 	@"DAY_SECOND",
+	@"DEALLOCATE",
 	@"DEC",
 	@"DECIMAL",
 	@"DECLARE",
 	@"DEFAULT",
+	@"DEFINER",
 	@"DELAYED",
+	@"DELAY_KEY_WRITE",
 	@"DELETE",
 	@"DESC",
 	@"DESCRIBE",
+	@"DES_KEY_FILE",
 	@"DETERMINISTIC",
+	@"DIRECTORY",
+	@"DISABLE",
+	@"DISCARD",
+	@"DISK",
 	@"DISTINCT",
 	@"DISTINCTROW",
 	@"DIV",
+	@"DO",
 	@"DOUBLE",
+	@"DROP",
 	@"DROP TABLE",
 	@"DROP TRIGGER",
 	@"DROP VIEW",
@@ -645,107 +709,296 @@ YY_BUFFER_STATE yy_scan_string (const char *);
 	@"DROP PRIMARY KEY",
 	@"DROP DATABASE",
 	@"DUAL",
+	@"DUMPFILE",
+	@"DUPLICATE",
+	@"DYNAMIC",
 	@"EACH",
 	@"ELSE",
 	@"ELSEIF",
+	@"ENABLE",
 	@"ENCLOSED",
+	@"END",
+	@"ENDS",
+	@"ENGINE",
+	@"ENGINES",
+	@"ENUM",
+	@"ERRORS",
+	@"ESCAPE",
 	@"ESCAPED",
+	@"EVENT",
+	@"EVENTS",
+	@"EVERY",
+	@"EXECUTE",
 	@"EXISTS",
 	@"EXIT",
+	@"EXPANSION",
 	@"EXPLAIN",
+	@"EXTENDED",
+	@"EXTENT_SIZE",
 	@"FALSE",
+	@"FAST",
 	@"FETCH",
 	@"FIELDS",
+	@"FILE",
+	@"FIRST",
+	@"FIXED",
 	@"FLOAT",
+	@"FLOAT4",
+	@"FLOAT8",
+	@"FLUSH",
 	@"FOR",
 	@"FORCE",
+	@"FOREIGN",
 	@"FOREIGN KEY",
 	@"FOUND",
+	@"FRAC_SECOND",
 	@"FROM",
+	@"FULL",
 	@"FULLTEXT",
-	@"GOTO",
+	@"FUNCTION",
+	@"GEOMETRY",
+	@"GEOMETRYCOLLECTION",
+	@"GET_FORMAT",
+	@"GLOBAL",
 	@"GRANT",
+	@"GRANTS",
 	@"GROUP",
+	@"HANDLER",
+	@"HASH",
 	@"HAVING",
+	@"HELP",
 	@"HIGH_PRIORITY",
+	@"HOSTS",
+	@"HOUR",
 	@"HOUR_MICROSECOND",
 	@"HOUR_MINUTE",
 	@"HOUR_SECOND",
+	@"IDENTIFIED",
+	@"IF",
 	@"IGNORE",
+	@"IMPORT",
+	@"IN",
 	@"INDEX",
+	@"INDEXES",
 	@"INFILE",
+	@"INITIAL_SIZE",
 	@"INNER",
+	@"INNOBASE",
+	@"INNODB",
 	@"INOUT",
 	@"INSENSITIVE",
 	@"INSERT",
+	@"INSERT_METHOD",
+	@"INSTALL",
 	@"INT",
+	@"INT1",
+	@"INT2",
+	@"INT3",
+	@"INT4",
+	@"INT8",
 	@"INTEGER",
 	@"INTERVAL",
 	@"INTO",
+	@"INVOKER",
+	@"IO_THREAD",
+	@"IS",
+	@"ISOLATION",
+	@"ISSUER",
 	@"ITERATE",
 	@"JOIN",
 	@"KEY",
 	@"KEYS",
+	@"KEY_BLOCK_SIZE",
 	@"KILL",
+	@"LANGUAGE",
+	@"LAST",
 	@"LEADING",
 	@"LEAVE",
+	@"LEAVES",
 	@"LEFT",
+	@"LESS",
+	@"LEVEL",
 	@"LIKE",
 	@"LIMIT",
+	@"LINEAR",
 	@"LINES",
-	@"LOAD",
+	@"LINESTRING",
+	@"LIST",
+	@"LOAD DATA",
+	@"LOCAL",
 	@"LOCALTIME",
 	@"LOCALTIMESTAMP",
 	@"LOCK",
+	@"LOCKS",
+	@"LOGFILE",
+	@"LOGS",
 	@"LONG",
 	@"LONGBLOB",
 	@"LONGTEXT",
 	@"LOOP",
 	@"LOW_PRIORITY",
+	@"MASTER",
+	@"MASTER_CONNECT_RETRY",
+	@"MASTER_HOST",
+	@"MASTER_LOG_FILE",
+	@"MASTER_LOG_POS",
+	@"MASTER_PASSWORD",
+	@"MASTER_PORT",
+	@"MASTER_SERVER_ID",
+	@"MASTER_SSL",
+	@"MASTER_SSL_CA",
+	@"MASTER_SSL_CAPATH",
+	@"MASTER_SSL_CERT",
+	@"MASTER_SSL_CIPHER",
+	@"MASTER_SSL_KEY",
+	@"MASTER_USER",
 	@"MATCH",
+	@"MAXVALUE",
+	@"MAX_CONNECTIONS_PER_HOUR",
+	@"MAX_QUERIES_PER_HOUR",
+	@"MAX_ROWS",
+	@"MAX_SIZE",
+	@"MAX_UPDATES_PER_HOUR",
+	@"MAX_USER_CONNECTIONS",
+	@"MEDIUM",
 	@"MEDIUMBLOB",
 	@"MEDIUMINT",
 	@"MEDIUMTEXT",
+	@"MEMORY",
+	@"MERGE",
+	@"MICROSECOND",
 	@"MIDDLEINT",
+	@"MIGRATE",
+	@"MINUTE",
 	@"MINUTE_MICROSECOND",
 	@"MINUTE_SECOND",
+	@"MIN_ROWS",
 	@"MOD",
+	@"MODE",
+	@"MODIFIES",
+	@"MODIFY",
+	@"MONTH",
+	@"MULTILINESTRING",
+	@"MULTIPOINT",
+	@"MULTIPOLYGON",
+	@"MUTEX",
+	@"NAME",
+	@"NAMES",
+	@"NATIONAL",
 	@"NATURAL",
+	@"NCHAR",
+	@"NDB",
+	@"NDBCLUSTER",
+	@"NEW",
+	@"NEXT",
+	@"NO",
+	@"NODEGROUP",
+	@"NONE",
 	@"NOT",
+	@"NO_WAIT",
 	@"NO_WRITE_TO_BINLOG",
 	@"NULL",
 	@"NUMERIC",
+	@"NVARCHAR",
+	@"OFFSET",
+	@"OLD_PASSWORD",
 	@"ON",
+	@"ONE",
+	@"ONE_SHOT",
+	@"OPEN",
 	@"OPTIMIZE",
 	@"OPTION",
 	@"OPTIONALLY",
+	@"OR",
 	@"ORDER",
 	@"OUT",
 	@"OUTER",
 	@"OUTFILE",
+	@"PACK_KEYS",
+	@"PARSER",
+	@"PARTIAL",
+	@"PARTITION",
+	@"PARTITIONING",
+	@"PARTITIONS",
+	@"PASSWORD",
+	@"PHASE",
+	@"PLUGIN",
+	@"PLUGINS",
+	@"POINT",
+	@"POLYGON",
 	@"PRECISION",
+	@"PREPARE",
+	@"PRESERVE",
+	@"PREV",
 	@"PRIMARY",
 	@"PRIVILEGES",
 	@"PROCEDURE",
+	@"PROCESS",
+	@"PROCESSLIST",
 	@"PURGE",
+	@"QUARTER",
+	@"QUERY",
+	@"QUICK",
+	@"RANGE",
 	@"READ",
+	@"READS",
+	@"READ_ONLY",
+	@"READ_WRITE",
 	@"REAL",
+	@"REBUILD",
+	@"RECOVER",
+	@"REDOFILE",
+	@"REDO_BUFFER_SIZE",
+	@"REDUNDANT",
 	@"REFERENCES",
 	@"REGEXP",
+	@"RELAY_LOG_FILE",
+	@"RELAY_LOG_POS",
+	@"RELAY_THREAD",
+	@"RELEASE",
+	@"RELOAD",
+	@"REMOVE",
 	@"RENAME",
+	@"REORGANIZE",
+	@"REPAIR",
 	@"REPEAT",
+	@"REPEATABLE",
 	@"REPLACE",
+	@"REPLICATION",
 	@"REQUIRE",
+	@"RESET",
+	@"RESTORE",
 	@"RESTRICT",
+	@"RESUME",
 	@"RETURN",
+	@"RETURNS",
 	@"REVOKE",
 	@"RIGHT",
 	@"RLIKE",
+	@"ROLLBACK",
+	@"ROLLUP",
+	@"ROUTINE",
+	@"ROW",
+	@"ROWS",
+	@"ROW_FORMAT",
+	@"RTREE",
+	@"SAVEPOINT",
+	@"SCHEDULE",
+	@"SCHEDULER",
+	@"SCHEMA",
+	@"SCHEMAS",
+	@"SECOND",
 	@"SECOND_MICROSECOND",
+	@"SECURITY",
 	@"SELECT",
 	@"SENSITIVE",
 	@"SEPARATOR",
+	@"SERIAL",
+	@"SERIALIZABLE",
+	@"SESSION",
 	@"SET",
+	@"SHARE",
+	@"SHOW",
 	@"SHOW PROCEDURE STATUS",
 	@"SHOW PROCESSLIST",
 	@"SHOW SCHEMAS",
@@ -785,8 +1038,15 @@ YY_BUFFER_STATE yy_scan_string (const char *);
 	@"SHOW ENGINE",
 	@"SHOW ENGINES",
 	@"SHOW KEYS",
+	@"SHUTDOWN",
+	@"SIGNED",
+	@"SIMPLE",
+	@"SLAVE",
 	@"SMALLINT",
+	@"SNAPSHOT",
+	@"SOME",
 	@"SONAME",
+	@"SOUNDS",
 	@"SPATIAL",
 	@"SPECIFIC",
 	@"SQL",
@@ -794,44 +1054,105 @@ YY_BUFFER_STATE yy_scan_string (const char *);
 	@"SQLSTATE",
 	@"SQLWARNING",
 	@"SQL_BIG_RESULT",
+	@"SQL_BUFFER_RESULT",
+	@"SQL_CACHE",
 	@"SQL_CALC_FOUND_ROWS",
+	@"SQL_NO_CACHE",
 	@"SQL_SMALL_RESULT",
+	@"SQL_THREAD",
+	@"SQL_TSI_DAY",
+	@"SQL_TSI_FRAC_SECOND",
+	@"SQL_TSI_HOUR",
+	@"SQL_TSI_MINUTE",
+	@"SQL_TSI_MONTH",
+	@"SQL_TSI_QUARTER",
+	@"SQL_TSI_SECOND",
+	@"SQL_TSI_WEEK",
+	@"SQL_TSI_YEAR",
 	@"SSL",
+	@"START",
 	@"STARTING",
+	@"STARTS",
+	@"STATUS",
+	@"STOP",
+	@"STORAGE",
 	@"STRAIGHT_JOIN",
+	@"STRING",
+	@"SUBJECT",
+	@"SUBPARTITION",
+	@"SUBPARTITIONS",
+	@"SUPER",
+	@"SUSPEND",
 	@"TABLE",
 	@"TABLES",
+	@"TABLESPACE",
+	@"TEMPORARY",
+	@"TEMPTABLE",
 	@"TERMINATED",
+	@"TEXT",
+	@"THAN",
 	@"THEN",
+	@"TIME",
+	@"TIMESTAMP",
+	@"TIMESTAMPADD",
+	@"TIMESTAMPDIFF",
 	@"TINYBLOB",
 	@"TINYINT",
 	@"TINYTEXT",
+	@"TO",
 	@"TRAILING",
+	@"TRANSACTION",
 	@"TRIGGER",
+	@"TRIGGERS",
 	@"TRUE",
+	@"TRUNCATE",
+	@"TYPE",
+	@"TYPES",
+	@"UNCOMMITTED",
+	@"UNDEFINED",
 	@"UNDO",
+	@"UNDOFILE",
+	@"UNDO_BUFFER_SIZE",
+	@"UNICODE",
+	@"UNINSTALL",
 	@"UNION",
 	@"UNIQUE",
+	@"UNKNOWN",
 	@"UNLOCK",
 	@"UNSIGNED",
+	@"UNTIL",
 	@"UPDATE",
+	@"UPGRADE",
 	@"USAGE",
 	@"USE",
+	@"USER",
+	@"USER_RESOURCES",
+	@"USE_FRM",
 	@"USING",
 	@"UTC_DATE",
 	@"UTC_TIME",
 	@"UTC_TIMESTAMP",
+	@"VALUE",
 	@"VALUES",
 	@"VARBINARY",
 	@"VARCHAR",
 	@"VARCHARACTER",
+	@"VARIABLES",
 	@"VARYING",
+	@"VIEW",
+	@"WAIT",
+	@"WARNINGS",
+	@"WEEK",
 	@"WHEN",
 	@"WHERE",
 	@"WHILE",
 	@"WITH",
+	@"WORK",
 	@"WRITE",
+	@"X509",
+	@"XA",
 	@"XOR",
+	@"YEAR",
 	@"YEAR_MONTH",
 	@"ZEROFILL",
 	nil];