From 1ac791d6819584c7a01849bfecb20db5a6b0cbaf Mon Sep 17 00:00:00 2001
From: VVT789 <sdxt_0802@163.com>
Date: 星期二, 18 三月 2025 11:59:03 +0800
Subject: [PATCH] update sql
---
sql/postgre.sql | 34 ++++++++--------------------------
1 files changed, 8 insertions(+), 26 deletions(-)
diff --git a/sql/postgre.sql b/sql/postgre.sql
index 333387f..97643d9 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";
@@ -582,6 +581,7 @@
"id" varchar(36) COLLATE "pg_catalog"."default" NOT NULL,
"code" varchar(20) COLLATE "pg_catalog"."default",
"name" varchar(20) COLLATE "pg_catalog"."default",
+ "gateway_key" varchar(255) COLLATE "pg_catalog"."default",
"device_type" varchar(10) COLLATE "pg_catalog"."default",
"unit" varchar(10) COLLATE "pg_catalog"."default",
"create_by" varchar(64) COLLATE "pg_catalog"."default",
@@ -595,6 +595,7 @@
COMMENT ON COLUMN "daq_template"."id" IS '涓婚敭';
COMMENT ON COLUMN "daq_template"."code" IS '鍙傛暟缂栫爜';
COMMENT ON COLUMN "daq_template"."name" IS '鍙傛暟鍚嶇О';
+COMMENT ON COLUMN "daq_template"."gateway_key" IS '閲囬泦缂栫爜';
COMMENT ON COLUMN "daq_template"."device_type" IS '鍙傛暟鎵�灞炵被鍨�';
COMMENT ON COLUMN "daq_template"."unit" IS '鍗曚綅';
COMMENT ON COLUMN "daq_template"."create_by" IS '鍒涘缓鑰�';
@@ -1715,25 +1716,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",
@@ -2252,6 +2234,7 @@
"update_time" timestamp(6)
)
;
+INSERT INTO "public"."sys_dept" ("dept_id", "parent_id", "ancestors", "dept_name", "order_num", "leader", "phone", "email", "status", "del_flag", "create_by", "create_time", "update_by", "update_time") VALUES (1, 0, NULL, '鏅虹⒊鏈潵绉戞妧鏈夐檺鍏徃', 1, NULL, NULL, NULL, '0', 0, 'admin', '2025-03-17 13:09:00', NULL, NULL);
ALTER TABLE "sys_dept" OWNER TO "postgres";
COMMENT ON COLUMN "sys_dept"."dept_id" IS '閮ㄩ棬id';
COMMENT ON COLUMN "sys_dept"."parent_id" IS '鐖堕儴闂╥d';
@@ -3244,10 +3227,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;
@@ -3455,7 +3434,11 @@
BEGIN;
LOCK TABLE "public"."sys_user" IN SHARE MODE;
DELETE FROM "public"."sys_user";
-INSERT INTO "public"."sys_user" ("user_id","dept_id","user_name","nick_name","user_type","email","phone_number","sex","avatar","password","status","del_flag","login_ip","login_date","create_by","create_time","update_by","update_time","remark","single_user") VALUES (25, NULL, 'aa1', 'aa', '00', NULL, NULL, '0', NULL, '$2a$10$u9ub/tiHDlQ56DiE6123auKlHdpbXACgHtP4RX2tPpYCGaq7FMdSq', '0', '0', '120.225.217.49', '2024-12-18 15:11:57.426', 'thirdPartGetAuth', '2024-12-18 15:11:57.374536', NULL, '2024-12-18 15:11:57.445301', NULL, '24'),(22, NULL, 'a13', 'a', '00', NULL, NULL, '0', NULL, '$2a$10$dOeiuOTt/2c3MDW0Tn35h.yr5OBvwQuhL7JChmoRkG70V5AkA/ova', '0', '0', NULL, NULL, 'admin', '2024-11-14 15:22:53.251616', NULL, NULL, NULL, NULL),(24, NULL, 'guestUser', '浣撻獙鐢ㄦ埛', '00', NULL, NULL, '0', '/profile/avatar/2025/01/11/寰俊鎴浘_20250109121925_20250111184045A003.png', '$2a$10$OZGdFJV3D7CBKurqiLFaTOInMXZUVc4boSyOPOqVfCiWRVLAGHkRW', '0', '0', '123.168.102.234', '2025-01-18 12:06:26.002', 'admin', '2024-12-04 10:44:29.111243', 'admin', '2025-01-18 12:06:26.005789', NULL, NULL),(23, NULL, 'ceshi', 'ceshi', '00', NULL, NULL, '0', NULL, '$2a$10$ziJEqBj4EuKcp0pwcEffluauZnvoVpSrNtdOwMfQOIZBzBNVu9Ixa', '0', '0', '27.219.144.165', '2024-11-20 10:04:56.266', 'admin', '2024-11-15 14:37:26.096551', 'admin', '2025-01-09 19:01:36.016128', NULL, NULL),(1, 103, 'admin', '绠＄悊鍛�', '00', '', '', '0', '/profile/avatar/2025/01/10/寰俊鎴浘_20250109121925_20250110145027A002.png', '$2a$10$5OXwz0BDzpEmGcI.fXJID.ZNVdNQiD78gYXp5gSUoCkvagcbWwPne', '0', '0', '192.168.110.134', '2025-01-18 14:37:39.517', 'admin', '2018-03-16 11:33:00', 'admin', '2025-01-18 14:37:39.105126', '绠＄悊鍛�', NULL);
+INSERT INTO "public"."sys_user" ("user_id","dept_id","user_name","nick_name","user_type","email","phone_number","sex","avatar","password","status","del_flag","login_ip","login_date","create_by","create_time","update_by","update_time","remark","single_user") VALUES
+(1, 103, 'admin', '绠＄悊鍛�', '00', '', '', '0', '/profile/avatar/2025/01/10/寰俊鎴浘_20250109121925_20250110145027A002.png', '$2a$10$GCHJecgeMGEd0IfS5R17tOP9KxgHJ4SjO.m.e2yyJs95h7LvKyxhi', '0', '0', '192.168.110.134', '2025-01-18 14:37:39.517', 'admin', '2018-03-16 11:33:00', 'admin', '2025-01-18 14:37:39.105126', '绠＄悊鍛�', NULL),
+(23, NULL, 'ceshi', 'ceshi', '00', NULL, NULL, '0', NULL, '$2a$10$GCHJecgeMGEd0IfS5R17tOP9KxgHJ4SjO.m.e2yyJs95h7LvKyxhi', '0', '0', '27.219.144.165', '2024-11-20 10:04:56.266', 'admin', '2024-11-15 14:37:26.096551', 'admin', '2025-01-09 19:01:36.016128', NULL, NULL),
+(24, NULL, 'guestUser', '浣撻獙鐢ㄦ埛', '00', NULL, NULL, '0', '/profile/avatar/2025/01/11/寰俊鎴浘_20250109121925_20250111184045A003.png', '$2a$10$GCHJecgeMGEd0IfS5R17tOP9KxgHJ4SjO.m.e2yyJs95h7LvKyxhi', '0', '0', '123.168.102.234', '2025-01-18 12:06:26.002', 'admin', '2024-12-04 10:44:29.111243', 'admin', '2025-01-18 12:06:26.005789', NULL, NULL);
+
COMMIT;
BEGIN;
LOCK TABLE "public"."sys_user_post" IN SHARE MODE;
@@ -3559,7 +3542,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