In this way I can create a table with a timestamp field in MySQL:
CREATE TABLE foo (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
created_at TIMESTAMP,
name varchar(255)
);
Which would automatically insert a timestamp value each time a new row is inserted.
For example:
INSERT INTO foo (name) VALUES ('bar');
SELECT * FROM foo;
Output:
+----+---------------------+------+
| id | created_at | name |
+----+---------------------+------+
| 1 | 2012-03-12 10:47:02 | bar |
+----+---------------------+------+
How can I create a timestamp field like this using the drupal6 schema API?