From 722ddd5804a20b8d9f457a490b2d714d8d1ce7a1 Mon Sep 17 00:00:00 2001 From: x2000habouzit Date: Wed, 11 Aug 2004 09:45:28 +0000 Subject: [PATCH] new simplifications id db --- scripts/migration.sql | 12 ++++++++---- 1 file changed, 8 insertions(+), 4 deletions(-) diff --git a/scripts/migration.sql b/scripts/migration.sql index d358a30..cbb6b26 100644 --- a/scripts/migration.sql +++ b/scripts/migration.sql @@ -15,12 +15,16 @@ ALTER TABLE `events` ADD INDEX ( `session` ); -- optim trackers drop trackers; --- +-------------------------------------------------------------------------------- -- X4DAT --- - --- lastlogin --> logger +-------------------------------------------------------------------------------- +-- pas sur que je veuille le dropper pr le moment celui la ... a voir ALTER TABLE x4dat.auth_user_md5 DROP COLUMN lastnewslogin; +-- lastlogin --> logger ALTER TABLE x4dat.auth_user_md5 DROP COLUMN lastlogin; ALTER TABLE x4dat.auth_user_md5 DROP COLUMN host; +-- drop du soundex +ALTER TABLE x4dat.auth_user_md5 DROP COLUMN nom_soundex; +ALTER TABLE x4dat.auth_user_md5 DROP COLUMN prenom_soundex; +ALTER TABLE x4dat.auth_user_md5 DROP COLUMN epouse_soundex; INSERT INTO logger.actions SET text="connexion_auth_ext",description="connection via l'auth des groupes X"; -- 2.1.4