--
-- LightDB database dump
--
-- Dumped from database version 13.3
-- Dumped by lt_dump version 13.3
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
DROP INDEX IF EXISTS idx_21253578_idx_var_exesys;
DROP INDEX IF EXISTS idx_21253578_idx_var_execution;
DROP INDEX IF EXISTS idx_21253541_idx_task_supertask;
DROP INDEX IF EXISTS idx_21253541_idx_task_procinst;
DROP INDEX IF EXISTS idx_21253541_idx_task_exec;
DROP INDEX IF EXISTS idx_21253541_idx_task_create;
DROP INDEX IF EXISTS idx_21253541_idx_task_assignee;
... 略
DROP INDEX IF EXISTS idx_21252337_idx_exec_defid;
DROP INDEX IF EXISTS idx_21252323_idx_deployment_key;
DROP INDEX IF EXISTS idx_21252323_idx_deployment_def;
DROP INDEX IF EXISTS idx_21252313_idx_customer_name;
DROP INDEX IF EXISTS idx_21252313_idx_customer_agesex;
ALTER TABLE IF EXISTS ONLY jbpm4_variable DROP CONSTRAINT IF EXISTS idx_21253578_primary;
ALTER TABLE IF EXISTS ONLY jbpm4_task DROP CONSTRAINT IF EXISTS idx_21253541_primary;
ALTER TABLE IF EXISTS ONLY jbpm4_swimlane DROP CONSTRAINT IF EXISTS idx_21253532_primary;
ALTER TABLE IF EXISTS ONLY jbpm4_property DROP CONSTRAINT IF EXISTS idx_21253525_primary;
ALTER TABLE IF EXISTS ONLY jbpm4_participation DROP CONSTRAINT IF EXISTS idx_21253508_primary;
ALTER TABLE IF EXISTS ONLY jbpm4_lob DROP CONSTRAINT IF EXISTS idx_21253500_primary;
... 略
ALTER TABLE IF EXISTS jbpm4_ext_delegate ALTER COLUMN dbid_ DROP DEFAULT;
ALTER TABLE IF EXISTS jbpm4_ext_config ALTER COLUMN dbid_ DROP DEFAULT;
ALTER TABLE IF EXISTS jbpm4_ext_bussiness_model ALTER COLUMN dbid_ DROP DEFAULT;
ALTER TABLE IF EXISTS jbpm4_ext_bussimodel_type ALTER COLUMN dbid_ DROP DEFAULT;
DROP TABLE IF EXISTS jbpm4_variable;
DROP TABLE IF EXISTS jbpm4_task;
DROP TABLE IF EXISTS jbpm4_swimlane;
... 略
DROP SEQUENCE IF EXISTS jbpm4_ext_design_config_dbid__seq;
DROP TABLE IF EXISTS jbpm4_ext_design_config;
DROP SEQUENCE IF EXISTS jbpm4_ext_delegate_detail_dbid__seq;
DROP TABLE IF EXISTS jbpm4_ext_delegate_detail;
DROP SEQUENCE IF EXISTS jbpm4_ext_delegate_dbid__seq;
DROP TABLE IF EXISTS jbpm4_ext_delegate;
DROP SEQUENCE IF EXISTS jbpm4_ext_config_dbid__seq;
DROP TABLE IF EXISTS jbpm4_ext_config;
DROP TABLE IF EXISTS jbpm4_ext_comform_rule;
DROP TABLE IF EXISTS jbpm4_ext_comform_hist;
DROP TABLE IF EXISTS jbpm4_ext_comform_field;
DROP TABLE IF EXISTS jbpm4_ext_comform_data;
DROP SEQUENCE IF EXISTS jbpm4_ext_bussiness_model_dbid__seq;
DROP TABLE IF EXISTS jbpm4_ext_bussiness_model;
DROP SEQUENCE IF EXISTS jbpm4_ext_bussimodel_type_dbid__seq;
DROP TABLE IF EXISTS jbpm4_ext_bussimodel_type;
DROP TABLE IF EXISTS jbpm4_ext_auto_principal;
DROP TABLE IF EXISTS jbpm4_ext_attachment;
DROP TABLE IF EXISTS jbpm4_execution;
DROP TABLE IF EXISTS jbpm4_deployment;
DROP TABLE IF EXISTS jbpm4_demo_customer;
DROP SCHEMA IF EXISTS workflow12;
--
-- Name: workflow12; Type: SCHEMA; Schema: -; Owner: -
--
CREATE SCHEMA workflow12;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- Name: jbpm4_ext_delegate; Type: TABLE; Schema: workflow12; Owner: -
--
CREATE TABLE jbpm4_ext_delegate (
dbid_ bigint NOT NULL,
user_name character varying(50) DEFAULT NULL::character varying,
delegate_user character varying(50) DEFAULT NULL::character varying,
start_time timestamp with time zone,
end_time timestamp with time zone,
delegate_type character varying(4) DEFAULT NULL::character varying,
task_state character(1) DEFAULT NULL::bpchar,
delegate_task numeric(19,0) DEFAULT NULL::numeric,
withdraw_task integer,
do_as_delegator character(1) DEFAULT NULL::bpchar,
remark character varying(500) DEFAULT NULL::character varying,
createby character varying(50) DEFAULT NULL::character varying,
createtime timestamp with time zone,
inheritable_ numeric(1,0) DEFAULT NULL::numeric,
system_id_ character varying(255) DEFAULT NULL::character varying,
company_id_ character varying(255) DEFAULT NULL::character varying,
not_notice_delegator character varying(8) DEFAULT '0'::character varying,
group_type_id character varying(255) DEFAULT NULL::character varying
);
--
-- Name: TABLE jbpm4_ext_delegate; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON TABLE jbpm4_ext_delegate IS '委托关系表';
--
-- Name: COLUMN jbpm4_ext_delegate.dbid_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.dbid_ IS '主键ID';
--
-- Name: COLUMN jbpm4_ext_delegate.user_name; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.user_name IS '委托人ID';
--
-- Name: COLUMN jbpm4_ext_delegate.delegate_user; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.delegate_user IS '受托人ID';
--
-- Name: COLUMN jbpm4_ext_delegate.start_time; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.start_time IS '开始时间';
--
-- Name: COLUMN jbpm4_ext_delegate.end_time; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.end_time IS '结束时间';
--
-- Name: COLUMN jbpm4_ext_delegate.delegate_type; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.delegate_type IS '委托方式 A：全权委托，P：流程委托，T:活动节点委托';
--
-- Name: COLUMN jbpm4_ext_delegate.task_state; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.task_state IS '委托状态 0：过期，1：停用，2：启用，3：删除';
--
-- Name: COLUMN jbpm4_ext_delegate.delegate_task; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.delegate_task IS '被委托的任务（单个任务委托已改为子任务）';
--
-- Name: COLUMN jbpm4_ext_delegate.withdraw_task; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.withdraw_task IS '委托过期后是否将已经产生的委托关系清除，默认1';
--
-- Name: COLUMN jbpm4_ext_delegate.do_as_delegator; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.do_as_delegator IS '是否以委托人身份提交，默认为N';
--
-- Name: COLUMN jbpm4_ext_delegate.remark; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.remark IS '备注';
--
-- Name: COLUMN jbpm4_ext_delegate.createby; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.createby IS '创建人';
--
-- Name: COLUMN jbpm4_ext_delegate.createtime; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.createtime IS '创建时间';
--
-- Name: COLUMN jbpm4_ext_delegate.inheritable_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.inheritable_ IS '是否可以自动级联，默认为0， 暂时没用这个字段';
--
-- Name: COLUMN jbpm4_ext_delegate.system_id_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.system_id_ IS '系统号';
--
-- Name: COLUMN jbpm4_ext_delegate.company_id_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate.company_id_ IS '租户号';
--
-- Name: jbpm4_ext_delegate_dbid__seq; Type: SEQUENCE; Schema: workflow12; Owner: -
--
CREATE SEQUENCE jbpm4_ext_delegate_dbid__seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: jbpm4_ext_delegate_dbid__seq; Type: SEQUENCE OWNED BY; Schema: workflow12; Owner: -
--
ALTER SEQUENCE jbpm4_ext_delegate_dbid__seq OWNED BY jbpm4_ext_delegate.dbid_;
--
-- Name: jbpm4_ext_delegate_detail; Type: TABLE; Schema: workflow12; Owner: -
--
CREATE TABLE jbpm4_ext_delegate_detail (
dbid_ bigint NOT NULL,
delegate_id_ numeric(19,0) NOT NULL,
process_key_ character varying(255) DEFAULT NULL::character varying,
activity_name_ character varying(255) DEFAULT NULL::character varying,
ext_field_ character varying(255) DEFAULT NULL::character varying
);
--
-- Name: TABLE jbpm4_ext_delegate_detail; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON TABLE jbpm4_ext_delegate_detail IS '委托明细表';
--
-- Name: COLUMN jbpm4_ext_delegate_detail.dbid_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate_detail.dbid_ IS '主键ID';
--
-- Name: COLUMN jbpm4_ext_delegate_detail.delegate_id_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate_detail.delegate_id_ IS '委托id';
--
-- Name: COLUMN jbpm4_ext_delegate_detail.process_key_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate_detail.process_key_ IS '流程编码';
--
-- Name: COLUMN jbpm4_ext_delegate_detail.activity_name_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate_detail.activity_name_ IS '节点名称';
--
-- Name: COLUMN jbpm4_ext_delegate_detail.ext_field_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_delegate_detail.ext_field_ IS '扩展字段';
--
-- Name: jbpm4_ext_delegate_detail_dbid__seq; Type: SEQUENCE; Schema: workflow12; Owner: -
--
CREATE SEQUENCE jbpm4_ext_delegate_detail_dbid__seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: jbpm4_ext_delegate_detail_dbid__seq; Type: SEQUENCE OWNED BY; Schema: workflow12; Owner: -
--
ALTER SEQUENCE jbpm4_ext_delegate_detail_dbid__seq OWNED BY jbpm4_ext_delegate_detail.dbid_;
--
-- Name: jbpm4_ext_design_config; Type: TABLE; Schema: workflow12; Owner: -
--
CREATE TABLE jbpm4_ext_design_config (
dbid_ bigint NOT NULL,
id_ numeric(19,0) DEFAULT NULL::numeric,
typekey_ character varying(255) NOT NULL,
name_ character varying(255) DEFAULT NULL::character varying,
parent_id numeric(19,0) DEFAULT NULL::numeric,
visiable_ numeric(1,0) DEFAULT '1'::numeric,
required_ numeric(1,0) DEFAULT NULL::numeric,
remark_ character varying(512) DEFAULT NULL::character varying,
model_isvisiable_ numeric(1,0) DEFAULT '1'::numeric,
model_canmodify_ numeric(1,0) DEFAULT '1'::numeric,
model_candelete_ numeric(1,0) DEFAULT NULL::numeric,
system_id_ character varying(255) DEFAULT NULL::character varying,
company_id_ character varying(255) DEFAULT NULL::character varying
);
--
-- Name: TABLE jbpm4_ext_design_config; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON TABLE jbpm4_ext_design_config IS '设计器简化配置表';
--
-- Name: COLUMN jbpm4_ext_design_config.dbid_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_design_config.dbid_ IS '主键ID';
--
-- Name: COLUMN jbpm4_ext_design_config.id_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_design_config.id_ IS '编码ID';
--
-- Name: COLUMN jbpm4_ext_design_config.typekey_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_design_config.typekey_ IS '类型名称，包括活动类型、Tab类型、属性类型';
--
-- Name: COLUMN jbpm4_ext_design_config.name_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_design_config.name_ IS '具体的含义名称';
--
-- Name: COLUMN jbpm4_ext_design_config.parent_id; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_design_config.parent_id IS '父编码';
--
-- Name: COLUMN jbpm4_ext_design_config.visiable_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_design_config.visiable_ IS '是否需要显示';
--
-- Name: COLUMN jbpm4_ext_design_config.required_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_design_config.required_ IS '必须配置项，节点必须参数';
--
-- Name: COLUMN jbpm4_ext_design_config.remark_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_design_config.remark_ IS '关键配置介绍';
--
-- Name: COLUMN jbpm4_ext_design_config.model_isvisiable_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_design_config.model_isvisiable_ IS '固化模型属性可见性';
--
-- Name: COLUMN jbpm4_ext_design_config.model_canmodify_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_design_config.model_canmodify_ IS '固化模型属性可修改性';
--
-- Name: COLUMN jbpm4_ext_design_config.model_candelete_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_design_config.model_candelete_ IS '固化模型属性可删除性';
--
-- Name: COLUMN jbpm4_ext_design_config.system_id_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_design_config.system_id_ IS '系统号';
--
-- Name: COLUMN jbpm4_ext_design_config.company_id_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_design_config.company_id_ IS '租户号';
--
-- Name: jbpm4_ext_design_config_dbid__seq; Type: SEQUENCE; Schema: workflow12; Owner: -
--
CREATE SEQUENCE jbpm4_ext_design_config_dbid__seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: jbpm4_ext_design_config_dbid__seq; Type: SEQUENCE OWNED BY; Schema: workflow12; Owner: -
--
ALTER SEQUENCE jbpm4_ext_design_config_dbid__seq OWNED BY jbpm4_ext_design_config.dbid_;
--
-- Name: jbpm4_ext_design_log; Type: TABLE; Schema: workflow12; Owner: -
--
CREATE TABLE jbpm4_ext_design_log (
dbid_ bigint NOT NULL,
process_ bigint NOT NULL,
version_no bigint NOT NULL,
editor_id character varying(255) DEFAULT NULL::character varying,
editor_name character varying(255) DEFAULT NULL::character varying,
edit_time timestamp with time zone,
edit_type character varying(64) NOT NULL,
remark_ text,
xml_file text NOT NULL
);
--
-- Name: jbpm4_ext_design_log_dbid__seq; Type: SEQUENCE; Schema: workflow12; Owner: -
--
CREATE SEQUENCE jbpm4_ext_design_log_dbid__seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: jbpm4_ext_design_log_dbid__seq; Type: SEQUENCE OWNED BY; Schema: workflow12; Owner: -
--
ALTER SEQUENCE jbpm4_ext_design_log_dbid__seq OWNED BY jbpm4_ext_design_log.dbid_;
--
-- Name: jbpm4_ext_dict; Type: TABLE; Schema: workflow12; Owner: -
--
CREATE TABLE jbpm4_ext_dict (
dbid_ numeric(19,0) NOT NULL,
type_ character varying(50) NOT NULL,
value_ character varying(255) NOT NULL,
display_ character varying(100) NOT NULL,
renderer_ character varying(200) NOT NULL,
display_en_ character varying(100) DEFAULT NULL::character varying,
renderer_en_ character varying(100) DEFAULT NULL::character varying
);
--
-- Name: TABLE jbpm4_ext_dict; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON TABLE jbpm4_ext_dict IS '数据字典表';
--
-- Name: COLUMN jbpm4_ext_dict.dbid_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_dict.dbid_ IS '主键ID';
--
-- Name: COLUMN jbpm4_ext_dict.type_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_dict.type_ IS '类型';
--
-- Name: COLUMN jbpm4_ext_dict.value_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_dict.value_ IS '值';
--
-- Name: COLUMN jbpm4_ext_dict.display_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_dict.display_ IS '显示到界面的内容';
--
-- Name: COLUMN jbpm4_ext_dict.renderer_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_dict.renderer_ IS '渲染内容';
--
-- Name: COLUMN jbpm4_ext_dict.display_en_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_dict.display_en_ IS '渲染英文';
--
-- Name: COLUMN jbpm4_ext_dict.renderer_en_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_dict.renderer_en_ IS '渲染内容英文';
--
-- Name: jbpm4_ext_duration_report; Type: TABLE; Schema: workflow12; Owner: -
--
CREATE TABLE jbpm4_ext_duration_report (
dbid_ bigint NOT NULL,
sta_data timestamp with time zone NOT NULL,
sum_duration numeric(19,0) DEFAULT NULL::numeric,
sum_instance numeric(19,0) DEFAULT NULL::numeric,
sum_avg_duration numeric(19,0) DEFAULT NULL::numeric,
day_duration numeric(19,0) DEFAULT NULL::numeric,
day_instance numeric(19,0) DEFAULT NULL::numeric,
day_avg_duration numeric(19,0) DEFAULT NULL::numeric,
process_key_ character varying(255) NOT NULL
);
--
-- Name: TABLE jbpm4_ext_duration_report; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON TABLE jbpm4_ext_duration_report IS '实例耗时统计表';
--
-- Name: COLUMN jbpm4_ext_duration_report.dbid_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_duration_report.dbid_ IS '主键ID';
--
-- Name: COLUMN jbpm4_ext_duration_report.sta_data; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_duration_report.sta_data IS '统计日期';
--
-- Name: COLUMN jbpm4_ext_duration_report.sum_duration; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_duration_report.sum_duration IS '截止到统计日期内累计结束的实例总耗时（单位小时）';
--
-- Name: COLUMN jbpm4_ext_duration_report.sum_instance; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_duration_report.sum_instance IS '截止到统计日期内累计结束的实例总数';
--
-- Name: COLUMN jbpm4_ext_duration_report.sum_avg_duration; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_duration_report.sum_avg_duration IS '截止到统计日期内累计结束的实例平均耗时（单位小时）';
--
-- Name: COLUMN jbpm4_ext_duration_report.day_duration; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_duration_report.day_duration IS '统计日期内结束的实例总耗时（单位小时）';
--
-- Name: COLUMN jbpm4_ext_duration_report.day_instance; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_duration_report.day_instance IS '统计日期内结束的实例总数';
--
-- Name: COLUMN jbpm4_ext_duration_report.day_avg_duration; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_duration_report.day_avg_duration IS '统计日期内结束的实例平均耗时（单位小时）';
--
-- Name: COLUMN jbpm4_ext_duration_report.process_key_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_duration_report.process_key_ IS '流程编码';
--
-- Name: jbpm4_ext_duration_report_dbid__seq; Type: SEQUENCE; Schema: workflow12; Owner: -
--
CREATE SEQUENCE jbpm4_ext_duration_report_dbid__seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: jbpm4_ext_duration_report_dbid__seq; Type: SEQUENCE OWNED BY; Schema: workflow12; Owner: -
--
ALTER SEQUENCE jbpm4_ext_duration_report_dbid__seq OWNED BY jbpm4_ext_duration_report.dbid_;
--
-- Name: jbpm4_ext_exp; Type: TABLE; Schema: workflow12; Owner: -
--
CREATE TABLE jbpm4_ext_exp (
dbid_ bigint NOT NULL,
name_ character varying(200) NOT NULL,
lang_ character varying(200) DEFAULT NULL::character varying,
desc_ character varying(1024) DEFAULT NULL::character varying,
code_ character varying(1024) DEFAULT NULL::character varying,
params_in_ character varying(1024) DEFAULT NULL::character varying,
type_ character varying(20) DEFAULT NULL::character varying,
classid numeric(19,0) DEFAULT NULL::numeric,
system_id_ character varying(255) DEFAULT NULL::character varying,
company_id_ character varying(255) DEFAULT NULL::character varying,
decide_value character varying(255) DEFAULT NULL::character varying,
return_type character varying(64) DEFAULT NULL::character varying
);
--
-- Name: TABLE jbpm4_ext_exp; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON TABLE jbpm4_ext_exp IS '表达式表';
--
-- Name: COLUMN jbpm4_ext_exp.dbid_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp.dbid_ IS '主键ID';
--
-- Name: COLUMN jbpm4_ext_exp.name_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp.name_ IS '表达式名称';
--
-- Name: COLUMN jbpm4_ext_exp.lang_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp.lang_ IS '语言';
--
-- Name: COLUMN jbpm4_ext_exp.desc_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp.desc_ IS '描述';
--
-- Name: COLUMN jbpm4_ext_exp.code_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp.code_ IS '表达式';
--
-- Name: COLUMN jbpm4_ext_exp.params_in_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp.params_in_ IS '输入参数';
--
-- Name: COLUMN jbpm4_ext_exp.type_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp.type_ IS '表达式类型';
--
-- Name: COLUMN jbpm4_ext_exp.classid; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp.classid IS '表达式分类';
--
-- Name: COLUMN jbpm4_ext_exp.system_id_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp.system_id_ IS '系统号';
--
-- Name: COLUMN jbpm4_ext_exp.company_id_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp.company_id_ IS '租户号';
--
-- Name: COLUMN jbpm4_ext_exp.decide_value; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp.decide_value IS '支持匹配符号';
--
-- Name: COLUMN jbpm4_ext_exp.return_type; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp.return_type IS '表达式返回类型';
--
-- Name: jbpm4_ext_exp_dbid__seq; Type: SEQUENCE; Schema: workflow12; Owner: -
--
CREATE SEQUENCE jbpm4_ext_exp_dbid__seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: jbpm4_ext_exp_dbid__seq; Type: SEQUENCE OWNED BY; Schema: workflow12; Owner: -
--
ALTER SEQUENCE jbpm4_ext_exp_dbid__seq OWNED BY jbpm4_ext_exp.dbid_;
--
-- Name: jbpm4_ext_exp_type; Type: TABLE; Schema: workflow12; Owner: -
--
CREATE TABLE jbpm4_ext_exp_type (
dbid_ bigint NOT NULL,
type_name character varying(50) NOT NULL,
parent_id numeric(19,0) NOT NULL,
descript character varying(255) DEFAULT NULL::character varying,
system_id_ character varying(255) DEFAULT NULL::character varying,
company_id_ character varying(255) DEFAULT NULL::character varying,
real_root_ numeric(1,0) DEFAULT '0'::numeric
);
--
-- Name: TABLE jbpm4_ext_exp_type; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON TABLE jbpm4_ext_exp_type IS '表达式分类表';
--
-- Name: COLUMN jbpm4_ext_exp_type.dbid_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp_type.dbid_ IS '主键ID';
--
-- Name: COLUMN jbpm4_ext_exp_type.type_name; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp_type.type_name IS '分类名称';
--
-- Name: COLUMN jbpm4_ext_exp_type.parent_id; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp_type.parent_id IS '父id';
--
-- Name: COLUMN jbpm4_ext_exp_type.descript; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp_type.descript IS '描述';
--
-- Name: COLUMN jbpm4_ext_exp_type.system_id_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp_type.system_id_ IS '系统号';
--
-- Name: COLUMN jbpm4_ext_exp_type.company_id_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp_type.company_id_ IS '租户号';
--
-- Name: COLUMN jbpm4_ext_exp_type.real_root_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_exp_type.real_root_ IS '是否虚根';
--
-- Name: jbpm4_ext_exp_type_dbid__seq; Type: SEQUENCE; Schema: workflow12; Owner: -
--
CREATE SEQUENCE jbpm4_ext_exp_type_dbid__seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: jbpm4_ext_exp_type_dbid__seq; Type: SEQUENCE OWNED BY; Schema: workflow12; Owner: -
--
ALTER SEQUENCE jbpm4_ext_exp_type_dbid__seq OWNED BY jbpm4_ext_exp_type.dbid_;
--
-- Name: jbpm4_ext_extend_xml; Type: TABLE; Schema: workflow12; Owner: -
--
CREATE TABLE jbpm4_ext_extend_xml (
dbid_ bigint NOT NULL,
xml_ text NOT NULL,
system_id_ character varying(255) DEFAULT NULL::character varying
);
--
-- Name: TABLE jbpm4_ext_extend_xml; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON TABLE jbpm4_ext_extend_xml IS '扩展属性表';
--
-- Name: COLUMN jbpm4_ext_extend_xml.dbid_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_extend_xml.dbid_ IS '主键ID';
--
-- Name: COLUMN jbpm4_ext_extend_xml.xml_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_extend_xml.xml_ IS '扩展属性XML';
--
-- Name: COLUMN jbpm4_ext_extend_xml.system_id_; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_extend_xml.system_id_ IS '系统号';
--
-- Name: jbpm4_ext_extend_xml_dbid__seq; Type: SEQUENCE; Schema: workflow12; Owner: -
--
CREATE SEQUENCE jbpm4_ext_extend_xml_dbid__seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--
-- Name: jbpm4_ext_extend_xml_dbid__seq; Type: SEQUENCE OWNED BY; Schema: workflow12; Owner: -
--
ALTER SEQUENCE jbpm4_ext_extend_xml_dbid__seq OWNED BY jbpm4_ext_extend_xml.dbid_;
--
-- Name: jbpm4_ext_form_resreg; Type: TABLE; Schema: workflow12; Owner: -
--
CREATE TABLE jbpm4_ext_form_resreg (
uuid character varying(32) NOT NULL,
formid character varying(500) NOT NULL,
resid character varying(50) NOT NULL,
resname character varying(100) NOT NULL,
restype character varying(30) DEFAULT 'COLUMN'::character varying
);
--
-- Name: TABLE jbpm4_ext_form_resreg; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON TABLE jbpm4_ext_form_resreg IS '表单资源关系表';
--
-- Name: COLUMN jbpm4_ext_form_resreg.uuid; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_form_resreg.uuid IS '主键ID';
--
-- Name: COLUMN jbpm4_ext_form_resreg.formid; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_form_resreg.formid IS '表单id';
--
-- Name: COLUMN jbpm4_ext_form_resreg.resid; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_form_resreg.resid IS '资源id';
--
-- Name: COLUMN jbpm4_ext_form_resreg.resname; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_form_resreg.resname IS '资源名称';
--
-- Name: COLUMN jbpm4_ext_form_resreg.restype; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_form_resreg.restype IS '资源类型';
--
-- Name: jbpm4_ext_form_resstatus; Type: TABLE; Schema: workflow12; Owner: -
--
CREATE TABLE jbpm4_ext_form_resstatus (
uuid character varying(32) NOT NULL,
resuuid character varying(32) NOT NULL,
processversionid character varying(50) NOT NULL,
processnodeid character varying(150) NOT NULL,
resstatus character varying(10) DEFAULT 'w'::character varying NOT NULL
);
--
-- Name: TABLE jbpm4_ext_form_resstatus; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON TABLE jbpm4_ext_form_resstatus IS '流程资源关系表';
--
-- Name: COLUMN jbpm4_ext_form_resstatus.uuid; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_form_resstatus.uuid IS '主键ID';
--
-- Name: COLUMN jbpm4_ext_form_resstatus.resuuid; Type: COMMENT; Schema: workflow12; Owner: -
--
COMMENT ON COLUMN jbpm4_ext_form_resstatus.resuuid IS '资源主键';
COMMENT ON TABLE jbpm4_variable IS '变量表';
INSERT INTO jbpm4_ext_design_config VALUES (-1180102, 1180102, 'remark', '备注', 11801, 1, 0, NULL, 1, 1, NULL, NULL, NULL);
INSERT INTO jbpm4_ext_design_config VALUES (-106, 106, 'state', '等待', NULL, 1, 0, NULL, 1, 1, NULL, NULL, NULL);
INSERT INTO jbpm4_ext_design_config VALUES (-105, 105, 'auto', '自动', NULL, 1, 0, NULL, 1, 1, NULL, NULL, NULL);
INSERT INTO jbpm4_ext_design_config VALUES (-104, 104, 'vote', '投票', NULL, 1, 0, NULL, 1, 1, NULL, NULL, NULL);
INSERT INTO jbpm4_ext_design_config VALUES (-103, 103, 'manyapprove', '多人审批', NULL, 0, 0, NULL, 1, 1, NULL, NULL, NULL);
INSERT INTO jbpm4_ext_design_config VALUES (-102, 102, 'countersign', '会签', NULL, 1, 0, NULL, 1, 1, NULL, NULL, NULL);
INSERT INTO jbpm4_ext_design_config VALUES (-101, 101, 'task', '人工', NULL, 1, 0, NULL, 1, 1, NULL, NULL, NULL);
--
-- Data for Name: jbpm4_ext_design_log; Type: TABLE DATA; Schema: workflow12; Owner: -
--
--
-- Data for Name: jbpm4_ext_dict; Type: TABLE DATA; Schema: workflow12; Owner: -
--
INSERT INTO jbpm4_ext_dict VALUES (100201, 'workflow_formTemplate', 'PAGE_MW', 'JRES页面(PAGE_MW)', 'JRES页面', NULL, NULL);
INSERT INTO jbpm4_ext_dict VALUES (100202, 'workflow_formTemplate', 'PAGE_MDA', 'MDA页面(PAGE_MDA)', 'MDA页面', NULL, NULL);
INSERT INTO jbpm4_ext_dict VALUES (100302, 'workflow_serviceType', 'spring', 'spring', 'Spring', NULL, NULL);
INSERT INTO jbpm4_ext_dict VALUES (100303, 'workflow_serviceType', 'T2', 'T2', 'T2', NULL, NULL);
INSERT INTO jbpm4_ext_dict VALUES (700022, 'workflow_comform_rule_exec_type', '2', '任何地方都执行', '任何地方都执行', NULL, NULL);
INSERT INTO jbpm4_ext_dict VALUES (700023, 'workflow_comform_rule_exec_type', '3', '新增和修改执行', '新增和修改执行', NULL, NULL);
INSERT INTO jbpm4_ext_dict VALUES (700024, 'workflow_comform_rule_exec_type', '4', '提交的时候执行', '提交的时候执行', NULL, NULL);
INSERT INTO jbpm4_ext_dict VALUES (700025, 'workflow_comform_rule_exec_type', '5', '提交的时候弹出对话框', '提交的时候弹出对话框', NULL, NULL);
--
-- Data for Name: jbpm4_ext_probaseinfo_conf; Type: TABLE DATA; Schema: workflow12; Owner: -
--
INSERT INTO jbpm4_ext_probaseinfo_conf VALUES (-12, 'instanceRemind', '实例催办', '1', '0', 'PROCESS_ATTR', NULL, NULL);
INSERT INTO jbpm4_ext_probaseinfo_conf VALUES (-11, 'instanceOverDue', '实例逾期', '1', '0', 'PROCESS_ATTR', NULL, NULL);
INSERT INTO jbpm4_ext_probaseinfo_conf VALUES (-9, 'taskSkipNouser', '任务无候选人时自动提交', '0', '1', 'PROCESS_ATTR', NULL, NULL);
INSERT INTO jbpm4_ext_probaseinfo_conf VALUES (-8, 'ignoreExistUser', '排除参与人', '0', '1', 'PROCESS_ATTR', NULL, NULL);
INSERT INTO jbpm4_ext_probaseinfo_conf VALUES (-7, 'cancelBeforeEnd', '发起人终止设置', '0', '1', 'PROCESS_ATTR', NULL, NULL);
INSERT INTO jbpm4_ext_probaseinfo_conf VALUES (-6, 'bizRefrenceCode', '业务编码', '0', '1', 'PROCESS_ATTR', NULL, NULL);
INSERT INTO jbpm4_ext_probaseinfo_conf VALUES (-5, 'extBizType', '业务类型', '0', '1', 'PROCESS_ATTR', NULL, NULL);
INSERT INTO jbpm4_ext_probaseinfo_conf VALUES (-4, 'isPersonAll', '指定发起人', '0', '1', 'PROCESS_ATTR', NULL, NULL);
INSERT INTO jbpm4_ext_probaseinfo_conf VALUES (-3, 'canHumanStart', '发起模式', '0', '1', 'PROCESS_ATTR', NULL, NULL);
INSERT INTO jbpm4_ext_probaseinfo_conf VALUES (-2, 'proIsCommonOrBusiness', '流程类型', '0', '0', 'PROCESS_ATTR', NULL, NULL);
INSERT INTO jbpm4_ext_probaseinfo_conf VALUES (-1, 'PROCESS_ATTR', '流程基本属性', NULL, NULL, NULL, NULL, NULL);
--
-- Data for Name: jbpm4_ext_proc_editor; Type: TABLE DATA; Schema: workflow12; Owner: -
--
--
-- Data for Name: jbpm4_ext_proc_service; Type: TABLE DATA; Schema: workflow12; Owner: -
--
--
-- Name: jbpm4_ext_proc_service_dbid__seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_proc_service_dbid__seq', 1, true);
--
-- Name: jbpm4_ext_process_opr_dbid__seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_process_opr_dbid__seq', 1, true);
--
-- Name: jbpm4_ext_process_testcase_dbid__seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_process_testcase_dbid__seq', 1, true);
--
-- Name: jbpm4_ext_process_type_dbid__seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_process_type_dbid__seq', 1, true);
--
-- Name: jbpm4_ext_resource_log_dbid__seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_resource_log_dbid__seq', 1, true);
--
-- Name: jbpm4_ext_service_error_dbid__seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_service_error_dbid__seq', 1, true);
--
-- Name: jbpm4_ext_service_form_dbid__seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_service_form_dbid__seq', 1, true);
--
-- Name: jbpm4_ext_service_log_dbid_seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_service_log_dbid_seq', 1, true);
--
-- Name: jbpm4_ext_suspend_log_dbid__seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_suspend_log_dbid__seq', 1, true);
--
-- Name: jbpm4_ext_system_reg_dbid__seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_system_reg_dbid__seq', 1, true);
--
-- Name: jbpm4_ext_task_read_dbid__seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_task_read_dbid__seq', 1, true);
--
-- Name: jbpm4_ext_taskdef_detail_dbid__seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_taskdef_detail_dbid__seq', 1, true);
--
-- Name: jbpm4_ext_template_data_dbid__seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_template_data_dbid__seq', 1, true);
--
-- Name: jbpm4_ext_ver_dbid__seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_ver_dbid__seq', 1, true);
--
-- Name: jbpm4_ext_ver_opr_dbid__seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_ver_opr_dbid__seq', 1, true);
--
-- Name: jbpm4_ext_version_contextfield_dbid__seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_version_contextfield_dbid__seq', 1, true);
--
-- Name: jbpm4_ext_workingday_dbid_seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_ext_workingday_dbid_seq', 1, true);
--
-- Name: jbpm4_formtext_demo_uuid_seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_formtext_demo_uuid_seq', 1, true);
--
-- Name: jbpm4_formtext_leave_uuid_seq; Type: SEQUENCE SET; Schema: workflow12; Owner: -
--
SELECT pg_catalog.setval('jbpm4_formtext_leave_uuid_seq', 1, true);
--
-- Name: jbpm4_demo_customer idx_21252313_primary; Type: CONSTRAINT; Schema: workflow12; Owner: -
--
ALTER TABLE ONLY jbpm4_demo_customer
ADD CONSTRAINT idx_21252313_primary PRIMARY KEY (id);
CREATE INDEX idx_21253541_idx_task_assignee ON jbpm4_task USING btree (assignee_);
--
-- Name: idx_21253541_idx_task_create; Type: INDEX; Schema: workflow12; Owner: -
--
CREATE INDEX idx_21253541_idx_task_create ON jbpm4_task USING btree (create_);
--
-- Name: idx_21253541_idx_task_exec; Type: INDEX; Schema: workflow12; Owner: -
--
CREATE INDEX idx_21253541_idx_task_exec ON jbpm4_task USING btree (execution_);
--
-- Name: idx_21253541_idx_task_procinst; Type: INDEX; Schema: workflow12; Owner: -
--
CREATE INDEX idx_21253541_idx_task_procinst ON jbpm4_task USING btree (procinst_);
--
-- Name: idx_21253541_idx_task_supertask; Type: INDEX; Schema: workflow12; Owner: -
--
CREATE INDEX idx_21253541_idx_task_supertask ON jbpm4_task USING btree (supertask_);
--
-- Name: idx_21253578_idx_var_execution; Type: INDEX; Schema: workflow12; Owner: -
--
CREATE INDEX idx_21253578_idx_var_execution ON jbpm4_variable USING btree (execution_);
--
-- Name: idx_21253578_idx_var_exesys; Type: INDEX; Schema: workflow12; Owner: -
--
CREATE INDEX idx_21253578_idx_var_exesys ON jbpm4_variable USING btree (exesys_);
--
-- Name: DEFAULT PRIVILEGES FOR SEQUENCES; Type: DEFAULT ACL; Schema: workflow12; Owner: -
--
ALTER DEFAULT PRIVILEGES FOR ROLE lightdb IN SCHEMA workflow12 REVOKE ALL ON SEQUENCES FROM lightdb;
ALTER DEFAULT PRIVILEGES FOR ROLE lightdb IN SCHEMA workflow12 GRANT USAGE ON SEQUENCES TO workflow12;
--
-- Name: DEFAULT PRIVILEGES FOR TABLES; Type: DEFAULT ACL; Schema: workflow12; Owner: -
--
ALTER DEFAULT PRIVILEGES FOR ROLE lightdb IN SCHEMA workflow12 REVOKE ALL ON TABLES FROM lightdb;
ALTER DEFAULT PRIVILEGES FOR ROLE lightdb IN SCHEMA workflow12 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLES TO workflow12;
--
-- LightDB database dump complete
--