From 3f05d9a394ed61fafa7ee4fd10a5477f611b5bb7 Mon Sep 17 00:00:00 2001
From: x2000habouzit <x2000habouzit>
Date: Thu, 14 Oct 2004 22:08:48 +0000
Subject: [PATCH] rm list from aliases

---
 scripts/migration/0.0.0_to_0.9.0/new_newsletter.sh | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/scripts/migration/0.0.0_to_0.9.0/new_newsletter.sh b/scripts/migration/0.0.0_to_0.9.0/new_newsletter.sh
index ad2f24e..983d4ca 100755
--- a/scripts/migration/0.0.0_to_0.9.0/new_newsletter.sh
+++ b/scripts/migration/0.0.0_to_0.9.0/new_newsletter.sh
@@ -4,3 +4,5 @@ mysql x4dat < newsleter.sql
 list_members polytechnique.org-newsletter | \
     sed -e 's!^\(.*\)@polytechnique.org!INSERT INTO newsletter_ins SELECT id FROM aliases WHERE alias="\1";!' | \
     mysql x4dat
+
+echo "DELETE FROM aliases WHERE alias LIKE 'newsletter%';" | mysql x4dat 
-- 
2.1.4