mysql> show create table order_scores_history_old \G *************************** 1. row *************************** Table: order_scores_history_old Create Table: CREATE TABLE `order_scores_history_old` ( `suborder_id` int(20) DEFAULT NULL, `suborder_code` varchar(20) DEFAULT NULL, `order_date` datetime DEFAULT NULL, `supc` varchar(15) DEFAULT NULL, `subcategory_id` int(11) DEFAULT NULL, `seller_code` varchar(20) DEFAULT NULL, `seller_id` int(11) NOT NULL, `shipping_model` varchar(11) DEFAULT NULL, `shipping_model_detail` varchar(30) DEFAULT NULL, `order_cld_date` datetime DEFAULT NULL, `time_flag` int(2) DEFAULT NULL, `OOS_penalty` double(3,2) DEFAULT NULL, `Wrong_Product_Delivered` double(3,2) NOT NULL DEFAULT '0.00', `unhappy_with_the_quality` double(3,2) NOT NULL DEFAULT '0.00', `Physical_Damage_in_Product` double(3,2) NOT NULL DEFAULT '0.00', `Invoice_not_received` double(3,2) NOT NULL DEFAULT '0.00', `Faulty_Product_Delivered` double(3,2) NOT NULL DEFAULT '0.00', `Products_Freebie_not_received` double(3,2) NOT NULL DEFAULT '0.00', `Products_Warranty_Card_Certificate_not_received` double(3,2) NOT NULL DEFAULT '0.00', `Products_Used_Product_Received` double(3,2) NOT NULL DEFAULT '0.00', `rating` varchar(5) DEFAULT NULL, `IC_Poor_product_quality` double(3,2) NOT NULL DEFAULT '0.00', `IC_Poor_packaging` double(3,2) NOT NULL DEFAULT '0.00', `IC_Damaged_product_delivered` double(3,2) NOT NULL DEFAULT '0.00',
```Customer_Wants_Size_Change``` double(6,4) NOT NULL DEFAULT '0.0000',
`IC_Wrong_product_delivered` double(3,2) NOT NULL DEFAULT '0.00', `date_delivered` datetime DEFAULT NULL, `ops_penalty` double(3,2) DEFAULT '0.00', `order_cld_after_exp_date` double(3,2) DEFAULT '0.00', `order_moved_after_exp_date` double(3,2) DEFAULT '0.00', `order_shipped_after_exp_date` double(3,2) DEFAULT '0.00', `fss_penalty` double(3,2) DEFAULT '0.00', `selling_price` int(12) DEFAULT NULL, `sdf_cashback` int(12) DEFAULT NULL, `promo_value` int(12) DEFAULT NULL, `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', KEY `indx_updated` (`updated`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 1 row in set (0.00 sec)
mysql> quit Bye nilnandan@desktop:~$ pt-duplicate-key-checker Can't determine column type for ```customer_wants_size_change``` double(6,4) not null default '0.0000' at /usr/bin/pt-duplicate-key-checker line 360. nilnandan@desktop:~$
Current workaround can be ignore that table.
nilnandan@desktop:~$ pt-duplicate-key-checker --ignore-tables=order_scores_history_old # ######################################################################## # Summary of indexes # ########################################################################
# Total Indexes 55 nilnandan@desktop:~$
mysql> show create table order_scores_ history_ old \G ******* ******* ****** 1. row ******* ******* ******* ****** history_ old scores_ history_ old` ( model_detail` varchar(30) DEFAULT NULL, Product_ Delivered` double(3,2) NOT NULL DEFAULT '0.00', with_the_ quality` double(3,2) NOT NULL DEFAULT '0.00', Damage_ in_Product` double(3,2) NOT NULL DEFAULT '0.00', not_received` double(3,2) NOT NULL DEFAULT '0.00', Product_ Delivered` double(3,2) NOT NULL DEFAULT '0.00', Freebie_ not_received` double(3,2) NOT NULL DEFAULT '0.00', Warranty_ Card_Certificat e_not_received` double(3,2) NOT NULL DEFAULT '0.00', Used_Product_ Received` double(3,2) NOT NULL DEFAULT '0.00', product_ quality` double(3,2) NOT NULL DEFAULT '0.00', packaging` double(3,2) NOT NULL DEFAULT '0.00', product_ delivered` double(3,2) NOT NULL DEFAULT '0.00',
*******
Table: order_scores_
Create Table: CREATE TABLE `order_
`suborder_id` int(20) DEFAULT NULL,
`suborder_code` varchar(20) DEFAULT NULL,
`order_date` datetime DEFAULT NULL,
`supc` varchar(15) DEFAULT NULL,
`subcategory_id` int(11) DEFAULT NULL,
`seller_code` varchar(20) DEFAULT NULL,
`seller_id` int(11) NOT NULL,
`shipping_model` varchar(11) DEFAULT NULL,
`shipping_
`order_cld_date` datetime DEFAULT NULL,
`time_flag` int(2) DEFAULT NULL,
`OOS_penalty` double(3,2) DEFAULT NULL,
`Wrong_
`unhappy_
`Physical_
`Invoice_
`Faulty_
`Products_
`Products_
`Products_
`rating` varchar(5) DEFAULT NULL,
`IC_Poor_
`IC_Poor_
`IC_Damaged_
```Customer_ Wants_Size_ Change` `` double(6,4) NOT NULL DEFAULT '0.0000',
`IC_Wrong_ product_ delivered` double(3,2) NOT NULL DEFAULT '0.00', cld_after_ exp_date` double(3,2) DEFAULT '0.00', moved_after_ exp_date` double(3,2) DEFAULT '0.00', shipped_ after_exp_ date` double(3,2) DEFAULT '0.00',
`date_delivered` datetime DEFAULT NULL,
`ops_penalty` double(3,2) DEFAULT '0.00',
`order_
`order_
`order_
`fss_penalty` double(3,2) DEFAULT '0.00',
`selling_price` int(12) DEFAULT NULL,
`sdf_cashback` int(12) DEFAULT NULL,
`promo_value` int(12) DEFAULT NULL,
`updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
KEY `indx_updated` (`updated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
mysql> quit desktop: ~$ pt-duplicate- key-checker wants_size_ change` `` double(6,4) not null default '0.0000' at /usr/bin/ pt-duplicate- key-checker line 360. desktop: ~$
Bye
nilnandan@
Can't determine column type for ```customer_
nilnandan@
Current workaround can be ignore that table.
nilnandan@ desktop: ~$ pt-duplicate- key-checker --ignore- tables= order_scores_ history_ old ####### ####### ####### ####### ####### ####### ####### ####### ####### ## ####### ####### ####### ####### ####### ####### ####### ####### ####### ##
# #######
# Summary of indexes
# #######
# Total Indexes 55 desktop: ~$
nilnandan@