This is an automated email from the ASF dual-hosted git repository.

machristie pushed a commit to branch develop
in repository https://gitbox.apache.org/repos/asf/airavata.git

commit 3fb981b8e945fc7bae16f3d5071c807ebca8e93c
Author: Marcus Christie <machris...@apache.org>
AuthorDate: Wed Mar 25 15:40:42 2020 -0400

    AIRAVATA-3126 Prevent MariaDB ON UPDATE CURRENT_TIMESTAMP
    
    Need `DEFAULT 0` to prevent `ON UPDATE CURRENT_TIMESTAMP` behavior for first
    TIMESTAMP in table.
---
 .../next/DeltaScripts/appCatalog_schema_delta.sql                       | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git 
a/modules/registry/release-migration-scripts/next/DeltaScripts/appCatalog_schema_delta.sql
 
b/modules/registry/release-migration-scripts/next/DeltaScripts/appCatalog_schema_delta.sql
index 480b545..c25b3b1 100644
--- 
a/modules/registry/release-migration-scripts/next/DeltaScripts/appCatalog_schema_delta.sql
+++ 
b/modules/registry/release-migration-scripts/next/DeltaScripts/appCatalog_schema_delta.sql
@@ -22,7 +22,7 @@ use app_catalog;
 
 -- AIRAVATA-3126
 CREATE TABLE IF NOT EXISTS COMPUTE_RESOURCE_RESERVATION -- 
ComputeResourceReservationEntity
-    (RESERVATION_ID VARCHAR(255) NOT NULL, END_TIME TIMESTAMP NOT NULL, 
RESERVATION_NAME VARCHAR(255) NOT NULL, START_TIME TIMESTAMP NOT NULL, 
RESOURCE_ID VARCHAR(255) NOT NULL, GROUP_RESOURCE_PROFILE_ID VARCHAR(255) NOT 
NULL, PRIMARY KEY (RESERVATION_ID)
+    (RESERVATION_ID VARCHAR(255) NOT NULL, END_TIME TIMESTAMP NOT NULL DEFAULT 
0, RESERVATION_NAME VARCHAR(255) NOT NULL, START_TIME TIMESTAMP NOT NULL 
DEFAULT 0, RESOURCE_ID VARCHAR(255) NOT NULL, GROUP_RESOURCE_PROFILE_ID 
VARCHAR(255) NOT NULL, PRIMARY KEY (RESERVATION_ID)
 )ENGINE=InnoDB DEFAULT CHARSET=latin1;
 CREATE TABLE IF NOT EXISTS COMPUTE_RESOURCE_RESERVATION_QUEUE (RESERVATION_ID 
VARCHAR(255), QUEUE_NAME VARCHAR(255) NOT NULL
 )ENGINE=InnoDB DEFAULT CHARSET=latin1;

Reply via email to