
Before entering any into the database make sure that the table
preposition is the same as in the config file so if it is NULL then
copy this exactly other wise if it is mymail_ for example use:

CREATE TABLE users (

would be...

CREATE TABLE mymail_users (

####################################################3

#
# Table structure for table 'mymail_archive'
#

CREATE TABLE `mymail_archive` (
  `ID` int(11) NOT NULL auto_increment,
  `issueID` int(11) NOT NULL default '0',
  `listID` varchar(20) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  `text` text NOT NULL,
  `html` text NOT NULL,
  `sent` varchar(10) NOT NULL default '',
  `time` varchar(20) NOT NULL default '',
  `archive` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table 'mymail_lists'
#

CREATE TABLE `mymail_lists` (
  `ID` int(11) NOT NULL auto_increment,
  `t_name` varchar(20) NOT NULL default '',
  `Name` varchar(50) NOT NULL default '',
  `Email` varchar(150) NOT NULL default '',
  `Description` varchar(255) NOT NULL default '',
  `WelcomeTitle` varchar(255) default NULL,
  `Welcome` text,
  `ConfirmTitle` varchar(255) default NULL,
  `Confirm` text,
  `GoodbyeTitle` varchar(255) default NULL,
  `Goodbye` text,
  `Send_Welcome` tinyint(4) NOT NULL default '0',
  `Send_Goodbye` tinyint(4) NOT NULL default '0',
  `Send_Confirm` tinyint(4) NOT NULL default '0',
  `Send_UnConfirm` tinyint(4) NOT NULL default '0',
  `UnConfirmTitle` varchar(255) NOT NULL default '',
  `UnConfirm` text NOT NULL,
  `archive` tinyint(4) NOT NULL default '0',
  `archiveHeader` varchar(150) NOT NULL default '',
  `archiveFooter` varchar(150) NOT NULL default '',
  `use_name` tinyint(4) NOT NULL default '0',
  `fontColor` varchar(20) NOT NULL default '',
  `fontFace` varchar(40) NOT NULL default '',
  `fontSize` int(11) NOT NULL default '0',
  `use_html` tinyint(4) NOT NULL default '0',
  `use_templates` tinyint(4) NOT NULL default '0',
  `generalHeader` varchar(255) default NULL,
  `generalFooter` varchar(255) default NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table 'mymail_templates'
#

CREATE TABLE `mymail_templates` (
  `ID` int(11) NOT NULL auto_increment,
  `NameID` varchar(20) NOT NULL default '',
  `Name` varchar(200) NOT NULL default '',
  `Value` text NOT NULL,
  `Type` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table 'mymail_users'
#

CREATE TABLE `mymail_users` (
  `ID` int(11) NOT NULL auto_increment,
  `Name` varchar(50) NOT NULL default '',
  `Email` varchar(150) NOT NULL default '',
  `Username` varchar(20) NOT NULL default '',
  `Password` varchar(20) NOT NULL default '',
  `a_list` tinyint(4) NOT NULL default '0',
  `e_list` tinyint(4) NOT NULL default '0',
  `d_list` tinyint(4) NOT NULL default '0',
  `c_list` tinyint(4) NOT NULL default '0',
  `t_list` tinyint(4) NOT NULL default '0',
  `a_email` tinyint(4) NOT NULL default '0',
  `d_email` tinyint(4) NOT NULL default '0',
  `e_email` tinyint(4) NOT NULL default '0',
  `v_email` tinyint(4) NOT NULL default '0',
  `a_archive` tinyint(4) NOT NULL default '0',
  `e_archive` tinyint(4) NOT NULL default '0',
  `d_archive` tinyint(4) NOT NULL default '0',
  `send_mail` tinyint(4) NOT NULL default '0',
  `get_html` tinyint(4) NOT NULL default '0',
  `users` tinyint(4) NOT NULL default '0',
  `statistics` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;


