From c3f5a5b24843b960955dc4e5d092736b1de705fd Mon Sep 17 00:00:00 2001
From: Peter Hormanns <peter.hormanns@jalin.de>
Date: Sat, 17 May 2014 20:17:50 +0200
Subject: [PATCH] Spalten technical_contact, business_contact

---
 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 87008c1..dad7f9e 100644
--- a/hsarback/database/data.sql
+++ b/hsarback/database/data.sql
@@ -90,8 +90,9 @@
 -- table: bank_account 
 --
 INSERT INTO bank_account (bp_id, autodebit_ga, autodebit_ar, autodebit_op, 
-				bank_customer, bank_account, bank_code, bank_name)
-	SELECT bp_id, false, false, false, '', '', '', '' FROM business_partner WHERE member_id=10000;
+				bank_customer, bank_account, bank_code, bank_name, mandat_ref, mandat_signed, mandat_since)
+	SELECT bp_id, false, false, false, '', '', '', '', member_id, current_date, current_date 
+		FROM business_partner WHERE member_id=10000;
 
 --
 -- Table: inet_addr 

--
Gitblit v1.9.0-SNAPSHOT