bdbb273b60e862a786584fb8fae333f0debd8baa
1 alter table watch_cat
add column type enum('basic', 'near', 'often') not null default 'basic';
2 update watch_cat
set type='often' where frequent
=1;
3 alter table watch_cat
drop column frequent
;
5 alter table watch_cat
add mail_sg
varchar(80) default NULL after mail
;
6 update watch_cat
set mail_sg
= 'Ce camarade a mis sa fiche à jour' where id = 1;
7 update watch_cat
set mail_sg
= 'Ce camarade s\'est inscrit' where id = 2;
8 update watch_cat
set mail_sg
= 'Ce camarade nous a quitté' where id = 3;
10 insert into watch_cat (id, short
, mail
, mail_sg
, type)
11 values(4, 'Anniversaires', 'Ces camarades fêtent leur anniversaire cette semaine', 'Ce camarade fête son anniversaire cette semaine', 'near');
12 replace into watch_sub (uid
, cid
) select user_id
, 4 from auth_user_md5
where perms
in ('admin', 'user') and deces
=0;