Try datetime NOT NULL

On Tue, Mar 24, 2009 at 6:24 AM, Turgs <[email protected]> wrote:
>
> Hi
>
> My exact schema is:
>
> CREATE TABLE `users` (
>  `id` int(11) unsigned NOT NULL auto_increment,
>  `email` varchar(255) NOT NULL,
>  `password` varchar(50) NOT NULL,
>  `affiliate_id` int(11) default NULL,
>  `group_id` int(11) default NULL,
>  `login_count` int(11) unsigned NOT NULL default '0',
>  `deleted_flag` tinyint(1) default NULL,
>  `deleted` datetime default NULL,
>  `created` datetime default NULL,
>  `modified` datetime default NULL,
>  PRIMARY KEY  (`id`)
> ) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1
>
> I've checked out the following which haven't solved this either:
> http://www.sanisoft.com/blog/2007/06/15/cakephp-models-created-modified-gotcha/
> This information's also in http://book.cakephp.org I noticed. I think
> I've got that all ok though.
>
> The schema for these fields is the same on my other tables where they
> are updated correctly.
>
> Cheers
> Turgs
>
>
>
> Daniel Chcouri wrote:
>> What's your exact schema structure?
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to