SET NAMES 'utf8'

SELECT pref_name, pref_value FROM {prefs}

SELECT pref_value FROM {prefs} WHERE pref_name = ?

PREPARE MDB2_STATEMENT_mysql_8f4573b916ad80bcfaee9dd5d9a33295a440d7731 FROM 'SELECT pref_value FROM flyspray_prefs WHERE pref_name = ?'

PREPARE MDB2_STATEMENT_mysql_8f4573b916ad80bcfaee9dd5d9a33295a440d7731 FROM 'SELECT pref_value FROM flyspray_prefs WHERE pref_name = ?'

SET @0 = 'fs_ver'

EXECUTE MDB2_STATEMENT_mysql_8f4573b916ad80bcfaee9dd5d9a33295a440d7731 USING @0

DEALLOCATE PREPARE MDB2_STATEMENT_mysql_8f4573b916ad80bcfaee9dd5d9a33295a440d7731

Starting transaction/savepoint


-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-

START TRANSACTION (that's mine! need the whole procedure in a transaction. nested transaction makes no difference btw.)

-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-


SELECT pref_name FROM {prefs}

INSERT INTO `{prefs}` (`pref_name`, `pref_value`) VALUES (?, ?)

PREPARE MDB2_STATEMENT_mysql_0fe5c9eab4e51ea682925eaf14d07de5b12f64732 FROM 'INSERT INTO `flyspray_prefs` (`pref_name`, `pref_value`) VALUES (?, ?)'

DEALLOCATE PREPARE MDB2_STATEMENT_mysql_0fe5c9eab4e51ea682925eaf14d07de5b12f64732

DELETE FROM {prefs} WHERE pref_name = ?

PREPARE MDB2_STATEMENT_mysql_c293417d9b62c8b053acfcfeb46e9853669855c33 FROM 'DELETE FROM flyspray_prefs WHERE pref_name = ?'

DEALLOCATE PREPARE MDB2_STATEMENT_mysql_c293417d9b62c8b053acfcfeb46e9853669855c33

SELECT pref_value FROM {prefs} WHERE pref_name = ?

PREPARE MDB2_STATEMENT_mysql_bf01507f945130bd92241bd3d09a9c7c00e3066c4 FROM 'SELECT pref_value FROM flyspray_prefs WHERE pref_name = ?'

PREPARE MDB2_STATEMENT_mysql_bf01507f945130bd92241bd3d09a9c7c00e3066c4 FROM 'SELECT pref_value FROM flyspray_prefs WHERE pref_name = ?'

SET @0 = 'upgrader_done'

EXECUTE MDB2_STATEMENT_mysql_bf01507f945130bd92241bd3d09a9c7c00e3066c4 USING @0

DEALLOCATE PREPARE MDB2_STATEMENT_mysql_bf01507f945130bd92241bd3d09a9c7c00e3066c4

DELETE FROM `{notifications}` WHERE user_id = 0 OR task_id = 0

DELETE FROM `{notification_recipients}` WHERE 1=1

DELETE FROM `{notification_messages}` WHERE 1=1

DELETE FROM `{cache}` WHERE 1=1


-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-

here obviously the database definition is being fetched (note: no new transaction)

-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-


SHOW /*!50002 FULL*/ TABLES/*!50002 WHERE Table_type = 'BASE TABLE'*/

SHOW COLUMNS FROM `flyspray_admin_requests`

SHOW COLUMNS FROM `flyspray_admin_requests` LIKE 'request_id'

... (and so on)

SHOW COLUMNS FROM `flyspray_votes` LIKE 'user_id'

SHOW COLUMNS FROM `flyspray_votes` LIKE 'task_id'

SHOW COLUMNS FROM `flyspray_votes` LIKE 'date_time'

SHOW INDEX FROM `flyspray_votes`

SHOW INDEX FROM `flyspray_votes` /*!50002 WHERE Key_name = 'votes_task' */

SHOW INDEX FROM `flyspray_votes` /*!50002 WHERE Key_name = 'votes_task' */

SHOW INDEX FROM `flyspray_votes`

SHOW INDEX FROM `flyspray_votes` /*!50002 WHERE Key_name = 'primary' */

SHOW TABLES

Rolling back transaction/savepoint


-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-v-

ROLLBACK  ( the only thing that follows getDefinitionFromDatabase() is die() so there shouldn't be any rollback - at least not without starting a new one)

-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-