6 DROP TABLE dispatchlist;
18 CREATE UNIQUE INDEX "article_id" on "article" using btree ( article );
19 CREATE INDEX "article_name" on "article" using btree ( name );
22 articleid VARCHAR(12),
33 CREATE UNIQUE INDEX "offer_id" on "offer" using btree ( articleid );
34 CREATE INDEX "offer_offer" on "offer" using btree ( article );
35 CREATE INDEX "offer_name" on "offer" using btree ( subname );
38 articleid VARCHAR(12),
42 CREATE INDEX "spool_id" on "spool" using btree ( articleid );
44 CREATE TABLE customer (
57 CREATE UNIQUE INDEX "customer_id" on "customer" using btree ( customer );
59 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 );
76 REVOKE ALL on "article" from PUBLIC;
77 GRANT ALL on "article" to "www";
78 GRANT ALL on "article" to "joey";
80 REVOKE ALL on "offer" from PUBLIC;
81 GRANT ALL on "offer" to "www";
82 GRANT ALL on "offer" to "joey";
84 REVOKE ALL on "dispatch" from PUBLIC;
85 GRANT ALL on "dispatch" to "www";
86 GRANT ALL on "dispatch" to "joey";
88 REVOKE ALL on "dispatchlist" from PUBLIC;
89 GRANT ALL on "dispatchlist" to "www";
90 GRANT ALL on "dispatchlist" to "joey";
92 REVOKE ALL on "customer" from PUBLIC;
93 GRANT ALL on "customer" to "www";
94 GRANT ALL on "customer" to "joey";
96 REVOKE ALL on "spool" from PUBLIC;
97 GRANT ALL on "spool" to "www";
98 GRANT ALL on "spool" to "joey";