2 -- purpose: add logo image support for any group
4 ALTER TABLE groups ADD COLUMN logo_image_id int;
5 UPDATE groups SET logo_image_id=100;
6 ALTER TABLE groups ALTER COLUMN logo_image_id SET NOT NULL;
7 ALTER TABLE groups ALTER COLUMN logo_image_id SET DEFAULT 100;