CREATE TABLE sys_user ( id bigint NOT NULL, username varchar(50) NOT NULL, password varchar(100), real_name varchar(50), head_url varchar(200), gender int, email varchar(100), mobile varchar(100), dept_id bigint, super_admin int, status int, creator bigint, create_date datetime, updater bigint, update_date datetime, primary key (id) ); CREATE UNIQUE INDEX uk_sys_user_username on sys_user(username); CREATE INDEX idx_sys_user_create_date on sys_user(create_date); COMMENT ON TABLE sys_user IS '用户管理'; COMMENT ON COLUMN sys_user.id IS 'id'; COMMENT ON COLUMN sys_user.username IS '用户名'; COMMENT ON COLUMN sys_user.password IS '密码'; COMMENT ON COLUMN sys_user.real_name IS '姓名'; COMMENT ON COLUMN sys_user.head_url IS '头像'; COMMENT ON COLUMN sys_user.gender IS '性别 0：男 1：女 2：保密'; COMMENT ON COLUMN sys_user.email IS '邮箱'; COMMENT ON COLUMN sys_user.mobile IS '手机号'; COMMENT ON COLUMN sys_user.dept_id IS '部门ID'; COMMENT ON COLUMN sys_user.super_admin IS '超级管理员 0：否 1：是'; COMMENT ON COLUMN sys_user.status IS '状态 0：停用 1：正常'; COMMENT ON COLUMN sys_user.creator IS '创建者'; COMMENT ON COLUMN sys_user.create_date IS '创建时间'; COMMENT ON COLUMN sys_user.updater IS '更新者'; COMMENT ON COLUMN sys_user.update_date IS '更新时间'; CREATE TABLE sys_dept ( id bigint NOT NULL, pid bigint, pids varchar(500), name varchar(50), leader_id bigint, sort int, creator bigint, create_date datetime, updater bigint, update_date datetime, primary key (id) ); CREATE INDEX idx_sys_dept_pid on sys_dept(pid); CREATE INDEX idx_sys_dept_idx_sort on sys_dept(sort); COMMENT ON TABLE sys_dept IS '部门管理'; COMMENT ON COLUMN sys_dept.id IS 'id'; COMMENT ON COLUMN sys_dept.pid IS '上级ID'; COMMENT ON COLUMN sys_dept.pids IS '所有上级ID，用逗号分开'; COMMENT ON COLUMN sys_dept.name IS '部门名称'; COMMENT ON COLUMN sys_dept.sort IS '排序'; COMMENT ON COLUMN sys_dept.creator IS '创建者'; COMMENT ON COLUMN sys_dept.create_date IS '创建时间'; COMMENT ON COLUMN sys_dept.updater IS '更新者'; COMMENT ON COLUMN sys_dept.update_date IS '更新时间'; create table sys_role ( id bigint NOT NULL, name varchar(50), remark varchar(100), dept_id bigint, creator bigint, create_date datetime, updater bigint, update_date datetime, primary key (id) ); CREATE INDEX idx_sys_role_dept_id on sys_role(dept_id); COMMENT ON TABLE sys_role IS '角色管理'; COMMENT ON COLUMN sys_role.id IS 'id'; COMMENT ON COLUMN sys_role.name IS '角色名称'; COMMENT ON COLUMN sys_role.remark IS '备注'; COMMENT ON COLUMN sys_role.dept_id IS '部门ID'; COMMENT ON COLUMN sys_role.creator IS '创建者'; COMMENT ON COLUMN sys_role.create_date IS '创建时间'; COMMENT ON COLUMN sys_role.updater IS '更新者'; COMMENT ON COLUMN sys_role.update_date IS '更新时间'; create table sys_menu ( id bigint NOT NULL, pid bigint, url varchar(200), permissions varchar(500), menu_type int, open_style int, icon varchar(50), sort int, creator bigint, create_date datetime, updater bigint, update_date datetime, primary key (id) ); CREATE INDEX idx_sys_menu_pid on sys_menu(pid); CREATE INDEX idx_sys_menu_sort on sys_menu(sort); COMMENT ON TABLE sys_menu IS '菜单管理'; COMMENT ON COLUMN sys_menu.id IS 'id'; COMMENT ON COLUMN sys_menu.pid IS '上级ID，一级菜单为0'; COMMENT ON COLUMN sys_menu.url IS '菜单URL'; COMMENT ON COLUMN sys_menu.permissions IS '授权(多个用逗号分隔，如：sys:user:list,sys:user:save)'; COMMENT ON COLUMN sys_menu.menu_type IS '类型 0：菜单 1：按钮'; COMMENT ON COLUMN sys_menu.open_style IS '打开方式 0：内部 1：外部'; COMMENT ON COLUMN sys_menu.icon IS '菜单图标'; COMMENT ON COLUMN sys_menu.sort IS '排序'; COMMENT ON COLUMN sys_menu.creator IS '创建者'; COMMENT ON COLUMN sys_menu.create_date IS '创建时间'; COMMENT ON COLUMN sys_menu.updater IS '更新者'; COMMENT ON COLUMN sys_menu.update_date IS '更新时间'; create table sys_role_user ( id bigint NOT NULL, role_id bigint, user_id bigint, creator bigint, create_date datetime, primary key (id) ); CREATE INDEX idx_sys_role_user_role_id on sys_role_user(role_id); CREATE INDEX idx_sys_role_user_user_id on sys_role_user(user_id); COMMENT ON TABLE sys_role_user IS '角色用户关系'; COMMENT ON COLUMN sys_role_user.role_id IS '角色ID'; COMMENT ON COLUMN sys_role_user.user_id IS '用户ID'; COMMENT ON COLUMN sys_role_user.creator IS '创建者'; COMMENT ON COLUMN sys_role_user.create_date IS '创建时间'; create table sys_role_menu ( id bigint NOT NULL, role_id bigint, menu_id bigint, creator bigint, create_date datetime, primary key (id) ); CREATE INDEX idx_sys_role_menu_role_id on sys_role_menu(role_id); CREATE INDEX idx_sys_role_menu_menu_id on sys_role_menu(menu_id); COMMENT ON TABLE sys_role_menu IS '角色菜单关系'; COMMENT ON COLUMN sys_role_menu.role_id IS '角色ID'; COMMENT ON COLUMN sys_role_menu.menu_id IS '菜单ID'; COMMENT ON COLUMN sys_role_menu.creator IS '创建者'; COMMENT ON COLUMN sys_role_menu.create_date IS '创建时间'; create table sys_role_data_scope ( id bigint NOT NULL, role_id bigint, dept_id bigint, creator bigint, create_date datetime, primary key (id) ); CREATE INDEX idx_data_scope_role_id on sys_role_data_scope(role_id); COMMENT ON TABLE sys_role_data_scope IS '角色数据权限'; COMMENT ON COLUMN sys_role_data_scope.role_id IS '角色ID'; COMMENT ON COLUMN sys_role_data_scope.dept_id IS '部门ID'; COMMENT ON COLUMN sys_role_data_scope.creator IS '创建者'; COMMENT ON COLUMN sys_role_data_scope.create_date IS '创建时间'; create table sys_params ( id bigint NOT NULL, param_code varchar(32), param_value varchar(2000), param_type int DEFAULT 1 NOT NULL, remark varchar(200), creator bigint, create_date datetime, updater bigint, update_date datetime, primary key (id) ); CREATE UNIQUE INDEX uk_sys_params_param_code on sys_params(param_code); CREATE INDEX idx_sys_params_create_date on sys_params(create_date); COMMENT ON TABLE sys_params IS '参数管理'; COMMENT ON COLUMN sys_params.param_code IS '参数编码'; COMMENT ON COLUMN sys_params.param_value IS '参数值'; COMMENT ON COLUMN sys_params.param_type IS '类型 0：系统参数 1：非系统参数'; COMMENT ON COLUMN sys_params.remark IS '备注'; COMMENT ON COLUMN sys_params.creator IS '创建者'; COMMENT ON COLUMN sys_params.create_date IS '创建时间'; COMMENT ON COLUMN sys_params.updater IS '更新者'; COMMENT ON COLUMN sys_params.update_date IS '更新时间'; create table sys_dict_type ( id bigint NOT NULL, dict_type varchar(100), dict_name varchar(255), remark varchar(255), sort int, creator bigint, create_date datetime, updater bigint, update_date datetime, primary key (id) ); CREATE UNIQUE INDEX uk_sys_dict_type_dict_type on sys_dict_type(dict_type); COMMENT ON TABLE sys_dict_type IS '字典类型'; COMMENT ON COLUMN sys_dict_type.id IS 'id'; COMMENT ON COLUMN sys_dict_type.dict_type IS '字典类型'; COMMENT ON COLUMN sys_dict_type.dict_name IS '字典名称'; COMMENT ON COLUMN sys_dict_type.remark IS '备注'; COMMENT ON COLUMN sys_dict_type.sort IS '排序'; COMMENT ON COLUMN sys_dict_type.creator IS '创建者'; COMMENT ON COLUMN sys_dict_type.create_date IS '创建时间'; COMMENT ON COLUMN sys_dict_type.updater IS '更新者'; COMMENT ON COLUMN sys_dict_type.update_date IS '更新时间'; create table sys_dict_data ( id bigint NOT NULL, dict_type_id bigint NOT NULL, dict_label varchar(255), dict_value varchar(255), remark varchar(255), sort int, creator bigint, create_date datetime, updater bigint, update_date datetime, primary key (id) ); CREATE INDEX idx_sys_dict_data_sort on sys_dict_data(sort); CREATE UNIQUE INDEX uk_dict_type_value on sys_dict_data(dict_type_id, dict_value); COMMENT ON TABLE sys_dict_data IS '字典数据'; COMMENT ON COLUMN sys_dict_data.id IS 'id'; COMMENT ON COLUMN sys_dict_data.dict_type_id IS '字典类型ID'; COMMENT ON COLUMN sys_dict_data.dict_label IS '字典标签'; COMMENT ON COLUMN sys_dict_data.dict_value IS '字典值'; COMMENT ON COLUMN sys_dict_data.remark IS '备注'; COMMENT ON COLUMN sys_dict_data.sort IS '排序'; COMMENT ON COLUMN sys_dict_data.creator IS '创建者'; COMMENT ON COLUMN sys_dict_data.create_date IS '创建时间'; COMMENT ON COLUMN sys_dict_data.updater IS '更新者'; COMMENT ON COLUMN sys_dict_data.update_date IS '更新时间'; create table sys_log_login ( id bigint NOT NULL, operation int, status int, user_agent varchar(500), ip varchar(32), creator_name varchar(50), creator bigint, create_date datetime, primary key (id) ); CREATE INDEX idx_login_status on sys_log_login(status); CREATE INDEX idx_login_create_date on sys_log_login(create_date); COMMENT ON TABLE sys_log_login IS '登录日志'; COMMENT ON COLUMN sys_log_login.id IS 'id'; COMMENT ON COLUMN sys_log_login.operation IS '用户操作 0：用户登录 1：用户退出'; COMMENT ON COLUMN sys_log_login.status IS '状态 0：失败 1：成功 2：账号已锁定'; COMMENT ON COLUMN sys_log_login.user_agent IS '用户代理'; COMMENT ON COLUMN sys_log_login.ip IS '操作IP'; COMMENT ON COLUMN sys_log_login.creator_name IS '用户名'; COMMENT ON COLUMN sys_log_login.creator IS '创建者'; COMMENT ON COLUMN sys_log_login.create_date IS '创建时间'; create table sys_log_operation ( id bigint NOT NULL, operation varchar(50), request_uri varchar(200), request_method varchar(20), request_params text, request_time int, user_agent varchar(500), ip varchar(32), status int, creator_name varchar(50), creator bigint, create_date datetime, primary key (id) ); CREATE INDEX idx_operation_create_date on sys_log_operation(create_date); COMMENT ON TABLE sys_log_operation IS '操作日志'; COMMENT ON COLUMN sys_log_operation.id IS 'id'; COMMENT ON COLUMN sys_log_operation.operation IS '用户操作'; COMMENT ON COLUMN sys_log_operation.request_uri IS '请求URI'; COMMENT ON COLUMN sys_log_operation.request_method IS '请求方式'; COMMENT ON COLUMN sys_log_operation.request_params IS '请求参数'; COMMENT ON COLUMN sys_log_operation.request_time IS '请求时长(毫秒)'; COMMENT ON COLUMN sys_log_operation.user_agent IS '用户代理'; COMMENT ON COLUMN sys_log_operation.ip IS '操作IP'; COMMENT ON COLUMN sys_log_operation.status IS '状态 0：失败 1：成功'; COMMENT ON COLUMN sys_log_operation.creator_name IS '用户名'; COMMENT ON COLUMN sys_log_operation.creator IS '创建者'; COMMENT ON COLUMN sys_log_operation.create_date IS '创建时间'; create table sys_log_error ( id bigint NOT NULL, request_uri varchar(200), request_method varchar(20), request_params text, user_agent varchar(500), ip varchar(32), error_info text, creator bigint, create_date datetime, primary key (id) ); CREATE INDEX idx_error_create_date on sys_log_error(create_date); COMMENT ON TABLE sys_log_error IS '异常日志'; COMMENT ON COLUMN sys_log_error.id IS 'id'; COMMENT ON COLUMN sys_log_error.request_uri IS '请求URI'; COMMENT ON COLUMN sys_log_error.request_method IS '请求方式'; COMMENT ON COLUMN sys_log_error.request_params IS '请求参数'; COMMENT ON COLUMN sys_log_error.user_agent IS '用户代理'; COMMENT ON COLUMN sys_log_error.ip IS '操作IP'; COMMENT ON COLUMN sys_log_error.error_info IS '异常信息'; COMMENT ON COLUMN sys_log_error.creator IS '创建者'; COMMENT ON COLUMN sys_log_error.create_date IS '创建时间'; create table sys_sms ( id bigint NOT NULL, sms_code varchar(32), platform int, sms_config varchar(2000), remark varchar(200), creator bigint, create_date datetime, updater bigint, update_date datetime, primary key (id) ); CREATE UNIQUE INDEX uk_sms_code on sys_sms(sms_code); CREATE INDEX idx_sys_sms_create_date on sys_sms(create_date); COMMENT ON TABLE sys_sms IS '短信'; COMMENT ON COLUMN sys_sms.id IS 'id'; COMMENT ON COLUMN sys_sms.sms_code IS '短信编码'; COMMENT ON COLUMN sys_sms.platform IS '平台类型'; COMMENT ON COLUMN sys_sms.sms_config IS '短信配置'; COMMENT ON COLUMN sys_sms.remark IS '备注'; COMMENT ON COLUMN sys_sms.creator IS '创建者'; COMMENT ON COLUMN sys_sms.create_date IS '创建时间'; COMMENT ON COLUMN sys_sms.updater IS '更新者'; COMMENT ON COLUMN sys_sms.update_date IS '更新时间'; CREATE TABLE sys_sms_log ( id bigint NOT NULL, sms_code varchar(32), platform int, mobile varchar(20), params_1 varchar(50), params_2 varchar(50), params_3 varchar(50), params_4 varchar(50), status int, creator bigint, create_date datetime, PRIMARY KEY (id) ); CREATE INDEX idx_sys_sms_log_sms_code on sys_sms_log(sms_code); COMMENT ON TABLE sys_sms_log IS '短信发送记录'; COMMENT ON COLUMN sys_sms_log.id IS 'id'; COMMENT ON COLUMN sys_sms_log.sms_code IS '短信编码'; COMMENT ON COLUMN sys_sms_log.platform IS '平台类型'; COMMENT ON COLUMN sys_sms_log.mobile IS '手机号'; COMMENT ON COLUMN sys_sms_log.params_1 IS '参数1'; COMMENT ON COLUMN sys_sms_log.params_2 IS '参数2'; COMMENT ON COLUMN sys_sms_log.params_3 IS '参数3'; COMMENT ON COLUMN sys_sms_log.params_4 IS '参数4'; COMMENT ON COLUMN sys_sms_log.status IS '发送状态 0：失败 1：成功'; COMMENT ON COLUMN sys_sms_log.creator IS '创建者'; COMMENT ON COLUMN sys_sms_log.create_date IS '创建时间'; CREATE TABLE sys_notice ( id bigint NOT NULL, notice_type int NOT NULL, title varchar(200), content text, receiver_type int, receiver_type_ids varchar(500), status int, sender_name varchar(50), sender_date datetime, creator bigint, create_date datetime, PRIMARY KEY (id) ); CREATE INDEX idx_sys_notice_create_date on sys_notice(create_date); COMMENT ON TABLE sys_notice IS '通知管理'; COMMENT ON COLUMN sys_notice.id IS 'id'; COMMENT ON COLUMN sys_notice.notice_type IS '通知类型'; COMMENT ON COLUMN sys_notice.title IS '标题'; COMMENT ON COLUMN sys_notice.content IS '内容'; COMMENT ON COLUMN sys_notice.receiver_type IS '接收者 0：全部 1：部门'; COMMENT ON COLUMN sys_notice.receiver_type_ids IS '接收者ID，用逗号分开'; COMMENT ON COLUMN sys_notice.status IS '发送状态 0：草稿 1：已发布'; COMMENT ON COLUMN sys_notice.sender_name IS '发送者'; COMMENT ON COLUMN sys_notice.sender_date IS '发送时间'; COMMENT ON COLUMN sys_notice.creator IS '创建者'; COMMENT ON COLUMN sys_notice.create_date IS '创建时间'; CREATE TABLE sys_notice_user ( receiver_id bigint NOT NULL, notice_id bigint NOT NULL, read_status int NOT NULL, read_date datetime, PRIMARY KEY (receiver_id, notice_id) ); COMMENT ON TABLE sys_notice_user IS '我的通知'; COMMENT ON COLUMN sys_notice_user.receiver_id IS '接收者ID'; COMMENT ON COLUMN sys_notice_user.notice_id IS '通知ID'; COMMENT ON COLUMN sys_notice_user.read_status IS '阅读状态 0：未读 1：已读'; COMMENT ON COLUMN sys_notice_user.read_date IS '阅读时间'; CREATE TABLE sys_mail_template ( id bigint NOT NULL, name varchar(100), subject varchar(200), content text, creator bigint, create_date datetime, updater bigint, update_date datetime, PRIMARY KEY (id) ); CREATE INDEX idx_mail_template_create_date on sys_mail_template(create_date); COMMENT ON TABLE sys_mail_template IS '邮件模板'; COMMENT ON COLUMN sys_mail_template.id IS 'id'; COMMENT ON COLUMN sys_mail_template.name IS '模板名称'; COMMENT ON COLUMN sys_mail_template.subject IS '邮件主题'; COMMENT ON COLUMN sys_mail_template.content IS '邮件正文'; COMMENT ON COLUMN sys_mail_template.creator IS '创建者'; COMMENT ON COLUMN sys_mail_template.create_date IS '创建时间'; COMMENT ON COLUMN sys_mail_template.updater IS '更新者'; COMMENT ON COLUMN sys_mail_template.update_date IS '更新时间'; CREATE TABLE sys_mail_log ( id bigint NOT NULL, template_id bigint NOT NULL, mail_from varchar(200), mail_to varchar(400), mail_cc varchar(400), subject varchar(200), content text, status int, creator bigint, create_date datetime, PRIMARY KEY (id) ); CREATE INDEX idx_mail_log_create_date on sys_mail_log(create_date); COMMENT ON TABLE sys_mail_log IS '邮件发送记录'; COMMENT ON COLUMN sys_mail_log.id IS 'id'; COMMENT ON COLUMN sys_mail_log.template_id IS '邮件模板ID'; COMMENT ON COLUMN sys_mail_log.mail_from IS '发送者'; COMMENT ON COLUMN sys_mail_log.mail_to IS '收件人'; COMMENT ON COLUMN sys_mail_log.mail_cc IS '抄送者'; COMMENT ON COLUMN sys_mail_log.subject IS '邮件主题'; COMMENT ON COLUMN sys_mail_log.content IS '邮件正文'; COMMENT ON COLUMN sys_mail_log.status IS '发送状态 0：失败 1：成功'; COMMENT ON COLUMN sys_mail_log.creator IS '创建者'; COMMENT ON COLUMN sys_mail_log.create_date IS '创建时间'; CREATE TABLE sys_oss ( id bigint NOT NULL, url varchar(200), creator bigint, create_date datetime, PRIMARY KEY (id) ); CREATE INDEX idx_sys_oss_create_date on sys_oss(create_date); COMMENT ON TABLE sys_oss IS '文件上传'; COMMENT ON COLUMN sys_oss.id IS 'id'; COMMENT ON COLUMN sys_oss.url IS 'URL地址'; COMMENT ON COLUMN sys_oss.creator IS '创建者'; COMMENT ON COLUMN sys_oss.create_date IS '创建时间'; CREATE TABLE schedule_job ( id bigint NOT NULL, bean_name varchar(200), params varchar(2000), cron_expression varchar(100), status int, remark varchar(255), creator bigint, create_date datetime, updater bigint, update_date datetime, PRIMARY KEY (id) ); CREATE INDEX idx_schedule_job_create_date on schedule_job(create_date); COMMENT ON TABLE schedule_job IS '定时任务'; COMMENT ON COLUMN schedule_job.id IS 'id'; COMMENT ON COLUMN schedule_job.bean_name IS 'spring bean名称'; COMMENT ON COLUMN schedule_job.params IS '参数'; COMMENT ON COLUMN schedule_job.cron_expression IS 'cron表达式'; COMMENT ON COLUMN schedule_job.status IS '任务状态 0：暂停 1：正常'; COMMENT ON COLUMN schedule_job.remark IS '备注'; COMMENT ON COLUMN schedule_job.creator IS '创建者'; COMMENT ON COLUMN schedule_job.create_date IS '创建时间'; COMMENT ON COLUMN schedule_job.updater IS '更新者'; COMMENT ON COLUMN schedule_job.update_date IS '更新时间'; CREATE TABLE schedule_job_log ( id bigint NOT NULL, job_id bigint NOT NULL, bean_name varchar(200), params varchar(2000), status int, error varchar(2000), times int, create_date datetime, PRIMARY KEY (id) ); CREATE INDEX idx_job_log_job_id on schedule_job_log(job_id); CREATE INDEX idx_job_log_create_date on schedule_job_log(create_date); COMMENT ON TABLE schedule_job_log IS '定时任务日志'; COMMENT ON COLUMN schedule_job_log.id IS 'id'; COMMENT ON COLUMN schedule_job_log.bean_name IS 'spring bean名称'; COMMENT ON COLUMN schedule_job_log.params IS '参数'; COMMENT ON COLUMN schedule_job_log.status IS '任务状态 0：失败 1：成功'; COMMENT ON COLUMN schedule_job_log.error IS '失败信息'; COMMENT ON COLUMN schedule_job_log.times IS '耗时(单位：毫秒)'; COMMENT ON COLUMN schedule_job.create_date IS '创建时间'; CREATE TABLE sys_user_token ( id bigint NOT NULL, user_id bigint, token varchar(100), expire_date datetime, update_date datetime, create_date datetime, PRIMARY KEY (id) ); CREATE UNIQUE INDEX uk_sys_user_token_user_id on sys_user_token(user_id); CREATE UNIQUE INDEX uk_sys_user_token on sys_user_token(token); COMMENT ON TABLE sys_user_token IS '系统用户Token'; COMMENT ON COLUMN sys_user_token.id IS 'id'; COMMENT ON COLUMN sys_user_token.user_id IS '用户id'; COMMENT ON COLUMN sys_user_token.token IS '用户token'; COMMENT ON COLUMN sys_user_token.expire_date IS '过期时间'; COMMENT ON COLUMN sys_user_token.update_date IS '更新时间'; COMMENT ON COLUMN sys_user_token.create_date IS '创建时间'; CREATE TABLE sys_language ( table_name varchar(32) NOT NULL, table_id bigint NOT NULL, field_name varchar(32) NOT NULL, field_value varchar(200) NOT NULL, language varchar(10) NOT NULL, primary key (table_name, table_id, field_name, language) ); CREATE INDEX idx_sys_language_table_id on sys_language(table_id); COMMENT ON TABLE sys_language IS '国际化'; COMMENT ON COLUMN sys_language.table_name IS '表名'; COMMENT ON COLUMN sys_language.table_id IS '表主键'; COMMENT ON COLUMN sys_language.field_name IS '字段名'; COMMENT ON COLUMN sys_language.field_value IS '字段值'; COMMENT ON COLUMN sys_language.language IS '语言'; CREATE TABLE sys_region ( id bigint NOT NULL, pid bigint, name varchar(100), tree_level int, leaf int, sort bigint, creator bigint, create_date datetime, updater bigint, update_date datetime, PRIMARY KEY (id) ); COMMENT ON TABLE sys_region IS '行政区域'; COMMENT ON COLUMN sys_region.pid IS '上级ID'; COMMENT ON COLUMN sys_region.name IS '名称'; COMMENT ON COLUMN sys_region.tree_level IS '层级'; COMMENT ON COLUMN sys_region.leaf IS '是否叶子节点 0：否 1：是'; COMMENT ON COLUMN sys_region.sort IS '排序'; COMMENT ON COLUMN sys_region.creator IS '创建者'; COMMENT ON COLUMN sys_region.create_date IS '创建时间'; COMMENT ON COLUMN sys_region.updater IS '更新者'; COMMENT ON COLUMN sys_region.update_date IS '更新时间'; CREATE TABLE tb_news ( id bigint NOT NULL, title varchar(100), content text, pub_date datetime, dept_id bigint, creator bigint, create_date datetime, updater bigint, update_date datetime, PRIMARY KEY (id) ); COMMENT ON TABLE tb_news IS '新闻管理'; COMMENT ON COLUMN tb_news.id IS 'id'; COMMENT ON COLUMN tb_news.title IS '标题'; COMMENT ON COLUMN tb_news.content IS '内容'; COMMENT ON COLUMN tb_news.pub_date IS '发布时间'; COMMENT ON COLUMN tb_news.dept_id IS '创建者dept_id'; COMMENT ON COLUMN tb_news.creator IS '创建者'; COMMENT ON COLUMN tb_news.create_date IS '创建时间'; COMMENT ON COLUMN tb_news.updater IS '更新者'; COMMENT ON COLUMN tb_news.update_date IS '更新时间'; CREATE TABLE tb_product ( id bigint NOT NULL, name varchar(100), content varchar(5000), creator bigint, create_date datetime, updater bigint, update_date datetime, PRIMARY KEY (id) ); COMMENT ON TABLE tb_product IS '产品管理'; COMMENT ON COLUMN tb_product.id IS 'id'; COMMENT ON COLUMN tb_product.name IS '产品名称'; COMMENT ON COLUMN tb_product.content IS '产品介绍'; COMMENT ON COLUMN tb_product.creator IS '创建者'; COMMENT ON COLUMN tb_product.create_date IS '创建时间'; COMMENT ON COLUMN tb_product.updater IS '更新者'; COMMENT ON COLUMN tb_product.update_date IS '更新时间'; CREATE TABLE tb_product_params ( id bigint NOT NULL, param_name varchar(100), param_value varchar(200), product_id bigint, creator bigint, create_date datetime, updater bigint, update_date datetime, PRIMARY KEY (id) ); COMMENT ON TABLE tb_product_params IS '产品参数管理'; COMMENT ON COLUMN tb_product_params.id IS 'id'; COMMENT ON COLUMN tb_product_params.param_name IS '参数名'; COMMENT ON COLUMN tb_product_params.param_value IS '参数值'; COMMENT ON COLUMN tb_product_params.product_id IS '产品ID'; COMMENT ON COLUMN tb_product_params.creator IS '创建者'; COMMENT ON COLUMN tb_product_params.create_date IS '创建时间'; COMMENT ON COLUMN tb_product_params.updater IS '更新者'; COMMENT ON COLUMN tb_product_params.update_date IS '更新时间'; create table sys_post ( id bigint NOT NULL, post_code varchar(100), post_name varchar(100), sort int, status int, creator bigint, create_date datetime, updater bigint, update_date datetime, PRIMARY KEY (id) ); COMMENT ON TABLE sys_post IS '岗位管理'; COMMENT ON COLUMN sys_post.id IS 'id'; COMMENT ON COLUMN sys_post.post_code IS '岗位编码'; COMMENT ON COLUMN sys_post.post_name IS '岗位名称'; COMMENT ON COLUMN sys_post.sort IS '排序'; COMMENT ON COLUMN sys_post.status IS '状态 0：停用 1：正常'; COMMENT ON COLUMN sys_post.creator IS '创建者'; COMMENT ON COLUMN sys_post.create_date IS '创建时间'; COMMENT ON COLUMN sys_post.updater IS '更新者'; COMMENT ON COLUMN sys_post.update_date IS '更新时间'; CREATE TABLE sys_user_post ( id bigint NOT NULL, post_id bigint, user_id bigint, creator bigint, create_date datetime, primary key (id) ); CREATE INDEX idx_sys_user_post_post_id on sys_user_post(post_id); CREATE INDEX idx_sys_user_post_user_id on sys_user_post(user_id); COMMENT ON TABLE sys_user_post IS '用户岗位关系'; COMMENT ON COLUMN sys_user_post.id IS 'id'; COMMENT ON COLUMN sys_user_post.post_id IS '岗位ID'; COMMENT ON COLUMN sys_user_post.user_id IS '用户ID'; COMMENT ON COLUMN sys_post.creator IS '创建者'; COMMENT ON COLUMN sys_post.create_date IS '创建时间'; CREATE TABLE tb_excel_data ( id bigint NOT NULL, real_name varchar(100), user_identity varchar(100), address varchar(200), join_date datetime, class_name varchar(100), creator bigint, create_date datetime, primary key (id) ); COMMENT ON TABLE tb_excel_data IS 'Excel导入演示'; COMMENT ON COLUMN tb_excel_data.id IS 'id'; COMMENT ON COLUMN tb_excel_data.real_name IS '学生姓名'; COMMENT ON COLUMN tb_excel_data.user_identity IS '身份证'; COMMENT ON COLUMN tb_excel_data.address IS '家庭地址'; COMMENT ON COLUMN tb_excel_data.join_date IS '入学日期'; COMMENT ON COLUMN tb_excel_data.class_name IS '班级名称'; COMMENT ON COLUMN tb_excel_data.creator IS '创建者'; COMMENT ON COLUMN tb_excel_data.create_date IS '创建时间'; CREATE TABLE tb_order ( id bigint NOT NULL, order_id bigint, product_id bigint, product_name varchar(100), pay_amount numeric(10,2), status int, user_id bigint, pay_at datetime, create_date datetime, primary key (id) ); CREATE UNIQUE INDEX uk_tb_order_order_id on tb_order(order_id); COMMENT ON TABLE tb_order IS '订单'; COMMENT ON COLUMN tb_order.id IS 'id'; COMMENT ON COLUMN tb_order.order_id IS '订单ID'; COMMENT ON COLUMN tb_order.product_id IS '产品ID'; COMMENT ON COLUMN tb_order.product_name IS '产品名称'; COMMENT ON COLUMN tb_order.pay_amount IS '支付金额'; COMMENT ON COLUMN tb_order.status IS '订单状态 -1：已取消 0：等待付款 1：已完成'; COMMENT ON COLUMN tb_order.user_id IS '购买用户ID'; COMMENT ON COLUMN tb_order.pay_at IS '支付时间'; COMMENT ON COLUMN tb_order.create_date IS '下单时间'; CREATE TABLE tb_alipay_notify_log ( id bigint NOT NULL, out_trade_no bigint, total_amount numeric(10,2), buyer_pay_amount numeric(10,2), receipt_amount numeric(10,2), invoice_amount numeric(10,2), notify_id varchar(50), buyer_id varchar(50), seller_id varchar(50), trade_no varchar(50), trade_status varchar(50), create_date datetime, primary key (id) ); COMMENT ON TABLE tb_alipay_notify_log IS '支付宝回调日志'; COMMENT ON COLUMN tb_alipay_notify_log.id IS 'id'; COMMENT ON COLUMN tb_alipay_notify_log.out_trade_no IS '订单号'; COMMENT ON COLUMN tb_alipay_notify_log.total_amount IS '订单金额'; COMMENT ON COLUMN tb_alipay_notify_log.buyer_pay_amount IS '付款金额'; COMMENT ON COLUMN tb_alipay_notify_log.receipt_amount IS '实收金额'; COMMENT ON COLUMN tb_alipay_notify_log.invoice_amount IS '开票金额'; COMMENT ON COLUMN tb_alipay_notify_log.notify_id IS '通知校验ID'; COMMENT ON COLUMN tb_alipay_notify_log.buyer_id IS '买家支付宝用户号'; COMMENT ON COLUMN tb_alipay_notify_log.seller_id IS '卖家支付宝用户号'; COMMENT ON COLUMN tb_alipay_notify_log.trade_no IS '支付宝交易号'; COMMENT ON COLUMN tb_alipay_notify_log.trade_status IS '交易状态'; COMMENT ON COLUMN tb_alipay_notify_log.create_date IS '创建时间'; CREATE TABLE mp_account ( id bigint NOT NULL, name varchar(100), app_id varchar(100), app_secret varchar(100), token varchar(100), aes_key varchar(100), creator bigint, create_date datetime, updater bigint, update_date datetime, primary key (id) ); COMMENT ON TABLE mp_account IS '公众号账号管理'; COMMENT ON COLUMN mp_account.id IS 'id'; COMMENT ON COLUMN mp_account.name IS '名称'; COMMENT ON COLUMN mp_account.app_id IS 'AppID'; COMMENT ON COLUMN mp_account.app_secret IS 'AppSecret'; COMMENT ON COLUMN mp_account.token IS 'Token'; COMMENT ON COLUMN mp_account.aes_key IS 'EncodingAESKey'; COMMENT ON COLUMN mp_account.creator IS '创建者'; COMMENT ON COLUMN mp_account.create_date IS '创建时间'; COMMENT ON COLUMN mp_account.updater IS '更新者'; COMMENT ON COLUMN mp_account.update_date IS '更新时间'; CREATE TABLE mp_menu ( id bigint NOT NULL, menu varchar(2000), app_id varchar(100), creator bigint, create_date datetime, updater bigint, update_date datetime, primary key (id) ); COMMENT ON TABLE mp_menu IS '公众号自定义菜单'; COMMENT ON COLUMN mp_menu.id IS 'id'; COMMENT ON COLUMN mp_menu.menu IS '菜单json数据'; COMMENT ON COLUMN mp_menu.app_id IS 'AppID'; COMMENT ON COLUMN mp_menu.creator IS '创建者'; COMMENT ON COLUMN mp_menu.create_date IS '创建时间'; COMMENT ON COLUMN mp_menu.updater IS '更新者'; COMMENT ON COLUMN mp_menu.update_date IS '更新时间'; CREATE TABLE bpm_form ( id bigint NOT NULL, name varchar(50), remark varchar(200), content text, creator bigint, create_date datetime, updater bigint, update_date datetime, primary key (id) ); COMMENT ON TABLE bpm_form IS '流程表单'; COMMENT ON COLUMN bpm_form.id IS 'id'; COMMENT ON COLUMN bpm_form.name IS '名称'; COMMENT ON COLUMN bpm_form.remark IS '备注'; COMMENT ON COLUMN bpm_form.content IS '表单内容'; COMMENT ON COLUMN bpm_form.creator IS '创建者'; COMMENT ON COLUMN bpm_form.create_date IS '创建时间'; COMMENT ON COLUMN bpm_form.updater IS '更新者'; COMMENT ON COLUMN bpm_form.update_date IS '更新时间'; CREATE TABLE bpm_definition_ext ( id bigint NOT NULL, model_id varchar(64), process_definition_id varchar(64), form_type varchar(64), form_id varchar(500), form_content text, creator bigint, create_date datetime, updater bigint, update_date datetime, primary key (id) ); COMMENT ON TABLE bpm_definition_ext IS '流程定义扩展'; COMMENT ON COLUMN bpm_definition_ext.id IS 'id'; COMMENT ON COLUMN bpm_definition_ext.model_id IS '模型ID'; COMMENT ON COLUMN bpm_definition_ext.process_definition_id IS '流程定义ID'; COMMENT ON COLUMN bpm_definition_ext.form_id IS '表单ID'; COMMENT ON COLUMN bpm_definition_ext.form_content IS '表单内容'; COMMENT ON COLUMN bpm_definition_ext.creator IS '创建者'; COMMENT ON COLUMN bpm_definition_ext.create_date IS '创建时间'; COMMENT ON COLUMN bpm_definition_ext.updater IS '更新者'; COMMENT ON COLUMN bpm_definition_ext.update_date IS '更新时间'; CREATE TABLE bpm_instance_ext ( id bigint NOT NULL, process_instance_id varchar(64), process_definition_id varchar(64), form_variables varchar(4000), creator bigint, create_date datetime, updater bigint, update_date datetime, primary key (id) ); COMMENT ON TABLE bpm_instance_ext IS '流程实例扩展'; COMMENT ON COLUMN bpm_instance_ext.id IS 'id'; COMMENT ON COLUMN bpm_instance_ext.process_instance_id IS '流程实例ID'; COMMENT ON COLUMN bpm_instance_ext.process_definition_id IS '流程定义ID'; COMMENT ON COLUMN bpm_instance_ext.form_variables IS '表单值'; COMMENT ON COLUMN bpm_instance_ext.creator IS '创建者'; COMMENT ON COLUMN bpm_instance_ext.create_date IS '创建时间'; COMMENT ON COLUMN bpm_instance_ext.updater IS '更新者'; COMMENT ON COLUMN bpm_instance_ext.update_date IS '更新时间'; CREATE TABLE bpm_form_correction ( id bigint NOT NULL, apply_post varchar(255), entry_date datetime, correction_date datetime, work_content varchar(2000), achievement varchar(2000), instance_id varchar(80), creator bigint, create_date datetime, PRIMARY KEY (id) ); create table sys_ureport_data ( id bigint NOT NULL, file_name varchar(200), content text, create_date datetime, update_date datetime, PRIMARY KEY (id) ); COMMENT ON TABLE sys_ureport_data IS '报表数据'; COMMENT ON COLUMN sys_ureport_data.id IS 'id'; COMMENT ON COLUMN sys_ureport_data.file_name IS '报表文件名'; COMMENT ON COLUMN sys_ureport_data.content IS '内容'; COMMENT ON COLUMN sys_ureport_data.create_date IS '创建时间'; COMMENT ON COLUMN sys_ureport_data.update_date IS '更新时间'; -- 初始数据 INSERT INTO sys_user(id, username, password, real_name, gender, email, mobile, status, dept_id, super_admin, creator, create_date, updater, update_date) VALUES (1067246875800000001, 'admin', '$2a$10$012Kx2ba5jzqr9gLlG4MX.bnQJTD9UWqF57XDo2N3.fPtLne02u/m', '管理员', 0, 'root@scjydz.com', '13612345678', 1, null, 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_user(id, username, password, real_name, gender, email, mobile, dept_id, super_admin, status, creator, create_date, updater, update_date) VALUES (1353943117220315138, 'test', '$2a$10$012Kx2ba5jzqr9gLlG4MX.bnQJTD9UWqF57XDo2N3.fPtLne02u/m', '测试用户', 0, 'test@scjydz.com', '13012345678', 1067246875800000066, 0, 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000002, '0', NULL, NULL, 0, 0, 'icon-safetycertificate', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000003, 1067246875800000055, NULL, 'sys:user:save,sys:dept:list,sys:role:list', 1, 0, NULL, 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000004, 1067246875800000055, NULL, 'sys:user:update,sys:dept:list,sys:role:list', 1, 0, NULL, 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000005, 1067246875800000055, NULL, 'sys:user:delete', 1, 0, NULL, 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000006, 1067246875800000055, NULL, 'sys:user:export', 1, 0, NULL, 4, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000007, 1067246875800000002, 'sys/role', NULL, 0, 0, 'icon-team', 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000008, 1067246875800000007, NULL, 'sys:role:page,sys:role:info', 1, 0, NULL, 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000009, 1067246875800000007, NULL, 'sys:role:save,sys:menu:select,sys:dept:list', 1, 0, NULL, 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000010, 1067246875800000007, NULL, 'sys:role:update,sys:menu:select,sys:dept:list', 1, 0, NULL, 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000011, 1067246875800000007, NULL, 'sys:role:delete', 1, 0, NULL, 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000012, 1067246875800000002, 'sys/dept', NULL, 0, 0, 'icon-apartment', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000014, 1067246875800000012, NULL, 'sys:dept:list,sys:dept:info', 1, 0, NULL, 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000015, 1067246875800000012, NULL, 'sys:dept:save', 1, 0, NULL, 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000016, 1067246875800000012, NULL, 'sys:dept:update', 1, 0, NULL, 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000017, 1067246875800000012, NULL, 'sys:dept:delete', 1, 0, NULL, 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000018, 1150940491508928513, 'flow/bpmform', 'flow:bpmform:all', 0, 0, 'icon-detail', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000019, 1150940491508928513, 'flow/model', 'sys:model:all', 0, 0, 'icon-appstore-fill', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000020, 1150940491508928513, 'flow/running', 'sys:running:all,sys:flow:all', 0, 0, 'icon-play-square', 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000021, 1067246875800000024, 'message/sms', 'sys:sms:all', 0, 0, 'icon-message-fill', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000022, 1067246875800000024, 'message/mail_template', 'sys:mail:all', 0, 0, 'icon-mail', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000023, 1067246875800000024, 'message/mail_log', 'sys:mail:log', 0, 0, 'icon-detail-fill', 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000024, '0', NULL, NULL, 0, 0, 'icon-message', 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000025, 1067246875800000035, 'sys/menu', NULL, 0, 0, 'icon-unorderedlist', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000026, 1067246875800000025, NULL, 'sys:menu:list,sys:menu:info', 1, 0, NULL, 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000027, 1067246875800000025, NULL, 'sys:menu:save', 1, 0, NULL, 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000028, 1067246875800000025, NULL, 'sys:menu:update', 1, 0, NULL, 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000029, 1067246875800000025, NULL, 'sys:menu:delete', 1, 0, NULL, 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000030, 1067246875800000035, 'job/schedule', NULL, 0, 0, 'icon-dashboard', 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000031, 1067246875800000030, NULL, 'sys:schedule:page,sys:schedule:info', 1, 0, NULL, 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000032, 1067246875800000030, NULL, 'sys:schedule:save', 1, 0, NULL, 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000033, 1067246875800000030, NULL, 'sys:schedule:update', 1, 0, NULL, 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000034, 1067246875800000030, NULL, 'sys:schedule:delete', 1, 0, NULL, 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000035, '0', NULL, NULL, 0, 0, 'icon-setting', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000036, 1067246875800000030, NULL, 'sys:schedule:pause', 1, 0, NULL, 4, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000037, 1067246875800000030, NULL, 'sys:schedule:resume', 1, 0, NULL, 5, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000038, 1067246875800000030, NULL, 'sys:schedule:run', 1, 0, NULL, 6, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000039, 1067246875800000030, NULL, 'sys:schedule:log', 1, 0, NULL, 7, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000040, 1067246875800000035, 'sys/params', '', 0, 0, 'icon-fileprotect', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000041, 1067246875800000035, 'sys/dict-type', NULL, 0, 0, 'icon-golden-fill', 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000042, 1067246875800000041, NULL, 'sys:dict:page,sys:dict:info', 1, 0, NULL, 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000043, 1067246875800000041, NULL, 'sys:dict:save', 1, 0, NULL, 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000044, 1067246875800000041, NULL, 'sys:dict:update', 1, 0, NULL, 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000045, 1067246875800000041, NULL, 'sys:dict:delete', 1, 0, NULL, 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000046, '0', NULL, NULL, 0, 0, 'icon-container', 5, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000047, 1067246875800000035, 'oss/oss', 'sys:oss:all', 0, 0, 'icon-upload', 4, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000048, 1067246875800000046, 'sys/log-login', 'sys:log:login', 0, 0, 'icon-filedone', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000049, 1067246875800000046, 'sys/log-operation', 'sys:log:operation', 0, 0, 'icon-solution', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000050, 1067246875800000046, 'sys/log-error', 'sys:log:error', 0, 0, 'icon-file-exception', 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000051, 1067246875800000053, '{{ApiUrl}}/druid/sql.html', NULL, 0, 0, 'icon-database', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000052, 1067246875800000054, 'demo/news', 'demo:news:all', 0, 0, 'icon-file-word', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000053, '0', NULL, NULL, 0, 0, 'icon-desktop', 5, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000054, '0', NULL, NULL, 0, 0, 'icon-windows', 6, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000055, 1067246875800000002, 'sys/user', NULL, 0, 0, 'icon-user', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000056, 1067246875800000055, NULL, 'sys:user:page,sys:user:info', 1, 0, NULL, 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000057, 1067246875800000040, NULL, 'sys:params:save', 1, 0, NULL, 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000058, 1067246875800000040, NULL, 'sys:params:export', 1, 0, NULL, 4, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000059, 1067246875800000040, '', 'sys:params:page,sys:params:info', 1, 0, NULL, 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000060, 1067246875800000040, NULL, 'sys:params:update', 1, 0, NULL, 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000061, 1067246875800000040, '', 'sys:params:delete', 1, 0, '', 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1150940491508928513, '0', NULL, NULL, 0, 0, 'icon-reloadtime', 4, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1150941310262235138, '0', NULL, NULL, 0, 0, 'icon-user', 4, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1150941384811794433, 1150941310262235138, 'flow/todo', 'sys:flow:all,sys:user:page', 0, 0, 'icon-dashboard', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1150941447038488577, 1150941310262235138, 'flow/done', 'sys:flow:all', 0, 0, 'icon-check-square', 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1150941506626965506, 1150941310262235138, 'flow/start', 'sys:flow:all', 0, 0, 'icon-play-square', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1150941588046794754, 1150941310262235138, 'flow/my-send', 'sys:flow:all', 0, 0, 'icon-edit-square', 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1156748733921165314, 1067246875800000053, '{{ApiUrl}}/doc.html', '', 0, 1, 'icon-file-word', 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1158267114314842115, 1067246875800000035, 'sys/region', NULL, 0, 0, 'icon-location', 4, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1158267114314842116, 1158267114314842115, NULL, 'sys:region:list,sys:region:info', 1, 0, NULL, 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1158267114314842117, 1158267114314842115, NULL, 'sys:region:save', 1, 0, NULL, 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1158267114314842118, 1158267114314842115, NULL, 'sys:region:update', 1, 0, NULL, 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1158267114314842119, 1158267114314842115, NULL, 'sys:region:delete', 1, 0, NULL, 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000300, '0', NULL, NULL, 0, 0, 'icon-bell', 5, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000301, 1067246875800000300, 'notice/notice', 'sys:notice:all', 0, 0, 'icon-bell', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000302, 1067246875800000300, 'notice/notice-user', 'sys:notice:all', 0, 0, 'icon-notification', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000303, 1067246875800000024, 'message/sms-log', 'sys:smslog:all', 0, 0, 'icon-unorderedlist', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1270380959719501825, 1067246875800000054, 'demo/product', NULL, 0, 0, 'icon-tag', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1270380959719501826, 1270380959719501825, NULL, 'demo:product:page,demo:product:info', 1, 0, NULL, 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1270380959719501827, 1270380959719501825, NULL, 'demo:product:save', 1, 0, NULL, 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1270380959719501828, 1270380959719501825, NULL, 'demo:product:update', 1, 0, NULL, 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1270380959719501829, 1270380959719501825, NULL, 'demo:product:delete', 1, 0, NULL, 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1341596622612987906, 1067246875800000002, 'sys/post', NULL, 0, 0, 'icon-pic-left', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1341596622688485377, 1341596622612987906, NULL, 'sys:post:page,sys:post:info', 1, 0, NULL, 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1341596622755594242, 1341596622612987906, NULL, 'sys:post:save', 1, 0, NULL, 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1341596622835286018, 1341596622612987906, NULL, 'sys:post:update', 1, 0, NULL, 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1341596622902394881, 1341596622612987906, NULL, 'sys:post:delete', 1, 0, NULL, 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1341659662599495681, 1067246875800000053, 'sys/online', 'sys:online:all', 0, 0, 'icon-team', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1341676084016852994, 1067246875800000054, 'demo/excel', 'demo:excel:all', 0, 0, 'icon-table', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1343074487777677313, 0, '', '', 0, 0, 'icon-Dollar', 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1343074685589442561, 1343074487777677313, 'pay/order', 'pay:order:all', 0, 0, 'icon-unorderedlist', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1343074794440019970, 1343074487777677313, 'pay/alipaynotifylog', 'pay:alipayNotifyLog:all', 0, 0, 'icon-filedone', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1270380959719501800, 1067246875800000054, 'demo/charts', NULL, 0, 0, 'icon-tag', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu (id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1419551957005963266, 0, '', '', 0, 0, 'icon-wechat-fill', 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu (id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1419553543706972161, 1419551957005963266, 'mp/account', 'mp:account:all', 0, 0, 'icon-user', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu (id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1419963799817691137, 1419551957005963266, 'mp/menu', 'mp:menu:all', 0, 0, 'icon-unorderedlist', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1300278047072649217, 0, '', '', 0, 0, 'icon-filesearch', 3, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1300278435729440769, 1300278047072649217, '{{ApiUrl}}/ureport/designer', '', 0, 0, 'icon-book', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1300381796852060161, 1300278047072649217, 'ureport/ureport', 'sys:ureport:all', 0, 0, 'icon-up-circle', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000002, 'name', 'Authority Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000002, 'name', '权限管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000002, 'name', '權限管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000003, 'name', 'Add', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000003, 'name', '新增', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000003, 'name', '新增', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000004, 'name', 'Edit', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000004, 'name', '修改', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000004, 'name', '修改', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000005, 'name', 'Delete', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000005, 'name', '删除', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000005, 'name', '刪除', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000006, 'name', 'Export', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000006, 'name', '导出', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000006, 'name', '導出', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000007, 'name', 'Role Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000007, 'name', '角色管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000007, 'name', '角色管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000008, 'name', 'View', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000008, 'name', '查看', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000008, 'name', '查看', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000009, 'name', 'Add', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000009, 'name', '新增', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000009, 'name', '新增', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000010, 'name', 'Edit', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000010, 'name', '修改', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000010, 'name', '修改', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000011, 'name', 'Delete', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000011, 'name', '删除', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000011, 'name', '刪除', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000012, 'name', 'Department Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000012, 'name', '部门管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000012, 'name', '部門管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000014, 'name', 'View', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000014, 'name', '查看', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000014, 'name', '查看', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000015, 'name', 'Add', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000015, 'name', '新增', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000015, 'name', '新增', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000016, 'name', 'Edit', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000016, 'name', '修改', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000016, 'name', '修改', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000017, 'name', 'Delete', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000017, 'name', '删除', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000017, 'name', '刪除', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000018, 'name', 'Form Design', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000018, 'name', '表单设计', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000018, 'name', '表单设计', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000019, 'name', 'Process Design', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000019, 'name', '流程设计', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000019, 'name', '流程设计', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000020, 'name', 'Running Process', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000020, 'name', '运行中的流程', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000020, 'name', '運行中的流程', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000021, 'name', 'SMS Service', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000021, 'name', '短信服务', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000021, 'name', '短信服務', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000022, 'name', 'Mail Template', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000022, 'name', '邮件模板', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000022, 'name', '郵件模板', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000023, 'name', 'Mail Log', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000023, 'name', '邮件发送记录', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000023, 'name', '郵件發送記錄', 'zh-TW '); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000024, 'name', 'Message Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000024, 'name', '消息管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000024, 'name', '消息管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000025, 'name', 'Menu Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000025, 'name', '菜单管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000025, 'name', '菜單管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000026, 'name', 'View', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000026, 'name', '查看', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000026, 'name', '查看', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000027, 'name', 'Add', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000027, 'name', '新增', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000027, 'name', '新增', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000028, 'name', 'Edit', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000028, 'name', '修改', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000028, 'name', '修改', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000029, 'name', 'Delete', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000029, 'name', '删除', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000029, 'name', '刪除', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000030, 'name', 'Timed Task', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000030, 'name', '定时任务', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000030, 'name', '定時任務', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000031, 'name', 'View', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000031, 'name', '查看', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000031, 'name', '查看', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000032, 'name', 'Add', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000032, 'name', '新增', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000032, 'name', '新增', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000033, 'name', 'Edit', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000033, 'name', '修改', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000033, 'name', '修改', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000034, 'name', 'Delete', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000034, 'name', '删除', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000034, 'name', '刪除', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000035, 'name', 'Setting', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000035, 'name', '系统设置', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000035, 'name', '系統設置', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000036, 'name', 'Pause', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000036, 'name', '暂停', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000036, 'name', '暫停', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000037, 'name', 'Resume', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000037, 'name', '恢复', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000037, 'name', '恢復', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000038, 'name', 'Execute', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000038, 'name', '立即执行', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000038, 'name', '立即執行', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000039, 'name', 'Log List', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000039, 'name', '日志列表', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000039, 'name', '日誌列表', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000040, 'name', 'Parameter Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000040, 'name', '参数管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000040, 'name', '參數管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000041, 'name', 'Dict Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000041, 'name', '字典管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000041, 'name', '字典管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000042, 'name', 'View', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000042, 'name', '查看', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000042, 'name', '查看', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000043, 'name', 'Add', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000043, 'name', '新增', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000043, 'name', '新增', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000044, 'name', 'Edit', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000044, 'name', '修改', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000044, 'name', '修改', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000045, 'name', 'Delete', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000045, 'name', '删除', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000045, 'name', '刪除', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000046, 'name', 'Log Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000046, 'name', '日志管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000046, 'name', '日誌管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000047, 'name', 'File Upload', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000047, 'name', '文件上传', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000047, 'name', '文件上傳', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000048, 'name', 'Login Log', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000048, 'name', '登录日志', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000048, 'name', '登錄日誌', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000049, 'name', 'Operation Log', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000049, 'name', '操作日志', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000049, 'name', '操作日誌', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000050, 'name', 'Error Log', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000050, 'name', '异常日志', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000050, 'name', '異常日誌', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000051, 'name', 'SQL Monitoring', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000051, 'name', 'SQL监控', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000051, 'name', 'SQL監控', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000052, 'name', 'News Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000052, 'name', '新闻管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000052, 'name', '新聞管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000053, 'name', 'System Monitoring', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000053, 'name', '系统监控', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000053, 'name', '系統監控', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000054, 'name', 'Demo', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000054, 'name', '功能示例', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000054, 'name', '功能示例', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000055, 'name', 'User Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000055, 'name', '用户管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000055, 'name', '用戶管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000056, 'name', 'View', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000056, 'name', '查看', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000056, 'name', '查看', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000057, 'name', 'Add', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000057, 'name', '新增', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000057, 'name', '新增', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000058, 'name', 'Export', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000058, 'name', '导出', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000058, 'name', '導出', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000059, 'name', 'View', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000059, 'name', '查看', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000059, 'name', '查看', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000060, 'name', 'Edit', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000060, 'name', '修改', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000060, 'name', '修改', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000061, 'name', 'Delete', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000061, 'name', '删除', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000061, 'name', '刪除', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150940491508928513, 'name', 'Process Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150940491508928513, 'name', '流程管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150940491508928513, 'name', '流程管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941310262235138, 'name', 'Personal Office', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941310262235138, 'name', '办公管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941310262235138, 'name', '辦公管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941384811794433, 'name', 'Todo', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941384811794433, 'name', '待办任务', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941384811794433, 'name', '待辦任務', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941447038488577, 'name', 'Task Already', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941447038488577, 'name', '已办任务', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941447038488577, 'name', '已辦任務', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941506626965506, 'name', 'Initiation Process', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941506626965506, 'name', '发起流程', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941506626965506, 'name', '發起流程', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941588046794754, 'name', 'My Send', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941588046794754, 'name', '我发起的', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941588046794754, 'name', '我發起的', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1156748733921165314, 'name', 'Interface Document', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1156748733921165314, 'name', '接口文档', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1156748733921165314, 'name', '接口文檔', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842115, 'name', 'Administrative Regions', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842115, 'name', '行政区域', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842115, 'name', '行政區域', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842116, 'name', 'View', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842116, 'name', '查看', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842116, 'name', '查看', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842117, 'name', 'Add', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842117, 'name', '新增', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842117, 'name', '新增', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842118, 'name', 'Edit', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842118, 'name', '修改', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842118, 'name', '修改', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842119, 'name', 'Delete', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842119, 'name', '删除', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842119, 'name', '刪除', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000300, 'name', 'Station Notice', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000300, 'name', '站内通知', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000300, 'name', '站內通知', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000301, 'name', 'Notice Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000301, 'name', '通知管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000301, 'name', '通知管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000302, 'name', 'My Notice', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000302, 'name', '我的通知', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000302, 'name', '我的通知', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000303, 'name', 'SMS History', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000303, 'name', '短信发送记录', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000303, 'name', '短信發送記錄', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300278047072649217, 'name', 'Report Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300278047072649217, 'name', '报表管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300278047072649217, 'name', '報表管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300278435729440769, 'name', 'Report Design', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300278435729440769, 'name', '报表设计器', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300278435729440769, 'name', '報表設計器', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300381796852060161, 'name', 'Report List', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300381796852060161, 'name', '报表列表', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300381796852060161, 'name', '報表列表', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501825, 'name', 'Master And Child', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501825, 'name', '主子表演示', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501825, 'name', '主子表演示', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501826, 'name', 'View', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501826, 'name', '查看', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501826, 'name', '查看', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501827, 'name', 'Add', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501827, 'name', '新增', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501827, 'name', '新增', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501828, 'name', 'Edit', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501828, 'name', '修改', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501828, 'name', '修改', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501829, 'name', 'Delete', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501829, 'name', '删除', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501829, 'name', '刪除', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501800, 'name', 'ECharts', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501800, 'name', 'ECharts', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501800, 'name', 'ECharts', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341659662599495681, 'name', 'Online User', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341659662599495681, 'name', '在线用户', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341659662599495681, 'name', '在線用戶', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341676084016852994, 'name', 'Excel Demo', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341676084016852994, 'name', 'Excel导入演示', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341676084016852994, 'name', 'Excel導入演示', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074487777677313, 'name', 'Pay Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074487777677313, 'name', '支付管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074487777677313, 'name', '支付管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074685589442561, 'name', 'Order Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074685589442561, 'name', '订单管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074685589442561, 'name', '訂單管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074794440019970, 'name', 'AliPay Log', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074794440019970, 'name', '支付宝回调日志', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074794440019970, 'name', '支付寶回調日誌', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622612987906, 'name', 'Job Management', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622612987906, 'name', '岗位管理', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622612987906, 'name', '崗位管理', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622688485377, 'name', 'View', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622688485377, 'name', '查看', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622688485377, 'name', '查看', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622755594242, 'name', 'Add', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622755594242, 'name', '新增', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622755594242, 'name', '新增', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622835286018, 'name', 'Edit', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622835286018, 'name', '修改', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622835286018, 'name', '修改', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622902394881, 'name', 'Delete', 'en-US'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622902394881, 'name', '删除', 'zh-CN'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622902394881, 'name', '刪除', 'zh-TW'); INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419551957005963266, 'name', 'Wechat Management', 'en-US'); INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419551957005963266, 'name', '微信管理', 'zh-CN'); INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419551957005963266, 'name', '微信管理', 'zh-TW'); INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419553543706972161, 'name', 'Mp Management', 'en-US'); INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419553543706972161, 'name', '公众号管理', 'zh-CN'); INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419553543706972161, 'name', '公眾號管理', 'zh-TW'); INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419963799817691137, 'name', 'Custom Menu', 'en-US'); INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419963799817691137, 'name', '自定义菜单', 'zh-CN'); INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419963799817691137, 'name', '自定義選單', 'zh-TW'); INSERT INTO sys_dept(id, pid, pids, name, sort, creator, create_date, updater, update_date) VALUES (1067246875800000062, 1067246875800000063, '1067246875800000066,1067246875800000063', '技术部', 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dept(id, pid, pids, name, sort, creator, create_date, updater, update_date) VALUES (1067246875800000063, 1067246875800000066, '1067246875800000066', '长沙分公司', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dept(id, pid, pids, name, sort, creator, create_date, updater, update_date) VALUES (1067246875800000064, 1067246875800000066, '1067246875800000066', '上海分公司', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dept(id, pid, pids, name, sort, creator, create_date, updater, update_date) VALUES (1067246875800000065, 1067246875800000064, '1067246875800000066,1067246875800000064', '市场部', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dept(id, pid, pids, name, sort, creator, create_date, updater, update_date) VALUES (1067246875800000066, 0, '0', '佳缘科技股份有限公司', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dept(id, pid, pids, name, sort, creator, create_date, updater, update_date) VALUES (1067246875800000067, 1067246875800000064, '1067246875800000066,1067246875800000064', '销售部', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dept(id, pid, pids, name, sort, creator, create_date, updater, update_date) VALUES (1067246875800000068, 1067246875800000063, '1067246875800000066,1067246875800000063', '产品部', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dict_type(id, dict_type, dict_name, remark, sort, creator, create_date, updater, update_date) VALUES (1160061077912858625, 'gender', '性别', '', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dict_type(id, dict_type, dict_name, remark, sort, creator, create_date, updater, update_date) VALUES (1225813644059140097, 'notice_type', '站内通知-类型', '', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dict_type(id, dict_type, dict_name, remark, sort, creator, create_date, updater, update_date) VALUES (1341593474355838978, 'post_status', '岗位管理状态', '', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dict_type(id, dict_type, dict_name, remark, sort, creator, create_date, updater, update_date) VALUES (1343069688596295682, 'order_status', '订单状态', '', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1225814069634195457, 1225813644059140097, '公告', '0', '', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1225814107559092225, 1225813644059140097, '会议', '1', '', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1225814271879340034, 1225813644059140097, '其他', '2', '', 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1160061112075464705, 1160061077912858625, '男', '0', '', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1160061146967879681, 1160061077912858625, '女', '1', '', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1160061190127267841, 1160061077912858625, '保密', '2', '', 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1341593562419445762, 1341593474355838978, '停用', '0', '', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1341593595407646722, 1341593474355838978, '正常', '1', '', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1343069765549191170, 1343069688596295682, '已取消', '-1', '', 0, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1343069839847092226, 1343069688596295682, '等待付款', '0', '', 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1343069914518286337, 1343069688596295682, '已完成', '1', '', 2, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_sms(id, sms_code, platform, sms_config, remark, creator, create_date, updater, update_date) VALUES (1228954061084676097, '1001', 1, '{"aliyunAccessKeyId":"1","aliyunAccessKeySecret":"1","aliyunSignName":"1","aliyunTemplateCode":"1","qcloudAppKey":"","qcloudSignName":"","qcloudTemplateId":"","qiniuAccessKey":"","qiniuSecretKey":"","qiniuTemplateId":""}', '', 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_params(id, param_code, param_value, param_type, remark, creator, create_date, updater, update_date) VALUES (1067246875800000073, 'CLOUD_STORAGE_CONFIG_KEY', '{"type":1,"qiniuDomain":"http://test.oss.scjydz.com","qiniuPrefix":"upload","qiniuAccessKey":"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ","qiniuSecretKey":"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV","qiniuBucketName":"wjp-oss","aliyunDomain":"","aliyunPrefix":"","aliyunEndPoint":"","aliyunAccessKeyId":"","aliyunAccessKeySecret":"","aliyunBucketName":"","qcloudDomain":"","qcloudPrefix":"","qcloudSecretId":"","qcloudSecretKey":"","qcloudBucketName":""}', '0', '云存储配置信息', 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_params(id, param_code, param_value, param_type, remark, creator, create_date, updater, update_date) VALUES (1067246875800000075, 'MAIL_CONFIG_KEY', '{"smtp":"smtp.163.com","port":25,"username":"wjp_test@163.com","password":"wjp123456"}', 0, '邮件配置信息', 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO schedule_job (id, bean_name, params, cron_expression, status, remark, creator, create_date, updater, update_date) VALUES (1067246875800000076, 'testTask', 'wjp', '0 0/30 * * * ?', 0, '有参测试，多个参数使用json', 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO sys_mail_template(id, name, subject, content, create_date) VALUES (1067246875800000077, '验证码模板', '注册验证码', '

注册验证码：${code}

', now()); INSERT INTO tb_alipay_notify_log(id, out_trade_no, total_amount, buyer_pay_amount, receipt_amount, invoice_amount, notify_id, buyer_id, seller_id, trade_no, trade_status, create_date) VALUES (1343493644518195201, 1343491774781419523, 3600.00, 3600.00, 3600.00, 3600.00, '2020122800222174658006930510128003', '2088102177806934', '2088102177441441', '2020122822001406930501194003', 'TRADE_SUCCESS', now()); INSERT INTO sys_post(id, post_code, post_name, sort, status, creator, create_date, updater, update_date) VALUES (1341597192832811009, 'tech', '技术岗', 0, 1, 1067246875800000001, now(), 1067246875800000001, now()); INSERT INTO tb_excel_data(id, real_name, user_identity, address, join_date, class_name, creator, create_date) VALUES (1343762012112445441, '大力', '430212199910102980', '上海市长宁区中山公园', now(), '姚班2101', 1067246875800000001, now()); -- quartz自带表结构 DROP TABLE IF EXISTS QRTZ_FIRED_TRIGGERS; DROP TABLE IF EXISTS QRTZ_PAUSED_TRIGGER_GRPS; DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE; DROP TABLE IF EXISTS QRTZ_LOCKS; DROP TABLE IF EXISTS QRTZ_SIMPLE_TRIGGERS; DROP TABLE IF EXISTS QRTZ_SIMPROP_TRIGGERS; DROP TABLE IF EXISTS QRTZ_CRON_TRIGGERS; DROP TABLE IF EXISTS QRTZ_BLOB_TRIGGERS; DROP TABLE IF EXISTS QRTZ_TRIGGERS; DROP TABLE IF EXISTS QRTZ_JOB_DETAILS; DROP TABLE IF EXISTS QRTZ_CALENDARS; create table QRTZ_JOB_DETAILS ( sched_name varchar(120) not null, job_name varchar(200) not null, job_group varchar(200) not null, description varchar(250) null, job_class_name varchar(250) not null, is_durable varchar(1) not null, is_nonconcurrent varchar(1) not null, is_update_data varchar(1) not null, requests_recovery varchar(1) not null, job_data blob null, primary key (sched_name, job_name, job_group) ); create table QRTZ_TRIGGERS ( sched_name varchar(120) not null, trigger_name varchar(200) not null, trigger_group varchar(200) not null, job_name varchar(200) not null, job_group varchar(200) not null, description varchar(250) null, next_fire_time bigint null, prev_fire_time bigint null, priority int null, trigger_state varchar(16) not null, trigger_type varchar(8) not null, start_time bigint not null, end_time bigint null, calendar_name varchar(200) null, misfire_instr int null, job_data blob null, primary key (sched_name, trigger_name, trigger_group), foreign key (sched_name, job_name, job_group) references QRTZ_JOB_DETAILS(sched_name, job_name, job_group) ); create table QRTZ_SIMPLE_TRIGGERS ( sched_name varchar(120) not null, trigger_name varchar(200) not null, trigger_group varchar(200) not null, repeat_count bigint not null, repeat_interval bigint not null, times_triggered bigint not null, primary key (sched_name, trigger_name, trigger_group), foreign key (sched_name, trigger_name, trigger_group) references QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group) ); create table QRTZ_CRON_TRIGGERS ( sched_name varchar(120) not null, trigger_name varchar(200) not null, trigger_group varchar(200) not null, cron_expression varchar(200) not null, time_zone_id varchar(80), primary key (sched_name, trigger_name, trigger_group), foreign key (sched_name, trigger_name, trigger_group) references QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group) ); create table QRTZ_BLOB_TRIGGERS ( sched_name varchar(120) not null, trigger_name varchar(200) not null, trigger_group varchar(200) not null, blob_data blob null, primary key (sched_name, trigger_name, trigger_group), foreign key (sched_name, trigger_name, trigger_group) references QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group) ); create table QRTZ_CALENDARS ( sched_name varchar(120) not null, calendar_name varchar(200) not null, calendar blob not null, primary key (sched_name, calendar_name) ); create table QRTZ_PAUSED_TRIGGER_GRPS ( sched_name varchar(120) not null, trigger_group varchar(200) not null, primary key (sched_name, trigger_group) ); create table QRTZ_FIRED_TRIGGERS ( sched_name varchar(120) not null, entry_id varchar(95) not null, trigger_name varchar(200) not null, trigger_group varchar(200) not null, instance_name varchar(200) not null, fired_time bigint not null, sched_time bigint not null, priority int not null, state varchar(16) not null, job_name varchar(200) null, job_group varchar(200) null, is_nonconcurrent varchar(1) null, requests_recovery varchar(1) null, primary key (sched_name, entry_id) ); create table QRTZ_SCHEDULER_STATE ( sched_name varchar(120) not null, instance_name varchar(200) not null, last_checkin_time bigint not null, checkin_interval bigint not null, primary key (sched_name, instance_name) ); create table QRTZ_LOCKS ( sched_name varchar(120) not null, lock_name varchar(40) not null, primary key (sched_name, lock_name) ); create table QRTZ_SIMPROP_TRIGGERS ( sched_name varchar(120) not null, trigger_name varchar(200) not null, trigger_group varchar(200) not null, str_prop_1 varchar(512) null, str_prop_2 varchar(512) null, str_prop_3 varchar(512) null, int_prop_1 int null, int_prop_2 int null, long_prop_1 bigint null, long_prop_2 bigint null, dec_prop_1 numeric(13,4) null, dec_prop_2 numeric(13,4) null, bool_prop_1 varchar(1) null, bool_prop_2 varchar(1) null, primary key (sched_name, trigger_name, trigger_group), foreign key (sched_name, trigger_name, trigger_group) references QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group) ); -- flowable表结构 create table ACT_GE_PROPERTY ( NAME_ NVARCHAR2(64), VALUE_ NVARCHAR2(300), REV_ INTEGER, primary key (NAME_) ); create table ACT_GE_BYTEARRAY ( ID_ NVARCHAR2(64), REV_ INTEGER, NAME_ NVARCHAR2(255), DEPLOYMENT_ID_ NVARCHAR2(64), BYTES_ BLOB, GENERATED_ NUMBER(1,0) CHECK (GENERATED_ IN (1,0)), primary key (ID_) ); insert into ACT_GE_PROPERTY values ('common.schema.version', '7.0.0.0', 1); insert into ACT_GE_PROPERTY values ('next.dbid', '1', 1); create table ACT_RU_ENTITYLINK ( ID_ NVARCHAR2(64), REV_ INTEGER, CREATE_TIME_ TIMESTAMP(6), LINK_TYPE_ NVARCHAR2(255), SCOPE_ID_ NVARCHAR2(255), SUB_SCOPE_ID_ NVARCHAR2(255), SCOPE_TYPE_ NVARCHAR2(255), SCOPE_DEFINITION_ID_ NVARCHAR2(255), PARENT_ELEMENT_ID_ NVARCHAR2(255), REF_SCOPE_ID_ NVARCHAR2(255), REF_SCOPE_TYPE_ NVARCHAR2(255), REF_SCOPE_DEFINITION_ID_ NVARCHAR2(255), ROOT_SCOPE_ID_ NVARCHAR2(255), ROOT_SCOPE_TYPE_ NVARCHAR2(255), HIERARCHY_TYPE_ NVARCHAR2(255), primary key (ID_) ); create index ACT_IDX_ENT_LNK_SCOPE on ACT_RU_ENTITYLINK(SCOPE_ID_, SCOPE_TYPE_, LINK_TYPE_); create index ACT_IDX_ENT_LNK_REF_SCOPE on ACT_RU_ENTITYLINK(REF_SCOPE_ID_, REF_SCOPE_TYPE_, LINK_TYPE_); create index ACT_IDX_ENT_LNK_ROOT_SCOPE on ACT_RU_ENTITYLINK(ROOT_SCOPE_ID_, ROOT_SCOPE_TYPE_, LINK_TYPE_); create index ACT_IDX_ENT_LNK_SCOPE_DEF on ACT_RU_ENTITYLINK(SCOPE_DEFINITION_ID_, SCOPE_TYPE_, LINK_TYPE_); insert into ACT_GE_PROPERTY values ('entitylink.schema.version', '7.0.0.0', 1); create table ACT_HI_ENTITYLINK ( ID_ NVARCHAR2(64), LINK_TYPE_ NVARCHAR2(255), CREATE_TIME_ TIMESTAMP(6), SCOPE_ID_ NVARCHAR2(255), SUB_SCOPE_ID_ NVARCHAR2(255), SCOPE_TYPE_ NVARCHAR2(255), SCOPE_DEFINITION_ID_ NVARCHAR2(255), PARENT_ELEMENT_ID_ NVARCHAR2(255), REF_SCOPE_ID_ NVARCHAR2(255), REF_SCOPE_TYPE_ NVARCHAR2(255), REF_SCOPE_DEFINITION_ID_ NVARCHAR2(255), ROOT_SCOPE_ID_ NVARCHAR2(255), ROOT_SCOPE_TYPE_ NVARCHAR2(255), HIERARCHY_TYPE_ NVARCHAR2(255), primary key (ID_) ); create index ACT_IDX_HI_ENT_LNK_SCOPE on ACT_HI_ENTITYLINK(SCOPE_ID_, SCOPE_TYPE_, LINK_TYPE_); create index ACT_IDX_HI_ENT_LNK_REF_SCOPE on ACT_HI_ENTITYLINK(REF_SCOPE_ID_, REF_SCOPE_TYPE_, LINK_TYPE_); create index ACT_IDX_HI_ENT_LNK_ROOT_SCOPE on ACT_HI_ENTITYLINK(ROOT_SCOPE_ID_, ROOT_SCOPE_TYPE_, LINK_TYPE_); create index ACT_IDX_HI_ENT_LNK_SCOPE_DEF on ACT_HI_ENTITYLINK(SCOPE_DEFINITION_ID_, SCOPE_TYPE_, LINK_TYPE_); create table ACT_RU_IDENTITYLINK ( ID_ NVARCHAR2(64), REV_ INTEGER, GROUP_ID_ NVARCHAR2(255), TYPE_ NVARCHAR2(255), USER_ID_ NVARCHAR2(255), TASK_ID_ NVARCHAR2(64), PROC_INST_ID_ NVARCHAR2(64), PROC_DEF_ID_ NVARCHAR2(64), SCOPE_ID_ NVARCHAR2(255), SUB_SCOPE_ID_ NVARCHAR2(255), SCOPE_TYPE_ NVARCHAR2(255), SCOPE_DEFINITION_ID_ NVARCHAR2(255), primary key (ID_) ); create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_); create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_); create index ACT_IDX_IDENT_LNK_SCOPE on ACT_RU_IDENTITYLINK(SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_IDENT_LNK_SUB_SCOPE on ACT_RU_IDENTITYLINK(SUB_SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_IDENT_LNK_SCOPE_DEF on ACT_RU_IDENTITYLINK(SCOPE_DEFINITION_ID_, SCOPE_TYPE_); insert into ACT_GE_PROPERTY values ('identitylink.schema.version', '7.0.0.0', 1); create table ACT_HI_IDENTITYLINK ( ID_ NVARCHAR2(64), GROUP_ID_ NVARCHAR2(255), TYPE_ NVARCHAR2(255), USER_ID_ NVARCHAR2(255), TASK_ID_ NVARCHAR2(64), CREATE_TIME_ TIMESTAMP(6), PROC_INST_ID_ NVARCHAR2(64), SCOPE_ID_ NVARCHAR2(255), SUB_SCOPE_ID_ NVARCHAR2(255), SCOPE_TYPE_ NVARCHAR2(255), SCOPE_DEFINITION_ID_ NVARCHAR2(255), primary key (ID_) ); create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_); create index ACT_IDX_HI_IDENT_LNK_SCOPE on ACT_HI_IDENTITYLINK(SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_HI_IDENT_LNK_SUB_SCOPE on ACT_HI_IDENTITYLINK(SUB_SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_HI_IDENT_LNK_SCOPE_DEF on ACT_HI_IDENTITYLINK(SCOPE_DEFINITION_ID_, SCOPE_TYPE_); create table ACT_RU_JOB ( ID_ NVARCHAR2(64) NOT NULL, REV_ INTEGER, CATEGORY_ NVARCHAR2(255), TYPE_ NVARCHAR2(255) NOT NULL, LOCK_EXP_TIME_ TIMESTAMP(6), LOCK_OWNER_ NVARCHAR2(255), EXCLUSIVE_ NUMBER(1,0) CHECK (EXCLUSIVE_ IN (1,0)), EXECUTION_ID_ NVARCHAR2(64), PROCESS_INSTANCE_ID_ NVARCHAR2(64), PROC_DEF_ID_ NVARCHAR2(64), ELEMENT_ID_ NVARCHAR2(255), ELEMENT_NAME_ NVARCHAR2(255), SCOPE_ID_ NVARCHAR2(255), SUB_SCOPE_ID_ NVARCHAR2(255), SCOPE_TYPE_ NVARCHAR2(255), SCOPE_DEFINITION_ID_ NVARCHAR2(255), CORRELATION_ID_ NVARCHAR2(255), RETRIES_ INTEGER, EXCEPTION_STACK_ID_ NVARCHAR2(64), EXCEPTION_MSG_ NVARCHAR2(2000), DUEDATE_ TIMESTAMP(6), REPEAT_ NVARCHAR2(255), HANDLER_TYPE_ NVARCHAR2(255), HANDLER_CFG_ NVARCHAR2(2000), CUSTOM_VALUES_ID_ NVARCHAR2(64), CREATE_TIME_ TIMESTAMP(6), TENANT_ID_ NVARCHAR2(255) DEFAULT '', primary key (ID_) ); create table ACT_RU_TIMER_JOB ( ID_ NVARCHAR2(64) NOT NULL, REV_ INTEGER, CATEGORY_ NVARCHAR2(255), TYPE_ NVARCHAR2(255) NOT NULL, LOCK_EXP_TIME_ TIMESTAMP(6), LOCK_OWNER_ NVARCHAR2(255), EXCLUSIVE_ NUMBER(1,0) CHECK (EXCLUSIVE_ IN (1,0)), EXECUTION_ID_ NVARCHAR2(64), PROCESS_INSTANCE_ID_ NVARCHAR2(64), PROC_DEF_ID_ NVARCHAR2(64), ELEMENT_ID_ NVARCHAR2(255), ELEMENT_NAME_ NVARCHAR2(255), SCOPE_ID_ NVARCHAR2(255), SUB_SCOPE_ID_ NVARCHAR2(255), SCOPE_TYPE_ NVARCHAR2(255), SCOPE_DEFINITION_ID_ NVARCHAR2(255), CORRELATION_ID_ NVARCHAR2(255), RETRIES_ INTEGER, EXCEPTION_STACK_ID_ NVARCHAR2(64), EXCEPTION_MSG_ NVARCHAR2(2000), DUEDATE_ TIMESTAMP(6), REPEAT_ NVARCHAR2(255), HANDLER_TYPE_ NVARCHAR2(255), HANDLER_CFG_ NVARCHAR2(2000), CUSTOM_VALUES_ID_ NVARCHAR2(64), CREATE_TIME_ TIMESTAMP(6), TENANT_ID_ NVARCHAR2(255) DEFAULT '', primary key (ID_) ); create table ACT_RU_SUSPENDED_JOB ( ID_ NVARCHAR2(64) NOT NULL, REV_ INTEGER, CATEGORY_ NVARCHAR2(255), TYPE_ NVARCHAR2(255) NOT NULL, EXCLUSIVE_ NUMBER(1,0) CHECK (EXCLUSIVE_ IN (1,0)), EXECUTION_ID_ NVARCHAR2(64), PROCESS_INSTANCE_ID_ NVARCHAR2(64), PROC_DEF_ID_ NVARCHAR2(64), ELEMENT_ID_ NVARCHAR2(255), ELEMENT_NAME_ NVARCHAR2(255), SCOPE_ID_ NVARCHAR2(255), SUB_SCOPE_ID_ NVARCHAR2(255), SCOPE_TYPE_ NVARCHAR2(255), SCOPE_DEFINITION_ID_ NVARCHAR2(255), CORRELATION_ID_ NVARCHAR2(255), RETRIES_ INTEGER, EXCEPTION_STACK_ID_ NVARCHAR2(64), EXCEPTION_MSG_ NVARCHAR2(2000), DUEDATE_ TIMESTAMP(6), REPEAT_ NVARCHAR2(255), HANDLER_TYPE_ NVARCHAR2(255), HANDLER_CFG_ NVARCHAR2(2000), CUSTOM_VALUES_ID_ NVARCHAR2(64), CREATE_TIME_ TIMESTAMP(6), TENANT_ID_ NVARCHAR2(255) DEFAULT '', primary key (ID_) ); create table ACT_RU_DEADLETTER_JOB ( ID_ NVARCHAR2(64) NOT NULL, REV_ INTEGER, CATEGORY_ NVARCHAR2(255), TYPE_ NVARCHAR2(255) NOT NULL, EXCLUSIVE_ NUMBER(1,0) CHECK (EXCLUSIVE_ IN (1,0)), EXECUTION_ID_ NVARCHAR2(64), PROCESS_INSTANCE_ID_ NVARCHAR2(64), PROC_DEF_ID_ NVARCHAR2(64), ELEMENT_ID_ NVARCHAR2(255), ELEMENT_NAME_ NVARCHAR2(255), SCOPE_ID_ NVARCHAR2(255), SUB_SCOPE_ID_ NVARCHAR2(255), SCOPE_TYPE_ NVARCHAR2(255), SCOPE_DEFINITION_ID_ NVARCHAR2(255), CORRELATION_ID_ NVARCHAR2(255), EXCEPTION_STACK_ID_ NVARCHAR2(64), EXCEPTION_MSG_ NVARCHAR2(2000), DUEDATE_ TIMESTAMP(6), REPEAT_ NVARCHAR2(255), HANDLER_TYPE_ NVARCHAR2(255), HANDLER_CFG_ NVARCHAR2(2000), CUSTOM_VALUES_ID_ NVARCHAR2(64), CREATE_TIME_ TIMESTAMP(6), TENANT_ID_ NVARCHAR2(255) DEFAULT '', primary key (ID_) ); create table ACT_RU_HISTORY_JOB ( ID_ NVARCHAR2(64) NOT NULL, REV_ INTEGER, LOCK_EXP_TIME_ TIMESTAMP(6), LOCK_OWNER_ NVARCHAR2(255), RETRIES_ INTEGER, EXCEPTION_STACK_ID_ NVARCHAR2(64), EXCEPTION_MSG_ NVARCHAR2(2000), HANDLER_TYPE_ NVARCHAR2(255), HANDLER_CFG_ NVARCHAR2(2000), CUSTOM_VALUES_ID_ NVARCHAR2(64), ADV_HANDLER_CFG_ID_ NVARCHAR2(64), CREATE_TIME_ TIMESTAMP(6), SCOPE_TYPE_ NVARCHAR2(255), TENANT_ID_ NVARCHAR2(255) DEFAULT '', primary key (ID_) ); create table ACT_RU_EXTERNAL_JOB ( ID_ NVARCHAR2(64) NOT NULL, REV_ INTEGER, CATEGORY_ NVARCHAR2(255), TYPE_ NVARCHAR2(255) NOT NULL, LOCK_EXP_TIME_ TIMESTAMP(6), LOCK_OWNER_ NVARCHAR2(255), EXCLUSIVE_ NUMBER(1,0) CHECK (EXCLUSIVE_ IN (1,0)), EXECUTION_ID_ NVARCHAR2(64), PROCESS_INSTANCE_ID_ NVARCHAR2(64), PROC_DEF_ID_ NVARCHAR2(64), ELEMENT_ID_ NVARCHAR2(255), ELEMENT_NAME_ NVARCHAR2(255), SCOPE_ID_ NVARCHAR2(255), SUB_SCOPE_ID_ NVARCHAR2(255), SCOPE_TYPE_ NVARCHAR2(255), SCOPE_DEFINITION_ID_ NVARCHAR2(255), CORRELATION_ID_ NVARCHAR2(255), RETRIES_ INTEGER, EXCEPTION_STACK_ID_ NVARCHAR2(64), EXCEPTION_MSG_ NVARCHAR2(2000), DUEDATE_ TIMESTAMP(6), REPEAT_ NVARCHAR2(255), HANDLER_TYPE_ NVARCHAR2(255), HANDLER_CFG_ NVARCHAR2(2000), CUSTOM_VALUES_ID_ NVARCHAR2(64), CREATE_TIME_ TIMESTAMP(6), TENANT_ID_ NVARCHAR2(255) DEFAULT '', primary key (ID_) ); create index ACT_IDX_JOB_EXCEPTION on ACT_RU_JOB(EXCEPTION_STACK_ID_); create index ACT_IDX_JOB_CUSTOM_VAL_ID on ACT_RU_JOB(CUSTOM_VALUES_ID_); create index ACT_IDX_JOB_CORRELATION_ID on ACT_RU_JOB(CORRELATION_ID_); create index ACT_IDX_TJOB_EXCEPTION on ACT_RU_TIMER_JOB(EXCEPTION_STACK_ID_); create index ACT_IDX_TJOB_CUSTOM_VAL_ID on ACT_RU_TIMER_JOB(CUSTOM_VALUES_ID_); create index ACT_IDX_TJOB_CORRELATION_ID on ACT_RU_TIMER_JOB(CORRELATION_ID_); create index ACT_IDX_TJOB_DUEDATE on ACT_RU_TIMER_JOB(DUEDATE_); create index ACT_IDX_SJOB_EXCEPTION on ACT_RU_SUSPENDED_JOB(EXCEPTION_STACK_ID_); create index ACT_IDX_SJOB_CUSTOM_VAL_ID on ACT_RU_SUSPENDED_JOB(CUSTOM_VALUES_ID_); create index ACT_IDX_SJOB_CORRELATION_ID on ACT_RU_SUSPENDED_JOB(CORRELATION_ID_); create index ACT_IDX_DJOB_EXCEPTION on ACT_RU_DEADLETTER_JOB(EXCEPTION_STACK_ID_); create index ACT_IDX_DJOB_CUSTOM_VAL_ID on ACT_RU_DEADLETTER_JOB(CUSTOM_VALUES_ID_); create index ACT_IDX_DJOB_CORRELATION_ID on ACT_RU_DEADLETTER_JOB(CORRELATION_ID_); create index ACT_IDX_EJOB_EXCEPTION on ACT_RU_EXTERNAL_JOB(EXCEPTION_STACK_ID_); create index ACT_IDX_EJOB_CUSTOM_VAL_ID on ACT_RU_EXTERNAL_JOB(CUSTOM_VALUES_ID_); create index ACT_IDX_EJOB_CORRELATION_ID on ACT_RU_EXTERNAL_JOB(CORRELATION_ID_); alter table ACT_RU_JOB add constraint ACT_FK_JOB_EXCEPTION foreign key (EXCEPTION_STACK_ID_) references ACT_GE_BYTEARRAY (ID_); alter table ACT_RU_JOB add constraint ACT_FK_JOB_CUSTOM_VAL foreign key (CUSTOM_VALUES_ID_) references ACT_GE_BYTEARRAY (ID_); alter table ACT_RU_TIMER_JOB add constraint ACT_FK_TJOB_EXCEPTION foreign key (EXCEPTION_STACK_ID_) references ACT_GE_BYTEARRAY (ID_); alter table ACT_RU_TIMER_JOB add constraint ACT_FK_TJOB_CUSTOM_VAL foreign key (CUSTOM_VALUES_ID_) references ACT_GE_BYTEARRAY (ID_); alter table ACT_RU_SUSPENDED_JOB add constraint ACT_FK_SJOB_EXCEPTION foreign key (EXCEPTION_STACK_ID_) references ACT_GE_BYTEARRAY (ID_); alter table ACT_RU_SUSPENDED_JOB add constraint ACT_FK_SJOB_CUSTOM_VAL foreign key (CUSTOM_VALUES_ID_) references ACT_GE_BYTEARRAY (ID_); alter table ACT_RU_DEADLETTER_JOB add constraint ACT_FK_DJOB_EXCEPTION foreign key (EXCEPTION_STACK_ID_) references ACT_GE_BYTEARRAY (ID_); alter table ACT_RU_DEADLETTER_JOB add constraint ACT_FK_DJOB_CUSTOM_VAL foreign key (CUSTOM_VALUES_ID_) references ACT_GE_BYTEARRAY (ID_); alter table ACT_RU_EXTERNAL_JOB add constraint ACT_FK_EJOB_EXCEPTION foreign key (EXCEPTION_STACK_ID_) references ACT_GE_BYTEARRAY (ID_); alter table ACT_RU_EXTERNAL_JOB add constraint ACT_FK_EJOB_CUSTOM_VAL foreign key (CUSTOM_VALUES_ID_) references ACT_GE_BYTEARRAY (ID_); create index ACT_IDX_JOB_SCOPE on ACT_RU_JOB(SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_JOB_SUB_SCOPE on ACT_RU_JOB(SUB_SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_JOB_SCOPE_DEF on ACT_RU_JOB(SCOPE_DEFINITION_ID_, SCOPE_TYPE_); create index ACT_IDX_TJOB_SCOPE on ACT_RU_TIMER_JOB(SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_TJOB_SUB_SCOPE on ACT_RU_TIMER_JOB(SUB_SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_TJOB_SCOPE_DEF on ACT_RU_TIMER_JOB(SCOPE_DEFINITION_ID_, SCOPE_TYPE_); create index ACT_IDX_SJOB_SCOPE on ACT_RU_SUSPENDED_JOB(SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_SJOB_SUB_SCOPE on ACT_RU_SUSPENDED_JOB(SUB_SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_SJOB_SCOPE_DEF on ACT_RU_SUSPENDED_JOB(SCOPE_DEFINITION_ID_, SCOPE_TYPE_); create index ACT_IDX_DJOB_SCOPE on ACT_RU_DEADLETTER_JOB(SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_DJOB_SUB_SCOPE on ACT_RU_DEADLETTER_JOB(SUB_SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_DJOB_SCOPE_DEF on ACT_RU_DEADLETTER_JOB(SCOPE_DEFINITION_ID_, SCOPE_TYPE_); create index ACT_IDX_EJOB_SCOPE on ACT_RU_EXTERNAL_JOB(SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_EJOB_SUB_SCOPE on ACT_RU_EXTERNAL_JOB(SUB_SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_EJOB_SCOPE_DEF on ACT_RU_EXTERNAL_JOB(SCOPE_DEFINITION_ID_, SCOPE_TYPE_); insert into ACT_GE_PROPERTY values ('job.schema.version', '7.0.0.0', 1); create table FLW_RU_BATCH ( ID_ NVARCHAR2(64) not null, REV_ INTEGER, TYPE_ NVARCHAR2(64) not null, SEARCH_KEY_ NVARCHAR2(255), SEARCH_KEY2_ NVARCHAR2(255), CREATE_TIME_ TIMESTAMP(6) not null, COMPLETE_TIME_ TIMESTAMP(6), STATUS_ NVARCHAR2(255), BATCH_DOC_ID_ NVARCHAR2(64), TENANT_ID_ NVARCHAR2(255) default '', primary key (ID_) ); create table FLW_RU_BATCH_PART ( ID_ NVARCHAR2(64) not null, REV_ INTEGER, BATCH_ID_ NVARCHAR2(64), TYPE_ NVARCHAR2(64) not null, SCOPE_ID_ NVARCHAR2(64), SUB_SCOPE_ID_ NVARCHAR2(64), SCOPE_TYPE_ NVARCHAR2(64), SEARCH_KEY_ NVARCHAR2(255), SEARCH_KEY2_ NVARCHAR2(255), CREATE_TIME_ TIMESTAMP(6) not null, COMPLETE_TIME_ TIMESTAMP(6), STATUS_ NVARCHAR2(255), RESULT_DOC_ID_ NVARCHAR2(64), TENANT_ID_ NVARCHAR2(255) default '', primary key (ID_) ); create index FLW_IDX_BATCH_PART on FLW_RU_BATCH_PART(BATCH_ID_); alter table FLW_RU_BATCH_PART add constraint FLW_FK_BATCH_PART_PARENT foreign key (BATCH_ID_) references FLW_RU_BATCH (ID_); insert into ACT_GE_PROPERTY values ('batch.schema.version', '7.0.0.0', 1); create table ACT_RU_TASK ( ID_ NVARCHAR2(64), REV_ INTEGER, EXECUTION_ID_ NVARCHAR2(64), PROC_INST_ID_ NVARCHAR2(64), PROC_DEF_ID_ NVARCHAR2(64), TASK_DEF_ID_ NVARCHAR2(64), SCOPE_ID_ NVARCHAR2(255), SUB_SCOPE_ID_ NVARCHAR2(255), SCOPE_TYPE_ NVARCHAR2(255), SCOPE_DEFINITION_ID_ NVARCHAR2(255), PROPAGATED_STAGE_INST_ID_ NVARCHAR2(255), NAME_ NVARCHAR2(255), PARENT_TASK_ID_ NVARCHAR2(64), DESCRIPTION_ NVARCHAR2(2000), TASK_DEF_KEY_ NVARCHAR2(255), OWNER_ NVARCHAR2(255), ASSIGNEE_ NVARCHAR2(255), DELEGATION_ NVARCHAR2(64), PRIORITY_ INTEGER, CREATE_TIME_ TIMESTAMP(6), DUE_DATE_ TIMESTAMP(6), CATEGORY_ NVARCHAR2(255), SUSPENSION_STATE_ INTEGER, TENANT_ID_ NVARCHAR2(255) DEFAULT '', FORM_KEY_ NVARCHAR2(255), CLAIM_TIME_ TIMESTAMP(6), IS_COUNT_ENABLED_ NUMBER(1,0) CHECK (IS_COUNT_ENABLED_ IN (1,0)), VAR_COUNT_ INTEGER, ID_LINK_COUNT_ INTEGER, SUB_TASK_COUNT_ INTEGER, primary key (ID_) ); create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_); create index ACT_IDX_TASK_SCOPE on ACT_RU_TASK(SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_TASK_SUB_SCOPE on ACT_RU_TASK(SUB_SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_TASK_SCOPE_DEF on ACT_RU_TASK(SCOPE_DEFINITION_ID_, SCOPE_TYPE_); insert into ACT_GE_PROPERTY values ('task.schema.version', '7.0.0.0', 1); create table ACT_HI_TASKINST ( ID_ NVARCHAR2(64) not null, REV_ INTEGER default 1, PROC_DEF_ID_ NVARCHAR2(64), TASK_DEF_ID_ NVARCHAR2(64), TASK_DEF_KEY_ NVARCHAR2(255), PROC_INST_ID_ NVARCHAR2(64), EXECUTION_ID_ NVARCHAR2(64), SCOPE_ID_ NVARCHAR2(255), SUB_SCOPE_ID_ NVARCHAR2(255), SCOPE_TYPE_ NVARCHAR2(255), SCOPE_DEFINITION_ID_ NVARCHAR2(255), PROPAGATED_STAGE_INST_ID_ NVARCHAR2(255), PARENT_TASK_ID_ NVARCHAR2(64), NAME_ NVARCHAR2(255), DESCRIPTION_ NVARCHAR2(2000), OWNER_ NVARCHAR2(255), ASSIGNEE_ NVARCHAR2(255), START_TIME_ TIMESTAMP(6) not null, CLAIM_TIME_ TIMESTAMP(6), END_TIME_ TIMESTAMP(6), DURATION_ NUMBER(19,0), DELETE_REASON_ NVARCHAR2(2000), PRIORITY_ INTEGER, DUE_DATE_ TIMESTAMP(6), FORM_KEY_ NVARCHAR2(255), CATEGORY_ NVARCHAR2(255), TENANT_ID_ NVARCHAR2(255) default '', LAST_UPDATED_TIME_ TIMESTAMP(6), primary key (ID_) ); create table ACT_HI_TSK_LOG ( ID_ NUMBER(19), TYPE_ NVARCHAR2(64), TASK_ID_ NVARCHAR2(64) not null, TIME_STAMP_ TIMESTAMP(6) not null, USER_ID_ NVARCHAR2(255), DATA_ NVARCHAR2(2000), EXECUTION_ID_ NVARCHAR2(64), PROC_INST_ID_ NVARCHAR2(64), PROC_DEF_ID_ NVARCHAR2(64), SCOPE_ID_ NVARCHAR2(255), SCOPE_DEFINITION_ID_ NVARCHAR2(255), SUB_SCOPE_ID_ NVARCHAR2(255), SCOPE_TYPE_ NVARCHAR2(255), TENANT_ID_ NVARCHAR2(255) default '', primary key (ID_) ); create sequence act_hi_task_evt_log_seq start with 1 increment by 1; create index ACT_IDX_HI_TASK_SCOPE on ACT_HI_TASKINST(SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_HI_TASK_SUB_SCOPE on ACT_HI_TASKINST(SUB_SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_HI_TASK_SCOPE_DEF on ACT_HI_TASKINST(SCOPE_DEFINITION_ID_, SCOPE_TYPE_); create table ACT_RU_VARIABLE ( ID_ NVARCHAR2(64) not null, REV_ INTEGER, TYPE_ NVARCHAR2(255) not null, NAME_ NVARCHAR2(255) not null, EXECUTION_ID_ NVARCHAR2(64), PROC_INST_ID_ NVARCHAR2(64), TASK_ID_ NVARCHAR2(64), SCOPE_ID_ NVARCHAR2(255), SUB_SCOPE_ID_ NVARCHAR2(255), SCOPE_TYPE_ NVARCHAR2(255), BYTEARRAY_ID_ NVARCHAR2(64), DOUBLE_ NUMBER(*,10), LONG_ NUMBER(19,0), TEXT_ NVARCHAR2(2000), TEXT2_ NVARCHAR2(2000), META_INFO_ NVARCHAR2(2000), primary key (ID_) ); create index ACT_IDX_RU_VAR_SCOPE_ID_TYPE on ACT_RU_VARIABLE(SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_RU_VAR_SUB_ID_TYPE on ACT_RU_VARIABLE(SUB_SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_VAR_BYTEARRAY on ACT_RU_VARIABLE(BYTEARRAY_ID_); alter table ACT_RU_VARIABLE add constraint ACT_FK_VAR_BYTEARRAY foreign key (BYTEARRAY_ID_) references ACT_GE_BYTEARRAY (ID_); insert into ACT_GE_PROPERTY values ('variable.schema.version', '7.0.0.0', 1); create table ACT_HI_VARINST ( ID_ NVARCHAR2(64) not null, REV_ INTEGER default 1, PROC_INST_ID_ NVARCHAR2(64), EXECUTION_ID_ NVARCHAR2(64), TASK_ID_ NVARCHAR2(64), NAME_ NVARCHAR2(255) not null, VAR_TYPE_ NVARCHAR2(100), SCOPE_ID_ NVARCHAR2(255), SUB_SCOPE_ID_ NVARCHAR2(255), SCOPE_TYPE_ NVARCHAR2(255), BYTEARRAY_ID_ NVARCHAR2(64), DOUBLE_ NUMBER(*,10), LONG_ NUMBER(19,0), TEXT_ NVARCHAR2(2000), TEXT2_ NVARCHAR2(2000), CREATE_TIME_ TIMESTAMP(6), LAST_UPDATED_TIME_ TIMESTAMP(6), META_INFO_ NVARCHAR2(2000), primary key (ID_) ); create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_); create index ACT_IDX_HI_VAR_SCOPE_ID_TYPE on ACT_HI_VARINST(SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_HI_VAR_SUB_ID_TYPE on ACT_HI_VARINST(SUB_SCOPE_ID_, SCOPE_TYPE_); create table ACT_RU_EVENT_SUBSCR ( ID_ NVARCHAR2(64) not null, REV_ integer, EVENT_TYPE_ NVARCHAR2(255) not null, EVENT_NAME_ NVARCHAR2(255), EXECUTION_ID_ NVARCHAR2(64), PROC_INST_ID_ NVARCHAR2(64), ACTIVITY_ID_ NVARCHAR2(64), CONFIGURATION_ NVARCHAR2(255), CREATED_ TIMESTAMP(6) not null, PROC_DEF_ID_ NVARCHAR2(64), SUB_SCOPE_ID_ NVARCHAR2(64), SCOPE_ID_ NVARCHAR2(64), SCOPE_DEFINITION_ID_ NVARCHAR2(64), SCOPE_TYPE_ NVARCHAR2(64), LOCK_TIME_ TIMESTAMP(6), LOCK_OWNER_ NVARCHAR2(255), TENANT_ID_ NVARCHAR2(255) DEFAULT '', primary key (ID_) ); create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_); create index ACT_IDX_EVENT_SUBSCR on ACT_RU_EVENT_SUBSCR(EXECUTION_ID_); create index ACT_IDX_EVENT_SUBSCR_SCOPEREF_ on ACT_RU_EVENT_SUBSCR(SCOPE_ID_, SCOPE_TYPE_); insert into ACT_GE_PROPERTY values ('eventsubscription.schema.version', '7.0.0.0', 1); create table ACT_RE_DEPLOYMENT ( ID_ NVARCHAR2(64), NAME_ NVARCHAR2(255), CATEGORY_ NVARCHAR2(255), KEY_ NVARCHAR2(255), TENANT_ID_ NVARCHAR2(255) DEFAULT '', DEPLOY_TIME_ TIMESTAMP(6), DERIVED_FROM_ NVARCHAR2(64), DERIVED_FROM_ROOT_ NVARCHAR2(64), PARENT_DEPLOYMENT_ID_ NVARCHAR2(255), ENGINE_VERSION_ NVARCHAR2(255), primary key (ID_) ); create table ACT_RE_MODEL ( ID_ NVARCHAR2(64) not null, REV_ INTEGER, NAME_ NVARCHAR2(255), KEY_ NVARCHAR2(255), CATEGORY_ NVARCHAR2(255), CREATE_TIME_ TIMESTAMP(6), LAST_UPDATE_TIME_ TIMESTAMP(6), VERSION_ INTEGER, META_INFO_ NVARCHAR2(2000), DEPLOYMENT_ID_ NVARCHAR2(64), EDITOR_SOURCE_VALUE_ID_ NVARCHAR2(64), EDITOR_SOURCE_EXTRA_VALUE_ID_ NVARCHAR2(64), TENANT_ID_ NVARCHAR2(255) DEFAULT '', primary key (ID_) ); create table ACT_RU_EXECUTION ( ID_ NVARCHAR2(64), REV_ INTEGER, PROC_INST_ID_ NVARCHAR2(64), BUSINESS_KEY_ NVARCHAR2(255), PARENT_ID_ NVARCHAR2(64), PROC_DEF_ID_ NVARCHAR2(64), SUPER_EXEC_ NVARCHAR2(64), ROOT_PROC_INST_ID_ NVARCHAR2(64), ACT_ID_ NVARCHAR2(255), IS_ACTIVE_ NUMBER(1,0) CHECK (IS_ACTIVE_ IN (1,0)), IS_CONCURRENT_ NUMBER(1,0) CHECK (IS_CONCURRENT_ IN (1,0)), IS_SCOPE_ NUMBER(1,0) CHECK (IS_SCOPE_ IN (1,0)), IS_EVENT_SCOPE_ NUMBER(1,0) CHECK (IS_EVENT_SCOPE_ IN (1,0)), IS_MI_ROOT_ NUMBER(1,0) CHECK (IS_MI_ROOT_ IN (1,0)), SUSPENSION_STATE_ INTEGER, CACHED_ENT_STATE_ INTEGER, TENANT_ID_ NVARCHAR2(255) DEFAULT '', NAME_ NVARCHAR2(255), START_ACT_ID_ NVARCHAR2(255), START_TIME_ TIMESTAMP(6), START_USER_ID_ NVARCHAR2(255), LOCK_TIME_ TIMESTAMP(6), LOCK_OWNER_ NVARCHAR2(255), IS_COUNT_ENABLED_ NUMBER(1,0) CHECK (IS_COUNT_ENABLED_ IN (1,0)), EVT_SUBSCR_COUNT_ INTEGER, TASK_COUNT_ INTEGER, JOB_COUNT_ INTEGER, TIMER_JOB_COUNT_ INTEGER, SUSP_JOB_COUNT_ INTEGER, DEADLETTER_JOB_COUNT_ INTEGER, EXTERNAL_WORKER_JOB_COUNT_ INTEGER, VAR_COUNT_ INTEGER, ID_LINK_COUNT_ INTEGER, CALLBACK_ID_ NVARCHAR2(255), CALLBACK_TYPE_ NVARCHAR2(255), REFERENCE_ID_ NVARCHAR2(255), REFERENCE_TYPE_ NVARCHAR2(255), PROPAGATED_STAGE_INST_ID_ NVARCHAR2(255), BUSINESS_STATUS_ NVARCHAR2(255), primary key (ID_) ); create table ACT_RE_PROCDEF ( ID_ NVARCHAR2(64) NOT NULL, REV_ INTEGER, CATEGORY_ NVARCHAR2(255), NAME_ NVARCHAR2(255), KEY_ NVARCHAR2(255) NOT NULL, VERSION_ INTEGER NOT NULL, DEPLOYMENT_ID_ NVARCHAR2(64), RESOURCE_NAME_ NVARCHAR2(2000), DGRM_RESOURCE_NAME_ varchar(4000), DESCRIPTION_ NVARCHAR2(2000), HAS_START_FORM_KEY_ NUMBER(1,0) CHECK (HAS_START_FORM_KEY_ IN (1,0)), HAS_GRAPHICAL_NOTATION_ NUMBER(1,0) CHECK (HAS_GRAPHICAL_NOTATION_ IN (1,0)), SUSPENSION_STATE_ INTEGER, TENANT_ID_ NVARCHAR2(255) DEFAULT '', DERIVED_FROM_ NVARCHAR2(64), DERIVED_FROM_ROOT_ NVARCHAR2(64), DERIVED_VERSION_ INTEGER DEFAULT 0 NOT NULL, ENGINE_VERSION_ NVARCHAR2(255), primary key (ID_) ); create table ACT_EVT_LOG ( LOG_NR_ NUMBER(19), TYPE_ NVARCHAR2(64), PROC_DEF_ID_ NVARCHAR2(64), PROC_INST_ID_ NVARCHAR2(64), EXECUTION_ID_ NVARCHAR2(64), TASK_ID_ NVARCHAR2(64), TIME_STAMP_ TIMESTAMP(6) not null, USER_ID_ NVARCHAR2(255), DATA_ BLOB, LOCK_OWNER_ NVARCHAR2(255), LOCK_TIME_ TIMESTAMP(6) null, IS_PROCESSED_ NUMBER(3) default 0, primary key (LOG_NR_) ); create sequence act_evt_log_seq; create table ACT_PROCDEF_INFO ( ID_ NVARCHAR2(64) not null, PROC_DEF_ID_ NVARCHAR2(64) not null, REV_ integer, INFO_JSON_ID_ NVARCHAR2(64), primary key (ID_) ); create table ACT_RU_ACTINST ( ID_ NVARCHAR2(64) not null, REV_ INTEGER default 1, PROC_DEF_ID_ NVARCHAR2(64) not null, PROC_INST_ID_ NVARCHAR2(64) not null, EXECUTION_ID_ NVARCHAR2(64) not null, ACT_ID_ NVARCHAR2(255) not null, TASK_ID_ NVARCHAR2(64), CALL_PROC_INST_ID_ NVARCHAR2(64), ACT_NAME_ NVARCHAR2(255), ACT_TYPE_ NVARCHAR2(255) not null, ASSIGNEE_ NVARCHAR2(255), START_TIME_ TIMESTAMP(6) not null, END_TIME_ TIMESTAMP(6), DURATION_ NUMBER(19,0), TRANSACTION_ORDER_ INTEGER, DELETE_REASON_ NVARCHAR2(2000), TENANT_ID_ NVARCHAR2(255) default '', primary key (ID_) ); create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_); create index ACT_IDX_EXEC_ROOT on ACT_RU_EXECUTION(ROOT_PROC_INST_ID_); create index ACT_IDX_EXEC_REF_ID_ on ACT_RU_EXECUTION(REFERENCE_ID_); create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_); create index ACT_IDX_RU_ACTI_START on ACT_RU_ACTINST(START_TIME_); create index ACT_IDX_RU_ACTI_END on ACT_RU_ACTINST(END_TIME_); create index ACT_IDX_RU_ACTI_PROC on ACT_RU_ACTINST(PROC_INST_ID_); create index ACT_IDX_RU_ACTI_PROC_ACT on ACT_RU_ACTINST(PROC_INST_ID_, ACT_ID_); create index ACT_IDX_RU_ACTI_EXEC on ACT_RU_ACTINST(EXECUTION_ID_); create index ACT_IDX_RU_ACTI_EXEC_ACT on ACT_RU_ACTINST(EXECUTION_ID_, ACT_ID_); create index ACT_IDX_RU_ACTI_TASK on ACT_RU_ACTINST(TASK_ID_); create index ACT_IDX_BYTEAR_DEPL on ACT_GE_BYTEARRAY(DEPLOYMENT_ID_); alter table ACT_GE_BYTEARRAY add constraint ACT_FK_BYTEARR_DEPL foreign key (DEPLOYMENT_ID_) references ACT_RE_DEPLOYMENT (ID_); alter table ACT_RE_PROCDEF add constraint ACT_UNIQ_PROCDEF unique (KEY_,VERSION_, DERIVED_VERSION_, TENANT_ID_); create index ACT_IDX_EXE_PROCINST on ACT_RU_EXECUTION(PROC_INST_ID_); alter table ACT_RU_EXECUTION add constraint ACT_FK_EXE_PROCINST foreign key (PROC_INST_ID_) references ACT_RU_EXECUTION (ID_); create index ACT_IDX_EXE_PARENT on ACT_RU_EXECUTION(PARENT_ID_); alter table ACT_RU_EXECUTION add constraint ACT_FK_EXE_PARENT foreign key (PARENT_ID_) references ACT_RU_EXECUTION (ID_); create index ACT_IDX_EXE_SUPER on ACT_RU_EXECUTION(SUPER_EXEC_); alter table ACT_RU_EXECUTION add constraint ACT_FK_EXE_SUPER foreign key (SUPER_EXEC_) references ACT_RU_EXECUTION (ID_); create index ACT_IDX_EXE_PROCDEF on ACT_RU_EXECUTION(PROC_DEF_ID_); alter table ACT_RU_EXECUTION add constraint ACT_FK_EXE_PROCDEF foreign key (PROC_DEF_ID_) references ACT_RE_PROCDEF (ID_); create index ACT_IDX_TSKASS_TASK on ACT_RU_IDENTITYLINK(TASK_ID_); alter table ACT_RU_IDENTITYLINK add constraint ACT_FK_TSKASS_TASK foreign key (TASK_ID_) references ACT_RU_TASK (ID_); create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_); alter table ACT_RU_IDENTITYLINK add constraint ACT_FK_ATHRZ_PROCEDEF foreign key (PROC_DEF_ID_) references ACT_RE_PROCDEF (ID_); create index ACT_IDX_IDL_PROCINST on ACT_RU_IDENTITYLINK(PROC_INST_ID_); alter table ACT_RU_IDENTITYLINK add constraint ACT_FK_IDL_PROCINST foreign key (PROC_INST_ID_) references ACT_RU_EXECUTION (ID_); create index ACT_IDX_TASK_EXEC on ACT_RU_TASK(EXECUTION_ID_); alter table ACT_RU_TASK add constraint ACT_FK_TASK_EXE foreign key (EXECUTION_ID_) references ACT_RU_EXECUTION (ID_); create index ACT_IDX_TASK_PROCINST on ACT_RU_TASK(PROC_INST_ID_); alter table ACT_RU_TASK add constraint ACT_FK_TASK_PROCINST foreign key (PROC_INST_ID_) references ACT_RU_EXECUTION (ID_); create index ACT_IDX_TASK_PROCDEF on ACT_RU_TASK(PROC_DEF_ID_); alter table ACT_RU_TASK add constraint ACT_FK_TASK_PROCDEF foreign key (PROC_DEF_ID_) references ACT_RE_PROCDEF (ID_); create index ACT_IDX_VAR_EXE on ACT_RU_VARIABLE(EXECUTION_ID_); alter table ACT_RU_VARIABLE add constraint ACT_FK_VAR_EXE foreign key (EXECUTION_ID_) references ACT_RU_EXECUTION (ID_); create index ACT_IDX_VAR_PROCINST on ACT_RU_VARIABLE(PROC_INST_ID_); alter table ACT_RU_VARIABLE add constraint ACT_FK_VAR_PROCINST foreign key (PROC_INST_ID_) references ACT_RU_EXECUTION(ID_); create index ACT_IDX_JOB_EXECUTION_ID on ACT_RU_JOB(EXECUTION_ID_); alter table ACT_RU_JOB add constraint ACT_FK_JOB_EXECUTION foreign key (EXECUTION_ID_) references ACT_RU_EXECUTION (ID_); create index ACT_IDX_JOB_PROC_INST_ID on ACT_RU_JOB(PROCESS_INSTANCE_ID_); alter table ACT_RU_JOB add constraint ACT_FK_JOB_PROCESS_INSTANCE foreign key (PROCESS_INSTANCE_ID_) references ACT_RU_EXECUTION (ID_); create index ACT_IDX_JOB_PROC_DEF_ID on ACT_RU_JOB(PROC_DEF_ID_); alter table ACT_RU_JOB add constraint ACT_FK_JOB_PROC_DEF foreign key (PROC_DEF_ID_) references ACT_RE_PROCDEF (ID_); create index ACT_IDX_TJOB_EXECUTION_ID on ACT_RU_TIMER_JOB(EXECUTION_ID_); alter table ACT_RU_TIMER_JOB add constraint ACT_FK_TJOB_EXECUTION foreign key (EXECUTION_ID_) references ACT_RU_EXECUTION (ID_); create index ACT_IDX_TJOB_PROC_INST_ID on ACT_RU_TIMER_JOB(PROCESS_INSTANCE_ID_); alter table ACT_RU_TIMER_JOB add constraint ACT_FK_TJOB_PROCESS_INSTANCE foreign key (PROCESS_INSTANCE_ID_) references ACT_RU_EXECUTION (ID_); create index ACT_IDX_TJOB_PROC_DEF_ID on ACT_RU_TIMER_JOB(PROC_DEF_ID_); alter table ACT_RU_TIMER_JOB add constraint ACT_FK_TJOB_PROC_DEF foreign key (PROC_DEF_ID_) references ACT_RE_PROCDEF (ID_); create index ACT_IDX_SJOB_EXECUTION_ID on ACT_RU_SUSPENDED_JOB(EXECUTION_ID_); alter table ACT_RU_SUSPENDED_JOB add constraint ACT_FK_SJOB_EXECUTION foreign key (EXECUTION_ID_) references ACT_RU_EXECUTION (ID_); create index ACT_IDX_SJOB_PROC_INST_ID on ACT_RU_SUSPENDED_JOB(PROCESS_INSTANCE_ID_); alter table ACT_RU_SUSPENDED_JOB add constraint ACT_FK_SJOB_PROCESS_INSTANCE foreign key (PROCESS_INSTANCE_ID_) references ACT_RU_EXECUTION (ID_); create index ACT_IDX_SJOB_PROC_DEF_ID on ACT_RU_SUSPENDED_JOB(PROC_DEF_ID_); alter table ACT_RU_SUSPENDED_JOB add constraint ACT_FK_SJOB_PROC_DEF foreign key (PROC_DEF_ID_) references ACT_RE_PROCDEF (ID_); create index ACT_IDX_DJOB_EXECUTION_ID on ACT_RU_DEADLETTER_JOB(EXECUTION_ID_); alter table ACT_RU_DEADLETTER_JOB add constraint ACT_FK_DJOB_EXECUTION foreign key (EXECUTION_ID_) references ACT_RU_EXECUTION (ID_); create index ACT_IDX_DJOB_PROC_INST_ID on ACT_RU_DEADLETTER_JOB(PROCESS_INSTANCE_ID_); alter table ACT_RU_DEADLETTER_JOB add constraint ACT_FK_DJOB_PROCESS_INSTANCE foreign key (PROCESS_INSTANCE_ID_) references ACT_RU_EXECUTION (ID_); create index ACT_IDX_DJOB_PROC_DEF_ID on ACT_RU_DEADLETTER_JOB(PROC_DEF_ID_); alter table ACT_RU_DEADLETTER_JOB add constraint ACT_FK_DJOB_PROC_DEF foreign key (PROC_DEF_ID_) references ACT_RE_PROCDEF (ID_); alter table ACT_RU_EVENT_SUBSCR add constraint ACT_FK_EVENT_EXEC foreign key (EXECUTION_ID_) references ACT_RU_EXECUTION(ID_); create index ACT_IDX_MODEL_SOURCE on ACT_RE_MODEL(EDITOR_SOURCE_VALUE_ID_); alter table ACT_RE_MODEL add constraint ACT_FK_MODEL_SOURCE foreign key (EDITOR_SOURCE_VALUE_ID_) references ACT_GE_BYTEARRAY (ID_); create index ACT_IDX_MODEL_SOURCE_EXTRA on ACT_RE_MODEL(EDITOR_SOURCE_EXTRA_VALUE_ID_); alter table ACT_RE_MODEL add constraint ACT_FK_MODEL_SOURCE_EXTRA foreign key (EDITOR_SOURCE_EXTRA_VALUE_ID_) references ACT_GE_BYTEARRAY (ID_); create index ACT_IDX_MODEL_DEPLOYMENT on ACT_RE_MODEL(DEPLOYMENT_ID_); alter table ACT_RE_MODEL add constraint ACT_FK_MODEL_DEPLOYMENT foreign key (DEPLOYMENT_ID_) references ACT_RE_DEPLOYMENT (ID_); create index ACT_IDX_PROCDEF_INFO_JSON on ACT_PROCDEF_INFO(INFO_JSON_ID_); alter table ACT_PROCDEF_INFO add constraint ACT_FK_INFO_JSON_BA foreign key (INFO_JSON_ID_) references ACT_GE_BYTEARRAY (ID_); create index ACT_IDX_PROCDEF_INFO_PROC on ACT_PROCDEF_INFO(PROC_DEF_ID_); alter table ACT_PROCDEF_INFO add constraint ACT_FK_INFO_PROCDEF foreign key (PROC_DEF_ID_) references ACT_RE_PROCDEF (ID_); alter table ACT_PROCDEF_INFO add constraint ACT_UNIQ_INFO_PROCDEF unique (PROC_DEF_ID_); insert into ACT_GE_PROPERTY values ('schema.version', '7.0.0.0', 1); insert into ACT_GE_PROPERTY values ('schema.history', 'create(7.0.0.0)', 1); create table ACT_HI_PROCINST ( ID_ NVARCHAR2(64) not null, REV_ INTEGER default 1, PROC_INST_ID_ NVARCHAR2(64) not null, BUSINESS_KEY_ NVARCHAR2(255), PROC_DEF_ID_ NVARCHAR2(64) not null, START_TIME_ TIMESTAMP(6) not null, END_TIME_ TIMESTAMP(6), DURATION_ NUMBER(19,0), START_USER_ID_ NVARCHAR2(255), START_ACT_ID_ NVARCHAR2(255), END_ACT_ID_ NVARCHAR2(255), SUPER_PROCESS_INSTANCE_ID_ NVARCHAR2(64), DELETE_REASON_ NVARCHAR2(2000), TENANT_ID_ NVARCHAR2(255) default '', NAME_ NVARCHAR2(255), CALLBACK_ID_ NVARCHAR2(255), CALLBACK_TYPE_ NVARCHAR2(255), REFERENCE_ID_ NVARCHAR2(255), REFERENCE_TYPE_ NVARCHAR2(255), PROPAGATED_STAGE_INST_ID_ NVARCHAR2(255), BUSINESS_STATUS_ NVARCHAR2(255), primary key (ID_), unique (PROC_INST_ID_) ); create table ACT_HI_ACTINST ( ID_ NVARCHAR2(64) not null, REV_ INTEGER default 1, PROC_DEF_ID_ NVARCHAR2(64) not null, PROC_INST_ID_ NVARCHAR2(64) not null, EXECUTION_ID_ NVARCHAR2(64) not null, ACT_ID_ NVARCHAR2(255) not null, TASK_ID_ NVARCHAR2(64), CALL_PROC_INST_ID_ NVARCHAR2(64), ACT_NAME_ NVARCHAR2(255), ACT_TYPE_ NVARCHAR2(255) not null, ASSIGNEE_ NVARCHAR2(255), START_TIME_ TIMESTAMP(6) not null, END_TIME_ TIMESTAMP(6), TRANSACTION_ORDER_ INTEGER, DURATION_ NUMBER(19,0), DELETE_REASON_ NVARCHAR2(2000), TENANT_ID_ NVARCHAR2(255) default '', primary key (ID_) ); create table ACT_HI_DETAIL ( ID_ NVARCHAR2(64) not null, TYPE_ NVARCHAR2(255) not null, PROC_INST_ID_ NVARCHAR2(64), EXECUTION_ID_ NVARCHAR2(64), TASK_ID_ NVARCHAR2(64), ACT_INST_ID_ NVARCHAR2(64), NAME_ NVARCHAR2(255) not null, VAR_TYPE_ NVARCHAR2(64), REV_ INTEGER, TIME_ TIMESTAMP(6) not null, BYTEARRAY_ID_ NVARCHAR2(64), DOUBLE_ NUMBER(*,10), LONG_ NUMBER(19,0), TEXT_ NVARCHAR2(2000), TEXT2_ NVARCHAR2(2000), primary key (ID_) ); create table ACT_HI_COMMENT ( ID_ NVARCHAR2(64) not null, TYPE_ NVARCHAR2(255), TIME_ TIMESTAMP(6) not null, USER_ID_ NVARCHAR2(255), TASK_ID_ NVARCHAR2(64), PROC_INST_ID_ NVARCHAR2(64), ACTION_ NVARCHAR2(255), MESSAGE_ NVARCHAR2(2000), FULL_MSG_ BLOB, primary key (ID_) ); create table ACT_HI_ATTACHMENT ( ID_ NVARCHAR2(64) not null, REV_ INTEGER, USER_ID_ NVARCHAR2(255), NAME_ NVARCHAR2(255), DESCRIPTION_ NVARCHAR2(2000), TYPE_ NVARCHAR2(255), TASK_ID_ NVARCHAR2(64), PROC_INST_ID_ NVARCHAR2(64), URL_ NVARCHAR2(2000), CONTENT_ID_ NVARCHAR2(64), TIME_ TIMESTAMP(6), primary key (ID_) ); create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_); create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_); create index ACT_IDX_HI_PRO_SUPER_PROCINST on ACT_HI_PROCINST(SUPER_PROCESS_INSTANCE_ID_); create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_); create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_); create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_); create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_); create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_); create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_); create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_); create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_); create index ACT_IDX_HI_PROCVAR_TASK_ID on ACT_HI_VARINST(TASK_ID_); create index ACT_IDX_HI_PROCVAR_EXE on ACT_HI_VARINST(EXECUTION_ID_); create index ACT_IDX_HI_IDENT_LNK_TASK on ACT_HI_IDENTITYLINK(TASK_ID_); create index ACT_IDX_HI_IDENT_LNK_PROCINST on ACT_HI_IDENTITYLINK(PROC_INST_ID_); create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_); create index ACT_IDX_HI_ACT_INST_EXEC on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_); create index ACT_IDX_HI_TASK_INST_PROCINST on ACT_HI_TASKINST(PROC_INST_ID_); create table ACT_ID_PROPERTY ( NAME_ NVARCHAR2(64), VALUE_ NVARCHAR2(300), REV_ INTEGER, primary key (NAME_) ); insert into ACT_ID_PROPERTY values ('schema.version', '7.0.0.0', 1); create table ACT_ID_BYTEARRAY ( ID_ NVARCHAR2(64), REV_ INTEGER, NAME_ NVARCHAR2(255), BYTES_ BLOB, primary key (ID_) ); create table ACT_ID_GROUP ( ID_ NVARCHAR2(64), REV_ INTEGER, NAME_ NVARCHAR2(255), TYPE_ NVARCHAR2(255), primary key (ID_) ); create table ACT_ID_MEMBERSHIP ( USER_ID_ NVARCHAR2(64), GROUP_ID_ NVARCHAR2(64), primary key (USER_ID_, GROUP_ID_) ); create table ACT_ID_USER ( ID_ NVARCHAR2(64), REV_ INTEGER, FIRST_ NVARCHAR2(255), LAST_ NVARCHAR2(255), DISPLAY_NAME_ NVARCHAR2(255), EMAIL_ NVARCHAR2(255), PWD_ NVARCHAR2(255), PICTURE_ID_ NVARCHAR2(64), TENANT_ID_ NVARCHAR2(255) default '', primary key (ID_) ); create table ACT_ID_INFO ( ID_ NVARCHAR2(64), REV_ INTEGER, USER_ID_ NVARCHAR2(64), TYPE_ NVARCHAR2(64), KEY_ NVARCHAR2(255), VALUE_ NVARCHAR2(255), PASSWORD_ BLOB, PARENT_ID_ NVARCHAR2(255), primary key (ID_) ); create table ACT_ID_TOKEN ( ID_ NVARCHAR2(64) not null, REV_ INTEGER, TOKEN_VALUE_ NVARCHAR2(255), TOKEN_DATE_ TIMESTAMP(6), IP_ADDRESS_ NVARCHAR2(255), USER_AGENT_ NVARCHAR2(255), USER_ID_ NVARCHAR2(255), TOKEN_DATA_ NVARCHAR2(2000), primary key (ID_) ); create table ACT_ID_PRIV ( ID_ NVARCHAR2(64) not null, NAME_ NVARCHAR2(255) not null, primary key (ID_) ); create table ACT_ID_PRIV_MAPPING ( ID_ NVARCHAR2(64) not null, PRIV_ID_ NVARCHAR2(64) not null, USER_ID_ NVARCHAR2(255), GROUP_ID_ NVARCHAR2(255), primary key (ID_) ); create index ACT_IDX_MEMB_GROUP on ACT_ID_MEMBERSHIP(GROUP_ID_); alter table ACT_ID_MEMBERSHIP add constraint ACT_FK_MEMB_GROUP foreign key (GROUP_ID_) references ACT_ID_GROUP (ID_); create index ACT_IDX_MEMB_USER on ACT_ID_MEMBERSHIP(USER_ID_); alter table ACT_ID_MEMBERSHIP add constraint ACT_FK_MEMB_USER foreign key (USER_ID_) references ACT_ID_USER (ID_); create index ACT_IDX_PRIV_MAPPING on ACT_ID_PRIV_MAPPING(PRIV_ID_); alter table ACT_ID_PRIV_MAPPING add constraint ACT_FK_PRIV_MAPPING foreign key (PRIV_ID_) references ACT_ID_PRIV (ID_); create index ACT_IDX_PRIV_USER on ACT_ID_PRIV_MAPPING(USER_ID_); create index ACT_IDX_PRIV_GROUP on ACT_ID_PRIV_MAPPING(GROUP_ID_); alter table ACT_ID_PRIV add constraint ACT_UNIQ_PRIV_NAME unique (NAME_); CREATE TABLE FLW_EV_DATABASECHANGELOGLOCK (ID INTEGER NOT NULL, LOCKED NUMBER(1) NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR2(255), CONSTRAINT PK_FLW_EV_DATABASECHANGELOGLOC PRIMARY KEY (ID)); DELETE FROM FLW_EV_DATABASECHANGELOGLOCK; INSERT INTO FLW_EV_DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, 0); UPDATE FLW_EV_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.10.1 (192.168.10.1)', LOCKGRANTED = TO_TIMESTAMP('2022-12-21 17:24:52.826', 'YYYY-MM-DD HH24:MI:SS.FF') WHERE ID = 1 AND LOCKED = 0; CREATE TABLE FLW_EV_DATABASECHANGELOG (ID VARCHAR2(255) NOT NULL, AUTHOR VARCHAR2(255) NOT NULL, FILENAME VARCHAR2(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INTEGER NOT NULL, EXECTYPE VARCHAR2(10) NOT NULL, MD5SUM VARCHAR2(35), DESCRIPTION VARCHAR2(255), COMMENTS VARCHAR2(255), TAG VARCHAR2(255), LIQUIBASE VARCHAR2(20), CONTEXTS VARCHAR2(255), LABELS VARCHAR2(255), DEPLOYMENT_ID VARCHAR2(10)); CREATE TABLE FLW_EVENT_DEPLOYMENT (ID_ VARCHAR2(255) NOT NULL, NAME_ VARCHAR2(255), CATEGORY_ VARCHAR2(255), DEPLOY_TIME_ TIMESTAMP(3), TENANT_ID_ VARCHAR2(255), PARENT_DEPLOYMENT_ID_ VARCHAR2(255), CONSTRAINT PK_FLW_EVENT_DEPLOYMENT PRIMARY KEY (ID_)); CREATE TABLE FLW_EVENT_RESOURCE (ID_ VARCHAR2(255) NOT NULL, NAME_ VARCHAR2(255), DEPLOYMENT_ID_ VARCHAR2(255), RESOURCE_BYTES_ BLOB, CONSTRAINT PK_FLW_EVENT_RESOURCE PRIMARY KEY (ID_)); CREATE TABLE FLW_EVENT_DEFINITION (ID_ VARCHAR2(255) NOT NULL, NAME_ VARCHAR2(255), VERSION_ INTEGER, KEY_ VARCHAR2(255), CATEGORY_ VARCHAR2(255), DEPLOYMENT_ID_ VARCHAR2(255), TENANT_ID_ VARCHAR2(255), RESOURCE_NAME_ VARCHAR2(255), DESCRIPTION_ VARCHAR2(255), CONSTRAINT PK_FLW_EVENT_DEFINITION PRIMARY KEY (ID_)); CREATE UNIQUE INDEX ACT_IDX_EVENT_DEF_UNIQ ON FLW_EVENT_DEFINITION(KEY_, VERSION_, TENANT_ID_); CREATE TABLE FLW_CHANNEL_DEFINITION (ID_ VARCHAR2(255) NOT NULL, NAME_ VARCHAR2(255), VERSION_ INTEGER, KEY_ VARCHAR2(255), CATEGORY_ VARCHAR2(255), DEPLOYMENT_ID_ VARCHAR2(255), CREATE_TIME_ TIMESTAMP(3), TENANT_ID_ VARCHAR2(255), RESOURCE_NAME_ VARCHAR2(255), DESCRIPTION_ VARCHAR2(255), CONSTRAINT PK_FLW_CHANNEL_DEFINITION PRIMARY KEY (ID_)); CREATE UNIQUE INDEX ACT_IDX_CHANNEL_DEF_UNIQ ON FLW_CHANNEL_DEFINITION(KEY_, VERSION_, TENANT_ID_); INSERT INTO FLW_EV_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('1', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', SYSTIMESTAMP, 1, '8:1b0c48c9cf7945be799d868a2626d687', 'createTable tableName=FLW_EVENT_DEPLOYMENT; createTable tableName=FLW_EVENT_RESOURCE; createTable tableName=FLW_EVENT_DEFINITION; createIndex indexName=ACT_IDX_EVENT_DEF_UNIQ, tableName=FLW_EVENT_DEFINITION; createTable tableName=FLW_CHANNEL_DEFIN...', '', 'EXECUTED', NULL, NULL, '4.3.5', '1643492901'); ALTER TABLE FLW_CHANNEL_DEFINITION ADD TYPE_ VARCHAR2(255); ALTER TABLE FLW_CHANNEL_DEFINITION ADD IMPLEMENTATION_ VARCHAR2(255); INSERT INTO FLW_EV_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('2', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', SYSTIMESTAMP, 2, '8:0ea825feb8e470558f0b5754352b9cda', 'addColumn tableName=FLW_CHANNEL_DEFINITION; addColumn tableName=FLW_CHANNEL_DEFINITION', '', 'EXECUTED', NULL, NULL, '4.3.5', '1643492901'); INSERT INTO FLW_EV_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('3', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', SYSTIMESTAMP, 3, '8:3c2bb293350b5cbe6504331980c9dcee', 'customChange', '', 'EXECUTED', NULL, NULL, '4.3.5', '1643492901'); UPDATE FLW_EV_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1; commit;