1 files changed, 48 insertions, 0 deletions
diff --git a/sql/constraints.sql.template b/sql/constraints.sql.template
new file mode 100644
index 0000000..f2f1dd9
--- /dev/null
+++ b/sql/constraints.sql.template
@@ -0,0 +1,48 @@
+USE [@initial.catalog@]
+
+ALTER TABLE [dbo].[InvoiceLineItems]  WITH CHECK ADD  CONSTRAINT [FK_InvoiceLineItems_GLAccounts] FOREIGN KEY([AccountNo])
+REFERENCES [dbo].[GLAccounts] ([AccountNo])
+ON UPDATE CASCADE
+GO
+
+ALTER TABLE [dbo].[InvoiceLineItems] CHECK CONSTRAINT [FK_InvoiceLineItems_GLAccounts]
+GO
+
+ALTER TABLE [dbo].[InvoiceLineItems]  WITH CHECK ADD  CONSTRAINT [FK_InvoiceLineItems_Invoices] FOREIGN KEY([InvoiceID])
+REFERENCES [dbo].[Invoices] ([InvoiceID])
+ON UPDATE CASCADE
+ON DELETE CASCADE
+GO
+ALTER TABLE [dbo].[InvoiceLineItems] CHECK CONSTRAINT [FK_InvoiceLineItems_Invoices]
+GO
+
+ALTER TABLE [dbo].[Invoices]  WITH CHECK ADD  CONSTRAINT [FK_Invoices_Terms] FOREIGN KEY([TermsID])
+REFERENCES [dbo].[Terms] ([TermsID])
+GO
+ALTER TABLE [dbo].[Invoices] CHECK CONSTRAINT [FK_Invoices_Terms]
+GO
+
+ALTER TABLE [dbo].[Invoices]  WITH CHECK ADD  CONSTRAINT [FK_Invoices_Vendors] FOREIGN KEY([VendorID])
+REFERENCES [dbo].[Vendors] ([VendorID])
+GO
+ALTER TABLE [dbo].[Invoices] CHECK CONSTRAINT [FK_Invoices_Vendors]
+GO
+
+ALTER TABLE [dbo].[Vendors]  WITH CHECK ADD  CONSTRAINT [FK_Vendors_GLAccounts] FOREIGN KEY([DefaultAccountNo])
+REFERENCES [dbo].[GLAccounts] ([AccountNo])
+ON UPDATE CASCADE
+GO
+ALTER TABLE [dbo].[Vendors] CHECK CONSTRAINT [FK_Vendors_GLAccounts]
+GO
+
+ALTER TABLE [dbo].[Vendors]  WITH CHECK ADD  CONSTRAINT [FK_Vendors_States] FOREIGN KEY([State])
+REFERENCES [dbo].[States] ([StateCode])
+GO
+ALTER TABLE [dbo].[Vendors] CHECK CONSTRAINT [FK_Vendors_States]
+GO
+
+ALTER TABLE [dbo].[Vendors]  WITH CHECK ADD  CONSTRAINT [FK_Vendors_Terms] FOREIGN KEY([DefaultTermsID])
+REFERENCES [dbo].[Terms] ([TermsID])
+GO
+ALTER TABLE [dbo].[Vendors] CHECK CONSTRAINT [FK_Vendors_Terms]
+GO
+\ No newline at end of file