not null not taking

Why would some innodb's not take a 'no null' for a field? Has anyone
experienced anything like this? -Ike

Re: not null not taking

yet, when I export the table, I get:

CREATE TABLE `leads` (
`id` int(11) NOT NULL auto_increment,
`uniqueId` varchar(40) default NULL,
`upcardkey` int(11) NOT NULL default '0',
`associatekey` int(11) NOT NULL default '0',
`date` varchar(16) default NULL,
`time` varchar(11) default NULL,
`sensor` int(3) NOT NULL default '0',
`heads` int(3) NOT NULL default '1',
`upskey` int(11) NOT NULL default '0',
`closed` int(3) NOT NULL default '0',
`howdidyouhear` int(11) NOT NULL default '0',
`bb` int(3) NOT NULL default '0',
`tor` int(3) NOT NULL default '0',
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


So evidently NOT NULL is taking...yet, when I look at the table structure
under phpMyAdmin 2.6.1-pl3
the NULL column for each field shows as 'Yes.'

Something is amiss here. -Ike