--- /dev/null
+--
+-- 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
+--
+