From: Joey Schulze <joey@infodrom.org>
Date: Mon, 11 Dec 2000 06:37:58 +0000 (+0000)
Subject: Korrektur der Datenbankschemata
X-Git-Url: https://git.infodrom.org/?p=infodrom.org%2Finfocon.infodrom.org;a=commitdiff_plain;h=4e870f2175f2b25409b035aecf1dfa8b497a5f8b

Korrektur der Datenbankschemata
---

diff --git a/misc/inserts b/misc/inserts
index ef5e50c..01002a0 100644
--- a/misc/inserts
+++ b/misc/inserts
@@ -21,20 +21,31 @@ INSERT INTO offer VALUES ('1010010303','10100103','12 Tassen' ,30.0,30.0,0.5,0.1
 INSERT INTO spool VALUES ('1010010101',10,2);
 INSERT INTO spool VALUES ('1010010102',20,2);
 INSERT INTO spool VALUES ('1010010103',34,6);
+INSERT INTO spool VALUES ('1010010104',34,6);
+INSERT INTO spool VALUES ('1010010105',34,6);
+INSERT INTO spool VALUES ('1010010201',10,2);
+INSERT INTO spool VALUES ('1010010202',20,2);
+INSERT INTO spool VALUES ('1010010203',34,6);
+INSERT INTO spool VALUES ('1010010204',0,6);
+INSERT INTO spool VALUES ('1010010205',4,6);
+INSERT INTO spool VALUES ('1010010301',10,2);
+INSERT INTO spool VALUES ('1010010302',20,2);
+INSERT INTO spool VALUES ('1010010303',3,6);
 
 INSERT INTO customer VALUES (1,'','Martin','Schulze','','Am Zollbaum 7','26129','Oldenburg','Germany','','fips');
 INSERT INTO customer VALUES (2,'','Juergen','Schulze','','Dorfmark 10','26389','Wilhelmshaven','Germany','','hurz');
 
-INSERT INTO dispatch VALUES (1,1,'Fri 04 Dec 00:00:00 1998 CET',3);
-INSERT INTO dispatch VALUES (2,2,'Thu 03 Dec 00:00:00 1998 CET',2);
-INSERT INTO dispatch VALUES (3,2,'Sun 06 Dec 00:00:00 1998 CET',0);
+INSERT INTO dispatch VALUES (1,1,'Fri 04 Dec 00:00:00 1998 CET');
+INSERT INTO dispatch VALUES (2,2,'Thu 03 Dec 00:00:00 1998 CET');
+INSERT INTO dispatch VALUES (3,2,'Sun 06 Dec 00:00:00 1998 CET');
 
 INSERT INTO dispatchlist VALUES (1,'1010010101',1,25.0);
 INSERT INTO dispatchlist VALUES (1,'1010010102',1,25.0);
 INSERT INTO dispatchlist VALUES (1,'1010010103',1,25.0);
-
 INSERT INTO dispatchlist VALUES (2,'1010010101',2,25.0);
 INSERT INTO dispatchlist VALUES (2,'1010010103',1,25.0);
-
 INSERT INTO dispatchlist VALUES (3,'1010010103',4,25.0);
 
+INSERT INTO status VALUES (1,0,'web','Fri 04 Dec 00:00:00 1998 CET');
+INSERT INTO status VALUES (2,0,'web','Thu 03 Dec 00:00:00 1998 CET');
+INSERT INTO status VALUES (3,0,'web','Sun 06 Dec 00:00:00 1998 CET');
diff --git a/misc/schemes b/misc/schemes
index 851bbac..be6cb86 100644
--- a/misc/schemes
+++ b/misc/schemes
@@ -4,6 +4,7 @@ DROP TABLE spool;
 DROP TABLE customer;
 DROP TABLE dispatch;
 DROP TABLE dispatchlist;
+DROP TABLE status;
 
 CREATE TABLE article (
 	article VARCHAR(10),
@@ -59,8 +60,7 @@ CREATE UNIQUE INDEX "customer_id" on "customer" using btree ( customer );
 CREATE TABLE dispatch (
 	dispatch int4,
 	customer int4,
-	date datetime,
-	status int4
+	date datetime
 );
 CREATE UNIQUE INDEX "dispatch_id" on "dispatch" using btree ( dispatch );
 
@@ -73,6 +73,15 @@ CREATE TABLE dispatchlist (
 CREATE  INDEX "dispatchlist_orderid" on "dispatchlist" using btree ( dispatch );
 CREATE  INDEX "dispatchlist_artid"   on "dispatchlist" using btree ( articleid );
 
+CREATE TABLE status (
+	dispatch int4,
+	status int4,
+	staff TEXT,
+	date datetime
+);
+CREATE  INDEX "status_disp" on "status" using btree ( dispatch );
+
+
 REVOKE ALL on "article" from PUBLIC;
 GRANT  ALL on "article" to "www";
 GRANT  ALL on "article" to "joey";
@@ -96,3 +105,7 @@ GRANT  ALL on "customer" to "joey";
 REVOKE ALL on "spool" from PUBLIC;
 GRANT  ALL on "spool" to "www";
 GRANT  ALL on "spool" to "joey";
+
+REVOKE ALL on "status" from PUBLIC;
+GRANT  ALL on "status" to "www";
+GRANT  ALL on "status" to "joey";