// SQL highlighter for DBISAM V3
// Ole Willy Tuv 2002-05-14

// states
State=snormal
State=sstring1
State=sstring2
State=scomment1
State=scomment2

// tokens
Token=tnone
Token=tstring
Token=tcomment
Token=tident
Token=tinteger
Token=tfloat
Token=tresword

//delims
Delimiters=;.,:'"{}[]()?!@#$%^&*-+=|\/

// reswords
snormal 'ABS'               snormal tresword
snormal 'ADD'               snormal tresword
snormal 'ALL'               snormal tresword
snormal 'ALTER'             snormal tresword
snormal 'AND'               snormal tresword
snormal 'AS'                snormal tresword
snormal 'ASC'               snormal tresword
snormal 'ASCENDING'         snormal tresword
snormal 'AT'                snormal tresword
snormal 'AUTOINC'           snormal tresword
snormal 'AVG'               snormal tresword
snormal 'BETWEEN'           snormal tresword
snormal 'BLOB'              snormal tresword
snormal 'BLOCK'             snormal tresword
snormal 'BOOLEAN'           snormal tresword
snormal 'BOTH'              snormal tresword
snormal 'BY'                snormal tresword
snormal 'BYTES'             snormal tresword
snormal 'CAST'              snormal tresword
snormal 'CHAR'              snormal tresword
snormal 'CHARACTER'         snormal tresword
snormal 'CHARCASE'          snormal tresword
snormal 'CHARS'             snormal tresword
snormal 'COLUMN'            snormal tresword
snormal 'COMMIT'            snormal tresword
snormal 'COMPRESS'          snormal tresword
snormal 'CONSTRAINT'        snormal tresword
snormal 'COUNT'             snormal tresword
snormal 'CREATE'            snormal tresword
snormal 'CURRENT_DATE'      snormal tresword
snormal 'CURRENT_TIME'      snormal tresword
snormal 'CURRENT_TIMESTAMP' snormal tresword
snormal 'DATE'              snormal tresword
snormal 'DAY'               snormal tresword
snormal 'DAYOFWEEK'         snormal tresword
snormal 'DECIMAL'           snormal tresword
snormal 'DEFAULT'           snormal tresword
snormal 'DELETE'            snormal tresword
snormal 'DESC'              snormal tresword
snormal 'DESCENDING'        snormal tresword
snormal 'DESCRIPTION'       snormal tresword
snormal 'DISTINCT'          snormal tresword
snormal 'DROP'              snormal tresword
snormal 'DUPBYTE'           snormal tresword
snormal 'ELSE'              snormal tresword
snormal 'ENCRYPTED'         snormal tresword
snormal 'EXISTS'            snormal tresword
snormal 'EXTRACT'           snormal tresword
snormal 'FALSE'             snormal tresword
snormal 'FLOAT'             snormal tresword
snormal 'FLUSH'             snormal tresword
snormal 'FOR'               snormal tresword
snormal 'FROM'              snormal tresword
snormal 'FULL'              snormal tresword
snormal 'GROUP'             snormal tresword
snormal 'HAVING'            snormal tresword
snormal 'HOUR'              snormal tresword
snormal 'IF'                snormal tresword
snormal 'IN'                snormal tresword
snormal 'INCLUDE'           snormal tresword
snormal 'INDEX'             snormal tresword
snormal 'INNER'             snormal tresword
snormal 'INSERT'            snormal tresword
snormal 'INT'               snormal tresword
snormal 'INTEGER'           snormal tresword
snormal 'INTERVAL'          snormal tresword
snormal 'INTO'              snormal tresword
snormal 'IS'                snormal tresword
snormal 'JOIN'              snormal tresword
snormal 'KEY'               snormal tresword
snormal 'LANGUAGE'          snormal tresword
snormal 'LARGEINT'          snormal tresword
snormal 'LEADING'           snormal tresword
snormal 'LEFT'              snormal tresword
snormal 'LENGTH'            snormal tresword
snormal 'LIKE'              snormal tresword
snormal 'LOCKS'             snormal tresword
snormal 'LOWER'             snormal tresword
snormal 'MAJOR'             snormal tresword
snormal 'MAX'               snormal tresword
snormal 'MAXIMUM'           snormal tresword
snormal 'MEMORY'            snormal tresword
snormal 'MIN'               snormal tresword
snormal 'MINIMUM'           snormal tresword
snormal 'MINOR'             snormal tresword
snormal 'MINUTE'            snormal tresword
snormal 'MONEY'             snormal tresword
snormal 'MONTH'             snormal tresword
snormal 'NOAUTOINC'         snormal tresword
snormal 'NOBACKUP'          snormal tresword
snormal 'NOCASE'            snormal tresword
snormal 'NOCHANGE'          snormal tresword
snormal 'NOJOINOPTIMIZE'    snormal tresword
snormal 'NONE'              snormal tresword
snormal 'NOT'               snormal tresword
snormal 'NULL'              snormal tresword
snormal 'NUMERIC'           snormal tresword
snormal 'OCCURS'            snormal tresword
snormal 'ON'                snormal tresword
snormal 'OR'                snormal tresword
snormal 'ORDER'             snormal tresword
snormal 'OUTER'             snormal tresword
snormal 'POS'               snormal tresword
snormal 'PRIMARY'           snormal tresword
snormal 'RANGE'             snormal tresword
snormal 'REDEFINE'          snormal tresword
snormal 'REPLACE'           snormal tresword
snormal 'RIGHT'             snormal tresword
snormal 'ROUND'             snormal tresword
snormal 'RUNSUM'            snormal tresword
snormal 'SECOND'            snormal tresword
snormal 'SELECT'            snormal tresword
snormal 'SET'               snormal tresword
snormal 'SIZE'              snormal tresword
snormal 'SMALLINT'          snormal tresword
snormal 'SORT'              snormal tresword
snormal 'SPACE'             snormal tresword
snormal 'STOP'              snormal tresword
snormal 'SUBSTRING'         snormal tresword
snormal 'SUM'               snormal tresword
snormal 'TABLE'             snormal tresword
snormal 'TEXT'              snormal tresword
snormal 'TEXTOCCURS'        snormal tresword
snormal 'TEXTSEARCH'        snormal tresword
snormal 'THEN'              snormal tresword
snormal 'TIME'              snormal tresword
snormal 'TIMESTAMP'         snormal tresword
snormal 'TO'                snormal tresword
snormal 'TOP'               snormal tresword
snormal 'TRAILBYTE'         snormal tresword
snormal 'TRAILING'          snormal tresword
snormal 'TRIM'              snormal tresword
snormal 'TRUE'              snormal tresword
snormal 'UNION'             snormal tresword
snormal 'UNIQUE'            snormal tresword
snormal 'UPDATE'            snormal tresword
snormal 'UPPER'             snormal tresword
snormal 'USER'              snormal tresword
snormal 'VALUES'            snormal tresword
snormal 'VARCHAR'           snormal tresword
snormal 'VERSION'           snormal tresword
snormal 'WEEK'              snormal tresword
snormal 'WHERE'             snormal tresword
snormal 'WITH'              snormal tresword
snormal 'WORD'              snormal tresword
snormal 'YEAR'              snormal tresword

// numbers
snormal [0-9][0-9]*                            snormal  tinteger
snormal [1-9][0-9]*\.[0-9]*                    snormal  tfloat
snormal [1-9][0-9]*{\.[0-9]+}|e{[\+\-]}|[0-9]+ snormal  tfloat

//idents
snormal   [a-