CREATE TABLE `passwd` ( `id` varchar(64) NOT NULL default '', `created` datetime NOT NULL default '0000-00-00 00:00:00', `updated` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP, `password` varchar(255) NOT NULL default '', `name` varchar(64) NOT NULL default '', `maildir` varchar(255) NOT NULL default '', `expired` enum('N','Y') NOT NULL default 'N', `antivirus` enum('N','Y') NOT NULL default 'Y', `antispam` enum('N','Y') NOT NULL default 'Y', `comment` text, PRIMARY KEY (`id`) );