upgrade/0.0.0_to_0.9.0/new_newsletter.sh

   1 #! /bin/sh
   2 mysql x4dat < newsleter.sql
   3
   4 list_members polytechnique.org-newsletter | \
   5     sed -e 's!^\(.*\)@polytechnique.org!INSERT INTO newsletter_ins SELECT id FROM aliases WHERE alias="\1";!' | \
   6     mysql x4dat
   7
   8 echo "DELETE FROM aliases WHERE alias LIKE 'newsletter%';" | mysql x4dat