aboutsummaryrefslogtreecommitdiff
path: root/vim/bundle/vim-snippets/snippets/sql.snippets
diff options
context:
space:
mode:
authorKarel Kočí <cynerd@email.cz>2016-06-30 16:03:25 +0200
committerKarel Kočí <cynerd@email.cz>2016-06-30 16:03:25 +0200
commite573b3020c032400eed60b649a2cbf55266e6bb0 (patch)
tree8f572394ac8433529c7a8e70d160a2fbe8268b4e /vim/bundle/vim-snippets/snippets/sql.snippets
parentb8c667bd64b3edd38d56c63c5bd1db53a23b4499 (diff)
downloadmyconfigs-e573b3020c032400eed60b649a2cbf55266e6bb0.tar.gz
myconfigs-e573b3020c032400eed60b649a2cbf55266e6bb0.tar.bz2
myconfigs-e573b3020c032400eed60b649a2cbf55266e6bb0.zip
Add current configurations from old repository
Diffstat (limited to 'vim/bundle/vim-snippets/snippets/sql.snippets')
-rw-r--r--vim/bundle/vim-snippets/snippets/sql.snippets26
1 files changed, 26 insertions, 0 deletions
diff --git a/vim/bundle/vim-snippets/snippets/sql.snippets b/vim/bundle/vim-snippets/snippets/sql.snippets
new file mode 100644
index 0000000..556fae0
--- /dev/null
+++ b/vim/bundle/vim-snippets/snippets/sql.snippets
@@ -0,0 +1,26 @@
+snippet tbl
+ create table ${1:table} (
+ ${0:columns}
+ );
+snippet col
+ ${1:name} ${2:type} ${3:default ''} ${0:not null}
+snippet ccol
+ ${1:name} varchar2(${2:size}) ${3:default ''} ${0:not null}
+snippet ncol
+ ${1:name} number ${3:default 0} ${0:not null}
+snippet dcol
+ ${1:name} date ${3:default sysdate} ${0:not null}
+snippet ind
+ create index ${0:$1_$2} on ${1:table}(${2:column});
+snippet uind
+ create unique index ${1:name} on ${2:table}(${0:column});
+snippet tblcom
+ comment on table ${1:table} is '${0:comment}';
+snippet colcom
+ comment on column ${1:table}.${2:column} is '${0:comment}';
+snippet addcol
+ alter table ${1:table} add (${2:column} ${0:type});
+snippet seq
+ create sequence ${1:name} start with ${2:1} increment by ${3:1} minvalue ${0:1};
+snippet s*
+ select * from ${0:table}