SN:LiquidFeedback/Datenbankeingriffe
Version vom 10. September 2010, 13:00 Uhr von 92.75.203.101 (Diskussion)
Ä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>