This is a little tricky.
Older versions of the built in editor didn't issue "alter table" commands, just updated the .def file.
To do this right, you need to use MySQLMan. Edit the PROPERTIES of the fields you want to change in the tables. After you do that, resync the .def files.
MySQL allows you to alter the properties of columns, but it will adjust the data to fit. If you have a text column, and change it to an Int, you will lose all your data in that column!
Just changing the NULL/Not Null shouldn't affect anything, but it might, if you had null fields and the column is now defined NOT NULL. What you will find will depend on your version of MySQL.
Changing a field from NOT NULL to NULL shouldn't cause any problems at all.
PUGDOG® Enterprises, Inc.
FAQ:
http://LinkSQL.com/FAQ Forum:
http://LinkSQL.com/forum