SF.net SVN: ledger-smb:[6501] trunk/sql

[..hidden..]

Revision: 6501
          http://sourceforge.net/p/ledger-smb/code/6501
Author:   einhverfr
Date:     2014-01-17 09:56:22 +0000 (Fri, 17 Jan 2014)
Log Message:
-----------
fixing foreign key on new_shipto table

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

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2014-01-17 08:10:49 UTC (rev 6500)
+++ trunk/sql/Pg-database.sql	2014-01-17 09:56:22 UTC (rev 6501)
@@ -3632,7 +3632,7 @@
 
 CREATE TABLE new_shipto (
 	id serial primary key,
-	trans_id int references journal_entry(id),
+	trans_id int references transactions(id),
 	oe_id int references oe(id),
 	location_id int references location(id)
 );

Modified: trunk/sql/modules/Fixes.sql
===================================================================
--- trunk/sql/modules/Fixes.sql	2014-01-17 08:10:49 UTC (rev 6500)
+++ trunk/sql/modules/Fixes.sql	2014-01-17 09:56:22 UTC (rev 6501)
@@ -326,4 +326,9 @@
 BEGIN;
 INSERT INTO taxmodule (taxmodule_id, taxmodulename) values (2, 'Rounded');
 COMMIT;
+
+BEGIN;
+ALTER TABLE new_shipto DROP CONSTRAINT new_shipto_trans_id_fkey;
+ALTER TABLE new_shipto ADD FOREIGN KEY (trans_id) REFERENCES transactions(id);
+COMMIT;
 -- Beta 4 fixes below

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


------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today. 
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits