Add a test suite which just creates/deletes databases for now.
[mailshears.git] / test / sql / postfixadmin.sql
1 --
2 -- PostgreSQL database dump
3 --
4
5 SET statement_timeout = 0;
6 SET client_encoding = 'UTF8';
7 SET standard_conforming_strings = on;
8 SET check_function_bodies = false;
9 SET client_min_messages = warning;
10
11 --
12 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
13 --
14
15 CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
16
17
18 --
19 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
20 --
21
22 COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
23
24
25 SET search_path = public, pg_catalog;
26
27 --
28 -- Name: merge_quota(); Type: FUNCTION; Schema: public; Owner: postgres
29 --
30
31 CREATE FUNCTION merge_quota() RETURNS trigger
32 LANGUAGE plpgsql
33 AS $$
34 BEGIN
35 UPDATE quota SET current = NEW.current + current WHERE username = NEW.username AND path = NEW.path;
36 IF found THEN
37 RETURN NULL;
38 ELSE
39 RETURN NEW;
40 END IF;
41 END;
42 $$;
43
44
45 ALTER FUNCTION public.merge_quota() OWNER TO postgres;
46
47 --
48 -- Name: merge_quota2(); Type: FUNCTION; Schema: public; Owner: postgres
49 --
50
51 CREATE FUNCTION merge_quota2() RETURNS trigger
52 LANGUAGE plpgsql
53 AS $$
54 BEGIN
55 IF NEW.messages < 0 OR NEW.messages IS NULL THEN
56 -- ugly kludge: we came here from this function, really do try to insert
57 IF NEW.messages IS NULL THEN
58 NEW.messages = 0;
59 ELSE
60 NEW.messages = -NEW.messages;
61 END IF;
62 return NEW;
63 END IF;
64
65 LOOP
66 UPDATE quota2 SET bytes = bytes + NEW.bytes,
67 messages = messages + NEW.messages
68 WHERE username = NEW.username;
69 IF found THEN
70 RETURN NULL;
71 END IF;
72
73 BEGIN
74 IF NEW.messages = 0 THEN
75 INSERT INTO quota2 (bytes, messages, username) VALUES (NEW.bytes, NULL, NEW.username);
76 ELSE
77 INSERT INTO quota2 (bytes, messages, username) VALUES (NEW.bytes, -NEW.messages, NEW.username);
78 END IF;
79 return NULL;
80 EXCEPTION WHEN unique_violation THEN
81 -- someone just inserted the record, update it
82 END;
83 END LOOP;
84 END;
85 $$;
86
87
88 ALTER FUNCTION public.merge_quota2() OWNER TO postgres;
89
90 SET default_tablespace = '';
91
92 SET default_with_oids = true;
93
94 --
95 -- Name: admin; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
96 --
97
98 CREATE TABLE admin (
99 username character varying(255) NOT NULL,
100 password character varying(255) DEFAULT ''::character varying NOT NULL,
101 created timestamp with time zone DEFAULT now(),
102 modified timestamp with time zone DEFAULT now(),
103 active boolean DEFAULT true NOT NULL
104 );
105
106
107 ALTER TABLE public.admin OWNER TO postgres;
108
109 --
110 -- Name: TABLE admin; Type: COMMENT; Schema: public; Owner: postgres
111 --
112
113 COMMENT ON TABLE admin IS 'Postfix Admin - Virtual Admins';
114
115
116 --
117 -- Name: alias; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
118 --
119
120 CREATE TABLE alias (
121 address character varying(255) NOT NULL,
122 goto text NOT NULL,
123 domain character varying(255) NOT NULL,
124 created timestamp with time zone DEFAULT now(),
125 modified timestamp with time zone DEFAULT now(),
126 active boolean DEFAULT true NOT NULL
127 );
128
129
130 ALTER TABLE public.alias OWNER TO postgres;
131
132 --
133 -- Name: TABLE alias; Type: COMMENT; Schema: public; Owner: postgres
134 --
135
136 COMMENT ON TABLE alias IS 'Postfix Admin - Virtual Aliases';
137
138
139 SET default_with_oids = false;
140
141 --
142 -- Name: alias_domain; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
143 --
144
145 CREATE TABLE alias_domain (
146 alias_domain character varying(255) NOT NULL,
147 target_domain character varying(255) NOT NULL,
148 created timestamp with time zone DEFAULT now(),
149 modified timestamp with time zone DEFAULT now(),
150 active boolean DEFAULT true NOT NULL
151 );
152
153
154 ALTER TABLE public.alias_domain OWNER TO postgres;
155
156 --
157 -- Name: TABLE alias_domain; Type: COMMENT; Schema: public; Owner: postgres
158 --
159
160 COMMENT ON TABLE alias_domain IS 'Postfix Admin - Domain Aliases';
161
162
163 SET default_with_oids = true;
164
165 --
166 -- Name: config; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
167 --
168
169 CREATE TABLE config (
170 id integer NOT NULL,
171 name character varying(20) NOT NULL,
172 value character varying(20) NOT NULL
173 );
174
175
176 ALTER TABLE public.config OWNER TO postgres;
177
178 --
179 -- Name: config_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
180 --
181
182 CREATE SEQUENCE config_id_seq
183 START WITH 1
184 INCREMENT BY 1
185 NO MINVALUE
186 NO MAXVALUE
187 CACHE 1;
188
189
190 ALTER TABLE public.config_id_seq OWNER TO postgres;
191
192 --
193 -- Name: config_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
194 --
195
196 ALTER SEQUENCE config_id_seq OWNED BY config.id;
197
198
199 --
200 -- Name: domain; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
201 --
202
203 CREATE TABLE domain (
204 domain character varying(255) NOT NULL,
205 description character varying(255) DEFAULT ''::character varying NOT NULL,
206 aliases integer DEFAULT 0 NOT NULL,
207 mailboxes integer DEFAULT 0 NOT NULL,
208 maxquota bigint DEFAULT 0 NOT NULL,
209 quota bigint DEFAULT 0 NOT NULL,
210 transport character varying(255),
211 backupmx boolean DEFAULT false NOT NULL,
212 created timestamp with time zone DEFAULT now(),
213 modified timestamp with time zone DEFAULT now(),
214 active boolean DEFAULT true NOT NULL
215 );
216
217
218 ALTER TABLE public.domain OWNER TO postgres;
219
220 --
221 -- Name: TABLE domain; Type: COMMENT; Schema: public; Owner: postgres
222 --
223
224 COMMENT ON TABLE domain IS 'Postfix Admin - Virtual Domains';
225
226
227 --
228 -- Name: domain_admins; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
229 --
230
231 CREATE TABLE domain_admins (
232 username character varying(255) NOT NULL,
233 domain character varying(255) NOT NULL,
234 created timestamp with time zone DEFAULT now(),
235 active boolean DEFAULT true NOT NULL
236 );
237
238
239 ALTER TABLE public.domain_admins OWNER TO postgres;
240
241 --
242 -- Name: TABLE domain_admins; Type: COMMENT; Schema: public; Owner: postgres
243 --
244
245 COMMENT ON TABLE domain_admins IS 'Postfix Admin - Domain Admins';
246
247
248 --
249 -- Name: fetchmail; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
250 --
251
252 CREATE TABLE fetchmail (
253 id integer NOT NULL,
254 mailbox character varying(255) DEFAULT ''::character varying NOT NULL,
255 src_server character varying(255) DEFAULT ''::character varying NOT NULL,
256 src_auth character varying(15) NOT NULL,
257 src_user character varying(255) DEFAULT ''::character varying NOT NULL,
258 src_password character varying(255) DEFAULT ''::character varying NOT NULL,
259 src_folder character varying(255) DEFAULT ''::character varying NOT NULL,
260 poll_time integer DEFAULT 10 NOT NULL,
261 fetchall boolean DEFAULT false NOT NULL,
262 keep boolean DEFAULT false NOT NULL,
263 protocol character varying(15) NOT NULL,
264 extra_options text,
265 returned_text text,
266 mda character varying(255) DEFAULT ''::character varying NOT NULL,
267 date timestamp with time zone DEFAULT now(),
268 usessl boolean DEFAULT false NOT NULL,
269 CONSTRAINT fetchmail_protocol_check CHECK (((((((protocol)::text = 'POP3'::text) OR ((protocol)::text = 'IMAP'::text)) OR ((protocol)::text = 'POP2'::text)) OR ((protocol)::text = 'ETRN'::text)) OR ((protocol)::text = 'AUTO'::text))),
270 CONSTRAINT fetchmail_src_auth_check CHECK (((((((((((((src_auth)::text = 'password'::text) OR ((src_auth)::text = 'kerberos_v5'::text)) OR ((src_auth)::text = 'kerberos'::text)) OR ((src_auth)::text = 'kerberos_v4'::text)) OR ((src_auth)::text = 'gssapi'::text)) OR ((src_auth)::text = 'cram-md5'::text)) OR ((src_auth)::text = 'otp'::text)) OR ((src_auth)::text = 'ntlm'::text)) OR ((src_auth)::text = 'msn'::text)) OR ((src_auth)::text = 'ssh'::text)) OR ((src_auth)::text = 'any'::text)))
271 );
272
273
274 ALTER TABLE public.fetchmail OWNER TO postgres;
275
276 --
277 -- Name: fetchmail_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
278 --
279
280 CREATE SEQUENCE fetchmail_id_seq
281 START WITH 1
282 INCREMENT BY 1
283 NO MINVALUE
284 NO MAXVALUE
285 CACHE 1;
286
287
288 ALTER TABLE public.fetchmail_id_seq OWNER TO postgres;
289
290 --
291 -- Name: fetchmail_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
292 --
293
294 ALTER SEQUENCE fetchmail_id_seq OWNED BY fetchmail.id;
295
296
297 --
298 -- Name: log; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
299 --
300
301 CREATE TABLE log (
302 "timestamp" timestamp with time zone DEFAULT now(),
303 username character varying(255) DEFAULT ''::character varying NOT NULL,
304 domain character varying(255) DEFAULT ''::character varying NOT NULL,
305 action character varying(255) DEFAULT ''::character varying NOT NULL,
306 data text DEFAULT ''::text NOT NULL
307 );
308
309
310 ALTER TABLE public.log OWNER TO postgres;
311
312 --
313 -- Name: TABLE log; Type: COMMENT; Schema: public; Owner: postgres
314 --
315
316 COMMENT ON TABLE log IS 'Postfix Admin - Log';
317
318
319 --
320 -- Name: mailbox; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
321 --
322
323 CREATE TABLE mailbox (
324 username character varying(255) NOT NULL,
325 password character varying(255) DEFAULT ''::character varying NOT NULL,
326 name character varying(255) DEFAULT ''::character varying NOT NULL,
327 maildir character varying(255) DEFAULT ''::character varying NOT NULL,
328 quota bigint DEFAULT 0 NOT NULL,
329 created timestamp with time zone DEFAULT now(),
330 modified timestamp with time zone DEFAULT now(),
331 active boolean DEFAULT true NOT NULL,
332 domain character varying(255),
333 local_part character varying(255) NOT NULL
334 );
335
336
337 ALTER TABLE public.mailbox OWNER TO postgres;
338
339 --
340 -- Name: TABLE mailbox; Type: COMMENT; Schema: public; Owner: postgres
341 --
342
343 COMMENT ON TABLE mailbox IS 'Postfix Admin - Virtual Mailboxes';
344
345
346 SET default_with_oids = false;
347
348 --
349 -- Name: quota; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
350 --
351
352 CREATE TABLE quota (
353 username character varying(255) NOT NULL,
354 path character varying(100) NOT NULL,
355 current bigint
356 );
357
358
359 ALTER TABLE public.quota OWNER TO postgres;
360
361 --
362 -- Name: quota2; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
363 --
364
365 CREATE TABLE quota2 (
366 username character varying(100) NOT NULL,
367 bytes bigint DEFAULT 0 NOT NULL,
368 messages integer DEFAULT 0 NOT NULL
369 );
370
371
372 ALTER TABLE public.quota2 OWNER TO postgres;
373
374 SET default_with_oids = true;
375
376 --
377 -- Name: vacation; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
378 --
379
380 CREATE TABLE vacation (
381 email character varying(255) NOT NULL,
382 subject character varying(255) NOT NULL,
383 body text DEFAULT ''::text NOT NULL,
384 created timestamp with time zone DEFAULT now(),
385 active boolean DEFAULT true NOT NULL,
386 domain character varying(255)
387 );
388
389
390 ALTER TABLE public.vacation OWNER TO postgres;
391
392 --
393 -- Name: vacation_notification; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
394 --
395
396 CREATE TABLE vacation_notification (
397 on_vacation character varying(255) NOT NULL,
398 notified character varying(255) NOT NULL,
399 notified_at timestamp with time zone DEFAULT now() NOT NULL
400 );
401
402
403 ALTER TABLE public.vacation_notification OWNER TO postgres;
404
405 --
406 -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
407 --
408
409 ALTER TABLE ONLY config ALTER COLUMN id SET DEFAULT nextval('config_id_seq'::regclass);
410
411
412 --
413 -- Name: id; Type: DEFAULT; Schema: public; Owner: postgres
414 --
415
416 ALTER TABLE ONLY fetchmail ALTER COLUMN id SET DEFAULT nextval('fetchmail_id_seq'::regclass);
417
418
419 --
420 -- Name: admin_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
421 --
422
423 ALTER TABLE ONLY admin
424 ADD CONSTRAINT admin_key PRIMARY KEY (username);
425
426
427 --
428 -- Name: alias_domain_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
429 --
430
431 ALTER TABLE ONLY alias_domain
432 ADD CONSTRAINT alias_domain_pkey PRIMARY KEY (alias_domain);
433
434
435 --
436 -- Name: alias_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
437 --
438
439 ALTER TABLE ONLY alias
440 ADD CONSTRAINT alias_key PRIMARY KEY (address);
441
442
443 --
444 -- Name: config_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
445 --
446
447 ALTER TABLE ONLY config
448 ADD CONSTRAINT config_name_key UNIQUE (name);
449
450
451 --
452 -- Name: config_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
453 --
454
455 ALTER TABLE ONLY config
456 ADD CONSTRAINT config_pkey PRIMARY KEY (id);
457
458
459 --
460 -- Name: domain_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
461 --
462
463 ALTER TABLE ONLY domain
464 ADD CONSTRAINT domain_key PRIMARY KEY (domain);
465
466
467 --
468 -- Name: fetchmail_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
469 --
470
471 ALTER TABLE ONLY fetchmail
472 ADD CONSTRAINT fetchmail_pkey PRIMARY KEY (id);
473
474
475 --
476 -- Name: mailbox_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
477 --
478
479 ALTER TABLE ONLY mailbox
480 ADD CONSTRAINT mailbox_key PRIMARY KEY (username);
481
482
483 --
484 -- Name: quota2_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
485 --
486
487 ALTER TABLE ONLY quota2
488 ADD CONSTRAINT quota2_pkey PRIMARY KEY (username);
489
490
491 --
492 -- Name: quota_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
493 --
494
495 ALTER TABLE ONLY quota
496 ADD CONSTRAINT quota_pkey PRIMARY KEY (username, path);
497
498
499 --
500 -- Name: vacation_notification_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
501 --
502
503 ALTER TABLE ONLY vacation_notification
504 ADD CONSTRAINT vacation_notification_pkey PRIMARY KEY (on_vacation, notified);
505
506
507 --
508 -- Name: vacation_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
509 --
510
511 ALTER TABLE ONLY vacation
512 ADD CONSTRAINT vacation_pkey PRIMARY KEY (email);
513
514
515 --
516 -- Name: alias_address_active; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
517 --
518
519 CREATE INDEX alias_address_active ON alias USING btree (address, active);
520
521
522 --
523 -- Name: alias_domain_active; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
524 --
525
526 CREATE INDEX alias_domain_active ON alias_domain USING btree (alias_domain, active);
527
528
529 --
530 -- Name: alias_domain_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
531 --
532
533 CREATE INDEX alias_domain_idx ON alias USING btree (domain);
534
535
536 --
537 -- Name: domain_domain_active; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
538 --
539
540 CREATE INDEX domain_domain_active ON domain USING btree (domain, active);
541
542
543 --
544 -- Name: mailbox_domain_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
545 --
546
547 CREATE INDEX mailbox_domain_idx ON mailbox USING btree (domain);
548
549
550 --
551 -- Name: mailbox_username_active; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
552 --
553
554 CREATE INDEX mailbox_username_active ON mailbox USING btree (username, active);
555
556
557 --
558 -- Name: vacation_email_active; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
559 --
560
561 CREATE INDEX vacation_email_active ON vacation USING btree (email, active);
562
563
564 --
565 -- Name: mergequota; Type: TRIGGER; Schema: public; Owner: postgres
566 --
567
568 CREATE TRIGGER mergequota BEFORE INSERT ON quota FOR EACH ROW EXECUTE PROCEDURE merge_quota();
569
570
571 --
572 -- Name: mergequota2; Type: TRIGGER; Schema: public; Owner: postgres
573 --
574
575 CREATE TRIGGER mergequota2 BEFORE INSERT ON quota2 FOR EACH ROW EXECUTE PROCEDURE merge_quota2();
576
577
578 --
579 -- Name: alias_domain_alias_domain_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
580 --
581
582 ALTER TABLE ONLY alias_domain
583 ADD CONSTRAINT alias_domain_alias_domain_fkey FOREIGN KEY (alias_domain) REFERENCES domain(domain) ON DELETE CASCADE;
584
585
586 --
587 -- Name: alias_domain_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
588 --
589
590 ALTER TABLE ONLY alias
591 ADD CONSTRAINT alias_domain_fkey FOREIGN KEY (domain) REFERENCES domain(domain);
592
593
594 --
595 -- Name: alias_domain_target_domain_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
596 --
597
598 ALTER TABLE ONLY alias_domain
599 ADD CONSTRAINT alias_domain_target_domain_fkey FOREIGN KEY (target_domain) REFERENCES domain(domain) ON DELETE CASCADE;
600
601
602 --
603 -- Name: domain_admins_domain_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
604 --
605
606 ALTER TABLE ONLY domain_admins
607 ADD CONSTRAINT domain_admins_domain_fkey FOREIGN KEY (domain) REFERENCES domain(domain);
608
609
610 --
611 -- Name: mailbox_domain_fkey1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
612 --
613
614 ALTER TABLE ONLY mailbox
615 ADD CONSTRAINT mailbox_domain_fkey1 FOREIGN KEY (domain) REFERENCES domain(domain);
616
617
618 --
619 -- Name: vacation_domain_fkey1; Type: FK CONSTRAINT; Schema: public; Owner: postgres
620 --
621
622 ALTER TABLE ONLY vacation
623 ADD CONSTRAINT vacation_domain_fkey1 FOREIGN KEY (domain) REFERENCES domain(domain);
624
625
626 --
627 -- Name: vacation_notification_on_vacation_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
628 --
629
630 ALTER TABLE ONLY vacation_notification
631 ADD CONSTRAINT vacation_notification_on_vacation_fkey FOREIGN KEY (on_vacation) REFERENCES vacation(email) ON DELETE CASCADE;
632
633
634 --
635 -- Name: public; Type: ACL; Schema: -; Owner: postgres
636 --
637
638 REVOKE ALL ON SCHEMA public FROM PUBLIC;
639 REVOKE ALL ON SCHEMA public FROM postgres;
640 GRANT ALL ON SCHEMA public TO postgres;
641 GRANT ALL ON SCHEMA public TO PUBLIC;
642
643
644 --
645 -- Name: admin; Type: ACL; Schema: public; Owner: postgres
646 --
647
648 REVOKE ALL ON TABLE admin FROM PUBLIC;
649 REVOKE ALL ON TABLE admin FROM postgres;
650 GRANT ALL ON TABLE admin TO postgres;
651
652
653 --
654 -- Name: alias; Type: ACL; Schema: public; Owner: postgres
655 --
656
657 REVOKE ALL ON TABLE alias FROM PUBLIC;
658 REVOKE ALL ON TABLE alias FROM postgres;
659 GRANT ALL ON TABLE alias TO postgres;
660
661
662 --
663 -- Name: config; Type: ACL; Schema: public; Owner: postgres
664 --
665
666 REVOKE ALL ON TABLE config FROM PUBLIC;
667 REVOKE ALL ON TABLE config FROM postgres;
668 GRANT ALL ON TABLE config TO postgres;
669
670
671 --
672 -- Name: domain; Type: ACL; Schema: public; Owner: postgres
673 --
674
675 REVOKE ALL ON TABLE domain FROM PUBLIC;
676 REVOKE ALL ON TABLE domain FROM postgres;
677 GRANT ALL ON TABLE domain TO postgres;
678
679
680 --
681 -- Name: domain_admins; Type: ACL; Schema: public; Owner: postgres
682 --
683
684 REVOKE ALL ON TABLE domain_admins FROM PUBLIC;
685 REVOKE ALL ON TABLE domain_admins FROM postgres;
686 GRANT ALL ON TABLE domain_admins TO postgres;
687
688
689 --
690 -- Name: fetchmail; Type: ACL; Schema: public; Owner: postgres
691 --
692
693 REVOKE ALL ON TABLE fetchmail FROM PUBLIC;
694 REVOKE ALL ON TABLE fetchmail FROM postgres;
695 GRANT ALL ON TABLE fetchmail TO postgres;
696
697
698 --
699 -- Name: log; Type: ACL; Schema: public; Owner: postgres
700 --
701
702 REVOKE ALL ON TABLE log FROM PUBLIC;
703 REVOKE ALL ON TABLE log FROM postgres;
704 GRANT ALL ON TABLE log TO postgres;
705
706
707 --
708 -- Name: mailbox; Type: ACL; Schema: public; Owner: postgres
709 --
710
711 REVOKE ALL ON TABLE mailbox FROM PUBLIC;
712 REVOKE ALL ON TABLE mailbox FROM postgres;
713 GRANT ALL ON TABLE mailbox TO postgres;
714
715
716 --
717 -- Name: vacation; Type: ACL; Schema: public; Owner: postgres
718 --
719
720 REVOKE ALL ON TABLE vacation FROM PUBLIC;
721 REVOKE ALL ON TABLE vacation FROM postgres;
722 GRANT ALL ON TABLE vacation TO postgres;
723
724
725 --
726 -- Name: vacation_notification; Type: ACL; Schema: public; Owner: postgres
727 --
728
729 REVOKE ALL ON TABLE vacation_notification FROM PUBLIC;
730 REVOKE ALL ON TABLE vacation_notification FROM postgres;
731 GRANT ALL ON TABLE vacation_notification TO postgres;
732
733
734 --
735 -- PostgreSQL database dump complete
736 --
737