From 6745bb97eba3b1e2a60ea2c5fc9f9298d79f13e6 Mon Sep 17 00:00:00 2001 From: jhh Date: Tue, 23 Aug 2022 20:26:21 -0500 Subject: made lock sql compatible with both mysql/mariadb Issue-ID: POLICY-4329 Signed-off-by: jhh Change-Id: I784a3f8456a201262056803169204d499a4a68a2 Signed-off-by: jhh --- .../main/feature/db/pooling/sql/1811-distributedlocking.upgrade.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'feature-distributed-locking/src') diff --git a/feature-distributed-locking/src/main/feature/db/pooling/sql/1811-distributedlocking.upgrade.sql b/feature-distributed-locking/src/main/feature/db/pooling/sql/1811-distributedlocking.upgrade.sql index ed51879c..847c44ac 100644 --- a/feature-distributed-locking/src/main/feature/db/pooling/sql/1811-distributedlocking.upgrade.sql +++ b/feature-distributed-locking/src/main/feature/db/pooling/sql/1811-distributedlocking.upgrade.sql @@ -1,7 +1,7 @@ # ============LICENSE_START======================================================= # feature-distributed-locking # ================================================================================ -# Copyright (C) 2018, 2021 AT&T Intellectual Property. All rights reserved. +# Copyright (C) 2018, 2021-2022 AT&T Intellectual Property. All rights reserved. # ================================================================================ # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. @@ -18,6 +18,6 @@ set foreign_key_checks=0; - ALTER TABLE pooling.locks modify if exists expirationTime timestamp default '1971-01-01 00:00:00.000000'; + ALTER TABLE pooling.locks modify expirationTime timestamp default '1971-01-01 00:00:00.000000'; set foreign_key_checks=1; -- cgit 1.2.3-korg