1 配置说明
- 天舟云只需要配置必要的配置，多个服务公用一个即可，如有项目独有的，可以自定义个namespace配置即可
- legox仅展示新增的配置项
1.1 天舟云配置说明
# 数据库配置，必须配置成自己的
spring.datasource.url = jdbc:postgresql://t-dbsec-postgres.gz.cvte.cn:11000/pguat_scm
spring.datasource.username = scm
spring.datasource.password = XXXXXX
spring.datasource.driver-class-name = org.postgresql.Driver
#Redis连接，建议配置成自己的
spring.redis.host = redis-fat001.gz.cvte.cn
spring.redis.password = XXXXX
spring.redis.port = 6379
spring.redis.database = 9
# IAC配置，必须配置成自己的
csb.iac.appId = 15d22276-a397-4f24-bcea-XXXXXX
csb.iac.appSecret = d96deb81-358e-481b-XXXXXX
csb.iac.systemId = 1206b5b9-1c37-45c6-8ed0-XXXXX
csb.iac.tenantId = 93caaf4e-478e-4026-a87d-XXXXXXX
# 服务名，必须配置成自己的
lcp.hub.application.name = scm-lcp-hub
lcp.app.application.name = scm-lcp-app
lcp.data.application.name = scm-lcp-data
csb.legox.application.name = scm-bsm
# 流水号使用公共的，建议使用自己的
csb.serial.feignName = csb-legox/legox
# 队列，使用低代码的MQ使用不同的队列
itemtoes.queue.name = scm-lcpSearchPushItemToEsQueue
#域名配置，域名转发必须一致，都是/hub /app /data，域名改成自己的
lcp.core.url = https://scm-buat-api.gz.cvte.cn/app
lcp.data.url = https://scm-buat-api.gz.cvte.cn/data
lcp.hub.url = https://scm-buat-api.gz.cvte.cn/hub
# bsm csb legox后台访问地址
service.csb.url = https://scm-buat-api.gz.cvte.cn
service.csb.gw.url = https://csbuat-gw.gz.cvte.cn
#流水号地址，如果需要使用自己的需要修改,多租户版本使用https://csbsit-admin.gz.cvte.cn/legox，单租户使用
service.csno.url = https://csbsit-admin.gz.cvte.cn/legox 或者 https://csbsit-api.gz.cvte.cn/csno
# 产品线标识，改成自己的
lcp.log.prodLine = scm1.2 csb-legox配置
此处只为增量配置
# 新增的
csb.allow.appId.menu.query.resource = false
1.3 nacos配置
- 需提供当前部署的租户ID和数据库信息给到【王浩彬】，新增租户配置
- 如果天舟云的数据库与legox的数据库不一致，需要给两份以下配置
需提供的信息示例如下：# 数据库配置，必须配置成自己的 druid.url = jdbc:postgresql://postgres002.gz.cvte.cn:1921/**_tzc?&ssl=false druid.username = user druid.password = 123***** druid.driver-class-name = org.postgresql.Driver
2 鲸云配置
此处展示的是鲸云环境变量配置，项目部署完整请参考V1.6.0的文档
2.1 lcp-hub项目鲸云配置
JAVA_OPTS = -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/app/heapdump.hprof -Denv=PRO
app.id = 1234
apollo.app.namespaces = application
lcp.log.enabled = true
lcp.log.sender.type = web2.2 lcp-app项目鲸云配置
JAVA_OPTS = -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/app/heapdump.hprof -Denv=PRO
app.id = 1234
apollo.app.namespaces = application
csb.feignName = csb-legox/legox
lcp.log.enabled = true
lcp.log.sender.type = web2.3 lcp-data项目鲸云配置
JAVA_OPTS = -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/app/heapdump.hprof -Denv=PRO
app.id = 1234
apollo.app.namespaces = application
lcp.log.enabled = true
lcp.log.sender.type = web3 数据库脚本
此处是额外无法自动执行的，有些是选配的，legox脚本是基于原来增量的脚本
3.1 lcp-data脚本
此处为业务数据库执行的，不是配置数据库的脚本，在系统中自己增加的数据源才需要，而且是需要使用【对象】【变更】等功能时候才需要，否则不需要执行
DROP TABLE IF EXISTS obj_version;
CREATE TABLE obj_version(
ID VARCHAR(32) NOT NULL,
OBJ_ID VARCHAR(32),
CHANGE_ID VARCHAR(32),
CHANGE_TYPE VARCHAR(64),
IS_RELEASED VARCHAR(1),
IS_LATEST VARCHAR(1) NOT NULL,
VERSION_NO VARCHAR(128),
PRE_VERSION_NO VARCHAR(128),
RELEASE_TIME TIMESTAMP,
SORT_NO INTEGER,
IS_ENABLED VARCHAR(1),
IS_DELETED VARCHAR(1),
CRT_USER VARCHAR(32),
CRT_NAME VARCHAR(64),
CRT_TIME TIMESTAMP,
CRT_HOST VARCHAR(64),
UPD_USER VARCHAR(32),
UPD_NAME VARCHAR(64),
UPD_TIME TIMESTAMP,
UPD_HOST VARCHAR(64),
PRIMARY KEY (ID)
);
COMMENT ON TABLE obj_version IS '对象版本';
COMMENT ON COLUMN obj_version.ID IS '主键';
COMMENT ON COLUMN obj_version.OBJ_ID IS '对象ID';
COMMENT ON COLUMN obj_version.CHANGE_ID IS '变更ID';
COMMENT ON COLUMN obj_version.CHANGE_TYPE IS '变更类型';
COMMENT ON COLUMN obj_version.IS_RELEASED IS '是否已发布';
COMMENT ON COLUMN obj_version.IS_LATEST IS '是否最新已发布版本';
COMMENT ON COLUMN obj_version.VERSION_NO IS '版本号';
COMMENT ON COLUMN obj_version.PRE_VERSION_NO IS '上一个版本';
COMMENT ON COLUMN obj_version.RELEASE_TIME IS '发布时间';
COMMENT ON COLUMN obj_version.SORT_NO IS '排序';
COMMENT ON COLUMN obj_version.IS_ENABLED IS '禁用启用';
COMMENT ON COLUMN obj_version.IS_DELETED IS '是否删除';
COMMENT ON COLUMN obj_version.CRT_USER IS '创建人';
COMMENT ON COLUMN obj_version.CRT_NAME IS '创建人名';
COMMENT ON COLUMN obj_version.CRT_TIME IS '创建时间';
COMMENT ON COLUMN obj_version.CRT_HOST IS '创建地址';
COMMENT ON COLUMN obj_version.UPD_USER IS '更新人';
COMMENT ON COLUMN obj_version.UPD_NAME IS '更新人名';
COMMENT ON COLUMN obj_version.UPD_TIME IS '更新时间';
COMMENT ON COLUMN obj_version.UPD_HOST IS '更新地址';
create index idx_obj_version_n1 on OBJ_VERSION(obj_id);
create index idx_obj_version_n2 on OBJ_VERSION(change_id);
DROP TABLE IF EXISTS obj_attr_value_list;
CREATE TABLE obj_attr_value_list
(
id varchar(32) NOT NULL,
list_id varchar(32),
list_type varchar(32),
attr_id varchar(32),
api_name varchar(255),
attr_value varchar(1000),
upd_user varchar(32),
upd_time TIMESTAMP,
sort_no integer,
PRIMARY KEY (ID)
);
COMMENT ON TABLE obj_attr_value_list IS '列表属性值';
COMMENT ON COLUMN obj_attr_value_list.id IS '主键';
COMMENT ON COLUMN obj_attr_value_list.list_id IS '列表ID';
COMMENT ON COLUMN obj_attr_value_list.list_type IS '列表类型_TagTypeEnum';
COMMENT ON COLUMN obj_attr_value_list.attr_id IS '属性ID';
COMMENT ON COLUMN obj_attr_value_list.api_name IS '属性CODE';
COMMENT ON COLUMN obj_attr_value_list.attr_value IS '属性值';
COMMENT ON COLUMN obj_attr_value_list.upd_user IS '更新人';
COMMENT ON COLUMN obj_attr_value_list.upd_time IS '更新时间';
COMMENT ON COLUMN obj_attr_value_list.sort_no IS '排序号（多选值的排序）';
CREATE INDEX idx_attr_value_list_n1 ON obj_attr_value_list(attr_value, api_name) ;
CREATE INDEX idx_attr_value_list_n2 ON obj_attr_value_list(list_id, api_name, attr_value) ;
CREATE INDEX idx_attr_value_list_n3 ON obj_attr_value_list(attr_id, list_id) ;
DROP TABLE IF EXISTS obj_attr_value_version;
CREATE TABLE obj_attr_value_version(
ID VARCHAR(32) NOT NULL,
VERSION_ID VARCHAR(32),
ATTR_ID VARCHAR(32),
API_NAME VARCHAR(255),
NEW_VALUE VARCHAR(1000),
OLD_VALUE VARCHAR(1000),
ORG_ID VARCHAR(32),
NEW_ONLY_VALUE VARCHAR(32),
OLD_ONLY_VALUE VARCHAR(32),
NEW_ONLY_UNIT VARCHAR(32),
OLD_ONLY_UNIT VARCHAR(32),
UPD_USER VARCHAR(32),
UPD_TIME TIMESTAMP,
SORT_NO INTEGER,
PRIMARY KEY (ID)
);
COMMENT ON TABLE obj_attr_value_version IS '属性值版本';
COMMENT ON COLUMN obj_attr_value_version.ID IS '主键';
COMMENT ON COLUMN obj_attr_value_version.VERSION_ID IS '版本ID';
COMMENT ON COLUMN obj_attr_value_version.ATTR_ID IS '属性ID';
COMMENT ON COLUMN obj_attr_value_version.API_NAME IS '属性编码';
COMMENT ON COLUMN obj_attr_value_version.NEW_VALUE IS '属性新值';
COMMENT ON COLUMN obj_attr_value_version.OLD_VALUE IS '属性旧值';
COMMENT ON COLUMN obj_attr_value_version.ORG_ID IS '组织ID';
COMMENT ON COLUMN obj_attr_value_version.NEW_ONLY_VALUE IS '仅新值';
COMMENT ON COLUMN obj_attr_value_version.OLD_ONLY_VALUE IS '仅旧值';
COMMENT ON COLUMN obj_attr_value_version.NEW_ONLY_UNIT IS '仅新值单位';
COMMENT ON COLUMN obj_attr_value_version.OLD_ONLY_UNIT IS '仅旧值单位';
COMMENT ON COLUMN obj_attr_value_version.UPD_USER IS '更新人';
COMMENT ON COLUMN obj_attr_value_version.UPD_TIME IS '更新时间';
COMMENT ON COLUMN obj_attr_value_version.SORT_NO IS '序号（多选值排序）';
-- 版本属性值表
CREATE INDEX IDX_ATTR_VALUE_version_N1 ON OBJ_ATTR_VALUE_version(attr_id, version_id) ;
CREATE INDEX IDX_ATTR_VALUE_version_N2 ON OBJ_ATTR_VALUE_version(version_id, api_name) ; -- api_name字段需要增加
DROP TABLE IF EXISTS obj_attr_value_org;
CREATE TABLE obj_attr_value_org(
ID VARCHAR(32) NOT NULL,
OBJ_ID VARCHAR(32),
ATTR_ID VARCHAR(32),
API_NAME VARCHAR(255),
ATTR_VALUE VARCHAR(1000),
ONLY_VALUE VARCHAR(32),
ONLY_UNIT VARCHAR(32),
ORG_ID VARCHAR(32),
UPD_USER VARCHAR(32),
UPD_TIME TIMESTAMP,
SORT_NO INTEGER,
PRIMARY KEY (ID)
);
COMMENT ON TABLE obj_attr_value_org IS '分组织管控属性值';
COMMENT ON COLUMN obj_attr_value_org.ID IS '主键';
COMMENT ON COLUMN obj_attr_value_org.OBJ_ID IS '对象ID';
COMMENT ON COLUMN obj_attr_value_org.ATTR_ID IS '属性ID';
COMMENT ON COLUMN obj_attr_value_org.API_NAME IS '属性CODE';
COMMENT ON COLUMN obj_attr_value_org.ATTR_VALUE IS '属性值';
COMMENT ON COLUMN obj_attr_value_org.ONLY_VALUE IS '仅属性值';
COMMENT ON COLUMN obj_attr_value_org.ONLY_UNIT IS '仅属性单位';
COMMENT ON COLUMN obj_attr_value_org.ORG_ID IS '组织ID';
COMMENT ON COLUMN obj_attr_value_org.UPD_USER IS '更新人';
COMMENT ON COLUMN obj_attr_value_org.UPD_TIME IS '更新时间';
COMMENT ON COLUMN obj_attr_value_org.SORT_NO IS '排序号（多选值的排序）';
CREATE INDEX idx_attr_value_org_n1 ON obj_attr_value_org(attr_value, api_name) ;
CREATE INDEX idx_attr_value_org_n2 ON obj_attr_value_org(obj_id, api_name, attr_value) ;
CREATE INDEX idx_attr_value_org_n3 ON obj_attr_value_org(attr_id, obj_id) ;
DROP TABLE IF EXISTS obj_attr_value_ex;
CREATE TABLE obj_attr_value_ex(
ID VARCHAR(32) NOT NULL,
CLOB_VALUE TEXT,
PRIMARY KEY (ID)
);
COMMENT ON TABLE obj_attr_value_ex IS '大文本属性值';
COMMENT ON COLUMN obj_attr_value_ex.ID IS '主键';
COMMENT ON COLUMN obj_attr_value_ex.CLOB_VALUE IS '大文本属性值';
DROP TABLE IF EXISTS obj_attr_value;
CREATE TABLE obj_attr_value(
ID VARCHAR(32) NOT NULL,
OBJ_ID VARCHAR(32),
ATTR_ID VARCHAR(32),
API_NAME VARCHAR(255),
ATTR_VALUE VARCHAR(1000),
ONLY_VALUE VARCHAR(32),
ONLY_UNIT VARCHAR(32),
UPD_USER VARCHAR(32),
UPD_TIME TIMESTAMP,
SORT_NO INTEGER,
PRIMARY KEY (ID)
);
COMMENT ON TABLE obj_attr_value IS '属性值';
COMMENT ON COLUMN obj_attr_value.ID IS '主键';
COMMENT ON COLUMN obj_attr_value.OBJ_ID IS '对象ID';
COMMENT ON COLUMN obj_attr_value.ATTR_ID IS '属性ID';
COMMENT ON COLUMN obj_attr_value.API_NAME IS '属性CODE';
COMMENT ON COLUMN obj_attr_value.ATTR_VALUE IS '属性值';
COMMENT ON COLUMN obj_attr_value.ONLY_VALUE IS '仅属性值';
COMMENT ON COLUMN obj_attr_value.ONLY_UNIT IS '仅属性单位';
COMMENT ON COLUMN obj_attr_value.UPD_USER IS '更新人';
COMMENT ON COLUMN obj_attr_value.UPD_TIME IS '更新时间';
COMMENT ON COLUMN obj_attr_value.SORT_NO IS '排序号（多选值的排序）';
-- 属性值
CREATE INDEX IDX_ATTR_VALUE_ITEM_ATTR_N1 ON OBJ_ATTR_VALUE(ATTR_VALUE, API_NAME) ;
CREATE INDEX IDX_ATTR_VALUE_ITEM_ATTR_N2 ON OBJ_ATTR_VALUE(OBJ_ID, API_NAME, ATTR_VALUE) ;
CREATE INDEX IDX_ATTR_VALUE_ITEM_ATTR_N3 ON OBJ_ATTR_VALUE(ATTR_ID, OBJ_ID) ;
-- -------------------------------------------------------------- 附件相关 --------------------------------------------------------------
-- ALTER TABLE obj_file DROP COLUMN last_view_time;
-- ALTER TABLE obj_file DROP COLUMN last_download_time;
-- ALTER TABLE obj_file DROP COLUMN srm_file_id;
DROP TABLE IF EXISTS obj_file_data;
CREATE TABLE obj_file_data(
id VARCHAR(32) NOT NULL,
csb_file_id varchar(50),
file_name varchar(800),
description varchar(500),
file_size numeric,
file_type varchar(20),
check_status VARCHAR(1),
checksum VARCHAR(255),
is_deleted VARCHAR(1),
crt_user VARCHAR(32),
crt_name varchar(50),
crt_time timestamp,
crt_host varchar(50),
upd_user VARCHAR(32),
upd_name varchar(50),
upd_time timestamp,
upd_host varchar(50),
obj_id varchar(32) NULL,
obj_class_id varchar(32) NULL,
app_id VARCHAR(64),
product_id VARCHAR(64),
tenant_id VARCHAR(64),
PRIMARY KEY (id)
);
COMMENT ON TABLE obj_file_data IS '附件记录';
COMMENT ON COLUMN obj_file_data.id IS '主键';
COMMENT ON COLUMN obj_file_data.csb_file_id IS '附件服务ID';
COMMENT ON COLUMN obj_file_data.file_name IS '附件名称';
COMMENT ON COLUMN obj_file_data.description IS '描述';
COMMENT ON COLUMN obj_file_data.file_size IS '附件大小';
COMMENT ON COLUMN obj_file_data.file_type IS '附件类型';
COMMENT ON COLUMN obj_file_data.check_status IS '状态';
COMMENT ON COLUMN obj_file_data.checksum IS '文件校验和';
COMMENT ON COLUMN obj_file_data.is_deleted IS '是否删除';
COMMENT ON COLUMN obj_file_data.obj_id IS '表单对象ID';
COMMENT ON COLUMN obj_file_data.obj_class_id IS '表单分类ID';
COMMENT ON COLUMN obj_file_data.app_id IS '应用ID';
COMMENT ON COLUMN obj_file_data.tenant_id IS '应用ID';
DROP TABLE IF EXISTS obj_file_info;
CREATE TABLE obj_file_info(
ID VARCHAR(32) NOT NULL,
FILE_NAME VARCHAR(2000),
DESCRIPTION VARCHAR(4000),
FILE_TYPE VARCHAR(32),
CHECK_STATUS VARCHAR(1),
ATTRIBUTE1 VARCHAR(255),
ATTRIBUTE2 VARCHAR(255),
IS_ENABLED VARCHAR(1),
IS_DELETED VARCHAR(1),
CRT_USER VARCHAR(32),
CRT_NAME VARCHAR(64),
CRT_TIME TIMESTAMP,
CRT_HOST VARCHAR(64),
UPD_USER VARCHAR(32),
UPD_NAME VARCHAR(64),
UPD_TIME TIMESTAMP,
UPD_HOST VARCHAR(64),
APP_ID VARCHAR(64),
product_id VARCHAR(64),
TENANT_ID VARCHAR(64),
PRIMARY KEY (ID)
);
COMMENT ON TABLE obj_file_info IS '附件信息';
COMMENT ON COLUMN obj_file_info.ID IS '主键';
COMMENT ON COLUMN obj_file_info.FILE_NAME IS '附件名称';
COMMENT ON COLUMN obj_file_info.DESCRIPTION IS '附件描述';
COMMENT ON COLUMN obj_file_info.FILE_TYPE IS '附件类型';
COMMENT ON COLUMN obj_file_info.CHECK_STATUS IS '签入签出状态';
COMMENT ON COLUMN obj_file_info.ATTRIBUTE1 IS '扩展属性1';
COMMENT ON COLUMN obj_file_info.ATTRIBUTE2 IS '扩展属性2';
COMMENT ON COLUMN obj_file_info.IS_ENABLED IS '禁用启用';
COMMENT ON COLUMN obj_file_info.IS_DELETED IS '是否删除';
COMMENT ON COLUMN obj_file_info.CRT_USER IS '创建人';
COMMENT ON COLUMN obj_file_info.CRT_NAME IS '创建人名';
COMMENT ON COLUMN obj_file_info.CRT_TIME IS '创建时间';
COMMENT ON COLUMN obj_file_info.CRT_HOST IS '创建地址';
COMMENT ON COLUMN obj_file_info.UPD_USER IS '更新人';
COMMENT ON COLUMN obj_file_info.UPD_NAME IS '更新人名';
COMMENT ON COLUMN obj_file_info.UPD_TIME IS '更新时间';
COMMENT ON COLUMN obj_file_info.UPD_HOST IS '更新地址';
COMMENT ON COLUMN obj_file_info.APP_ID IS '应用ID';
COMMENT ON COLUMN obj_file_info.TENANT_ID IS '租户号';
DROP TABLE IF EXISTS obj_file_revision;
CREATE TABLE obj_file_revision(
ID VARCHAR(32) NOT NULL,
FILE_INFO_ID VARCHAR(32),
FILE_ID VARCHAR(32),
OBJ_ID VARCHAR(32),
OBJ_TABLE VARCHAR(64),
CHANGE_ID VARCHAR(32),
REVISION_NO VARCHAR(32),
CHECK_IN_TIME TIMESTAMP,
IS_ENABLED VARCHAR(1),
IS_DELETED VARCHAR(1),
CRT_USER VARCHAR(32),
CRT_NAME VARCHAR(64),
CRT_TIME TIMESTAMP,
CRT_HOST VARCHAR(64),
UPD_USER VARCHAR(32),
UPD_NAME VARCHAR(64),
UPD_TIME TIMESTAMP,
UPD_HOST VARCHAR(64),
APP_ID VARCHAR(64),
product_id VARCHAR(64),
TENANT_ID VARCHAR(64),
PRIMARY KEY (ID)
);
COMMENT ON TABLE obj_file_revision IS '对象附件版次';
COMMENT ON COLUMN obj_file_revision.ID IS '主键';
COMMENT ON COLUMN obj_file_revision.FILE_INFO_ID IS '附件信息ID';
COMMENT ON COLUMN obj_file_revision.FILE_ID IS '附件ID';
COMMENT ON COLUMN obj_file_revision.OBJ_ID IS '对象ID';
COMMENT ON COLUMN obj_file_revision.OBJ_TABLE IS '对象表名';
COMMENT ON COLUMN obj_file_revision.CHANGE_ID IS '变更ID';
COMMENT ON COLUMN obj_file_revision.REVISION_NO IS '版次号';
COMMENT ON COLUMN obj_file_revision.CHECK_IN_TIME IS '发布时间（签入时间）';
COMMENT ON COLUMN obj_file_revision.IS_ENABLED IS '禁用启用';
COMMENT ON COLUMN obj_file_revision.IS_DELETED IS '是否删除';
COMMENT ON COLUMN obj_file_revision.CRT_USER IS '创建人';
COMMENT ON COLUMN obj_file_revision.CRT_NAME IS '创建人名';
COMMENT ON COLUMN obj_file_revision.CRT_TIME IS '创建时间（签出时间）';
COMMENT ON COLUMN obj_file_revision.CRT_HOST IS '创建地址';
COMMENT ON COLUMN obj_file_revision.UPD_USER IS '更新人';
COMMENT ON COLUMN obj_file_revision.UPD_NAME IS '更新人名';
COMMENT ON COLUMN obj_file_revision.UPD_TIME IS '更新时间';
COMMENT ON COLUMN obj_file_revision.UPD_HOST IS '更新地址';
COMMENT ON COLUMN obj_file_revision.APP_ID IS '应用ID';
COMMENT ON COLUMN obj_file_revision.TENANT_ID IS '租户号';
DROP TABLE IF EXISTS obj_file_revision_rel;
CREATE TABLE obj_file_revision_rel(
ID VARCHAR(32) NOT NULL,
OBJ_ID VARCHAR(32),
OBJ_TABLE VARCHAR(64),
CHANGE_ID VARCHAR(32),
FILE_INFO_ID VARCHAR(32),
FILE_REVISION_ID VARCHAR(32),
IS_OBJ_MAIN_FILE VARCHAR(1),
OPERATORS VARCHAR(100),
IS_ENABLED VARCHAR(1),
IS_DELETED VARCHAR(1),
CRT_USER VARCHAR(32),
CRT_NAME VARCHAR(64),
CRT_TIME TIMESTAMP,
CRT_HOST VARCHAR(64),
UPD_USER VARCHAR(32),
UPD_NAME VARCHAR(64),
UPD_TIME TIMESTAMP,
UPD_HOST VARCHAR(64),
APP_ID VARCHAR(64),
product_id VARCHAR(64),
TENANT_ID VARCHAR(64),
PRIMARY KEY (ID)
);
COMMENT ON TABLE obj_file_revision_rel IS '附件版次关系';
COMMENT ON COLUMN obj_file_revision_rel.ID IS '主键';
COMMENT ON COLUMN obj_file_revision_rel.OBJ_ID IS '对象ID';
COMMENT ON COLUMN obj_file_revision_rel.OBJ_TABLE IS '对象表名';
COMMENT ON COLUMN obj_file_revision_rel.CHANGE_ID IS '变更ID';
COMMENT ON COLUMN obj_file_revision_rel.FILE_INFO_ID IS '附件信息ID';
COMMENT ON COLUMN obj_file_revision_rel.FILE_REVISION_ID IS '生效文件版次id';
COMMENT ON COLUMN obj_file_revision_rel.IS_OBJ_MAIN_FILE IS '是否文件对象的主附件';
COMMENT ON COLUMN obj_file_revision_rel.OPERATORS IS '操作类型, 多个逗号隔开';
COMMENT ON COLUMN obj_file_revision_rel.IS_ENABLED IS '禁用启用';
COMMENT ON COLUMN obj_file_revision_rel.IS_DELETED IS '是否删除';
COMMENT ON COLUMN obj_file_revision_rel.CRT_USER IS '创建人';
COMMENT ON COLUMN obj_file_revision_rel.CRT_NAME IS '创建人名';
COMMENT ON COLUMN obj_file_revision_rel.CRT_TIME IS '创建时间';
COMMENT ON COLUMN obj_file_revision_rel.CRT_HOST IS '创建地址';
COMMENT ON COLUMN obj_file_revision_rel.UPD_USER IS '更新人';
COMMENT ON COLUMN obj_file_revision_rel.UPD_NAME IS '更新人名';
COMMENT ON COLUMN obj_file_revision_rel.UPD_TIME IS '更新时间';
COMMENT ON COLUMN obj_file_revision_rel.UPD_HOST IS '更新地址';
COMMENT ON COLUMN obj_file_revision_rel.APP_ID IS '应用ID';
COMMENT ON COLUMN obj_file_revision_rel.TENANT_ID IS '租户号';
DROP TABLE IF EXISTS obj_relation;
-- 对象关联关系2023年08月01日
CREATE TABLE obj_relation
(
ID VARCHAR(32) NOT NULL PRIMARY KEY,
OBJ_ID VARCHAR(32),
OBJ_CLASS_ID VARCHAR(32),
OBJ_TABLE VARCHAR(64),
RELATION_OBJ_ID VARCHAR(32),
RELATION_OBJ_CLASS_ID VARCHAR(32),
RELATION_OBJ_TABLE VARCHAR(64),
SOURCE_ATTR_ID VARCHAR(36),
FORBID_DELETE VARCHAR(1),
IS_DELETED VARCHAR(1),
CRT_USER VARCHAR(32),
CRT_NAME VARCHAR(50),
CRT_TIME TIMESTAMP,
CRT_HOST VARCHAR(50),
UPD_USER VARCHAR(32),
UPD_NAME VARCHAR(50),
UPD_TIME TIMESTAMP,
UPD_HOST VARCHAR(50),
APP_ID VARCHAR(64),
TENANT_ID VARCHAR(64),
product_id varchar(64)
);
COMMENT ON TABLE obj_relation IS '对象关联关系表';
COMMENT ON COLUMN obj_relation.OBJ_ID IS '当前对象ID';
COMMENT ON COLUMN obj_relation.OBJ_CLASS_ID IS '当前对象分类ID';
COMMENT ON COLUMN obj_relation.OBJ_TABLE IS '当前对象表名,来源 obj_class.api_name,如果有变更需要一起调整';
COMMENT ON COLUMN obj_relation.RELATION_OBJ_ID IS '关联对象ID';
COMMENT ON COLUMN obj_relation.RELATION_OBJ_CLASS_ID IS '关联对象分类ID';
COMMENT ON COLUMN obj_relation.RELATION_OBJ_TABLE IS '关联对象表名,来源 obj_class.api_name,如果有变更需要一起调整';
COMMENT ON COLUMN obj_relation.SOURCE_ATTR_ID IS '关联属性ID';
COMMENT ON COLUMN obj_relation.FORBID_DELETE IS '禁删标志, 默认 0';
-- -------------------------------------------------------------- BOM 2023年09月06日 --------------------------------------------------------------
DROP TABLE IF EXISTS obj_bom;
/* 1. 创建BOM表 */
CREATE TABLE obj_bom(
ID VARCHAR(32) NOT NULL,
PARENT_OBJ_ID VARCHAR(32),
OBJ_ID VARCHAR(32),
OBJ_NUMBER VARCHAR(255),
VERSION_IN VARCHAR(32),
VERSION_OUT VARCHAR(32),
PRIOR_BOM VARCHAR(32),
CRT_USER VARCHAR(32),
CRT_NAME VARCHAR(64),
CRT_TIME TIMESTAMP,
CRT_HOST VARCHAR(64),
UPD_USER VARCHAR(32),
UPD_NAME VARCHAR(64),
UPD_TIME TIMESTAMP,
UPD_HOST VARCHAR(64),
PRIMARY KEY (ID)
);
COMMENT ON TABLE obj_bom IS 'BOM表;';
COMMENT ON COLUMN obj_bom.ID IS '主键';
COMMENT ON COLUMN obj_bom.PARENT_OBJ_ID IS '产品实例ID';
COMMENT ON COLUMN obj_bom.OBJ_ID IS '子物件实例ID';
COMMENT ON COLUMN obj_bom.OBJ_NUMBER IS '子物件实例编号';
COMMENT ON COLUMN obj_bom.VERSION_IN IS '进入版本ID';
COMMENT ON COLUMN obj_bom.VERSION_OUT IS '退出版本ID';
COMMENT ON COLUMN obj_bom.PRIOR_BOM IS '前置bom';
COMMENT ON COLUMN obj_bom.CRT_USER IS '创建人';
COMMENT ON COLUMN obj_bom.CRT_NAME IS '创建人名';
COMMENT ON COLUMN obj_bom.CRT_TIME IS '创建时间';
COMMENT ON COLUMN obj_bom.CRT_HOST IS '创建地址';
COMMENT ON COLUMN obj_bom.UPD_USER IS '更新人';
COMMENT ON COLUMN obj_bom.UPD_NAME IS '更新人名';
COMMENT ON COLUMN obj_bom.UPD_TIME IS '更新时间';
COMMENT ON COLUMN obj_bom.UPD_HOST IS '更新地址';
CREATE INDEX IDX_OBJ_BOM_PARENT_OBJ_ID ON OBJ_BOM(PARENT_OBJ_ID, VERSION_IN);
CREATE INDEX IDX_OBJ_BOM_OBJ_ID ON OBJ_BOM(OBJ_ID);
CREATE INDEX IDX_OBJ_BOM_OBJ_NO ON OBJ_BOM(OBJ_NUMBER);
CREATE INDEX IDX_OBJ_BOM_VER_IN ON OBJ_BOM(VERSION_IN);
CREATE INDEX IDX_OBJ_BOM_VER_OUT ON OBJ_BOM(VERSION_OUT);
DROP TABLE IF EXISTS obj_bom_designator;
/* 2. 创建bom位号表*/
CREATE TABLE obj_bom_designator(
ID VARCHAR(32) NOT NULL,
BOM_ID VARCHAR(32),
LABEL VARCHAR(255),
SORT_NO INTEGER,
IS_ENABLED VARCHAR(1),
IS_DELETED VARCHAR(1),
CRT_USER VARCHAR(32),
CRT_NAME VARCHAR(64),
CRT_TIME TIMESTAMP,
CRT_HOST VARCHAR(64),
PRIMARY KEY (ID)
);
COMMENT ON TABLE obj_bom_designator IS 'bom位号;';
COMMENT ON COLUMN obj_bom_designator.ID IS '主键';
COMMENT ON COLUMN obj_bom_designator.BOM_ID IS 'BOMID';
COMMENT ON COLUMN obj_bom_designator.LABEL IS '位号';
COMMENT ON COLUMN obj_bom_designator.SORT_NO IS '序号';
COMMENT ON COLUMN obj_bom_designator.IS_ENABLED IS '禁用启用';
COMMENT ON COLUMN obj_bom_designator.IS_DELETED IS '是否删除';
COMMENT ON COLUMN obj_bom_designator.CRT_USER IS '创建人';
COMMENT ON COLUMN obj_bom_designator.CRT_NAME IS '创建人名';
COMMENT ON COLUMN obj_bom_designator.CRT_TIME IS '创建时间';
COMMENT ON COLUMN obj_bom_designator.CRT_HOST IS '创建地址';
CREATE INDEX IDX_OBJ_BOM_DESIGNATOR_BOM_ID ON OBJ_BOM_DESIGNATOR(BOM_ID);
/* 3. 创建bom替代料表*/
DROP TABLE IF EXISTS obj_bom_substitute;
CREATE TABLE obj_bom_substitute(
ID VARCHAR(32) NOT NULL,
BOM_ID VARCHAR(32),
OBJ_ID VARCHAR(32),
OBJ_NUMBER VARCHAR(255),
IS_ENABLED VARCHAR(1),
IS_DELETED VARCHAR(1),
CRT_USER VARCHAR(32),
CRT_NAME VARCHAR(64),
CRT_TIME TIMESTAMP,
CRT_HOST VARCHAR(64),
UPD_USER VARCHAR(32),
UPD_NAME VARCHAR(64),
UPD_TIME TIMESTAMP,
UPD_HOST VARCHAR(64),
PRIMARY KEY (ID)
);
COMMENT ON TABLE obj_bom_substitute IS 'BOM替代料;';
COMMENT ON COLUMN obj_bom_substitute.ID IS '主键';
COMMENT ON COLUMN obj_bom_substitute.BOM_ID IS 'BOMID';
COMMENT ON COLUMN obj_bom_substitute.OBJ_ID IS '替代料ID';
COMMENT ON COLUMN obj_bom_substitute.OBJ_NUMBER IS '替代料编号';
COMMENT ON COLUMN obj_bom_substitute.IS_ENABLED IS '禁用启用';
COMMENT ON COLUMN obj_bom_substitute.IS_DELETED IS '是否删除';
COMMENT ON COLUMN obj_bom_substitute.CRT_USER IS '创建人';
COMMENT ON COLUMN obj_bom_substitute.CRT_NAME IS '创建人名';
COMMENT ON COLUMN obj_bom_substitute.CRT_TIME IS '创建时间';
COMMENT ON COLUMN obj_bom_substitute.CRT_HOST IS '创建地址';
COMMENT ON COLUMN obj_bom_substitute.UPD_USER IS '更新人';
COMMENT ON COLUMN obj_bom_substitute.UPD_NAME IS '更新人名';
COMMENT ON COLUMN obj_bom_substitute.UPD_TIME IS '更新时间';
COMMENT ON COLUMN obj_bom_substitute.UPD_HOST IS '更新地址';
create index IDX_OBJ_BOM_SUBST_BOM_ID on OBJ_BOM_SUBSTITUTE(BOM_ID);
create index IDX_OBJ_BOM_SUBST_OBJ_ID on OBJ_BOM_SUBSTITUTE(OBJ_ID);
create index IDX_OBJ_BOM_SUBST_OBJ_NUMBER on OBJ_BOM_SUBSTITUTE(OBJ_NUMBER);
/* BOM快照表 */
DROP TABLE IF EXISTS OBJ_BOM_SNAPSHOT;
CREATE TABLE OBJ_BOM_SNAPSHOT(
ID VARCHAR(32) NOT NULL,
OBJ_ID VARCHAR(32),
VERSION_ID VARCHAR(32),
BOM_COUNT INTEGER,
SUB_BOM_INFO TEXT,
CRT_USER VARCHAR(32),
CRT_NAME VARCHAR(64),
CRT_TIME TIMESTAMP,
CRT_HOST VARCHAR(64),
PRIMARY KEY (ID)
);
COMMENT ON TABLE OBJ_BOM_SNAPSHOT IS 'BOM版本快照;';
COMMENT ON COLUMN OBJ_BOM_SNAPSHOT.ID IS '主键';
COMMENT ON COLUMN OBJ_BOM_SNAPSHOT.OBJ_ID IS '对象ID';
COMMENT ON COLUMN OBJ_BOM_SNAPSHOT.VERSION_ID IS '版本ID';
COMMENT ON COLUMN OBJ_BOM_SNAPSHOT.BOM_COUNT IS 'BOM数量';
COMMENT ON COLUMN OBJ_BOM_SNAPSHOT.SUB_BOM_INFO IS '子BOM信息json（版本、数量）';
COMMENT ON COLUMN OBJ_BOM_SNAPSHOT.CRT_USER IS '创建人';
COMMENT ON COLUMN OBJ_BOM_SNAPSHOT.CRT_NAME IS '创建人名';
COMMENT ON COLUMN OBJ_BOM_SNAPSHOT.CRT_TIME IS '创建时间';
COMMENT ON COLUMN OBJ_BOM_SNAPSHOT.CRT_HOST IS '创建地址';
/* 创建索引 */
CREATE INDEX idx_OBJ_BOM_SNAPSHOT_obj_id ON OBJ_BOM_SNAPSHOT(OBJ_ID);
CREATE INDEX idx_OBJ_BOM_SNAPSHOT_version_id ON OBJ_BOM_SNAPSHOT(VERSION_ID);
3.2 csb-legox脚本
此处仅为增量脚本，其他的参考
-- ======= 角色表 ==============================
-- 新增是否同步角色字段，控制标准租户端不能操作从租管端同步过来的角色
ALTER TABLE sys_role ADD IS_INNER_SYNC CHAR(1) default '0' NOT NULL;
comment on column SYS_ROLE.IS_INNER_SYNC is '是否租管端同步的角色：0-不是 1-是';
ALTER TABLE CSB.SYS_PAGE_BUTTON ADD APP_ID VARCHAR2(36) NULL;
ALTER TABLE CSB.SYS_PAGE_TAB ADD APP_ID VARCHAR2(36) NULL;
ALTER TABLE CSB.SYS_ROLE_PERMISSION_PORTAL ADD TAB_ID VARCHAR2(36) NULL;
-- 机构关联节点表新增全路径的维护
ALTER TABLE sys_org_relation ADD FULL_ID_PATH varchar(1000);
comment on column sys_org_relation.FULL_ID_PATH is 'relation_id的全路径维护';
ALTER TABLE sys_org_relation
ADD FULL_NAME_PATH varchar(1000) ;
comment on column sys_org_relation.FULL_NAME_PATH is 'org名称的全路径维护';
-- 商务新增的组织扩展字段
ALTER TABLE SYS_ORG_EXT ADD PROVINCE_CODE VARCHAR(100) NULL;
ALTER TABLE SYS_ORG_EXT ADD CITY_CODE VARCHAR(100) NULL;
-- ======= CSB视图，注意是否已经执行过 ==============================
-- CSB视图：新增字段
ALTER TABLE sys_view_datasource ADD datasource_code varchar2(64) NULL;
COMMENT ON COLUMN sys_view_datasource.datasource_code IS '视图主编码';
ALTER TABLE sys_view_datasource ADD sys_database_type varchar2(64) NULL;
COMMENT ON COLUMN sys_view_datasource.sys_database_type IS '数据源类型:表单 数据库';
ALTER TABLE sys_view_datasource ADD biz_id varchar2(32) NULL;
COMMENT ON COLUMN sys_view_datasource.biz_id IS '业务归属来源ID';
ALTER TABLE sys_view_datasource ADD biz_type varchar2(255) NULL;
COMMENT ON COLUMN sys_view_datasource.biz_type IS '业务归属类型';
ALTER TABLE sys_view_datasource ADD app_id varchar2(64) NULL;
COMMENT ON COLUMN sys_view_datasource.app_id IS '应用ID';
ALTER TABLE sys_view_datasource ADD tenant_id varchar2(64) NULL;
COMMENT ON COLUMN sys_view_datasource.tenant_id IS '租户号';
ALTER TABLE sys_view_datasource ADD product_id varchar2(64) NULL;
COMMENT ON COLUMN sys_view_datasource.product_id IS '产品ID';
ALTER TABLE sys_view_condition ADD view_source_id varchar2(36) NULL;
COMMENT ON COLUMN sys_view_condition.view_source_id IS '视图资源ID';
ALTER TABLE sys_view ADD view_type varchar2(128) NULL;
COMMENT ON COLUMN sys_view.view_type IS '视图类型';
ALTER TABLE sys_view ADD user_id varchar2(128) NULL;
COMMENT ON COLUMN sys_view.user_id IS '用户id';4 必要的基础配置数据
- 需要替换dictionary_type中app_id值’c518f53d-b405-4111-afe1-5c082b284971’为自己的
- 需要替换dictionary_item中AppID和systemID
- 需要替换sys_page中AppID和systemID
- 需要替换sys_menu中AppID和systemID
4.0 初始化根级数据字典分类(无执行未创建数据字典才需要执行)
-- ----------------------------
-- delete DICTIONARY_TYPE
-- ----------------------------
DELETE FROM dictionary_type WHERE id in ('250f1ebe-96a0-4462-965e-0a238401ef40','81be2728-b8d9-4787-b577-96cd5d230d56','63dae451-a26b-4325-bf10-221802817884') ;
-- ----------------------------
-- insert DICTIONARY_TYPE
-- ----------------------------
INSERT INTO dictionary_type (id,app_id,parent_id,code,name,description,type,type_name,control_type,control_type_name,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,is_editable,crt_user,crt_name,crt_host,crt_time,upd_user,upd_name,upd_host,upd_time,system_id,sort_no,dict_type,is_tree,sync_interval,sync_time,sync_succeed,app_type,params_json) values ('250f1ebe-96a0-4462-965e-0a238401ef40','c518f53d-b405-4111-afe1-5c082b284971','root','LCP','低代码平台',null,'SYSTEM','系统',null,null,'root',null,null,null,null,null,'0','1','1','dfd37a8ea9394e078d9cb1788549247c','叶端旺','172.29.79.64',TO_DATE('2021-11-23 16:56:44', 'YYYY-MM-DD HH24:MI:SS'),'dfd37a8ea9394e078d9cb1788549247c','叶端旺','172.29.79.64',TO_DATE('2021-11-23 16:56:44', 'YYYY-MM-DD HH24:MI:SS'),'2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58','13','1','0',null,TO_DATE('2021-11-23 16:56:44', 'YYYY-MM-DD HH24:MI:SS'),'0',null,null);
INSERT INTO dictionary_type (id,app_id,parent_id,code,name,description,type,type_name,control_type,control_type_name,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,is_editable,crt_user,crt_name,crt_host,crt_time,upd_user,upd_name,upd_host,upd_time,system_id,sort_no,dict_type,is_tree,sync_interval,sync_time,sync_succeed,app_type,params_json) values ('63dae451-a26b-4325-bf10-221802817884','c518f53d-b405-4111-afe1-5c082b284971','250f1ebe-96a0-4462-965e-0a238401ef40','LCP_FORM_DESGIN','表单设计器',null,'GROUP','分组',null,null,'root#250f1ebe-96a0-4462-965e-0a238401ef40',null,null,null,null,null,'0','1','1','19741bee96044d648f3a4c947399cdf0','袁子涵','172.29.170.192',TO_DATE('2021-11-23 16:56:44', 'YYYY-MM-DD HH24:MI:SS'),'19741bee96044d648f3a4c947399cdf0','袁子涵','172.29.170.192',TO_DATE('2021-11-23 16:56:44', 'YYYY-MM-DD HH24:MI:SS'),'2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58','3','1','0',null,TO_DATE('2021-11-23 16:56:44', 'YYYY-MM-DD HH24:MI:SS'),'0',null,null);
INSERT INTO dictionary_type (id,app_id,parent_id,code,name,description,type,type_name,control_type,control_type_name,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,is_editable,crt_user,crt_name,crt_host,crt_time,upd_user,upd_name,upd_host,upd_time,system_id,sort_no,dict_type,is_tree,sync_interval,sync_time,sync_succeed,app_type,params_json) values ('81be2728-b8d9-4787-b577-96cd5d230d56','c518f53d-b405-4111-afe1-5c082b284971','250f1ebe-96a0-4462-965e-0a238401ef40','LCP_CONF','配置',null,'GROUP','分组',null,null,'root#250f1ebe-96a0-4462-965e-0a238401ef40',null,null,null,null,null,'0','1','1','dfd37a8ea9394e078d9cb1788549247c','叶端旺','172.29.79.64',TO_DATE('2021-11-23 16:56:44', 'YYYY-MM-DD HH24:MI:SS'),'dfd37a8ea9394e078d9cb1788549247c','叶端旺','172.29.79.64',TO_DATE('2021-11-23 16:56:44', 'YYYY-MM-DD HH24:MI:SS'),'2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58','2','1','0',null,TO_DATE('2021-11-23 16:56:44', 'YYYY-MM-DD HH24:MI:SS'),'0',null,null);
-- ----------------------------
-- delete DICTIONARY_ITEM
-- ----------------------------
-- not data to delete, whereSql=id in ()
4.1 数据字典-生命周期-分类-通用是否
/*
CSB通用导出工具
SQL导出时间 : 2023-09-12 10:16:17
*/
-- ----------------------------
-- delete DICTIONARY_TYPE
-- ----------------------------
DELETE FROM dictionary_type WHERE id in ('2260b840-d1de-452a-a39c-e83abdd23c92') ;
-- ----------------------------
-- insert DICTIONARY_TYPE
-- ----------------------------
INSERT INTO dictionary_type (id,app_id,parent_id,code,name,description,type,type_name,control_type,control_type_name,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,is_editable,crt_user,crt_name,crt_host,crt_time,upd_user,upd_name,upd_host,upd_time,system_id,sort_no,dict_type,is_tree,sync_interval,sync_time,sync_succeed,app_type,params_json) values ('2260b840-d1de-452a-a39c-e83abdd23c92','c518f53d-b405-4111-afe1-5c082b284971','81be2728-b8d9-4787-b577-96cd5d230d56','LCP_CONF_CLASS_TAG','分类标签',null,'CODE','代码',null,null,'root#250f1ebe-96a0-4462-965e-0a238401ef40#81be2728-b8d9-4787-b577-96cd5d230d56',null,null,null,null,null,'0','1','1','2c91d20c5615c055015615c550c706f7','陈伟斌','172.29.120.57',TO_DATE('2023-07-12 14:28:36', 'YYYY-MM-DD HH24:MI:SS'),'2c91d20c5615c055015615c550c706f7','陈伟斌','172.29.120.57',TO_DATE('2023-07-12 14:28:36', 'YYYY-MM-DD HH24:MI:SS'),'2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58','9','1','0',null,TO_DATE('2023-07-12 14:28:36', 'YYYY-MM-DD HH24:MI:SS'),'0',null,null);
-- ----------------------------
-- delete DICTIONARY_ITEM
-- ----------------------------
DELETE FROM dictionary_item WHERE id in ( '2977a1b2-0451-48a9-89b7-4bb458a1b43b','a2535ab3-aa02-4b46-9425-a054562d551b','af84d6dc-2e86-4798-80e3-3266511de1bc') ;
-- ----------------------------
-- insert DICTIONARY_ITEM
-- ----------------------------
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('2977a1b2-0451-48a9-89b7-4bb458a1b43b','小分类','LCP_CONF_CLASS_TAG_SMALL','2260b840-d1de-452a-a39c-e83abdd23c92','LCP_CONF_CLASS_TAG','SMALL',null,'3',null,null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c550c706f7','陈伟斌',TO_DATE('2023-07-12 14:29:16', 'YYYY-MM-DD HH24:MI:SS'),'172.29.0.136','2c91d20c5615c055015615c550c706f7','陈伟斌',TO_DATE('2023-07-12 14:29:16', 'YYYY-MM-DD HH24:MI:SS'),'172.29.0.136',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('a2535ab3-aa02-4b46-9425-a054562d551b','大分类','LCP_CONF_CLASS_TAG_BIG','2260b840-d1de-452a-a39c-e83abdd23c92','LCP_CONF_CLASS_TAG','BIG',null,'1',null,null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c550c706f7','陈伟斌',TO_DATE('2023-07-12 14:29:16', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.235','2c91d20c5615c055015615c550c706f7','陈伟斌',TO_DATE('2023-07-12 14:29:16', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.235',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('af84d6dc-2e86-4798-80e3-3266511de1bc','中分类','LCP_CONF_CLASS_TAG_MIDDLE','2260b840-d1de-452a-a39c-e83abdd23c92','LCP_CONF_CLASS_TAG','MIDDLE',null,'2',null,null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c550c706f7','陈伟斌',TO_DATE('2023-07-12 14:29:16', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.57','2c91d20c5615c055015615c550c706f7','陈伟斌',TO_DATE('2023-07-12 14:29:16', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.57',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
/*
CSB通用导出工具
SQL导出时间 : 2023-09-12 11:54:35
*/
-- ----------------------------
-- delete DICTIONARY_TYPE
-- ----------------------------
DELETE FROM dictionary_type WHERE id in ('296f8095-17be-445d-b942-f6cbcd0340fa') ;
-- ----------------------------
-- insert DICTIONARY_TYPE
-- ----------------------------
INSERT INTO dictionary_type (id,app_id,parent_id,code,name,description,type,type_name,control_type,control_type_name,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,is_editable,crt_user,crt_name,crt_host,crt_time,upd_user,upd_name,upd_host,upd_time,system_id,sort_no,dict_type,is_tree,sync_interval,sync_time,sync_succeed,app_type,params_json) values ('296f8095-17be-445d-b942-f6cbcd0340fa','c518f53d-b405-4111-afe1-5c082b284971','81be2728-b8d9-4787-b577-96cd5d230d56','LCP_CONF_YES_NO','通用是否',null,'CODE','代码',null,null,'root#250f1ebe-96a0-4462-965e-0a238401ef40#81be2728-b8d9-4787-b577-96cd5d230d56',null,null,null,null,null,'0','1','1','2c91d20c5615c055015615c550c706f7','陈伟斌','172.29.170.235',TO_DATE('2023-07-12 14:31:31', 'YYYY-MM-DD HH24:MI:SS'),'2c91d20c5615c055015615c550c706f7','陈伟斌','172.29.170.235',TO_DATE('2023-07-12 14:31:31', 'YYYY-MM-DD HH24:MI:SS'),'2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58','10','1','0',null,TO_DATE('2023-07-12 14:31:31', 'YYYY-MM-DD HH24:MI:SS'),'0',null,null);
-- ----------------------------
-- delete DICTIONARY_ITEM
-- ----------------------------
DELETE FROM dictionary_item WHERE id in ( '8d834bde-a47e-4193-becd-ae798563b3e1','83921619-ef6c-4e86-a834-bf752e7caa7c') ;
-- ----------------------------
-- insert DICTIONARY_ITEM
-- ----------------------------
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('83921619-ef6c-4e86-a834-bf752e7caa7c','是','LCP_CONF_YES_NO_1','296f8095-17be-445d-b942-f6cbcd0340fa','LCP_CONF_YES_NO','1',null,'1',null,null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c550c706f7','陈伟斌',TO_DATE('2023-07-12 14:31:56', 'YYYY-MM-DD HH24:MI:SS'),'172.29.175.36','2c91d20c5615c055015615c550c706f7','陈伟斌',TO_DATE('2023-07-12 14:31:56', 'YYYY-MM-DD HH24:MI:SS'),'172.29.175.36',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('8d834bde-a47e-4193-becd-ae798563b3e1','否','LCP_CONF_YES_NO_0','296f8095-17be-445d-b942-f6cbcd0340fa','LCP_CONF_YES_NO','0',null,'2',null,null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c550c706f7','陈伟斌',TO_DATE('2023-07-12 14:31:56', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.235','2c91d20c5615c055015615c550c706f7','陈伟斌',TO_DATE('2023-07-12 14:31:56', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.235',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
/*
CSB通用导出工具
SQL导出时间 : 2023-09-12 17:51:02
*/
-- ----------------------------
-- delete DICTIONARY_TYPE
-- ----------------------------
DELETE FROM dictionary_type WHERE id in ('ff3b188c-39a1-42f1-9ebd-e8318e28d384') ;
-- ----------------------------
-- insert DICTIONARY_TYPE
-- ----------------------------
INSERT INTO dictionary_type (id,app_id,parent_id,code,name,description,type,type_name,control_type,control_type_name,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,is_editable,crt_user,crt_name,crt_host,crt_time,upd_user,upd_name,upd_host,upd_time,system_id,sort_no,dict_type,is_tree,sync_interval,sync_time,sync_succeed,app_type,params_json) values ('ff3b188c-39a1-42f1-9ebd-e8318e28d384','c518f53d-b405-4111-afe1-5c082b284971','81be2728-b8d9-4787-b577-96cd5d230d56','LCP_CONF_LIFECYCLE','生命周期',null,'CODE','代码',null,null,'root#250f1ebe-96a0-4462-965e-0a238401ef40#81be2728-b8d9-4787-b577-96cd5d230d56',null,null,null,null,null,'0','1','1','2c91d20c5615c055015615c550c706f7','陈伟斌','172.29.120.57',TO_DATE('2023-06-29 21:08:38', 'YYYY-MM-DD HH24:MI:SS'),'2c91d20c5615c055015615c550c706f7','陈伟斌','172.29.120.57',TO_DATE('2023-06-29 21:08:38', 'YYYY-MM-DD HH24:MI:SS'),'2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58','6','1','0',null,TO_DATE('2023-06-29 21:08:38', 'YYYY-MM-DD HH24:MI:SS'),'0','LOW_CODE_PLATFORM',null);
-- ----------------------------
-- delete DICTIONARY_ITEM
-- ----------------------------
DELETE FROM dictionary_item WHERE id in ( 'e5230366-0875-41bc-9085-e3206dabd3e2','caf41d15-5863-41de-9bfd-ab261f3872b7','f37da4cb-0c1b-4389-a7c7-6924db73a19f','27d18ab8-3c11-41e0-8d73-5e2e39708d8d','df48c6a3-f28d-4317-8baf-bac1c5b46ac8','1b415807-ce03-47de-a212-942451e7654e','a7fd617e-9554-47da-9dea-c14a95be7782','ce14ff6c-0b36-442d-aa2b-cb824cbdda31','56c1a929-bb95-4de3-a670-0c2f4a5ea31b','6eda8234-e94d-40a7-922e-819ac3a59a53','b8b6d659-6384-4839-8408-256663d42b79','7aefa9e5-fc7a-47a6-a800-11ec61f7a834','2d07101f-90e0-4877-bb82-f878f76d417c','3cdb80c8-355f-4d60-b318-952230d6f3eb','85d7666c-b916-44a2-be85-3d1ae9674d9e','32bb81ba-d09b-40df-a3c3-f6b0afd98637','2d8efd5e-3ce9-4064-8d8b-6794c9553faa','ead45cf3-01bc-46fc-990c-dac33d46b5e2','7f1e1191-8ed7-4ad2-8445-a9be6664d522','e44d6580-b6bd-4f3c-b0fb-61b70cf20f92','2011f680-f1b8-42f0-8b6b-8157827d5628','131d6502-baa7-42d9-8b03-f6d9c54767e1','4c198abc-aeda-489a-9341-c7ed40011032','e0639f39-d55e-45b5-ac55-4f653fe74f79','2dbf1bd9-e173-4f1c-b2cd-cd3cb837e485','4c57eb5e-2fd0-4415-850e-ad4cfdcc0271','f0492f10-ca1d-4340-aa6c-6ab81892b091','865471c0-0cc2-4982-acc4-3904256f9a2a','b38ff980-5944-4fa4-8f4f-d941a9e6ca45','eb4ae4cd-bbd1-478b-a406-fe0fa4646f45','41d64eeb-5c78-4b7a-88e7-592881ab20a1','7daa4d2e-fbfe-4f0b-a790-28f762e5b17b','ff3f221d-62f0-4681-b85b-0134ee5d0f69','b1d3c65e-9e49-4301-b0dd-ae8976d08405','affb6f8d-430d-4f3e-ad80-7f487e351a8d','b13e2080-4b30-4e11-a43d-2db9ad2a59ff','385e76b2-343d-4d83-b926-aebbc91d9379','1830916d-3d05-46ae-93a5-0022673304e1','35480702-343f-4cb8-a861-166d89517f7f','22120d45-e172-4dfb-bee9-784758b445da','af1c3c69-1311-4095-8bd0-decd5985633d','9c1cec09-83fc-4985-9067-754cd10f3e28','cc492acb-f29e-4c8f-924c-9e7b77b1b2fa') ;
-- ----------------------------
-- insert DICTIONARY_ITEM
-- ----------------------------
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('131d6502-baa7-42d9-8b03-f6d9c54767e1','已终止','LCP_CONF_LIFECYCLE_DISCONTINUED','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','Discontinued',null,'32','已终止',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('1830916d-3d05-46ae-93a5-0022673304e1','小批量','LCP_CONF_LIFECYCLE_FINISHEDGOODSPILOT','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','FinishedGoodsPilot',null,'29','小批量',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.175.11','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.175.11',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('2011f680-f1b8-42f0-8b6b-8157827d5628','已退市','LCP_CONF_LIFECYCLE_DELISTED','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','Delisted',null,'31','已退市',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.0.149','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.0.149',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('22120d45-e172-4dfb-bee9-784758b445da','性能样机','LCP_CONF_LIFECYCLE_FUNCTIONALPROTOTYPE','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','FunctionalPrototype',null,'39','性能样机',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.240','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.240',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('2dbf1bd9-e173-4f1c-b2cd-cd3cb837e485','开发','LCP_CONF_LIFECYCLE_DEVELOP','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','DEVELOP',null,'42','开发',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('35480702-343f-4cb8-a861-166d89517f7f','改板','LCP_CONF_LIFECYCLE_REVISION','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','Revision',null,'37','改板',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('385e76b2-343d-4d83-b926-aebbc91d9379','样机','LCP_CONF_LIFECYCLE_SAMPLEPROTOTYPE','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','SamplePrototype',null,'28','样机',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.0.149','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.0.149',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('4c198abc-aeda-489a-9341-c7ed40011032','淘汰中','LCP_CONF_LIFECYCLE_DESELECTING','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','Deselecting',null,'34','淘汰中',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.240','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.240',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('4c57eb5e-2fd0-4415-850e-ad4cfdcc0271','逐步退市','LCP_CONF_LIFECYCLE_DELISTING','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','Delisting',null,'30','逐步退市',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('7daa4d2e-fbfe-4f0b-a790-28f762e5b17b','发布','LCP_CONF_LIFECYCLE_RELEASE','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','RELEASE',null,'5','发布',null,null,null,null,null,null,null,'0','1','2c919611542ca99101542cab44210003','王浩彬',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.235','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.0.149',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('7f1e1191-8ed7-4ad2-8445-a9be6664d522','原型机','LCP_CONF_LIFECYCLE_PROTOTYPE','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','Prototype',null,'38','原型机',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('865471c0-0cc2-4982-acc4-3904256f9a2a','即将作废','LCP_CONF_LIFECYCLE_OBSOLETING','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','Obsoleting',null,'35','即将作废',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.175.11','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.175.11',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('affb6f8d-430d-4f3e-ad80-7f487e351a8d','禁用','LCP_CONF_LIFECYCLE_DISABLE','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','DISABLE',null,'25','禁用',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('b13e2080-4b30-4e11-a43d-2db9ad2a59ff','详设','LCP_CONF_LIFECYCLE_DESIGN','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','Design',null,'27','详设',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.240','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.240',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('b1d3c65e-9e49-4301-b0dd-ae8976d08405','样品','LCP_CONF_LIFECYCLE_SAMPLE','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','SAMPLE',null,'23','样品',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('b38ff980-5944-4fa4-8f4f-d941a9e6ca45','作废','LCP_CONF_LIFECYCLE_INVALID','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','Invalid',null,'40','作废',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.175.11','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.175.11',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('caf41d15-5863-41de-9bfd-ab261f3872b7','初始','LCP_CONF_LIFECYCLE_PRELIMINARY','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','PRELIMINARY',null,'7','初始',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.57','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.0.149',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('cc492acb-f29e-4c8f-924c-9e7b77b1b2fa','量产','LCP_CONF_LIFECYCLE_PRODUCTION','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','Production',null,'1','用于描述量产状态',null,null,null,null,null,null,null,'0','1','2c919611542ca99101542cab44210003','王浩彬',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.235','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.0.149',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('e0639f39-d55e-45b5-ac55-4f653fe74f79','中试','LCP_CONF_LIFECYCLE_MIDDLEPILOT','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','MiddlePilot',null,'36','中试',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('e44d6580-b6bd-4f3c-b0fb-61b70cf20f92','已作废','LCP_CONF_LIFECYCLE_OBSOLETE','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','OBSOLETE',null,'26','已作废',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('ead45cf3-01bc-46fc-990c-dac33d46b5e2','概设','LCP_CONF_LIFECYCLE_CONCEPT','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','CONCEPT',null,'24','概设',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.175.11','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.175.11',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('eb4ae4cd-bbd1-478b-a406-fe0fa4646f45','RFQ','LCP_CONF_LIFECYCLE_RFQ','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','RFQ',null,'41','RFQ',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.0.149','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.0.149',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('f0492f10-ca1d-4340-aa6c-6ab81892b091','试产','LCP_CONF_LIFECYCLE_RAWPILOT','ff3b188c-39a1-42f1-9ebd-e8318e28d384','LCP_CONF_LIFECYCLE','RawPilot',null,'33','试产',null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2023-09-12 17:26:51', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);4.2 数据字典-流程表单状态
/*
CSB通用导出工具
SQL导出时间 : 2023-09-20 16:11:55
*/
-- ----------------------------
-- delete DICTIONARY_TYPE
-- ----------------------------
DELETE FROM dictionary_type WHERE id in ('0c0f5885-2b9e-42df-9237-f6144add6f4f') ;
-- ----------------------------
-- insert DICTIONARY_TYPE
-- ----------------------------
INSERT INTO dictionary_type (id,app_id,parent_id,code,name,description,type,type_name,control_type,control_type_name,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,is_editable,crt_user,crt_name,crt_host,crt_time,upd_user,upd_name,upd_host,upd_time,system_id,sort_no,dict_type,is_tree,sync_interval,sync_time,sync_succeed,app_type,params_json) values ('0c0f5885-2b9e-42df-9237-f6144add6f4f','c518f53d-b405-4111-afe1-5c082b284971','81be2728-b8d9-4787-b577-96cd5d230d56','LCP_CONF_WFSTATUS','流程表单状态',null,'CODE','代码',null,null,'root#250f1ebe-96a0-4462-965e-0a238401ef40#81be2728-b8d9-4787-b577-96cd5d230d56',null,null,null,null,null,'0','1','1','dfd37a8ea9394e078d9cb1788549247c','叶端旺','172.29.79.64',TO_DATE('2021-11-23 16:56:44', 'YYYY-MM-DD HH24:MI:SS'),'dfd37a8ea9394e078d9cb1788549247c','叶端旺','172.29.79.64',TO_DATE('2021-11-23 16:56:44', 'YYYY-MM-DD HH24:MI:SS'),'2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58','1','1','0',null,TO_DATE('2021-11-23 16:56:44', 'YYYY-MM-DD HH24:MI:SS'),'0','LOW_CODE_PLATFORM',null);
-- ----------------------------
-- delete DICTIONARY_ITEM
-- ----------------------------
DELETE FROM dictionary_item WHERE id in ( '030fba31-3b56-46fb-affa-9e90277f141c','64c0bc17-4a2b-49c5-8958-ea18275fdb11','a65d7c8e-56c5-4250-8fcb-eaec05586684','aea231b5-81b9-409e-83c2-17b25e67aed9','ddc62114-cadb-4ecd-b92d-e1d3f359fcfb','b82370be-8dd0-4cce-895f-c30d3135630a','fccff96a-a9be-403b-8cee-791a4e730155','b48ca62b-8576-442c-abda-2045257e6df2') ;
-- ----------------------------
-- insert DICTIONARY_ITEM
-- ----------------------------
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('030fba31-3b56-46fb-affa-9e90277f141c','驳回','LCP_CONF_WFSTATUS_REFUSE','0c0f5885-2b9e-42df-9237-f6144add6f4f','LCP_CONF_WFSTATUS','REFUSE',null,'5',null,null,null,null,null,null,null,null,'1','1','dfd37a8ea9394e078d9cb1788549247c','叶端旺',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.79.64','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.0.149',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('64c0bc17-4a2b-49c5-8958-ea18275fdb11','异常','LCP_CONF_WFSTATUS_ERROR','0c0f5885-2b9e-42df-9237-f6144add6f4f','LCP_CONF_WFSTATUS','ERROR',null,'6',null,null,null,null,null,null,null,null,'0','0','dfd37a8ea9394e078d9cb1788549247c','叶端旺',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.192','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.0.149',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('a65d7c8e-56c5-4250-8fcb-eaec05586684','草稿','LCP_CONF_WFSTATUS_DRAFT','0c0f5885-2b9e-42df-9237-f6144add6f4f','LCP_CONF_WFSTATUS','DRAFT',null,'1',null,null,null,null,null,null,null,null,'0','1','dfd37a8ea9394e078d9cb1788549247c','叶端旺',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.79.64','dfd37a8ea9394e078d9cb1788549247c','叶端旺',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.79.64',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('aea231b5-81b9-409e-83c2-17b25e67aed9','审批中','LCP_CONF_WFSTATUS_SUSPEND','0c0f5885-2b9e-42df-9237-f6144add6f4f','LCP_CONF_WFSTATUS','SUSPEND',null,'2',null,null,null,null,null,null,null,null,'0','1','dfd37a8ea9394e078d9cb1788549247c','叶端旺',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.79.64','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('b48ca62b-8576-442c-abda-2045257e6df2','处理中','LCP_CONF_WFSTATUS_HOLDING','0c0f5885-2b9e-42df-9237-f6144add6f4f','LCP_CONF_WFSTATUS','HOLDING',null,'7',null,null,null,null,null,null,null,null,'0','0','2c91d2385a3f6c81015c216fe5d10121','聂维',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.192','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.240',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('b82370be-8dd0-4cce-895f-c30d3135630a','结束','LCP_CONF_WFSTATUS_FINISH','0c0f5885-2b9e-42df-9237-f6144add6f4f','LCP_CONF_WFSTATUS','FINISH',null,'4',null,null,null,null,null,null,null,null,'0','1','dfd37a8ea9394e078d9cb1788549247c','叶端旺',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.192','dfd37a8ea9394e078d9cb1788549247c','叶端旺',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.192',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('ddc62114-cadb-4ecd-b92d-e1d3f359fcfb','废弃','LCP_CONF_WFSTATUS_DISCARD','0c0f5885-2b9e-42df-9237-f6144add6f4f','LCP_CONF_WFSTATUS','DISCARD',null,'3',null,null,null,null,null,null,null,null,'0','1','dfd37a8ea9394e078d9cb1788549247c','叶端旺',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.192','dfd37a8ea9394e078d9cb1788549247c','叶端旺',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.192',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('fccff96a-a9be-403b-8cee-791a4e730155','初始','LCP_CONF_WFSTATUS_PRELIMINARY','0c0f5885-2b9e-42df-9237-f6144add6f4f','LCP_CONF_WFSTATUS','PRELIMINARY',null,'8',null,null,null,null,null,null,null,null,'1','1','2c91d2385a3f6c81015c216fe5d10121','聂维',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.79.64','2c91d20c5615c055015615c5453b032a','吴碧君',TO_DATE('2021-11-23 17:39:38', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.240',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
4.3 数据字典-是否允许或警告
/*
CSB通用导出工具
SQL导出时间 : 2023-09-14 21:55:03
*/
-- ----------------------------
-- delete DICTIONARY_TYPE
-- ----------------------------
DELETE FROM dictionary_type WHERE id in ('b460827b-4797-4113-bda5-b33296375be1') ;
-- ----------------------------
-- insert DICTIONARY_TYPE
-- ----------------------------
INSERT INTO dictionary_type (id,app_id,parent_id,code,name,description,type,type_name,control_type,control_type_name,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,is_editable,crt_user,crt_name,crt_host,crt_time,upd_user,upd_name,upd_host,upd_time,system_id,sort_no,dict_type,is_tree,sync_interval,sync_time,sync_succeed,app_type,params_json) values ('b460827b-4797-4113-bda5-b33296375be1','c518f53d-b405-4111-afe1-5c082b284971','81be2728-b8d9-4787-b577-96cd5d230d56','LCP_CONF_ALLOW_LEVEL','是否允许或警告',null,'CODE','代码',null,null,'root#250f1ebe-96a0-4462-965e-0a238401ef40#81be2728-b8d9-4787-b577-96cd5d230d56',null,null,null,null,null,'0','1','1','2c91d20c5615c055015615c5483c041a','谭荣华','172.29.0.149',TO_DATE('2023-09-06 18:15:33', 'YYYY-MM-DD HH24:MI:SS'),'2c91d20c5615c055015615c5483c041a','谭荣华','172.29.0.149',TO_DATE('2023-09-06 18:15:33', 'YYYY-MM-DD HH24:MI:SS'),'2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58','11','1','0',null,TO_DATE('2023-09-06 18:15:33', 'YYYY-MM-DD HH24:MI:SS'),'0',null,null);
-- ----------------------------
-- delete DICTIONARY_ITEM
-- ----------------------------
DELETE FROM dictionary_item WHERE id in ( '7b846438-0ea3-493e-9301-16c06655c6cd','6a16ea66-58ca-45a9-82d6-34295681fc6b','eecf2c6b-236a-4882-b678-7e84e94fffab') ;
-- ----------------------------
-- insert DICTIONARY_ITEM
-- ----------------------------
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('6a16ea66-58ca-45a9-82d6-34295681fc6b','不允许','LCP_CONF_ALLOW_LEVEL_2','b460827b-4797-4113-bda5-b33296375be1','LCP_CONF_ALLOW_LEVEL','2',null,'2',null,null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5483c041a','谭荣华',TO_DATE('2023-09-06 18:17:28', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22','2c91d20c5615c055015615c5483c041a','谭荣华',TO_DATE('2023-09-06 18:17:28', 'YYYY-MM-DD HH24:MI:SS'),'172.29.120.22',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('7b846438-0ea3-493e-9301-16c06655c6cd','允许','LCP_CONF_ALLOW_LEVEL_1','b460827b-4797-4113-bda5-b33296375be1','LCP_CONF_ALLOW_LEVEL','1',null,'1',null,null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5483c041a','谭荣华',TO_DATE('2023-09-06 18:17:28', 'YYYY-MM-DD HH24:MI:SS'),'172.29.0.149','2c91d20c5615c055015615c5483c041a','谭荣华',TO_DATE('2023-09-06 18:17:28', 'YYYY-MM-DD HH24:MI:SS'),'172.29.0.149',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
INSERT INTO dictionary_item (id,name,code,dictionary_type_id,dictionary_type_code,item_value,is_default,sort_no,description,item_parent_id,hierarchy_id,attribute1,attribute2,attribute3,attribute4,attribute5,is_deleted,is_enabled,crt_user,crt_name,crt_time,crt_host,upd_user,upd_name,upd_time,upd_host,org_code,app_id,system_id,newest) values ('eecf2c6b-236a-4882-b678-7e84e94fffab','警告','LCP_CONF_ALLOW_LEVEL_3','b460827b-4797-4113-bda5-b33296375be1','LCP_CONF_ALLOW_LEVEL','3',null,'3',null,null,null,null,null,null,null,null,'0','1','2c91d20c5615c055015615c5483c041a','谭荣华',TO_DATE('2023-09-06 18:17:28', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.240','2c91d20c5615c055015615c5483c041a','谭荣华',TO_DATE('2023-09-06 18:17:28', 'YYYY-MM-DD HH24:MI:SS'),'172.29.170.240',null,'c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58',null);
4.4 菜单配置
需要在csb-legox上增加菜单配置
4.4.1 示例截图
4.4.2 SQL示例
/*
CSB通用导出工具
SQL导出时间 : 2023-09-21 14:46:04
*/
-- ----------------------------
-- delete SYS_PAGE
-- ----------------------------
DELETE FROM sys_page WHERE ID IN ('423a66820f0749c68699fb2645021ba9') ;
-- ----------------------------
-- insert SYS_PAGE
-- ----------------------------
INSERT INTO sys_page (id,app_id,system_id,page_code,parent_id,page_name,page_icon,page_level,page_type,da_type,page_url,is_group_manage,is_view_config,is_open_da,da_resourcr_code,charge_mission_relation,remark,sort_no,is_enabled,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,crt_user,crt_name,crt_host,crt_time,upd_user,upd_name,upd_host,upd_time,version,view_datasource_id,resource_id,comp_type,src_app,src_key) values ('423a66820f0749c68699fb2645021ba9','c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58','bsm_sys_config_base_version','be644ca43cf64110a9d1b4ae5b09a179','版本配置管理','calendar',null,'2','1',null,'0','0','0',null,null,null,'2348','1','1','0','modules/FormTemplate/Resource',null,null,'tenantId=c518f53d-b405-4111-afe1-5c082b284971&appId=1269620726624013b98cf4baadaa759f&resourceName=lcp-data-object&resourceVersion=latest&exposeName=VersionRuleManage','2c919611542ca99101542cab44210003','王浩彬','172.29.0.136',TO_DATE('2023-07-04 17:50:56', 'YYYY-MM-DD HH24:MI:SS'),'2c919611542ca99101542cab44210003','王浩彬','172.29.120.57',TO_DATE('2023-07-04 17:50:56', 'YYYY-MM-DD HH24:MI:SS'),null,null,null,null,null,null);
-- ----------------------------
-- delete SYS_MENU
-- ----------------------------
DELETE FROM sys_menu WHERE PAGE_ID IN ('423a66820f0749c68699fb2645021ba9') ;
-- ----------------------------
-- insert SYS_MENU
-- ----------------------------
INSERT INTO sys_menu (id,app_id,system_id,parent_id,menu_type,menu_name,page_id,open_type,is_auto_add,is_enabled,remark,sort_no,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,crt_user,crt_name,crt_host,crt_time,upd_user,upd_name,upd_host,upd_time,version) values ('423a66820f0749c68699fb2645021ba9','c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58','34f4b04212624c43b36173693f54eb40','menu','版本配置管理','423a66820f0749c68699fb2645021ba9','normal','1','1',null,'3330',null,null,null,null,null,null,'2c919611542ca99101542cab44210003','王浩彬','172.29.0.136',TO_DATE('2023-07-04 17:50:56', 'YYYY-MM-DD HH24:MI:SS'),'2c919611542ca99101542cab44210003','王浩彬','172.29.0.136',TO_DATE('2023-07-04 17:50:56', 'YYYY-MM-DD HH24:MI:SS'),null);
-- ----------------------------
-- delete SYS_PAGE_TAB
-- ----------------------------
DELETE FROM sys_page_tab WHERE PAGE_ID IN ('423a66820f0749c68699fb2645021ba9') ;
-- ----------------------------
-- delete SYS_PAGE_BUTTON
-- ----------------------------
DELETE FROM sys_page_button WHERE PAGE_ID IN ('423a66820f0749c68699fb2645021ba9') ;
/*
CSB通用导出工具
SQL导出时间 : 2023-09-21 14:46:42
*/
-- ----------------------------
-- delete SYS_PAGE
-- ----------------------------
DELETE FROM sys_page WHERE ID IN ('27693cadb101416c8c588e00784d64a8') ;
-- ----------------------------
-- insert SYS_PAGE
-- ----------------------------
INSERT INTO sys_page (id,app_id,system_id,page_code,parent_id,page_name,page_icon,page_level,page_type,da_type,page_url,is_group_manage,is_view_config,is_open_da,da_resourcr_code,charge_mission_relation,remark,sort_no,is_enabled,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,crt_user,crt_name,crt_host,crt_time,upd_user,upd_name,upd_host,upd_time,version,view_datasource_id,resource_id,comp_type,src_app,src_key) values ('27693cadb101416c8c588e00784d64a8','c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58','bsm_sys_config_lifecycle','be644ca43cf64110a9d1b4ae5b09a179','生命周期配置管理','align-left',null,'2','1',null,'0','0','0',null,null,null,'2347','1','1','0','modules/FormTemplate/Resource','id',null,'tenantId=c518f53d-b405-4111-afe1-5c082b284971&appId=1269620726624013b98cf4baadaa759f&resourceName=lcp-data-object&resourceVersion=latest&exposeName=LifecycleManage','2c919611542ca99101542cab44210003','王浩彬','172.29.0.136',TO_DATE('2023-07-04 17:27:09', 'YYYY-MM-DD HH24:MI:SS'),'2c919611542ca99101542cab44210003','王浩彬','172.29.175.36',TO_DATE('2023-07-04 17:27:09', 'YYYY-MM-DD HH24:MI:SS'),null,null,null,null,null,null);
-- ----------------------------
-- delete SYS_MENU
-- ----------------------------
DELETE FROM sys_menu WHERE PAGE_ID IN ('27693cadb101416c8c588e00784d64a8') ;
-- ----------------------------
-- insert SYS_MENU
-- ----------------------------
INSERT INTO sys_menu (id,app_id,system_id,parent_id,menu_type,menu_name,page_id,open_type,is_auto_add,is_enabled,remark,sort_no,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,crt_user,crt_name,crt_host,crt_time,upd_user,upd_name,upd_host,upd_time,version) values ('27693cadb101416c8c588e00784d64a8','c518f53d-b405-4111-afe1-5c082b284971','2a1fe9c4-4f65-419c-bd4e-3aa18d3b6e58','34f4b04212624c43b36173693f54eb40','menu','生命周期配置管理','27693cadb101416c8c588e00784d64a8','normal','1','1',null,'3329',null,null,null,null,null,null,'2c919611542ca99101542cab44210003','王浩彬','172.29.0.136',TO_DATE('2023-07-04 17:27:09', 'YYYY-MM-DD HH24:MI:SS'),'2c919611542ca99101542cab44210003','王浩彬','172.29.170.235',TO_DATE('2023-07-04 17:27:09', 'YYYY-MM-DD HH24:MI:SS'),null);
-- ----------------------------
-- delete SYS_PAGE_TAB
-- ----------------------------
DELETE FROM sys_page_tab WHERE PAGE_ID IN ('27693cadb101416c8c588e00784d64a8') ;
-- ----------------------------
-- delete SYS_PAGE_BUTTON
-- ----------------------------
DELETE FROM sys_page_button WHERE PAGE_ID IN ('27693cadb101416c8c588e00784d64a8') ;
5 应用同步初始化
5.1 平台配置应用同步
需要找【黄泽彬】进行操作处理，将平台配置应用数据同步处理到对应系统
| 功能模块 | 名称 | 负责人 |
|---|---|---|
| 平台配置应用 | 菜单、配置数据和业务数据 | 黄泽彬 |
| 系统管理应用 | 菜单、配置数据和业务数据 | 黄泽彬 |
| 应用中心 | 内置产品、分类、应用和内置应用菜单 | 黄泽彬 |
| 业务应用 | 产品数据管理应用 注意确认数据源是业务数据库非配置库 | 黄泽彬 |
5.2 PLM应用初始化
需要找【陈树添】执行
| 功能模块 | 名称 | 负责人 |
|---|---|---|
| PLM应用 | 应用初始化 | 陈树添 |
| legox基础数据 | 流水号、数据字典初始化 | 聂维 |
作者：聂维 创建时间：2023-10-11 10:22
最后编辑：王浩彬 更新时间：2024-12-11 10:09
最后编辑：王浩彬 更新时间：2024-12-11 10:09
