mySQL rules different between dev & live sites

[eluser]theshiftexchange[/eluser]
[quote author="WanWizard" date="1274809450"]Afaik 'not null' is an attribute of a table column, which you should have set when you created the table.
So you have to check the way you have recreated your tables...[/quote]

Sorry - thats my point - in both databases "not null" is set (i.e. the tables are identical - thats the first thing I checked).

One of the databaes enforces the rule, the other does not...