> On Tuesday 02 June 2009, Michael Scheidell wrote: > What "optional" fields are you refering to? > > I have seen this, on the spamassassin WIKI: > > CREATE TABLE awl ( > username varchar(100) NOT NULL default '', > email varchar(200) NOT NULL default '', > ip varchar(10) NOT NULL default '', > count int(11) default '0', > totscore float default '0', > PRIMARY KEY (username,email,ip) > ) TYPE=MyISAM; > > Is there a better reference?
CREATE TABLE `awl` ( `username` varchar(100) NOT NULL DEFAULT '', `email` varchar(200) NOT NULL DEFAULT '', `ip` varchar(10) NOT NULL DEFAULT '', `count` int(11) DEFAULT '0', `totscore` float DEFAULT '0', `lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`username`,`email`,`ip`) ) ENGINE=InnoDB ;