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