NDS:LiquidFeedback/Datenbankeingriffe

Aus Piratenwiki
Wechseln zu: Navigation, Suche

2010-07-25 (Björn): Einfrieren von Themen wegen anstehendem Parteitag

Ausgefuehrt: Sun Jul 25 10:26:59 CEST 2010

update issue set half_frozen = now() WHERE issue.id IN ( 5, 8, 10, 14, 15, 17, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29, 32, 35, 36, 38, 39, 40, 42, 43, 44, 46, 47, 49 ) and half_frozen isnull;

2010-07-26 (Björn): Einfrieren von Themen wegen anstehendem Parteitag

select manual_freeze(issue.id) from issue WHERE issue.id IN ( 5, 8, 10, 14, 15, 17, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29, 32, 35, 36, 38, 39, 40, 42, 43, 44, 46, 47, 49 ) and fully_frozen isnull;
update issue set voting_time = '2010-08-02 05:00'::timestamp - now() WHERE issue.id IN ( 5, 8, 10, 14, 15, 17, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29, 32, 35, 36, 38, 39, 40, 42, 43, 44, 46, 47, 49 );

2010-07-30 (Björn): Einfrieren von Themen wegen anstehendem Parteitag

select manual_freeze(50);
update issue set voting_time = '2010-08-02 05:00'::timestamp - now() WHERE issue.id = 50;