<!DOCTYPE Highlight>
<Highlight wildcards="*.sql" name="MY/SQL">

 <Items>
  <Text                style=""   color="#000000" />
  <Keyword             style=""   color="#0000ff" />
  <String              style=""   color="#008000" />
  <Char                style=""   color="#ff00ff" />
  <Memo                style="i"  color="#ff0000" />
  <EscapedChar   style=""  color="#F08050" />
 </Items>

 <Break>

  <normal>
   <citem item="" regexp="--.*"        mode="until, include" lineEndContent="normal" />
   <citem item="" regexp="/\*"         mode="until, include" lineEndContent="multiLineComment" />
   <citem item="" regexp="'"           mode="until, include" lineEndContent="string2" />
   <citem item="" regexp="$"           mode="until" />
  </normal>

  <string1>
   <citem item="" regexp="([^&quot;\\]|\\.)+" />
   <citem item="" regexp="&quot;" mode="until, exclude, allowfull" />
   <citem item="" regexp="&quot;" lineEndContent="normal" />
  </string1>

  <string2>
   <citem item="" regexp="([^'\\]|\\.)+" />
   <citem item="" regexp="'" mode="until, exclude, allowfull" />
   <citem item="" regexp="'" lineEndContent="normal" />
  </string2>

  <multiLineComment>
   <citem item="" regexp="\*/" mode="until, exclude, allowfull"/>
   <citem item="" regexp="\*/" lineEndContent="normal" />
  </multiLineComment>

 </Break>

 <Contents>

  <normal>
   <citem item="Text" regexp="\s+" />

   <citem item="Keyword" regexp="\w+" keyword="
 add 
 all 
 alter 
 analyze 
 and 
 as 
 asc 
 asensitive 
 auto_increment  
 bdb 
 before 
 berkeleydb 
 between 
 bigint 
 binary 
 blob 
 both 
 by 
 call 
 cascade 
 case 
 change 
 char 
 character 
 check 
 collate 
 column 
 columns 
 condition 
 connection 
 constraint 
 continue 
 create 
 cross 
 current_date 
 current_time 
 current_timestamp 
 cursor 
 database 
 databases  
 day_hour 
 day_microsecond 
 day_minute 
 day_second 
 dec 
 decimal 
 declare 
 default 
 delayed 
 delete 
 desc 
 describe 
 distinct 
 distinctrow 
 div 
 double 
 drop  
 else 
 elseif 
 enclosed 
 escaped 
 exists 
 exit 
 explain 
 false 
 fetch 
 fields 
 float 
 for 
 force 
 foreign 
 found 
 frac_second 
 from 
 fulltext 
 grant 
 group 
 having 
 high_priority 
 hour_microsecond 
 hour_minute 
 hour_second 
 if 
 ignore 
 in 
 index 
 infile 
 inner 
 innodb 
 inout 
 insensitive 
 insert 
 int 
 integer 
 interval 
 into 
 io_thread 
 is 
 iterate 
 join 
 key 
 keys 
 kill 
 leading 
 leave 
 left 
 like 
 limit  
 lines 
 load 
 localtime 
 localtimestamp 
 lock 
 long 
 longblob 
 longtext 
 loop 
 low_priority 
 master_server_id 
 match 
 mediumblob 
 mediumint 
 mediumtext 
 middleint 
 minute_microsecond 
 minute_second 
 mod 
 natural 
 not 
 no_write_to_binlog 
 null 
 numeric 
 on 
 optimize 
 option 
 optionally 
 or 
 order 
 out 
 outer 
 outfile 
 precision 
 primary 
 privileges 
 procedure 
 purge 
 read  
 real 
 references 
 regexp 
 rename 
 repeat 
 replace 
 require 
 restrict 
 return 
 returns 
 revoke 
 right  
 rlike 
 second_microsecond 
 select 
 sensitive 
 separator 
 set 
 show 
 smallint 
 some 
 soname 
 spatial 
 specific 
 sql 
 sqlexception 
 sqlstate 
 sqlwarning 
 sql_big_result 
 sql_calc_found_rows 
 sql_small_result 
 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 
 starting 
 straight_join 
 striped 
 table 
 tables 
 terminated 
 then 
 timestampadd 
 timestampdiff 
 tinyblob 
 tinyint 
 tinytext 
 to 
 trailing 
 true 
 types 
 undo 
 union 
 unique 
 unlock 
 unsigned 
 update 
 usage 
 use 
 user_resources 
 using 
 utc_date 
 utc_time 
 utc_timestamp 
 values 
 varbinary 
 varchar 
 varcharacter 
 varying 
 when 
 where 
 while 
 with 
 write 
 xor 
 year_month 
 zerofill 
" caseSensitive="false"/>

   <citem item="Memo" regexp="--.*" />
   <citem item="Memo" regexp="/\*" lineEndContent="multiLineComment" />

   <citem item="String"  regexp="&quot;" lineEndContent="string1" />
   <citem item="String" regexp="'"      lineEndContent="string2" />

   <citem item="Text" regexp="[\w_]+" lineEndContent="normal" />
   <citem item="Text" regexp="\s+"    lineEndContent="normal" />
   <citem item="Text" regexp="\W"     lineEndContent="normal" />
  </normal>

  <string1>
   <citem item="String"    regexp="[^&quot;\\]+" />
   <citem item="Char"      regexp="\\." />
   <citem item="String"    regexp="&quot;" lineEndContent="normal" />
  </string1>

  <string2>
   <citem item="String"    regexp="[^'\\]+" />
   <citem item="Char"      regexp="\\." />
   <citem item="String"    regexp="'" lineEndContent="normal" />
  </string2>

  <multiLineComment>
   <citem item="Memo" regexp="\*/" mode="until, exclude, allowfull"/>
   <citem item="Memo" regexp="\*/" lineEndContent="normal" />
  </multiLineComment>

 </Contents>

</Highlight>
