diff options
author | Einer von Vielen <tomwie@users.sourceforge.net> | 2016-07-31 18:05:16 +0200 |
---|---|---|
committer | Einer von Vielen <tomwie@users.sourceforge.net> | 2016-07-31 18:05:16 +0200 |
commit | 215659a234dd253210c9f57d5000fe1b57cffe0b (patch) | |
tree | 2c0f3f06c22933a536e6922de287599b8e788b09 /library/ace/snippets/sql.js | |
parent | c0e0379bab601fa0594fee8da37872eaf111d20a (diff) | |
parent | 287e9c8d68a670ebc98942a6e9a52abaa80b1094 (diff) | |
download | volse-hubzilla-215659a234dd253210c9f57d5000fe1b57cffe0b.tar.gz volse-hubzilla-215659a234dd253210c9f57d5000fe1b57cffe0b.tar.bz2 volse-hubzilla-215659a234dd253210c9f57d5000fe1b57cffe0b.zip |
Merge remote-tracking branch 'mikemaster/master'
Diffstat (limited to 'library/ace/snippets/sql.js')
-rw-r--r-- | library/ace/snippets/sql.js | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/library/ace/snippets/sql.js b/library/ace/snippets/sql.js new file mode 100644 index 000000000..1bacce06d --- /dev/null +++ b/library/ace/snippets/sql.js @@ -0,0 +1 @@ +ace.define("ace/snippets/sql",["require","exports","module"],function(e,t,n){"use strict";t.snippetText="snippet tbl\n create table ${1:table} (\n ${2:columns}\n );\nsnippet col\n ${1:name} ${2:type} ${3:default ''} ${4:not null}\nsnippet ccol\n ${1:name} varchar2(${2:size}) ${3:default ''} ${4:not null}\nsnippet ncol\n ${1:name} number ${3:default 0} ${4:not null}\nsnippet dcol\n ${1:name} date ${3:default sysdate} ${4:not null}\nsnippet ind\n create index ${3:$1_$2} on ${1:table}(${2:column});\nsnippet uind\n create unique index ${1:name} on ${2:table}(${3:column});\nsnippet tblcom\n comment on table ${1:table} is '${2:comment}';\nsnippet colcom\n comment on column ${1:table}.${2:column} is '${3:comment}';\nsnippet addcol\n alter table ${1:table} add (${2:column} ${3:type});\nsnippet seq\n create sequence ${1:name} start with ${2:1} increment by ${3:1} minvalue ${4:1};\nsnippet s*\n select * from ${1:table}\n",t.scope="sql"})
\ No newline at end of file |