From c464f55e9a53e10fe2d0cc25238b9d7ef1f94ab1 Mon Sep 17 00:00:00 2001
From: Peter Hormanns <peter.hormanns@hostsharing.net>
Date: Thu, 19 May 2011 13:06:51 +0200
Subject: [PATCH] complete test packages

---
 hsarback/database/data.sql |   37 ++++++++++++++++++++++++++++++++++++-
 1 files changed, 36 insertions(+), 1 deletions(-)

diff --git a/hsarback/database/data.sql b/hsarback/database/data.sql
index 7b5938c..fef5303 100644
--- a/hsarback/database/data.sql
+++ b/hsarback/database/data.sql
@@ -108,7 +108,42 @@
 		WHERE hive_name='h81' AND inet_addr = inet '192.168.108.201' AND member_id = 10000; 
 INSERT INTO packet (packet_name, bp_id, hive_id, created, cur_inet_addr_id)
 	SELECT 'hsh01', business_partner.bp_id, hive.hive_id, current_date, inet_addr.inet_addr_id FROM business_partner, hive, inet_addr 
-		WHERE hive_name='h81' AND inet_addr = inet '192.168.108.202' AND member_id = 10000; 
+		WHERE hive_name='h81' AND inet_addr = inet '192.168.108.202' AND member_id = 10000;
+		
+--
+-- table: packet_component 
+--
+INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
+	SELECT 1, 1, packet.packet_id, 2, current_date FROM packet 
+		WHERE packet.packet_name = 'hsh00'; 
+INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
+	SELECT 1, 2, packet.packet_id, 128, current_date FROM packet 
+		WHERE packet.packet_name = 'hsh00'; 
+INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
+	SELECT 1, 3, packet.packet_id, 0, current_date FROM packet 
+		WHERE packet.packet_name = 'hsh00'; 
+INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
+	SELECT 1, 4, packet.packet_id, 0, current_date FROM packet 
+		WHERE packet.packet_name = 'hsh00'; 
+INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
+	SELECT 1, 5, packet.packet_id, 0, current_date FROM packet 
+		WHERE packet.packet_name = 'hsh00'; 
+INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
+	SELECT 1, 1, packet.packet_id, 2, current_date FROM packet 
+		WHERE packet.packet_name = 'hsh01'; 
+INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
+	SELECT 1, 2, packet.packet_id, 128, current_date FROM packet 
+		WHERE packet.packet_name = 'hsh01'; 
+INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
+	SELECT 1, 3, packet.packet_id, 0, current_date FROM packet 
+		WHERE packet.packet_name = 'hsh01'; 
+INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
+	SELECT 1, 4, packet.packet_id, 0, current_date FROM packet 
+		WHERE packet.packet_name = 'hsh01'; 
+INSERT INTO packet_component (basepacket_id, basecomponent_id, packet_id, quantity, created)
+	SELECT 1, 5, packet.packet_id, 0, current_date FROM packet 
+		WHERE packet.packet_name = 'hsh01'; 
+
 --
 -- table: unixuser 
 --

--
Gitblit v1.9.1