1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

CREATE TABLE `mass_mail` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `from_email` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `to_admin` enum('false','true') NOT NULL DEFAULT 'false',
  `to_resellers` enum('false','true') NOT NULL DEFAULT 'false',
  `to_resellers_mode` enum('all','select','except') NOT NULL DEFAULT 'all',
  `to_clients` enum('false','true') NOT NULL DEFAULT 'false',
  `to_clients_mode` enum('all','select','except') NOT NULL DEFAULT 'all',
  `to_domains` enum('false','true') NOT NULL DEFAULT 'false',
  `to_domains_mode` enum('all','select','except') NOT NULL DEFAULT 'all',
  `subject` varchar(255) CHARACTER SET utf8 NOT NULL,
  `body` text CHARACTER SET utf8 NOT NULL,
  `cdate` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `mass_mail` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', `from_email` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '', `to_admin` enum('false','true') NOT NULL DEFAULT 'false', `to_resellers` enum('false','true') NOT NULL DEFAULT 'false', `to_resellers_mode` enum('all','select','except') NOT NULL DEFAULT 'all', `to_clients` enum('false','true') NOT NULL DEFAULT 'false', `to_clients_mode` enum('all','select','except') NOT NULL DEFAULT 'all', `to_domains` enum('false','true') NOT NULL DEFAULT 'false', `to_domains_mode` enum('all','select','except') NOT NULL DEFAULT 'all', `subject` varchar(255) CHARACTER SET utf8 NOT NULL, `body` text CHARACTER SET utf8 NOT NULL, `cdate` date DEFAULT NULL, PRIMARY KEY (`id`), KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1