text: BEGIN;
  SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
  
  INSERT INTO "direct_voter" ("member_id", "issue_id") VALUES
    ( 8, 1),
    ( 9, 1),
    (11, 1),
    (12, 1),
    (14, 1),
    (19, 1),
    (20, 1),
    (21, 1);
  
  INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES
    ( 8, 1, 1,  1),
    ( 8, 1, 2,  1),
    ( 8, 1, 3,  1),
    ( 8, 1, 4,  1),
    ( 8, 1, 5,  1),
    ( 8, 1, 6, -1),
    ( 8, 1, 7, -1),
    ( 9, 1, 1, -2),
    ( 9, 1, 2, -3),
    ( 9, 1, 3, -2),
    ( 9, 1, 4, -2),
    ( 9, 1, 5, -2),
    ( 9, 1, 6, -1),
    (11, 1, 1, -1),
    (11, 1, 2, -1),
    (11, 1, 3, -1),
    (11, 1, 4, -1),
    (11, 1, 5, -1),
    (11, 1, 6,  2),
    (11, 1, 7,  1),
    (12, 1, 1, -1),
    (12, 1, 3, -1),
    (12, 1, 4, -1),
    (12, 1, 5, -1),
    (12, 1, 6, -2),
    (12, 1, 7,  1),
    (14, 1, 1,  1),
    (14, 1, 2,  3),
    (14, 1, 3,  1),
    (14, 1, 4,  2),
    (14, 1, 5,  1),
    (14, 1, 6,  1),
    (14, 1, 7,  1),
    (19, 1, 1,  3),
    (19, 1, 2,  4),
    (19, 1, 3,  2),
    (19, 1, 4,  2),
    (19, 1, 5,  2),
    (19, 1, 7,  1),
    (20, 1, 1,  1),
    (20, 1, 2,  2),
    (20, 1, 3,  1),
    (20, 1, 4,  1),
    (20, 1, 5,  1),
    (21, 1, 5, -1);
  
  INSERT INTO "direct_voter" ("member_id", "issue_id") VALUES
    ( 1, 2),
    ( 2, 2),
    ( 3, 2),
    ( 4, 2),
    ( 5, 2),
    ( 6, 2),
    ( 7, 2),
    ( 8, 2),
    ( 9, 2),
    (10, 2),
    (11, 2),
    (12, 2),
    (13, 2),
    (14, 2),
    (15, 2),
    (16, 2),
    (17, 2),
    (18, 2),
    (19, 2),
    (20, 2);
  
  INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES
    ( 1, 2,  8,  3),
    ( 1, 2,  9,  4),
    ( 1, 2, 10,  2),
    ( 1, 2, 11,  1),
    ( 2, 2,  8,  3),
    ( 2, 2,  9,  4),
    ( 2, 2, 10,  2),
    ( 2, 2, 11,  1),
    ( 3, 2,  8,  4),
    ( 3, 2,  9,  3),
    ( 3, 2, 10,  2),
    ( 3, 2, 11,  1),
    ( 4, 2,  8,  4),
    ( 4, 2,  9,  3),
    ( 4, 2, 10,  2),
    ( 4, 2, 11,  1),
    ( 5, 2,  8,  4),
    ( 5, 2,  9,  3),
    ( 5, 2, 10,  2),
    ( 5, 2, 11,  1),
    ( 6, 2,  8,  4),
    ( 6, 2,  9,  3),
    ( 6, 2, 10,  2),
    ( 6, 2, 11,  1),
    ( 7, 2,  8,  4),
    ( 7, 2,  9,  3),
    ( 7, 2, 10,  2),
    ( 7, 2, 11,  1),
    ( 8, 2,  8,  4),
    ( 8, 2,  9,  3),
    ( 8, 2, 10,  2),
    ( 8, 2, 11,  1),
    ( 9, 2,  8, -1),
    ( 9, 2,  9,  1),
    ( 9, 2, 10,  3),
    ( 9, 2, 11,  2),
    (10, 2,  8, -1),
    (10, 2,  9,  1),
    (10, 2, 10,  3),
    (10, 2, 11,  2),
    (11, 2,  8, -1),
    (11, 2,  9,  1),
    (11, 2, 10,  3),
    (11, 2, 11,  2),
    (12, 2,  8, -1),
    (12, 2,  9,  1),
    (12, 2, 10,  3),
    (12, 2, 11,  2),
    (13, 2,  8, -1),
    (13, 2,  9,  1),
    (13, 2, 10,  3),
    (13, 2, 11,  2),
    (14, 2,  8, -1),
    (14, 2,  9,  1),
    (14, 2, 10,  3),
    (14, 2, 11,  2),
    (15, 2,  8, -1),
    (15, 2,  9, -3),
    (15, 2, 10, -4),
    (15, 2, 11, -2),
    (16, 2,  8, -1),
    (16, 2,  9, -3),
    (16, 2, 10, -4),
    (16, 2, 11, -2),
    (17, 2,  8, -1),
    (17, 2,  9, -3),
    (17, 2, 10, -4),
    (17, 2, 11, -2),
    (18, 2,  8, -1),
    (18, 2,  9,  1),
    (18, 2, 10, -2),
    (18, 2, 11,  2),
    (19, 2,  8, -1),
    (19, 2,  9,  1),
    (19, 2, 10, -2),
    (19, 2, 11,  2),
    (20, 2,  8,  1),
    (20, 2,  9,  2),
    (20, 2, 10, -1),
    (20, 2, 11,  3);
  
  SELECT "time_warp"('1 hour 1 minute');
  
  
  END;
  