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