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 |   22 +++++++++++++---------
 1 files changed, 13 insertions(+), 9 deletions(-)

diff --git a/hsarback/database/dropschema.sql b/hsarback/database/dropschema.sql
index 5acf9e3..b0bbbb8 100644
--- a/hsarback/database/dropschema.sql
+++ b/hsarback/database/dropschema.sql
@@ -1,12 +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 billdata ;
-DROP SEQUENCE billdata_billdata_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 ;
@@ -27,7 +26,7 @@
 DROP TABLE packet_component ;
 DROP TABLE component ;
 DROP TABLE basecomponent ;
-DROP TABLE basepacket ;
+DROP TABLE basepacket CASCADE ;
 DROP SEQUENCE basecomponent_basecomponent_seq ;
 DROP SEQUENCE basepacket_basepacket_id_seq ;
 DROP TABLE packet ;
@@ -36,5 +35,10 @@
 DROP SEQUENCE hive_hive_id_seq ;
 DROP TABLE inet_addr ;
 DROP SEQUENCE inet_addr_inet_addr_id_seq ;
-DROP TABLE business_partner ;
+DROP TABLE business_partner CASCADE ;
 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