6 DROP TABLE dispatchlist;
19 CREATE UNIQUE INDEX "article_id" on "article" using btree ( article );
20 CREATE INDEX "article_name" on "article" using btree ( name );
23 articleid VARCHAR(12),
34 CREATE UNIQUE INDEX "offer_id" on "offer" using btree ( articleid );
35 CREATE INDEX "offer_offer" on "offer" using btree ( article );
36 CREATE INDEX "offer_name" on "offer" using btree ( subname );
39 articleid VARCHAR(12),
43 CREATE INDEX "spool_id" on "spool" using btree ( articleid );
45 CREATE TABLE customer (
58 CREATE UNIQUE INDEX "customer_id" on "customer" using btree ( customer );
60 CREATE TABLE dispatch (
65 CREATE UNIQUE INDEX "dispatch_id" on "dispatch" using btree ( dispatch );
67 CREATE TABLE dispatchlist (
69 articleid varchar(12),
73 CREATE INDEX "dispatchlist_orderid" on "dispatchlist" using btree ( dispatch );
74 CREATE INDEX "dispatchlist_artid" on "dispatchlist" using btree ( articleid );
82 CREATE INDEX "status_disp" on "status" using btree ( dispatch );
85 REVOKE ALL on "article" from PUBLIC;
86 GRANT ALL on "article" to "www";
87 GRANT ALL on "article" to "joey";
89 REVOKE ALL on "offer" from PUBLIC;
90 GRANT ALL on "offer" to "www";
91 GRANT ALL on "offer" to "joey";
93 REVOKE ALL on "dispatch" from PUBLIC;
94 GRANT ALL on "dispatch" to "www";
95 GRANT ALL on "dispatch" to "joey";
97 REVOKE ALL on "dispatchlist" from PUBLIC;
98 GRANT ALL on "dispatchlist" to "www";
99 GRANT ALL on "dispatchlist" to "joey";
101 REVOKE ALL on "customer" from PUBLIC;
102 GRANT ALL on "customer" to "www";
103 GRANT ALL on "customer" to "joey";
105 REVOKE ALL on "spool" from PUBLIC;
106 GRANT ALL on "spool" to "www";
107 GRANT ALL on "spool" to "joey";
109 REVOKE ALL on "status" from PUBLIC;
110 GRANT ALL on "status" to "www";
111 GRANT ALL on "status" to "joey";