compatibiltiy

gistfile1.sql

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: compatibility; Type: TABLE; Schema: public; Owner: play; Tablespace: 
--

CREATE TABLE compatibility (
    id bigint NOT NULL,
    attr1_id bigint,
    attr2_id bigint,
    user_id character varying(255),
    rating_id bigint,
    override_comment character varying(255)
);


ALTER TABLE public.compatibility OWNER TO play;

--
-- Data for Name: compatibility; Type: TABLE DATA; Schema: public; Owner: play
--

COPY compatibility (id, attr1_id, attr2_id, user_id, rating_id, override_comment) FROM stdin;
2	6	11	212249140	1	
3	2	5	212249140	1	
4	2	12	212249140	1	
5	1	13	212249140	1	
6	1	12	212249140	1	
7	4	10	212249140	1	
8	1	9	212249140	1	
9	5	11	212249140	1	
10	3	12	212249140	1	
11	5	9	212249140	1	
12	4	13	212249140	1	
13	6	13	212249140	1	
14	9	10	212249140	1	
15	7	14	212249140	1	
16	2	7	212249140	1	
17	4	9	212249140	1	
18	8	12	212249140	1	
19	8	11	212249140	1	
20	6	12	212249140	1	
21	3	8	212249140	1	
22	9	11	212249140	1	
23	7	9	212249140	1	
24	2	10	212249140	1	
25	4	11	212249140	1	
26	5	8	212249140	1	
27	4	12	212249140	1	
28	7	11	212249140	1	
29	3	6	212249140	1	
30	3	11	212249140	1	
31	5	12	212249140	1	
32	3	14	212249140	1	
33	9	13	212249140	1	
34	1	5	212249140	1	
35	3	13	212249140	1	
36	1	10	212249140	1	
37	6	10	212249140	1	
38	5	10	212249140	1	
40	7	12	212249140	1	
41	6	9	212249140	1	
42	1	8	212249140	1	
43	4	14	212249140	1	
45	3	7	212249140	1	
46	4	8	212249140	1	
47	6	8	212249140	1	
48	1	14	212249140	1	
49	1	11	212249140	1	
50	1	6	212249140	1	
52	9	12	212249140	1	
53	3	5	212249140	1	
54	2	9	212249140	1	
55	7	13	212249140	1	
56	3	10	212249140	1	
57	5	14	212249140	1	
59	9	14	212249140	1	
60	7	8	212249140	1	
61	6	14	212249140	1	
62	8	14	212249140	1	
63	3	9	212249140	1	
64	4	5	212249140	1	
66	1	7	212249140	1	
67	5	13	212249140	1	
68	7	10	212249140	1	
69	2	13	212249140	1	
70	8	10	212249140	1	
71	2	14	212249140	1	
72	4	7	212249140	1	
73	2	11	212249140	1	
74	2	8	212249140	1	
76	2	6	212249140	1	
77	4	6	212249140	1	
78	2	9	-1420972575	1	
79	7	12	-1420972575	1	
80	2	11	-1420972575	1	
82	3	8	-1420972575	1	
83	1	9	-1420972575	1	
84	12	13	-1420972575	1	
85	3	11	-1420972575	1	
86	1	12	-1420972575	1	
87	2	5	-1420972575	1	
88	4	8	-1420972575	1	
89	9	12	-1420972575	1	
91	4	9	-1420972575	1	
92	2	10	-1420972575	1	
93	5	12	-1420972575	1	
95	5	14	-1420972575	1	
96	7	14	-1420972575	1	
97	6	14	-1420972575	1	
1	14	11	212249140	2	
51	13	11	212249140	2	
58	14	12	212249140	2	
44	13	12	212249140	2	
94	11	8	-1420972575	3	
81	13	8	-1420972575	3	
39	13	8	212249140	2	
98	5	9	-1420972575	1	
100	4	5	-1420972575	1	
103	4	13	-1420972575	1	
105	7	9	-1420972575	1	
108	3	13	-1420972575	1	
110	5	13	-1420972575	1	
113	1	11	-1420972575	1	
115	2	14	-1420972575	1	
120	7	13	-1420972575	1	
123	6	8	-1420972575	1	
125	5	11	-1420972575	1	
128	7	11	-1420972575	1	
130	1	8	-1420972575	1	
133	12	14	-1420972575	1	
135	2	12	-1420972575	1	
138	2	8	-1420972575	1	
140	9	10	-1420972575	1	
143	1	13	-1420972575	1	
145	4	12	-1420972575	1	
150	6	13	-1420972575	1	
153	10	8	-1420972575	3	
148	14	10	-1420972575	4	
118	13	10	-1420972575	4	
99	7	10	-1420972575	1	
109	4	11	-1420972575	1	
131	2	13	-1420972575	1	
132	2	6	-1420972575	1	
136	9	13	-1420972575	1	
137	9	11	-1420972575	1	
141	1	6	-1420972575	1	
142	4	7	-1420972575	1	
146	5	8	-1420972575	1	
147	1	14	-1420972575	1	
104	14	8	-1420972575	3	
101	11	13	-1420972575	1	
102	3	12	-1420972575	1	
106	7	8	-1420972575	1	
107	6	11	-1420972575	1	
134	3	6	-1420972575	1	
139	2	7	-1420972575	1	
144	6	10	-1420972575	1	
149	3	10	-1420972575	1	
111	3	9	-1420972575	1	
112	3	7	-1420972575	1	
116	5	10	-1420972575	1	
117	6	12	-1420972575	1	
121	1	7	-1420972575	1	
122	4	6	-1420972575	1	
126	1	10	-1420972575	1	
127	3	14	-1420972575	1	
154	4	10	-1420972575	1	
114	9	14	-1420972575	1	
119	1	5	-1420972575	1	
124	4	14	-1420972575	1	
129	6	9	-1420972575	1	
151	3	5	-1420972575	1	
152	11	14	-1420972575	1	
75	14	10	212249140	2	
65	13	10	212249140	2	
90	12	8	-1420972575	3	
\.


--
-- Name: pk_compatibility; Type: CONSTRAINT; Schema: public; Owner: play; Tablespace: 
--

ALTER TABLE ONLY compatibility
    ADD CONSTRAINT pk_compatibility PRIMARY KEY (id);


--
-- Name: unique_combination; Type: CONSTRAINT; Schema: public; Owner: play; Tablespace: 
--

ALTER TABLE ONLY compatibility
    ADD CONSTRAINT unique_combination UNIQUE (attr1_id, attr2_id, user_id);


--
-- Name: ix_compatibility_attr1_2; Type: INDEX; Schema: public; Owner: play; Tablespace: 
--

CREATE INDEX ix_compatibility_attr1_2 ON compatibility USING btree (attr1_id);


--
-- Name: ix_compatibility_attr2_3; Type: INDEX; Schema: public; Owner: play; Tablespace: 
--

CREATE INDEX ix_compatibility_attr2_3 ON compatibility USING btree (attr2_id);


--
-- Name: ix_compatibility_rating_4; Type: INDEX; Schema: public; Owner: play; Tablespace: 
--

CREATE INDEX ix_compatibility_rating_4 ON compatibility USING btree (rating_id);


--
-- Name: fk_compatibility_attr1_2; Type: FK CONSTRAINT; Schema: public; Owner: play
--

ALTER TABLE ONLY compatibility
    ADD CONSTRAINT fk_compatibility_attr1_2 FOREIGN KEY (attr1_id) REFERENCES attribute(id);


--
-- Name: fk_compatibility_attr2_3; Type: FK CONSTRAINT; Schema: public; Owner: play
--

ALTER TABLE ONLY compatibility
    ADD CONSTRAINT fk_compatibility_attr2_3 FOREIGN KEY (attr2_id) REFERENCES attribute(id);


--
-- Name: fk_compatibility_rating_4; Type: FK CONSTRAINT; Schema: public; Owner: play
--

ALTER TABLE ONLY compatibility
    ADD CONSTRAINT fk_compatibility_rating_4 FOREIGN KEY (rating_id) REFERENCES rating(id);


--
-- PostgreSQL database dump complete
--