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 |   11 +++++------
 1 files changed, 5 insertions(+), 6 deletions(-)

diff --git a/hsarback/database/dropschema.sql b/hsarback/database/dropschema.sql
index 6c53b28..b0bbbb8 100644
--- a/hsarback/database/dropschema.sql
+++ b/hsarback/database/dropschema.sql
@@ -1,11 +1,11 @@
 DROP TABLE pricelist_ref ;
 DROP TABLE price ;
-DROP TABLE price_list ;
+DROP TABLE price_list CASCADE ;
 -- DROP VIEW business_partner_ticket ;
 DROP TABLE sepa_mandat ;
 DROP SEQUENCE sepa_mandat_id_seq ;
-DROP TABLE contact ;
 DROP SEQUENCE contact_contact_id_seq ;
+DROP TABLE contact CASCADE ;
 DROP TABLE database ;
 DROP TABLE database_user ;
 DROP SEQUENCE database_database_id_seq ;
@@ -39,7 +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_i_seq ;
--- DROP SEQUENCE billdata_billdata_id_seq ;
--- DROP SEQUENCE member_id_seq ;
--- DROP SEQUENCE queue_queue_entry_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