CREATE TABLE admin_table ( 
	 comment_admin 	 varchar(150), 
	 date_admin 	 datetime NOT NULL, 
	 include_sources_admin 	 varchar(50), 
	 included_admin 	 int(1), 
	 info_admin 	 varchar(150), 
	 list_admin 	 varchar(50) NOT NULL, 
	 profile_admin 	 enum('privileged','normal'), 
	 reception_admin 	 varchar(20), 
	 robot_admin 	 varchar(80) NOT NULL, 
	 role_admin 	 enum('listmaster','owner','editor') NOT NULL, 
	 subscribed_admin 	 int(1), 
	 update_admin 	 datetime, 
	 user_admin 	 varchar(100) NOT NULL, 
	 visibility_admin 	 varchar(20), 
	 PRIMARY KEY (robot_admin, list_admin, role_admin, user_admin), 
 	 INDEX admin_user_index ( user_admin ) 
 ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8;


-- --------------------------------------------------------
--
-- Table structure for table `bulkmailer_table`
-- 

CREATE TABLE bulkmailer_table ( 
	 delivery_date_bulkmailer 	 int(11), 
	 listname_bulkmailer 	 varchar(50), 
	 lock_bulkmailer 	 varchar(30), 
	 merge_bulkmailer 	 int(1), 
	 messageid_bulkmailer 	 varchar(200), 
	 messagekey_bulkmailer 	 varchar(80) NOT NULL, 
	 packetid_bulkmailer 	 varchar(33) NOT NULL, 
	 priority_message_bulkmailer 	 smallint(10), 
	 priority_packet_bulkmailer 	 smallint(10), 
	 receipients_bulkmailer 	 text, 
	 reception_date_bulkmailer 	 int(11), 
	 returnpath_bulkmailer 	 varchar(100), 
	 robot_bulkmailer 	 varchar(80), 
	 verp_bulkmailer 	 int(1), 
	 PRIMARY KEY (messagekey_bulkmailer, packetid_bulkmailer) 
 ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8;


-- --------------------------------------------------------
--
-- Table structure for table `bulkspool_table`
-- 

CREATE TABLE bulkspool_table ( 
	 dkim_d_bulkspool 	 varchar(50), 
	 dkim_i_bulkspool 	 varchar(100), 
	 dkim_privatekey_bulkspool 	 varchar(1000), 
	 dkim_selector_bulkspool 	 varchar(50), 
	 lock_bulkspool 	 int(1), 
	 message_bulkspool 	 longtext, 
	 messageid_bulkspool 	 varchar(200), 
	 messagekey_bulkspool 	 varchar(33) NOT NULL, 
	 PRIMARY KEY (messagekey_bulkspool) 
 ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8;


-- --------------------------------------------------------
--
-- Table structure for table `conf_table`
-- 

CREATE TABLE conf_table ( 
	 label_conf 	 varchar(80), 
	 robot_conf 	 varchar(80), 
	 value_conf 	 varchar(300), 
	 PRIMARY KEY (robot_conf, label_conf) 
 ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8;


-- --------------------------------------------------------
--
-- Table structure for table `exclusion_table`
-- 

CREATE TABLE exclusion_table ( 
	 date_exclusion 	 int(11), 
	 family_exclusion 	 varchar(50), 
	 list_exclusion 	 varchar(50) NOT NULL, 
	 robot_exclusion 	 varchar(50) NOT NULL, 
	 user_exclusion 	 varchar(100) NOT NULL, 
	 PRIMARY KEY (list_exclusion, user_exclusion, robot_exclusion) 
 ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8;


-- --------------------------------------------------------
--
-- Table structure for table `list_table`
-- 

CREATE TABLE list_table ( 
	 creation_email_list 	 varchar(100), 
	 creation_epoch_list 	 datetime, 
	 editors_list 	 varchar(100), 
	 name_list 	 varchar(100) NOT NULL, 
	 owners_list 	 varchar(100), 
	 path_list 	 varchar(100), 
	 robot_list 	 varchar(100) NOT NULL, 
	 status_list 	 enum('open','closed','pending','error_config','family_closed'), 
	 subject_list 	 varchar(100), 
	 topics_list 	 varchar(100), 
	 web_archive_list 	 tinyint(1), 
	 PRIMARY KEY (name_list, robot_list) 
 ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8;


-- --------------------------------------------------------
--
-- Table structure for table `logs_table`
-- 

CREATE TABLE logs_table ( 
	 action_logs 	 varchar(50) NOT NULL, 
	 client_logs 	 varchar(100), 
	 daemon_logs 	 varchar(10) NOT NULL, 
	 date_logs 	 int(11) NOT NULL, 
	 error_type_logs 	 varchar(150), 
	 id_logs 	 bigint(20) NOT NULL, 
	 list_logs 	 varchar(50), 
	 msg_id_logs 	 varchar(255), 
	 parameters_logs 	 varchar(100), 
	 robot_logs 	 varchar(80), 
	 status_logs 	 varchar(10) NOT NULL, 
	 target_email_logs 	 varchar(100), 
	 user_email_logs 	 varchar(100), 
	 PRIMARY KEY (id_logs) 
 ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8;


-- --------------------------------------------------------
--
-- Table structure for table `netidmap_table`
-- 

CREATE TABLE netidmap_table ( 
	 email_netidmap 	 varchar(100), 
	 netid_netidmap 	 varchar(100) NOT NULL, 
	 robot_netidmap 	 varchar(80) NOT NULL, 
	 serviceid_netidmap 	 varchar(100) NOT NULL, 
	 PRIMARY KEY (netid_netidmap, serviceid_netidmap, robot_netidmap) 
 ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8;


-- --------------------------------------------------------
--
-- Table structure for table `one_time_ticket_table`
-- 

CREATE TABLE one_time_ticket_table ( 
	 data_one_time_ticket 	 varchar(200), 
	 date_one_time_ticket 	 int(11), 
	 email_one_time_ticket 	 varchar(100), 
	 remote_addr_one_time_ticket 	 varchar(60), 
	 robot_one_time_ticket 	 varchar(80), 
	 status_one_time_ticket 	 varchar(60), 
	 ticket_one_time_ticket 	 varchar(30), 
	 PRIMARY KEY (ticket_one_time_ticket) 
 ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8;


-- --------------------------------------------------------
--
-- Table structure for table `session_table`
-- 

CREATE TABLE session_table ( 
	 data_session 	 text, 
	 date_session 	 int(11) NOT NULL, 
	 email_session 	 varchar(100), 
	 hit_session 	 int(11), 
	 id_session 	 varchar(30) NOT NULL, 
	 remote_addr_session 	 varchar(60), 
	 robot_session 	 varchar(80), 
	 start_date_session 	 int(11) NOT NULL, 
	 PRIMARY KEY (id_session) 
 ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8;


-- --------------------------------------------------------
--
-- Table structure for table `subscriber_table`
-- 

CREATE TABLE subscriber_table ( 
	 bounce_address_subscriber 	 varchar(100), 
	 bounce_score_subscriber 	 smallint(6), 
	 bounce_subscriber 	 varchar(35), 
	 comment_subscriber 	 varchar(150), 
	 custom_attribute_subscriber 	 text, 
	 date_subscriber 	 datetime NOT NULL, 
	 include_sources_subscriber 	 varchar(50), 
	 included_subscriber 	 int(1), 
	 list_subscriber 	 varchar(50) NOT NULL, 
	 reception_subscriber 	 varchar(20), 
	 robot_subscriber 	 varchar(80) NOT NULL, 
	 subscribed_subscriber 	 int(1), 
	 suspend_end_date_subscriber 	 int(11), 
	 suspend_start_date_subscriber 	 int(11), 
	 suspend_subscriber 	 int(1), 
	 topics_subscriber 	 varchar(200), 
	 update_subscriber 	 datetime, 
	 user_subscriber 	 varchar(100) NOT NULL, 
	 visibility_subscriber 	 varchar(20), 
	 PRIMARY KEY (robot_subscriber, list_subscriber, user_subscriber), 
 	 INDEX subscriber_user_index ( user_subscriber ) 
 ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8;


-- --------------------------------------------------------
--
-- Table structure for table `user_table`
-- 

CREATE TABLE user_table ( 
	 attributes_user 	 text, 
	 cookie_delay_user 	 int(11), 
	 data_user 	 text, 
	 email_user 	 varchar(100) NOT NULL, 
	 gecos_user 	 varchar(150), 
	 lang_user 	 varchar(10), 
	 last_login_date_user 	 int(11), 
	 last_login_host_user 	 varchar(60), 
	 password_user 	 varchar(40), 
	 wrong_login_count_user 	 int(11), 
	 PRIMARY KEY (email_user) 
 ) ENGINE=MyISAM DEFAULT CHARACTER SET utf8;
