sql.jsf (7372B)
1 # JOE syntax highlight file for SQL 2 3 # See c.jsf for more documentation 4 5 =Idle 6 =Ident 7 =Bad 8 =Comment 9 =Constant 10 =String +Constant 11 =Number +Constant 12 =Character +String 13 =Boolean +Constant 14 =Escape 15 =StringEscape +Escape +String 16 =CharacterEscape +StringEscape 17 =Type 18 =Keyword 19 =Statement +Keyword 20 =Brace 21 =Control 22 23 :idle Idle 24 * idle 25 "\n" idle 26 "#" line_comment recolor=-1 27 "/" slash 28 "-" dash 29 "0" first_digit recolor=-1 30 "1-9" decimal recolor=-1 31 "." maybe_float 32 "\"" string recolor=-1 33 "'" char recolor=-1 34 "\i@" ident buffer 35 "{}" brace recolor=-1 36 ",:;=()><[]*&|!~+%^" control recolor=-1 37 38 :brace Brace 39 * idle noeat 40 41 :control Control 42 * idle noeat 43 44 :slash Idle 45 * idle noeat recolor=-2 # Not sure about this 46 "*" comment recolor=-2 47 "/" line_comment recolor=-2 48 49 :dash Idle 50 * idle noeat recolor=-2 # Not sure about this 51 "-" line_comment recolor=-2 52 53 :comment Comment comment 54 * comment 55 "*" maybe_end_comment 56 "BFHNTX" comment noeat call=comment_todo.comment_todo() 57 58 :maybe_end_comment Comment comment 59 * comment noeat 60 "/" idle 61 "*" maybe_end_comment 62 63 :line_comment Comment comment 64 * line_comment 65 "BFHNTX" line_comment noeat call=comment_todo.comment_todo() 66 "\n" idle 67 68 :first_digit Number 69 * idle noeat 70 "xX" hex 71 "." float 72 "eE" epart 73 "0-7" octal 74 "89" bad_number recolor=-1 75 76 :bad_number Bad 77 * idle noeat 78 "0-9" bad_number 79 80 :octal Number 81 * idle noeat 82 "0-7" octal 83 "89" bad_number recolor=-1 84 85 :hex Number 86 * idle noeat 87 "0-9A-Fa-f" hex 88 89 :decimal Number 90 * idle noeat 91 "0-9" decimal 92 "eE" epart 93 "." float 94 95 :maybe_float Number 96 * idle recolor=-2 noeat 97 "0-9" float recolor=-2 98 99 :float Number 100 * idle noeat 101 "eE" epart 102 "0-9" float 103 104 :epart Number 105 * idle noeat 106 "0-9+\-" enum 107 108 :enum Number 109 * idle noeat 110 "0-9" enum 111 112 :string String string 113 * string 114 "\"" idle 115 "\\" string_escape recolor=-1 116 "%" string_control recolor=-1 117 118 :string_escape StringEscape string 119 * string 120 "x" string_hex1 121 "0-7" string_octal2 122 "\n" string recolor=-2 123 124 :string_hex1 StringEscape string 125 * string noeat 126 "0-9a-fA-F" string_hex2 127 128 :string_hex2 StringEscape string 129 * string noeat 130 "0-9a-fA-F" string 131 132 :string_octal2 StringEscape string 133 * string noeat 134 "0-7" string_octal3 135 136 :string_octal3 StringEscape string 137 * string noeat 138 "0-7" string 139 140 :string_control StringEscape string 141 * string 142 "\"" string noeat 143 "\n" idle 144 "0-9.\-+ #hjILtz$" string_control 145 146 :char Character string 147 * char 148 "\n" idle 149 "'" idle 150 "\\" char_escape recolor=-1 151 152 :char_escape CharacterEscape string 153 * char 154 "x" char_hex1 155 "0-7" char_octal2 156 "\n" char recolor=-2 157 158 :char_hex1 CharacterEscape string 159 * char noeat 160 "0-9a-fA-F" char_hex2 161 162 :char_hex2 CharacterEscape string 163 * char noeat 164 "0-9a-fA-F" char 165 166 :char_octal2 CharacterEscape string 167 * char noeat 168 "0-7" char_octal3 169 170 :char_octal3 CharacterEscape string 171 * char noeat 172 "0-7" char 173 174 :ident Ident 175 * idle noeat istrings 176 "absolute" kw 177 "add" kw 178 "admindb" kw 179 "all" kw 180 "alphanumeric" kw 181 "alter" stmt 182 "and" kw 183 "any" kw 184 "are" kw 185 "as" kw 186 "asc" kw 187 "assertion" kw 188 "authorization" kw 189 "autoincrement" kw 190 "avg" kw 191 "begin" kw 192 "between" kw 193 "binary" type 194 "bit" type 195 "bit_length" kw 196 "boolean" type 197 "both" kw 198 "by" kw 199 "byte" kw 200 "cascade" kw 201 "catalog" kw 202 "char," type 203 "character" type 204 "character_length" kw 205 "char_length" kw 206 "check" kw 207 "clause" kw 208 "close" kw 209 "clustered" kw 210 "coalesce" kw 211 "collate" kw 212 "collation" kw 213 "column" kw 214 "commit" kw 215 "comp," kw 216 "compression" kw 217 "connect" kw 218 "connection" kw 219 "constraint," kw 220 "constraints" kw 221 "container" kw 222 "contains" kw 223 "convert" kw 224 "count" kw 225 "counter" kw 226 "create" stmt 227 "currency" kw 228 "current_date" kw 229 "current_time" kw 230 "current_timestamp" kw 231 "current_user" kw 232 "cursor" kw 233 "d" kw 234 "database" kw 235 "date" type 236 "datetime" type 237 "day" type 238 "dec," type 239 "decimal" type 240 "declare" kw 241 "delete" stmt 242 "desc" kw 243 "disallow" kw 244 "disconnect" kw 245 "distinct" kw 246 "distinctrow" kw 247 "domain" kw 248 "double" kw 249 "drop" stmt 250 "eqv" kw 251 "exclusiveconnect" kw 252 "exec," kw 253 "execute" kw 254 "exists" kw 255 "extract" kw 256 "false" bool 257 "fetch" kw 258 "first" kw 259 "float," type 260 "float4" type 261 "float8" type 262 "foreign" kw 263 "from" kw 264 "general" kw 265 "grant" kw 266 "group" kw 267 "guid" kw 268 "having" kw 269 "hour" kw 270 "i" kw 271 "identity" kw 272 "ieeedouble" kw 273 "ieeesingle" kw 274 "ignore" kw 275 "image" kw 276 "imp" kw 277 "in" kw 278 "in" kw 279 "index" kw 280 "indexcreatedb" kw 281 "inner" kw 282 "input" kw 283 "insensitive" kw 284 "insert" stmt 285 "int," type 286 "integer," type 287 "integer1" type 288 "integer2" type 289 "integer4" type 290 "interval" kw 291 "into" stmt 292 "is" kw 293 "isolation" kw 294 "join" kw 295 "key" kw 296 "language" kw 297 "last" kw 298 "left" kw 299 "level" kw 300 "like" kw 301 "logical," kw 302 "logical1" kw 303 "long" type 304 "longbinary" type 305 "longchar" type 306 "longtext" type 307 "lower" kw 308 "match" kw 309 "max" kw 310 "memo" kw 311 "min" kw 312 "minute" kw 313 "mod" kw 314 "money" type 315 "month" type 316 "national" kw 317 "nchar" type 318 "nonclustered" kw 319 "not" kw 320 "ntext" kw 321 "null" kw 322 "number" kw 323 "numeric" kw 324 "nvarchar" type 325 "octet_length" kw 326 "oleobject" kw 327 "on" kw 328 "open" kw 329 "option" kw 330 "or" kw 331 "order" kw 332 "outer" kw 333 "output" kw 334 "owneraccess" kw 335 "pad" kw 336 "parameters" kw 337 "partial" kw 338 "password" kw 339 "percent" kw 340 "pivot" kw 341 "position" kw 342 "precision" kw 343 "prepare" kw 344 "primary" kw 345 "privileges" kw 346 "proc," kw 347 "procedure" kw 348 "public" kw 349 "real" type 350 "references" kw 351 "restrict" kw 352 "revoke" kw 353 "right" kw 354 "rollback" kw 355 "schema" kw 356 "second" kw 357 "select" stmt 358 "selectschema" kw 359 "selectsecurity" kw 360 "set" stmt 361 "short" kw 362 "single" kw 363 "size" kw 364 "smalldatetime" type 365 "smallint" type 366 "smallmoney" type 367 "some" kw 368 "space" kw 369 "sql" kw 370 "sqlcode," kw 371 "sqlerror," kw 372 "sqlstate" kw 373 "stdev" kw 374 "stdevp" kw 375 "string" kw 376 "substring" kw 377 "sum" kw 378 "sysname" kw 379 "system_user" kw 380 "table" kw 381 "tableid" kw 382 "temporary" kw 383 "text" kw 384 "time" type 385 "timestamp" type 386 "timezone_hour" kw 387 "timezone_minute" kw 388 "tinyint" type 389 "to" kw 390 "top" kw 391 "trailing" kw 392 "transaction" kw 393 "transform" kw 394 "translate" kw 395 "translation" kw 396 "trim" kw 397 "true" bool 398 "union" kw 399 "unique" kw 400 "uniqueidentifier" kw 401 "unknown" kw 402 "update" stmt 403 "updateidentity" kw 404 "updateowner" kw 405 "updatesecurity" kw 406 "upper" kw 407 "usage" kw 408 "user" kw 409 "using" kw 410 "value" kw 411 "values" kw 412 "var" kw 413 "varbinary" kw 414 "varchar" type 415 "varp" kw 416 "varying" kw 417 "view" kw 418 "when" kw 419 "whenever" kw 420 "where" kw 421 "with" kw 422 "work" kw 423 "xor" kw 424 "year" type 425 "yesno" kw 426 "zone" kw 427 "begin" kw 428 "end" kw 429 # T-SQl 430 "if" kw 431 "then" kw 432 "else" kw 433 "print" kw 434 "case" kw 435 "go" kw 436 "cross" kw 437 "exec" kw 438 "use" kw 439 # mysql 440 "int" type 441 "char" type 442 "default" kw 443 "type" kw 444 "float" type 445 "begint" type 446 "mediumint" type 447 "longint" type 448 "blob" type 449 "tinyblob" type 450 "mediumblob" type 451 "longblob" type 452 "tinytext" type 453 "mediumtext" type 454 "longtext" type 455 "show" kw 456 "explain" kw 457 "enum" type 458 done 459 "\c" ident 460 461 :type Type 462 * idle noeat 463 464 :kw Keyword 465 * idle noeat 466 467 :bool Boolean 468 * idle noeat 469 470 :stmt Statement 471 * idle noeat