· 7 years ago · Sep 03, 2018, 07:14 PM
1CREATE TABLE IF NOT EXISTS `mail_accounts` ( `id` int (9) NOT NULL auto_increment, `local_part` varchar (255) NOT NULL default '', `domain` int(16) NOT NULL, `forward` varchar(255) NOT NULL, `cc` varchar(255) default NULL, `name` varchar(255) NOT NULL default '', `pwclear` varchar(255) NOT NULL default '', `pwcrypt` varchar(255) NOT NULL default '', `is_away` enum ('yes', 'no') NOT NULL default 'no', `away_text` text, `spam_check` enum ('yes', 'no') NOT NULL default 'no', `spam_purge` enum ('yes', 'no') NOT NULL default 'no', `virus_check` enum ('yes', 'no') NOT NULL default 'no', `is_enabled` enum ('yes', 'no') NOT NULL default 'yes', `created_at` int (16) NOT NULL default '0', `updated_at` int (16) NOT NULL default '0', PRIMARY KEY (`id`),UNIQUE KEY `UNIQUE_EMAIL` (`domain`, `local_part`) ) ENGINE = InnoDB;
2ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes