Backlog Courrier

Réaliser pour le CD45

a modifier :

CREATE TABLE redirected_baskets
      (
      id serial NOT NULL,
      actual_user_id INTEGER NOT NULL,
      owner_user_id INTEGER NOT NULL,
      basket_id character varying(255) NOT NULL,
      group_id INTEGER NOT NULL,
      CONSTRAINT redirected_baskets_pkey PRIMARY KEY (id),
      CONSTRAINT redirected_baskets_unique_key UNIQUE (owner_user_id, basket_id, group_id)
      )
      WITH (OIDS=FALSE);

      INSERT INTO redirected_baskets (owner_user_id, actual_user_id, basket_id, group_id) SELECT users.id, us.id, user_abs.basket_id, usergroups.id FROM usergroups, usergroup_content, user_abs, groupbasket, users, users us
        where usergroup_content.group_id = usergroups.group_id
        and usergroup_content.user_id = user_abs.user_abs
        and users.user_id = user_abs.user_abs
        and us.user_id = user_abs.new_user
        and groupbasket.group_id = usergroup_content.group_id
        and groupbasket.basket_id = user_abs.basket_id;

Remplacer par :

CREATE TABLE redirected_baskets
        (
        id serial NOT NULL,
        actual_user_id INTEGER NOT NULL,
        owner_user_id INTEGER NOT NULL,
        basket_id character varying(255) NOT NULL,
        group_id INTEGER NOT NULL,
        CONSTRAINT redirected_baskets_pkey PRIMARY KEY (id)--,
        --CONSTRAINT redirected_baskets_unique_key UNIQUE (owner_user_id, basket_id, group_id)
        )
        WITH (OIDS=FALSE);

        --Insertion des lignes (avec les doublons dans la table)
        INSERT INTO redirected_baskets (owner_user_id, actual_user_id, basket_id, group_id) SELECT users.id, us.id, user_abs.basket_id, usergroups.id FROM usergroups, usergroup_content, user_abs, groupbasket, users, users us
        where usergroup_content.group_id = usergroups.group_id
        and usergroup_content.user_id = user_abs.user_abs
        and users.user_id = user_abs.user_abs
        and us.user_id = user_abs.new_user
        and groupbasket.group_id = usergroup_content.group_id
        and groupbasket.basket_id = user_abs.basket_id;

        --suppression des lignes en doublons
        DELETE FROM redirected_baskets a USING redirected_baskets b where a.id > b.id
        AND a.actual_user_id = b.actual_user_id
        AND a.owner_user_id = b.owner_user_id
        AND a.basket_id = b.basket_id;