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