32 lines
2.5 KiB
MySQL
32 lines
2.5 KiB
MySQL
|
-- ----------------------------
|
|||
|
|
-- 项目结构节点表
|
|||
|
|
-- ----------------------------
|
|||
|
|
drop table if exists sys_project_structure;
|
|||
|
|
create table sys_project_structure (
|
|||
|
|
node_id bigint(20) not null auto_increment comment '节点ID',
|
|||
|
|
parent_id bigint(20) default 0 comment '父节点ID',
|
|||
|
|
node_name varchar(50) not null comment '节点名称',
|
|||
|
|
node_type varchar(20) not null comment '节点类型(folder/file)',
|
|||
|
|
module varchar(100) not null comment '功能模块',
|
|||
|
|
template_id bigint(20) comment '模板ID',
|
|||
|
|
table_id bigint(20) comment '关联表ID',
|
|||
|
|
category varchar(50) comment '文件类别',
|
|||
|
|
sort_order int(4) default 0 comment '显示顺序',
|
|||
|
|
status char(1) default '0' comment '状态（0正常 1停用）',
|
|||
|
|
create_by varchar(64) default '' comment '创建者',
|
|||
|
|
create_time datetime comment '创建时间',
|
|||
|
|
update_by varchar(64) default '' comment '更新者',
|
|||
|
|
update_time datetime comment '更新时间',
|
|||
|
|
primary key (node_id)
|
|||
|
|
) engine=innodb auto_increment=100 comment = '项目结构节点表';
|
|||
|
|
|
|||
|
|
-- ----------------------------
|
|||
|
|
-- 初始化-项目结构节点表数据
|
|||
|
|
-- ----------------------------
|
|||
|
|
insert into sys_project_structure values(1, 0, '项目根目录', 'folder', '根模块', null, null, null, 1, '0', 'admin', sysdate(), '', null);
|
|||
|
|
insert into sys_project_structure values(2, 1, 'src', 'folder', '源码', null, null, null, 1, '0', 'admin', sysdate(), '', null);
|
|||
|
|
insert into sys_project_structure values(3, 2, 'main', 'folder', '主目录', null, null, null, 1, '0', 'admin', sysdate(), '', null);
|
|||
|
|
insert into sys_project_structure values(4, 3, 'java', 'folder', '源代码', null, null, null, 1, '0', 'admin', sysdate(), '', null);
|
|||
|
|
insert into sys_project_structure values(5, 3, 'resources', 'folder', '资源', null, null, null, 2, '0', 'admin', sysdate(), '', null);
|
|||
|
|
insert into sys_project_structure values(6, 1, 'pom.xml', 'file', '依赖管理', null, null, 'xml', 2, '0', 'admin', sysdate(), '', null);
|
|||
|
|
insert into sys_project_structure values(7, 1, 'README.md', 'file', '说明文档', null, null, 'markdown', 3, '0', 'admin', sysdate(), '', null);
|