LightDB/PostgreSQL 生成可重複執行的指令碼
--
-- 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
--
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29990276/viewspace-2897237/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 防止指令碼重複執行方法指令碼
- linux指令碼完成重複執行的命令Linux指令碼
- apache_weblogic自動生成可執行指令碼ApacheWeb指令碼
- 使用nohup執行迴圈指令碼插入發現資料重複的問題指令碼
- 使用shell指令碼生成只讀許可權的sql指令碼指令碼SQL
- 生成 Linux 執行時間報告的 Bash 指令碼Linux指令碼
- 使用原生Java程式碼生成可執行Jar包JavaJAR
- php執行shell指令碼需要sudo許可權PHP指令碼
- ruby指令碼，隨機生成複雜密碼指令碼隨機密碼
- java 生成可執行jar包JavaJAR
- 生成14個可重複一次的隨機數隨機
- 將Python指令碼打包成可執行檔案Python指令碼
- 如何讓shell指令碼變成可執行檔案指令碼
- js儘量減少程式碼重複執行的次數JS
- ELF PHP 可執行程式執行後載入重型指令碼的過程PHP行程指令碼
- 執行shell指令碼指令碼
- 指令碼執行方式指令碼
- 執行Shell指令碼的方式指令碼
- Casperjs迴圈執行（重複執行不退出）JS
- MATLAB生成可執行檔案Matlab
- PostgreSQL/LightDB 不走並行是為什麼？SQL並行
- java-maven生成可執行的 jar 包JavaMavenJAR
- 怎麼生成可執行的.jar檔案???????????JAR
- 如何避免任務重複執行
- 【Shell】使用Shell指令碼快速完成SQL指令碼中重複枯燥的任務指令碼SQL
- 生成insert指令碼的指令碼指令碼
- [20231021]生成bbed的執行指令碼.txt指令碼
- [20190107]生成bbed執行指令碼:指令碼
- sqlplus動態生成linux shell指令碼並執行SQLLinux指令碼
- matlab gui 生成獨立可執行的程式MatlabGUI
- 執行Shell指令碼的方式(轉)指令碼
- 停止 FutrueBuilder 的重複重新整理和執行UI
- mybatis執行sql指令碼MyBatisSQL指令碼
- crontab執行shell指令碼指令碼
- PowerShell 指令碼執行策略指令碼
- SQL SERVER執行指令碼SQLServer指令碼
- 指令碼後臺執行指令碼
- 如何防止jQuery物件動畫重複執行jQuery物件動畫