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";
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`
);
14 --------------------------------------------------------------------------------
17 --------------------------------------------------------------------------------
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;
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;
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='';
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 --------------------------------------------------------------------------------
53 --------------------------------------------------------------------------------
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
62 --------------------------------------------------------------------------------
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 --------------------------------------------------------------------------------