#
# Table structure for table `newslettermembers`
#

CREATE TABLE newslettermembers (
  tipnm_id int(4) NOT NULL auto_increment,
  tipnm_name varchar(200) NOT NULL default '',
  tipnm_email varchar(200) NOT NULL default '',
  tipnm_newsid int(1) NOT NULL default '0',
  PRIMARY KEY (tipnm_id),
  UNIQUE KEY tipnm_id(tipnm_id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `newsletters`
#

CREATE TABLE newsletters (
  tipnl_id int(1) NOT NULL auto_increment,
  tipnl_title varchar(100) NOT NULL default '',
  tipnl_description varchar(200) NOT NULL default '',
  tipnl_status int(1) NOT NULL default '0',
  PRIMARY KEY (tipnl_id),
  UNIQUE KEY tipnl_id(tipnl_id)
) TYPE=MyISAM;