X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=inline;f=modules%2Ffusionax%2FAnciens.sql;h=7964f430af23406e896578036792c74fbd36eb80;hb=2504be33ed7e7436c428f188bdafa9e72248131d;hp=87fa8c8190a7da8949a9232b99ef2bf22e93891d;hpb=0b37833b3b42f608fa0d5864f9d4b2518d9676ae;p=platal.git

diff --git a/modules/fusionax/Anciens.sql b/modules/fusionax/Anciens.sql
index 87fa8c8..7964f43 100644
--- a/modules/fusionax/Anciens.sql
+++ b/modules/fusionax/Anciens.sql
@@ -56,11 +56,3 @@ CREATE TABLE IF NOT EXISTS `fusionax_import` (
 
 INSERT INTO `fusionax_import` ( SELECT `id_ancien`, NULL, NULL FROM `fusionax_anciens` );
 REPLACE INTO `fusionax_import` ( SELECT `matricule_ax`, `user_id`, NOW() FROM `auth_user_md5` );
-
-DROP VIEW IF EXISTS `fusionax_deceased`;
-
-CREATE VIEW  fusionax_deceased AS
-     SELECT  u.user_id, a.id_ancien, u.nom, u.prenom, u.promo, u.deces AS deces_xorg, a.Date_deces AS deces_ax
-       FROM  auth_user_md5 AS u
- INNER JOIN  fusionax_anciens AS a ON (a.id_ancien = u.matricule_ax)
-      WHERE  u.deces != a.Date_deces;