blob: 26f38f684a55c61a864f580b308eba2e61e86466 (
plain)
1
2
3
4
5
6
7
8
9
10
|
CREATE TABLE IF NOT EXISTS `resource_lock` (
`resource_lock_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`resource_name` varchar(256),
`lock_holder` varchar(100) NOT NULL,
`lock_count` smallint(6) NOT NULL,
`lock_time` datetime NOT NULL,
`expiration_time` datetime NOT NULL,
PRIMARY KEY (`resource_lock_id`),
UNIQUE KEY `IX1_RESOURCE_LOCK` (`resource_name`)
);
|
