From 2b03dc25e4a74a94f245c67582e145a38de1351e Mon Sep 17 00:00:00 2001
From: x2000habouzit <x2000habouzit>
Date: Thu, 14 Oct 2004 22:02:30 +0000
Subject: [PATCH] convert to new system

---
 scripts/migration/0.0.0_to_0.9.0/new_newsletter.sh | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100755 scripts/migration/0.0.0_to_0.9.0/new_newsletter.sh

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
new file mode 100755
index 0000000..ad2f24e
--- /dev/null
+++ b/scripts/migration/0.0.0_to_0.9.0/new_newsletter.sh
@@ -0,0 +1,6 @@
+#! /bin/sh
+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
-- 
2.1.4