SN:LiquidFeedback/Datenbankeingriffe

Ä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>