markdown格式wiki文档

sql.js 1.0KB

    define("ace/snippets/sql",["require","exports","module"], function(require, exports, module) { "use strict"; exports.snippetText = "snippet tbl\n\ create table ${1:table} (\n\ ${2:columns}\n\ );\n\ snippet col\n\ ${1:name} ${2:type} ${3:default ''} ${4:not null}\n\ snippet ccol\n\ ${1:name} varchar2(${2:size}) ${3:default ''} ${4:not null}\n\ snippet ncol\n\ ${1:name} number ${3:default 0} ${4:not null}\n\ snippet dcol\n\ ${1:name} date ${3:default sysdate} ${4:not null}\n\ snippet ind\n\ create index ${3:$1_$2} on ${1:table}(${2:column});\n\ snippet uind\n\ create unique index ${1:name} on ${2:table}(${3:column});\n\ snippet tblcom\n\ comment on table ${1:table} is '${2:comment}';\n\ snippet colcom\n\ comment on column ${1:table}.${2:column} is '${3:comment}';\n\ snippet addcol\n\ alter table ${1:table} add (${2:column} ${3:type});\n\ snippet seq\n\ create sequence ${1:name} start with ${2:1} increment by ${3:1} minvalue ${4:1};\n\ snippet s*\n\ select * from ${1:table}\n\ "; exports.scope = "sql"; });