diff options
| author | handingkang <[email protected]> | 2024-05-23 12:39:01 +0800 |
|---|---|---|
| committer | handingkang <[email protected]> | 2024-05-23 12:39:01 +0800 |
| commit | 50b34fb103d476c0f20d5ae0069c9eab49ca96bb (patch) | |
| tree | 23cd78bf31a045ebb12894639ec2cb4bc0575f96 | |
| parent | cf7e75de76c228b092e5d4f072f6a0a388620879 (diff) | |
| parent | 8c67435320d34ea3ef941e435194e9a794bcce59 (diff) | |
Merge remote-tracking branch 'origin/main'
| -rw-r--r-- | server/apps/util.py | 8 |
1 files changed, 1 insertions, 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"): |