CqMVHUtb

1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 10.1
6-- Dumped by pg_dump version 10.1
7
8-- Started on 2018-04-21 09:25:53
9
10SET statement_timeout = 0;
11SET lock_timeout = 0;
12SET idle_in_transaction_session_timeout = 0;
13SET client_encoding = 'UTF8';
14SET standard_conforming_strings = on;
15SET check_function_bodies = false;
16SET client_min_messages = warning;
17SET row_security = off;
18
19--
20-- TOC entry 1 (class 3079 OID 12924)
21-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
22--
23
24CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
25
26
27--
28-- TOC entry 2802 (class 0 OID 0)
29-- Dependencies: 1
30-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
31--
32
33COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
34
35
36SET search_path = public, pg_catalog;
37
38SET default_tablespace = '';
39
40SET default_with_oids = false;
41
42--
43-- TOC entry 197 (class 1259 OID 24624)
44-- Name: int_answers; Type: TABLE; Schema: public; Owner: postgres
45--
46
47CREATE TABLE int_answers (
48    id integer NOT NULL,
49    form_id integer NOT NULL,
50    question_id integer NOT NULL,
51    answer integer NOT NULL,
52    user_id integer NOT NULL
53);
54
55
56ALTER TABLE int_answers OWNER TO postgres;
57
58--
59-- TOC entry 196 (class 1259 OID 24622)
60-- Name: int_answers_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
61--
62
63CREATE SEQUENCE int_answers_id_seq
64    AS integer
65    START WITH 1
66    INCREMENT BY 1
67    NO MINVALUE
68    NO MAXVALUE
69    CACHE 1;
70
71
72ALTER TABLE int_answers_id_seq OWNER TO postgres;
73
74--
75-- TOC entry 2803 (class 0 OID 0)
76-- Dependencies: 196
77-- Name: int_answers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
78--
79
80ALTER SEQUENCE int_answers_id_seq OWNED BY int_answers.id;
81
82
83--
84-- TOC entry 2670 (class 2604 OID 24627)
85-- Name: int_answers id; Type: DEFAULT; Schema: public; Owner: postgres
86--
87
88ALTER TABLE ONLY int_answers ALTER COLUMN id SET DEFAULT nextval('int_answers_id_seq'::regclass);
89
90
91--
92-- TOC entry 2795 (class 0 OID 24624)
93-- Dependencies: 197
94-- Data for Name: int_answers; Type: TABLE DATA; Schema: public; Owner: postgres
95--
96
97COPY int_answers (id, form_id, question_id, answer, user_id) FROM stdin;
98\.
99
100
101--
102-- TOC entry 2804 (class 0 OID 0)
103-- Dependencies: 196
104-- Name: int_answers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
105--
106
107SELECT pg_catalog.setval('int_answers_id_seq', 1, false);
108
109
110--
111-- TOC entry 2672 (class 2606 OID 24629)
112-- Name: int_answers int_answers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
113--
114
115ALTER TABLE ONLY int_answers
116    ADD CONSTRAINT int_answers_pkey PRIMARY KEY (id);
117
118
119-- Completed on 2018-04-21 09:25:55
120
121--
122-- PostgreSQL database dump complete
123--