upgrade/0.9.3/30_auth_user_md5.sql

   1 --
   2 -- PERMS
   3 --
   4 alter table auth_user_md5 change column perms perms enum('user','admin','non-inscrit','pending','disabled');
   5 update auth_user_md5 set perms='pending' where perms='non-inscrit';
   6 alter table auth_user_md5 change column perms perms enum('user','admin','pending','disabled');
   7 alter table auth_user_md5 change column comment comment varchar(64) not null;
   8
   9 --
  10 -- be naissance live as a date
  11 --
  12
  13 alter table auth_user_md5 add column foo int;
  14 update auth_user_md5 set foo=naissance ;
  15 alter table auth_user_md5 change column naissance naissance date not null;
  16 update auth_user_md5 set naissance = concat(foo % 10000, '-', (foo / 10000) % 100, '-', foo / 1000000);
  17 alter table auth_user_md5 drop column foo;
  18
  19 alter table en_cours add column foo int;
  20 update en_cours set foo=naissance ;
  21 alter table en_cours change column naissance naissance date not null;
  22 update en_cours set naissance = concat(foo % 10000, '-', (foo / 10000) % 100, '-', foo / 1000000);
  23 alter table en_cours drop column foo;
  24
  25 --
  26 -- webredirect
  27 --
  28
  29 alter table auth_user_quick add column redirecturl varchar(255) not null;
  30 replace into auth_user_quick (user_id,lastnewslogin,skin,watch_flags,watch_last,redirecturl)
  31       select q.user_id,q.lastnewslogin,q.skin,q.watch_flags,q.watch_last,u.redirecturl
  32         from auth_user_md5   as u
  33   inner join auth_user_quick as q USING(user_id)
  34        where u.redirecturl!='';
  35 alter table auth_user_md5 drop column redirecturl;