 -- Name: uq_no_multiple_contributor_2; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
-ALTER TABLE ONLY contributions
+ALTER TABLE ONLY public.contributions
     ADD CONSTRAINT uq_no_multiple_contributor_2 UNIQUE (post_id, user_id);
 
 

-- Name: post_community_unique; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY communities_posts
    ADD CONSTRAINT post_community_unique UNIQUE (post_id, community_id);



-- Name: notifications_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.notifications
    ADD CONSTRAINT notifications_pkey PRIMARY KEY (id);


