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