2 -- PostgreSQL database dump
5 SET statement_timeout
= 0;
7 SET client_encoding
= 'UTF8';
8 SET standard_conforming_strings
= on;
9 SET check_function_bodies
= false;
10 SET client_min_messages
= warning
;
11 SET row_security
= off;
14 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
17 CREATE EXTENSION
IF NOT EXISTS plpgsql
WITH SCHEMA pg_catalog
;
21 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
24 COMMENT ON EXTENSION plpgsql
IS 'PL/pgSQL procedural language';
27 SET search_path
= public, pg_catalog
;
29 SET default_tablespace
= '';
31 SET default_with_oids
= false;
34 -- Name: prefs; Type: TABLE; Schema: public; Owner: agendav
38 username
character varying(255) NOT NULL,
43 ALTER TABLE prefs
OWNER to postgres
;
46 -- Name: principals; Type: TABLE; Schema: public; Owner: agendav
49 CREATE TABLE principals (
50 url
character varying(255) NOT NULL,
51 displayname
character varying(255) NOT NULL,
52 email
character varying(255) NOT NULL
56 ALTER TABLE principals
OWNER to postgres
;
59 -- Name: schema_versions; Type: TABLE; Schema: public; Owner: agendav
62 CREATE TABLE schema_versions (
63 version character varying(255) NOT NULL
67 ALTER TABLE schema_versions
OWNER to postgres
;
70 -- Name: sessions; Type: TABLE; Schema: public; Owner: agendav
73 CREATE TABLE sessions (
74 sess_id
character varying(128) NOT NULL,
75 sess_data bytea
NOT NULL,
76 sess_lifetime
integer NOT NULL,
77 sess_time
integer NOT NULL
81 ALTER TABLE sessions
OWNER to postgres
;
84 -- Name: shares; Type: TABLE; Schema: public; Owner: agendav
89 owner character varying(255) NOT NULL,
90 calendar
character varying(255) NOT NULL,
91 "with" character varying(255) NOT NULL,
92 options text NOT NULL,
97 ALTER TABLE shares
OWNER to postgres
;
100 -- Name: shares_sid_seq; Type: SEQUENCE; Schema: public; Owner: agendav
103 CREATE SEQUENCE shares_sid_seq
111 ALTER TABLE shares_sid_seq
OWNER to postgres
;
114 -- Name: shares_sid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agendav
117 ALTER SEQUENCE shares_sid_seq
OWNED BY shares.sid
;
121 -- Name: sid; Type: DEFAULT; Schema: public; Owner: agendav
124 ALTER TABLE ONLY shares
ALTER COLUMN sid
SET DEFAULT nextval('shares_sid_seq'::regclass);
128 -- Name: prefs_pkey; Type: CONSTRAINT; Schema: public; Owner: agendav
131 ALTER TABLE ONLY prefs
132 ADD CONSTRAINT prefs_pkey
PRIMARY KEY (username
);
136 -- Name: principals_pkey; Type: CONSTRAINT; Schema: public; Owner: agendav
139 ALTER TABLE ONLY principals
140 ADD CONSTRAINT principals_pkey
PRIMARY KEY (url
);
144 -- Name: schema_versions_pkey; Type: CONSTRAINT; Schema: public; Owner: agendav
147 ALTER TABLE ONLY schema_versions
148 ADD CONSTRAINT schema_versions_pkey
PRIMARY KEY (version);
152 -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: agendav
155 ALTER TABLE ONLY sessions
156 ADD CONSTRAINT sessions_pkey
PRIMARY KEY (sess_id
);
160 -- Name: shares_pkey; Type: CONSTRAINT; Schema: public; Owner: agendav
163 ALTER TABLE ONLY shares
164 ADD CONSTRAINT shares_pkey
PRIMARY KEY (sid
);
168 -- Name: idx_905f717c9890e20e; Type: INDEX; Schema: public; Owner: agendav
171 CREATE INDEX idx_905f717c9890e20e
ON shares
USING btree ("with");
175 -- Name: idx_905f717ccf60e67c6ea9a146; Type: INDEX; Schema: public; Owner: agendav
178 CREATE INDEX idx_905f717ccf60e67c6ea9a146
ON shares
USING btree (owner, calendar
);
182 -- Name: public; Type: ACL; Schema: -; Owner: postgres
185 REVOKE ALL ON SCHEMA public FROM PUBLIC;
186 REVOKE ALL ON SCHEMA public FROM postgres
;
187 GRANT ALL ON SCHEMA public TO postgres
;
188 GRANT ALL ON SCHEMA public TO PUBLIC;
192 -- PostgreSQL database dump complete