From f6bff2e6c662d4778f86a919b6f7b731d2553f44 Mon Sep 17 00:00:00 2001 From: "dlenev@jabberwock.localdomain" <> Date: Fri, 2 Apr 2004 10:12:53 +0400 Subject: WL#1266 "Separate auto-set logic from TIMESTAMP type." Final version of patch. Adds support for specifying of DEFAULT NOW() and/or ON UPDATE NOW() clauses for TIMESTAMP field definition. Current implementation allows only one such field per table and uses several unireg types for storing info about this properties of field. It should be replaced with better implementation when new .frm format is introduced. --- mysql-test/r/show_check.result | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mysql-test/r/show_check.result') diff --git a/mysql-test/r/show_check.result b/mysql-test/r/show_check.result index 3693d92693f..5a5eb025353 100644 --- a/mysql-test/r/show_check.result +++ b/mysql-test/r/show_check.result @@ -225,7 +225,7 @@ t1 CREATE TABLE `t1` ( `empty_char` char(0) default NULL, `type_char` char(2) default NULL, `type_varchar` varchar(10) default NULL, - `type_timestamp` timestamp NOT NULL, + `type_timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `type_date` date NOT NULL default '0000-00-00', `type_time` time NOT NULL default '00:00:00', `type_datetime` datetime NOT NULL default '0000-00-00 00:00:00', -- cgit v1.2.1