Add a test suite which just creates/deletes databases for now.
[mailshears.git] / test / sql / agendav.sql
1 --
2 -- PostgreSQL database dump
3 --
4
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;
10
11 --
12 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
13 --
14
15 CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
16
17
18 --
19 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
20 --
21
22 COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
23
24
25 SET search_path = public, pg_catalog;
26
27 SET default_tablespace = '';
28
29 SET default_with_oids = false;
30
31 --
32 -- Name: migrations; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
33 --
34
35 CREATE TABLE migrations (
36 version integer NOT NULL
37 );
38
39
40 ALTER TABLE public.migrations OWNER TO postgres;
41
42 --
43 -- Name: prefs; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
44 --
45
46 CREATE TABLE prefs (
47 username character varying(255) NOT NULL,
48 options text NOT NULL
49 );
50
51
52 ALTER TABLE public.prefs OWNER TO postgres;
53
54 --
55 -- Name: sessions; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
56 --
57
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
64 );
65
66
67 ALTER TABLE public.sessions OWNER TO postgres;
68
69 --
70 -- Name: shared_sid_seq; Type: SEQUENCE; Schema: public; Owner: postgres
71 --
72
73 CREATE SEQUENCE shared_sid_seq
74 START WITH 1
75 INCREMENT BY 1
76 NO MINVALUE
77 NO MAXVALUE
78 CACHE 1;
79
80
81 ALTER TABLE public.shared_sid_seq OWNER TO postgres;
82
83 --
84 -- Name: shared; Type: TABLE; Schema: public; Owner: postgres; Tablespace:
85 --
86
87 CREATE TABLE shared (
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
94 );
95
96
97 ALTER TABLE public.shared OWNER TO postgres;
98
99 --
100 -- Name: prefs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
101 --
102
103 ALTER TABLE ONLY prefs
104 ADD CONSTRAINT prefs_pkey PRIMARY KEY (username);
105
106
107 --
108 -- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
109 --
110
111 ALTER TABLE ONLY sessions
112 ADD CONSTRAINT sessions_pkey PRIMARY KEY (session_id);
113
114
115 --
116 -- Name: shared_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace:
117 --
118
119 ALTER TABLE ONLY shared
120 ADD CONSTRAINT shared_pkey PRIMARY KEY (sid);
121
122
123 --
124 -- Name: last_activity_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
125 --
126
127 CREATE INDEX last_activity_idx ON sessions USING btree (last_activity);
128
129
130 --
131 -- Name: sharedwithidx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
132 --
133
134 CREATE INDEX sharedwithidx ON shared USING btree (user_which);
135
136
137 --
138 -- Name: shareidx; Type: INDEX; Schema: public; Owner: postgres; Tablespace:
139 --
140
141 CREATE INDEX shareidx ON shared USING btree (user_from, calendar);
142
143
144 --
145 -- Name: public; Type: ACL; Schema: -; Owner: postgres
146 --
147
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;
152
153
154 --
155 -- PostgreSQL database dump complete
156 --
157