sj_distributed_lock.sql 647 B

123456789101112
  1. create table sj_distributed_lock
  2. (
  3. name varchar(64) not null comment '锁名称'
  4. primary key,
  5. lock_until timestamp(3) default CURRENT_TIMESTAMP(3) not null on update CURRENT_TIMESTAMP(3) comment '锁定时长',
  6. locked_at timestamp(3) default CURRENT_TIMESTAMP(3) not null comment '锁定时间',
  7. locked_by varchar(255) not null comment '锁定者',
  8. create_dt datetime default CURRENT_TIMESTAMP not null comment '创建时间',
  9. update_dt datetime default CURRENT_TIMESTAMP not null comment '修改时间'
  10. )
  11. comment '锁定表';