-- -- PostgreSQL database dump -- SET statement_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; -- -- 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: migrations; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE migrations ( version integer NOT NULL ); ALTER TABLE public.migrations OWNER TO postgres; -- -- Name: prefs; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE prefs ( username character varying(255) NOT NULL, options text NOT NULL ); ALTER TABLE public.prefs OWNER TO postgres; -- -- Name: sessions; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE sessions ( session_id character varying(40) DEFAULT 0 NOT NULL, ip_address character varying(16) DEFAULT 0 NOT NULL, user_agent character varying(120) DEFAULT NULL::character varying, last_activity bigint DEFAULT 0 NOT NULL, user_data text NOT NULL ); ALTER TABLE public.sessions OWNER TO postgres; -- -- Name: shared_sid_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE shared_sid_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE public.shared_sid_seq OWNER TO postgres; -- -- Name: shared; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE shared ( sid integer DEFAULT nextval('shared_sid_seq'::regclass) NOT NULL, user_from character varying(255) NOT NULL, calendar character varying(255) NOT NULL, user_which character varying(255) NOT NULL, options text DEFAULT ''::text NOT NULL, write_access boolean DEFAULT false NOT NULL ); ALTER TABLE public.shared OWNER TO postgres; -- -- Name: prefs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY prefs ADD CONSTRAINT prefs_pkey PRIMARY KEY (username); -- -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY sessions ADD CONSTRAINT sessions_pkey PRIMARY KEY (session_id); -- -- Name: shared_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: -- ALTER TABLE ONLY shared ADD CONSTRAINT shared_pkey PRIMARY KEY (sid); -- -- Name: last_activity_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX last_activity_idx ON sessions USING btree (last_activity); -- -- Name: sharedwithidx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX sharedwithidx ON shared USING btree (user_which); -- -- Name: shareidx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: -- CREATE INDEX shareidx ON shared USING btree (user_from, 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 --