Re: help required on how to modify constraints/indexes of unique_together after data is loaded

Hi Found the solution ran the following sql directly and it worked fine ALTER TABLE `table_name` DROP INDEX `field1` , ADD UNIQUE INDEX `field1` (`field1` ASC, `field2` ASC, `field3` ASC) ; Also checked a distinct on the three fields to ensure data integrity Thanks Subramanyam On

help required on how to modify constraints/indexes of unique_together after data is loaded

Hi Initially when we created the table we had two fields as unique_together = ( 'field1',field2') and quite some data has been added with the same Later we added one more field to unique_together = ( 'field1',field2','field3') how can I flush the old constraints/indexes created and add the