#!/bin/sh

cat vmailadmin.mailbox.txt | perl -n -e '
chomp($_);
if (!@field_name) {
	@field_name=split(/\t/, $_);
} else {
	%data = {};
	$i = 0;
	for (split(/\t/, $_)) {
		$data{$field_name[$i]} = $_;
		$i++;
	}
	($data{"local_part"}, $data{"domain"}) = split("\@", $data{"pobox"});
	printf(
		"REPLACE INTO \`mailbox\` (\`username\`, \`password\`, \`name\`, \`maildir\`, \`quota\`, \`local_part\`, \`domain\`, \`created\`, \`modified\`, \`active\`, \`phone\`, \`email_other\`, \`token\`, \`token_validity\`)".
		" VALUES(\"%s\", \"%s\", \"%s\", \"%s/%s/\", 0, \"%s\", \"%s\", FROM_UNIXTIME(%d), FROM_UNIXTIME(%d), %d, \"\", \"\", \"\", \"2000-01-01 00:00:00\");\n",
		$data{"pobox"}, $data{"password"}, $data{"name"}, $data{"domain"}, $data{"local_part"}, $data{"local_part"}, $data{"domain"}, $data{"created"}, $data{"modified"}, $data{"active"}
	);
}
' > postfixadmin.mailbox.sql