From 8c67435320d34ea3ef941e435194e9a794bcce59 Mon Sep 17 00:00:00 2001
From: 韩丁康 <handingkang@mesalab.cn>
Date: Mon, 20 May 2024 13:43:33 +0000
Subject: 废除task表指向taskpolicy的外键创建
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 server/apps/util.py | 8 +-------
 1 file changed, 1 insertion(+), 7 deletions(-)

diff --git a/server/apps/util.py b/server/apps/util.py
index ad5bec2..9ea099d 100644
--- a/server/apps/util.py
+++ b/server/apps/util.py
@@ -135,11 +135,6 @@ class DataHandler:
         `USER_PWD_HASH` varchar(255),
         `USER_GROUP` varchar(255)) ENGINE=innodb DEFAULT CHARSET=utf8;""" % MYSQL_TAB_USER
 
-        # 和task_policysql存在双向外键引用的问题，需要额外定义
-        fkey = """
-        ALTER TABLE %s ADD CONSTRAINT `fk_TASK_TASK_POLICY_1`
-        FOREIGN KEY(`POLICY`) REFERENCES %s(`TP_ID`)""" % (
-            MYSQL_TAB_TASK, MYSQL_TAB_TASKPOLICY)
 
         # 执行sql语句
         try:
@@ -159,8 +154,7 @@ class DataHandler:
             self.cursor.execute(tasklogsql)
             self.conn.commit()
 
-            # 创建外键
-            self.cursor.execute(fkey)
+
         except Exception as e:
             # 重复外键
             if str(e).find("(1826"):
-- 
cgit v1.2.3