 -- Name: group_memberships_group_id_user_id_unique; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
-ALTER TABLE ONLY group_memberships
+ALTER TABLE ONLY public.group_memberships
     ADD CONSTRAINT group_memberships_group_id_user_id_unique UNIQUE (group_id, user_id);
 
 

    NULL::bigint AS user_id,
    c.id AS comment_id,
    (setweight(to_tsvector('english'::regconfig, c.text), 'C'::"char") || setweight(to_tsvector('english'::regconfig, (u.name)::text), 'D'::"char")) AS document
   FROM (comments c
     JOIN users u ON ((u.id = c.user_id)))
  WHERE ((c.active = true) AND (u.active = true))
  WITH NO DATA;


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

ALTER TABLE ONLY public.groups
    ADD CONSTRAINT groups_pkey PRIMARY KEY (id);


