1 |
On 12/28/2012 01:44 AM, Joseph wrote: |
2 |
> I'm not a PHP programmer but I'll try to explain my problem. |
3 |
> I've create table in my php database: |
4 |
> |
5 |
> DROP TABLE IF EXISTS visual_verify_code; |
6 |
> CREATE TABLE visual_verify_code ( |
7 |
> oscsid varchar(32) NOT NULL, |
8 |
> code varchar(6) NOT NULL, |
9 |
> dt TIMESTAMP(12) NOT NULL DEFAULT NOW(), |
10 |
> PRIMARY KEY (oscsid) |
11 |
> ); |
12 |
> |
13 |
|
14 |
Looks fine. |
15 |
|
16 |
|
17 |
> It worked OK, after few days I backup my database and try to restore it, but it keeps complaining on the "dt": |
18 |
> ERROR 1067 (42000) at line 38009: Invalid default value for 'dt' |
19 |
> |
20 |
> so the database is dropped but never restored. The backup data base contain: |
21 |
> |
22 |
> create table visual_verify_code ( |
23 |
> oscsid varchar(32) not null , |
24 |
> code varchar(6) not null , |
25 |
> dt timestamp default 'CURRENT_TIMESTAMP' not null , |
26 |
> PRIMARY KEY (oscsid) |
27 |
> ); |
28 |
|
29 |
|
30 |
CURRENT_TIMESTAMP shouldn't be quoted. How are you backing up the database? |