HH:LiquidFeedback/Datenbankeingriffe

2010-06-23 23:10 UTC+02 (Jbe): Umbenennung des Themenbereichs #16 (Urheberrecht) in "Immaterialgüter- und Internetrecht"

liquid_feedback_hh=> BEGIN;
BEGIN
liquid_feedback_hh=> SELECT id, name FROM area WHERE name = 'Urheberrecht';
 id |     name     
----+--------------
 16 | Urheberrecht
(1 row)

liquid_feedback_hh=> UPDATE area SET name = 'Immaterialgüter- und Internetrecht' WHERE id=16;
UPDATE 1
liquid_feedback_hh=> COMMIT;
COMMIT

2010-06-27 18:10 UTC+02 (Jbe): Sperrung von Accounts

liquid_feedback_hh=> BEGIN;
BEGIN
liquid_feedback_hh=> UPDATE member SET active = FALSE
liquid_feedback_hh->   FROM invite_code
liquid_feedback_hh->   WHERE member.id = invite_code.member_id
liquid_feedback_hh->   AND invite_code.code IN (
liquid_feedback_hh(>     '[...]',
liquid_feedback_hh(>     '[...]'
liquid_feedback_hh(>   );
UPDATE 2
liquid_feedback_hh=> COMMIT;
COMMIT