mysql 建表设置时间默认值

CREATE TABLE `T_INPUTCONTENT` (              
                  `id` int(10) NOT NULL auto_increment,      
                  `title` varchar(40) default NULL,          
                  `content` longtext,                        
                  `subdate` timestamp(10) default now(),          
                  `status` varchar(10) NOT NULL default '0', 
                  PRIMARY KEY  (`id`)                        
                ) ENGINE=MyISAM DEFAULT CHARSET=latin1