email VARCHAR(255) NOT NULL,
domain SMALLINT(3) UNSIGNED NOT NULL DEFAULT 1,
uid INT(11) UNSIGNED NOT NULL,
- type ENUM('forlife', 'alias') NOT NULL DEFAULT 'forlife',
+ type ENUM('forlife', 'alias', 'alias_aux') NOT NULL DEFAULT 'forlife',
flags SET('bestalias', 'usage', 'marital') NOT NULL DEFAULT '',
expire DATE DEFAULT NULL,
PRIMARY KEY (email, domain),
email VARCHAR(255) NOT NULL,
domain SMALLINT(3) UNSIGNED NOT NULL DEFAULT 1,
redirect VARCHAR(255) NOT NULL,
- type ENUM('user', 'list', 'domain', 'event', 'admin', 'partner'),
+ type ENUM('alias', 'list', 'event', 'admin', 'partner'),
expire DATE NOT NULL DEFAULT '0000-00-00',
PRIMARY KEY (email, domain, redirect),
KEY (domain),