corrade-nucleus-nucleons – Blame information for rev 20

Subversion Repositories:
Rev:
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 });