From 089a79002f697198e9f4cbeb0ca85711d329eb52 Mon Sep 17 00:00:00 2001
From: AprilWind <2100166581@qq.com>
Date: 星期三, 15 一月 2025 19:06:42 +0800
Subject: [PATCH] update 升级warm-flow的sql语句

---
 script/sql/postgres/postgres_ry_workflow.sql |  184 +++++++++++++++++++++++----------------------
 1 files changed, 93 insertions(+), 91 deletions(-)

diff --git a/script/sql/postgres/postgres_ry_workflow.sql b/script/sql/postgres/postgres_ry_workflow.sql
index aacd145..337b066 100644
--- a/script/sql/postgres/postgres_ry_workflow.sql
+++ b/script/sql/postgres/postgres_ry_workflow.sql
@@ -3,22 +3,22 @@
 -- ----------------------------
 CREATE TABLE flow_definition
 (
-    id              int8         NOT NULL,                      -- 涓婚敭id
-    flow_code       varchar(40)  NOT NULL,                      -- 娴佺▼缂栫爜
-    flow_name       varchar(100) NOT NULL,                      -- 娴佺▼鍚嶇О
-    category        varchar(100) NULL,                          -- 娴佺▼绫诲埆
-    "version"       varchar(20)  NOT NULL,                      -- 娴佺▼鐗堟湰
-    is_publish      int2         NOT NULL DEFAULT 0,            -- 鏄惁鍙戝竷锛�0鏈彂甯� 1宸插彂甯� 9澶辨晥锛�
-    form_custom     bpchar(1) NULL DEFAULT 'N':: character varying, -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
-    form_path       varchar(100) NULL,                          -- 瀹℃壒琛ㄥ崟璺緞
-    activity_status int2         NOT NULL DEFAULT 1,            -- 娴佺▼婵�娲荤姸鎬侊紙0鎸傝捣 1婵�娲伙級
-    listener_type   varchar(100) NULL,                          -- 鐩戝惉鍣ㄧ被鍨�
-    listener_path   varchar(400) NULL,                          -- 鐩戝惉鍣ㄨ矾寰�
-    ext             varchar(500) NULL,                          -- 鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤
-    create_time     timestamp    NULL,                          -- 鍒涘缓鏃堕棿
-    update_time     timestamp    NULL,                          -- 鏇存柊鏃堕棿
-    del_flag        bpchar(1) NULL DEFAULT '0':: character varying,    -- 鍒犻櫎鏍囧織
-    tenant_id       varchar(40)  NULL,                          -- 绉熸埛id
+    id              int8         NOT NULL,                                 -- 涓婚敭id
+    flow_code       varchar(40)  NOT NULL,                                 -- 娴佺▼缂栫爜
+    flow_name       varchar(100) NOT NULL,                                 -- 娴佺▼鍚嶇О
+    category        varchar(100) NULL,                                     -- 娴佺▼绫诲埆
+    "version"       varchar(20)  NOT NULL,                                 -- 娴佺▼鐗堟湰
+    is_publish      int2         NOT NULL DEFAULT 0,                       -- 鏄惁鍙戝竷锛�0鏈彂甯� 1宸插彂甯� 9澶辨晥锛�
+    form_custom     bpchar(1)    NULL     DEFAULT 'N':: character varying, -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
+    form_path       varchar(100) NULL,                                     -- 瀹℃壒琛ㄥ崟璺緞
+    activity_status int2         NOT NULL DEFAULT 1,                       -- 娴佺▼婵�娲荤姸鎬侊紙0鎸傝捣 1婵�娲伙級
+    listener_type   varchar(100) NULL,                                     -- 鐩戝惉鍣ㄧ被鍨�
+    listener_path   varchar(400) NULL,                                     -- 鐩戝惉鍣ㄨ矾寰�
+    ext             varchar(500) NULL,                                     -- 鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤
+    create_time     timestamp    NULL,                                     -- 鍒涘缓鏃堕棿
+    update_time     timestamp    NULL,                                     -- 鏇存柊鏃堕棿
+    del_flag        bpchar(1)    NULL     DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
+    tenant_id       varchar(40)  NULL,                                     -- 绉熸埛id
     CONSTRAINT flow_definition_pkey PRIMARY KEY (id)
 );
 COMMENT ON TABLE flow_definition IS '娴佺▼瀹氫箟琛�';
@@ -56,12 +56,12 @@
     listener_path   varchar(400)  NULL,                                 -- 鐩戝惉鍣ㄨ矾寰�
     handler_type    varchar(100)  NULL,                                 -- 澶勭悊鍣ㄧ被鍨�
     handler_path    varchar(400)  NULL,                                 -- 澶勭悊鍣ㄨ矾寰�
-    form_custom     bpchar(1) NULL DEFAULT 'N':: character varying,         -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
+    form_custom     bpchar(1)     NULL DEFAULT 'N':: character varying, -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
     form_path       varchar(100)  NULL,                                 -- 瀹℃壒琛ㄥ崟璺緞
     "version"       varchar(20)   NOT NULL,                             -- 鐗堟湰
     create_time     timestamp     NULL,                                 -- 鍒涘缓鏃堕棿
     update_time     timestamp     NULL,                                 -- 鏇存柊鏃堕棿
-    del_flag        bpchar(1) NULL DEFAULT '0':: character varying,            -- 鍒犻櫎鏍囧織
+    del_flag        bpchar(1)     NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
     tenant_id       varchar(40)   NULL,                                 -- 绉熸埛id
     CONSTRAINT flow_node_pkey PRIMARY KEY (id)
 );
@@ -92,20 +92,20 @@
 
 CREATE TABLE flow_skip
 (
-    id             int8         NOT NULL,                    -- 涓婚敭id
-    definition_id  int8         NOT NULL,                    -- 娴佺▼瀹氫箟id
-    now_node_code  varchar(100) NOT NULL,                    -- 褰撳墠娴佺▼鑺傜偣鐨勭紪鐮�
-    now_node_type  int2         NULL,                        -- 褰撳墠鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
-    next_node_code varchar(100) NOT NULL,                    -- 涓嬩竴涓祦绋嬭妭鐐圭殑缂栫爜
-    next_node_type int2         NULL,                        -- 涓嬩竴涓妭鐐圭被鍨嬶紙0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
-    skip_name      varchar(100) NULL,                        -- 璺宠浆鍚嶇О
-    skip_type      varchar(40)  NULL,                        -- 璺宠浆绫诲瀷锛圥ASS瀹℃壒閫氳繃 REJECT閫�鍥烇級
-    skip_condition varchar(200) NULL,                        -- 璺宠浆鏉′欢
-    coordinate     varchar(100) NULL,                        -- 鍧愭爣
-    create_time    timestamp    NULL,                        -- 鍒涘缓鏃堕棿
-    update_time    timestamp    NULL,                        -- 鏇存柊鏃堕棿
-    del_flag       bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
-    tenant_id      varchar(40)  NULL,                        -- 绉熸埛id
+    id             int8         NOT NULL,                             -- 涓婚敭id
+    definition_id  int8         NOT NULL,                             -- 娴佺▼瀹氫箟id
+    now_node_code  varchar(100) NOT NULL,                             -- 褰撳墠娴佺▼鑺傜偣鐨勭紪鐮�
+    now_node_type  int2         NULL,                                 -- 褰撳墠鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
+    next_node_code varchar(100) NOT NULL,                             -- 涓嬩竴涓祦绋嬭妭鐐圭殑缂栫爜
+    next_node_type int2         NULL,                                 -- 涓嬩竴涓妭鐐圭被鍨嬶紙0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
+    skip_name      varchar(100) NULL,                                 -- 璺宠浆鍚嶇О
+    skip_type      varchar(40)  NULL,                                 -- 璺宠浆绫诲瀷锛圥ASS瀹℃壒閫氳繃 REJECT閫�鍥烇級
+    skip_condition varchar(200) NULL,                                 -- 璺宠浆鏉′欢
+    coordinate     varchar(100) NULL,                                 -- 鍧愭爣
+    create_time    timestamp    NULL,                                 -- 鍒涘缓鏃堕棿
+    update_time    timestamp    NULL,                                 -- 鏇存柊鏃堕棿
+    del_flag       bpchar(1)    NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
+    tenant_id      varchar(40)  NULL,                                 -- 绉熸埛id
     CONSTRAINT flow_skip_pkey PRIMARY KEY (id)
 );
 COMMENT ON TABLE flow_skip IS '鑺傜偣璺宠浆鍏宠仈琛�';
@@ -127,21 +127,21 @@
 
 CREATE TABLE flow_instance
 (
-    id              int8         NOT NULL,                                -- 涓婚敭id
-    definition_id   int8         NOT NULL,                                -- 瀵瑰簲flow_definition琛ㄧ殑id
-    business_id     varchar(40)  NOT NULL,                                -- 涓氬姟id
-    node_type       int2         NOT NULL,                                -- 鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
-    node_code       varchar(40)  NOT NULL,                                -- 娴佺▼鑺傜偣缂栫爜
-    node_name       varchar(100) NULL,                                    -- 娴佺▼鑺傜偣鍚嶇О
-    variable        text         NULL,                                    -- 浠诲姟鍙橀噺
-    flow_status     varchar(20)  NOT NULL,                                -- 娴佺▼鐘舵�侊紙0寰呮彁浜� 1瀹℃壒涓� 2 瀹℃壒閫氳繃 8宸插畬鎴� 9宸查��鍥� 10澶辨晥锛�
-    activity_status int2         NOT NULL DEFAULT 1,                      -- 娴佺▼婵�娲荤姸鎬侊紙0鎸傝捣 1婵�娲伙級
-    create_by       varchar(64)  NULL     DEFAULT '':: character varying, -- 鍒涘缓鑰�
-    create_time     timestamp    NULL,                                    -- 鍒涘缓鏃堕棿
-    update_time     timestamp    NULL,                                    -- 鏇存柊鏃堕棿
-    ext             varchar(500) NULL,                                    -- 鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤
-    del_flag        bpchar(1) NULL DEFAULT '0':: character varying,              -- 鍒犻櫎鏍囧織
-    tenant_id       varchar(40)  NULL,                                    -- 绉熸埛id
+    id              int8         NOT NULL,                                 -- 涓婚敭id
+    definition_id   int8         NOT NULL,                                 -- 瀵瑰簲flow_definition琛ㄧ殑id
+    business_id     varchar(40)  NOT NULL,                                 -- 涓氬姟id
+    node_type       int2         NOT NULL,                                 -- 鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
+    node_code       varchar(40)  NOT NULL,                                 -- 娴佺▼鑺傜偣缂栫爜
+    node_name       varchar(100) NULL,                                     -- 娴佺▼鑺傜偣鍚嶇О
+    variable        text         NULL,                                     -- 浠诲姟鍙橀噺
+    flow_status     varchar(20)  NOT NULL,                                 -- 娴佺▼鐘舵�侊紙0寰呮彁浜� 1瀹℃壒涓� 2 瀹℃壒閫氳繃 8宸插畬鎴� 9宸查��鍥� 10澶辨晥锛�
+    activity_status int2         NOT NULL DEFAULT 1,                       -- 娴佺▼婵�娲荤姸鎬侊紙0鎸傝捣 1婵�娲伙級
+    create_by       varchar(64)  NULL     DEFAULT '':: character varying,  -- 鍒涘缓鑰�
+    create_time     timestamp    NULL,                                     -- 鍒涘缓鏃堕棿
+    update_time     timestamp    NULL,                                     -- 鏇存柊鏃堕棿
+    ext             varchar(500) NULL,                                     -- 鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤
+    del_flag        bpchar(1)    NULL     DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
+    tenant_id       varchar(40)  NULL,                                     -- 绉熸埛id
     CONSTRAINT flow_instance_pkey PRIMARY KEY (id)
 );
 COMMENT ON TABLE flow_instance IS '娴佺▼瀹炰緥琛�';
@@ -164,18 +164,18 @@
 
 CREATE TABLE flow_task
 (
-    id            int8         NOT NULL,                        -- 涓婚敭id
-    definition_id int8         NOT NULL,                        -- 瀵瑰簲flow_definition琛ㄧ殑id
-    instance_id   int8         NOT NULL,                        -- 瀵瑰簲flow_instance琛ㄧ殑id
-    node_code     varchar(100) NOT NULL,                        -- 鑺傜偣缂栫爜
-    node_name     varchar(100) NULL,                            -- 鑺傜偣鍚嶇О
-    node_type     int2         NOT NULL,                        -- 鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
-    form_custom   bpchar(1) NULL DEFAULT 'N':: character varying, -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
-    form_path     varchar(100) NULL,                            -- 瀹℃壒琛ㄥ崟璺緞
-    create_time   timestamp    NULL,                            -- 鍒涘缓鏃堕棿
-    update_time   timestamp    NULL,                            -- 鏇存柊鏃堕棿
-    del_flag      bpchar(1) NULL DEFAULT '0':: character varying,    -- 鍒犻櫎鏍囧織
-    tenant_id     varchar(40)  NULL,                            -- 绉熸埛id
+    id            int8         NOT NULL,                             -- 涓婚敭id
+    definition_id int8         NOT NULL,                             -- 瀵瑰簲flow_definition琛ㄧ殑id
+    instance_id   int8         NOT NULL,                             -- 瀵瑰簲flow_instance琛ㄧ殑id
+    node_code     varchar(100) NOT NULL,                             -- 鑺傜偣缂栫爜
+    node_name     varchar(100) NULL,                                 -- 鑺傜偣鍚嶇О
+    node_type     int2         NOT NULL,                             -- 鑺傜偣绫诲瀷锛�0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
+    form_custom   bpchar(1)    NULL DEFAULT 'N':: character varying, -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
+    form_path     varchar(100) NULL,                                 -- 瀹℃壒琛ㄥ崟璺緞
+    create_time   timestamp    NULL,                                 -- 鍒涘缓鏃堕棿
+    update_time   timestamp    NULL,                                 -- 鏇存柊鏃堕棿
+    del_flag      bpchar(1)    NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
+    tenant_id     varchar(40)  NULL,                                 -- 绉熸埛id
     CONSTRAINT flow_task_pkey PRIMARY KEY (id)
 );
 COMMENT ON TABLE flow_task IS '寰呭姙浠诲姟琛�';
@@ -195,28 +195,29 @@
 
 CREATE TABLE flow_his_task
 (
-    id               int8         NOT NULL,                     -- 涓婚敭id
-    definition_id    int8         NOT NULL,                     -- 瀵瑰簲flow_definition琛ㄧ殑id
-    instance_id      int8         NOT NULL,                     -- 瀵瑰簲flow_instance琛ㄧ殑id
-    task_id          int8         NOT NULL,                     -- 瀵瑰簲flow_task琛ㄧ殑id
-    node_code        varchar(100) NULL,                         -- 寮�濮嬭妭鐐圭紪鐮�
-    node_name        varchar(100) NULL,                         -- 寮�濮嬭妭鐐瑰悕绉�
-    node_type        int2         NULL,                         -- 寮�濮嬭妭鐐圭被鍨嬶紙0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
-    target_node_code varchar(100) NULL,                         -- 鐩爣鑺傜偣缂栫爜
-    target_node_name varchar(100) NULL,                         -- 缁撴潫鑺傜偣鍚嶇О
-    approver         varchar(40)  NULL,                         -- 瀹℃壒鑰�
-    cooperate_type   int2         NOT NULL DEFAULT 0,           -- 鍗忎綔鏂瑰紡(1瀹℃壒 2杞姙 3濮旀淳 4浼氱 5绁ㄧ 6鍔犵 7鍑忕)
-    collaborator     varchar(40)  NULL,                         -- 鍗忎綔浜�(鍙湁杞姙銆佷細绛俱�佺エ绛俱�佸娲�)
-    skip_type        varchar(10)  NULL,                         -- 娴佽浆绫诲瀷锛圥ASS閫氳繃 REJECT閫�鍥� NONE鏃犲姩浣滐級
-    flow_status      varchar(20)  NOT NULL,                     -- 娴佺▼鐘舵�侊紙0寰呮彁浜� 1瀹℃壒涓� 2 瀹℃壒閫氳繃 8宸插畬鎴� 9宸查��鍥� 10澶辨晥锛�
-    form_custom      bpchar(1) NULL DEFAULT 'N':: character varying, -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
-    form_path        varchar(100) NULL,                         -- 瀹℃壒琛ㄥ崟璺緞
-    ext              varchar(500) NULL,                         -- 鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤
-    message          varchar(500) NULL,                         -- 瀹℃壒鎰忚
-    create_time      timestamp    NULL,                         -- 鍒涘缓鏃堕棿
-    update_time      timestamp    NULL,                         -- 鏇存柊鏃堕棿
-    del_flag         bpchar(1) NULL DEFAULT '0':: character varying,    -- 鍒犻櫎鏍囧織
-    tenant_id        varchar(40)  NULL,                         -- 绉熸埛id
+    id               int8         NOT NULL,                                 -- 涓婚敭id
+    definition_id    int8         NOT NULL,                                 -- 瀵瑰簲flow_definition琛ㄧ殑id
+    instance_id      int8         NOT NULL,                                 -- 瀵瑰簲flow_instance琛ㄧ殑id
+    task_id          int8         NOT NULL,                                 -- 瀵瑰簲flow_task琛ㄧ殑id
+    node_code        varchar(100) NULL,                                     -- 寮�濮嬭妭鐐圭紪鐮�
+    node_name        varchar(100) NULL,                                     -- 寮�濮嬭妭鐐瑰悕绉�
+    node_type        int2         NULL,                                     -- 寮�濮嬭妭鐐圭被鍨嬶紙0寮�濮嬭妭鐐� 1涓棿鑺傜偣 2缁撴潫鑺傜偣 3浜掓枼缃戝叧 4骞惰缃戝叧锛�
+    target_node_code varchar(200) NULL,                                     -- 鐩爣鑺傜偣缂栫爜
+    target_node_name varchar(200) NULL,                                     -- 缁撴潫鑺傜偣鍚嶇О
+    approver         varchar(40)  NULL,                                     -- 瀹℃壒鑰�
+    cooperate_type   int2         NOT NULL DEFAULT 0,                       -- 鍗忎綔鏂瑰紡(1瀹℃壒 2杞姙 3濮旀淳 4浼氱 5绁ㄧ 6鍔犵 7鍑忕)
+    collaborator     varchar(40)  NULL,                                     -- 鍗忎綔浜�(鍙湁杞姙銆佷細绛俱�佺エ绛俱�佸娲�)
+    skip_type        varchar(10)  NULL,                                     -- 娴佽浆绫诲瀷锛圥ASS閫氳繃 REJECT閫�鍥� NONE鏃犲姩浣滐級
+    flow_status      varchar(20)  NOT NULL,                                 -- 娴佺▼鐘舵�侊紙0寰呮彁浜� 1瀹℃壒涓� 2 瀹℃壒閫氳繃 8宸插畬鎴� 9宸查��鍥� 10澶辨晥锛�
+    form_custom      bpchar(1)    NULL     DEFAULT 'N':: character varying, -- 瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級
+    form_path        varchar(100) NULL,                                     -- 瀹℃壒琛ㄥ崟璺緞
+    ext              varchar(500) NULL,                                     -- 鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤
+    message          varchar(500) NULL,                                     -- 瀹℃壒鎰忚
+    variable         text         NULL,                                     -- 浠诲姟鍙橀噺
+    create_time      timestamp    NULL,                                     -- 鍒涘缓鏃堕棿
+    update_time      timestamp    NULL,                                     -- 鏇存柊鏃堕棿
+    del_flag         bpchar(1)    NULL     DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
+    tenant_id        varchar(40)  NULL,                                     -- 绉熸埛id
     CONSTRAINT flow_his_task_pkey PRIMARY KEY (id)
 );
 COMMENT ON TABLE flow_his_task IS '鍘嗗彶浠诲姟璁板綍琛�';
@@ -238,6 +239,7 @@
 COMMENT ON COLUMN flow_his_task.form_custom IS '瀹℃壒琛ㄥ崟鏄惁鑷畾涔夛紙Y鏄� N鍚︼級';
 COMMENT ON COLUMN flow_his_task.form_path IS '瀹℃壒琛ㄥ崟璺緞';
 COMMENT ON COLUMN flow_his_task.message IS '瀹℃壒鎰忚';
+COMMENT ON COLUMN flow_his_task.variable IS '浠诲姟鍙橀噺';
 COMMENT ON COLUMN flow_his_task.ext IS '鎵╁睍瀛楁锛岄鐣欑粰涓氬姟绯荤粺浣跨敤';
 COMMENT ON COLUMN flow_his_task.create_time IS '浠诲姟寮�濮嬫椂闂�';
 COMMENT ON COLUMN flow_his_task.update_time IS '瀹℃壒瀹屾垚鏃堕棿';
@@ -246,15 +248,15 @@
 
 CREATE TABLE flow_user
 (
-    id           int8        NOT NULL,                       -- 涓婚敭id
-    "type"       bpchar(1) NOT NULL,                         -- 浜哄憳绫诲瀷锛�1寰呭姙浠诲姟鐨勫鎵逛汉鏉冮檺 2寰呭姙浠诲姟鐨勮浆鍔炰汉鏉冮檺 3娴佺▼瀹炰緥鐨勬妱閫佷汉鏉冮檺 4寰呭姙浠诲姟鐨勫鎵樹汉鏉冮檺锛�
-    processed_by varchar(80) NULL,                           -- 鏉冮檺浜�
-    associated   int8        NOT NULL,                       -- 浠诲姟琛╥d
-    create_time  timestamp   NULL,                           -- 鍒涘缓鏃堕棿
-    create_by    varchar(80) NULL,                           -- 鍒涘缓浜�
-    update_time  timestamp   NULL,                           -- 鏇存柊鏃堕棿
-    del_flag     bpchar(1) NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
-    tenant_id    varchar(40) NULL,                           -- 绉熸埛id
+    id           int8        NOT NULL,                             -- 涓婚敭id
+    "type"       bpchar(1)   NOT NULL,                             -- 浜哄憳绫诲瀷锛�1寰呭姙浠诲姟鐨勫鎵逛汉鏉冮檺 2寰呭姙浠诲姟鐨勮浆鍔炰汉鏉冮檺 3娴佺▼瀹炰緥鐨勬妱閫佷汉鏉冮檺 4寰呭姙浠诲姟鐨勫鎵樹汉鏉冮檺锛�
+    processed_by varchar(80) NULL,                                 -- 鏉冮檺浜�
+    associated   int8        NOT NULL,                             -- 浠诲姟琛╥d
+    create_time  timestamp   NULL,                                 -- 鍒涘缓鏃堕棿
+    create_by    varchar(80) NULL,                                 -- 鍒涘缓浜�
+    update_time  timestamp   NULL,                                 -- 鏇存柊鏃堕棿
+    del_flag     bpchar(1)   NULL DEFAULT '0':: character varying, -- 鍒犻櫎鏍囧織
+    tenant_id    varchar(40) NULL,                                 -- 绉熸埛id
     CONSTRAINT flow_user_pk PRIMARY KEY (id)
 );
 CREATE INDEX user_processed_type ON flow_user USING btree (processed_by, type);
@@ -306,7 +308,7 @@
 
 INSERT INTO flow_category VALUES (100, '000000', 0, '0', 'OA瀹℃壒', 0, '0', 103, 1, now(), NULL, NULL);
 INSERT INTO flow_category VALUES (101, '000000', 100, '0,100', '鍋囧嫟绠$悊', 0, '0', 103, 1, now(), NULL, NULL);
-INSERT INTO flow_category VALUES (102, '000000', 100, '0,100', '浜轰簨绠$悊', 0, '0', 103, 1, now(), NULL, NULL);
+INSERT INTO flow_category VALUES (102, '000000', 100, '0,100', '浜轰簨绠$悊', 1, '0', 103, 1, now(), NULL, NULL);
 INSERT INTO flow_category VALUES (103, '000000', 101, '0,100,101', '璇峰亣', 0, '0', 103, 1, now(), NULL, NULL);
 INSERT INTO flow_category VALUES (104, '000000', 101, '0,100,101', '鍑哄樊', 1, '0', 103, 1, now(), NULL, NULL);
 INSERT INTO flow_category VALUES (105, '000000', 101, '0,100,101', '鍔犵彮', 2, '0', 103, 1, now(), NULL, NULL);

--
Gitblit v1.9.3