Menu

#118 DEFTIMESTAMP broken on MySQL

open
nobody
None
5
2010-12-05
2010-12-05
Anonymous
No

Around line 752 in adodb-datadict.inc.php the field type for timestamps and dates in MySQL is forced to "TIMESTAMP". However, the line assigning the default clause is in an ELSE, therefore MySQL can never have a default timestamp or date value even though it supports this.

Removing the 'else' makes the DEFTIMESTAMP and DEFDATE clauses work.

Discussion