SF.net SVN: ledger-smb:[4132] branches/1.3/sql/modules/Fixes.sql

[..hidden..]

Revision: 4132
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4132&view=rev
Author:   einhverfr
Date:     2011-12-03 11:35:50 +0000 (Sat, 03 Dec 2011)
Log Message:
-----------
Correcting load error allowing null BIC's

Modified Paths:
--------------
    branches/1.3/sql/modules/Fixes.sql

Modified: branches/1.3/sql/modules/Fixes.sql
===================================================================
--- branches/1.3/sql/modules/Fixes.sql	2011-12-02 21:15:19 UTC (rev 4131)
+++ branches/1.3/sql/modules/Fixes.sql	2011-12-03 11:35:50 UTC (rev 4132)
@@ -56,5 +56,8 @@
 COMMIT;
 
 BEGIN;
+ALTER TABLE entity_bank_account DROP CONSTRAINT entity_bank_account_pkey;
 ALTER TABLE entity_bank_account ALTER COLUMN bic DROP NOT NULL;
+ALTER TABLE entity_bank_account ADD UNIQUE(bic,iban);
+CREATE UNIQUE INDEX eba_iban_null_bic_u ON entity_bank_account(iban) WHERE bic IS NULL;
 COMMIT;

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