From fd42c6e903ddc976d3b8f1bdf9d3128753b8af98 Mon Sep 17 00:00:00 2001
From: VVT789 <sdxt_0802@163.com>
Date: 星期二, 25 二月 2025 10:41:24 +0800
Subject: [PATCH] update sql
---
sql/postgre.sql | 25 -------------------------
1 files changed, 0 insertions(+), 25 deletions(-)
diff --git a/sql/postgre.sql b/sql/postgre.sql
index 333387f..81bc1c8 100644
--- a/sql/postgre.sql
+++ b/sql/postgre.sql
@@ -86,7 +86,6 @@
DROP TABLE IF EXISTS "public"."node_energy";
DROP TABLE IF EXISTS "public"."node_index";
DROP TABLE IF EXISTS "public"."node_product";
-DROP TABLE IF EXISTS "public"."pdb_table_index";
DROP TABLE IF EXISTS "public"."plan_energy";
DROP TABLE IF EXISTS "public"."planned_output";
DROP TABLE IF EXISTS "public"."policies_regulations_management";
@@ -1715,25 +1714,6 @@
ALTER TABLE "node_product" OWNER TO "postgres";
COMMENT ON COLUMN "node_product"."node_id" IS '妯″瀷鑺傜偣 ID';
COMMENT ON COLUMN "node_product"."product_id" IS '浜у搧 ID';
-CREATE TABLE "pdb_table_index" (
- "tx_id" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
- "idex_id" varchar(200) COLLATE "pg_catalog"."default" NOT NULL,
- "index_code" varchar(255) COLLATE "pg_catalog"."default",
- "index_name" varchar(255) COLLATE "pg_catalog"."default",
- "table_index_name" varchar(255) COLLATE "pg_catalog"."default",
- "table_index_code" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
- "data_info" varchar(255) COLLATE "pg_catalog"."default"
-)
-;
-ALTER TABLE "pdb_table_index" OWNER TO "postgres";
-COMMENT ON COLUMN "pdb_table_index"."tx_id" IS 'uuid鍞竴涓嶅彲閲嶅';
-COMMENT ON COLUMN "pdb_table_index"."idex_id" IS '鎸囨爣瀵瑰簲鐨刬nde_id';
-COMMENT ON COLUMN "pdb_table_index"."index_code" IS '鎸囨爣瀵瑰簲鐨勭紪鐮乮ndex_code';
-COMMENT ON COLUMN "pdb_table_index"."index_name" IS '鎸囨爣鍚嶇Оindex_name';
-COMMENT ON COLUMN "pdb_table_index"."table_index_name" IS '鎶ヨ〃浣跨敤鐨勬寚鏍囧悕绉�';
-COMMENT ON COLUMN "pdb_table_index"."table_index_code" IS '鎶ヨ〃浣跨敤鐨勬寚鏍囩紪鐮�';
-COMMENT ON COLUMN "pdb_table_index"."data_info" IS '鏁版嵁鏉ユ簮鐨勮〃鍚嶇紪鍙凤紙澶囩敤瀛楁锛�';
-COMMENT ON TABLE "pdb_table_index" IS '搴炲反杩」鐩姤琛ㄦ寚鏍囦笌骞冲彴鎸囨爣鐨勫叧鑱旇〃';
CREATE TABLE "plan_energy" (
"product_id" int4 NOT NULL,
"value" varchar(255) COLLATE "pg_catalog"."default",
@@ -3244,10 +3224,6 @@
DELETE FROM "public"."node_product";
COMMIT;
BEGIN;
-LOCK TABLE "public"."pdb_table_index" IN SHARE MODE;
-DELETE FROM "public"."pdb_table_index";
-COMMIT;
-BEGIN;
LOCK TABLE "public"."plan_energy" IN SHARE MODE;
DELETE FROM "public"."plan_energy";
COMMIT;
@@ -3559,7 +3535,6 @@
ALTER TABLE "node_energy" ADD CONSTRAINT "node_device_copy1_pkey" PRIMARY KEY ("node_id", "energy_id");
ALTER TABLE "node_index" ADD CONSTRAINT "node_index_pkey" PRIMARY KEY ("node_id", "index_id");
ALTER TABLE "node_product" ADD CONSTRAINT "node_energy_copy2_pkey" PRIMARY KEY ("node_id", "product_id");
-ALTER TABLE "pdb_table_index" ADD CONSTRAINT "pdb_table_index_pkey" PRIMARY KEY ("tx_id");
ALTER TABLE "plan_energy" ADD CONSTRAINT "plan_energy_pkey" PRIMARY KEY ("product_id", "time_code");
ALTER TABLE "planned_output" ADD CONSTRAINT "planned_output_pkey" PRIMARY KEY ("product_id", "time_code");
ALTER TABLE "policies_regulations_management" ADD CONSTRAINT "policies_regulations_management_pkey" PRIMARY KEY ("id");
--
Gitblit v1.9.3