This looks to be working in postgres but not in mysql.
I wonder if it's due to the triggers having things like:
UPDATE "usr" SET unread = unread + 1 WHERE id = NEW.usr
Where the table name is escaped in the postgres way, I wonder if it needs to be like
UPDATE `usr` SET unread = unread + 1 WHERE id = NEW.usr
Which if true then there will be a bunch of triggers that need fixing up for MySql
This looks to be working in postgres but not in mysql.
I wonder if it's due to the triggers having things like:
UPDATE "usr" SET unread = unread + 1 WHERE id = NEW.usr
Where the table name is escaped in the postgres way, I wonder if it needs to be like
UPDATE `usr` SET unread = unread + 1 WHERE id = NEW.usr
Which if true then there will be a bunch of triggers that need fixing up for MySql