CAu0YvBu

1CREATE TABLE IF NOT EXISTS `wp_affiliate_commission` (
2  `id` int(10) unsigned NOT NULL auto_increment,
3  `post_id` int(10) unsigned NOT NULL default '0',
4  `user_id` int(10) unsigned NOT NULL default '0',
5  `owner_id` int(10) unsigned NOT NULL default '0',
6  `package_id` smallint(5) unsigned NOT NULL default '0',
7  `start_date` int(11) NOT NULL default '0',
8  `end_date` int(11) NOT NULL default '0',
9  `admin_revenue` float NOT NULL default '0',
10  `user_revenue` float NOT NULL default '0',
11  `status` enum('active','inactive','expired') NOT NULL default 'inactive',
12  `owner_name` varchar(100) NOT NULL,
13  `owner_bank_account` varchar(50) NOT NULL,
14  `owner_bank` varchar(50) NOT NULL,
15  `owner_contact` varchar(50) NOT NULL,
16  `owner_email` varchar(100) NOT NULL,
17  `pay_date` int(11) NOT NULL default '0',
18  PRIMARY KEY  (`id`),
19  KEY `user_id` (`user_id`),
20  KEY `start_date` (`start_date`),
21  KEY `post_id` (`post_id`)
22) ENGINE=InnoDB DEFAULT CHARSET=latin1;