From 374a39bd9b2c44fbc0ea9f7e3b29fa6b30753c7a Mon Sep 17 00:00:00 2001
From: Peter Hormanns <peter.hormanns@jalin.de>
Date: Tue, 25 Nov 2014 14:37:29 +0100
Subject: [PATCH] fill mandatory columns in bank_account

---
 hsarback/database/data.sql |    5 +++--
 1 files changed, 3 insertions(+), 2 deletions(-)

diff --git a/hsarback/database/data.sql b/hsarback/database/data.sql
index f40ef64..62c7b66 100644
--- a/hsarback/database/data.sql
+++ b/hsarback/database/data.sql
@@ -89,10 +89,11 @@
 --
 -- table: bank_account 
 --
-INSERT INTO bank_account (bp_id, bank_customer, bank_account, bank_code, bank_name, mandat_ref, mandat_signed, mandat_since)
-	SELECT bp_id, '', '', '', '', member_id, current_date, current_date 
+INSERT INTO bank_account (bp_id, bank_customer, bank_account, bank_code, bank_name, bank_iban, bank_bic, mandat_ref, mandat_signed, mandat_since)
+	SELECT bp_id, '', '', '', '', 'DEXX', 'XXX', member_id, current_date, current_date 
 		FROM business_partner WHERE member_id=10000;
 
+		
 --
 -- Table: inet_addr 
 --

--
Gitblit v1.9.0-SNAPSHOT