-- -- PostgreSQL database dump -- SET statement_timeout = 0; SET lock_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; SET row_security = off; -- -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -- CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; -- -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -- COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; SET search_path = public, pg_catalog; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: prefs; Type: TABLE; Schema: public; Owner: agendav -- CREATE TABLE prefs ( username character varying(255) NOT NULL, options text NOT NULL ); ALTER TABLE prefs OWNER TO agendav; -- -- Name: principals; Type: TABLE; Schema: public; Owner: agendav -- CREATE TABLE principals ( url character varying(255) NOT NULL, displayname character varying(255) NOT NULL, email character varying(255) NOT NULL ); ALTER TABLE principals OWNER TO agendav; -- -- Name: schema_versions; Type: TABLE; Schema: public; Owner: agendav -- CREATE TABLE schema_versions ( version character varying(255) NOT NULL ); ALTER TABLE schema_versions OWNER TO agendav; -- -- Name: sessions; Type: TABLE; Schema: public; Owner: agendav -- CREATE TABLE sessions ( sess_id character varying(128) NOT NULL, sess_data bytea NOT NULL, sess_lifetime integer NOT NULL, sess_time integer NOT NULL ); ALTER TABLE sessions OWNER TO agendav; -- -- Name: shares; Type: TABLE; Schema: public; Owner: agendav -- CREATE TABLE shares ( sid integer NOT NULL, owner character varying(255) NOT NULL, calendar character varying(255) NOT NULL, "with" character varying(255) NOT NULL, options text NOT NULL, rw boolean NOT NULL ); ALTER TABLE shares OWNER TO agendav; -- -- Name: shares_sid_seq; Type: SEQUENCE; Schema: public; Owner: agendav -- CREATE SEQUENCE shares_sid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE shares_sid_seq OWNER TO agendav; -- -- Name: shares_sid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: agendav -- ALTER SEQUENCE shares_sid_seq OWNED BY shares.sid; -- -- Name: sid; Type: DEFAULT; Schema: public; Owner: agendav -- ALTER TABLE ONLY shares ALTER COLUMN sid SET DEFAULT nextval('shares_sid_seq'::regclass); -- -- Name: prefs_pkey; Type: CONSTRAINT; Schema: public; Owner: agendav -- ALTER TABLE ONLY prefs ADD CONSTRAINT prefs_pkey PRIMARY KEY (username); -- -- Name: principals_pkey; Type: CONSTRAINT; Schema: public; Owner: agendav -- ALTER TABLE ONLY principals ADD CONSTRAINT principals_pkey PRIMARY KEY (url); -- -- Name: schema_versions_pkey; Type: CONSTRAINT; Schema: public; Owner: agendav -- ALTER TABLE ONLY schema_versions ADD CONSTRAINT schema_versions_pkey PRIMARY KEY (version); -- -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: agendav -- ALTER TABLE ONLY sessions ADD CONSTRAINT sessions_pkey PRIMARY KEY (sess_id); -- -- Name: shares_pkey; Type: CONSTRAINT; Schema: public; Owner: agendav -- ALTER TABLE ONLY shares ADD CONSTRAINT shares_pkey PRIMARY KEY (sid); -- -- Name: idx_905f717c9890e20e; Type: INDEX; Schema: public; Owner: agendav -- CREATE INDEX idx_905f717c9890e20e ON shares USING btree ("with"); -- -- Name: idx_905f717ccf60e67c6ea9a146; Type: INDEX; Schema: public; Owner: agendav -- CREATE INDEX idx_905f717ccf60e67c6ea9a146 ON shares USING btree (owner, calendar); -- -- Name: public; Type: ACL; Schema: -; Owner: postgres -- REVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM postgres; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO PUBLIC; -- -- PostgreSQL database dump complete --