| 1 | -- passage à diogenes |
| 2 | ALTER TABLE logger.sessions ADD `auth` ENUM( 'native' ) DEFAULT 'native' NOT NULL AFTER `id`; |
| 3 | ALTER TABLE logger.sessions ADD `sauth` ENUM( 'native' ) DEFAULT 'native' NOT NULL AFTER `host`; |
| 4 | INSERT INTO logger.actions SET text="connexion_auth_ext",description="connection via l'auth des groupes X"; |
| 5 | |
| 6 | -- modifs diogenes/logger |
| 7 | ALTER TABLE logger.events DROP `id` ; |
| 8 | ALTER TABLE logger.sessions ADD INDEX ( `uid` ); |
| 9 | ALTER TABLE logger.sessions ADD INDEX ( `uid` ); |
| 10 | ALTER TABLE logger.events ADD INDEX ( `session` ); |
| 11 | DROP TABLE x4dat.log; |
| 12 | |
| 13 | drop trackers; |
| 14 | -------------------------------------------------------------------------------- |
| 15 | |
| 16 | |
| 17 | -------------------------------------------------------------------------------- |
| 18 | -- X4DAT |
| 19 | -------------------------------------------------------------------------------- |
| 20 | -- pas sur que je veuille le dropper pr le moment celui la ... a voir |
| 21 | --*-- ALTER TABLE x4dat.auth_user_md5 DROP COLUMN lastnewslogin; |
| 22 | |
| 23 | -- cgt de type pour les ML |
| 24 | ALTER TABLE x4dat.requests CHANGE `type` `type` ENUM('alias','epouse','liste','photo','sondage','emploi','evts' ) DEFAULT 'alias' NOT NULL; |
| 25 | -- lastlogin --> logger |
| 26 | ALTER TABLE x4dat.auth_user_md5 DROP COLUMN lastlogin; |
| 27 | ALTER TABLE x4dat.auth_user_md5 DROP COLUMN host; |
| 28 | -- drop du soundex |
| 29 | ALTER TABLE x4dat.auth_user_md5 DROP COLUMN nom_soundex; |
| 30 | ALTER TABLE x4dat.auth_user_md5 DROP COLUMN prenom_soundex; |
| 31 | ALTER TABLE x4dat.auth_user_md5 DROP COLUMN epouse_soundex; |
| 32 | -- drop des anciens alias --> aliases |
| 33 | alter table x4dat.aliases add column expire date; |
| 34 | delete from x4dat.aliases where `type` LIKE 'liste-%'; |
| 35 | ALTER TABLE x4dat.aliases CHANGE `type` `type` ENUM( 'a_vie', 'epouse', 'alias', 'homonyme', 'liste' ) DEFAULT 'alias' NOT NULL; |
| 36 | delete from x4dat.aliases where type=''; |
| 37 | |
| 38 | -- auth_user_md5 |
| 39 | update x4dat.aliases as a inner join x4dat.auth_user_md5 as u ON(u.loginbis=a.alias) |
| 40 | set a.expire=ADDDATE(u.date_mise_alias_temp,INTERVAL 1 MONTH) |
| 41 | WHERE u.date_mise_alias_temp!='' AND u.date_mise_alias_temp!='0000-00-00'; |
| 42 | update x4dat.aliases as a inner join x4dat.auth_user_md5 as u ON(u.loginbis=a.alias) set a.id=u.user_id; |
| 43 | insert into homonymes select a.id,u.user_id from aliases as a inner join auth_user_md5 as u ON(u.loginbis=a.alias); |
| 44 | -- drop des colones inutiles |
| 45 | ALTER TABLE x4dat.auth_user_md5 DROP COLUMN date_mise_alias_temp; |
| 46 | ALTER TABLE x4dat.auth_user_md5 DROP COLUMN loginbis; |
| 47 | ALTER TABLE x4dat.auth_user_md5 DROP COLUMN username; |
| 48 | ALTER TABLE x4dat.auth_user_md5 DROP COLUMN alias; |
| 49 | ALTER TABLE x4dat.auth_user_md5 DROP COLUMN username_sasl; |
| 50 | -------------------------------------------------------------------------------- |
| 51 | |
| 52 | |
| 53 | -------------------------------------------------------------------------------- |
| 54 | -- MELIX |
| 55 | -------------------------------------------------------------------------------- |
| 56 | update groupex.aliases AS gx |
| 57 | inner join x4dat.aliases AS a ON (gx.email = a.alias) |
| 58 | inner join x4dat.aliases AS b ON (a.id=b.id AND b.type='a_vie') |
| 59 | set gx.email = b.alias |
| 60 | where gx.id = 12; |
| 61 | |
| 62 | -------------------------------------------------------------------------------- |
| 63 | -- DROP des LISTES |
| 64 | -------------------------------------------------------------------------------- |
| 65 | drop table x4dat.listes_def; |
| 66 | drop table x4dat.listes_ins; |
| 67 | drop table x4dat.listes_mod; |
| 68 | update x4dat.aliases set id=0 where `type`='liste'; |
| 69 | -------------------------------------------------------------------------------- |
| 70 | |