From 1cdccaf0a06161fcc2a5797e617508c8a7e1f300 Mon Sep 17 00:00:00 2001
From: p-honggang.li <p-honggang.li@pcitc.com>
Date: 星期六, 06 九月 2025 03:14:53 +0800
Subject: [PATCH] 修改订单创建，发起工作流调用，采用后端处理，增加事务，修改审核同通过和驳回处理，修改根据用户id获取工作流代办信息，再根据代办ids查询订单信息
---
sql/public_new.sql | 60 ++++++++++++++++++++++++++++++------------------------------
1 files changed, 30 insertions(+), 30 deletions(-)
diff --git a/sql/public_new.sql b/sql/public_new.sql
index f2df232..b1d947a 100644
--- a/sql/public_new.sql
+++ b/sql/public_new.sql
@@ -28,10 +28,10 @@
CACHE 1;
-- ----------------------------
--- Sequence structure for cart_id_seq1
+-- Sequence structure for cart_id_seq
-- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."cart_id_seq1";
-CREATE SEQUENCE "public"."cart_id_seq1"
+DROP SEQUENCE IF EXISTS "public"."cart_id_seq";
+CREATE SEQUENCE "public"."cart_id_seq"
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
@@ -50,10 +50,10 @@
CACHE 1;
-- ----------------------------
--- Sequence structure for order_approval_id_seq1
+-- Sequence structure for order_approval_id_seq
-- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."order_approval_id_seq1";
-CREATE SEQUENCE "public"."order_approval_id_seq1"
+DROP SEQUENCE IF EXISTS "public"."order_approval_id_seq";
+CREATE SEQUENCE "public"."order_approval_id_seq"
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
@@ -72,10 +72,10 @@
CACHE 1;
-- ----------------------------
--- Sequence structure for order_attachment_id_seq1
+-- Sequence structure for order_attachment_id_seq
-- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."order_attachment_id_seq1";
-CREATE SEQUENCE "public"."order_attachment_id_seq1"
+DROP SEQUENCE IF EXISTS "public"."order_attachment_id_seq";
+CREATE SEQUENCE "public"."order_attachment_id_seq"
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
@@ -94,10 +94,10 @@
CACHE 1;
-- ----------------------------
--- Sequence structure for order_detail_id_seq1
+-- Sequence structure for order_detail_id_seq
-- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."order_detail_id_seq1";
-CREATE SEQUENCE "public"."order_detail_id_seq1"
+DROP SEQUENCE IF EXISTS "public"."order_detail_id_seq";
+CREATE SEQUENCE "public"."order_detail_id_seq"
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
@@ -116,10 +116,10 @@
CACHE 1;
-- ----------------------------
--- Sequence structure for order_evaluation_id_seq1
+-- Sequence structure for order_evaluation_id_seq
-- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."order_evaluation_id_seq1";
-CREATE SEQUENCE "public"."order_evaluation_id_seq1"
+DROP SEQUENCE IF EXISTS "public"."order_evaluation_id_seq";
+CREATE SEQUENCE "public"."order_evaluation_id_seq"
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
@@ -215,10 +215,10 @@
CACHE 1;
-- ----------------------------
--- Sequence structure for product_pricing_id_seq1
+-- Sequence structure for product_pricing_id_seq
-- ----------------------------
-DROP SEQUENCE IF EXISTS "public"."product_pricing_id_seq1";
-CREATE SEQUENCE "public"."product_pricing_id_seq1"
+DROP SEQUENCE IF EXISTS "public"."product_pricing_id_seq";
+CREATE SEQUENCE "public"."product_pricing_id_seq"
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
@@ -984,9 +984,9 @@
-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
-ALTER SEQUENCE "public"."cart_id_seq1"
+ALTER SEQUENCE "public"."cart_id_seq"
OWNED BY "public"."cart"."id";
-SELECT setval('"public"."cart_id_seq1"', 15, true);
+SELECT setval('"public"."cart_id_seq"', 15, true);
-- ----------------------------
-- Alter sequences owned by
@@ -998,9 +998,9 @@
-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
-ALTER SEQUENCE "public"."order_approval_id_seq1"
+ALTER SEQUENCE "public"."order_approval_id_seq"
OWNED BY "public"."order_approval"."id";
-SELECT setval('"public"."order_approval_id_seq1"', 2, false);
+SELECT setval('"public"."order_approval_id_seq"', 2, false);
-- ----------------------------
-- Alter sequences owned by
@@ -1012,9 +1012,9 @@
-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
-ALTER SEQUENCE "public"."order_attachment_id_seq1"
+ALTER SEQUENCE "public"."order_attachment_id_seq"
OWNED BY "public"."order_attachment"."id";
-SELECT setval('"public"."order_attachment_id_seq1"', 2, false);
+SELECT setval('"public"."order_attachment_id_seq"', 2, false);
-- ----------------------------
-- Alter sequences owned by
@@ -1026,9 +1026,9 @@
-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
-ALTER SEQUENCE "public"."order_detail_id_seq1"
+ALTER SEQUENCE "public"."order_detail_id_seq"
OWNED BY "public"."order_detail"."id";
-SELECT setval('"public"."order_detail_id_seq1"', 11, true);
+SELECT setval('"public"."order_detail_id_seq"', 11, true);
-- ----------------------------
-- Alter sequences owned by
@@ -1040,9 +1040,9 @@
-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
-ALTER SEQUENCE "public"."order_evaluation_id_seq1"
+ALTER SEQUENCE "public"."order_evaluation_id_seq"
OWNED BY "public"."order_evaluation"."id";
-SELECT setval('"public"."order_evaluation_id_seq1"', 2, false);
+SELECT setval('"public"."order_evaluation_id_seq"', 2, false);
-- ----------------------------
-- Alter sequences owned by
@@ -1103,9 +1103,9 @@
-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
-ALTER SEQUENCE "public"."product_pricing_id_seq1"
+ALTER SEQUENCE "public"."product_pricing_id_seq"
OWNED BY "public"."product_pricing"."id";
-SELECT setval('"public"."product_pricing_id_seq1"', 10, true);
+SELECT setval('"public"."product_pricing_id_seq"', 10, true);
-- ----------------------------
-- Alter sequences owned by
--
Gitblit v1.8.0