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 |   26 ++++++++++++++++++--------
 1 files changed, 18 insertions(+), 8 deletions(-)

diff --git a/hsarback/database/dropschema.sql b/hsarback/database/dropschema.sql
index 139a193..b0bbbb8 100644
--- a/hsarback/database/dropschema.sql
+++ b/hsarback/database/dropschema.sql
@@ -1,9 +1,11 @@
-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 pricelist_ref ;
+DROP TABLE price ;
+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 ;
@@ -11,9 +13,12 @@
 DROP TABLE emailaddr ;
 DROP SEQUENCE emailaddr_emailaddr_id_seq ;
 DROP TABLE emailalias ;
-DROP SEQUENCE  emailalias_emailalias_id_seq ;
+DROP SEQUENCE emailalias_emailalias_id_seq ;
 DROP TABLE queue_task ;
 DROP SEQUENCE queue_task_id_seq ;
+DROP TABLE domain__domain_option ;
+DROP TABLE domain_option ;
+DROP SEQUENCE domain_option_id_seq ;
 DROP TABLE domain ;
 DROP SEQUENCE domain_domain_id_seq ;
 DROP TABLE unixuser ;
@@ -21,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 ;
@@ -30,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