ALTER TABLE cmd_report ADD create_day DATETIME NOT NULL;
ALTER TABLE cmd_report DROP PRIMARY KEY
ALTER TABLE cmd_report
ADD CONSTRAINT pk_name PRIMARY KEY(command_id,report_key,create_day)
UPDATE cmd_report SET create_day ='2015-03-15 00:00:00'
DROP TABLE IF EXISTS cmd_report_log
ALTER TABLE cmd_report DROP PRIMARY KEY
ALTER TABLE cmd_report
ADD CONSTRAINT pk_name PRIMARY KEY(command_id,report_key,create_day)
UPDATE cmd_report SET create_day ='2015-03-15 00:00:00'
DROP TABLE IF EXISTS cmd_report_log