aboutsummaryrefslogtreecommitdiffstats
path: root/lib/rlock/src/test/resources/schema.sql
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`)
);