From 53c315297a3906e567b01107a85836528a664206 Mon Sep 17 00:00:00 2001
From: seatonwan9
Date: 星期二, 19 八月 2025 18:11:38 +0800
Subject: [PATCH] 产品订购sql
---
sql/public_new.sql | 30 ++++++++++++++++++++++++------
1 files changed, 24 insertions(+), 6 deletions(-)
diff --git a/sql/public_new.sql b/sql/public_new.sql
index 7bc1ac8..f2df232 100644
--- a/sql/public_new.sql
+++ b/sql/public_new.sql
@@ -12,7 +12,7 @@
Target Server Version : 130000
File Encoding : 65001
- Date: 19/08/2025 01:39:12
+ Date: 19/08/2025 18:11:08
*/
@@ -428,6 +428,16 @@
-- ----------------------------
-- Records of order_detail
-- ----------------------------
+INSERT INTO "public"."order_detail" OVERRIDING SYSTEM VALUE VALUES (1, '202508191718590806528000', 5, 1, '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉佹湁澧為噺鍖�', '涓汉', '2', '3', '绉垎', '濂�/骞�', 200.00, 1, 1, 200.00, 3, '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:18:59.649', '2025-08-19 17:18:59.649', '', 0);
+INSERT INTO "public"."order_detail" OVERRIDING SYSTEM VALUE VALUES (2, '202508191718590806528000', 4, 1, '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉熻祦', '涓汉', '1', '1', '绉垎', '濂�/骞�', 200.00, 1, 1, 200.00, 3, '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:18:59.66', '2025-08-19 17:18:59.66', '', 0);
+INSERT INTO "public"."order_detail" OVERRIDING SYSTEM VALUE VALUES (3, '202508191718590806528000', 9, 1, '浼佷笟绉佹湁SaaS鐗堢敤鎴峰閲忓寘', '绉佹湁澧為噺鍖�', '椤圭洰閮�', '1', '1', '鍏嶈垂', '骞�', 0.00, 1, 1, 0.00, 3, '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:18:59.664', '2025-08-19 17:18:59.664', '', 0);
+INSERT INTO "public"."order_detail" OVERRIDING SYSTEM VALUE VALUES (4, '202508191730018270442496', 2, 1, '涓撲笟鐗�', '绉熻祦', '浼佷笟', '涓嶉檺', '涓嶉檺', '绉垎', '濂�/骞�', 500.00, 1, 1, 500.00, 3, '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:30:01.814', '2025-08-19 17:30:01.814', '', 0);
+INSERT INTO "public"."order_detail" OVERRIDING SYSTEM VALUE VALUES (5, '202508191732232175500288', 1, 1, '鍩虹鐗�', '涔版柇', '浼佷笟', '涓嶉檺', '涓嶉檺', '绉垎', '濂�', 1000.00, 1, 1, 1000.00, 3, '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:32:23.412', '2025-08-19 17:32:23.412', '', 0);
+INSERT INTO "public"."order_detail" OVERRIDING SYSTEM VALUE VALUES (6, '202508191735337897883648', 9, 1, '浼佷笟绉佹湁SaaS鐗堢敤鎴峰閲忓寘', '绉佹湁澧為噺鍖�', '椤圭洰閮�', '1', '1', '鍏嶈垂', '骞�', 0.00, 1, 1, 0.00, 3, '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:35:33.127', '2025-08-19 17:35:33.127', '', 0);
+INSERT INTO "public"."order_detail" OVERRIDING SYSTEM VALUE VALUES (7, '202508191745527049352192', 5, 1, '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉佹湁澧為噺鍖�', '涓汉', '2', '3', '绉垎', '濂�/骞�', 200.00, 1, 1, 200.00, 3, '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:45:52.815', '2025-08-19 17:45:52.815', '', 0);
+INSERT INTO "public"."order_detail" OVERRIDING SYSTEM VALUE VALUES (8, '202508191752392071676928', 9, 1, '浼佷笟绉佹湁SaaS鐗堢敤鎴峰閲忓寘', '绉佹湁澧為噺鍖�', '椤圭洰閮�', '1', '1', '鍏嶈垂', '骞�', 0.00, 1, 1, 0.00, 3, '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 17:52:39.325', '2025-08-19 17:52:39.325', '', 0);
+INSERT INTO "public"."order_detail" OVERRIDING SYSTEM VALUE VALUES (9, '202508191809061614843904', 4, 1, '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉熻祦', '涓汉', '1', '1', '绉垎', '濂�/骞�', 200.00, 1, 1, 200.00, 3, '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 18:09:06.269', '2025-08-19 18:09:06.269', '', 0);
+INSERT INTO "public"."order_detail" OVERRIDING SYSTEM VALUE VALUES (10, '202508191809061614843904', 9, 1, '浼佷笟绉佹湁SaaS鐗堢敤鎴峰閲忓寘', '绉佹湁澧為噺鍖�', '椤圭洰閮�', '1', '1', '鍏嶈垂', '骞�', 0.00, 1, 1, 0.00, 3, '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', '2025-08-19 18:09:06.275', '2025-08-19 18:09:06.275', '', 0);
-- ----------------------------
-- Table structure for order_evaluation
@@ -496,6 +506,13 @@
-- ----------------------------
-- Records of order_info
-- ----------------------------
+INSERT INTO "public"."order_info" VALUES ('202508191718590806528000', 1, 1, 1, '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', 3, '2025-08-19 17:18:59.608', '寰呭鎵�', 400.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-19 17:18:59.608', '2025-08-19 17:18:59.608', 0);
+INSERT INTO "public"."order_info" VALUES ('202508191730018270442496', 1, 1, 1, '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', 3, '2025-08-19 17:30:01.807', '寰呭鎵�', 500.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-19 17:30:01.807', '2025-08-19 17:30:01.807', 0);
+INSERT INTO "public"."order_info" VALUES ('202508191732232175500288', 1, 1, 1, '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', 3, '2025-08-19 17:32:23.405', '寰呭鎵�', 1000.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-19 17:32:23.405', '2025-08-19 17:32:23.405', 0);
+INSERT INTO "public"."order_info" VALUES ('202508191735337897883648', 1, 1, 1, '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', 3, '2025-08-19 17:35:33.12', '寰呭鎵�', 0.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-19 17:35:33.12', '2025-08-19 17:35:33.12', 0);
+INSERT INTO "public"."order_info" VALUES ('202508191745527049352192', 1, 1, 1, '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', 3, '2025-08-19 17:45:52.806', '寰呭鎵�', 200.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-19 17:45:52.807', '2025-08-19 17:45:52.807', 0);
+INSERT INTO "public"."order_info" VALUES ('202508191752392071676928', 1, 1, 1, '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', 3, '2025-08-19 17:52:39.316', '寰呭鎵�', 0.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-19 17:52:39.316', '2025-08-19 17:52:39.316', 0);
+INSERT INTO "public"."order_info" VALUES ('202508191809061614843904', 1, 1, 1, '涓氦鏂硅繙鏅鸿兘瀹炴祴瀹為噺绠＄悊绯荤粺', '涓氦寤虹瓚闆嗗洟绗竴宸ョ▼鏈夐檺鍏徃', 3, '2025-08-19 18:09:06.259', '寰呭鎵�', 200.00, '绉垎', '鏈敮浠�', NULL, NULL, NULL, '', NULL, '2025-08-19 18:09:06.259', '2025-08-19 18:09:06.259', 0);
-- ----------------------------
-- Table structure for points
@@ -820,7 +837,7 @@
"concurrent_nodes" text COLLATE "pg_catalog"."default" DEFAULT '涓嶉檺'::text,
"price_type" text COLLATE "pg_catalog"."default" NOT NULL,
"price_unit" text COLLATE "pg_catalog"."default" NOT NULL,
- "points_price" numeric(15,2) NOT NULL,
+ "points_price" numeric(15,2),
"is_active" bool DEFAULT true,
"product_id" int8 NOT NULL,
"product_name" text COLLATE "pg_catalog"."default",
@@ -849,7 +866,8 @@
INSERT INTO "public"."product_pricing" OVERRIDING SYSTEM VALUE VALUES (3, '浼佷笟鐗�', '涔版柇', '浼佷笟', '涓嶉檺', '涓嶉檺', '璐у竵', '濂�', 10000.00, 't', 2, '娴嬭瘯浜у搧2', 3, '娴嬭瘯鎻愪緵鑰�', NULL, '2025-08-13 14:50:16.574223', '2025-08-13 14:50:16.574223', NULL, NULL, 0, NULL);
INSERT INTO "public"."product_pricing" OVERRIDING SYSTEM VALUE VALUES (4, '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉熻祦', '涓汉', '1', '1', '绉垎,璐у竵', '濂�/骞�', 200.00, 't', 1, '鏁板瓧鍖栦骇鍝丄', NULL, NULL, '', '2025-08-18 16:53:39.407', '2025-08-18 16:53:39.407', NULL, NULL, 0, 100.00);
INSERT INTO "public"."product_pricing" OVERRIDING SYSTEM VALUE VALUES (6, '浼佷笟绉佹湁SaaS鐗堢敤鎴峰閲忓寘', '绉熻祦', '涓汉', '2', '2', '璐у竵', '濂�/骞�', 200.00, 't', 1, '鏁板瓧鍖栦骇鍝丄', NULL, NULL, '', '2025-08-18 17:13:29.332', '2025-08-18 17:13:29.332', NULL, NULL, 0, 100.00);
-INSERT INTO "public"."product_pricing" OVERRIDING SYSTEM VALUE VALUES (5, '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉佹湁澧炲寘閲�', '涓汉', '2', '3', '绉垎,璐у竵', '濂�/骞�', 200.00, 'f', 1, '鏁板瓧鍖栦骇鍝丄', NULL, NULL, '', '2025-08-18 16:53:57.726', '2025-08-18 17:32:14.623', NULL, NULL, 0, 100.00);
+INSERT INTO "public"."product_pricing" OVERRIDING SYSTEM VALUE VALUES (9, '浼佷笟绉佹湁SaaS鐗堢敤鎴峰閲忓寘', '绉佹湁澧炲寘閲�', '椤圭洰閮�', '1', '1', '鍏嶈垂', '骞�', NULL, 't', 1, '鏁板瓧鍖栦骇鍝丄', NULL, NULL, '', '2025-08-19 17:17:41.644', '2025-08-19 17:17:41.644', NULL, NULL, 0, NULL);
+INSERT INTO "public"."product_pricing" OVERRIDING SYSTEM VALUE VALUES (5, '浼佷笟绉佹湁SaaS鐗堣鍙�', '绉佹湁澧炲寘閲�', '涓汉', '2', '3', '绉垎,璐у竵', '濂�/骞�', 200.00, 'f', 1, '鏁板瓧鍖栦骇鍝丄', NULL, NULL, '', '2025-08-18 16:53:57.726', '2025-08-19 17:54:06.25', NULL, NULL, 1, 100.00);
-- ----------------------------
-- Table structure for unit
@@ -968,7 +986,7 @@
-- ----------------------------
ALTER SEQUENCE "public"."cart_id_seq1"
OWNED BY "public"."cart"."id";
-SELECT setval('"public"."cart_id_seq1"', 2, false);
+SELECT setval('"public"."cart_id_seq1"', 15, true);
-- ----------------------------
-- Alter sequences owned by
@@ -1010,7 +1028,7 @@
-- ----------------------------
ALTER SEQUENCE "public"."order_detail_id_seq1"
OWNED BY "public"."order_detail"."id";
-SELECT setval('"public"."order_detail_id_seq1"', 2, false);
+SELECT setval('"public"."order_detail_id_seq1"', 11, true);
-- ----------------------------
-- Alter sequences owned by
@@ -1087,7 +1105,7 @@
-- ----------------------------
ALTER SEQUENCE "public"."product_pricing_id_seq1"
OWNED BY "public"."product_pricing"."id";
-SELECT setval('"public"."product_pricing_id_seq1"', 7, true);
+SELECT setval('"public"."product_pricing_id_seq1"', 10, true);
-- ----------------------------
-- Alter sequences owned by
--
Gitblit v1.8.0