All snippets imported, init file polished

6 files changed, 38 insertions, 0 deletions

diff --git a/.emacs.d/mysnippets/text-mode/sql-mode/column b/.emacs.d/mysnippets/text-mode/sql-mode/column
new file mode 100644
index 0000000..90e4963
--- /dev/null
+++ b/.emacs.d/mysnippets/text-mode/sql-mode/column
@@ -0,0 +1,4 @@
+#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx>
+#name : , ColumnName ColumnType NOT NULL...
+# --
+        ,       ${1:Name}               ${2:Type}                       ${3:NOT NULL}
diff --git a/.emacs.d/mysnippets/text-mode/sql-mode/constraint b/.emacs.d/mysnippets/text-mode/sql-mode/constraint
new file mode 100644
index 0000000..989e508
--- /dev/null
+++ b/.emacs.d/mysnippets/text-mode/sql-mode/constraint
@@ -0,0 +1,4 @@
+#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx>
+#name : CONSTRAINT [..] PRIMARY KEY ...
+# --
+CONSTRAINT [${1:PK_Name}] PRIMARY KEY ${2:CLUSTERED} ([${3:ColumnName}]) 
diff --git a/.emacs.d/mysnippets/text-mode/sql-mode/constraint.1 b/.emacs.d/mysnippets/text-mode/sql-mode/constraint.1
new file mode 100644
index 0000000..98d89f0
--- /dev/null
+++ b/.emacs.d/mysnippets/text-mode/sql-mode/constraint.1
@@ -0,0 +1,4 @@
+#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx>
+#name : CONSTRAINT [..] FOREIGN KEY ...
+# --
+CONSTRAINT [${1:FK_Name}] FOREIGN KEY ${2:CLUSTERED} ([${3:ColumnName}]) 
diff --git a/.emacs.d/mysnippets/text-mode/sql-mode/create b/.emacs.d/mysnippets/text-mode/sql-mode/create
new file mode 100644
index 0000000..a34624d
--- /dev/null
+++ b/.emacs.d/mysnippets/text-mode/sql-mode/create
@@ -0,0 +1,10 @@
+#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx>
+#name : create table ...
+# --
+CREATE TABLE [${1:dbo}].[${2:TableName}] 
+(
+                ${3:Id}         ${4:INT IDENTITY(1,1)}          ${5:NOT NULL}
+$0
+        CONSTRAINT [${6:PK_}] PRIMARY KEY ${7:CLUSTERED} ([$3]) 
+)
+GO
diff --git a/.emacs.d/mysnippets/text-mode/sql-mode/create.1 b/.emacs.d/mysnippets/text-mode/sql-mode/create.1
new file mode 100644
index 0000000..1323daf
--- /dev/null
+++ b/.emacs.d/mysnippets/text-mode/sql-mode/create.1
@@ -0,0 +1,12 @@
+#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx>
+#name : create procedure ...
+# --
+CREATE PROCEDURE [${1:dbo}].[${2:Name}] 
+(
+                $3              $4              = ${5:NULL}             ${6:OUTPUT}
+)
+AS
+BEGIN
+$0
+END
+GO
diff --git a/.emacs.d/mysnippets/text-mode/sql-mode/references b/.emacs.d/mysnippets/text-mode/sql-mode/references
new file mode 100644
index 0000000..f2e4eab
--- /dev/null
+++ b/.emacs.d/mysnippets/text-mode/sql-mode/references
@@ -0,0 +1,4 @@
+#contributor : Alejandro Espinoza Esparza <aespinoza@structum.com.mx>
+#name : REFERENCES ...
+# --
+REFERENCES ${1:TableName}([${2:ColumnName}])