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