删除废弃代码

1 files changed, 0 insertions, 48 deletions

diff --git a/server/apps/util.py b/server/apps/util.py
index 3ef9063..67227e4 100644
--- a/server/apps/util.py
+++ b/server/apps/util.py
@@ -154,52 +154,12 @@ class DataHandler:
         `USER_PWD_HASH` varchar(255),
         `USER_GROUP` varchar(255)) ENGINE=innodb DEFAULT CHARSET=utf8;""" % MYSQL_TAB_USER
 
-        # 外键，考虑重复外键的处理
-        # fkey1 = """
-        # ALTER TABLE %s DROP FOREIGN KEY IF EXISTS `fk_SYSLOG_USER_1`;
-        # ALTER TABLE %s ADD CONSTRAINT `fk_SYSLOG_USER_1`
-        # FOREIGN KEY(`USER_ID`) REFERENCES %s(`USER_ID`);""" % (MYSQL_TAB_SYSLOG, MYSQL_TAB_SYSLOG, MYSQL_TAB_USER)
-
-        # fkey2 = """
-        # ALTER TABLE %s DROP FOREIGN KEY IF EXISTS `fk_TASK_AGENT_1`;
-        # ALTER TABLE %s ADD CONSTRAINT `fk_TASK_AGENT_1`
-        # FOREIGN KEY(`AGENT_ID`) REFERENCES %s(`AGENT_ID`);""" % (MYSQL_TAB_TASK, MYSQL_TAB_TASK, MYSQL_TAB_AGENT)
-
-        # fkey3 = """
-        # ALTER TABLE %s DROP FOREIGN KEY IF EXISTS `fk_TASK_USER_1`;
-        # ALTER TABLE %s ADD CONSTRAINT `fk_TASK_USER_1`
-        # FOREIGN KEY(`CREATED_BY`) REFERENCES %s(`USER_ID`);""" % (MYSQL_TAB_TASK, MYSQL_TAB_TASK, 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)
 
-        # fkey5 = """
-        # ALTER TABLE %s DROP FOREIGN KEY IF EXISTS `fk_TASK_LOG_AGENT_1`;
-        # ALTER TABLE %s ADD CONSTRAINT `fk_TASK_LOG_AGENT_1`
-        # FOREIGN KEY(`CREATED_BY_AGENT`) REFERENCES %s(`AGENT_ID`);""" % (
-        #     MYSQL_TAB_TASK_LOG, MYSQL_TAB_TASK_LOG, MYSQL_TAB_AGENT)
-
-        # fkey6 = """
-        # ALTER TABLE %s DROP FOREIGN KEY IF EXISTS `fk_TASK_LOG_TASK_POLICY_1`;
-        # ALTER TABLE %s ADD CONSTRAINT `fk_TASK_LOG_TASK_POLICY_1`
-        #                 FOREIGN KEY(`TLOG_TP`) REFERENCES %s(`TP_ID`);""" % (
-        #     MYSQL_TAB_TASK_LOG, MYSQL_TAB_TASK_LOG, MYSQL_TAB_TASKPOLICY)
-
-        # fkey7 = """
-        # ALTER TABLE %s DROP FOREIGN KEY IF EXISTS `fk_TASK_POLICY_POLICY_1`;
-        # ALTER TABLE %s ADD CONSTRAINT `fk_TASK_POLICY_POLICY_1`
-        # FOREIGN KEY(`POLICY`) REFERENCES %s(`P_ID`);""" % (
-        #     MYSQL_TAB_TASKPOLICY, MYSQL_TAB_TASKPOLICY, MYSQL_TAB_POLICY)
-
-        # fkey8 = """
-        # ALTER TABLE %s DROP FOREIGN KEY IF EXISTS `fk_TASK_POLICY_TASK_1`;
-        # ALTER TABLE %s ADD CONSTRAINT `fk_TASK_POLICY_TASK_1`
-        # FOREIGN KEY(`FOR_TASK`) REFERENCES %s(`TASK_ID`);""" % (
-        #     MYSQL_TAB_TASKPOLICY, MYSQL_TAB_TASKPOLICY, MYSQL_TAB_TASK)
-
         # 执行sql语句
         try:
             # 创建数据库
@@ -220,14 +180,6 @@ class DataHandler:
 
             # 创建外键
             self.cursor.execute(fkey)
-            # self.cursor.execute(fkey2)
-            # self.cursor.execute(fkey3)
-            # self.cursor.execute(fkey4)
-            # self.cursor.execute(fkey5)
-            # self.cursor.execute(fkey6)
-            # self.cursor.execute(fkey7)
-            # self.cursor.execute(fkey8)
-            # self.conn.commit()
         except Exception as e:
             # 重复外键
             if str(e).find("(1826"):