> The order of dependency removal is:
> 1 - remove the foreign key constraint(s) first and commit
> 2 - Then remove the primary key constraint and commit
> 3. Next do ALTER COLUMN on all of the affected columns and commit
>
> After that, do
> 4. Re-add the primary key constraint and commit
> 5 Re-add the foreign key constraint and commit

Alternatively - create the new database and pump the data
from the old one - watching pump order. Personally I do the
foreign key stuff in the application, but with a switch to
PHP, I need to start looking at it :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services