NDS:LiquidFeedback/Datenbankeingriffe
< NDS:LiquidFeedback
Version vom 16. Juni 2012, 03:37 Uhr von imported>Wiskyhotel
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;