summaryrefslogtreecommitdiffstats
path: root/misc/syntax/sql.syntax
diff options
context:
space:
mode:
Diffstat (limited to 'misc/syntax/sql.syntax')
-rw-r--r--misc/syntax/sql.syntax367
1 files changed, 367 insertions, 0 deletions
diff --git a/misc/syntax/sql.syntax b/misc/syntax/sql.syntax
new file mode 100644
index 0000000..000bfe1
--- /dev/null
+++ b/misc/syntax/sql.syntax
@@ -0,0 +1,367 @@
+# SQL syntax highlighting for CoolEdit
+# by Walery Studennikov <despair@sama.ru>
+
+caseinsensitive
+
+context default
+ keyword whole abort yellow
+ keyword whole absolute yellow
+ keyword whole action yellow
+ keyword whole ada yellow
+ keyword whole add yellow
+ keyword whole all yellow
+ keyword whole allocate yellow
+ keyword whole alter yellow
+ keyword whole and yellow
+ keyword whole any yellow
+ keyword whole are yellow
+ keyword whole as yellow
+ keyword whole asc yellow
+ keyword whole assertion yellow
+ keyword whole at yellow
+ keyword whole authorization yellow
+ keyword whole auto_increment yellow
+ keyword whole begin yellow
+ keyword whole between yellow
+ keyword whole bigint yellow
+ keyword whole bit yellow
+ keyword whole bit_length yellow
+ keyword whole blob yellow
+ keyword whole both yellow
+ keyword whole by yellow
+ keyword whole cascade yellow
+ keyword whole cascaded yellow
+ keyword whole case yellow
+ keyword whole cast yellow
+ keyword whole catalog yellow
+ keyword whole char yellow
+ keyword whole char_length yellow
+ keyword whole character yellow
+ keyword whole character_length yellow
+ keyword whole check yellow
+ keyword whole close yellow
+ keyword whole coalesce yellow
+ keyword whole collate yellow
+ keyword whole collation yellow
+ keyword whole column yellow
+ keyword whole comment yellow
+ keyword whole commit yellow
+ keyword whole compile yellow
+ keyword whole connect yellow
+ keyword whole connection yellow
+ keyword whole constraint yellow
+ keyword whole constraint yellow
+ keyword whole constraints yellow
+ keyword whole continue yellow
+ keyword whole copy yellow
+ keyword whole corresponding yellow
+ keyword whole create yellow
+ keyword whole cross yellow
+ keyword whole count yellow
+ keyword whole current yellow
+ keyword whole current_date yellow
+ keyword whole current_time yellow
+ keyword whole current_timestamp yellow
+ keyword whole current_user yellow
+ keyword whole cursor yellow
+ keyword whole database yellow
+ keyword whole date yellow
+ keyword whole datetime yellow
+ keyword whole day yellow
+ keyword whole deallocate yellow
+ keyword whole dec yellow
+ keyword whole decimal yellow
+ keyword whole declare yellow
+ keyword whole default yellow
+ keyword whole deferrable yellow
+ keyword whole deferred yellow
+ keyword whole delete yellow
+ keyword whole desc yellow
+ keyword whole describe yellow
+ keyword whole descriptor yellow
+ keyword whole diagnostics yellow
+ keyword whole disconnect yellow
+ keyword whole distinct yellow
+ keyword whole domain yellow
+ keyword whole double yellow
+ keyword whole drop yellow
+ keyword whole else yellow
+ keyword whole elsif yellow
+ keyword whole encoding yellow
+ keyword whole end yellow
+ keyword whole end-exec yellow
+ keyword whole enum yellow
+ keyword whole escape yellow
+ keyword whole except yellow
+ keyword whole exception yellow
+ keyword whole exec yellow
+ keyword whole execute yellow
+ keyword whole exists yellow
+ keyword whole external yellow
+ keyword whole extract yellow
+ keyword whole false yellow
+ keyword whole fetch yellow
+ keyword whole first yellow
+ keyword whole float yellow
+ keyword whole for yellow
+ keyword whole foreign yellow
+ keyword whole fortran yellow
+ keyword whole found yellow
+ keyword whole from yellow
+ keyword whole full yellow
+ keyword whole function yellow
+ keyword whole get yellow
+ keyword whole global yellow
+ keyword whole go yellow
+ keyword whole goto yellow
+ keyword whole grant yellow
+ keyword whole group yellow
+ keyword whole having yellow
+ keyword whole hour yellow
+ keyword whole identity yellow
+ keyword whole if yellow
+ keyword whole immediate yellow
+ keyword whole in yellow
+ keyword whole include yellow
+ keyword whole index yellow
+ keyword whole indicator yellow
+ keyword whole initially yellow
+ keyword whole inner yellow
+ keyword whole input yellow
+ keyword whole insensitive yellow
+ keyword whole insert yellow
+ keyword whole int yellow
+ keyword whole integer yellow
+ keyword whole intersect yellow
+ keyword whole interval yellow
+ keyword whole into yellow
+ keyword whole is yellow
+ keyword whole isolation yellow
+ keyword whole join yellow
+ keyword whole key yellow
+ keyword whole key yellow
+ keyword whole language yellow
+ keyword whole last yellow
+ keyword whole leading yellow
+ keyword whole left yellow
+ keyword whole level yellow
+ keyword whole like yellow
+ keyword whole local yellow
+ keyword whole lock yellow
+ keyword whole longblob yellow
+ keyword whole longtext yellow
+ keyword whole loop yellow
+ keyword whole min yellow
+ keyword whole match yellow
+ keyword whole max yellow
+ keyword whole mediumblob yellow
+ keyword whole mediumint yellow
+ keyword whole mediumtext yellow
+ keyword whole merge yellow
+ keyword whole minute yellow
+ keyword whole minus yellow
+ keyword whole module yellow
+ keyword whole month yellow
+ keyword whole names yellow
+ keyword whole national yellow
+ keyword whole natural yellow
+ keyword whole nchar yellow
+ keyword whole next yellow
+ keyword whole no yellow
+ keyword whole none yellow
+ keyword whole not yellow
+ keyword whole null yellow
+ keyword whole nullif yellow
+ keyword whole number yellow
+ keyword whole numeric yellow
+ keyword whole octet_length yellow
+ keyword whole of yellow
+ keyword whole offline yellow
+ keyword whole on yellow
+ keyword whole online yellow
+ keyword whole only yellow
+ keyword whole open yellow
+ keyword whole option yellow
+ keyword whole or yellow
+ keyword whole order yellow
+ keyword whole out yellow
+ keyword whole outer yellow
+ keyword whole output yellow
+ keyword whole overlaps yellow
+ keyword whole pad yellow
+ keyword whole partial yellow
+ keyword whole pascal yellow
+ keyword whole position yellow
+ keyword whole precision yellow
+ keyword whole prepare yellow
+ keyword whole preserve yellow
+ keyword whole primary yellow
+ keyword whole primary yellow
+ keyword whole prior yellow
+ keyword whole privileges yellow
+ keyword whole procedure yellow
+ keyword whole public yellow
+ keyword whole raise yellow
+ keyword whole read yellow
+ keyword whole real yellow
+ keyword whole rebuild yellow
+ keyword whole references yellow
+ keyword whole relative yellow
+ keyword whole rename yellow
+ keyword whole replace yellow
+ keyword whole restrict yellow
+ keyword whole revoke yellow
+ keyword whole right yellow
+ keyword whole rollback yellow
+ keyword whole round yellow
+ keyword whole rows yellow
+ keyword whole schema yellow
+ keyword whole scroll yellow
+ keyword whole second yellow
+ keyword whole section yellow
+ keyword whole select yellow
+ keyword whole sequence yellow
+ keyword whole session yellow
+ keyword whole session_user yellow
+ keyword whole set yellow
+ keyword whole size yellow
+ keyword whole smallint yellow
+ keyword whole some yellow
+ keyword whole space yellow
+ keyword whole sql yellow
+ keyword whole sqlca yellow
+ keyword whole sqlstate yellow
+ keyword whole sqlwarning yellow
+ keyword whole substring yellow
+ keyword whole sum yellow
+ keyword whole system_user yellow
+ keyword whole table yellow
+ keyword whole tablespace yellow
+ keyword whole template yellow
+ keyword whole temporary yellow
+ keyword whole text yellow
+ keyword whole then yellow
+ keyword whole time yellow
+ keyword whole truncate yellow
+ keyword whole timestamp yellow
+ keyword whole timezone_hour yellow
+ keyword whole timezone_minute yellow
+ keyword whole tinyblob yellow
+ keyword whole tinyint yellow
+ keyword whole tinytext yellow
+ keyword whole to yellow
+ keyword whole trailing yellow
+ keyword whole transaction yellow
+ keyword whole translation yellow
+ keyword whole trigger yellow
+ keyword whole trim yellow
+ keyword whole true yellow
+ keyword whole type yellow
+ keyword whole union yellow
+ keyword whole unique yellow
+ keyword whole unknown yellow
+ keyword whole unsigned yellow
+ keyword whole update yellow
+ keyword whole usage yellow
+ keyword whole use yellow
+ keyword whole user yellow
+ keyword whole using yellow
+ keyword whole value yellow
+ keyword whole values yellow
+ keyword whole varchar yellow
+ keyword whole varying yellow
+ keyword whole view yellow
+ keyword whole when yellow
+ keyword whole whenever yellow
+ keyword whole where yellow
+ keyword whole while yellow
+ keyword whole with yellow
+ keyword whole work yellow
+ keyword whole write yellow
+ keyword whole year yellow
+ keyword whole zone yellow
+
+ keyword /\* brown
+ keyword \*/ brown
+ keyword -- brown
+
+ keyword > brightcyan
+ keyword < brightcyan
+ keyword \+ brightcyan
+ keyword - brightcyan
+ keyword \* brightcyan
+ keyword / brightcyan
+ keyword % brightcyan
+ keyword = brightcyan
+ keyword ( brightcyan
+ keyword ) brightcyan
+ keyword , brightcyan
+ keyword ; brightcyan
+ keyword . white
+
+# PostgreSQL specific
+ keyword aggregate yellow
+ keyword checkpoint yellow
+ keyword cluster yellow
+ keyword conversion yellow
+ keyword listen yellow
+ keyword notify yellow
+ keyword operator yellow
+ keyword reindex yellow
+ keyword savepoint yellow
+ keyword unlisten yellow
+ keyword vacuum yellow
+
+ keyword createdb white
+ keyword createuser white
+ keyword nocreatedb white
+ keyword nocreateuser white
+ keyword password white
+ keyword sysid white
+
+ keyword currval white
+ keyword nextval white
+ keyword pg_database white
+ keyword pg_group white
+ keyword pg_shadow white
+ keyword setval white
+ keyword stdin white
+
+# PostgreSQL sequences
+ keyword cache white
+ keyword increment white
+ keyword maxvalue white
+ keyword minvalue white
+ keyword start white
+
+# Oracle specific
+ keyword dual white
+ keyword whole lag yellow
+ keyword whole lead yellow
+ keyword whole nvl yellow
+ keyword whole over yellow
+ keyword whole partition yellow
+ keyword whole pragma yellow
+ keyword whole varchar2 yellow
+ keyword whole sys_refcursor yellow
+
+# MySQL comment
+context linestart # \n brown
+ spellcheck
+
+# ANSI SQL comment
+context exclusive -- \n brown
+ spellcheck
+
+context exclusive /\* \*/ brown
+ spellcheck
+
+context ' ' green
+ keyword \\' green
+
+context " " green
+ keyword \\" green
+
+# Beckticks are used to escape reserved words in MySQL
+context ` ` cyan
+ keyword . white