File: //usr/share/joe/syntax/sql.jsf
# JOE syntax highlight file for SQL
# See c.jsf for more documentation
=Idle
=Ident
=Bad
=Comment
=Constant
=String +Constant
=Number +Constant
=Character +String
=Boolean +Constant
=Escape
=StringEscape +Escape +String
=CharacterEscape +StringEscape
=Type
=Keyword
=Statement +Keyword
=Brace
=Control
:idle Idle
* idle
"\n" idle
"#" line_comment recolor=-1
"/" slash
"-" dash
"0" first_digit recolor=-1
"1-9" decimal recolor=-1
"." maybe_float
"\"" string recolor=-1
"'" char recolor=-1
"\i@" ident buffer
"{}" brace recolor=-1
",:;=()><[]*&|!~+%^" control recolor=-1
:brace Brace
* idle noeat
:control Control
* idle noeat
:slash Idle
* idle noeat recolor=-2 # Not sure about this
"*" comment recolor=-2
"/" line_comment recolor=-2
:dash Idle
* idle noeat recolor=-2 # Not sure about this
"-" line_comment recolor=-2
:comment Comment comment
* comment
"*" maybe_end_comment
"BFHNTX" comment noeat call=comment_todo.comment_todo()
:maybe_end_comment Comment comment
* comment noeat
"/" idle
"*" maybe_end_comment
:line_comment Comment comment
* line_comment
"BFHNTX" line_comment noeat call=comment_todo.comment_todo()
"\n" idle
:first_digit Number
* idle noeat
"xX" hex
"." float
"eE" epart
"0-7" octal
"89" bad_number recolor=-1
:bad_number Bad
* idle noeat
"0-9" bad_number
:octal Number
* idle noeat
"0-7" octal
"89" bad_number recolor=-1
:hex Number
* idle noeat
"0-9A-Fa-f" hex
:decimal Number
* idle noeat
"0-9" decimal
"eE" epart
"." float
:maybe_float Number
* idle recolor=-2 noeat
"0-9" float recolor=-2
:float Number
* idle noeat
"eE" epart
"0-9" float
:epart Number
* idle noeat
"0-9+\-" enum
:enum Number
* idle noeat
"0-9" enum
:string String string
* string
"\"" idle
"\\" string_escape recolor=-1
"%" string_control recolor=-1
:string_escape StringEscape string
* string
"x" string_hex1
"0-7" string_octal2
"\n" string recolor=-2
:string_hex1 StringEscape string
* string noeat
"0-9a-fA-F" string_hex2
:string_hex2 StringEscape string
* string noeat
"0-9a-fA-F" string
:string_octal2 StringEscape string
* string noeat
"0-7" string_octal3
:string_octal3 StringEscape string
* string noeat
"0-7" string
:string_control StringEscape string
* string
"\"" string noeat
"\n" idle
"0-9.\-+ #hjILtz$" string_control
:char Character string
* char
"\n" idle
"'" idle
"\\" char_escape recolor=-1
:char_escape CharacterEscape string
* char
"x" char_hex1
"0-7" char_octal2
"\n" char recolor=-2
:char_hex1 CharacterEscape string
* char noeat
"0-9a-fA-F" char_hex2
:char_hex2 CharacterEscape string
* char noeat
"0-9a-fA-F" char
:char_octal2 CharacterEscape string
* char noeat
"0-7" char_octal3
:char_octal3 CharacterEscape string
* char noeat
"0-7" char
:ident Ident
* idle noeat istrings
"absolute" kw
"add" kw
"admindb" kw
"all" kw
"alphanumeric" kw
"alter" stmt
"and" kw
"any" kw
"are" kw
"as" kw
"asc" kw
"assertion" kw
"authorization" kw
"autoincrement" kw
"avg" kw
"begin" kw
"between" kw
"binary" type
"bit" type
"bit_length" kw
"boolean" type
"both" kw
"by" kw
"byte" kw
"cascade" kw
"catalog" kw
"char," type
"character" type
"character_length" kw
"char_length" kw
"check" kw
"clause" kw
"close" kw
"clustered" kw
"coalesce" kw
"collate" kw
"collation" kw
"column" kw
"commit" kw
"comp," kw
"compression" kw
"connect" kw
"connection" kw
"constraint," kw
"constraints" kw
"container" kw
"contains" kw
"convert" kw
"count" kw
"counter" kw
"create" stmt
"currency" kw
"current_date" kw
"current_time" kw
"current_timestamp" kw
"current_user" kw
"cursor" kw
"d" kw
"database" kw
"date" type
"datetime" type
"day" type
"dec," type
"decimal" type
"declare" kw
"delete" stmt
"desc" kw
"disallow" kw
"disconnect" kw
"distinct" kw
"distinctrow" kw
"domain" kw
"double" kw
"drop" stmt
"eqv" kw
"exclusiveconnect" kw
"exec," kw
"execute" kw
"exists" kw
"extract" kw
"false" bool
"fetch" kw
"first" kw
"float," type
"float4" type
"float8" type
"foreign" kw
"from" kw
"general" kw
"grant" kw
"group" kw
"guid" kw
"having" kw
"hour" kw
"i" kw
"identity" kw
"ieeedouble" kw
"ieeesingle" kw
"ignore" kw
"image" kw
"imp" kw
"in" kw
"in" kw
"index" kw
"indexcreatedb" kw
"inner" kw
"input" kw
"insensitive" kw
"insert" stmt
"int," type
"integer," type
"integer1" type
"integer2" type
"integer4" type
"interval" kw
"into" stmt
"is" kw
"isolation" kw
"join" kw
"key" kw
"language" kw
"last" kw
"left" kw
"level" kw
"like" kw
"logical," kw
"logical1" kw
"long" type
"longbinary" type
"longchar" type
"longtext" type
"lower" kw
"match" kw
"max" kw
"memo" kw
"min" kw
"minute" kw
"mod" kw
"money" type
"month" type
"national" kw
"nchar" type
"nonclustered" kw
"not" kw
"ntext" kw
"null" kw
"number" kw
"numeric" kw
"nvarchar" type
"octet_length" kw
"oleobject" kw
"on" kw
"open" kw
"option" kw
"or" kw
"order" kw
"outer" kw
"output" kw
"owneraccess" kw
"pad" kw
"parameters" kw
"partial" kw
"password" kw
"percent" kw
"pivot" kw
"position" kw
"precision" kw
"prepare" kw
"primary" kw
"privileges" kw
"proc," kw
"procedure" kw
"public" kw
"real" type
"references" kw
"restrict" kw
"revoke" kw
"right" kw
"rollback" kw
"schema" kw
"second" kw
"select" stmt
"selectschema" kw
"selectsecurity" kw
"set" stmt
"short" kw
"single" kw
"size" kw
"smalldatetime" type
"smallint" type
"smallmoney" type
"some" kw
"space" kw
"sql" kw
"sqlcode," kw
"sqlerror," kw
"sqlstate" kw
"stdev" kw
"stdevp" kw
"string" kw
"substring" kw
"sum" kw
"sysname" kw
"system_user" kw
"table" kw
"tableid" kw
"temporary" kw
"text" kw
"time" type
"timestamp" type
"timezone_hour" kw
"timezone_minute" kw
"tinyint" type
"to" kw
"top" kw
"trailing" kw
"transaction" kw
"transform" kw
"translate" kw
"translation" kw
"trim" kw
"true" bool
"union" kw
"unique" kw
"uniqueidentifier" kw
"unknown" kw
"update" stmt
"updateidentity" kw
"updateowner" kw
"updatesecurity" kw
"upper" kw
"usage" kw
"user" kw
"using" kw
"value" kw
"values" kw
"var" kw
"varbinary" kw
"varchar" type
"varp" kw
"varying" kw
"view" kw
"when" kw
"whenever" kw
"where" kw
"with" kw
"work" kw
"xor" kw
"year" type
"yesno" kw
"zone" kw
"begin" kw
"end" kw
# T-SQl
"if" kw
"then" kw
"else" kw
"print" kw
"case" kw
"go" kw
"cross" kw
"exec" kw
"use" kw
# mysql
"int" type
"char" type
"default" kw
"type" kw
"float" type
"begint" type
"mediumint" type
"longint" type
"blob" type
"tinyblob" type
"mediumblob" type
"longblob" type
"tinytext" type
"mediumtext" type
"longtext" type
"show" kw
"explain" kw
"enum" type
done
"\c" ident
:type Type
* idle noeat
:kw Keyword
* idle noeat
:bool Boolean
* idle noeat
:stmt Statement
* idle noeat