CREATE TABLE `packages` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `pkgname` varchar(255) NOT NULL default '',
  `pkgver` varchar(255) NOT NULL default '',
  `pkgrel` tinyint(4) NOT NULL default '0',
  `groups` varchar(255) NOT NULL default '',
  `provides` varchar(255) default NULL,
  `depends` varchar(255) default NULL,
  `conflicts` varchar(255) default NULL,
  `replaces` varchar(255) default NULL,
  `csize` int(11) NOT NULL default '0',
  `arch` varchar(255) NOT NULL default '',
  `desc` varchar(255) NOT NULL default '',
  `maintainer` varchar(255) NOT NULL default '',
  `md5` varchar(32) NOT NULL default '',
  `fwver` varchar(255) NOT NULL default '',
  `repo` varchar(255) NOT NULL default '',
  `files` mediumtext NOT NULL,
  `updated` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
)
INSERT INTO `packages` ( `id` , `pkgname` , `pkgver` , `pkgrel` , `groups` , `provides` , `depends` , `conflicts` , `replaces` , `csize` , `arch` , `desc` , `maintainer` , `md5` , `fwver` , `repo` , `files` , `updated` )
VALUES (
'1', 'foo', '', '0', '', NULL , NULL , NULL , NULL , '0', '', '', '', '', '', '', '', NOW( )
);
-- now look at the value of the `updated` field
update packages set pkgname='bar' where id=1;
-- now the value of the `updated` field would have to be updated, but mysql doesn't update it. weird