From c9f5e29792b89edafec6305b7a587b17c72f822a Mon Sep 17 00:00:00 2001
From: Peter Hormanns <peter.hormanns@jalin.de>
Date: Wed, 01 May 2013 13:51:55 +0200
Subject: [PATCH] data and test for pac.add SRV/MDG

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

diff --git a/hsarback/database/data.sql b/hsarback/database/data.sql
index 4aa7a45..ad2c5fb 100644
--- a/hsarback/database/data.sql
+++ b/hsarback/database/data.sql
@@ -25,6 +25,10 @@
 	VALUES ('MIRROR', 'Echtzeitspiegelung der Daten', 500, true);
 INSERT INTO basecomponent (basecomponent_code, description, sorting, valid)
 	VALUES ('BACKUP', 'Nächtliches Backup', 600, true);
+INSERT INTO basecomponent (basecomponent_code, description, sorting, valid)
+	VALUES ('DISK', 'Nächtliches Backup', 700, true);
+INSERT INTO basecomponent (basecomponent_code, description, sorting, valid)
+	VALUES ('CPU', 'Nächtliches Backup', 800, true);
 
 --
 -- Table: component
@@ -65,7 +69,13 @@
 	SELECT basepacket_id, basecomponent_id, 0, 1, 1, 1, 1, false, 205 FROM basepacket, basecomponent WHERE basepacket_code='PAC/SW' AND  basecomponent_code='BACKUP';
 INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number)
 	SELECT basepacket_id, basecomponent_id, 0, 1, 1, 1, 1, false, 305 FROM basepacket, basecomponent WHERE basepacket_code='PAC/WEB' AND  basecomponent_code='BACKUP';
-
+INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number)
+	SELECT basepacket_id, basecomponent_id, 25, 100, 25, 25, 0, false, 410 FROM basepacket, basecomponent WHERE basepacket_code='SRV/MGD' AND  basecomponent_code='DISK';
+INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number)
+	SELECT basepacket_id, basecomponent_id, 1, 16, 1, 1, 0, false, 420 FROM basepacket, basecomponent WHERE basepacket_code='SRV/MGD' AND  basecomponent_code='CPU';
+INSERT INTO component (basepacket_id, basecomponent_id, min_quantity, max_quantity, default_quantity, increment_quantity, include_quantity, admin_only, article_number)
+	SELECT basepacket_id, basecomponent_id, 10, 1000, 10, 10, 0, false, 430 FROM basepacket, basecomponent WHERE basepacket_code='SRV/MGD' AND  basecomponent_code='TRAFFIC';
+	
 --
 -- Table: business_partner 
 --

--
Gitblit v1.9.3