corrade-nucleus-nucleons
/script-kiddie/002_script_kiddie/script-kiddie/node_modules/ace-builds/src/snippets/sql.js |
@@ -0,0 +1,33 @@ |
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"; |
|
}); |