Message6781
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. |
|
Date |
User |
Action |
Args |
2019-10-28 20:27:27 | whunger | set | messageid: <1572294447.29.0.744652198903.issue2550725@roundup.psfhosted.org> |
2019-10-28 20:27:27 | whunger | set | recipients:
+ whunger, richard, schlatterbeck, rouilj |
2019-10-28 20:27:27 | whunger | link | issue2550725 messages |
2019-10-28 20:27:27 | whunger | create | |
|