Project

General

Profile

Defect #19106 » test.log

Toshi MARUYAMA, 2015-02-14 12:10

 
1
  ActiveRecord::SchemaMigration Load (0.5ms)  SELECT "schema_migrations".* FROM "schema_migrations"
2
   (0.1ms)  begin transaction
3
  Fixture Delete (0.2ms)  DELETE FROM "projects"
4
  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)
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:14:19.000000', 'OnlineStore', '2006-07-20 02:14:19.000000', 2, 'E-commerce web site', '', 'f', 'onlinestore', NULL, 11, 12)
6
  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)
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)
8
  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)
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', '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)
10
  Fixture Delete (0.1ms)  DELETE FROM "users"
11
  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')
12
  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')
13
  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')
14
  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')
15
  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')
16
  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')
17
  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')
18
  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')
19
  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')
20
  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')
21
  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')
22
  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')
23
  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')
24
  Fixture Delete (0.1ms)  DELETE FROM "email_addresses"
25
  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')
26
  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')
27
  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')
28
  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')
29
  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')
30
  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')
31
  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')
32
  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')
33
  Fixture Delete (0.1ms)  DELETE FROM "members"
34
  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')
35
  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')
36
  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')
37
  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')
38
  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')
39
  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')
40
  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')
41
  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')
42
  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')
43
  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')
44
  Fixture Delete (0.1ms)  DELETE FROM "member_roles"
45
  Fixture Insert (0.1ms)  INSERT INTO "member_roles" ("id", "role_id", "member_id") VALUES (1, 1, 1)
46
  Fixture Insert (0.1ms)  INSERT INTO "member_roles" ("id", "role_id", "member_id") VALUES (2, 2, 2)
47
  Fixture Insert (0.1ms)  INSERT INTO "member_roles" ("id", "role_id", "member_id") VALUES (3, 2, 3)
48
  Fixture Insert (0.1ms)  INSERT INTO "member_roles" ("id", "role_id", "member_id") VALUES (4, 2, 4)
49
  Fixture Insert (0.1ms)  INSERT INTO "member_roles" ("id", "role_id", "member_id") VALUES (5, 1, 5)
50
  Fixture Insert (0.1ms)  INSERT INTO "member_roles" ("id", "role_id", "member_id") VALUES (6, 1, 6)
51
  Fixture Insert (0.1ms)  INSERT INTO "member_roles" ("id", "role_id", "member_id") VALUES (7, 2, 6)
52
  Fixture Insert (0.1ms)  INSERT INTO "member_roles" ("id", "role_id", "member_id", "inherited_from") VALUES (8, 1, 7, 6)
53
  Fixture Insert (0.1ms)  INSERT INTO "member_roles" ("id", "role_id", "member_id", "inherited_from") VALUES (9, 2, 7, 7)
54
  Fixture Insert (0.1ms)  INSERT INTO "member_roles" ("id", "role_id", "member_id", "inherited_from") VALUES (10, 2, 9, NULL)
55
  Fixture Insert (0.1ms)  INSERT INTO "member_roles" ("id", "role_id", "member_id", "inherited_from") VALUES (11, 2, 10, 10)
56
  Fixture Delete (0.1ms)  DELETE FROM "roles"
57
  Fixture Insert (0.1ms)  INSERT INTO "roles" ("name", "id", "builtin", "issues_visibility", "users_visibility", "permissions", "position") VALUES ('Manager', 1, 0, 'all', 'all', '--- 
58
- :add_project
59
- :edit_project
60
- :close_project
61
- :select_project_modules
62
- :manage_members
63
- :manage_versions
64
- :manage_categories
65
- :view_issues
66
- :add_issues
67
- :edit_issues
68
- :copy_issues
69
- :manage_issue_relations
70
- :manage_subtasks
71
- :add_issue_notes
72
- :delete_issues
73
- :view_issue_watchers
74
- :add_issue_watchers
75
- :set_issues_private
76
- :set_notes_private
77
- :view_private_notes
78
- :delete_issue_watchers
79
- :manage_public_queries
80
- :save_queries
81
- :view_gantt
82
- :view_calendar
83
- :log_time
84
- :view_time_entries
85
- :edit_time_entries
86
- :delete_time_entries
87
- :manage_news
88
- :comment_news
89
- :view_documents
90
- :add_documents
91
- :edit_documents
92
- :delete_documents
93
- :view_wiki_pages
94
- :export_wiki_pages
95
- :view_wiki_edits
96
- :edit_wiki_pages
97
- :delete_wiki_pages_attachments
98
- :protect_wiki_pages
99
- :delete_wiki_pages
100
- :rename_wiki_pages
101
- :add_messages
102
- :edit_messages
103
- :delete_messages
104
- :manage_boards
105
- :view_files
106
- :manage_files
107
- :browse_repository
108
- :manage_repository
109
- :view_changesets
110
- :manage_related_issues
111
- :manage_project_activities
112
', 1)
113
  Fixture Insert (0.1ms)  INSERT INTO "roles" ("name", "id", "builtin", "issues_visibility", "users_visibility", "permissions", "position") VALUES ('Developer', 2, 0, 'default', 'all', '--- 
114
- :edit_project
115
- :manage_members
116
- :manage_versions
117
- :manage_categories
118
- :view_issues
119
- :add_issues
120
- :edit_issues
121
- :copy_issues
122
- :manage_issue_relations
123
- :manage_subtasks
124
- :add_issue_notes
125
- :delete_issues
126
- :view_issue_watchers
127
- :save_queries
128
- :view_gantt
129
- :view_calendar
130
- :log_time
131
- :view_time_entries
132
- :edit_own_time_entries
133
- :manage_news
134
- :comment_news
135
- :view_documents
136
- :add_documents
137
- :edit_documents
138
- :delete_documents
139
- :view_wiki_pages
140
- :view_wiki_edits
141
- :edit_wiki_pages
142
- :protect_wiki_pages
143
- :delete_wiki_pages
144
- :add_messages
145
- :edit_own_messages
146
- :delete_own_messages
147
- :manage_boards
148
- :view_files
149
- :manage_files
150
- :browse_repository
151
- :view_changesets
152
', 2)
153
  Fixture Insert (0.1ms)  INSERT INTO "roles" ("name", "id", "builtin", "issues_visibility", "users_visibility", "permissions", "position") VALUES ('Reporter', 3, 0, 'default', 'all', '--- 
154
- :edit_project
155
- :manage_members
156
- :manage_versions
157
- :manage_categories
158
- :view_issues
159
- :add_issues
160
- :edit_issues
161
- :manage_issue_relations
162
- :add_issue_notes
163
- :view_issue_watchers
164
- :save_queries
165
- :view_gantt
166
- :view_calendar
167
- :log_time
168
- :view_time_entries
169
- :manage_news
170
- :comment_news
171
- :view_documents
172
- :add_documents
173
- :edit_documents
174
- :delete_documents
175
- :view_wiki_pages
176
- :view_wiki_edits
177
- :edit_wiki_pages
178
- :delete_wiki_pages
179
- :add_messages
180
- :manage_boards
181
- :view_files
182
- :manage_files
183
- :browse_repository
184
- :view_changesets
185
', 3)
186
  Fixture Insert (0.1ms)  INSERT INTO "roles" ("name", "id", "builtin", "issues_visibility", "users_visibility", "permissions", "position") VALUES ('Non member', 4, 1, 'default', 'all', '--- 
187
- :view_issues
188
- :add_issues
189
- :edit_issues
190
- :manage_issue_relations
191
- :add_issue_notes
192
- :save_queries
193
- :view_gantt
194
- :view_calendar
195
- :log_time
196
- :view_time_entries
197
- :comment_news
198
- :view_documents
199
- :view_wiki_pages
200
- :view_wiki_edits
201
- :edit_wiki_pages
202
- :add_messages
203
- :view_files
204
- :manage_files
205
- :browse_repository
206
- :view_changesets
207
', 4)
208
  Fixture Insert (0.1ms)  INSERT INTO "roles" ("name", "id", "builtin", "issues_visibility", "users_visibility", "permissions", "position") VALUES ('Anonymous', 5, 2, 'default', 'all', '--- 
209
- :view_issues
210
- :add_issue_notes
211
- :view_gantt
212
- :view_calendar
213
- :view_time_entries
214
- :view_documents
215
- :view_wiki_pages
216
- :view_wiki_edits
217
- :view_files
218
- :browse_repository
219
- :view_changesets
220
', 5)
221
  Fixture Delete (0.1ms)  DELETE FROM "groups_users"
222
  Fixture Insert (0.0ms)  INSERT INTO "groups_users" ("group_id", "user_id") VALUES (10, 8)
223
  Fixture Insert (0.0ms)  INSERT INTO "groups_users" ("group_id", "user_id") VALUES (11, 8)
224
  Fixture Delete (0.1ms)  DELETE FROM "trackers"
225
  Fixture Insert (0.1ms)  INSERT INTO "trackers" ("name", "id", "is_in_chlog", "default_status_id", "position") VALUES ('Bug', 1, 't', 1, 1)
226
  Fixture Insert (0.1ms)  INSERT INTO "trackers" ("name", "id", "is_in_chlog", "default_status_id", "position") VALUES ('Feature request', 2, 't', 1, 2)
227
  Fixture Insert (0.1ms)  INSERT INTO "trackers" ("name", "id", "is_in_chlog", "default_status_id", "position") VALUES ('Support request', 3, 'f', 1, 3)
228
  Fixture Delete (0.1ms)  DELETE FROM "projects_trackers"
229
  Fixture Insert (0.1ms)  INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (4, 3)
230
  Fixture Insert (0.0ms)  INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (1, 1)
231
  Fixture Insert (0.0ms)  INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (5, 1)
232
  Fixture Insert (0.0ms)  INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (1, 2)
233
  Fixture Insert (0.0ms)  INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (5, 2)
234
  Fixture Insert (0.0ms)  INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (5, 3)
235
  Fixture Insert (0.0ms)  INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (2, 1)
236
  Fixture Insert (0.0ms)  INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (2, 2)
237
  Fixture Insert (0.0ms)  INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (2, 3)
238
  Fixture Insert (0.0ms)  INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (3, 2)
239
  Fixture Insert (0.0ms)  INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (3, 3)
240
  Fixture Insert (0.0ms)  INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (4, 1)
241
  Fixture Insert (0.0ms)  INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (4, 2)
242
  Fixture Insert (0.1ms)  INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (1, 3)
243
  Fixture Insert (0.0ms)  INSERT INTO "projects_trackers" ("project_id", "tracker_id") VALUES (6, 1)
244
  Fixture Delete (0.1ms)  DELETE FROM "enabled_modules"
245
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('issue_tracking', 1, 1)
246
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('time_tracking', 1, 2)
247
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('news', 1, 3)
248
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('documents', 1, 4)
249
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('files', 1, 5)
250
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('wiki', 1, 6)
251
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('repository', 1, 7)
252
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('boards', 1, 8)
253
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('repository', 3, 9)
254
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('wiki', 3, 10)
255
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('issue_tracking', 2, 11)
256
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('time_tracking', 3, 12)
257
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('issue_tracking', 3, 13)
258
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('issue_tracking', 5, 14)
259
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('wiki', 2, 15)
260
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('boards', 2, 16)
261
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('calendar', 1, 17)
262
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('gantt', 1, 18)
263
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('calendar', 2, 19)
264
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('gantt', 2, 20)
265
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('calendar', 3, 21)
266
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('gantt', 3, 22)
267
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('calendar', 5, 23)
268
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('gantt', 5, 24)
269
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('news', 2, 25)
270
  Fixture Insert (0.1ms)  INSERT INTO "enabled_modules" ("name", "project_id", "id") VALUES ('repository', 2, 26)
271
  Fixture Delete (0.1ms)  DELETE FROM "versions"
272
  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')
273
  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')
274
  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')
275
  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')
276
  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')
277
  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')
278
  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')
279
  Fixture Delete (0.1ms)  DELETE FROM "issue_statuses"
280
  Fixture Insert (0.1ms)  INSERT INTO "issue_statuses" ("id", "name", "is_closed", "position") VALUES (1, 'New', 'f', 1)
281
  Fixture Insert (0.1ms)  INSERT INTO "issue_statuses" ("id", "name", "is_closed", "position") VALUES (2, 'Assigned', 'f', 2)
282
  Fixture Insert (0.1ms)  INSERT INTO "issue_statuses" ("id", "name", "is_closed", "position") VALUES (3, 'Resolved', 'f', 3)
283
  Fixture Insert (0.1ms)  INSERT INTO "issue_statuses" ("name", "id", "is_closed", "position") VALUES ('Feedback', 4, 'f', 4)
284
  Fixture Insert (0.1ms)  INSERT INTO "issue_statuses" ("id", "name", "is_closed", "position") VALUES (5, 'Closed', 't', 5)
285
  Fixture Insert (0.1ms)  INSERT INTO "issue_statuses" ("id", "name", "is_closed", "position") VALUES (6, 'Rejected', 't', 6)
286
  Fixture Delete (0.1ms)  DELETE FROM "issue_categories"
287
  Fixture Insert (0.1ms)  INSERT INTO "issue_categories" ("name", "project_id", "assigned_to_id", "id") VALUES ('Printing', 1, 2, 1)
288
  Fixture Insert (0.1ms)  INSERT INTO "issue_categories" ("name", "project_id", "assigned_to_id", "id") VALUES ('Recipes', 1, NULL, 2)
289
  Fixture Insert (0.1ms)  INSERT INTO "issue_categories" ("name", "project_id", "assigned_to_id", "id") VALUES ('Stock management', 2, NULL, 3)
290
  Fixture Insert (0.1ms)  INSERT INTO "issue_categories" ("name", "project_id", "assigned_to_id", "id") VALUES ('Printing', 2, NULL, 4)
291
  Fixture Delete (0.1ms)  DELETE FROM "issue_relations"
292
  Fixture Insert (0.1ms)  INSERT INTO "issue_relations" ("id", "issue_from_id", "issue_to_id", "relation_type", "delay") VALUES (1, 10, 9, 'blocks', NULL)
293
  Fixture Insert (0.1ms)  INSERT INTO "issue_relations" ("id", "issue_from_id", "issue_to_id", "relation_type", "delay") VALUES (2, 2, 3, 'relates', NULL)
294
  Fixture Delete (0.1ms)  DELETE FROM "workflows"
295
  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')
296
  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')
297
  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')
298
  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')
299
  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')
300
  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')
301
  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')
302
  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')
303
  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')
304
  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')
305
  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')
306
  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')
307
  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')
308
  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')
309
  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')
310
  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')
311
  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')
312
  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')
313
  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')
314
  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')
315
  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')
316
  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')
317
  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')
318
  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')
319
  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')
320
  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')
321
  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')
322
  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')
323
  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')
324
  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')
325
  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')
326
  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')
327
  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')
328
  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')
329
  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')
330
  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')
331
  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')
332
  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')
333
  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')
334
  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')
335
  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')
336
  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')
337
  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')
338
  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')
339
  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')
340
  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')
341
  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')
342
  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')
343
  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')
344
  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')
345
  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')
346
  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')
347
  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')
348
  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')
349
  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')
350
  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')
351
  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')
352
  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')
353
  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')
354
  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')
355
  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')
356
  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')
357
  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')
358
  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')
359
  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')
360
  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')
361
  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')
362
  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')
363
  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')
364
  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')
365
  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')
366
  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')
367
  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')
368
  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')
369
  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')
370
  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')
371
  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')
372
  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')
373
  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')
374
  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')
375
  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')
376
  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')
377
  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')
378
  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')
379
  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')
380
  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')
381
  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')
382
  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')
383
  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')
384
  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')
385
  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')
386
  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')
387
  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')
388
  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')
389
  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')
390
  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')
391
  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')
392
  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')
393
  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')
394
  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')
395
  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')
396
  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')
397
  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')
398
  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')
399
  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')
400
  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')
401
  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')
402
  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')
403
  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')
404
  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')
405
  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')
406
  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')
407
  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')
408
  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')
409
  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')
410
  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')
411
  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')
412
  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')
413
  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')
414
  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')
415
  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')
416
  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')
417
  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')
418
  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')
419
  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')
420
  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')
421
  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')
422
  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')
423
  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')
424
  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')
425
  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')
426
  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')
427
  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')
428
  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')
429
  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')
430
  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')
431
  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')
432
  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')
433
  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')
434
  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')
435
  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')
436
  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')
437
  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')
438
  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')
439
  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')
440
  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')
441
  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')
442
  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')
443
  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')
444
  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')
445
  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')
446
  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')
447
  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')
448
  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')
449
  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')
450
  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')
451
  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')
452
  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')
453
  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')
454
  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')
455
  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')
456
  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')
457
  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')
458
  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')
459
  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')
460
  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')
461
  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')
462
  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')
463
  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')
464
  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')
465
  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')
466
  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')
467
  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')
468
  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')
469
  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')
470
  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')
471
  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')
472
  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')
473
  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')
474
  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')
475
  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')
476
  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')
477
  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')
478
  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')
479
  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')
480
  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')
481
  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')
482
  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')
483
  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')
484
  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')
485
  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')
486
  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')
487
  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')
488
  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')
489
  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')
490
  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')
491
  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')
492
  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')
493
  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')
494
  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')
495
  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')
496
  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')
497
  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')
498
  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')
499
  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')
500
  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')
501
  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')
502
  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')
503
  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')
504
  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')
505
  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')
506
  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')
507
  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')
508
  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')
509
  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')
510
  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')
511
  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')
512
  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')
513
  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')
514
  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')
515
  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')
516
  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')
517
  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')
518
  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')
519
  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')
520
  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')
521
  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')
522
  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')
523
  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')
524
  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')
525
  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')
526
  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')
527
  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')
528
  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')
529
  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')
530
  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')
531
  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')
532
  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')
533
  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')
534
  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')
535
  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')
536
  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')
537
  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')
538
  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')
539
  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')
540
  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')
541
  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')
542
  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')
543
  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')
544
  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')
545
  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')
546
  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')
547
  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')
548
  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')
549
  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')
550
  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')
551
  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')
552
  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')
553
  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')
554
  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')
555
  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')
556
  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')
557
  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')
558
  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')
559
  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')
560
  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')
561
  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')
562
  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')
563
  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')
564
  Fixture Delete (0.1ms)  DELETE FROM "enumerations"
565
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "active", "position") VALUES ('Uncategorized', 1, 'DocumentCategory', 't', 1)
566
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "active", "position") VALUES ('User documentation', 2, 'DocumentCategory', 't', 2)
567
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "active", "position") VALUES ('Technical documentation', 3, 'DocumentCategory', 't', 3)
568
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "active", "position", "position_name") VALUES ('Low', 4, 'IssuePriority', 't', 1, 'lowest')
569
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "is_default", "active", "position", "position_name") VALUES ('Normal', 5, 'IssuePriority', 't', 't', 2, 'default')
570
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "active", "position", "position_name") VALUES ('High', 6, 'IssuePriority', 't', 3, 'high3')
571
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "active", "position", "position_name") VALUES ('Urgent', 7, 'IssuePriority', 't', 4, 'high2')
572
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "active", "position", "position_name") VALUES ('Immediate', 8, 'IssuePriority', 't', 5, 'highest')
573
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "position", "active") VALUES ('Design', 9, 'TimeEntryActivity', 1, 't')
574
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "position", "is_default", "active") VALUES ('Development', 10, 'TimeEntryActivity', 2, 't', 't')
575
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "position", "active") VALUES ('QA', 11, 'TimeEntryActivity', 3, 't')
576
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "is_default", "active") VALUES ('Default Enumeration', 12, 'Enumeration', 't', 't')
577
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "active") VALUES ('Another Enumeration', 13, 'Enumeration', 't')
578
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "position", "active") VALUES ('Inactive Activity', 14, 'TimeEntryActivity', 4, 'f')
579
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "position", "active") VALUES ('Inactive Priority', 15, 'IssuePriority', 6, 'f')
580
  Fixture Insert (0.1ms)  INSERT INTO "enumerations" ("name", "id", "type", "active", "position") VALUES ('Inactive Document Category', 16, 'DocumentCategory', 'f', 4)
581
  Fixture Delete (0.1ms)  DELETE FROM "issues"
582
  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)
583
  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)
584
  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)
585
  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)
586
  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)
587
  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)
588
  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)
589
  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')
590
  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)
591
  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)
592
  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')
593
  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')
594
  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)
595
  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)
596
  Fixture Delete (0.1ms)  DELETE FROM "journals"
597
  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)
598
  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)
599
  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)
600
  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)
601
  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)
602
  Fixture Delete (0.1ms)  DELETE FROM "journal_details"
603
  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)
604
  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)
605
  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)
606
  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)
607
  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)
608
  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)
609
  Fixture Delete (0.1ms)  DELETE FROM "custom_fields"
610
  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', '---
611
- MySQL
612
- PostgreSQL
613
- Oracle
614
', 1, 'f', 'list', '', 't', 2)
615
  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)
616
  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', '---
617
- Stable
618
- Beta
619
- Alpha
620
- Planning
621
', 3, 'f', 'list', '', 't', 1)
622
  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)
623
  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)
624
  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)
625
  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)
626
  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)
627
  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)
628
  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)
629
  Fixture Insert (0.1ms)  INSERT INTO "custom_fields" ("id", "name", "type", "possible_values", "field_format") VALUES (11, 'Binary', 'CustomField', '---
630
- !binary |-
631
  SGXDqWzDp2prc2Tigqw2NTTDuQ==
632
- Other value
633
', 'list')
634
  Fixture Delete (0.1ms)  DELETE FROM "custom_fields_projects"
635
  Fixture Insert (0.0ms)  INSERT INTO "custom_fields_projects" ("custom_field_id", "project_id") VALUES (9, 1)
636
  Fixture Delete (0.1ms)  DELETE FROM "custom_fields_trackers"
637
  Fixture Insert (0.0ms)  INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (1, 1)
638
  Fixture Insert (0.0ms)  INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (2, 1)
639
  Fixture Insert (0.0ms)  INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (2, 3)
640
  Fixture Insert (0.0ms)  INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (6, 1)
641
  Fixture Insert (0.0ms)  INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (6, 2)
642
  Fixture Insert (0.0ms)  INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (6, 3)
643
  Fixture Insert (0.0ms)  INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (8, 1)
644
  Fixture Insert (0.0ms)  INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (8, 2)
645
  Fixture Insert (0.0ms)  INSERT INTO "custom_fields_trackers" ("custom_field_id", "tracker_id") VALUES (8, 3)
646
  Fixture Delete (0.1ms)  DELETE FROM "custom_values"
647
  Fixture Insert (0.1ms)  INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 2, 3, 6, '125')
648
  Fixture Insert (0.1ms)  INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Project', 3, 1, 7, 'Stable')
649
  Fixture Insert (0.1ms)  INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Principal', 4, 3, 1, '')
650
  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')
651
  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')
652
  Fixture Insert (0.1ms)  INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 2, 1, 4, '125')
653
  Fixture Insert (0.1ms)  INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 2, 2, 5, '')
654
  Fixture Insert (0.1ms)  INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 1, 3, 8, 'MySQL')
655
  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')
656
  Fixture Insert (0.1ms)  INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 6, 1, 10, '2.1')
657
  Fixture Insert (0.1ms)  INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 6, 2, 11, '2.05')
658
  Fixture Insert (0.1ms)  INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 6, 3, 12, '11.65')
659
  Fixture Insert (0.1ms)  INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 6, 7, 13, '')
660
  Fixture Insert (0.1ms)  INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Issue', 6, 5, 14, '-7.6')
661
  Fixture Insert (0.1ms)  INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Enumeration', 7, 10, 15, 't')
662
  Fixture Insert (0.1ms)  INSERT INTO "custom_values" ("customized_type", "custom_field_id", "customized_id", "id", "value") VALUES ('Enumeration', 7, 11, 16, '1')
663
  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')
664
  Fixture Delete (0.1ms)  DELETE FROM "time_entries"
665
  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)
666
  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)
667
  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)
668
  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)
669
  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)
670
   (134.1ms)  commit transaction
671
   (0.1ms)  begin transaction
672
----------------------------------------------------------------------------------
673
IssueTest: test_visible_scope_for_member_with_groups_should_return_assigned_issues
674
----------------------------------------------------------------------------------
675
  User Load (0.3ms)  SELECT  "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."id" = ? LIMIT 1  [["id", 8]]
676
  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]]
677
  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]]
678
   (0.1ms)  SAVEPOINT active_record_1
679
  Role Load (0.2ms)  SELECT  "roles".* FROM "roles" WHERE "roles"."id" = ? LIMIT 1  [["id", 2]]
680
  Project Load (0.2ms)  SELECT  "projects".* FROM "projects" WHERE "projects"."id" = ? LIMIT 1  [["id", 1]]
681
  Member Exists (0.1ms)  SELECT  1 AS one FROM "members" WHERE ("members"."user_id" = 10 AND "members"."project_id" = 1) LIMIT 1
682
  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"]]
683
  SQL (0.1ms)  INSERT INTO "member_roles" ("role_id", "member_id") VALUES (?, ?)  [["role_id", 2], ["member_id", 11]]
684
  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]]
685
  Member Load (0.1ms)  SELECT  "members".* FROM "members" WHERE "members"."project_id" = ? AND "members"."user_id" = ? LIMIT 1  [["project_id", 1], ["user_id", 8]]
686
  Principal Load (0.1ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 8]]
687
  Project Load (0.0ms)  SELECT  "projects".* FROM "projects" WHERE "projects"."id" = ? LIMIT 1  [["id", 1]]
688
  Member Exists (0.1ms)  SELECT  1 AS one FROM "members" WHERE ("members"."user_id" = 8 AND "members"."project_id" = 1) LIMIT 1
689
  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"]]
690
  SQL (0.1ms)  INSERT INTO "member_roles" ("role_id", "inherited_from", "member_id") VALUES (?, ?, ?)  [["role_id", 2], ["inherited_from", 12], ["member_id", 12]]
691
  Project Load (0.1ms)  SELECT "projects".* FROM "projects" WHERE "projects"."parent_id" = ?  ORDER BY "projects"."lft" ASC  [["parent_id", 1]]
692
  Project Load (0.1ms)  SELECT "projects".* FROM "projects" WHERE "projects"."parent_id" = ?  ORDER BY "projects"."lft" ASC  [["parent_id", 1]]
693
   (0.1ms)  RELEASE SAVEPOINT active_record_1
694
  Role Load (0.1ms)  SELECT  "roles".* FROM "roles" WHERE "roles"."builtin" = ?  ORDER BY "roles"."id" ASC LIMIT 1  [["builtin", 1]]
695
   (0.0ms)  SAVEPOINT active_record_1
696
  Role Exists (0.1ms)  SELECT  1 AS one FROM "roles" WHERE ("roles"."name" = 'Non member' AND "roles"."id" != 4) LIMIT 1
697
  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]]
698
   (0.1ms)  RELEASE SAVEPOINT active_record_1
699
  IssuePriority Load (0.1ms)  SELECT  "enumerations".* FROM "enumerations" WHERE "enumerations"."type" IN ('IssuePriority')  ORDER BY "enumerations"."position" ASC LIMIT 1
700
  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]]
701
  Project Load (0.1ms)  SELECT  "projects".* FROM "projects" WHERE "projects"."id" = ? LIMIT 1  [["id", 1]]
702
  Tracker Load (0.1ms)  SELECT  "trackers".* FROM "trackers" WHERE "trackers"."id" = ? LIMIT 1  [["id", 1]]
703
  IssueStatus Load (0.1ms)  SELECT  "issue_statuses".* FROM "issue_statuses" WHERE "issue_statuses"."id" = ? LIMIT 1  [["id", 1]]
704
   (0.1ms)  SAVEPOINT active_record_1
705
  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
706
  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]]
707
  User Load (0.1ms)  SELECT  "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."id" = ? LIMIT 1  [["id", 3]]
708
  Setting Load (0.1ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ?  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "issue_done_ratio"]]
709
  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]]
710
  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]]
711
  Project Load (0.2ms)  SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (1)
712
  MemberRole Load (0.2ms)  SELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (2)
713
  Role Load (0.1ms)  SELECT "roles".* FROM "roles" WHERE "roles"."id" IN (2)
714
  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]]
715
  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]]
716
  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"]]
717
  SQL (0.1ms)  UPDATE "issues" SET "root_id" = 18, "lft" = 1, "rgt" = 2 WHERE "issues"."id" = ?  [["id", 18]]
718
  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"]]
719
  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", ""]]
720
  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", ""]]
721
  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", ""]]
722
  Setting Load (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ?  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "notified_events"]]
723
  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]]
724
  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]]
725
  Principal Load (0.0ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 2]]
726
  Principal Load (0.0ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 3]]
727
  Principal Load (0.0ms)  SELECT  "users".* FROM "users" WHERE "users"."id" = ? LIMIT 1  [["id", 8]]
728
   (0.1ms)  SELECT "enabled_modules"."name" FROM "enabled_modules" WHERE "enabled_modules"."project_id" = ?  [["project_id", 1]]
729
  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]]
730
  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]]
731
  Project Load (0.1ms)  SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (1)
732
  MemberRole Load (0.1ms)  SELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (12)
733
  Role Load (0.1ms)  SELECT "roles".* FROM "roles" WHERE "roles"."id" IN (2)
734
  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]]
735
  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]]
736
  Project Load (0.1ms)  SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (1)
737
  MemberRole Load (0.1ms)  SELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (1)
738
  Role Load (0.1ms)  SELECT "roles".* FROM "roles" WHERE "roles"."id" IN (1)
739
  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]]
740
  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]]
741
  Setting Load (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ?  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "default_language"]]
742
  Setting Load (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ?  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "host_name"]]
743
  Setting Load (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ?  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "protocol"]]
744
  Setting Load (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ?  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "app_title"]]
745
  Setting Load (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ?  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "mail_from"]]
746
   (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')
747
  UserPreference Load (0.1ms)  SELECT  "user_preferences".* FROM "user_preferences" WHERE "user_preferences"."user_id" = ? LIMIT 1  [["user_id", 3]]
748
  Setting Load (0.1ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ?  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "bcc_recipients"]]
749
  Setting Load (0.1ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ?  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "user_format"]]
750
  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"]]
751
  Rendered mailer/_issue.text.erb (6.1ms)
752
  Rendered mailer/issue_add.text.erb within layouts/mailer (13.7ms)
753
  Setting Load (0.1ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ?  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "emails_header"]]
754
  Setting Load (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ?  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "emails_footer"]]
755
  Setting Load (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ?  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "plain_text_mail"]]
756
  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"]]
757
  Rendered mailer/_issue.html.erb (39.8ms)
758
  Rendered mailer/issue_add.html.erb within layouts/mailer (41.0ms)
759
  Setting Load (0.1ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ?  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "text_formatting"]]
760
  Setting Load (0.0ms)  SELECT  "settings".* FROM "settings" WHERE "settings"."name" = ?  ORDER BY "settings"."id" DESC LIMIT 1  [["name", "cache_formatted_text"]]
761

    
762
Mailer#issue_add: processed outbound mail in 410.2ms
763

    
764
Sent email "[eCookbook - Bug #18] (New) Assignment test" (50ms)
765
  bcc: jsmith@somenet.foo, dlopper@somenet.foo, miscuser8@foo.bar
766
Date: Sat, 14 Feb 2015 20:06:48 +0900
767
From: redmine@example.net
768
Message-ID: <redmine.issue-18.20150214110647.a0a29e3f7b42e2d1@example.net>
769
References: <redmine.issue-18.20150214110647@example.net>
770
Subject: [eCookbook - Bug #18] (New) Assignment test
771
Mime-Version: 1.0
772
Content-Type: multipart/alternative;
773
 boundary="--==_mimepart_54df2c4818f50_c95af102c7963f";
774
 charset=UTF-8
775
Content-Transfer-Encoding: 7bit
776
X-Redmine-Project: ecookbook
777
X-Redmine-Issue-Id: 18
778
X-Redmine-Issue-Author: dlopper
779
X-Redmine-Issue-Assignee: 
780
X-Redmine-Sender: dlopper
781
X-Mailer: Redmine
782
X-Redmine-Host: localhost:3000
783
X-Redmine-Site: Redmine
784
X-Auto-Response-Suppress: OOF
785
Auto-Submitted: auto-generated
786
List-Id: <redmine.example.net>
787

    
788

    
789
----==_mimepart_54df2c4818f50_c95af102c7963f
790
Content-Type: text/plain;
791
 charset=UTF-8
792
Content-Transfer-Encoding: 7bit
793

    
794
Issue #18 has been reported by Dave Lopper.
795

    
796
----------------------------------------
797
Bug #18: Assignment test
798
http://localhost:3000/issues/18
799

    
800
* Author: Dave Lopper
801
* Status: New
802
* Priority: Low
803
* Assignee: A Team
804
* Category: 
805
* Target version: 
806
* Searchable field: Default string
807
* Database: 
808
* Float field: 
809
* Custom date: 
810
----------------------------------------
811

    
812

    
813

    
814

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

    
819
----==_mimepart_54df2c4818f50_c95af102c7963f
820
Content-Type: text/html;
821
 charset=UTF-8
822
Content-Transfer-Encoding: 7bit
823

    
824
<html>
825
<head>
826
<style>
827
body {
828
  font-family: Verdana, sans-serif;
829
  font-size: 0.8em;
830
  color:#484848;
831
}
832
h1, h2, h3 { font-family: "Trebuchet MS", Verdana, sans-serif; margin: 0px; }
833
h1 { font-size: 1.2em; }
834
h2, h3 { font-size: 1.1em; }
835
a, a:link, a:visited { color: #2A5685;}
836
a:hover, a:active { color: #c61a1a; }
837
a.wiki-anchor { display: none; }
838
fieldset.attachments {border-width: 1px 0 0 0;}
839
hr {
840
  width: 100%;
841
  height: 1px;
842
  background: #ccc;
843
  border: 0;
844
}
845
span.footer {
846
  font-size: 0.8em;
847
  font-style: italic;
848
}
849
</style>
850
</head>
851
<body>
852
Issue #18 has been reported by Dave Lopper.
853
<hr />
854
<h1><a href="http://localhost:3000/issues/18">Bug #18: Assignment test</a></h1>
855

    
856
<ul><li>Author: Dave Lopper</li>
857
<li>Status: New</li>
858
<li>Priority: Low</li>
859
<li>Assignee: A Team</li>
860
<li>Category: </li>
861
<li>Target version: </li>
862
<li>Searchable field: Default string</li>
863
<li>Database: </li>
864
<li>Float field: </li>
865
<li>Custom date: </li></ul>
866

    
867

    
868

    
869

    
870

    
871
<hr />
872
<span class="footer"><p>You have received this notification because you have either subscribed to it, or are involved in it.<br />To change your notification preferences, please click here: <a class="external" href="http://hostname/my/account">http://hostname/my/account</a></p></span>
873
</body>
874
</html>
875

    
876
----==_mimepart_54df2c4818f50_c95af102c7963f--
877

    
878
   (0.1ms)  RELEASE SAVEPOINT active_record_1
879
  Role Load (0.1ms)  SELECT  "roles".* FROM "roles" WHERE "roles"."id" = ? LIMIT 1  [["id", 2]]
880
   (0.0ms)  SAVEPOINT active_record_1
881
  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]]
882
   (0.1ms)  RELEASE SAVEPOINT active_record_1
883
  User Load (0.1ms)  SELECT  "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."id" = ? LIMIT 1  [["id", 8]]
884
  Role Load (0.0ms)  SELECT  "roles".* FROM "roles" WHERE "roles"."builtin" = ?  ORDER BY "roles"."id" ASC LIMIT 1  [["builtin", 1]]
885
  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'))
886
  Project Load (0.1ms)  SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (5, 2, 1)
887
  MemberRole Load (0.1ms)  SELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (7, 10, 12)
888
  Role Load (0.1ms)  SELECT "roles".* FROM "roles" WHERE "roles"."id" IN (1, 2)
889
  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]]
890
  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)))))))
891
  Role Load (0.0ms)  SELECT  "roles".* FROM "roles" WHERE "roles"."id" = ? LIMIT 1  [["id", 2]]
892
   (0.0ms)  SAVEPOINT active_record_1
893
  SQL (0.1ms)  UPDATE "roles" SET "issues_visibility" = ? WHERE "roles"."id" = ?  [["issues_visibility", "own"], ["id", 2]]
894
   (0.1ms)  RELEASE SAVEPOINT active_record_1
895
  User Load (0.1ms)  SELECT  "users".* FROM "users" WHERE "users"."type" IN ('User', 'AnonymousUser') AND "users"."id" = ? LIMIT 1  [["id", 8]]
896
  Role Load (0.0ms)  SELECT  "roles".* FROM "roles" WHERE "roles"."builtin" = ?  ORDER BY "roles"."id" ASC LIMIT 1  [["builtin", 1]]
897
  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'))
898
  Project Load (0.1ms)  SELECT "projects".* FROM "projects" WHERE "projects"."id" IN (5, 2, 1)
899
  MemberRole Load (0.1ms)  SELECT "member_roles".* FROM "member_roles" WHERE "member_roles"."member_id" IN (7, 10, 12)
900
  Role Load (0.1ms)  SELECT "roles".* FROM "roles" WHERE "roles"."id" IN (1, 2)
901
  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]]
902
  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)))))))
903
   (0.1ms)  rollback transaction
(1-1/2)