# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : newsletter

# --------------------------------------------------------
#
# Table structure for table 'members'
#

CREATE TABLE members (
   pid int(11) NOT NULL auto_increment,
   name varchar(255) NOT NULL,
   email varchar(255) NOT NULL,
   status varchar(20) NOT NULL,
   PRIMARY KEY (pid)
);


# --------------------------------------------------------
#
# Table structure for table 'newsletter'
#

CREATE TABLE newsletter (
   pid int(11) NOT NULL auto_increment,
   name varchar(255) NOT NULL,
   date varchar(30) NOT NULL,
   title varchar(255) NOT NULL,
   emailfrom varchar(255) NOT NULL,
   text blob NOT NULL,
   status varchar(20) NOT NULL,
   PRIMARY KEY (pid)
);