From 5c0c111a6552fdf310dd3b9d99c959b8746d7c99 Mon Sep 17 00:00:00 2001
From: Peter Hormanns <peter.hormanns@jalin.de>
Date: Mon, 10 Apr 2017 18:40:55 +0200
Subject: [PATCH] update schema for member_shares

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

diff --git a/hsarback/database/data.sql b/hsarback/database/data.sql
index 62c7b66..84ad030 100644
--- a/hsarback/database/data.sql
+++ b/hsarback/database/data.sql
@@ -87,14 +87,6 @@
 	SELECT bp_id, 'Herr', 'Uwe', 'Mueller', 'Hostsharing eG', 'service@hostsharing.net' FROM business_partner WHERE member_id=10000;
 
 --
--- table: bank_account 
---
-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 
 --
 INSERT INTO inet_addr (inet_addr, description)
@@ -207,11 +199,11 @@
 --
 -- table: price_list
 --
-INSERT INTO price_list VALUES (1, 'Default Price List');
+INSERT INTO price_list (name) VALUES ('Default Price List');
 
 --
 -- table: customer_price_list_mapping
 --
-INSERT INTO customer_price_list_mapping (SELECT bp_id, 1 FROM business_partner);
+INSERT INTO pricelist_ref (SELECT business_partner.bp_id, price_list.name FROM business_partner, price_list);
 
 

--
Gitblit v1.9.0-SNAPSHOT