+
+ // - Campaign Statistics
+ addDropTableSql('forced_stats');
+ addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_forced_stats` (
+`forced_stats_id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
+`forced_stats_campaign_id` BIGINT( 20 ) UNSIGNED NULL DEFAULT NULL ,
+`forced_stats_user_id` BIGINT( 20 ) UNSIGNED NULL DEFAULT NULL ,
+`forced_stats_viewed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
+`forced_stats_clicked` TIMESTAMP NULL DEFAULT NULL ,
+`forced_stats_real_ip` VARCHAR ( 15 ) NOT NULL DEFAULT '0.0.0.0' ,
+`forced_stats_remote_addr` VARCHAR ( 15 ) NOT NULL DEFAULT '0.0.0.0' ,
+`forced_stats_ua` VARCHAR ( 255 ) NULL DEFAULT NULL ,
+`forced_stats_is_proxy` ENUM ( 'Y', 'N' ) NOT NULL DEFAULT 'N' ,
+`forced_stats_session_id` VARCHAR ( 100 ) NULL DEFAULT NULL ,
+INDEX ( `forced_stats_campaign_id` ) ,
+INDEX ( `forced_stats_user_id` ) ,
+PRIMARY KEY ( `forced_stats_id` )
+) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Forced Campaign Statistics'");