diff options
Diffstat (limited to 'sql/data/Terms.sql.template')
| -rw-r--r-- | sql/data/Terms.sql.template | 9 |
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 |
