SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `soft_webinsta13e`
--

-- --------------------------------------------------------

--
-- Table structure for table `wiml_history`
--

CREATE TABLE `wiml_history` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `lastupd` char(20) DEFAULT NULL,
  `group_id` int(3) DEFAULT NULL,
  `email_address` char(50) DEFAULT NULL,
  `date` char(20) DEFAULT NULL,
  `subject` char(255) DEFAULT NULL,
  `text_message` longtext,
  `html_message` longtext,
  `template` char(20) DEFAULT NULL,
  `emailfrom` char(255) DEFAULT NULL,
  `charsetiso` char(20) DEFAULT NULL,
  `priority` char(1) DEFAULT NULL,
  `total_emails` int(11) NOT NULL,
  `total_sends` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `wiml_mailgroup`
--

CREATE TABLE `wiml_mailgroup` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `lastupd` char(20) DEFAULT NULL,
  `fid` int(3) DEFAULT NULL,
  `name` char(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `wiml_mailgroup`
--

INSERT INTO `wiml_mailgroup` VALUES
(1, NULL, 0, 'Default');

-- --------------------------------------------------------

--
-- Table structure for table `wiml_maillist`
--

CREATE TABLE `wiml_maillist` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `lastupd` char(20) DEFAULT NULL,
  `email_name` char(50) DEFAULT NULL,
  `email_address` char(50) DEFAULT NULL,
  `email_ip` char(16) DEFAULT NULL,
  `email_date` char(64) DEFAULT NULL,
  `group_id` int(4) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email_address` (`email_address`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `wiml_verify`
--

CREATE TABLE `wiml_verify` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `lastupd` char(20) DEFAULT NULL,
  `email_name` char(50) DEFAULT NULL,
  `email_address` char(50) DEFAULT NULL,
  `group_id` int(3) DEFAULT NULL,
  `rand_str` char(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;