| 1 |
editAreaLoader.load_syntax["sql"] = { |
| 2 |
'DISPLAY_NAME' : 'SQL' |
| 3 |
,'COMMENT_SINGLE' : {1 : '--'} |
| 4 |
,'COMMENT_MULTI' : {'/*' : '*/'} |
| 5 |
,'QUOTEMARKS' : {1: "'", 2: '"', 3: '`'} |
| 6 |
,'KEYWORD_CASE_SENSITIVE' : false |
| 7 |
,'KEYWORDS' : { |
| 8 |
'statements' : [ |
| 9 |
'select', 'SELECT', 'where', 'order', 'by', |
| 10 |
'insert', 'from', 'update', 'grant', 'left join', 'right join', |
| 11 |
'union', 'group', 'having', 'limit', 'alter', 'LIKE','IN','CASE' |
| 12 |
] |
| 13 |
,'reserved' : [ |
| 14 |
'null', 'enum', 'int', 'boolean', 'add', 'varchar' |
| 15 |
|
| 16 |
] |
| 17 |
,'functions' : [ |
| 18 |
'ABS','ACOS','ADDDATE','ADDTIME','AES_DECRYPT','AES_ENCRYPT','ASCII','ASIN','ATAN2 ATAN','ATAN','AVG','BENCHMARK','DISTINCT','BIN','BIT_AND','BIT_COUNT','BIT_LENGTH','BIT_OR','BIT_XOR','CAST','CEILING CEIL','CHAR_LENGTH','CHAR', |
| 19 |
'CHARACTER_LENGTH','CHARSET','COALESCE','COERCIBILITY','COLLATION','COMPRESS','CONCAT_WS','CONCAT','CONNECTION_ID','CONV','CONVERT_TZ','COS','COT','COUNT','CRC32','CURDATE','CURRENT_DATE','CURRENT_TIME','CURRENT_TIMESTAMP','CURRENT_USER','CURTIME','DATABASE','DATE_ADD','DATE_FORMAT','DATE_SUB','DATE','DATEDIFF','DAY','DAYNAME','DAYOFMONTH', |
| 20 |
'DAYOFWEEK','DAYOFYEAR','DECODE','DEFAULT','DEGREES','DES_DECRYPT','DES_ENCRYPT','ELT','ENCODE','ENCRYPT','EXP','EXPORT_SET','EXTRACT','FIELD','FIND_IN_SET','FLOOR','FORMAT','FOUND_ROWS','FROM_DAYS','FROM_UNIXTIME','GET_FORMAT','GET_LOCK','GREATEST','GROUP_CONCAT','HEX','HOUR','IF','IFNULL','INET_ATON','INET_NTOA', |
| 21 |
'INSERT','INSTR','INTERVAL','IS_FREE_LOCK','IS_USED_LOCK','ISNULL','LAST_DAY','LAST_INSERT_ID','LCASE','LEAST','LEFT','LENGTH','LN','LOAD_FILE','LOCALTIME','LOCALTIMESTAMP','LOCATE','LOG10','LOG2','LOG','LOWER','LPAD','LTRIM','MAKE_SET','MAKEDATE','MAKETIME','MASTER_POS_WAIT','MAX','MD5','MICROSECOND', |
| 22 |
'MID','MIN','MINUTE','MOD','MONTH','MONTHNAME','NOW','NULLIF','OCT','OCTET_LENGTH','OLD_PASSWORD','ORD','PASSWORD','PERIOD_ADD','PERIOD_DIFF','PI','POSITION','POW','POWER','PROCEDURE ANALYSE','QUARTER','QUOTE','RADIANS','RAND','RELEASE_LOCK','REPEAT','REPLACE','REVERSE','RIGHT','ROUND', |
| 23 |
'RPAD','RTRIM','SEC_TO_TIME','SECOND','SESSION_USER','SHA1','SHA','SIGN','SIN','SOUNDEX','SOUNDS LIKE','SPACE','SQRT','STD','STDDEV','STR_TO_DATE','STRCMP','SUBDATE','SUBSTRING_INDEX','SUBSTRING','SUBSTR','SUBTIME','SUM','SYSDATE','SYSTEM_USER','TAN','TIME_FORMAT','TIME_TO_SEC','TIME','TIMEDIFF', |
| 24 |
'TIMESTAMP','TO_DAYS','TRIM','TRUNCATE','UCASE','UNCOMPRESS','UNCOMPRESSED_LENGTH','UNHEX','UNIX_TIMESTAMP','UPPER','USER','UTC_DATE','UTC_TIME','UTC_TIMESTAMP','UUID','VALUES','VARIANCE','WEEK','WEEKDAY','WEEKOFYEAR','YEAR','YEARWEEK' |
| 25 |
] |
| 26 |
} |
| 27 |
,'OPERATORS' :[ |
| 28 |
'AND','&&','BETWEEN','BINARY','&','|','^','/','DIV','<=>','=','>=','>','<<','>>','IS','NULL','<=','<','-','%','!=','<>','!','||','OR','+','REGEXP','RLIKE','XOR','~','*' |
| 29 |
] |
| 30 |
,'DELIMITERS' :[ |
| 31 |
'(', ')', '[', ']', '{', '}' |
| 32 |
] |
| 33 |
,'REGEXPS' : { |
| 34 |
// highlight all variables (@...) |
| 35 |
'variables' : { |
| 36 |
'search' : '()(\\@\\w+)()' |
| 37 |
,'class' : 'variables' |
| 38 |
,'modifiers' : 'g' |
| 39 |
,'execute' : 'before' // before or after |
| 40 |
} |
| 41 |
} |
| 42 |
,'STYLES' : { |
| 43 |
'COMMENTS': 'color: #AAAAAA;' |
| 44 |
,'QUOTESMARKS': 'color: #879EFA;' |
| 45 |
,'KEYWORDS' : { |
| 46 |
'reserved' : 'color: #48BDDF;' |
| 47 |
,'functions' : 'color: #0040FD;' |
| 48 |
,'statements' : 'color: #60CA00;' |
| 49 |
} |
| 50 |
,'OPERATORS' : 'color: #FF00FF;' |
| 51 |
,'DELIMITERS' : 'color: #2B60FF;' |
| 52 |
,'REGEXPS' : { |
| 53 |
'variables' : 'color: #E0BD54;' |
| 54 |
} |
| 55 |
} |
| 56 |
}; |
| 57 |
|
