aboutsummaryrefslogtreecommitdiffstats
path: root/feature-distributed-locking/src/main/feature/db/pooling/sql/1804-distributedlocking.upgrade.sql
blob: 07b30738d53c8d290754e0b43f7f728a23bd0e9a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
#  ============LICENSE_START=======================================================
#  feature-distributed-locking
# ================================================================================
#  Copyright (C) 2018, 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.
#  You may obtain a copy of the License at
#  
#       http://www.apache.org/licenses/LICENSE-2.0
#  
#  Unless required by applicable law or agreed to in writing, software
#  distributed under the License is distributed on an "AS IS" BASIS,
#  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
#  See the License for the specific language governing permissions and
#  limitations under the License.
#  ============LICENSE_END=========================================================

SET foreign_key_checks=0;

CREATE TABLE if NOT EXISTS pooling.locks(
    resourceId VARCHAR(128),
    host VARCHAR(128),
    owner VARCHAR(128),
    expirationTime BIGINT,
    PRIMARY KEY (resourceId),
    INDEX idx_expirationTime(expirationTime),
    INDEX idx_host(host));

SET foreign_key_checks=1;