--
-- PostgreSQL database dump
--
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: ballot; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE ballot (
id character varying(32) NOT NULL,
poll integer NOT NULL,
invalid boolean
);
--
-- Name: ballot_enc; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE ballot_enc (
id character varying(32) NOT NULL,
data text,
enckey text,
decrypted boolean DEFAULT false NOT NULL,
poll integer NOT NULL
);
--
-- Name: ballot_item; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE ballot_item (
id character varying(32) NOT NULL,
value text NOT NULL,
fromlist boolean DEFAULT false NOT NULL,
weight integer
);
--
-- Name: ballot_map; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE ballot_map (
poll integer NOT NULL,
"from" text NOT NULL,
"to" text NOT NULL
);
--
-- Name: choice; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE choice (
key integer NOT NULL,
poll integer NOT NULL,
label text NOT NULL
);
--
-- Name: choice_key_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE choice_key_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
--
-- Name: choice_key_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE choice_key_seq OWNED BY choice.key;
--
-- Name: extern_auth; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE extern_auth (
id bigint NOT NULL,
params text NOT NULL,
owner text,
"desc" text,
auth_type text NOT NULL
);
--
-- Name: extern_auth_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE extern_auth_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
--
-- Name: extern_auth_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE extern_auth_id_seq OWNED BY extern_auth.id;
--
-- Name: poll; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE poll (
id integer NOT NULL,
creation timestamp with time zone DEFAULT now() NOT NULL,
label text,
description text,
start timestamp with time zone,
"end" timestamp with time zone,
password text,
owner text,
CONSTRAINT check_start_end CHECK (("start" < "end"))
);
--
-- Name: poll_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE poll_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
--
-- Name: poll_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE poll_id_seq OWNED BY poll.id;
--
-- Name: poll_request; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE poll_request (
id character(32) NOT NULL,
label text,
mail text NOT NULL,
"create" timestamp with time zone DEFAULT now() NOT NULL,
password text
);
--
-- Name: sessions; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE sessions (
id character(72) NOT NULL,
session_data text,
expires bigint
);
--
-- Name: settings; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE settings (
poll integer NOT NULL,
var text NOT NULL,
val text
);
--
-- Name: signing; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE signing (
key integer NOT NULL,
date timestamp without time zone DEFAULT now() NOT NULL,
referal text
);
--
-- Name: voting; Type: TABLE; Schema: public; Owner: -; Tablespace:
--
CREATE TABLE voting (
key integer NOT NULL,
poll integer NOT NULL,
label text NOT NULL,
passwd text,
mail text,
extern_auth bigint,
extern_uid text
);
--
-- Name: TABLE voting; Type: COMMENT; Schema: public; Owner: -
--
COMMENT ON TABLE voting IS 'People list allow to vote';
--
-- Name: voting_key_seq; Type: SEQUENCE; Schema: public; Owner: -
--
CREATE SEQUENCE voting_key_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
--
-- Name: voting_key_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--
ALTER SEQUENCE voting_key_seq OWNED BY voting.key;
--
-- Name: key; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE choice ALTER COLUMN key SET DEFAULT nextval('choice_key_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE extern_auth ALTER COLUMN id SET DEFAULT nextval('extern_auth_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE poll ALTER COLUMN id SET DEFAULT nextval('poll_id_seq'::regclass);
--
-- Name: key; Type: DEFAULT; Schema: public; Owner: -
--
ALTER TABLE voting ALTER COLUMN key SET DEFAULT nextval('voting_key_seq'::regclass);
--
-- Name: ballot_enc_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY ballot_enc
ADD CONSTRAINT ballot_enc_pkey PRIMARY KEY (id);
--
-- Name: ballot_item_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY ballot_item
ADD CONSTRAINT ballot_item_pkey PRIMARY KEY (id, value);
--
-- Name: ballot_map_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY ballot_map
ADD CONSTRAINT ballot_map_pkey PRIMARY KEY (poll, "from");
--
-- Name: ballot_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY ballot
ADD CONSTRAINT ballot_pkey PRIMARY KEY (id);
--
-- Name: choice_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY choice
ADD CONSTRAINT choice_pkey PRIMARY KEY (key);
--
-- Name: extern_auth_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY extern_auth
ADD CONSTRAINT extern_auth_pkey PRIMARY KEY (id);
--
-- Name: poll_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY poll
ADD CONSTRAINT poll_pkey PRIMARY KEY (id);
--
-- Name: poll_request_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY poll_request
ADD CONSTRAINT poll_request_pkey PRIMARY KEY (id);
--
-- Name: sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY sessions
ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);
--
-- Name: setting_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY settings
ADD CONSTRAINT setting_pkey PRIMARY KEY (poll, var);
--
-- Name: signing_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY signing
ADD CONSTRAINT signing_pkey PRIMARY KEY (key);
--
-- Name: voting_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY voting
ADD CONSTRAINT voting_pkey PRIMARY KEY (key);
--
-- Name: voting_poll_mail_uniq; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
--
ALTER TABLE ONLY voting
ADD CONSTRAINT voting_poll_mail_uniq UNIQUE (mail, poll);
--
-- Name: fki_ballot_enc_poll_fkey; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX fki_ballot_enc_poll_fkey ON ballot_enc USING btree (poll);
--
-- Name: fki_ballot_poll_fkey; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX fki_ballot_poll_fkey ON ballot USING btree (poll);
--
-- Name: fki_choice_poll_fkey; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX fki_choice_poll_fkey ON choice USING btree (poll);
--
-- Name: fki_voting_extern_auth; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX fki_voting_extern_auth ON voting USING btree (extern_auth);
--
-- Name: poll_request_create_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX poll_request_create_idx ON poll_request USING btree ("create");
--
-- Name: sessions_expires_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX sessions_expires_idx ON sessions USING btree (expires);
--
-- Name: settings_var_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
--
CREATE INDEX settings_var_idx ON settings USING btree (var);
--
-- Name: ballop_map_poll_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY ballot_map
ADD CONSTRAINT ballop_map_poll_fkey FOREIGN KEY (poll) REFERENCES poll(id);
--
-- Name: ballot_enc_poll_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY ballot_enc
ADD CONSTRAINT ballot_enc_poll_fkey FOREIGN KEY (poll) REFERENCES poll(id);
--
-- Name: ballot_item; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY ballot_item
ADD CONSTRAINT ballot_item FOREIGN KEY (id) REFERENCES ballot(id);
--
-- Name: ballot_poll_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY ballot
ADD CONSTRAINT ballot_poll_fkey FOREIGN KEY (poll) REFERENCES poll(id);
--
-- Name: choice_poll_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY choice
ADD CONSTRAINT choice_poll_fkey FOREIGN KEY (poll) REFERENCES poll(id);
--
-- Name: setting_poll_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY settings
ADD CONSTRAINT setting_poll_fkey FOREIGN KEY (poll) REFERENCES poll(id);
--
-- Name: signing_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY signing
ADD CONSTRAINT signing_fkey FOREIGN KEY ("key") REFERENCES voting("key");
--
-- Name: voting_extern_auth; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY voting
ADD CONSTRAINT voting_extern_auth FOREIGN KEY (extern_auth) REFERENCES extern_auth(id);
--
-- Name: voting_poll_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--
ALTER TABLE ONLY voting
ADD CONSTRAINT voting_poll_fkey FOREIGN KEY (poll) REFERENCES poll(id);
--
-- Name: public; Type: ACL; Schema: -; Owner: -
--
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
--
