Chapter 15: E-campaign System 513 # ——————————————————- # (Best web design)
Chapter 15: E-campaign System 513 # ——————————————————- # # Table structure for table `ECAMPAIGN_EXECUTION` # CREATE TABLE ECAMPAIGN_EXECUTION ( EXEC_ID int(11) NOT NULL auto_increment, CAMPAIGN_ID int(11) NOT NULL default 0 , CAMPAIGN_TS timestamp(14) NOT NULL, PRIMARY KEY (EXEC_ID), UNIQUE KEY CAMPAIGN_TS (CAMPAIGN_TS) ) TYPE=MyISAM; # ——————————————————- # # Table structure for table `LIST` # CREATE TABLE LIST ( LIST_ID int(11) NOT NULL auto_increment, NAME varchar(127) NOT NULL default , DB_HOST varchar(127) NOT NULL default , DB_USER varchar(127) NOT NULL default , DB_PASSWD varchar(127) NOT NULL default , DB_TYPE varchar(127) NOT NULL default , DB_NAME varchar(127) NOT NULL default , DB_TABLE varchar(127) NOT NULL default , LIMIT_CONDITION varchar(255) default NULL, CREATE_TS bigint(20) NOT NULL default 0 , CREATOR_ID int(11) NOT NULL default 0 , CHECK_FLAG bigint(20) NOT NULL default 0 , PRIMARY KEY (LIST_ID), UNIQUE KEY CHECK_FLAG (CHECK_FLAG), UNIQUE KEY NAME (NAME) ) TYPE=MyISAM; # ——————————————————- # # Table structure for table `LIST_FIELD_MAP` # CREATE TABLE LIST_FIELD_MAP ( Continued