| 12345678910111213141516171819202122 |
- create table sj_group_config
- (
- id bigint unsigned auto_increment comment '主键'
- primary key,
- namespace_id varchar(64) default '764d604ec6fc45f68cd92514c40e9e1a' not null comment '命名空间id',
- group_name varchar(64) default '' not null comment '组名称',
- description varchar(256) default '' not null comment '组描述',
- token varchar(64) default 'SJ_cKqBTPzCsWA3VyuCfFoccmuIEGXjr5KT' not null comment 'token',
- group_status tinyint default 0 not null comment '组状态 0、未启用 1、启用',
- version int not null comment '版本号',
- group_partition int not null comment '分区',
- id_generator_mode tinyint default 1 not null comment '唯一id生成模式 默认号段模式',
- init_scene tinyint default 0 not null comment '是否初始化场景 0:否 1:是',
- create_dt datetime default CURRENT_TIMESTAMP not null comment '创建时间',
- update_dt datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '修改时间',
- constraint uk_namespace_id_group_name
- unique (namespace_id, group_name)
- )
- comment '组配置';
- INSERT INTO ruoyi.sj_group_config (id, namespace_id, group_name, description, token, group_status, version, group_partition, id_generator_mode, init_scene, create_dt, update_dt) VALUES (1, 'dev', 'ruoyi_group', '', 'SJ_cKqBTPzCsWA3VyuCfFoccmuIEGXjr5KT', 1, 1, 0, 1, 1, '2025-08-23 21:50:37', '2025-08-23 21:50:37');
- INSERT INTO ruoyi.sj_group_config (id, namespace_id, group_name, description, token, group_status, version, group_partition, id_generator_mode, init_scene, create_dt, update_dt) VALUES (2, 'prod', 'ruoyi_group', '', 'SJ_cKqBTPzCsWA3VyuCfFoccmuIEGXjr5KT', 1, 1, 0, 1, 1, '2025-08-23 21:50:37', '2025-08-23 21:50:37');
|
