On 12/28/2012 01:44 AM, Joseph wrote: > I'm not a PHP programmer but I'll try to explain my problem. > I've create table in my php database: > > DROP TABLE IF EXISTS visual_verify_code; > CREATE TABLE visual_verify_code ( > oscsid varchar(32) NOT NULL, > code varchar(6) NOT NULL, > dt TIMESTAMP(12) NOT NULL DEFAULT NOW(), > PRIMARY KEY (oscsid) > ); >
Looks fine. > It worked OK, after few days I backup my database and try to restore it, but > it keeps complaining on the "dt": > ERROR 1067 (42000) at line 38009: Invalid default value for 'dt' > > so the database is dropped but never restored. The backup data base contain: > > create table visual_verify_code ( > oscsid varchar(32) not null , > code varchar(6) not null , > dt timestamp default 'CURRENT_TIMESTAMP' not null , > PRIMARY KEY (oscsid) > ); CURRENT_TIMESTAMP shouldn't be quoted. How are you backing up the database?