From 846577766e3d6b261508de0b97d0d382e1e560cb Mon Sep 17 00:00:00 2001 From: sunsetsystems Date: Fri, 16 Oct 2009 14:05:05 +0000 Subject: [PATCH] removed "default current_timestamp on update current_timestamp" which is unnecessary and incompatible with mysql 4.0 --- sql/database.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/sql/database.sql b/sql/database.sql index f44a2eb17..21b833133 100644 --- a/sql/database.sql +++ b/sql/database.sql @@ -251,7 +251,7 @@ CREATE TABLE `documents` ( `mimetype` varchar(255) default NULL, `pages` int(11) default NULL, `owner` int(11) default NULL, - `revision` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `revision` timestamp NOT NULL, `foreign_id` int(11) default NULL, `docdate` date default NULL, `list_id` bigint(20) NOT NULL default '0', @@ -1363,7 +1363,7 @@ CREATE TABLE `immunizations` ( `vis_date` date default NULL COMMENT 'Date of VIS Statement', `note` text, `create_date` datetime default NULL, - `update_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `update_date` timestamp NOT NULL, `created_by` bigint(20) default NULL, `updated_by` bigint(20) default NULL, PRIMARY KEY (`id`) @@ -2018,7 +2018,7 @@ CREATE TABLE `notes` ( `note` varchar(255) default NULL, `owner` int(11) default NULL, `date` datetime default NULL, - `revision` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `revision` timestamp NOT NULL, PRIMARY KEY (`id`), KEY `foreign_id` (`owner`), KEY `foreign_id_2` (`foreign_id`), @@ -2456,7 +2456,7 @@ CREATE TABLE `pma_history` ( `username` varchar(64) default NULL, `db` varchar(64) default NULL, `table` varchar(64) default NULL, - `timevalue` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `timevalue` timestamp NOT NULL, `sqlquery` text, PRIMARY KEY (`id`), KEY `username` (`username`,`db`,`table`,`timevalue`) -- 2.11.4.GIT