2 -- PostgreSQL database dump
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
;
12 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
15 CREATE EXTENSION
IF NOT EXISTS plpgsql
WITH SCHEMA pg_catalog
;
19 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
22 COMMENT ON EXTENSION plpgsql
IS 'PL/pgSQL procedural language';
25 SET search_path
= public, pg_catalog
;
27 SET default_tablespace
= '';
29 SET default_with_oids
= false;
32 -- Name: migrations; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
35 CREATE TABLE migrations (
36 version integer NOT NULL
40 ALTER TABLE public.migrations
OWNER TO postgres
;
43 -- Name: prefs; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
47 username
character varying(255) NOT NULL,
52 ALTER TABLE public.prefs
OWNER TO postgres
;
55 -- Name: sessions; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
58 CREATE TABLE sessions (
59 session_id
character varying(40) DEFAULT 0 NOT NULL,
60 ip_address
character varying(16) DEFAULT 0 NOT NULL,
61 user_agent
character varying(120) DEFAULT NULL::character varying,
62 last_activity
bigint DEFAULT 0 NOT NULL,
63 user_data
text NOT NULL
67 ALTER TABLE public.sessions
OWNER TO postgres
;
70 -- Name: shared_sid_seq; Type: SEQUENCE; Schema: public; Owner: postgres
73 CREATE SEQUENCE shared_sid_seq
81 ALTER TABLE public.shared_sid_seq
OWNER TO postgres
;
84 -- Name: shared; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
88 sid
integer DEFAULT nextval('shared_sid_seq'::regclass) NOT NULL,
89 user_from
character varying(255) NOT NULL,
90 calendar
character varying(255) NOT NULL,
91 user_which
character varying(255) NOT NULL,
92 options text DEFAULT ''::text NOT NULL,
93 write_access
boolean DEFAULT false NOT NULL
97 ALTER TABLE public.shared
OWNER TO postgres
;
100 -- Name: prefs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
103 ALTER TABLE ONLY prefs
104 ADD CONSTRAINT prefs_pkey
PRIMARY KEY (username
);
108 -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
111 ALTER TABLE ONLY sessions
112 ADD CONSTRAINT sessions_pkey
PRIMARY KEY (session_id
);
116 -- Name: shared_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
119 ALTER TABLE ONLY shared
120 ADD CONSTRAINT shared_pkey
PRIMARY KEY (sid
);
124 -- Name: last_activity_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
127 CREATE INDEX last_activity_idx
ON sessions
USING btree (last_activity
);
131 -- Name: sharedwithidx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
134 CREATE INDEX sharedwithidx
ON shared
USING btree (user_which
);
138 -- Name: shareidx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
141 CREATE INDEX shareidx
ON shared
USING btree (user_from
, calendar
);
145 -- Name: public; Type: ACL; Schema: -; Owner: postgres
148 REVOKE ALL ON SCHEMA public FROM PUBLIC;
149 REVOKE ALL ON SCHEMA public FROM postgres
;
150 GRANT ALL ON SCHEMA public TO postgres
;
151 GRANT ALL ON SCHEMA public TO PUBLIC;
155 -- PostgreSQL database dump complete