[mythtv] schema update problem with SVN 11777

[Chris Pinkham]

* On Sat Nov 18, 2006 at 07:13:19PM -0800, Ross Campbell wrote:
> After upgrading from SVN of about two weeks ago to today's SVN 11777,
> I get the following error when starting mythfrontend when trying to
> upgrade from schema 1167 to 1168. Can anyone help?

> Query was: CREATE TABLE IF NOT EXISTS dvdbookmark (   serialid
> varchar(16) NOT NULL default '',   name varchar(32) default NULL,
> title smallint(6) NOT NULL default 0,   audionum tinyint(4) NOT NULL
> default -1,   subtitlenum tinyint(4) NOT NULL default -1,   framenum
> bigint(20) NOT NULL default 0,   timestamp timestamp NOT NULL default
>   CURRENT_TIMESTAMP,   PRIMARY KEY (serialid));

> You have an error in your SQL syntax near 'CURRENT_TIMESTAMP,

CURRENT_TIMESTAMP is not MySQL 3.x compatible.  I removed the "default
CURRENT_TIMESTAMP" in SVN.  Can you re-update and try again?

--
Chris