corrade-nucleus-nucleons – Blame information for rev 20
?pathlinks?
Rev | Author | Line No. | Line |
---|---|---|---|
20 | office | 1 | ace.define("ace/snippets/sql",["require","exports","module"], function(require, exports, module) { |
2 | "use strict"; |
||
3 | |||
4 | exports.snippetText = "snippet tbl\n\ |
||
5 | create table ${1:table} (\n\ |
||
6 | ${2:columns}\n\ |
||
7 | );\n\ |
||
8 | snippet col\n\ |
||
9 | ${1:name} ${2:type} ${3:default ''} ${4:not null}\n\ |
||
10 | snippet ccol\n\ |
||
11 | ${1:name} varchar2(${2:size}) ${3:default ''} ${4:not null}\n\ |
||
12 | snippet ncol\n\ |
||
13 | ${1:name} number ${3:default 0} ${4:not null}\n\ |
||
14 | snippet dcol\n\ |
||
15 | ${1:name} date ${3:default sysdate} ${4:not null}\n\ |
||
16 | snippet ind\n\ |
||
17 | create index ${3:$1_$2} on ${1:table}(${2:column});\n\ |
||
18 | snippet uind\n\ |
||
19 | create unique index ${1:name} on ${2:table}(${3:column});\n\ |
||
20 | snippet tblcom\n\ |
||
21 | comment on table ${1:table} is '${2:comment}';\n\ |
||
22 | snippet colcom\n\ |
||
23 | comment on column ${1:table}.${2:column} is '${3:comment}';\n\ |
||
24 | snippet addcol\n\ |
||
25 | alter table ${1:table} add (${2:column} ${3:type});\n\ |
||
26 | snippet seq\n\ |
||
27 | create sequence ${1:name} start with ${2:1} increment by ${3:1} minvalue ${4:1};\n\ |
||
28 | snippet s*\n\ |
||
29 | select * from ${1:table}\n\ |
||
30 | "; |
||
31 | exports.scope = "sql"; |
||
32 | |||
33 | }); |