DB_Forge, default value

This is version-dependent. From the MySQL documentation:

Before MySQL 5.6.5, support for automatic initialization and updating is more limited:

• DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP cannot be used with DATETIME columns.
  
• DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP can be used with at most one TIMESTAMP column per table. It is not possible to have the current timestamp be the default value for one column and the auto-update value for another column.
  

Bonfire

Practical CodeIgniter 3
CodeIgniter Testing Guide

I was referring to the comment that "a table cannot have two timestamp fields", which is not true on its own. He didn't mention you can't have two timestamp columns that ALSO use the ON UPDATE CURRENT_TIMESTAMP clause, which would be true depending on the mysql version.

SQL 92 has CURRENT_TIMESTAMP, doesn't it?

https://www.ibphoenix.com/resources/docu...gn/doc_169

Since almost anything which would require this functionality would be database-specific (and CURRENT_TIMESTAMP is certainly MySQL-specific), you're probably better off just defining the field as

PHP Code:

'Ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP', 


ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper