From 3fd916ecc02a2db8ac4be56664c1a0bbb90e6daa Mon Sep 17 00:00:00 2001 From: Eileen McNaughton Date: Sun, 3 May 2015 11:30:52 +1200 Subject: [PATCH] Default created date to current timestamp --- CRM/Upgrade/Incremental/sql/4.6.3.mysql.tpl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.6.3.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.6.3.mysql.tpl index 7f9291e6b0..e486339c57 100644 --- a/CRM/Upgrade/Incremental/sql/4.6.3.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.6.3.mysql.tpl @@ -6,7 +6,7 @@ CREATE TABLE IF NOT EXISTS `civicrm_payment_token` ( `contact_id` int unsigned NOT NULL COMMENT 'FK to Contact ID for the owner of the token', `payment_processor_id` int unsigned NOT NULL , `token` varchar(255) NOT NULL COMMENT 'Externally provided token string', - `created_date` timestamp COMMENT 'Date created', + `created_date` timestamp DEFAULT CURRENT_TIMESTAMP COMMENT 'Date created', `created_id` int unsigned COMMENT 'Contact ID of token creator', `expiry_date` datetime COMMENT 'Date this token expires', `email` varchar(255) COMMENT 'Email at the time of token creation. Useful for fraud forensics', -- 2.25.1