Hello Alex!
I have done many times a change in the property fields like NULL to NOT NULL or UNIQUE KEY to None or PRIMARY KEY to None etc with phpMyAdmin utility from www.phpwizard.net!
It is for sure not necessary to recreate the table. One can simply change the property of the field with the help of this utility and later edit defs values from '1' to '0'!!!
Quote:
You'll need to recreate the table without the NOT NULL statement to do what you want.I have done many times a change in the property fields like NULL to NOT NULL or UNIQUE KEY to None or PRIMARY KEY to None etc with phpMyAdmin utility from www.phpwizard.net!
It is for sure not necessary to recreate the table. One can simply change the property of the field with the help of this utility and later edit defs values from '1' to '0'!!!