0337d704 |
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; |