-- Add to organization_requirement
INSERT INTO organization_requirement (organization_id, role, "any", "all", required)
SELECT sf.id, 180, TRUE, FALSE, TRUE
FROM (
  SELECT o.id FROM organization o
    JOIN region_zip_code_customer rzcc
    ON o.zip_code = rzcc.zip_code
  WHERE rzcc.region_id = 1
) sf;

-- # rows inserted:
-- check
SELECT * FROM organization_requirement WHERE role = 180;


-- Add to organization_requirement_attribute using organization_requirement_id
-- attribute_id = 39, 40
INSERT INTO organization_requirement_attribute (organization_requirement_id, attribute_id)
  SELECT org_req.id, 39
  FROM
    (SELECT id FROM organization_requirement WHERE role = 180) org_req;

INSERT INTO organization_requirement_attribute (organization_requirement_id, attribute_id)
  SELECT org_req.id, 40
  FROM
    (SELECT id FROM organization_requirement WHERE role = 180) org_req;

-- # rows inserted:
-- check
SELECT * FROM organization_requirement_attribute
WHERE attribute_id = 39 OR attribute_id = 40;


-- Add barback role to users
INSERT INTO user_role (user_id, role)
VALUES
  (10600, 180),
  (8925, 180),
  (7823, 180),
  (11283, 180),
  (1415, 180),
  (2951, 180),
  (4692, 180),
  (4959, 180),
  (12907, 180),
  (10190, 180),
  (10608, 180),
  (11002, 180),
  (12306, 180),
  (11581, 180),
  (13802, 180),
  (13559, 180),
  (11317, 180),
  (11672, 180),
  (12609, 180),
  (12628, 180),
  (12654, 180),
  (10631, 180),
  (5532, 180),
  (12405, 180),
  (3004, 180),
  (13828, 180),
  (12694, 180),
  (14726, 180),
  (12481, 180),
  (14488, 180),
  (14433, 180),
  (12815, 180),
  (12987, 180),
  (12096, 180),
  (11073, 180),
  (12990, 180),
  (12369, 180),
  (13301, 180),
  (14988, 180),
  (14271, 180),
  (12885, 180),
  (13876, 180),
  (13384, 180),
  (14179, 180),
  (14178, 180),
  (9380, 180),
  (58, 180),
  (14049, 180),
  (13506, 180),
  (14087, 180),
  (14225, 180),
  (13524, 180),
  (13531, 180),
  (16139, 180),
  (15020, 180),
  (13599, 180),
  (12407, 180),
  (14854, 180),
  (13068, 180),
  (13095, 180),
  (6617, 180),
  (15288, 180),
  (16210, 180),
  (15350, 180),
  (1486, 180),
  (15527, 180),
  (15576, 180),
  (16137, 180),
  (16590, 180),
  (16341, 180),
  (16371, 180),
  (15818, 180),
  (14938, 180),
  (16842, 180),
  (10146, 180),
  (15111, 180),
  (17116, 180),
  (12910, 180),
  (898, 180),
  (1025, 180),
  (1386, 180),
  (2357, 180),
  (2431, 180),
  (2495, 180),
  (4499, 180),
  (4885, 180),
  (4964, 180),
  (7461, 180),
  (10631, 180),
  (12096, 180),
  (13061, 180),
  (13321, 180),
  (14245, 180),
  (14727, 180),
  (18801, 180),
  (19363, 180),
  (18967, 180),
  (18949, 180)
ON CONFLICT DO NOTHING;

-- Add barback attributes to users
INSERT INTO user_attribute
    (user_id, attribute_id)
VALUES
    ( 10600 ,  38 ),
    ( 10600 ,  39 ),
    ( 8925  ,  38 ),
    ( 8925  ,  39 ),
    ( 7823  ,  38 ),
    ( 7823  ,  39 ),
    ( 11283 ,  38 ),
    ( 11283 ,  39 ),
    ( 1415  ,  38 ),
    ( 1415  ,  39 ),
    ( 1415  ,  40 ),
    ( 2951  ,  38 ),
    ( 2951  ,  39 ),
    ( 4692  ,  38 ),
    ( 4959  ,  38 ),
    ( 12907 ,  38 ),
    ( 12907 ,  39 ),
    ( 12907 ,  40 ),
    ( 10190 ,  38 ),
    ( 10608 ,  38 ),
    ( 10608 ,  39 ),
    ( 11002 ,  38 ),
    ( 12306 ,  38 ),
    ( 12306 ,  39 ),
    ( 11581 ,  38 ),
    ( 13802 ,  38 ),
    ( 13802 ,  39 ),
    ( 13559 ,  38 ),
    ( 13559 ,  39 ),
    ( 13559 ,  40 ),
    ( 11317 ,  38 ),
    ( 11672 ,  38 ),
    ( 11672 ,  39 ),
    ( 12609 ,  38 ),
    ( 12609 ,  39 ),
    ( 12628 ,  38 ),
    ( 12628 ,  39 ),
    ( 12628 ,  40 ),
    ( 12654 ,  38 ),
    ( 12654 ,  39 ),
    ( 10631 ,  38 ),
    ( 10631 ,  39 ),
    ( 5532  ,  38 ),
    ( 5532  ,  39 ),
    ( 12405 ,  38 ),
    ( 3004  ,  38 ),
    ( 13828 ,  38 ),
    ( 13828 ,  39 ),
    ( 13828 ,  40 ),
    ( 12694 ,  38 ),
    ( 12694 ,  39 ),
    ( 14726 ,  38 ),
    ( 14726 ,  39 ),
    ( 14726 ,  40 ),
    ( 12481 ,  38 ),
    ( 12481 ,  39 ),
    ( 12481 ,  40 ),
    ( 14488 ,  38 ),
    ( 14488 ,  39 ),
    ( 14488 ,  40 ),
    ( 14433 ,  38 ),
    ( 14433 ,  39 ),
    ( 14433 ,  40 ),
    ( 12815 ,  38 ),
    ( 12815 ,  39 ),
    ( 12815 ,  40 ),
    ( 12987 ,  38 ),
    ( 12987 ,  39 ),
    ( 12987 ,  40 ),
    ( 12096 ,  38 ),
    ( 12096 ,  39 ),
    ( 11073 ,  38 ),
    ( 11073 ,  39 ),
    ( 11073 ,  40 ),
    ( 12990 ,  38 ),
    ( 12990 ,  39 ),
    ( 12369 ,  38 ),
    ( 12369 ,  39 ),
    ( 12369 ,  40 ),
    ( 13301 ,  38 ),
    ( 14988 ,  38 ),
    ( 14271 ,  38 ),
    ( 12885 ,  38 ),
    ( 12885 ,  39 ),
    ( 12885 ,  40 ),
    ( 13876 ,  38 ),
    ( 13876 ,  39 ),
    ( 13876 ,  40 ),
    ( 13384 ,  38 ),
    ( 13384 ,  39 ),
    ( 14179 ,  38 ),
    ( 14179 ,  39 ),
    ( 14178 ,  38 ),
    ( 14178 ,  39 ),
    ( 14178 ,  40 ),
    ( 9380  ,  38 ),
    ( 58    ,  38 ),
    ( 58    ,  39 ),
    ( 14049 ,  38 ),
    ( 14049 ,  39 ),
    ( 13506 ,  38 ),
    ( 14087 ,  38 ),
    ( 14225 ,  38 ),
    ( 13524 ,  38 ),
    ( 13524 ,  39 ),
    ( 13531 ,  38 ),
    ( 13531 ,  39 ),
    ( 13531 ,  40 ),
    ( 16139 ,  38 ),
    ( 16139 ,  39 ),
    ( 15020 ,  38 ),
    ( 15020 ,  39 ),
    ( 13599 ,  38 ),
    ( 13599 ,  39 ),
    ( 13599 ,  40 ),
    ( 12407 ,  38 ),
    ( 12407 ,  39 ),
    ( 14854 ,  38 ),
    ( 13068 ,  38 ),
    ( 13068 ,  39 ),
    ( 13068 ,  40 ),
    ( 13095 ,  38 ),
    ( 13095 ,  39 ),
    ( 13095 ,  40 ),
    ( 6617  ,  38 ),
    ( 6617  ,  39 ),
    ( 15288 ,  38 ),
    ( 15288 ,  39 ),
    ( 16210 ,  38 ),
    ( 16210 ,  39 ),
    ( 16210 ,  40 ),
    ( 15350 ,  38 ),
    ( 15350 ,  39 ),
    ( 15350 ,  40 ),
    ( 1486  ,  38 ),
    ( 1486  ,  39 ),
    ( 1486  ,  40 ),
    ( 15527 ,  38 ),
    ( 15527 ,  39 ),
    ( 15527 ,  40 ),
    ( 15576 ,  38 ),
    ( 15576 ,  39 ),
    ( 16137 ,  38 ),
    ( 16137 ,  39 ),
    ( 16590 ,  38 ),
    ( 16590 ,  39 ),
    ( 16590 ,  40 ),
    ( 16341 ,  38 ),
    ( 16341 ,  39 ),
    ( 16371 ,  38 ),
    ( 16371 ,  39 ),
    ( 15818 ,  38 ),
    ( 15818 ,  39 ),
    ( 14938 ,  38 ),
    ( 14938 ,  39 ),
    ( 16842 ,  38 ),
    ( 16842 ,  39 ),
    ( 10146 ,  38 ),
    ( 10146 ,  39 ),
    ( 10146 ,  40 ),
    ( 15111 ,  38 ),
    ( 15111 ,  39 ),
    ( 15111 ,  40 ),
    ( 17116 ,  38 ),
    ( 17116 ,  39 ),
    ( 12910 ,  38 ),
    ( 12910 ,  39 ),
    ( 12910 ,  40 ),
    ( 898   ,  38 ),
    ( 1025  ,  38 ),
    ( 1025  ,  39 ),
    ( 1025  ,  40 ),
    ( 1386  ,  38 ),
    ( 2357  ,  38 ),
    ( 2357  ,  39 ),
    ( 2431  ,  38 ),
    ( 2431  ,  39 ),
    ( 2495  ,  38 ),
    ( 2495  ,  39 ),
    ( 4499  ,  38 ),
    ( 4499  ,  39 ),
    ( 4885  ,  38 ),
    ( 4964  ,  38 ),
    ( 7461  ,  38 ),
    ( 7461  ,  39 ),
    ( 7461  ,  40 ),
    ( 10631 ,  38 ),
    ( 10631 ,  39 ),
    ( 12096 ,  38 ),
    ( 12096 ,  39 ),
    ( 12096 ,  40 ),
    ( 13061 ,  38 ),
    ( 13321 ,  38 ),
    ( 14245 ,  38 ),
    ( 14727 ,  38 ),
    ( 18801 ,  38 ),
    ( 18801 ,  39 ),
    ( 18801 ,  40 ),
    ( 19363 ,  38 ),
    ( 19363 ,  39 ),
    ( 18967 ,  38 ),
    ( 18967 ,  39 ),
    ( 18949 ,  38 ),
    ( 18949 ,  39 ),
    ( 18949 ,  40 )
  ON CONFLICT DO NOTHING;