Chapter 15: E-campaign System 515 ID int(11) NOT (Web hosting script)
Chapter 15: E-campaign System 515 ID int(11) NOT NULL auto_increment, USER_ID int(11) NOT NULL default 0 , CAMP_ID int(11) NOT NULL default 0 , URL_ID int(11) NOT NULL default 0 , TRACK_TS bigint(20) NOT NULL default 0 , PRIMARY KEY (ID) ) TYPE=MyISAM; # ——————————————————- # # Table structure for table `UNSUB` # CREATE TABLE UNSUB ( ID int(11) NOT NULL auto_increment, REC_ID int(11) NOT NULL default 0 , LIST_ID int(11) NOT NULL default 0 , CAMPAIGN_ID int(11) NOT NULL default 0 , UNSUB_TS bigint(20) NOT NULL default 0 , PRIMARY KEY (ID,REC_ID,LIST_ID), UNIQUE KEY REC_ID (REC_ID,LIST_ID) ) TYPE=MyISAM; # ——————————————————- # # Table structure for table `URL` # CREATE TABLE URL ( URL_ID int(11) NOT NULL auto_increment, NAME varchar(127) NOT NULL default , URL varchar(255) NOT NULL default , PRIMARY KEY (URL_ID), UNIQUE KEY NAME (NAME) ) TYPE=MyISAM; Understanding Customer Database Requirements Each customer database that you want to use in e-campaigns must have the following data fields: