NOT NULL and zero default is ok, the problem is that you haven't specified that it's columns you are adding. The syntax should be like this ..
ALTER TABLE items ADD COLUMN `id` int(11) NOT NULL DEFAULT 0, ADD COLUMN `minstatus` int (11) NOT NULL DEFAULT 0 ... etc
|