32253b4d4f4d2eaa1657200ddac26a78ecc2a362
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;
10 -- be naissance live as a date
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
;
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
;
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
;