upgrade/0.0.0_to_0.9.0/migration.sql

   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