ERP-Table结构

-- ryvue_mes.ap_message definition

CREATE TABLE `ap_message` (
  `message_id` bigint(20) DEFAULT NULL COMMENT '消息ID',
  `message_module` varchar(100) DEFAULT NULL COMMENT '消息应用模块',
  `message_type` varchar(100) NOT NULL COMMENT '消息类型1为info,2为warn3为error',
  `message_code` varchar(100) DEFAULT NULL COMMENT '消息编码',
  `message_content` varchar(100) DEFAULT NULL,
  `message_title` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='应用程序的信息(info,warn,error)';

-- ryvue_mes.ap_message definition

CREATE TABLE `ap_message` (
  `message_id` bigint(20) NOT NULL COMMENT '消息ID',
  `message_module` varchar(100) DEFAULT NULL COMMENT '消息应用模块',
  `message_language` varchar(100) DEFAULT NULL COMMENT 'message语言',
  `message_type` varchar(100) NOT NULL COMMENT '消息类型i为info,w为warn,e为error',
  `message_code` varchar(100) DEFAULT NULL COMMENT '消息编码',
  `message_title` varchar(255) DEFAULT NULL,
  `message_content` varchar(100) DEFAULT NULL,
  `create_by` varchar(100) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `update_by` varchar(100) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `remark` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`message_id`),
  UNIQUE KEY `ap_message_unique` (`message_code`,`message_language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='应用程序的信息(info,warn,error)';

-- ryvue_mes.gen_table_column definition

CREATE TABLE `ap_data_dict` (
  `column_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `table_id` varchar(64) DEFAULT NULL COMMENT '归属表编号',
  `table_name` varchar(64) DEFAULT NULL COMMENT '归属表编号',
  `column_name` varchar(200) DEFAULT NULL COMMENT '列名称',
  `column_comment` varchar(500) DEFAULT NULL COMMENT '列描述',
  `column_type` varchar(100) DEFAULT NULL COMMENT '列类型',
  `dict_type` varchar(200) DEFAULT '' COMMENT '字典类型',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(64) DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`column_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='应用数据字典';

ALTER TABLE ryvue_mes.out_workorder ADD sync_id varchar(100) NULL COMMENT '同步ID(接名名称或AP名行或JOB名称等）';
ALTER TABLE ryvue_mes.out_workorder ADD sync_status INT NULL COMMENT '同步状态(0成功1失败2执行3重传）';
ALTER TABLE ryvue_mes.out_workorder ADD sync_time DATETIME NULL COMMENT '同步完成时间';
ALTER TABLE ryvue_mes.out_workorder ADD sync_qty INT NULL COMMENT '同步记录数';
ALTER TABLE ryvue_mes.out_workorder ADD sync_message varchar(100) NULL COMMENT '同步消息';

INSERT INTO `tony-flowable-24`.act_ge_property (NAME_,VALUE_,REV_) VALUES
	 ('batch.schema.version','6.8.0.0',1),
	 ('cfg.execution-related-entities-count','true',1),
	 ('cfg.task-related-entities-count','true',1),
	 ('common.schema.version','6.8.0.0',1),
	 ('entitylink.schema.version','6.8.0.0',1),
	 ('eventsubscription.schema.version','6.8.0.0',1),
	 ('identitylink.schema.version','6.8.0.0',1),
	 ('job.schema.version','6.8.0.0',1),
	 ('next.dbid','1',1),
	 ('schema.history','create(6.8.0.0)',1);
INSERT INTO `tony-flowable-24`.act_ge_property (NAME_,VALUE_,REV_) VALUES
	 ('schema.version','6.8.0.0',1),
	 ('task.schema.version','6.8.0.0',1),
	 ('variable.schema.version','6.8.0.0',1);

https://mp.weixin.qq.com/s?__biz=MzAxMjY5NDU2Ng==&mid=2651869855&idx=1&sn=d81c78481d15a5b7a7386ad83eedecd9&chksm=81e26fcca929c11ba6d9affdb5aed015d35f067fdde339feea987557e849745ac46f5a34bfde&scene=27