From f61aa2a3ee087dd5160cf904fdcf327fe49f31f7 Mon Sep 17 00:00:00 2001 From: Philipp Holzer Date: Sat, 7 Jul 2018 17:59:22 +0200 Subject: [PATCH] fixed locks in database.sql --- database.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/database.sql b/database.sql index b3d8f5dd05..e51f2a1e9b 100644 --- a/database.sql +++ b/database.sql @@ -576,8 +576,10 @@ CREATE TABLE IF NOT EXISTS `locks` ( `id` int unsigned NOT NULL auto_increment COMMENT 'sequential ID', `name` varchar(128) NOT NULL DEFAULT '' COMMENT '', `locked` boolean NOT NULL DEFAULT '0' COMMENT '', + `expires` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT 'datetime of lock expiration', `pid` int unsigned NOT NULL DEFAULT 0 COMMENT 'Process ID', - PRIMARY KEY(`id`) + PRIMARY KEY(`id`), + INDEX `name_expires` (`name`,`expires`) ) DEFAULT COLLATE utf8mb4_general_ci COMMENT=''; -- -- 2.39.5