Änderung der Fristen für Anträge zum LPT2010.1 (21.07.2010 19:45)
BEGIN;
UPDATE policy SET "admission_time"='7 days', "discussion_time"='28 days', "verification_time"='7 days', "voting_time"='7 days', "initiative_quorum_num"=20, "initiative_quorum_den"=100 WHERE "id" in (1,2,3,4);
COMMIT;
Neue Themenbereiche und Verfahren für den LPT2010.1 (16.08.2010 17:58)
liquid_feedback_sn=> BEGIN;
BEGIN
liquid_feedback_sn=> INSERT INTO "area" ("name") VALUES
liquid_feedback_sn-> ('Landesparteitag 2010.1 - Programm'),
liquid_feedback_sn-> ('Landesparteitag 2010.1 - Satzung'),
liquid_feedback_sn-> ('Landesparteitag 2010.1 - Sonstiges')
liquid_feedback_sn-> RETURNING "area"."id";
id
----
19
20
21
(3 rows)
INSERT 0 3
liquid_feedback_sn=> INSERT INTO "policy" (
liquid_feedback_sn(> "index", "active", "name",
liquid_feedback_sn(> "admission_time", "discussion_time", "verification_time", "voting_time",
liquid_feedback_sn(> "issue_quorum_num", "issue_quorum_den", "initiative_quorum_num", "initiative_quorum_den",
liquid_feedback_sn(> "majority_num", "majority_den", "majority_strict"
liquid_feedback_sn(> ) VALUES
liquid_feedback_sn-> (9, TRUE, 'LPT 2010.1 - Programmänderungsantrag',
liquid_feedback_sn(> '7 days', '14 days', '4 days', '7 days',
liquid_feedback_sn(> 10, 100, 10, 100,
liquid_feedback_sn(> 2, 3, FALSE ),
liquid_feedback_sn-> (10, TRUE, 'LPT 2010.1 - Satzungsänderungsantrag',
liquid_feedback_sn(> '7 days', '14 days', '4 days', '7 days',
liquid_feedback_sn(> 10, 100, 10, 100,
liquid_feedback_sn(> 2, 3, FALSE ),
liquid_feedback_sn-> (11, TRUE, 'LPT 2010.1 - Sonstiger Antrag',
liquid_feedback_sn(> '7 days', '14 days', '4 days', '7 days',
liquid_feedback_sn(> 10, 100, 10, 100,
liquid_feedback_sn(> 1, 2, TRUE )
liquid_feedback_sn-> RETURNING "policy"."id";
id
----
10
11
12
(3 rows)
INSERT 0 3
liquid_feedback_sn=> INSERT INTO "allowed_policy" ("area_id", "policy_id") VALUES (19,10), (20,11), (21,12);
INSERT 0 3
<\pre>
