From bde85859a33b0a9f6fd9a404e1e8ae81f378abf4 Mon Sep 17 00:00:00 2001
From: Peter Hormanns <peter.hormanns@jalin.de>
Date: Thu, 05 Jul 2018 15:10:39 +0200
Subject: [PATCH] fix test database

---
 hsarback/database/schema.sql     |    3 ++-
 hsarback/database/data.sql       |    4 ++--
 hsarback/database/dropschema.sql |    1 -
 3 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/hsarback/database/data.sql b/hsarback/database/data.sql
index 557e865..8c20fab 100644
--- a/hsarback/database/data.sql
+++ b/hsarback/database/data.sql
@@ -118,11 +118,11 @@
 INSERT INTO packet (packet_name, bp_id, hive_id, created, cur_inet_addr_id, free, basepacket_id)
 	SELECT 'hsh00', business_partner.bp_id, hive.hive_id, current_date, inet_addr.inet_addr_id, true, basepacket.basepacket_id 
 		FROM business_partner, hive, inet_addr, basepacket 
-		WHERE hive_name='h99' AND inet_addr = inet '176.9.242.72' AND member_id = 10000 AND basepacket.basepacket_code='PAC/DW'; 
+		WHERE hive_name='h99' AND inet_addr = inet '176.9.242.72' AND member_id = 10000 AND basepacket.basepacket_code='PAC/WEB'; 
 INSERT INTO packet (packet_name, bp_id, hive_id, created, cur_inet_addr_id, free, basepacket_id)
 	SELECT 'hsh01', business_partner.bp_id, hive.hive_id, current_date, inet_addr.inet_addr_id, true, basepacket.basepacket_id 
 		FROM business_partner, hive, inet_addr, basepacket 
-		WHERE hive_name='h99' AND inet_addr = inet '176.9.242.73' AND member_id = 10000 AND basepacket.basepacket_code='PAC/DW';
+		WHERE hive_name='h99' AND inet_addr = inet '176.9.242.73' AND member_id = 10000 AND basepacket.basepacket_code='PAC/WEB';
 		
 --
 -- table: packet_component 
diff --git a/hsarback/database/dropschema.sql b/hsarback/database/dropschema.sql
index 952fae5..1e001ee 100644
--- a/hsarback/database/dropschema.sql
+++ b/hsarback/database/dropschema.sql
@@ -23,7 +23,6 @@
 DROP SEQUENCE queue_task_id_seq ;
 DROP TABLE unixuser CASCADE ;
 DROP SEQUENCE unixuser_unixuser_id_seq ;
-DROP TABLE pac_administration CASCADE ; 
 DROP TABLE packet_component ;
 DROP TABLE component ;
 DROP TABLE basecomponent ;
diff --git a/hsarback/database/schema.sql b/hsarback/database/schema.sql
index 8d4f02d..5718095 100644
--- a/hsarback/database/schema.sql
+++ b/hsarback/database/schema.sql
@@ -318,7 +318,8 @@
     domain_since date,
     domain_dns_master character varying(64),
     domain_id integer DEFAULT nextval('domain_domain_id_seq'::regclass) NOT NULL,
-    domain_owner integer NOT NULL
+    domain_owner integer NOT NULL,
+    valid_subdomain_names character varying(256) DEFAULT 'www' NOT NULL
 );
 
 

--
Gitblit v1.9.0-SNAPSHOT