X-Git-Url: http://gitweb.michael.orlitzky.com/?p=mailshears.git;a=blobdiff_plain;f=test%2Fsql%2Fagendav.sql;h=9b84ac64f7b49b7fd7ee91677d371a187ee4fe6c;hp=e9458a9cc1ddb8f69ea312c541c7db4829cae2ef;hb=HEAD;hpb=0a0b9b0feb369d53af4ca7ffdd183db786f1127d

diff --git a/test/sql/agendav.sql b/test/sql/agendav.sql
deleted file mode 100644
index e9458a9..0000000
--- a/test/sql/agendav.sql
+++ /dev/null
@@ -1,157 +0,0 @@
---
--- 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
---
-