SF.net SVN: ledger-smb:[2500] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 2500
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2500&view=rev
Author:   einhverfr
Date:     2009-03-14 22:17:53 +0000 (Sat, 14 Mar 2009)

Log Message:
-----------
New shipto table included.  Soon all invoices will use it.  Not used by ar/ap transactions

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2009-03-14 22:16:12 UTC (rev 2499)
+++ trunk/sql/Pg-database.sql	2009-03-14 22:17:53 UTC (rev 2500)
@@ -2828,4 +2828,11 @@
 $$ This is a holding table and hence not a candidate for normalization.
 Jobs should be deleted from this table when they complete successfully.$$;
 
+CREATE TABLE new_shipto (
+	id serial primary key,
+	trans_id int references transactions(id),
+	oe_id int references oe(id),
+	location_id int references location(id)
+);
+
 commit;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.