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