| sb5356 | 1c1791c | 2020-03-30 13:14:46 -0400 | [diff] [blame] | 1 | CREATE TABLE IF NOT EXISTS `resource_lock` ( |
| 2 | `resource_lock_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, | ||||
| 3 | `resource_name` varchar(256), | ||||
| 4 | `lock_holder` varchar(100) NOT NULL, | ||||
| 5 | `lock_count` smallint(6) NOT NULL, | ||||
| 6 | `lock_time` datetime NOT NULL, | ||||
| 7 | `expiration_time` datetime NOT NULL, | ||||
| 8 | PRIMARY KEY (`resource_lock_id`), | ||||
| 9 | UNIQUE KEY `IX1_RESOURCE_LOCK` (`resource_name`) | ||||
| 10 | ); | ||||