1 BEGIN;

2

3 INSERT INTO "member" ("login", "name", "ident_number") VALUES

4 ('bernd', 'Bernd', '002'),

5 ('cesar', 'Cesar', '003'),

6 ('doris', 'Doris', '004'),

7 ('emil', 'Emil', '005'),

8 ('frank', 'Frank', '006'),

9 ('gerhard', 'Gerhard', '007'),

10 ('hugo', 'Hugo', '008'),

11 ('ines', 'Ines', '009'),

12 ('johann', 'Johann', '010'),

13 ('klaus', 'Klaus', '011'),

14 ('lisa', 'Lisa', '012'),

15 ('monika', 'Monika', '013'),

16 ('norbert', 'Norbert', '014'),

17 ('olaf', 'Olaf', '015'),

18 ('peter', 'Peter', '016'),

19 ('quinn', 'Quinn', '017'),

20 ('ralf', 'Ralf', '018'),

21 ('sabine', 'Sabine', '019'),

22 ('tobias', 'Tobias', '020'),

23 ('ulla', 'Ulla', '021'),

24 ('vincent', 'Vincent', '022'),

25 ('wolfgang', 'Wolfgang', '023'),

26 ('xavier', 'Xavier', '024'),

27 ('yoko', 'Yoko', '025'),

28 ('zareb', 'Zareb', '026');

29

30 INSERT INTO "issue" ("area_id", "policy_id") VALUES (1, 3);

31 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #1');

32 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #2');

33 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #3');

34 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #4');

35 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #5');

36 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #6');

37 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #7');

38 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #8');

39 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #9');

40 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #10');

41 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #11');

42 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #12');

43 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #13');

44 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #14');

45 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #15');

46 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #16');

47 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #17');

48 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #18');

49 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #19');

50 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #20');

51 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #21');

52 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #22');

53 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #23');

54 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #24');

55 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #25');

56 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #26');

57 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #27');

58 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #28');

59 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #29');

60 INSERT INTO "initiative" ("issue_id", "name") VALUES (1, 'Initiative #30');

61

62 INSERT INTO "draft" ("initiative_id", "content") SELECT "id", 'Lorem ipsum ...' FROM "initiative";

63 INSERT INTO "initiator" ("member_id", "initiative_id") SELECT 1, "id" FROM "initiative";

64 INSERT INTO "supporter" ("member_id", "initiative_id", "draft_id") SELECT "member"."id", "initiative"."id", "initiative"."id" FROM "member", "initiative";

65

66 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 1, 1);

67 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 2, 2);

68 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 3, 3);

69 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 4, 4);

70 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 5, 5);

71 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 6, 6);

72 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 7, 7);

73 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 8, 8);

74 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 9, 9);

75 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 10, 10);

76 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 11, 11);

77 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 12, 12);

78 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 13, 13);

79 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 14, 14);

80 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 15, 15);

81 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 16, 16);

82 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 17, 17);

83 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 18, 18);

84 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 19, 19);

85 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 20, 20);

86 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 21, 21);

87 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 22, 22);

88 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 23, 23);

89 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 24, 24);

90 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 25, 25);

91 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 26, 26);

92 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 27, 27);

93 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 28, 28);

94 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 29, 29);

95 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (1, 1, 30, 30);

96

97 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 1, 2);

98 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 2, 1);

99 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 3, 3);

100 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 4, 4);

101 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 5, 5);

102 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 6, 6);

103 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 7, 7);

104 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 8, 8);

105 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 9, 9);

106 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 10, 10);

107 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 11, 11);

108 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 12, 12);

109 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 13, 13);

110 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 14, 14);

111 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 15, 15);

112 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 16, 16);

113 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 17, 17);

114 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 18, 18);

115 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 19, 19);

116 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 20, 20);

117 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 21, 21);

118 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 22, 22);

119 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 23, 23);

120 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 24, 24);

121 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 25, 25);

122 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 26, 26);

123 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 27, 27);

124 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 28, 28);

125 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 29, 29);

126 INSERT INTO "vote" ("member_id", "issue_id", "initiative_id", "grade") VALUES (2, 1, 30, 30);

127

128

129 SELECT check_issues();

130 UPDATE issue SET frozen = now();

131

132 END;

133

134 -- UPDATE issue SET closed = now();