> although may be not relevant to your question, as i have noticed this
> before with mysql 'sql', what is the point of having a NOT NULL field
> that defaults to 0? the whole idea of a NOT NULL field is to have the
> value filled in compulsorily and having a default of 0 or '' defeats
> the purpose
Well if you define your field as NOT NULL mysql will automatically set it
to 0 if you store a NULL anyway, so you might as well specify it in your
table definitions so it looks like you wanted it...