mysql> show create table keys_publisher_merchant \G
*************************** 1. row ***************************
       Table: keys_publisher_merchant
Create Table: CREATE TABLE `keys_publisher_merchant` (
  `publisher_merchant_key_id` bigint(20) unsigned NOT NULL auto_increment,
  `publisher_id` varchar(100) default NULL,
  `merchant_id` varchar(100) character set utf8 collate utf8_unicode_ci default NULL,
  `retailer_id` varchar(100) character set utf8 collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`publisher_merchant_key_id`),
  UNIQUE KEY `publisher_id` (`publisher_id`,`merchant_id`,`retailer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql> show create table tmp_update_publisher_products \G
*************************** 1. row ***************************
       Table: tmp_update_publisher_products
Create Table: CREATE TABLE `tmp_update_publisher_products` (
  `date_info` date default NULL,
  `publisher_id` varchar(100) default NULL,
  `product_id` varchar(100) character set utf8 collate utf8_unicode_ci default NULL,
  `merchant_id` varchar(100) default NULL,
  `retailer_id` varchar(100) default NULL,
  `category_id` varchar(100) default NULL,
  `category_name` varchar(100) character set utf8 collate utf8_unicode_ci default NULL,
  `currency` char(3) default 'USD',
  `counter` bigint(20) default '0',
  `dbl1` decimal(10,5) default '0.00000',
  `dbl2` decimal(10,5) default '0.00000',
  `dbl3` decimal(10,5) default '0.00000',
  `dbl4` decimal(10,5) default '0.00000',
  `dbl5` decimal(10,5) default '0.00000',
  `dbl6` decimal(10,5) default '0.00000',
  `dbl7` decimal(10,5) default '0.00000',
  `dbl8` decimal(10,5) default '0.00000'
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)