From 522b89c5372746a79c500578967c3e8ba276320a Mon Sep 17 00:00:00 2001
From: Peter Hormanns <peter.hormanns@jalin.de>
Date: Mon, 13 May 2013 19:52:13 +0200
Subject: [PATCH] refactoring of database on pac-components

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

diff --git a/hsarback/database/data.sql b/hsarback/database/data.sql
index e759383..9d49f19 100644
--- a/hsarback/database/data.sql
+++ b/hsarback/database/data.sql
@@ -141,13 +141,13 @@
 	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 
+	SELECT 1, 3, packet.packet_id, 1, 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 
+	SELECT 1, 4, packet.packet_id, 1, 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 
+	SELECT 1, 5, packet.packet_id, 1, 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 
@@ -156,13 +156,13 @@
 	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 
+	SELECT 1, 3, packet.packet_id, 1, 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 
+	SELECT 1, 4, packet.packet_id, 1, 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 
+	SELECT 1, 5, packet.packet_id, 1, current_date FROM packet 
 		WHERE packet.packet_name = 'hsh01'; 
 
 --

--
Gitblit v1.9.0-SNAPSHOT