Error restoring SQL database

Hi,

Restoring my (Wordpress) SQL database gives me the following error:

Fout

SQL-query :

CREATE TABLE wp_alinks_keyphrases (
id int( 11 ) NOT NULL AUTO_INCREMENT ,
keyphrase varchar( 250 ) NOT NULL default '',
description varchar( 250 ) NOT NULL default '',
defines text NOT NULL ,
module varchar( 60 ) NOT NULL default '',
created timestamp NOT NULL defaultCURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
hash varchar( 32 ) NOT NULL default '',
PRIMARY KEY ( id ) ,
KEY keyword_keyword ( keyphrase )
)ENGINE = MYISAM DEFAULT CHARSET = latin1

MySQL retourneerde:
#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
hash varchar

Any suggestions how I can get my backup restored??

thx

Ron

Re: Error restoring SQL database

On 9 Nov 2006 13:20:22 -0800, "DonRon" wrote:

>Restoring my (Wordpress) SQL database gives me the following error:
>
>Fout
>
>SQL-query :
>
>CREATE TABLE wp_alinks_keyphrases (
>id int( 11 ) NOT NULL AUTO_INCREMENT ,
>keyphrase varchar( 250 ) NOT NULL default '',
>description varchar( 250 ) NOT NULL default '',
>defines text NOT NULL ,
>module varchar( 60 ) NOT NULL default '',
>created timestamp NOT NULL defaultCURRENT_TIMESTAMP ON UPDATE

There should be a space between 'default' and 'CURRENT_TIMESTAMP'.

--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool