osc 2.2 to oscmax database conversion

[sstrycker]

Hello, I'm using MySQLDiff to convert an existing osc database to oscmax and have this sql error when running the script generated by mysqldiff.

ALTER TABLE address_book ADD entry_company_tax_id varchar( 32 ) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci AFTER entry_company,
DROP PRIMARY KEY ,
ADD PRIMARY KEY ( address_book_id )

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1

any way around this? I'm not an SQL expert.

Thanks!

Sean

[jpf]

Remove the DROP and ADD lines. Not needed as the Primary key is already (or should be) address_book_id.