#!/bin/sh

echo "SELECT alias, destination, IF(active=1, 1, 0) as active, created, modified FROM alias WHERE domain_id > 0 AND NOT domain_id IS NULL;" | mysql vmailadmin > vmailadmin.alias.txt