https://wikimirror.piraten.tools/wiki/index.php?action=history&feed=atom&title=SN%3ALiquidFeedback%2FDatenbankeingriffe
SN:LiquidFeedback/Datenbankeingriffe - Versionsgeschichte
2026-05-31T16:43:23Z
Versionsgeschichte dieser Seite in Piratenwiki Mirror
MediaWiki 1.35.14
https://wikimirror.piraten.tools/wiki/index.php?title=SN:LiquidFeedback/Datenbankeingriffe&diff=55678443&oldid=prev
92.75.203.101 am 10. September 2010 um 11:00 Uhr
2010-09-10T11:00:20Z
<p></p>
<p><b>Neue Seite</b></p><div>===Änderung der Fristen für Anträge zum LPT2010.1 (21.07.2010 19:45)===<br />
<br />
<pre><br />
BEGIN;<br />
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);<br />
COMMIT;<br />
</pre><br />
<br />
===Neue Themenbereiche und Verfahren für den LPT2010.1 (16.08.2010 17:58)===<br />
<br />
<pre><br />
liquid_feedback_sn=> BEGIN;<br />
BEGIN<br />
liquid_feedback_sn=> INSERT INTO "area" ("name") VALUES<br />
liquid_feedback_sn-> ('Landesparteitag 2010.1 - Programm'),<br />
liquid_feedback_sn-> ('Landesparteitag 2010.1 - Satzung'),<br />
liquid_feedback_sn-> ('Landesparteitag 2010.1 - Sonstiges')<br />
liquid_feedback_sn-> RETURNING "area"."id";<br />
id <br />
----<br />
19<br />
20<br />
21<br />
(3 rows)<br />
<br />
INSERT 0 3<br />
liquid_feedback_sn=> INSERT INTO "policy" (<br />
liquid_feedback_sn(> "index", "active", "name",<br />
liquid_feedback_sn(> "admission_time", "discussion_time", "verification_time", "voting_time",<br />
liquid_feedback_sn(> "issue_quorum_num", "issue_quorum_den", "initiative_quorum_num", "initiative_quorum_den",<br />
liquid_feedback_sn(> "majority_num", "majority_den", "majority_strict"<br />
liquid_feedback_sn(> ) VALUES<br />
liquid_feedback_sn-> (9, TRUE, 'LPT 2010.1 - Programmänderungsantrag',<br />
liquid_feedback_sn(> '7 days', '14 days', '4 days', '7 days',<br />
liquid_feedback_sn(> 10, 100, 10, 100,<br />
liquid_feedback_sn(> 2, 3, FALSE ),<br />
liquid_feedback_sn-> (10, TRUE, 'LPT 2010.1 - Satzungsänderungsantrag',<br />
liquid_feedback_sn(> '7 days', '14 days', '4 days', '7 days',<br />
liquid_feedback_sn(> 10, 100, 10, 100,<br />
liquid_feedback_sn(> 2, 3, FALSE ),<br />
liquid_feedback_sn-> (11, TRUE, 'LPT 2010.1 - Sonstiger Antrag',<br />
liquid_feedback_sn(> '7 days', '14 days', '4 days', '7 days',<br />
liquid_feedback_sn(> 10, 100, 10, 100,<br />
liquid_feedback_sn(> 1, 2, TRUE )<br />
liquid_feedback_sn-> RETURNING "policy"."id";<br />
id <br />
----<br />
10<br />
11<br />
12<br />
(3 rows)<br />
<br />
INSERT 0 3<br />
liquid_feedback_sn=> INSERT INTO "allowed_policy" ("area_id", "policy_id") VALUES (19,10), (20,11), (21,12);<br />
INSERT 0 3<br />
<\pre><br />
<br />
</pre><br />
<br />
[[Kategorie:SN:LiquidFeedback]]</div>
92.75.203.101