# phpMyAdmin MySQL-Dump
# version 2.2.4
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: 64.247.48.53
# Generation Time: Sep 11, 2003 at 09:44 AM
# Server version: 3.23.42
# PHP Version: 4.3.3
# Database : `mymail`
# --------------------------------------------------------

#
# Table structure for table `archive`
#

DROP TABLE IF EXISTS archive;
CREATE TABLE archive (
  ID int(11) NOT NULL auto_increment,
  listID int(11) NOT NULL default '0',
  issueID int(11) default NULL,
  date date NOT NULL default '0000-00-00',
  text text NOT NULL,
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

#
# Dumping data for table `archive`
#

# --------------------------------------------------------

#
# Table structure for table `emails`
#

DROP TABLE IF EXISTS emails;
CREATE TABLE emails (
  ID int(11) NOT NULL auto_increment,
  email varchar(150) NOT NULL default '',
  validated int(11) NOT NULL default '0',
  listID int(11) NOT NULL default '0',
  date date NOT NULL default '0000-00-00',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

#
# Dumping data for table `emails`
#

# --------------------------------------------------------

#
# Table structure for table `lists`
#

DROP TABLE IF EXISTS lists;
CREATE TABLE lists (
  ID int(11) NOT NULL auto_increment,
  listName varchar(100) NOT NULL default '',
  listEmail varchar(150) NOT NULL default '',
  listDescription varchar(255) default NULL,
  listHeader text,
  listFooter text,
  archiveHeader varchar(200) default NULL,
  archiveFooter varchar(200) default NULL,
  archive int(11) NOT NULL default '0',
  useValid int(11) NOT NULL default '0',
  welcomeMsg text NOT NULL,
  welcomeMsgTitle varchar(100) default NULL,
  validMsg text NOT NULL,
  validMsgTitle varchar(100) default NULL,
  fontColor varchar(25) default NULL,
  fontType varchar(25) default NULL,
  fontSize smallint(6) default NULL,
  generalHeader varchar(200) default NULL,
  generalFooter varchar(200) default NULL,
  PRIMARY KEY  (ID),
  KEY ID (ID)
) TYPE=MyISAM;

#
# Dumping data for table `lists`
#

INSERT INTO lists (ID, listName, listEmail, listDescription, listHeader, listFooter, archiveHeader, archiveFooter, archive, useValid, welcomeMsg, welcomeMsgTitle, validMsg, validMsgTitle, fontColor, fontType, fontSize, generalHeader, generalFooter) VALUES (1, 'H4H Demo List', 'support@help4hosters.com', 'This is a demo list of MyMail for demonstrating the main abilities of this software.', 'Hello dear subscriber,\r\n\r\n', '\r\n\r\nBest regards,\r\nHelp4Hosters Team\r\nhttp://help4hosters.com', '', '', 0, 0, 'Welcome to H4H demo newsletter.', 'H4H Demo List subscription congratulations', '\r\nTo confirm your subscription, please click here:\r\n<--confirm-->\r\n\r\nIf you want to unsubscibe from our demo newsletter, please click here.\r\n<--unsub-->', 'H4H Demo Mail List Confirmation', '', '', 1, '', '');