# MySQL dump 4.0
#
# Host: localhost    Database: email
#--------------------------------------------------------

#
# Table structure for table 'ehosts'
#
CREATE TABLE ehosts (
  ehostNum int(11) DEFAULT '0' NOT NULL auto_increment,
  ehostName char(40) DEFAULT '' NOT NULL,
  PRIMARY KEY (ehostNum),
  KEY ehostkey (ehostName)
);

#
# Table structure for table 'email'
#
CREATE TABLE email (
  emailNum int(11) DEFAULT '0' NOT NULL auto_increment,
  euserNum int(11) DEFAULT '0' NOT NULL,
  ehostNum int(11) DEFAULT '0' NOT NULL,
  emailTitle char(40) DEFAULT '' NOT NULL,
  emailStatus char(1) DEFAULT '0' NOT NULL,
  emailSent datetime,
  PRIMARY KEY (emailNum),
  KEY euserKey (euserNum),
  KEY ehostKey (ehostNum)
);

#
# Table structure for table 'email_dk'
#
CREATE TABLE email_dk (
  emailNum int(11) DEFAULT '0' NOT NULL auto_increment,
  euserNum int(11) DEFAULT '0' NOT NULL,
  ehostNum int(11) DEFAULT '0' NOT NULL,
  emailTitle char(40) DEFAULT '' NOT NULL,
  emailStatus char(1) DEFAULT '0' NOT NULL,
  emailSent datetime,
  PRIMARY KEY (emailNum),
  KEY euserKey (euserNum),
  KEY ehostKey (ehostNum)
);

#
# Table structure for table 'email_fi'
#
CREATE TABLE email_fi (
  emailNum int(11) DEFAULT '0' NOT NULL auto_increment,
  euserNum int(11) DEFAULT '0' NOT NULL,
  ehostNum int(11) DEFAULT '0' NOT NULL,
  emailTitle char(40) DEFAULT '' NOT NULL,
  emailStatus char(1) DEFAULT '0' NOT NULL,
  emailSent datetime,
  PRIMARY KEY (emailNum),
  KEY euserKey (euserNum),
  KEY ehostKey (ehostNum)
);

#
# Table structure for table 'email_is'
#
CREATE TABLE email_is (
  emailNum int(11) DEFAULT '0' NOT NULL auto_increment,
  euserNum int(11) DEFAULT '0' NOT NULL,
  ehostNum int(11) DEFAULT '0' NOT NULL,
  emailTitle char(40) DEFAULT '' NOT NULL,
  emailStatus char(1) DEFAULT '0' NOT NULL,
  emailSent datetime,
  PRIMARY KEY (emailNum),
  KEY euserKey (euserNum),
  KEY ehostKey (ehostNum)
);

#
# Table structure for table 'email_no'
#
CREATE TABLE email_no (
  emailNum int(11) DEFAULT '0' NOT NULL auto_increment,
  euserNum int(11) DEFAULT '0' NOT NULL,
  ehostNum int(11) DEFAULT '0' NOT NULL,
  emailTitle char(40) DEFAULT '' NOT NULL,
  emailStatus char(1) DEFAULT '0' NOT NULL,
  emailSent datetime,
  PRIMARY KEY (emailNum),
  KEY euserKey (euserNum),
  KEY ehostKey (ehostNum)
);

#
# Table structure for table 'email_nu'
#
CREATE TABLE email_nu (
  emailNum int(11) DEFAULT '0' NOT NULL auto_increment,
  euserNum int(11) DEFAULT '0' NOT NULL,
  ehostNum int(11) DEFAULT '0' NOT NULL,
  emailTitle char(40) DEFAULT '' NOT NULL,
  emailStatus char(1) DEFAULT '0' NOT NULL,
  emailSent datetime,
  PRIMARY KEY (emailNum),
  KEY euserKey (euserNum),
  KEY ehostKey (ehostNum)
);

#
# Table structure for table 'email_se'
#
CREATE TABLE email_se (
  emailNum int(11) DEFAULT '0' NOT NULL auto_increment,
  euserNum int(11) DEFAULT '0' NOT NULL,
  ehostNum int(11) DEFAULT '0' NOT NULL,
  emailTitle char(40) DEFAULT '' NOT NULL,
  emailStatus char(1) DEFAULT '0' NOT NULL,
  emailSent datetime,
  PRIMARY KEY (emailNum),
  KEY euserKey (euserNum),
  KEY ehostKey (ehostNum)
);

#
# Table structure for table 'eusers'
#
CREATE TABLE eusers (
  euserNum int(11) DEFAULT '0' NOT NULL auto_increment,
  euserName char(40) DEFAULT '' NOT NULL,
  PRIMARY KEY (euserNum),
  KEY euserkey (euserName)
);

