/usr/lib/python2.7/dist-packages/framework/subsystems/opimd/db/upgrade-2.1.sql is in fso-frameworkd 0.10.1-3.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 | -- delete deprecated MessageRead values
DELETE FROM messages_boolean WHERE (field_name = 'MessageRead' or field_name = 'MessageSent') AND value = 1;
-- invert MessageRead and MessageSent to be used as New
UPDATE messages_boolean SET value = NOT value WHERE field_name = 'MessageRead' OR field_name = 'MessageSent';
-- rename MessageRead and MessageSent to New
UPDATE messages_boolean SET field_name = 'New' WHERE field_name = 'MessageRead' OR field_name = 'MessageSent';
-- update version info
REPLACE INTO info VALUES('version', '2.1');
|