From 330be9feefb6394479553be0e078b4c4df3cbff1 Mon Sep 17 00:00:00 2001
From: mo khan <mo@mokhan.ca>
Date: Sun, 26 Aug 2007 20:10:42 -0600
Subject: import from svn

---
 sql/constraints.sql.template | 48 ++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 48 insertions(+)
 create mode 100644 sql/constraints.sql.template

(limited to 'sql/constraints.sql.template')

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
-- 
cgit v1.2.3