Re: TIMESTAMP with DEFAULT broken?

At 14:31 -0800 2/26/02, John D. Kirkpatrick wrote: >I have tried to create a MySQL table with the following lines: > >$query[] = "CREATE TABLE member ( >IDbigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY, >userName varchar(40) NOT NULL, >. >. >. > >RecordCreationTime TIMESTAMP

TIMESTAMP with DEFAULT broken?

I have tried to create a MySQL table with the following lines: $query[] = "CREATE TABLE member ( IDbigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY, userName varchar(40) NOT NULL, . . . RecordCreationTime TIMESTAMP NOT NULL DEFAULT '0', LastLoginTIMESTAMP NOT NULL