Contents

ace.define("ace/snippets/sql",["require","exports","module"],function(e,t,n){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"})

Version data entries

30 entries across 30 versions & 2 rubygems

Version	Path
smithycms-0.8.1	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.7.3	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.7.2	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.7.1	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.7.0	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.6.10	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.5.99.3	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.6.9	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.6.7	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.6.6	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.6.5	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.6.4	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.6.3	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.5.99.2	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.5.99.1	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.5.99	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.6.2	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.6.1	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.5.2	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js
smithycms-0.6.0	vendor/assets/javascripts/ace-1.1.3/snippets/sql.js