日期:2014-05-16 浏览次数:20784 次
alter table `ec_core_order_log` DROP PRIMARY KEY,ADD id int auto_increment ,ADD PRIMARY KEY (id,tx_logistic_id);
------解决方案--------------------
create table `ec_core_order_log` (
`tx_logistic_id` varchar(50) not null,
`create_time` timestamp not null default current_timestamp comment '创建时间',
`update_time` timestamp null comment '支付成功/支付失败时间',
`payAmount` varchar(10) comment '支付金额',
`payTime` varchar(100) comment '支付时间',
`unitId` varchar(50) comment 'PDA发起支付时传入的网点id',
`employeeId` varchar(50) comment 'PDA发起支付时传入的员工号',
`remark` varchar(512),
primary key (`tx_logistic_id`)
) engine=InnoDB default charset=utf8;
ALTER TABLE `ec_core_order_log` ADD id INT AUTO_INCREMENT,DROP PRIMARY kEY,
ADD PRIMARY KEY (id,tx_logistic_id)