sj_sequence_alloc.sql 793 B

1234567891011121314
  1. create table sj_sequence_alloc
  2. (
  3. id bigint unsigned auto_increment comment '主键'
  4. primary key,
  5. namespace_id varchar(64) default '764d604ec6fc45f68cd92514c40e9e1a' not null comment '命名空间id',
  6. group_name varchar(64) default '' not null comment '组名称',
  7. max_id bigint default 1 not null comment '最大id',
  8. step int default 100 not null comment '步长',
  9. update_dt datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '更新时间',
  10. constraint uk_namespace_id_group_name
  11. unique (namespace_id, group_name)
  12. )
  13. comment '号段模式序号ID分配表';