· 8 years ago · May 23, 2018, 06:54 AM
1-- Table structure for table `responses`
2--
3
4DROP TABLE IF EXISTS `responses`;
5CREATE TABLE `responses` (
6 `id` int(11) NOT NULL auto_increment,
7 `ad_id` int(11) default NULL,
8 `website_id` int(11) default NULL,
9 `payout_id` int(11) default NULL,
10 `created_at` datetime default NULL,
11 `ip` varchar(255) default NULL,
12 `cpc` int(11) default '0',
13 `cpi` int(11) default '0',
14 `is_preview` tinyint(1) default '0',
15 `type` varchar(255) default NULL,
16 `discard_type_id` int(11) default NULL,
17 `num_mouseovers` int(11) default NULL,
18 `hover_seconds` float default NULL,
19 `num_views` int(11) default NULL,
20 `user_agent` varchar(255) default NULL,
21 PRIMARY KEY (`id`)
22) ENGINE=InnoDB DEFAULT CHARSET=latin1;