Web hosting plans - 512 Part III: Developing E-mail Solutions Listing 15-1
512 Part III: Developing E-mail Solutions Listing 15-1 (Continued) # ——————————————————- # # Table structure for table `ASSEMBLY` # CREATE TABLE ASSEMBLY ( LIST_ID int(11) NOT NULL default 0 , REC_ID int(11) NOT NULL default 0 , FIRST varchar(255) default NULL, LAST varchar(255) default NULL, EMAIL varchar(255) NOT NULL default , AGE varchar(255) default NULL, INCOME varchar(255) default NULL, SEX varchar(255) default NULL ) TYPE=MyISAM; # ——————————————————- # # Table structure for table `BOUNCED` # CREATE TABLE BOUNCED ( CAMPAIGN_ID tinyint(4) NOT NULL default 0 , LIST_ID tinyint(4) NOT NULL default 0 , REC_ID tinyint(4) NOT NULL default 0 , PRIMARY KEY (LIST_ID,REC_ID,CAMPAIGN_ID) ) TYPE=MyISAM; # ——————————————————- # # Table structure for table `CAMPAIGN` # CREATE TABLE CAMPAIGN ( CAMPAIGN_ID int(11) NOT NULL auto_increment, NAME varchar(127) NOT NULL default , LIST_ID int(11) NOT NULL default 0 , MSG_ID int(11) NOT NULL default 0 , STATUS int(4) NOT NULL default 0 , PRIMARY KEY (CAMPAIGN_ID) ) TYPE=MyISAM;