From 0b888d2a736b1b307da7bb412fc4beb151af0173 Mon Sep 17 00:00:00 2001
From: Peter Hormanns <peter.hormanns@jalin.de>
Date: Sat, 11 May 2013 17:52:53 +0200
Subject: [PATCH] prepare for moving basepacket foreign key

---
 hsarback/database/dropschema.sql |    3 ++-
 1 files changed, 2 insertions(+), 1 deletions(-)

diff --git a/hsarback/database/dropschema.sql b/hsarback/database/dropschema.sql
index 9b3690e..55bbc0e 100644
--- a/hsarback/database/dropschema.sql
+++ b/hsarback/database/dropschema.sql
@@ -25,7 +25,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,3 +36,4 @@
 DROP SEQUENCE inet_addr_inet_addr_id_seq ;
 DROP TABLE business_partner CASCADE ;
 DROP SEQUENCE business_partner_bp_id_seq ;
+-- DROP SEQUENCE packet_component_id_seq ;

--
Gitblit v1.9.0-SNAPSHOT