ActiveRecord::SchemaMigration Load (0.5ms) SELECT "schema_migrations".* FROM "schema_migrations"  (0.1ms) begin transaction Fixture Delete (0.2ms) DELETE FROM "projects" Fixture Insert (0.2ms) INSERT INTO "projects" ("created_on", "name", "updated_on", "id", "description", "homepage", "is_public", "identifier", "parent_id", "lft", "rgt") VALUES ('2006-07-20 02:13:59.000000', 'eCookbook', '2006-07-20 05:53:01.000000', 1, 'Recipes management application', 'http://ecookbook.somenet.foo/', 't', 'ecookbook', NULL, 1, 10) Fixture Insert (0.1ms) INSERT INTO "projects" ("created_on", "name", "updated_on", "id", "description", "homepage", "is_public", "identifier", "parent_id", "lft", "rgt") VALUES ('2006-07-20 02:14:19.000000', 'OnlineStore', '2006-07-20 02:14:19.000000', 2, 'E-commerce web site', '', 'f', 'onlinestore', NULL, 11, 12) Fixture Insert (0.1ms) INSERT INTO "projects" ("created_on", "name", "updated_on", "id", "description", "homepage", "is_public", "identifier", "parent_id", "lft", "rgt") VALUES ('2006-07-20 02:15:21.000000', 'eCookbook Subproject 1', '2006-07-20 02:18:12.000000', 3, 'eCookBook Subproject 1', '', 't', 'subproject1', 1, 6, 7) Fixture Insert (0.1ms) INSERT INTO "projects" ("created_on", "name", "updated_on", "id", "description", "homepage", "is_public", "identifier", "parent_id", "lft", "rgt") VALUES ('2006-07-20 02:15:51.000000', 'eCookbook Subproject 2', '2006-07-20 02:17:07.000000', 4, 'eCookbook Subproject 2', '', 't', 'subproject2', 1, 8, 9) Fixture Insert (0.1ms) INSERT INTO "projects" ("created_on", "name", "updated_on", "id", "description", "homepage", "is_public", "identifier", "parent_id", "lft", "rgt") VALUES ('2006-07-20 02:15:51.000000', 'Private child of eCookbook', '2006-07-20 02:17:07.000000', 5, 'This is a private subproject of a public project', '', 'f', 'private-child', 1, 2, 5) Fixture Insert (0.1ms) INSERT INTO "projects" ("created_on", "name", "updated_on", "id", "description", "homepage", "is_public", "identifier", "parent_id", "lft", "rgt") VALUES ('2006-07-20 02:15:51.000000', 'Child of private child', '2006-07-20 02:17:07.000000', 6, 'This is a public subproject of a private project', '', 't', 'project6', 5, 3, 4) Fixture Delete (0.1ms) DELETE FROM "users" Fixture Insert (0.1ms) INSERT INTO "users" ("created_on", "status", "last_login_on", "language", "salt", "hashed_password", "updated_on", "admin", "lastname", "firstname", "id", "auth_source_id", "mail_notification", "login", "type") VALUES ('2006-07-20 02:12:21.000000', 1, '2006-07-20 05:57:52.000000', 'en', '82090c953c4a0000a7db253b0691a6b4', 'b5b6ff9543bf1387374cdfa27a54c96d236a7150', '2006-07-20 05:57:52.000000', 't', 'Admin', 'Redmine', 1, NULL, 'all', 'admin', 'User') Fixture Insert (0.1ms) INSERT INTO "users" ("created_on", "status", "last_login_on", "language", "salt", "hashed_password", "updated_on", "admin", "lastname", "firstname", "id", "auth_source_id", "mail_notification", "login", "type") VALUES ('2006-07-20 02:32:09.000000', 1, '2006-07-20 05:42:15.000000', 'en', '67eb4732624d5a7753dcea7ce0bb7d7d', 'bfbe06043353a677d0215b26a5800d128d5413bc', '2006-07-20 05:42:15.000000', 'f', 'Smith', 'John', 2, NULL, 'all', 'jsmith', 'User') Fixture Insert (0.1ms) INSERT INTO "users" ("created_on", "status", "last_login_on", "language", "salt", "hashed_password", "updated_on", "admin", "lastname", "firstname", "id", "auth_source_id", "mail_notification", "login", "type") VALUES ('2006-07-20 02:33:19.000000', 1, NULL, 'en', '7599f9963ec07b5a3b55b354407120c0', '8f659c8d7c072f189374edacfa90d6abbc26d8ed', '2006-07-20 02:33:19.000000', 'f', 'Lopper', 'Dave', 3, NULL, 'all', 'dlopper', 'User') Fixture Insert (0.1ms) INSERT INTO "users" ("created_on", "status", "last_login_on", "language", "salt", "hashed_password", "updated_on", "admin", "lastname", "firstname", "id", "auth_source_id", "mail_notification", "login", "type") VALUES ('2006-07-20 02:34:07.000000', 1, NULL, 'en', '3126f764c3c5ac61cbfc103f25f934cf', '9e4dd7eeb172c12a0691a6d9d3a269f7e9fe671b', '2006-07-20 02:34:07.000000', 'f', 'Hill', 'Robert', 4, NULL, 'all', 'rhill', 'User') Fixture Insert (0.1ms) INSERT INTO "users" ("id", "created_on", "status", "last_login_on", "language", "hashed_password", "updated_on", "admin", "lastname", "firstname", "auth_source_id", "mail_notification", "login", "type") VALUES (5, '2006-07-20 02:33:19.000000', 3, NULL, 'en', '1', '2006-07-20 02:33:19.000000', 'f', 'Lopper2', 'Dave2', NULL, 'all', 'dlopper2', 'User') Fixture Insert (0.1ms) INSERT INTO "users" ("id", "created_on", "status", "last_login_on", "language", "hashed_password", "updated_on", "admin", "lastname", "firstname", "auth_source_id", "mail_notification", "login", "type") VALUES (6, '2006-07-20 02:33:19.000000', 0, NULL, '', '1', '2006-07-20 02:33:19.000000', 'f', 'Anonymous', '', NULL, 'only_my_events', '', 'AnonymousUser') Fixture Insert (0.1ms) INSERT INTO "users" ("id", "created_on", "status", "last_login_on", "language", "salt", "hashed_password", "updated_on", "admin", "lastname", "firstname", "auth_source_id", "mail_notification", "login", "type") VALUES (7, '2006-07-20 02:33:19.000000', 1, NULL, 'en', '7599f9963ec07b5a3b55b354407120c0', '8f659c8d7c072f189374edacfa90d6abbc26d8ed', '2006-07-20 02:33:19.000000', 'f', 'One', 'Some', NULL, 'only_my_events', 'someone', 'User') Fixture Insert (0.1ms) INSERT INTO "users" ("id", "created_on", "status", "last_login_on", "language", "salt", "hashed_password", "updated_on", "admin", "lastname", "firstname", "auth_source_id", "mail_notification", "login", "type") VALUES (8, '2006-07-20 02:33:19.000000', 1, NULL, 'it', '7599f9963ec07b5a3b55b354407120c0', '8f659c8d7c072f189374edacfa90d6abbc26d8ed', '2006-07-20 02:33:19.000000', 'f', 'Misc', 'User', NULL, 'only_my_events', 'miscuser8', 'User') Fixture Insert (0.1ms) INSERT INTO "users" ("id", "created_on", "status", "last_login_on", "language", "hashed_password", "updated_on", "admin", "lastname", "firstname", "auth_source_id", "mail_notification", "login", "type") VALUES (9, '2006-07-20 02:33:19.000000', 1, NULL, 'it', '1', '2006-07-20 02:33:19.000000', 'f', 'Misc', 'User', NULL, 'only_my_events', 'miscuser9', 'User') Fixture Insert (0.1ms) INSERT INTO "users" ("id", "lastname", "type", "status", "created_on", "updated_on") VALUES (10, 'A Team', 'Group', 1, '2015-02-14 20:06:46', '2015-02-14 20:06:46') Fixture Insert (0.1ms) INSERT INTO "users" ("id", "lastname", "type", "status", "created_on", "updated_on") VALUES (11, 'B Team', 'Group', 1, '2015-02-14 20:06:46', '2015-02-14 20:06:46') Fixture Insert (0.1ms) INSERT INTO "users" ("id", "lastname", "type", "status", "created_on", "updated_on") VALUES (12, 'Non member users', 'GroupNonMember', 1, '2015-02-14 20:06:46', '2015-02-14 20:06:46') Fixture Insert (0.1ms) INSERT INTO "users" ("id", "lastname", "type", "status", "created_on", "updated_on") VALUES (13, 'Anonymous users', 'GroupAnonymous', 1, '2015-02-14 20:06:46', '2015-02-14 20:06:46') Fixture Delete (0.1ms) DELETE FROM "email_addresses" Fixture Insert (0.1ms) INSERT INTO "email_addresses" ("id", "user_id", "address", "is_default", "created_on", "updated_on") VALUES (1, 1, 'admin@somenet.foo', 't', '2006-07-20 02:34:07.000000', '2006-07-20 02:34:07.000000') Fixture Insert (0.1ms) INSERT INTO "email_addresses" ("id", "user_id", "address", "is_default", "created_on", "updated_on") VALUES (2, 2, 'jsmith@somenet.foo', 't', '2006-07-20 02:34:07.000000', '2006-07-20 02:34:07.000000') Fixture Insert (0.1ms) INSERT INTO "email_addresses" ("id", "user_id", "address", "is_default", "created_on", "updated_on") VALUES (3, 3, 'dlopper@somenet.foo', 't', '2006-07-20 02:34:07.000000', '2006-07-20 02:34:07.000000') Fixture Insert (0.1ms) INSERT INTO "email_addresses" ("id", "user_id", "address", "is_default", "created_on", "updated_on") VALUES (4, 4, 'rhill@somenet.foo', 't', '2006-07-20 02:34:07.000000', '2006-07-20 02:34:07.000000') Fixture Insert (0.1ms) INSERT INTO "email_addresses" ("id", "user_id", "address", "is_default", "created_on", "updated_on") VALUES (5, 5, 'dlopper2@somenet.foo', 't', '2006-07-20 02:34:07.000000', '2006-07-20 02:34:07.000000') Fixture Insert (0.1ms) INSERT INTO "email_addresses" ("id", "user_id", "address", "is_default", "created_on", "updated_on") VALUES (7, 7, 'someone@foo.bar', 't', '2006-07-20 02:34:07.000000', '2006-07-20 02:34:07.000000') Fixture Insert (0.1ms) INSERT INTO "email_addresses" ("id", "user_id", "address", "is_default", "created_on", "updated_on") VALUES (8, 8, 'miscuser8@foo.bar', 't', '2006-07-20 02:34:07.000000', '2006-07-20 02:34:07.000000') Fixture Insert (0.2ms) INSERT INTO "email_addresses" ("id", "user_id", "address", "is_default", "created_on", "updated_on") VALUES (9, 9, 'miscuser9@foo.bar', 't', '2006-07-20 02:34:07.000000', '2006-07-20 02:34:07.000000') Fixture Delete (0.1ms) DELETE FROM "members" Fixture Insert (0.1ms) INSERT INTO "members" ("created_on", "project_id", "id", "user_id", "mail_notification") VALUES ('2006-07-20 02:35:33.000000', 1, 1, 2, 't') Fixture Insert (0.1ms) INSERT INTO "members" ("created_on", "project_id", "id", "user_id", "mail_notification") VALUES ('2006-07-20 02:35:36.000000', 1, 2, 3, 't') Fixture Insert (0.1ms) INSERT INTO "members" ("created_on", "project_id", "id", "user_id", "mail_notification") VALUES ('2006-07-20 02:35:36.000000', 2, 3, 2, 't') Fixture Insert (0.1ms) INSERT INTO "members" ("id", "created_on", "project_id", "user_id", "mail_notification") VALUES (4, '2006-07-20 02:35:36.000000', 1, 5, 't') Fixture Insert (0.1ms) INSERT INTO "members" ("id", "created_on", "project_id", "user_id", "mail_notification") VALUES (5, '2006-07-20 02:35:33.000000', 5, 2, 't') Fixture Insert (0.1ms) INSERT INTO "members" ("id", "created_on", "project_id", "user_id", "mail_notification") VALUES (6, '2006-07-20 02:35:33.000000', 5, 10, 'f') Fixture Insert (0.1ms) INSERT INTO "members" ("id", "created_on", "project_id", "user_id", "mail_notification") VALUES (7, '2006-07-20 02:35:33.000000', 5, 8, 'f') Fixture Insert (0.1ms) INSERT INTO "members" ("created_on", "project_id", "id", "user_id", "mail_notification") VALUES ('2006-07-20 02:35:33.000000', 5, 8, 1, 't') Fixture Insert (0.1ms) INSERT INTO "members" ("id", "created_on", "project_id", "user_id", "mail_notification") VALUES (9, '2006-07-20 02:35:33.000000', 2, 11, 'f') Fixture Insert (0.1ms) INSERT INTO "members" ("id", "created_on", "project_id", "user_id", "mail_notification") VALUES (10, '2006-07-20 02:35:33.000000', 2, 8, 'f') Fixture Delete (0.1ms) DELETE FROM "member_roles" Fixture Insert (0.1ms) INSERT INTO "member_roles" ("id", "role_id", "member_id") VALUES (1, 1, 1) Fixture Insert (0.1ms) INSERT INTO "member_roles" ("id", "role_id", "member_id") VALUES (2, 2, 2) Fixture Insert (0.1ms) INSERT INTO "member_roles" ("id", "role_id", "member_id") VALUES (3, 2, 3) Fixture Insert (0.1ms) INSERT INTO "member_roles" ("id", "role_id", "member_id") VALUES (4, 2, 4) Fixture Insert (0.1ms) INSERT INTO "member_roles" ("id", "role_id", "member_id") VALUES (5, 1, 5) Fixture Insert (0.1ms) INSERT INTO "member_roles" ("id", "role_id", "member_id") VALUES (6, 1, 6) Fixture Insert (0.1ms) INSERT INTO "member_roles" ("id", "role_id", "member_id") VALUES (7, 2, 6) Fixture Insert (0.1ms) INSERT INTO "member_roles" ("id", "role_id", "member_id", "inherited_from") VALUES (8, 1, 7, 6) Fixture Insert (0.1ms) INSERT INTO "member_roles" ("id", "role_id", "member_id", "inherited_from") VALUES (9, 2, 7, 7) Fixture Insert (0.1ms) INSERT INTO "member_roles" ("id", "role_id", "member_id", "inherited_from") VALUES (10, 2, 9, NULL) Fixture Insert (0.1ms) INSERT INTO "member_roles" ("id", "role_id", "member_id", "inherited_from") VALUES (11, 2, 10, 10) Fixture Delete (0.1ms) DELETE FROM "roles" Fixture Insert (0.1ms) INSERT INTO "roles" ("name", "id", "builtin", "issues_visibility", "users_visibility", "permissions", "position") VALUES ('Manager', 1, 0, 'all', 'all', '--- - :add_project - :edit_project - :close_project - :select_project_modules - :manage_members - :manage_versions - :manage_categories - :view_issues - :add_issues - :edit_issues - :copy_issues - :manage_issue_relations - :manage_subtasks - :add_issue_notes - :delete_issues - :view_issue_watchers - :add_issue_watchers - :set_issues_private - :set_notes_private - :view_private_notes - :delete_issue_watchers - :manage_public_queries - :save_queries - :view_gantt - :view_calendar - :log_time - :view_time_entries - :edit_time_entries - :delete_time_entries - :manage_news - :comment_news - :view_documents - :add_documents - :edit_documents - :delete_documents - :view_wiki_pages - :export_wiki_pages - :view_wiki_edits - :edit_wiki_pages - :delete_wiki_pages_attachments - :protect_wiki_pages - :delete_wiki_pages - :rename_wiki_pages - :add_messages - :edit_messages - :delete_messages - :manage_boards - :view_files - :manage_files - :browse_repository - :manage_repository - :view_changesets - :manage_related_issues - :manage_project_activities ', 1) Fixture Insert (0.1ms) INSERT INTO "roles" ("name", "id", "builtin", "issues_visibility", "users_visibility", "permissions", "position") VALUES ('Developer', 2, 0, 'default', 'all', '--- - :edit_project - :manage_members - :manage_versions - :manage_categories - :view_issues - :add_issues - :edit_issues - :copy_issues - :manage_issue_relations - :manage_subtasks - :add_issue_notes - :delete_issues - :view_issue_watchers - :save_queries - :view_gantt - :view_calendar - :log_time - :view_time_entries - :edit_own_time_entries - :manage_news - :comment_news - :view_documents - :add_documents - :edit_documents - :delete_documents - :view_wiki_pages - :view_wiki_edits - :edit_wiki_pages - :protect_wiki_pages - :delete_wiki_pages - :add_messages - :edit_own_messages - :delete_own_messages - :manage_boards - :view_files - :manage_files - :browse_repository - :view_changesets ', 2) Fixture Insert (0.1ms) INSERT INTO "roles" ("name", "id", "builtin", "issues_visibility", "users_visibility", "permissions", "position") VALUES ('Reporter', 3, 0, 'default', 'all', '--- - :edit_project - :manage_members - :manage_versions - :manage_categories - :view_issues - :add_issues - :edit_issues - :manage_issue_relations - :add_issue_notes - :view_issue_watchers - :save_queries - :view_gantt - :view_calendar - :log_time - :view_time_entries - :manage_news - :comment_news - :view_documents - :add_documents - :edit_documents - :delete_documents - :view_wiki_pages - :view_wiki_edits - :edit_wiki_pages - :delete_wiki_pages - :add_messages - :manage_boards - :view_files - :manage_files - :browse_repository - :view_changesets ', 3) Fixture Insert (0.1ms) INSERT INTO "roles" ("name", "id", "builtin", "issues_visibility", "users_visibility", "permissions", "position") VALUES ('Non member', 4, 1, 'default', 'all', '--- - :view_issues - :add_issues - :edit_issues - :manage_issue_relations - :add_issue_notes - :save_queries - :view_gantt - :view_calendar - :log_time - :view_time_entries - :comment_news - :view_documents - :view_wiki_pages - :view_wiki_edits - :edit_wiki_pages - :add_messages - :view_files - :manage_files - :browse_repository - :view_changesets ', 4) Fixture Insert (0.1ms) INSERT INTO "roles" ("name", "id", "builtin", "issues_visibility", "users_visibility", "permissions", "position") VALUES ('Anonymous', 5, 2, 'default', 'all', '--- - :view_issues - :add_issue_notes - :view_gantt - :view_calendar - :view_time_entries - :view_documents - :view_wiki_pages - :view_wiki_edits - :view_files - :browse_repository - :view_changesets ', 5) Fixture Delete (0.1ms) DELETE FROM "groups_users" Fixture Insert (0.0ms) INSERT INTO "groups_users" ("group_id", "user_id") VALUES (10, 8) Fixture Insert (0.0ms) INSERT INTO "groups_users" ("group_id", "user_id") VALUES (11, 8) Fixture Delete (0.1ms) DELETE FROM "trackers" Fixture Insert (0.1ms) INSERT INTO "trackers" ("name", "id", "is_in_chlog", "default_status_id", "position") VALUES ('Bug', 1, 't', 1, 1) Fixture Insert (0.1ms) INSERT INTO "trackers" ("name", "id", "is_in_chlog", "default_status_id", "position") VALUES ('Feature request', 2, 't', 1, 2) Fixture Insert (0.1ms) INSERT INTO "trackers" ("name", "id", "is_in_chlog", "default_status_id", "position") VALUES ('Support request', 3, 'f', 1, 3) Fixture Delete (0.1ms) DELETE FROM "projects_trackers" Fixture Insert (0.1ms) INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (4, 3) Fixture Insert (0.0ms) INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (1, 1) Fixture Insert (0.0ms) INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (5, 1) Fixture Insert (0.0ms) INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (1, 2) Fixture Insert (0.0ms) INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (5, 2) Fixture Insert (0.0ms) INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (5, 3) Fixture Insert (0.0ms) INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (2, 1) Fixture Insert (0.0ms) INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (2, 2) Fixture Insert (0.0ms) INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (2, 3) Fixture Insert (0.0ms) INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (3, 2) Fixture Insert (0.0ms) INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (3, 3) Fixture Insert (0.0ms) INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (4, 1) Fixture Insert (0.0ms) INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (4, 2) Fixture Insert (0.1ms) INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (1, 3) Fixture Insert (0.0ms) INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (6, 1) Fixture Delete (0.1ms) DELETE FROM "enabled_modules" Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('issue_tracking', 1, 1) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('time_tracking', 1, 2) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('news', 1, 3) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('documents', 1, 4) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('files', 1, 5) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('wiki', 1, 6) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('repository', 1, 7) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('boards', 1, 8) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('repository', 3, 9) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('wiki', 3, 10) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('issue_tracking', 2, 11) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('time_tracking', 3, 12) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('issue_tracking', 3, 13) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('issue_tracking', 5, 14) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('wiki', 2, 15) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('boards', 2, 16) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('calendar', 1, 17) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('gantt', 1, 18) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('calendar', 2, 19) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('gantt', 2, 20) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('calendar', 3, 21) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('gantt', 3, 22) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('calendar', 5, 23) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('gantt', 5, 24) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('news', 2, 25) Fixture Insert (0.1ms) INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('repository', 2, 26) Fixture Delete (0.1ms) DELETE FROM "versions" Fixture Insert (0.1ms) INSERT INTO "versions" ("created_on", "name", "project_id", "updated_on", "id", "description", "effective_date", "status", "sharing") VALUES ('2006-07-20 04:00:07.000000', '0.1', 1, '2006-07-20 04:00:07.000000', 1, 'Beta', '2006-07-01', 'closed', 'none') Fixture Insert (0.1ms) INSERT INTO "versions" ("created_on", "name", "project_id", "updated_on", "id", "description", "effective_date", "status", "sharing") VALUES ('2006-07-20 04:00:33.000000', '1.0', 1, '2006-07-20 04:00:33.000000', 2, 'Stable release', '2015-03-06', 'locked', 'none') Fixture Insert (0.1ms) INSERT INTO "versions" ("created_on", "name", "project_id", "updated_on", "id", "description", "effective_date", "status", "sharing") VALUES ('2006-07-20 04:00:33.000000', '2.0', 1, '2006-07-20 04:00:33.000000', 3, 'Future version', NULL, 'open', 'none') Fixture Insert (0.1ms) INSERT INTO "versions" ("created_on", "name", "project_id", "updated_on", "id", "description", "effective_date", "status", "sharing") VALUES ('2006-07-20 04:00:33.000000', '2.0', 3, '2006-07-20 04:00:33.000000', 4, 'Future version on subproject', NULL, 'open', 'tree') Fixture Insert (0.1ms) INSERT INTO "versions" ("created_on", "name", "project_id", "updated_on", "id", "description", "effective_date", "status", "sharing") VALUES ('2006-07-20 04:00:07.000000', 'Alpha', 2, '2006-07-20 04:00:07.000000', 5, 'Private Alpha', '2006-07-01', 'open', 'none') Fixture Insert (0.1ms) INSERT INTO "versions" ("created_on", "name", "project_id", "updated_on", "id", "description", "effective_date", "status", "sharing") VALUES ('2006-07-20 04:00:07.000000', 'Private Version of public subproject', 5, '2006-07-20 04:00:07.000000', 6, 'Should be done any day now...', NULL, 'open', 'tree') Fixture Insert (0.1ms) INSERT INTO "versions" ("created_on", "name", "project_id", "updated_on", "id", "description", "effective_date", "status", "sharing") VALUES ('2006-07-20 04:00:07.000000', 'Systemwide visible version', 2, '2006-07-20 04:00:07.000000', 7, NULL, NULL, 'open', 'system') Fixture Delete (0.1ms) DELETE FROM "issue_statuses" Fixture Insert (0.1ms) INSERT INTO "issue_statuses" ("id", "name", "is_closed", "position") VALUES (1, 'New', 'f', 1) Fixture Insert (0.1ms) INSERT INTO "issue_statuses" ("id", "name", "is_closed", "position") VALUES (2, 'Assigned', 'f', 2) Fixture Insert (0.1ms) INSERT INTO "issue_statuses" ("id", "name", "is_closed", "position") VALUES (3, 'Resolved', 'f', 3) Fixture Insert (0.1ms) INSERT INTO "issue_statuses" ("name", "id", "is_closed", "position") VALUES ('Feedback', 4, 'f', 4) Fixture Insert (0.1ms) INSERT INTO "issue_statuses" ("id", "name", "is_closed", "position") VALUES (5, 'Closed', 't', 5) Fixture Insert (0.1ms) INSERT INTO "issue_statuses" ("id", "name", "is_closed", "position") VALUES (6, 'Rejected', 't', 6) Fixture Delete (0.1ms) DELETE FROM "issue_categories" Fixture Insert (0.1ms) INSERT INTO "issue_categories" ("name", "project_id", "assigned_to_id", "id") VALUES ('Printing', 1, 2, 1) Fixture Insert (0.1ms) INSERT INTO "issue_categories" ("name", "project_id", "assigned_to_id", "id") VALUES ('Recipes', 1, NULL, 2) Fixture Insert (0.1ms) INSERT INTO "issue_categories" ("name", "project_id", "assigned_to_id", "id") VALUES ('Stock management', 2, NULL, 3) Fixture Insert (0.1ms) INSERT INTO "issue_categories" ("name", "project_id", "assigned_to_id", "id") VALUES ('Printing', 2, NULL, 4) Fixture Delete (0.1ms) DELETE FROM "issue_relations" Fixture Insert (0.1ms) INSERT INTO "issue_relations" ("id", "issue_from_id", "issue_to_id", "relation_type", "delay") VALUES (1, 10, 9, 'blocks', NULL) Fixture Insert (0.1ms) INSERT INTO "issue_relations" ("id", "issue_from_id", "issue_to_id", "relation_type", "delay") VALUES (2, 2, 3, 'relates', NULL) Fixture Delete (0.1ms) DELETE FROM "workflows" Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 1, 2, 189, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 1, 1, 1, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 1, 1, 2, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 1, 1, 3, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 1, 4, 110, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 1, 1, 4, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 1, 6, 30, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 1, 5, 111, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 1, 1, 5, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 2, 1, 31, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 1, 5, 112, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 1, 2, 6, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 2, 1, 32, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 1, 5, 113, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 2, 2, 220, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 1, 2, 7, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 2, 1, 33, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 2, 6, 60, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 1, 5, 114, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 2, 4, 140, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 2, 3, 221, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 1, 2, 8, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 2, 1, 34, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 1, 5, 115, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 2, 5, 141, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 2, 3, 222, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 2, 3, 223, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 1, 2, 9, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 2, 1, 35, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 3, 1, 61, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 1, 6, 116, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 2, 5, 142, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 3, 2, 250, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 2, 3, 224, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 2, 2, 36, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 3, 1, 62, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 1, 6, 117, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 2, 5, 143, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 3, 4, 170, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 3, 3, 251, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 2, 3, 225, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 3, 1, 63, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 3, 6, 90, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 1, 6, 118, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 2, 5, 144, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 3, 3, 252, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 2, 4, 226, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 2, 2, 38, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 3, 1, 64, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 1, 1, 91, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 1, 6, 119, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 2, 5, 145, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 3, 5, 171, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 3, 3, 253, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 2, 4, 227, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 2, 2, 39, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 3, 1, 65, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 1, 1, 92, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 2, 6, 146, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 3, 5, 172, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 3, 3, 254, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 2, 4, 228, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 3, 2, 66, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 1, 1, 93, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 2, 6, 147, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 3, 5, 173, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 3, 3, 255, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 2, 4, 229, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 3, 2, 67, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 2, 6, 148, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 3, 5, 174, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 3, 4, 256, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 3, 2, 68, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 1, 1, 94, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 2, 6, 149, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 3, 5, 175, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 3, 4, 257, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 3, 2, 69, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 1, 1, 95, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 3, 6, 176, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 3, 4, 258, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 1, 2, 96, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 3, 6, 177, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 3, 4, 259, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 1, 2, 97, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 3, 6, 178, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 1, 2, 98, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 3, 6, 179, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 1, 2, 99, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 1, 2, 100, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 1, 4, 20, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 1, 3, 101, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 1, 5, 21, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 1, 3, 102, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 1, 6, 210, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 1, 5, 22, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 1, 3, 103, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 1, 5, 23, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 1, 3, 104, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 2, 2, 130, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 2, 1, 211, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 1, 5, 24, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 2, 4, 50, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 1, 3, 105, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 2, 3, 131, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 2, 1, 212, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 1, 5, 25, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 2, 5, 51, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 1, 4, 106, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 2, 3, 132, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 2, 1, 213, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 2, 6, 240, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 1, 6, 26, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 2, 5, 52, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 1, 4, 107, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 2, 3, 133, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 2, 1, 214, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 3, 1, 241, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 1, 6, 27, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 2, 5, 53, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 3, 4, 80, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 1, 4, 108, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 2, 3, 134, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 3, 2, 160, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 2, 1, 215, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 3, 1, 242, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 1, 6, 28, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 2, 5, 54, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 3, 5, 81, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 1, 4, 109, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 2, 3, 135, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 3, 3, 161, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 2, 2, 216, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 3, 1, 243, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 1, 6, 29, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 2, 5, 55, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 3, 5, 82, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 2, 4, 136, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 3, 3, 162, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 2, 2, 217, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 3, 6, 270, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 3, 1, 244, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 2, 6, 56, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 2, 4, 137, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 3, 3, 163, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 1, 2, 190, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 2, 2, 218, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 3, 1, 245, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 2, 6, 57, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 3, 5, 83, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 2, 4, 138, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 3, 3, 164, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 1, 3, 191, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 2, 2, 219, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 3, 2, 246, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 2, 6, 58, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 3, 5, 84, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 2, 4, 139, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 3, 3, 165, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 1, 3, 192, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 3, 2, 247, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 2, 6, 59, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 3, 5, 85, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 3, 4, 166, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 3, 2, 248, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 3, 6, 86, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 3, 4, 167, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 1, 3, 193, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 3, 2, 249, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 3, 6, 87, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 3, 4, 168, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 1, 3, 194, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 3, 6, 88, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 3, 4, 169, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 1, 3, 195, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 3, 6, 89, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 1, 4, 196, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 1, 4, 197, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 1, 4, 198, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 1, 4, 199, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 1, 2, 10, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 1, 3, 11, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 1, 3, 12, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 1, 4, 200, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 1, 3, 13, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 1, 6, 120, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 1, 5, 201, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 2, 2, 40, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 2, 1, 121, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 1, 5, 202, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 1, 3, 14, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 2, 3, 41, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 2, 1, 122, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 1, 5, 203, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 1, 3, 15, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 2, 4, 230, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 2, 1, 123, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 1, 5, 204, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 1, 4, 16, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 2, 3, 42, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 2, 5, 231, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 3, 2, 70, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 2, 1, 124, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 2, 6, 150, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 1, 5, 205, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 1, 4, 17, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 2, 3, 43, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 2, 5, 232, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 2, 1, 125, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 3, 1, 151, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 1, 6, 206, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 1, 4, 18, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 2, 3, 44, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 3, 3, 71, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 2, 5, 233, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 2, 2, 126, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 3, 1, 152, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 1, 6, 207, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 1, 4, 19, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 2, 3, 45, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 3, 4, 260, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 2, 5, 234, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 2, 2, 127, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 3, 1, 153, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 3, 6, 180, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 1, 6, 208, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 2, 4, 46, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 3, 3, 72, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 3, 5, 261, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 2, 5, 235, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 3, 1, 154, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 1, 1, 181, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 1, 6, 209, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 2, 4, 47, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 3, 3, 73, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 2, 2, 128, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 3, 5, 262, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 2, 6, 236, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 3, 1, 155, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 2, 4, 48, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 3, 3, 74, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 2, 2, 129, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 3, 5, 263, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 2, 6, 237, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 1, 1, 182, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 2, 4, 49, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 3, 3, 75, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 3, 2, 156, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 3, 5, 264, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 2, 6, 238, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 1, 1, 183, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 3, 4, 76, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 3, 2, 157, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 3, 5, 265, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 2, 6, 239, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 3, 4, 77, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 3, 2, 158, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 1, 1, 184, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 3, 6, 266, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 3, 4, 78, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 3, 2, 159, 2, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (6, 1, 1, 185, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (2, 3, 6, 267, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (5, 3, 4, 79, 1, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (1, 1, 2, 186, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 3, 6, 268, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (3, 1, 2, 187, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 3, 6, 269, 3, 'WorkflowTransition') Fixture Insert (0.1ms) INSERT INTO "workflows" ("new_status_id", "role_id", "old_status_id", "id", "tracker_id", "type") VALUES (4, 1, 2, 188, 3, 'WorkflowTransition') Fixture Delete (0.1ms) DELETE FROM "enumerations" Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "active", "position") VALUES ('Uncategorized', 1, 'DocumentCategory', 't', 1) Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "active", "position") VALUES ('User documentation', 2, 'DocumentCategory', 't', 2) Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "active", "position") VALUES ('Technical documentation', 3, 'DocumentCategory', 't', 3) Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "active", "position", "position_name") VALUES ('Low', 4, 'IssuePriority', 't', 1, 'lowest') Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "is_default", "active", "position", "position_name") VALUES ('Normal', 5, 'IssuePriority', 't', 't', 2, 'default') Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "active", "position", "position_name") VALUES ('High', 6, 'IssuePriority', 't', 3, 'high3') Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "active", "position", "position_name") VALUES ('Urgent', 7, 'IssuePriority', 't', 4, 'high2') Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "active", "position", "position_name") VALUES ('Immediate', 8, 'IssuePriority', 't', 5, 'highest') Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "position", "active") VALUES ('Design', 9, 'TimeEntryActivity', 1, 't') Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "position", "is_default", "active") VALUES ('Development', 10, 'TimeEntryActivity', 2, 't', 't') Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "position", "active") VALUES ('QA', 11, 'TimeEntryActivity', 3, 't') Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "is_default", "active") VALUES ('Default Enumeration', 12, 'Enumeration', 't', 't') Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "active") VALUES ('Another Enumeration', 13, 'Enumeration', 't') Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "position", "active") VALUES ('Inactive Activity', 14, 'TimeEntryActivity', 4, 'f') Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "position", "active") VALUES ('Inactive Priority', 15, 'IssuePriority', 6, 'f') Fixture Insert (0.1ms) INSERT INTO "enumerations" ("name", "id", "type", "active", "position") VALUES ('Inactive Document Category', 16, 'DocumentCategory', 'f', 4) Fixture Delete (0.1ms) DELETE FROM "issues" Fixture Insert (0.1ms) INSERT INTO "issues" ("created_on", "project_id", "updated_on", "priority_id", "subject", "id", "fixed_version_id", "category_id", "description", "tracker_id", "assigned_to_id", "author_id", "status_id", "start_date", "due_date", "root_id", "lft", "rgt", "lock_version") VALUES ('2015-02-11 20:06:46.000000', 1, '2015-02-13 20:06:46.000000', 4, 'Cannot print recipes', 1, NULL, 1, 'Unable to print recipes', 1, NULL, 2, 1, '2015-02-13', '2015-02-24', 1, 1, 2, 3) Fixture Insert (0.1ms) INSERT INTO "issues" ("created_on", "project_id", "updated_on", "priority_id", "subject", "id", "fixed_version_id", "category_id", "description", "tracker_id", "assigned_to_id", "author_id", "status_id", "start_date", "due_date", "root_id", "lft", "rgt", "lock_version", "done_ratio") VALUES ('2006-07-20 04:04:21.000000', 1, '2006-07-20 04:09:50.000000', 5, 'Add ingredients categories', 2, 2, NULL, 'Ingredients of the recipe should be classified by categories', 2, 3, 2, 2, '2015-02-12', NULL, 2, 1, 2, 3, 30) Fixture Insert (0.1ms) INSERT INTO "issues" ("created_on", "project_id", "updated_on", "priority_id", "subject", "id", "fixed_version_id", "category_id", "description", "tracker_id", "assigned_to_id", "author_id", "status_id", "start_date", "due_date", "root_id", "lft", "rgt") VALUES ('2006-07-20 04:07:27.000000', 1, '2006-07-20 04:07:27.000000', 4, 'Error 281 when updating a recipe', 3, NULL, NULL, 'Error 281 is encountered when saving a recipe', 1, 3, 2, 1, '2015-01-30', '2015-02-09', 3, 1, 2) Fixture Insert (0.1ms) INSERT INTO "issues" ("created_on", "project_id", "updated_on", "priority_id", "subject", "id", "fixed_version_id", "category_id", "description", "tracker_id", "assigned_to_id", "author_id", "status_id", "root_id", "lft", "rgt") VALUES ('2015-02-09 20:06:46.000000', 2, '2015-02-12 20:06:46.000000', 4, 'Issue on project 2', 4, NULL, NULL, 'Issue on project 2', 1, 2, 2, 1, 4, 1, 2) Fixture Insert (0.1ms) INSERT INTO "issues" ("created_on", "project_id", "updated_on", "priority_id", "subject", "id", "fixed_version_id", "category_id", "description", "tracker_id", "assigned_to_id", "author_id", "status_id", "root_id", "lft", "rgt") VALUES ('2015-02-09 20:06:46.000000', 3, '2015-02-12 20:06:46.000000', 4, 'Subproject issue', 5, NULL, NULL, 'This is an issue on a cookbook subproject', 1, NULL, 2, 1, 5, 1, 2) Fixture Insert (0.1ms) INSERT INTO "issues" ("created_on", "project_id", "updated_on", "priority_id", "subject", "id", "fixed_version_id", "category_id", "description", "tracker_id", "assigned_to_id", "author_id", "status_id", "start_date", "due_date", "root_id", "lft", "rgt") VALUES ('2015-02-14 20:05:46.000000', 5, '2015-02-14 20:05:46.000000', 4, 'Issue of a private subproject', 6, NULL, NULL, 'This is an issue of a private subproject of cookbook', 1, NULL, 2, 1, '2015-02-14', '2015-02-15', 6, 1, 2) Fixture Insert (0.1ms) INSERT INTO "issues" ("created_on", "project_id", "updated_on", "priority_id", "subject", "id", "fixed_version_id", "category_id", "description", "tracker_id", "assigned_to_id", "author_id", "status_id", "start_date", "due_date", "lock_version", "root_id", "lft", "rgt") VALUES ('2015-02-04 20:06:46.000000', 1, '2015-02-04 20:06:46.000000', 5, 'Issue due today', 7, NULL, NULL, 'This is an issue that is due today', 1, NULL, 2, 1, '2015-02-04 20:06:46.000000', '2015-02-14', 0, 7, 1, 2) Fixture Insert (0.1ms) INSERT INTO "issues" ("created_on", "project_id", "updated_on", "priority_id", "subject", "id", "fixed_version_id", "category_id", "description", "tracker_id", "assigned_to_id", "author_id", "status_id", "start_date", "due_date", "lock_version", "root_id", "lft", "rgt", "closed_on") VALUES ('2015-02-04 20:06:46.000000', 1, '2015-02-04 20:06:46.000000', 5, 'Closed issue', 8, NULL, NULL, 'This is a closed issue.', 1, NULL, 2, 5, NULL, NULL, 0, 8, 1, 2, '2015-02-11 20:06:46.000000') Fixture Insert (0.1ms) INSERT INTO "issues" ("created_on", "project_id", "updated_on", "priority_id", "subject", "id", "fixed_version_id", "category_id", "description", "tracker_id", "assigned_to_id", "author_id", "status_id", "start_date", "due_date", "root_id", "lft", "rgt") VALUES ('2015-02-14 20:05:46.000000', 5, '2015-02-14 20:05:46.000000', 5, 'Blocked Issue', 9, NULL, NULL, 'This is an issue that is blocked by issue', 1, NULL, 2, 1, '2015-02-14', '2015-02-15', 9, 1, 2) Fixture Insert (0.1ms) INSERT INTO "issues" ("created_on", "project_id", "updated_on", "priority_id", "subject", "id", "fixed_version_id", "category_id", "description", "tracker_id", "assigned_to_id", "author_id", "status_id", "start_date", "due_date", "root_id", "lft", "rgt") VALUES ('2015-02-14 20:05:46.000000', 5, '2015-02-14 20:05:46.000000', 5, 'Issue Doing the Blocking', 10, NULL, NULL, 'This is an issue that blocks issue', 1, NULL, 2, 1, '2015-02-14', '2015-02-15', 10, 1, 2) Fixture Insert (0.1ms) INSERT INTO "issues" ("created_on", "project_id", "updated_on", "priority_id", "subject", "id", "fixed_version_id", "category_id", "description", "tracker_id", "assigned_to_id", "author_id", "status_id", "start_date", "due_date", "root_id", "lft", "rgt", "closed_on") VALUES ('2015-02-11 20:06:46.000000', 1, '2015-02-13 20:06:46.000000', 5, 'Closed issue on a closed version', 11, 1, 1, NULL, 1, NULL, 2, 5, '2015-02-13', NULL, 11, 1, 2, '2015-02-13 20:06:46.000000') Fixture Insert (0.1ms) INSERT INTO "issues" ("created_on", "project_id", "updated_on", "priority_id", "subject", "id", "fixed_version_id", "category_id", "description", "tracker_id", "assigned_to_id", "author_id", "status_id", "start_date", "due_date", "root_id", "lft", "rgt", "closed_on") VALUES ('2015-02-11 20:06:46.000000', 1, '2015-02-13 20:06:46.000000', 5, 'Closed issue on a locked version', 12, 2, 1, NULL, 1, NULL, 3, 5, '2015-02-13', NULL, 12, 1, 2, '2015-02-13 20:06:46.000000') Fixture Insert (0.1ms) INSERT INTO "issues" ("created_on", "project_id", "updated_on", "priority_id", "subject", "id", "fixed_version_id", "category_id", "description", "tracker_id", "assigned_to_id", "author_id", "status_id", "root_id", "lft", "rgt") VALUES ('2015-02-09 20:06:46.000000', 3, '2015-02-12 20:06:46.000000', 4, 'Subproject issue two', 13, NULL, NULL, 'This is a second issue on a cookbook subproject', 1, NULL, 2, 1, 13, 1, 2) Fixture Insert (0.1ms) INSERT INTO "issues" ("id", "created_on", "project_id", "updated_on", "priority_id", "subject", "fixed_version_id", "category_id", "description", "tracker_id", "assigned_to_id", "author_id", "status_id", "is_private", "root_id", "lft", "rgt") VALUES (14, '2015-01-30 20:06:46.000000', 3, '2015-01-30 20:06:46.000000', 5, 'Private issue on public project', NULL, NULL, 'This is a private issue', 1, NULL, 2, 1, 't', 14, 1, 2) Fixture Delete (0.1ms) DELETE FROM "journals" Fixture Insert (0.1ms) INSERT INTO "journals" ("created_on", "notes", "id", "journalized_type", "user_id", "journalized_id") VALUES ('2015-02-12', 'Journal notes', 1, 'Issue', 1, 1) Fixture Insert (0.1ms) INSERT INTO "journals" ("created_on", "notes", "id", "journalized_type", "user_id", "journalized_id") VALUES ('2015-02-13', 'Some notes with Redmine links: #2, r2.', 2, 'Issue', 2, 1) Fixture Insert (0.1ms) INSERT INTO "journals" ("created_on", "notes", "id", "journalized_type", "user_id", "journalized_id") VALUES ('2015-02-13', 'A comment with inline image: !picture.jpg! and a reference to #1 and r2.', 3, 'Issue', 2, 2) Fixture Insert (0.1ms) INSERT INTO "journals" ("created_on", "notes", "id", "journalized_type", "user_id", "journalized_id") VALUES ('2015-02-13', 'A comment with a private version.', 4, 'Issue', 1, 6) Fixture Insert (0.1ms) INSERT INTO "journals" ("id", "created_on", "notes", "user_id", "journalized_type", "journalized_id") VALUES (5, '2015-02-13', 'A comment on a private issue.', 2, 'Issue', 14) Fixture Delete (0.1ms) DELETE FROM "journal_details" Fixture Insert (0.1ms) INSERT INTO "journal_details" ("old_value", "property", "id", "value", "prop_key", "journal_id") VALUES ('1', 'attr', 1, '2', 'status_id', 1) Fixture Insert (0.1ms) INSERT INTO "journal_details" ("old_value", "property", "id", "value", "prop_key", "journal_id") VALUES ('40', 'attr', 2, '30', 'done_ratio', 1) Fixture Insert (0.1ms) INSERT INTO "journal_details" ("old_value", "property", "id", "value", "prop_key", "journal_id") VALUES (NULL, 'attr', 3, '6', 'fixed_version_id', 4) Fixture Insert (0.1ms) INSERT INTO "journal_details" ("old_value", "property", "id", "value", "prop_key", "journal_id") VALUES ('This word was removed and an other was', 'attr', 4, 'This word was and an other was added', 'description', 3) Fixture Insert (0.1ms) INSERT INTO "journal_details" ("old_value", "property", "id", "value", "prop_key", "journal_id") VALUES ('Old value', 'cf', 5, 'New value', '2', 3) Fixture Insert (0.1ms) INSERT INTO "journal_details" ("old_value", "property", "id", "value", "prop_key", "journal_id") VALUES (NULL, 'attachment', 6, '060719210727_picture.jpg', '4', 3) Fixture Delete (0.1ms) DELETE FROM "custom_fields" Fixture Insert (0.1ms) INSERT INTO "custom_fields" ("name", "regexp", "is_for_all", "is_filter", "type", "possible_values", "id", "is_required", "field_format", "default_value", "editable", "position") VALUES ('Database', '', 't', 't', 'IssueCustomField', '--- - MySQL - PostgreSQL - Oracle ', 1, 'f', 'list', '', 't', 2) Fixture Insert (0.1ms) INSERT INTO "custom_fields" ("name", "min_length", "regexp", "is_for_all", "is_filter", "type", "max_length", "possible_values", "id", "is_required", "field_format", "searchable", "default_value", "editable", "position") VALUES ('Searchable field', 1, '', 't', 't', 'IssueCustomField', 100, '', 2, 'f', 'string', 't', 'Default string', 't', 1) Fixture Insert (0.1ms) INSERT INTO "custom_fields" ("name", "regexp", "is_for_all", "is_filter", "type", "possible_values", "id", "is_required", "field_format", "default_value", "editable", "position") VALUES ('Development status', '', 'f', 't', 'ProjectCustomField', '--- - Stable - Beta - Alpha - Planning ', 3, 'f', 'list', '', 't', 1) Fixture Insert (0.1ms) INSERT INTO "custom_fields" ("name", "regexp", "is_for_all", "type", "possible_values", "id", "is_required", "field_format", "default_value", "editable", "position") VALUES ('Phone number', '', 'f', 'UserCustomField', '', 4, 'f', 'string', '', 't', 1) Fixture Insert (0.1ms) INSERT INTO "custom_fields" ("name", "regexp", "is_for_all", "type", "possible_values", "id", "is_required", "field_format", "default_value", "editable", "position") VALUES ('Money', '', 'f', 'UserCustomField', '', 5, 'f', 'float', '', 't', 2) Fixture Insert (0.1ms) INSERT INTO "custom_fields" ("name", "regexp", "is_for_all", "type", "possible_values", "id", "is_required", "field_format", "default_value", "editable", "position") VALUES ('Float field', '', 't', 'IssueCustomField', '', 6, 'f', 'float', '', 't', 3) Fixture Insert (0.1ms) INSERT INTO "custom_fields" ("name", "regexp", "is_for_all", "is_filter", "type", "possible_values", "id", "is_required", "field_format", "default_value", "editable", "position") VALUES ('Billable', '', 'f', 't', 'TimeEntryActivityCustomField', '', 7, 'f', 'bool', '', 't', 1) Fixture Insert (0.1ms) INSERT INTO "custom_fields" ("name", "regexp", "is_for_all", "is_filter", "type", "possible_values", "id", "is_required", "field_format", "default_value", "editable", "position") VALUES ('Custom date', '', 't', 'f', 'IssueCustomField', '', 8, 'f', 'date', '', 't', 4) Fixture Insert (0.1ms) INSERT INTO "custom_fields" ("name", "regexp", "is_for_all", "is_filter", "type", "possible_values", "id", "is_required", "field_format", "default_value", "editable", "position") VALUES ('Project 1 cf', '', 'f', 't', 'IssueCustomField', '', 9, 'f', 'date', '', 't', 5) Fixture Insert (0.1ms) INSERT INTO "custom_fields" ("name", "regexp", "is_for_all", "is_filter", "type", "possible_values", "id", "is_required", "field_format", "default_value", "editable", "position") VALUES ('Overtime', '', 'f', 'f', 'TimeEntryCustomField', '', 10, 'f', 'bool', '0', 't', 1) Fixture Insert (0.1ms) INSERT INTO "custom_fields" ("id", "name", "type", "possible_values", "field_format") VALUES (11, 'Binary', 'CustomField', '--- - !binary |- SGXDqWzDp2prc2Tigqw2NTTDuQ== - Other value ', 'list') Fixture Delete (0.1ms) DELETE FROM "custom_fields_projects" Fixture Insert (0.0ms) INSERT INTO "custom_fields_projects" ("custom_field_id", "project_id") VALUES (9, 1) Fixture Delete (0.1ms) DELETE FROM "custom_fields_trackers" Fixture Insert (0.0ms) INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (1, 1) Fixture Insert (0.0ms) INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (2, 1) Fixture Insert (0.0ms) INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (2, 3) Fixture Insert (0.0ms) INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (6, 1) Fixture Insert (0.0ms) INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (6, 2) Fixture Insert (0.0ms) INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (6, 3) Fixture Insert (0.0ms) INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (8, 1) Fixture Insert (0.0ms) INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (8, 2) Fixture Insert (0.0ms) INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (8, 3) Fixture Delete (0.1ms) DELETE FROM "custom_values" Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 2, 3, 6, '125') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Project', 3, 1, 7, 'Stable') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Principal', 4, 3, 1, '') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Principal', 4, 4, 2, '01 23 45 67 89') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Principal', 4, 2, 3, '01 42 50 00 00') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 2, 1, 4, '125') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 2, 2, 5, '') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 1, 3, 8, 'MySQL') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 2, 7, 9, 'this is a stringforcustomfield search') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 6, 1, 10, '2.1') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 6, 2, 11, '2.05') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 6, 3, 12, '11.65') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 6, 7, 13, '') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 6, 5, 14, '-7.6') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Enumeration', 7, 10, 15, 't') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Enumeration', 7, 11, 16, '1') Fixture Insert (0.1ms) INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 8, 1, 17, '2009-12-01') Fixture Delete (0.1ms) DELETE FROM "time_entries" Fixture Insert (0.1ms) INSERT INTO "time_entries" ("created_on", "tweek", "tmonth", "project_id", "comments", "updated_on", "activity_id", "spent_on", "issue_id", "id", "hours", "user_id", "tyear") VALUES ('2007-03-23 20:54:18.000000', 12, 3, 1, 'My hours', '2007-03-23 20:54:18.000000', 9, '2007-03-23', 1, 1, 4.25, 2, 2007) Fixture Insert (0.1ms) INSERT INTO "time_entries" ("created_on", "tweek", "tmonth", "project_id", "comments", "updated_on", "activity_id", "spent_on", "issue_id", "id", "hours", "user_id", "tyear") VALUES ('2007-03-23 22:11:04.000000', 11, 3, 1, '', '2007-03-23 22:11:04.000000', 9, '2007-03-12', 1, 2, 150.0, 1, 2007) Fixture Insert (0.1ms) INSERT INTO "time_entries" ("created_on", "tweek", "tmonth", "project_id", "comments", "updated_on", "activity_id", "spent_on", "issue_id", "id", "hours", "user_id", "tyear") VALUES ('2007-04-21 19:20:48.000000', 16, 4, 1, '', '2007-04-21 19:20:48.000000', 9, '2007-04-21', 3, 3, 1.0, 1, 2007) Fixture Insert (0.1ms) INSERT INTO "time_entries" ("created_on", "tweek", "tmonth", "project_id", "comments", "updated_on", "activity_id", "spent_on", "issue_id", "id", "hours", "user_id", "tyear") VALUES ('2007-04-22 19:20:48.000000', 16, 4, 3, 'Time spent on a subproject', '2007-04-22 19:20:48.000000', 10, '2007-04-22', NULL, 4, 7.65, 1, 2007) Fixture Insert (0.1ms) INSERT INTO "time_entries" ("created_on", "tweek", "tmonth", "project_id", "comments", "updated_on", "activity_id", "spent_on", "issue_id", "id", "hours", "user_id", "tyear") VALUES ('2011-03-22 19:20:48.000000', 12, 3, 5, 'Time spent on a subproject', '2011-03-22 19:20:48.000000', 10, '2011-03-22', NULL, 5, 7.65, 1, 2011)  (134.1ms) commit transaction  (0.1ms) begin transaction ---------------------------------------------------------------------------------- IssueTest: test_visible_scope_for_member_with_groups_should_return_assigned_issues ---------------------------------------------------------------------------------- User Load (0.3ms) SELECT "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."id" = ? LIMIT 1 [["id", 8]] Group Exists (0.2ms) SELECT 1 AS one FROM "users" INNER JOIN "groups_users" ON "users"."id" = "groups_users"."group_id" WHERE "users"."type" IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND "groups_users"."user_id" = ? LIMIT 1 [["user_id", 8]] Group Load (0.2ms) SELECT "users".* FROM "users" INNER JOIN "groups_users" ON "users"."id" = "groups_users"."group_id" WHERE "users"."type" IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND "groups_users"."user_id" = ? ORDER BY "users"."id" ASC LIMIT 1 [["user_id", 8]]  (0.1ms) SAVEPOINT active_record_1 Role Load (0.2ms) SELECT "roles".* FROM "roles" WHERE "roles"."id" = ? LIMIT 1 [["id", 2]] Project Load (0.2ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = ? LIMIT 1 [["id", 1]] Member Exists (0.1ms) SELECT 1 AS one FROM "members" WHERE ("members"."user_id" = 10 AND "members"."project_id" = 1) LIMIT 1 SQL (0.2ms) INSERT INTO "members" ("user_id", "project_id", "created_on") VALUES (?, ?, ?) [["user_id", 10], ["project_id", 1], ["created_on", "2015-02-14 20:06:47.249866"]] SQL (0.1ms) INSERT INTO "member_roles" ("role_id", "member_id") VALUES (?, ?) [["role_id", 2], ["member_id", 11]] User Load (0.2ms) SELECT "users".* FROM "users" INNER JOIN "groups_users" ON "users"."id" = "groups_users"."user_id" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "groups_users"."group_id" = ? [["group_id", 10]] Member Load (0.1ms) SELECT "members".* FROM "members" WHERE "members"."project_id" = ? AND "members"."user_id" = ? LIMIT 1 [["project_id", 1], ["user_id", 8]] Principal Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1 [["id", 8]] Project Load (0.0ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = ? LIMIT 1 [["id", 1]] Member Exists (0.1ms) SELECT 1 AS one FROM "members" WHERE ("members"."user_id" = 8 AND "members"."project_id" = 1) LIMIT 1 SQL (0.1ms) INSERT INTO "members" ("project_id", "user_id", "created_on") VALUES (?, ?, ?) [["project_id", 1], ["user_id", 8], ["created_on", "2015-02-14 20:06:47.261785"]] SQL (0.1ms) INSERT INTO "member_roles" ("role_id", "inherited_from", "member_id") VALUES (?, ?, ?) [["role_id", 2], ["inherited_from", 12], ["member_id", 12]] Project Load (0.1ms) SELECT "projects".* FROM "projects" WHERE "projects"."parent_id" = ? ORDER BY "projects"."lft" ASC [["parent_id", 1]] Project Load (0.1ms) SELECT "projects".* FROM "projects" WHERE "projects"."parent_id" = ? ORDER BY "projects"."lft" ASC [["parent_id", 1]]  (0.1ms) RELEASE SAVEPOINT active_record_1 Role Load (0.1ms) SELECT "roles".* FROM "roles" WHERE "roles"."builtin" = ? ORDER BY "roles"."id" ASC LIMIT 1 [["builtin", 1]]  (0.0ms) SAVEPOINT active_record_1 Role Exists (0.1ms) SELECT 1 AS one FROM "roles" WHERE ("roles"."name" = 'Non member' AND "roles"."id" != 4) LIMIT 1 SQL (0.1ms) UPDATE "roles" SET "permissions" = ? WHERE "roles"."id" = ? [["permissions", "---\n- :add_issues\n- :edit_issues\n- :manage_issue_relations\n- :add_issue_notes\n- :save_queries\n- :view_gantt\n- :view_calendar\n- :log_time\n- :view_time_entries\n- :comment_news\n- :view_documents\n- :view_wiki_pages\n- :view_wiki_edits\n- :edit_wiki_pages\n- :add_messages\n- :view_files\n- :manage_files\n- :browse_repository\n- :view_changesets\n"], ["id", 4]]  (0.1ms) RELEASE SAVEPOINT active_record_1 IssuePriority Load (0.1ms) SELECT "enumerations".* FROM "enumerations" WHERE "enumerations"."type" IN ('IssuePriority') ORDER BY "enumerations"."position" ASC LIMIT 1 Group Load (0.1ms) SELECT "users".* FROM "users" INNER JOIN "groups_users" ON "users"."id" = "groups_users"."group_id" WHERE "users"."type" IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND "groups_users"."user_id" = ? ORDER BY "users"."id" ASC LIMIT 1 [["user_id", 8]] Project Load (0.1ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" = ? LIMIT 1 [["id", 1]] Tracker Load (0.1ms) SELECT "trackers".* FROM "trackers" WHERE "trackers"."id" = ? LIMIT 1 [["id", 1]] IssueStatus Load (0.1ms) SELECT "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = ? LIMIT 1 [["id", 1]]  (0.1ms) SAVEPOINT active_record_1 IssueCustomField Load (0.3ms) SELECT "custom_fields".* FROM "custom_fields" WHERE "custom_fields"."type" IN ('IssueCustomField') AND (is_for_all = 't' OR id IN (SELECT DISTINCT cfp.custom_field_id FROM custom_fields_projects cfp WHERE cfp.project_id = 1)) ORDER BY "custom_fields"."position" ASC IssueCustomField Load (0.3ms) SELECT "custom_fields".* FROM "custom_fields" INNER JOIN "custom_fields_trackers" ON "custom_fields"."id" = "custom_fields_trackers"."custom_field_id" WHERE "custom_fields"."type" IN ('IssueCustomField') AND "custom_fields_trackers"."tracker_id" = ? [["tracker_id", 1]] User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."id" = ? LIMIT 1 [["id", 3]] Setting Load (0.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."id" DESC LIMIT 1 [["name", "issue_done_ratio"]] Tracker Exists (0.2ms) SELECT "trackers".* FROM "trackers" INNER JOIN "projects_trackers" ON "trackers"."id" = "projects_trackers"."tracker_id" WHERE "projects_trackers"."project_id" = ? AND "trackers"."id" = ? ORDER BY "trackers"."position" ASC [["project_id", 1], ["id", 1]] Member Load (0.2ms) SELECT "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" WHERE "members"."user_id" = ? AND (projects.status<>9) AND "members"."project_id" = ? ORDER BY projects.name LIMIT 1 [["user_id", 3], ["project_id", 1]] Project Load (0.2ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (1) MemberRole Load (0.2ms) SELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (2) Role Load (0.1ms) SELECT "roles".* FROM "roles" WHERE "roles"."id" IN (2) Role Load (0.1ms) SELECT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = ? [["member_id", 2]] WorkflowPermission Load (0.2ms) SELECT "workflows".* FROM "workflows" WHERE "workflows"."type" IN ('WorkflowPermission') AND "workflows"."tracker_id" = ? AND "workflows"."old_status_id" = ? AND "workflows"."role_id" = 2 [["tracker_id", 1], ["old_status_id", 1]] SQL (0.2ms) INSERT INTO "issues" ("project_id", "tracker_id", "status_id", "author_id", "priority_id", "subject", "assigned_to_id", "is_private", "updated_on", "created_on") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [["project_id", 1], ["tracker_id", 1], ["status_id", 1], ["author_id", 3], ["priority_id", 4], ["subject", "Assignment test"], ["assigned_to_id", 10], ["is_private", "t"], ["updated_on", "2015-02-14 20:06:47.608015"], ["created_on", "2015-02-14 20:06:47.608015"]] SQL (0.1ms) UPDATE "issues" SET "root_id" = 18, "lft" = 1, "rgt" = 2 WHERE "issues"."id" = ? [["id", 18]] SQL (0.1ms) INSERT INTO "custom_values" ("customized_id", "customized_type", "custom_field_id", "value") VALUES (?, ?, ?, ?) [["customized_id", 18], ["customized_type", "Issue"], ["custom_field_id", 2], ["value", "Default string"]] SQL (0.1ms) INSERT INTO "custom_values" ("customized_id", "customized_type", "custom_field_id", "value") VALUES (?, ?, ?, ?) [["customized_id", 18], ["customized_type", "Issue"], ["custom_field_id", 1], ["value", ""]] SQL (0.1ms) INSERT INTO "custom_values" ("customized_id", "customized_type", "custom_field_id", "value") VALUES (?, ?, ?, ?) [["customized_id", 18], ["customized_type", "Issue"], ["custom_field_id", 6], ["value", ""]] SQL (0.1ms) INSERT INTO "custom_values" ("customized_id", "customized_type", "custom_field_id", "value") VALUES (?, ?, ?, ?) [["customized_id", 18], ["customized_type", "Issue"], ["custom_field_id", 8], ["value", ""]] Setting Load (0.0ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."id" DESC LIMIT 1 [["name", "notified_events"]] User Load (0.1ms) SELECT "users".* FROM "users" INNER JOIN "groups_users" ON "users"."id" = "groups_users"."user_id" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "groups_users"."group_id" = ? [["group_id", 10]] Member Load (0.2ms) SELECT "members".* FROM "members" INNER JOIN "users" ON "users"."id" = "members"."user_id" INNER JOIN "member_roles" ON "member_roles"."member_id" = "members"."id" INNER JOIN "roles" ON "roles"."id" = "member_roles"."role_id" WHERE "members"."project_id" = ? AND (users.type='User' AND users.status=1) [["project_id", 1]] Principal Load (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1 [["id", 2]] Principal Load (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1 [["id", 3]] Principal Load (0.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1 [["id", 8]]  (0.1ms) SELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = ? [["project_id", 1]] Role Load (0.0ms) SELECT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = ? [["member_id", 2]] Member Load (0.1ms) SELECT "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" WHERE "members"."user_id" = ? AND (projects.status<>9) AND "members"."project_id" = ? ORDER BY projects.name LIMIT 1 [["user_id", 8], ["project_id", 1]] Project Load (0.1ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (1) MemberRole Load (0.1ms) SELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (12) Role Load (0.1ms) SELECT "roles".* FROM "roles" WHERE "roles"."id" IN (2) Role Load (0.0ms) SELECT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = ? [["member_id", 12]] Member Load (0.0ms) SELECT "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" WHERE "members"."user_id" = ? AND (projects.status<>9) AND "members"."project_id" = ? ORDER BY projects.name LIMIT 1 [["user_id", 2], ["project_id", 1]] Project Load (0.1ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (1) MemberRole Load (0.1ms) SELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (1) Role Load (0.1ms) SELECT "roles".* FROM "roles" WHERE "roles"."id" IN (1) Role Load (0.0ms) SELECT "roles".* FROM "roles" INNER JOIN "member_roles" ON "roles"."id" = "member_roles"."role_id" WHERE "member_roles"."member_id" = ? [["member_id", 1]] User Load (0.2ms) SELECT "users".* FROM "users" INNER JOIN "watchers" ON "users"."id" = "watchers"."user_id" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "watchers"."watchable_id" = ? AND "watchers"."watchable_type" = ? AND "users"."status" = ? [["watchable_id", 18], ["watchable_type", "Issue"], ["status", 1]] Setting Load (0.0ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."id" DESC LIMIT 1 [["name", "default_language"]] Setting Load (0.0ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."id" DESC LIMIT 1 [["name", "host_name"]] Setting Load (0.0ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."id" DESC LIMIT 1 [["name", "protocol"]] Setting Load (0.0ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."id" DESC LIMIT 1 [["name", "app_title"]] Setting Load (0.0ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."id" DESC LIMIT 1 [["name", "mail_from"]]  (0.1ms) SELECT "email_addresses"."address" FROM "email_addresses" WHERE "email_addresses"."user_id" IN (3, 8, 2) AND (is_default = 't' OR notify = 't') UserPreference Load (0.1ms) SELECT "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = ? LIMIT 1 [["user_id", 3]] Setting Load (0.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."id" DESC LIMIT 1 [["name", "bcc_recipients"]] Setting Load (0.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."id" DESC LIMIT 1 [["name", "user_format"]] Attachment Exists (0.2ms) SELECT 1 AS one FROM "attachments" WHERE "attachments"."container_id" = ? AND "attachments"."container_type" = ? LIMIT 1 [["container_id", 18], ["container_type", "Issue"]] Rendered mailer/_issue.text.erb (6.1ms) Rendered mailer/issue_add.text.erb within layouts/mailer (13.7ms) Setting Load (0.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."id" DESC LIMIT 1 [["name", "emails_header"]] Setting Load (0.0ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."id" DESC LIMIT 1 [["name", "emails_footer"]] Setting Load (0.0ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."id" DESC LIMIT 1 [["name", "plain_text_mail"]] Attachment Exists (0.1ms) SELECT 1 AS one FROM "attachments" WHERE "attachments"."container_id" = ? AND "attachments"."container_type" = ? LIMIT 1 [["container_id", 18], ["container_type", "Issue"]] Rendered mailer/_issue.html.erb (39.8ms) Rendered mailer/issue_add.html.erb within layouts/mailer (41.0ms) Setting Load (0.1ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."id" DESC LIMIT 1 [["name", "text_formatting"]] Setting Load (0.0ms) SELECT "settings".* FROM "settings" WHERE "settings"."name" = ? ORDER BY "settings"."id" DESC LIMIT 1 [["name", "cache_formatted_text"]] Mailer#issue_add: processed outbound mail in 410.2ms Sent email "[eCookbook - Bug #18] (New) Assignment test" (50ms) bcc: jsmith@somenet.foo, dlopper@somenet.foo, miscuser8@foo.bar Date: Sat, 14 Feb 2015 20:06:48 +0900 From: redmine@example.net Message-ID: References: Subject: [eCookbook - Bug #18] (New) Assignment test Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="--==_mimepart_54df2c4818f50_c95af102c7963f"; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Redmine-Project: ecookbook X-Redmine-Issue-Id: 18 X-Redmine-Issue-Author: dlopper X-Redmine-Issue-Assignee: X-Redmine-Sender: dlopper X-Mailer: Redmine X-Redmine-Host: localhost:3000 X-Redmine-Site: Redmine X-Auto-Response-Suppress: OOF Auto-Submitted: auto-generated List-Id: ----==_mimepart_54df2c4818f50_c95af102c7963f Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Issue #18 has been reported by Dave Lopper. ---------------------------------------- Bug #18: Assignment test http://localhost:3000/issues/18 * Author: Dave Lopper * Status: New * Priority: Low * Assignee: A Team * Category: * Target version: * Searchable field: Default string * Database: * Float field: * Custom date: ---------------------------------------- -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://hostname/my/account ----==_mimepart_54df2c4818f50_c95af102c7963f Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Issue #18 has been reported by Dave Lopper.

Bug #18: Assignment test

  • Author: Dave Lopper
  • Status: New
  • Priority: Low
  • Assignee: A Team
  • Category:
  • Target version:
  • Searchable field: Default string
  • Database:
  • Float field:
  • Custom date:

You have received this notification because you have either subscribed to it, or are involved in it.
To change your notification preferences, please click here: http://hostname/my/account

 ----==_mimepart_54df2c4818f50_c95af102c7963f--  (0.1ms) RELEASE SAVEPOINT active_record_1 Role Load (0.1ms) SELECT "roles".* FROM "roles" WHERE "roles"."id" = ? LIMIT 1 [["id", 2]]  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) UPDATE "roles" SET "permissions" = ? WHERE "roles"."id" = ? [["permissions", "---\n- :edit_project\n- :manage_members\n- :manage_versions\n- :manage_categories\n- :view_issues\n- :add_issues\n- :edit_issues\n- :copy_issues\n- :manage_issue_relations\n- :manage_subtasks\n- :add_issue_notes\n- :delete_issues\n- :view_issue_watchers\n- :save_queries\n- :view_gantt\n- :view_calendar\n- :log_time\n- :view_time_entries\n- :edit_own_time_entries\n- :manage_news\n- :comment_news\n- :view_documents\n- :add_documents\n- :edit_documents\n- :delete_documents\n- :view_wiki_pages\n- :view_wiki_edits\n- :edit_wiki_pages\n- :protect_wiki_pages\n- :delete_wiki_pages\n- :add_messages\n- :edit_own_messages\n- :delete_own_messages\n- :manage_boards\n- :view_files\n- :manage_files\n- :browse_repository\n- :view_changesets\n"], ["id", 2]]  (0.1ms) RELEASE SAVEPOINT active_record_1 User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."id" = ? LIMIT 1 [["id", 8]] Role Load (0.0ms) SELECT "roles".* FROM "roles" WHERE "roles"."builtin" = ? ORDER BY "roles"."id" ASC LIMIT 1 [["builtin", 1]] Member Load (0.2ms) SELECT "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" INNER JOIN "users" ON "users"."id" = "members"."user_id" WHERE (projects.status <> 9) AND (members.user_id = 8 OR (projects.is_public = 't' AND users.type = 'GroupNonMember')) Project Load (0.1ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (5, 2, 1) MemberRole Load (0.1ms) SELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (7, 10, 12) Role Load (0.1ms) SELECT "roles".* FROM "roles" WHERE "roles"."id" IN (1, 2) Group Load (0.2ms) SELECT "users".* FROM "users" INNER JOIN "groups_users" ON "users"."id" = "groups_users"."group_id" WHERE "users"."type" IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND "groups_users"."user_id" = ? [["user_id", 8]] Issue Load (0.3ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" WHERE (((projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (projects.id IN (5) OR (projects.id IN (5,2,1) AND ((issues.is_private = 'f' OR issues.author_id = 8 OR issues.assigned_to_id IN (8,10,11))))))) Role Load (0.0ms) SELECT "roles".* FROM "roles" WHERE "roles"."id" = ? LIMIT 1 [["id", 2]]  (0.0ms) SAVEPOINT active_record_1 SQL (0.1ms) UPDATE "roles" SET "issues_visibility" = ? WHERE "roles"."id" = ? [["issues_visibility", "own"], ["id", 2]]  (0.1ms) RELEASE SAVEPOINT active_record_1 User Load (0.1ms) SELECT "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."id" = ? LIMIT 1 [["id", 8]] Role Load (0.0ms) SELECT "roles".* FROM "roles" WHERE "roles"."builtin" = ? ORDER BY "roles"."id" ASC LIMIT 1 [["builtin", 1]] Member Load (0.1ms) SELECT "members".* FROM "members" INNER JOIN "projects" ON "projects"."id" = "members"."project_id" INNER JOIN "users" ON "users"."id" = "members"."user_id" WHERE (projects.status <> 9) AND (members.user_id = 8 OR (projects.is_public = 't' AND users.type = 'GroupNonMember')) Project Load (0.1ms) SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (5, 2, 1) MemberRole Load (0.1ms) SELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (7, 10, 12) Role Load (0.1ms) SELECT "roles".* FROM "roles" WHERE "roles"."id" IN (1, 2) Group Load (0.1ms) SELECT "users".* FROM "users" INNER JOIN "groups_users" ON "users"."id" = "groups_users"."group_id" WHERE "users"."type" IN ('Group', 'GroupBuiltin', 'GroupAnonymous', 'GroupNonMember') AND "groups_users"."user_id" = ? [["user_id", 8]] Issue Load (0.3ms) SELECT "issues".* FROM "issues" INNER JOIN "projects" ON "projects"."id" = "issues"."project_id" WHERE (((projects.status <> 9 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) AND (projects.id IN (5) OR (projects.id IN (5,2,1) AND ((issues.author_id = 8 OR issues.assigned_to_id IN (8,10,11)))))))  (0.1ms) rollback transaction