sj_namespace.sql 1.1 KB

1234567891011121314151617181920
  1. create table sj_namespace
  2. (
  3. id bigint unsigned auto_increment comment '主键'
  4. primary key,
  5. name varchar(64) not null comment '名称',
  6. unique_id varchar(64) not null comment '唯一id',
  7. description varchar(256) default '' not null comment '描述',
  8. deleted tinyint default 0 not null comment '逻辑删除 1、删除',
  9. create_dt datetime default CURRENT_TIMESTAMP not null comment '创建时间',
  10. update_dt datetime default CURRENT_TIMESTAMP not null on update CURRENT_TIMESTAMP comment '修改时间',
  11. constraint uk_unique_id
  12. unique (unique_id)
  13. )
  14. comment '命名空间';
  15. create index idx_name
  16. on sj_namespace (name);
  17. INSERT INTO ruoyi.sj_namespace (id, name, unique_id, description, deleted, create_dt, update_dt) VALUES (1, 'Development', 'dev', '', 0, '2025-08-23 21:50:37', '2025-08-23 21:50:37');
  18. INSERT INTO ruoyi.sj_namespace (id, name, unique_id, description, deleted, create_dt, update_dt) VALUES (2, 'Production', 'prod', '', 0, '2025-08-23 21:50:37', '2025-08-23 21:50:37');