Roundup Tracker - Issues

Message6781

Author whunger
Recipients richard, rouilj, schlatterbeck, whunger
Date 2019-10-28.20:27:27
Message-id <1572294447.29.0.744652198903.issue2550725@roundup.psfhosted.org>
In-reply-to
Thanks for reminding me!

> Were you able to track down what you did?

No, there's no SQL file or log left, sorry. I think i dropped the
indexes, altered the columns manually, then recreated the indexes, all
directly in MySQL.

This is what we are using in back_mysql.py since 2011:

    def create_multilink_table(self, spec, ml):
        sql = '''CREATE TABLE `%s_%s` (linkid INTEGER,
            nodeid INTEGER) ENGINE=%s'''%(spec.classname, ml,
                self.mysql_backend)
        self.sql(sql)
        self.create_multilink_table_indexes(spec, ml)

I went through our backend code changes, and this one seems to be the
only one regarding the linkid/nodeid types.
History
Date User Action Args
2019-10-28 20:27:27whungersetmessageid: <1572294447.29.0.744652198903.issue2550725@roundup.psfhosted.org>
2019-10-28 20:27:27whungersetrecipients: + whunger, richard, schlatterbeck, rouilj
2019-10-28 20:27:27whungerlinkissue2550725 messages
2019-10-28 20:27:27whungercreate