Файл: js/ace/snippets/sql.js
Строк: 83
<?php
define('ace/snippets/sql', ['require', 'exports', 'module' ], function(require, exports, module) {
exports.snippetText = "snippet tbln
create table ${1:table} (n
${2:columns}n
);n
snippet coln
${1:name} ${2:type} ${3:default ''} ${4:not null}n
snippet ccoln
${1:name} varchar2(${2:size}) ${3:default ''} ${4:not null}n
snippet ncoln
${1:name} number ${3:default 0} ${4:not null}n
snippet dcoln
${1:name} date ${3:default sysdate} ${4:not null}n
snippet indn
create index ${3:$1_$2} on ${1:table}(${2:column});n
snippet uindn
create unique index ${1:name} on ${2:table}(${3:column});n
snippet tblcomn
comment on table ${1:table} is '${2:comment}';n
snippet colcomn
comment on column ${1:table}.${2:column} is '${3:comment}';n
snippet addcoln
alter table ${1:table} add (${2:column} ${3:type});n
snippet seqn
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";
});
?>