From 799b5fac29747f287e0dd81796648715d182fab8 Mon Sep 17 00:00:00 2001
From: Peter Hormanns <peter.hormanns@jalin.de>
Date: Tue, 25 Nov 2014 14:40:23 +0100
Subject: [PATCH] drop new tables role, contactrole_ref

---
 hsarback/database/dropschema.sql |   14 +++++++++-----
 1 files changed, 9 insertions(+), 5 deletions(-)

diff --git a/hsarback/database/dropschema.sql b/hsarback/database/dropschema.sql
index 744718b..b0bbbb8 100644
--- a/hsarback/database/dropschema.sql
+++ b/hsarback/database/dropschema.sql
@@ -1,10 +1,11 @@
-DROP TABLE customer_price_list_mapping ;
+DROP TABLE pricelist_ref ;
 DROP TABLE price ;
-DROP TABLE price_list ;
-DROP TABLE bank_account ;
-DROP SEQUENCE bank_account_bank_account_id_seq ;
-DROP TABLE contact ;
+DROP TABLE price_list CASCADE ;
+-- DROP VIEW business_partner_ticket ;
+DROP TABLE sepa_mandat ;
+DROP SEQUENCE sepa_mandat_id_seq ;
 DROP SEQUENCE contact_contact_id_seq ;
+DROP TABLE contact CASCADE ;
 DROP TABLE database ;
 DROP TABLE database_user ;
 DROP SEQUENCE database_database_id_seq ;
@@ -38,3 +39,6 @@
 DROP SEQUENCE business_partner_bp_id_seq ;
 DROP SEQUENCE packet_component_id_seq ;
 DROP SEQUENCE component_id_seq ;
+DROP SEQUENCE bank_account_bank_account_id_seq;
+DROP TABLE contactrole_ref CASCADE ;
+DROP TABLE role CASCADE ;
\ No newline at end of file

--
Gitblit v1.9.0-SNAPSHOT