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)
-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-^-