summaryrefslogtreecommitdiff
path: root/sql/data/Terms.sql.template
diff options
context:
space:
mode:
Diffstat (limited to 'sql/data/Terms.sql.template')
-rw-r--r--sql/data/Terms.sql.template9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/data/Terms.sql.template b/sql/data/Terms.sql.template
new file mode 100644
index 0000000..b9c8252
--- /dev/null
+++ b/sql/data/Terms.sql.template
@@ -0,0 +1,9 @@
+USE [@initial.catalog@];
+
+SET IDENTITY_INSERT @initial.catalog@.dbo.Terms ON
+insert into [dbo].[Terms]([TermsID],[Description],[DueDays]) values (1,'Net due 10 days',10);
+insert into [dbo].[Terms]([TermsID],[Description],[DueDays]) values (2,'Net due 20 days',20);
+insert into [dbo].[Terms]([TermsID],[Description],[DueDays]) values (3,'Net due 30 days',30);
+insert into [dbo].[Terms]([TermsID],[Description],[DueDays]) values (4,'Net due 60 days',60);
+insert into [dbo].[Terms]([TermsID],[Description],[DueDays]) values (5,'Net due 90 days',90);
+SET IDENTITY_INSERT @initial.catalog@.dbo.Terms OFF \ No newline at end of file