Table Structure

["Krishna Chandra Prajapati" <prajapatikc@xxxxxxxxx>]

Hi all,

Below is the user_delivery table structure.

CREATE TABLE `user_delivery` (
  `user_id` decimal(22,0) NOT NULL default '0',
  `delivery_id` decimal(22,0) NOT NULL default '0',
  `send_to_regulator` char(1) default NULL,
  PRIMARY KEY  (`user_id`),
  KEY `user_delivery_comp1` (`user_id`,`delivery_id`),
  CONSTRAINT `fk_user_delivery` FOREIGN KEY (`user_id`) REFERENCES
`user_info` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

According to me user_delivery_comp1 index can be dropped and new index can
be created on delivery_id column. I would to know that the changes will work
or not. Yours suggestion regarding this table structure.

Thanks,
-- 
Krishna Chandra Prajapati