· 9 years ago · Nov 27, 2016, 05:10 PM
1 -- DELETE GENERATED DATABASE...
2 DROP DATABASE IF EXISTS `redmine_dashboard`;
3
4 -- CREATE NEW DATABASE...
5 CREATE DATABASE `redmine_dashboard`
6 CHARACTER SET utf8
7 COLLATE utf8_unicode_ci;
8
9 -- MAKE SURE THAT ALL DATABASE DELETED INCLUDED SHERODINGER'S TABLES IF EXISS...
10 DROP TABLE IF EXISTS `redmine_dashboard`.custom_field_enumerations;
11 DROP TABLE IF EXISTS `redmine_dashboard`.custom_fields;
12 DROP TABLE IF EXISTS `redmine_dashboard`.custom_fields_projects;
13 DROP TABLE IF EXISTS `redmine_dashboard`.custom_fields_roles;
14 DROP TABLE IF EXISTS `redmine_dashboard`.custom_fields_trackers;
15 DROP TABLE IF EXISTS `redmine_dashboard`.custom_values;
16 DROP TABLE IF EXISTS `redmine_dashboard`.enabled_modules;
17 DROP TABLE IF EXISTS `redmine_dashboard`.enumerations;
18 DROP TABLE IF EXISTS `redmine_dashboard`.issue_categories;
19 DROP TABLE IF EXISTS `redmine_dashboard`.issue_relations;
20 DROP TABLE IF EXISTS `redmine_dashboard`.issue_statuses;
21 DROP TABLE IF EXISTS `redmine_dashboard`.issues;
22 DROP TABLE IF EXISTS `redmine_dashboard`.journal_details;
23 DROP TABLE IF EXISTS `redmine_dashboard`.journals;
24 DROP TABLE IF EXISTS `redmine_dashboard`.projects;
25 DROP TABLE IF EXISTS `redmine_dashboard`.projects_trackers;
26 DROP TABLE IF EXISTS `redmine_dashboard`.time_logs;
27 DROP TABLE IF EXISTS `redmine_dashboard`.trackers;
28 DROP TABLE IF EXISTS `redmine_dashboard`.users;
29 DROP TABLE IF EXISTS `redmine_dashboard`.watchers;
30 DROP TABLE IF EXISTS `redmine_dashboard`.workflows;
31 DROP TABLE IF EXISTS `redmine_dashboard`.__issue_customfield;
32 DROP TABLE IF EXISTS `redmine_dashboard`.__project_customfield;
33 DROP TABLE IF EXISTS `redmine_dashboard`.__timeentry_customfield;
34 DROP TABLE IF EXISTS `redmine_dashboard`.__user_customfield;
35
36
37 -- ADDING THE MOST IMPORTANT TABLES OF REDMINE WITH ITS OWN DATATYPE STRUCTURE
38 -- BUT THE ID(S) BE VARCHAR AND ADDING LOCATION / COUNTRY COLUMN...
39 CREATE TABLE `redmine_dashboard`.custom_field_enumerations (
40
41 `id` varchar(10) NOT NULL,
42 `custom_field_id` varchar(10) NOT NULL,
43 `name` varchar(255) NOT NULL,
44 `active` tinyint(1) NOT NULL DEFAULT '1',
45 `position` varchar(10) NOT NULL DEFAULT '1',
46 `location` varchar(20) NOT NULL
47 );
48
49 CREATE TABLE `redmine_dashboard`.custom_fields (
50 `id` varchar(10) NOT NULL,
51 `type` varchar(30) NOT NULL DEFAULT '',
52 `name` varchar(30) NOT NULL DEFAULT '',
53 `field_format` varchar(30) NOT NULL DEFAULT '',
54 `possible_values` text,
55 `regexp` varchar(255) DEFAULT '',
56 `min_length` varchar(11) DEFAULT NULL,
57 `max_length` varchar(11) DEFAULT NULL,
58 `is_required` tinyint(1) NOT NULL DEFAULT '0',
59 `is_for_all` tinyint(1) NOT NULL DEFAULT '0',
60 `is_filter` tinyint(1) NOT NULL DEFAULT '0',
61 `position` varchar(11) DEFAULT '1',
62 `searchable` tinyint(1) DEFAULT '0',
63 `default_value` text,
64 `editable` tinyint(1) DEFAULT '1',
65 `visible` tinyint(1) NOT NULL DEFAULT '1',
66 `multiple` tinyint(1) DEFAULT '0',
67 `format_store` text,
68 `description` text,
69 `summable` tinyint(1) NULL DEFAULT '0',
70 `listed` tinyint(1) NULL DEFAULT '0',
71 `significant` tinyint(1) NULL DEFAULT '1',
72 `hint` varchar(255) DEFAULT NULL,
73 `location` varchar(20) NOT NULL,
74 KEY `index_custom_fields_on_id_and_type` (`id`,`type`)
75 );
76
77 CREATE TABLE `redmine_dashboard`.custom_fields_projects (
78 `custom_field_id` varchar(10) NOT NULL DEFAULT '0',
79 `project_id` varchar(10) NOT NULL DEFAULT '0',
80 `location` varchar(20) NOT NULL,
81 UNIQUE KEY `index_custom_fields_projects_on_custom_field_id_and_project_id` (`custom_field_id`,`project_id`)
82 );
83
84 CREATE TABLE `redmine_dashboard`.custom_fields_roles (
85 `custom_field_id` varchar(10) NOT NULL,
86 `role_id` varchar(10) NOT NULL,
87 `location` varchar(20) NOT NULL,
88 UNIQUE KEY `custom_fields_roles_ids` (`custom_field_id`,`role_id`)
89 );
90
91 CREATE TABLE `redmine_dashboard`.custom_fields_trackers (
92 `custom_field_id` varchar(10) NOT NULL DEFAULT '0',
93 `tracker_id` varchar(10) NOT NULL DEFAULT '0',
94 `location` varchar(20) NOT NULL,
95 UNIQUE KEY `index_custom_fields_trackers_on_custom_field_id_and_tracker_id` (`custom_field_id`,`tracker_id`)
96 );
97
98 CREATE TABLE `redmine_dashboard`.custom_values (
99 `id` varchar(10) NOT NULL,
100 `customized_type` varchar(30) NOT NULL DEFAULT '',
101 `customized_id` varchar(10) NOT NULL DEFAULT '0',
102 `custom_field_id` varchar(10) NOT NULL DEFAULT '0',
103 `value` text,
104 `location` varchar(20) NOT NULL,
105 KEY `custom_values_customized` (`customized_type`,`customized_id`),
106 KEY `index_custom_values_on_custom_field_id` (`custom_field_id`)
107 );
108
109 CREATE TABLE `redmine_dashboard`.enabled_modules (
110 `id` varchar(10) NOT NULL,
111 `project_id` varchar(11) DEFAULT NULL,
112 `name` varchar(255) NOT NULL,
113 `location` varchar(20) NOT NULL,
114 KEY `enabled_modules_project_id` (`project_id`)
115 );
116
117 CREATE TABLE `redmine_dashboard`.enumerations (
118 `id` varchar(10) NOT NULL,
119 `name` varchar(30) NOT NULL DEFAULT '',
120 `position` varchar(11) DEFAULT '1',
121 `is_default` tinyint(1) NOT NULL DEFAULT '0',
122 `type` varchar(255) DEFAULT NULL,
123 `active` tinyint(1) NOT NULL DEFAULT '1',
124 `project_id` varchar(11) DEFAULT NULL,
125 `parent_id` varchar(11) DEFAULT NULL,
126 `position_name` varchar(30) DEFAULT NULL,
127 `location` varchar(20) NOT NULL,
128 KEY `index_enumerations_on_project_id` (`project_id`),
129 KEY `index_enumerations_on_id_and_type` (`id`,`type`)
130 );
131
132 CREATE TABLE `redmine_dashboard`.issue_categories (
133 `id` varchar(10) NOT NULL,
134 `project_id` varchar(10) NOT NULL DEFAULT '0',
135 `name` varchar(60) NOT NULL DEFAULT '',
136 `assigned_to_id` varchar(11) DEFAULT NULL,
137 `location` varchar(20) NOT NULL,
138 KEY `issue_categories_project_id` (`project_id`),
139 KEY `index_issue_categories_on_assigned_to_id` (`assigned_to_id`)
140 );
141
142 CREATE TABLE `redmine_dashboard`.issue_relations (
143 `id` varchar(10) NOT NULL,
144 `issue_from_id` varchar(10) NOT NULL,
145 `issue_to_id` varchar(10) NOT NULL,
146 `relation_type` varchar(255) NOT NULL DEFAULT '',
147 `delay` varchar(11) DEFAULT NULL,
148 `location` varchar(20) NOT NULL,
149 UNIQUE KEY `index_issue_relations_on_issue_from_id_and_issue_to_id` (`issue_from_id`,`issue_to_id`),
150 KEY `index_issue_relations_on_issue_from_id` (`issue_from_id`),
151 KEY `index_issue_relations_on_issue_to_id` (`issue_to_id`)
152 );
153
154 CREATE TABLE `redmine_dashboard`.issue_statuses (
155 `id` varchar(10) NOT NULL,
156 `name` varchar(30) NOT NULL DEFAULT '',
157 `is_closed` tinyint(1) NOT NULL DEFAULT '0',
158 `position` varchar(11) DEFAULT '1',
159 `default_done_ratio` varchar(11) DEFAULT NULL,
160 `location` varchar(20) NOT NULL,
161 KEY `index_issue_statuses_on_position` (`position`),
162 KEY `index_issue_statuses_on_is_closed` (`is_closed`)
163 );
164
165 CREATE TABLE `redmine_dashboard`.issues (
166 `id` varchar(10) NOT NULL,
167 `tracker_id` varchar(10) NOT NULL,
168 `project_id` varchar(10) NOT NULL,
169 `subject` varchar(255) NOT NULL DEFAULT '',
170 `description` text,
171 `due_date` date DEFAULT NULL,
172 `category_id` varchar(11) DEFAULT NULL,
173 `status_id` varchar(10) NOT NULL,
174 `assigned_to_id` varchar(11) DEFAULT NULL,
175 `priority_id` varchar(10) NOT NULL,
176 `fixed_version_id` varchar(11) DEFAULT NULL,
177 `author_id` varchar(10) NOT NULL,
178 `lock_version` varchar(10) NOT NULL DEFAULT '0',
179 `created_on` datetime DEFAULT NULL,
180 `updated_on` datetime DEFAULT NULL,
181 `start_date` date DEFAULT NULL,
182 `done_ratio` varchar(10) NOT NULL DEFAULT '0',
183 `estimated_hours` double DEFAULT NULL,
184 `parent_id` varchar(11) DEFAULT NULL,
185 `root_id` varchar(11) DEFAULT NULL,
186 `lft` varchar(11) DEFAULT NULL,
187 `rgt` varchar(11) DEFAULT NULL,
188 `is_private` tinyint(1) NOT NULL DEFAULT '0',
189 `closed_on` datetime DEFAULT NULL,
190 `location` varchar(20) NOT NULL,
191 KEY `issues_project_id` (`project_id`),
192 KEY `index_issues_on_status_id` (`status_id`),
193 KEY `index_issues_on_category_id` (`category_id`),
194 KEY `index_issues_on_assigned_to_id` (`assigned_to_id`),
195 KEY `index_issues_on_fixed_version_id` (`fixed_version_id`),
196 KEY `index_issues_on_tracker_id` (`tracker_id`),
197 KEY `index_issues_on_priority_id` (`priority_id`),
198 KEY `index_issues_on_author_id` (`author_id`),
199 KEY `index_issues_on_created_on` (`created_on`),
200 KEY `index_issues_on_root_id_and_lft_and_rgt` (`root_id`,`lft`,`rgt`)
201 );
202
203 CREATE TABLE `redmine_dashboard`.journal_details (
204 `id` varchar(10) NOT NULL,
205 `journal_id` varchar(10) NOT NULL DEFAULT '0',
206 `property` varchar(30) NOT NULL DEFAULT '',
207 `prop_key` varchar(30) NOT NULL DEFAULT '',
208 `old_value` text,
209 `value` text,
210 `location` varchar(20) NOT NULL,
211 KEY `journal_details_journal_id` (`journal_id`)
212 );
213
214 CREATE TABLE `redmine_dashboard`.journals (
215 `id` varchar(10) NOT NULL,
216 `journalized_id` varchar(10) NOT NULL DEFAULT '0',
217 `journalized_type` varchar(30) NOT NULL DEFAULT '',
218 `user_id` varchar(10) NOT NULL DEFAULT '0',
219 `notes` text,
220 `created_on` datetime NOT NULL,
221 `private_notes` tinyint(1) NOT NULL DEFAULT '0',
222 `location` varchar(20) NOT NULL,
223 KEY `journals_journalized_id` (`journalized_id`,`journalized_type`),
224 KEY `index_journals_on_user_id` (`user_id`),
225 KEY `index_journals_on_journalized_id` (`journalized_id`),
226 KEY `index_journals_on_created_on` (`created_on`)
227 );
228
229 CREATE TABLE `redmine_dashboard`.projects (
230 `id` varchar(10) NOT NULL,
231 `name` varchar(255) NOT NULL DEFAULT '',
232 `description` text,
233 `homepage` varchar(255) DEFAULT '',
234 `is_public` tinyint(1) NOT NULL DEFAULT '1',
235 `parent_id` varchar(11) DEFAULT NULL,
236 `created_on` datetime DEFAULT NULL,
237 `updated_on` datetime DEFAULT NULL,
238 `identifier` varchar(255) DEFAULT NULL,
239 `status` varchar(10) NOT NULL DEFAULT '1',
240 `lft` varchar(11) DEFAULT NULL,
241 `rgt` varchar(11) DEFAULT NULL,
242 `inherit_members` tinyint(1) NOT NULL DEFAULT '0',
243 `default_version_id` varchar(11) DEFAULT NULL,
244 `location` varchar(20) NOT NULL,
245 KEY `index_projects_on_lft` (`lft`),
246 KEY `index_projects_on_rgt` (`rgt`)
247 );
248
249 CREATE TABLE `redmine_dashboard`.projects_trackers (
250 `project_id` varchar(10) NOT NULL DEFAULT '0',
251 `tracker_id` varchar(10) NOT NULL DEFAULT '0',
252 `location` varchar(20) NOT NULL,
253 UNIQUE KEY `projects_trackers_unique` (`project_id`,`tracker_id`),
254 KEY `projects_trackers_project_id` (`project_id`)
255 );
256
257 CREATE TABLE `redmine_dashboard`.time_entries (
258 `id` varchar(10) NOT NULL,
259 `project_id` varchar(10) NOT NULL,
260 `user_id` varchar(10) NOT NULL,
261 `issue_id` varchar(11) DEFAULT NULL,
262 `hours` double NOT NULL,
263 `comments` varchar(1024) DEFAULT NULL,
264 `activity_id` varchar(10) NOT NULL,
265 `spent_on` date NOT NULL,
266 `tyear` varchar(10) NOT NULL,
267 `tmonth` varchar(10) NOT NULL,
268 `tweek` varchar(10) NOT NULL,
269 `created_on` datetime NOT NULL,
270 `updated_on` datetime NOT NULL,
271 `location` varchar(20) NOT NULL,
272 KEY `time_entries_project_id` (`project_id`),
273 KEY `time_entries_issue_id` (`issue_id`),
274 KEY `index_time_entries_on_activity_id` (`activity_id`),
275 KEY `index_time_entries_on_user_id` (`user_id`),
276 KEY `index_time_entries_on_created_on` (`created_on`)
277 );
278
279 CREATE TABLE `redmine_dashboard`.time_logs (
280 `id` varchar(10) NOT NULL,
281 `user_id` varchar(11) DEFAULT NULL,
282 `started_on` datetime DEFAULT NULL,
283 `stopped_at` datetime DEFAULT NULL,
284 `project_id` varchar(11) DEFAULT NULL,
285 `comments` varchar(255) DEFAULT NULL,
286 `bookable` tinyint(1) DEFAULT '1',
287 `location` varchar(20) NOT NULL
288 );
289
290 CREATE TABLE `redmine_dashboard`.trackers (
291 `id` varchar(10) NOT NULL,
292 `name` varchar(30) NOT NULL DEFAULT '',
293 `is_in_chlog` tinyint(1) NOT NULL DEFAULT '0',
294 `position` varchar(11) DEFAULT '1',
295 `is_in_roadmap` tinyint(1) NOT NULL DEFAULT '1',
296 `fields_bits` varchar(11) DEFAULT '0',
297 `default_status_id` varchar(11) DEFAULT NULL,
298 `location` varchar(20) NOT NULL
299 );
300
301 CREATE TABLE `redmine_dashboard`.users (
302 `id` varchar(10) NOT NULL,
303 `login` varchar(255) NOT NULL DEFAULT '',
304 `hashed_password` varchar(40) NOT NULL DEFAULT '',
305 `firstname` varchar(30) NOT NULL DEFAULT '',
306 `lastname` varchar(255) NOT NULL DEFAULT '',
307 `admin` tinyint(1) NOT NULL DEFAULT '0',
308 `status` varchar(10) NOT NULL DEFAULT '1',
309 `last_login_on` datetime DEFAULT NULL,
310 `language` varchar(5) DEFAULT '',
311 `auth_source_id` varchar(11) DEFAULT NULL,
312 `created_on` datetime DEFAULT NULL,
313 `updated_on` datetime DEFAULT NULL,
314 `type` varchar(255) DEFAULT NULL,
315 `identity_url` varchar(255) DEFAULT NULL,
316 `mail_notification` varchar(255) NOT NULL DEFAULT '',
317 `salt` varchar(64) DEFAULT NULL,
318 `must_change_passwd` tinyint(1) NOT NULL DEFAULT '0',
319 `passwd_changed_on` datetime DEFAULT NULL,
320 `phone` varchar(255) DEFAULT NULL,
321 `address` varchar(255) DEFAULT NULL,
322 `skype` varchar(255) DEFAULT NULL,
323 `birthday` date DEFAULT NULL,
324 `job_title` varchar(255) DEFAULT NULL,
325 `company` varchar(255) DEFAULT NULL,
326 `middlename` varchar(255) DEFAULT NULL,
327 `gender` smallint(6) DEFAULT NULL,
328 `twitter` varchar(255) DEFAULT NULL,
329 `facebook` varchar(255) DEFAULT NULL,
330 `linkedin` varchar(255) DEFAULT NULL,
331 `background` text,
332 `appearance_date` date DEFAULT NULL,
333 `department_id` varchar(11) DEFAULT NULL,
334 `location` varchar(20) NOT NULL,
335 KEY `index_users_on_id_and_type` (`id`,`type`),
336 KEY `index_users_on_auth_source_id` (`auth_source_id`),
337 KEY `index_users_on_type` (`type`)
338 );
339
340 CREATE TABLE `redmine_dashboard`.watchers (
341 `id` varchar(10) NOT NULL,
342 `watchable_type` varchar(255) NOT NULL DEFAULT '',
343 `watchable_id` varchar(10) NOT NULL DEFAULT '0',
344 `user_id` varchar(11) DEFAULT NULL,
345 `location` varchar(20) NOT NULL,
346 KEY `watchers_user_id_type` (`user_id`,`watchable_type`),
347 KEY `index_watchers_on_user_id` (`user_id`),
348 KEY `index_watchers_on_watchable_id_and_watchable_type` (`watchable_id`,`watchable_type`)
349 );
350
351 CREATE TABLE `redmine_dashboard`.workflows (
352 `id` varchar(10) NOT NULL,
353 `tracker_id` varchar(10) NOT NULL DEFAULT '0',
354 `old_status_id` varchar(10) NOT NULL DEFAULT '0',
355 `new_status_id` varchar(10) NOT NULL DEFAULT '0',
356 `role_id` varchar(10) NOT NULL DEFAULT '0',
357 `assignee` tinyint(1) NOT NULL DEFAULT '0',
358 `author` tinyint(1) NOT NULL DEFAULT '0',
359 `type` varchar(30) DEFAULT NULL,
360 `field_name` varchar(30) DEFAULT NULL,
361 `rule` varchar(30) DEFAULT NULL,
362 `location` varchar(20) NOT NULL,
363 KEY `wkfs_role_tracker_old_status` (`role_id`,`tracker_id`,`old_status_id`),
364 KEY `index_workflows_on_old_status_id` (`old_status_id`),
365 KEY `index_workflows_on_role_id` (`role_id`),
366 KEY `index_workflows_on_new_status_id` (`new_status_id`)
367 );
368
369 CREATE TABLE `redmine_dashboard`.__issue_customfield (
370 `issue_id` varchar(20) NOT NULL,
371 `educational_QC` varchar(255) DEFAULT NULL,
372 `storyboard_document_link` varchar(255) DEFAULT NULL,
373 `user` varchar(100) DEFAULT NULL,
374 `issue_type` varchar(100) DEFAULT NULL,
375 `critical_path` varchar(255) DEFAULT NULL,
376 `approved_task` text DEFAULT NULL,
377 `deviation_reason` text DEFAULT NULL,
378 `issue_job_title` varchar(150) DEFAULT NULL,
379 `issue_seniorty_level` varchar(150) DEFAULT NULL,
380 `product_code` varchar(150) DEFAULT NULL,
381 `product_man_days` double(50,5) DEFAULT NULL
382 );
383
384 CREATE TABLE `redmine_dashboard`.__project_customfield (
385 `project_id` varchar(20) NOT NULL,
386 `business_unit` varchar(150) DEFAULT NULL,
387 `contract_name` varchar(150) DEFAULT NULL,
388 `project_code` varchar(50) DEFAULT NULL,
389 `project_name` varchar(255) DEFAULT NULL,
390 `start_date` date DEFAULT NULL,
391 `project_manager` varchar(150) DEFAULT NULL,
392 `phase` varchar(150) DEFAULT NULL,
393 `general_status` varchar(150) DEFAULT NULL,
394 `cost_centre` varchar(150) DEFAULT NULL,
395 `location` varchar(15) DEFAULT NULL,
396 `deliverables` varchar(150) DEFAULT NULL,
397 `notes` text DEFAULT NULL,
398 `completion` varchar(500) DEFAULT NULL,
399 `allocation_type` varchar(150) DEFAULT NULL,
400 `end_date` date DEFAULT NULL,
401 `customer` varchar(150) DEFAULT NULL,
402 `top_project` tinyint(1) DEFAULT NULL,
403 `project_entity` varchar(2550) DEFAULT NULL
404 );
405
406 CREATE TABLE `redmine_dashboard`.__timeentry_customfield (
407 `time_entry_id` varchar(20) NOT NULL,
408 `idle_time_type` varchar(150) DEFAULT NULL,
409 `overtime` tinyint(1) DEFAULT NULL
410 );
411
412 CREATE TABLE `redmine_dashboard`.__user_customfield (
413 `user_id` varchar(20) NOT NULL,
414 `department` varchar(150) DEFAULT NULL,
415 `country` varchar(150) DEFAULT NULL,
416 `job_title` varchar(150) DEFAULT NULL,
417 `employment_status` varchar(75) DEFAULT NULL,
418 `employee_level` varchar(75) DEFAULT NULL,
419 `employee_id` bigint(20) DEFAULT NULL,
420 `entity` varchar(100) DEFAULT NULL,
421 `employee_category` varchar(100) DEFAULT NULL
422 );
423
424
425 -- ADDING INDEXES TO MOST IMPORTANT COLUMN TO MAKE INNER JOIN EASY AND FAST...
426 ALTER TABLE `redmine_dashboard`.enumerations
427 ADD INDEX(`parent_id`);
428
429 ALTER TABLE `redmine_dashboard`.issues
430 ADD INDEX(`id`);
431
432 ALTER TABLE `redmine_dashboard`.issues
433 ADD INDEX(`parent_id`);
434
435 ALTER TABLE `redmine_dashboard`.issue_relations
436 ADD INDEX(`id`);
437
438 ALTER TABLE `redmine_dashboard`.issue_statuses
439 ADD INDEX(`id`);
440
441 ALTER TABLE `redmine_dashboard`.journals
442 ADD INDEX(`id`);
443
444 ALTER TABLE `redmine_dashboard`.journal_details
445 ADD INDEX(`id`);
446
447 ALTER TABLE `redmine_dashboard`.projects
448 ADD INDEX(`id`);
449
450 ALTER TABLE `redmine_dashboard`.projects
451 ADD INDEX(`parent_id`);
452
453 ALTER TABLE `redmine_dashboard`.time_entries
454 ADD INDEX(`id`);
455
456 ALTER TABLE `redmine_dashboard`.time_logs
457 ADD INDEX(`id`);
458
459 ALTER TABLE `redmine_dashboard`.trackers
460 ADD INDEX(`id`);
461
462 ALTER TABLE `redmine_dashboard`.trackers
463 ADD INDEX(`name`);
464
465 ALTER TABLE `redmine_dashboard`.users
466 ADD INDEX(`id`);
467
468 ALTER TABLE `redmine_dashboard`.watchers
469 ADD INDEX(`id`);
470
471 ALTER TABLE `redmine_dashboard`.workflows
472 ADD INDEX(`id`);
473
474 ALTER TABLE `redmine_dashboard`.__issue_customfield
475 ADD INDEX(`issue_id`);
476
477 ALTER TABLE `redmine_dashboard`.__project_customfield
478 ADD INDEX(`project_id`);
479
480 ALTER TABLE `redmine_dashboard`.__timeentry_customfield
481 ADD INDEX(`time_entry_id`);
482
483 ALTER TABLE `redmine_dashboard`.__user_customfield
484 ADD INDEX(`user_id`);
485
486
487 -- MERGING IN ACTION(1/4)!!!...
488 -- START OF JORDAN DATABASE...
489 INSERT INTO redmine_dashboard.projects
490 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.projects.id) AS 'id', `redmine_jo`.projects.name, `redmine_jo`.projects.description, `redmine_jo`.projects.homepage, `redmine_jo`.projects.is_public, CONCAT_WS('', 'jo-', `redmine_jo`.projects.parent_id) AS 'parent_id' , `redmine_jo`.projects.created_on, `redmine_jo`.projects.updated_on, `redmine_jo`.projects.identifier, `redmine_jo`.projects.status, `redmine_jo`.projects.lft, `redmine_jo`.projects.rgt, `redmine_jo`.projects.inherit_members, `redmine_jo`.projects.default_version_id, 'Jordan'
491 FROM `redmine_jo`.projects;
492
493 UPDATE `redmine_dashboard`.projects
494 SET parent_id = NULL
495 WHERE parent_id = 'jo-';
496
497 UPDATE `redmine_dashboard`.projects
498 SET status = 'Active'
499 WHERE status = '1';
500
501 UPDATE `redmine_dashboard`.projects
502 SET status = 'Closed'
503 WHERE status = '5';
504
505 -- END OF THIS TABLE
506
507 INSERT INTO redmine_dashboard.custom_fields
508 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.custom_fields.id) AS 'id', `redmine_jo`.custom_fields.type, `redmine_jo`.custom_fields.name, `redmine_jo`.custom_fields.field_format, `redmine_jo`.custom_fields.possible_values, `redmine_jo`.custom_fields.regexp, `redmine_jo`.custom_fields.min_length, `redmine_jo`.custom_fields.max_length, `redmine_jo`.custom_fields.is_required, `redmine_jo`.custom_fields.is_for_all, `redmine_jo`.custom_fields.is_filter, `redmine_jo`.custom_fields.position, `redmine_jo`.custom_fields.searchable, `redmine_jo`.custom_fields.default_value, `redmine_jo`.custom_fields.editable, `redmine_jo`.custom_fields.visible, `redmine_jo`.custom_fields.multiple, `redmine_jo`.custom_fields.format_store, `redmine_jo`.custom_fields.description, `redmine_jo`.custom_fields.summable, `redmine_jo`.custom_fields.listed, `redmine_jo`.custom_fields.significant, `redmine_jo`.custom_fields.hint, 'Jordan'
509 FROM `redmine_jo`.custom_fields;
510
511 -- END OF THIS TABLE
512
513 INSERT INTO redmine_dashboard.custom_fields_projects
514 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.custom_fields_projects.custom_field_id) AS 'custom_field_id',CONCAT_WS('', 'jo-', `redmine_jo`.custom_fields_projects.project_id) AS 'project_id', 'Jordan'
515 FROM `redmine_jo`.custom_fields_projects;
516
517 -- END OF THIS TABLE
518
519 INSERT INTO redmine_dashboard.custom_fields_roles
520 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.custom_fields_roles.custom_field_id) AS 'custom_field_id',CONCAT_WS('', 'jo-', `redmine_jo`.custom_fields_roles.role_id) AS 'role_id', 'Jordan'
521 FROM `redmine_jo`.custom_fields_roles;
522
523 -- END OF THIS TABLE
524
525 INSERT INTO redmine_dashboard.custom_fields_trackers
526 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.custom_fields_trackers.custom_field_id) AS 'custom_field_id',CONCAT_WS('', 'jo-', `redmine_jo`.custom_fields_trackers.tracker_id) AS 'tracker_id', 'Jordan'
527 FROM `redmine_jo`.custom_fields_trackers;
528
529 -- END OF THIS TABLE
530
531 INSERT INTO redmine_dashboard.custom_field_enumerations
532 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.custom_field_enumerations.id) AS 'id',CONCAT_WS('', 'jo-', `redmine_jo`.custom_field_enumerations.custom_field_id) AS 'custom_field_id', `redmine_jo`.custom_field_enumerations.name, `redmine_jo`.custom_field_enumerations.active, `redmine_jo`.custom_field_enumerations.position, 'Jordan'
533 FROM `redmine_jo`.custom_field_enumerations;
534
535 -- END OF THIS TABLE
536
537 INSERT INTO redmine_dashboard.custom_values
538 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.custom_values.id) AS 'id', `redmine_jo`.custom_values.customized_type, CONCAT_WS('', 'jo-', `redmine_jo`.custom_values.customized_id) AS 'customized_id', CONCAT_WS('', 'jo-', `redmine_jo`.custom_values.custom_field_id) AS 'custom_field_id', `redmine_jo`.custom_values.value, 'Jordan'
539 FROM `redmine_jo`.custom_values;
540
541 -- END OF THIS TABLE
542
543 INSERT INTO redmine_dashboard.enabled_modules
544 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.enabled_modules.id) AS 'id', CONCAT_WS('', 'jo-', `redmine_jo`.enabled_modules.project_id) AS 'project_id', `redmine_jo`.enabled_modules.name, 'Jordan'
545 FROM `redmine_jo`.enabled_modules;
546
547 -- END OF THIS TABLE
548
549 INSERT INTO redmine_dashboard.issues
550 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.issues.id) AS 'id', CONCAT_WS('', 'jo-', `redmine_jo`.issues.tracker_id) AS 'tracker_id', CONCAT_WS('', 'jo-', `redmine_jo`.issues.project_id) AS 'project_id', `redmine_jo`.issues.subject, `redmine_jo`.issues.description, `redmine_jo`.issues.due_date, `redmine_jo`.issues.category_id, `redmine_jo`.issues.status_id, `redmine_jo`.issues.assigned_to_id, `redmine_jo`.issues.priority_id, `redmine_jo`.issues.fixed_version_id, CONCAT_WS('', 'jo-', `redmine_jo`.issues.author_id) AS 'author_id', `redmine_jo`.issues.lock_version, `redmine_jo`.issues.created_on, `redmine_jo`.issues.updated_on, `redmine_jo`.issues.start_date, `redmine_jo`.issues.done_ratio, `redmine_jo`.issues.estimated_hours, CONCAT_WS('', 'jo-', `redmine_jo`.issues.parent_id) AS 'parent_id', CONCAT_WS('', 'jo-', `redmine_jo`.issues.root_id) AS 'root_id', `redmine_jo`.issues.lft, `redmine_jo`.issues.rgt, `redmine_jo`.issues.is_private, `redmine_jo`.issues.closed_on, 'Jordan'
551 FROM `redmine_jo`.issues;
552
553 UPDATE `redmine_dashboard`.issues
554 SET tracker_id = NULL
555 WHERE tracker_id = 'jo-';
556
557 UPDATE `redmine_dashboard`.issues
558 SET project_id = NULL
559 WHERE project_id = 'jo-';
560
561 UPDATE `redmine_dashboard`.issues
562 SET author_id = NULL
563 WHERE author_id = 'jo-';
564
565 UPDATE `redmine_dashboard`.issues
566 SET parent_id = NULL
567 WHERE parent_id = 'jo-';
568
569 UPDATE `redmine_dashboard`.issues
570 SET root_id = NULL
571 WHERE root_id = 'jo-';
572
573 -- END OF THIS TABLE
574
575 INSERT INTO redmine_dashboard.issue_relations
576 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.issue_relations.id) AS 'id', CONCAT_WS('', 'jo-', `redmine_jo`.issue_relations.issue_from_id) AS 'issue_from_id', CONCAT_WS('', 'jo-', `redmine_jo`.issue_relations.issue_to_id) AS 'issue_to_id', `redmine_jo`.issue_relations.relation_type, `redmine_jo`.issue_relations.delay, 'Jordan'
577 FROM `redmine_jo`.issue_relations;
578
579 -- END OF THIS TABLE
580
581 INSERT INTO redmine_dashboard.issue_statuses
582 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.issue_statuses.id) AS 'id', `redmine_jo`.issue_statuses.name, `redmine_jo`.issue_statuses.is_closed, `redmine_jo`.issue_statuses.position, `redmine_jo`.issue_statuses.default_done_ratio, 'Jordan'
583 FROM `redmine_jo`.issue_statuses;
584
585 -- END OF THIS TABLE
586
587 INSERT INTO redmine_dashboard.journals
588 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.journals.id) AS 'id', `redmine_jo`.journals.journalized_id, `redmine_jo`.journals.journalized_type, CONCAT_WS('', 'jo-', `redmine_jo`.journals.user_id) AS 'user_id', `redmine_jo`.journals.notes, `redmine_jo`.journals.created_on, `redmine_jo`.journals.private_notes, 'Jordan'
589 FROM `redmine_jo`.journals;
590
591 -- END OF THIS TABLE
592
593 INSERT INTO redmine_dashboard.journal_details
594 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.journal_details.id) AS 'id', CONCAT_WS('', 'jo-', `redmine_jo`.journal_details.journal_id) AS 'journal_id', `redmine_jo`.journal_details.property, `redmine_jo`.journal_details.prop_key, `redmine_jo`.journal_details.old_value, `redmine_jo`.journal_details.value, 'Jordan'
595 FROM `redmine_jo`.journal_details;
596
597 -- END OF THIS TABLE
598
599 INSERT INTO redmine_dashboard.projects_trackers
600 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.projects_trackers.project_id) AS 'project_id', CONCAT_WS('', 'jo-', `redmine_jo`.projects_trackers.tracker_id) AS 'tracker_id', 'Jordan'
601 FROM `redmine_jo`.projects_trackers;
602
603 -- END OF THIS TABLE
604
605 INSERT INTO redmine_dashboard.time_entries
606 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.time_entries.id) AS 'id' ,CONCAT_WS('', 'jo-', `redmine_jo`.time_entries.project_id) AS 'project_id', CONCAT_WS('', 'jo-', `redmine_jo`.time_entries.user_id) AS 'user_id', CONCAT_WS('', 'jo-', `redmine_jo`.time_entries.issue_id) AS 'issue_id', `redmine_jo`.time_entries.hours, `redmine_jo`.time_entries.comments, CONCAT_WS('', 'jo-', `redmine_jo`.time_entries.activity_id) AS 'activity_id', `redmine_jo`.time_entries.spent_on, `redmine_jo`.time_entries.tyear, `redmine_jo`.time_entries.tmonth, `redmine_jo`.time_entries.tweek, `redmine_jo`.time_entries.created_on, `redmine_jo`.time_entries.updated_on, 'Jordan'
607 FROM `redmine_jo`.time_entries;
608
609 UPDATE `redmine_dashboard`.time_entries
610 SET project_id = NULL
611 WHERE project_id = 'jo-';
612
613 UPDATE `redmine_dashboard`.time_entries
614 SET user_id = NULL
615 WHERE user_id = 'jo-';
616
617 UPDATE `redmine_dashboard`.time_entries
618 SET issue_id = NULL
619 WHERE issue_id = 'jo-';
620
621 UPDATE `redmine_dashboard`.time_entries
622 SET activity_id = NULL
623 WHERE activity_id = 'jo-';
624
625 -- END OF THIS TABLE
626
627 INSERT INTO redmine_dashboard.time_logs
628 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.time_logs.id) AS 'id' ,CONCAT_WS('', 'jo-', `redmine_jo`.time_logs.user_id) AS 'user_id', `redmine_jo`.time_logs.started_on, `redmine_jo`.time_logs.stopped_at, CONCAT_WS('', 'jo-', `redmine_jo`.time_logs.project_id) AS 'project_id', `redmine_jo`.time_logs.comments, `redmine_jo`.time_logs.bookable, 'Jordan'
629 FROM `redmine_jo`.time_logs;
630
631 UPDATE `redmine_dashboard`.time_logs
632 SET user_id = NULL
633 WHERE user_id = 'jo-';
634
635 UPDATE `redmine_dashboard`.time_logs
636 SET project_id = NULL
637 WHERE project_id = 'jo-';
638
639 -- END OF THIS TABLE
640
641 INSERT INTO redmine_dashboard.trackers
642 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.trackers.id) AS 'id', `redmine_jo`.trackers.name, `redmine_jo`.trackers.is_in_chlog, `redmine_jo`.trackers.position, `redmine_jo`.trackers.is_in_roadmap, `redmine_jo`.trackers.fields_bits, `redmine_jo`.trackers.default_status_id, 'Jordan'
643 FROM `redmine_jo`.trackers;
644
645 -- END OF THIS TABLE
646
647 INSERT INTO redmine_dashboard.users
648 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.users.id) AS 'id', `redmine_jo`.users.login, `redmine_jo`.users.hashed_password, `redmine_jo`.users.firstname, `redmine_jo`.users.lastname, `redmine_jo`.users.admin, `redmine_jo`.users.status, `redmine_jo`.users.last_login_on, `redmine_jo`.users.language, `redmine_jo`.users.auth_source_id, `redmine_jo`.users.created_on, `redmine_jo`.users.updated_on, `redmine_jo`.users.type, `redmine_jo`.users.identity_url, `redmine_jo`.users.mail_notification, `redmine_jo`.users.salt, `redmine_jo`.users.must_change_passwd, `redmine_jo`.users.passwd_changed_on, `redmine_jo`.users.phone, `redmine_jo`.users.address, `redmine_jo`.users.skype, `redmine_jo`.users.birthday, `redmine_jo`.users.job_title, `redmine_jo`.users.company, `redmine_jo`.users.middlename, `redmine_jo`.users.gender, `redmine_jo`.users.twitter, `redmine_jo`.users.facebook, `redmine_jo`.users.linkedin, `redmine_jo`.users.background, `redmine_jo`.users.appearance_date, `redmine_jo`.users.department_id, 'Jordan'
649 FROM `redmine_jo`.users;
650
651 -- END OF THIS TABLE
652
653 INSERT INTO redmine_dashboard.watchers
654 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.watchers.id) AS 'id', `redmine_jo`.watchers.watchable_type, CONCAT_WS('', 'jo-', `redmine_jo`.watchers.watchable_id) AS 'watchable_id', CONCAT_WS('', 'jo-', `redmine_jo`.watchers.user_id) AS 'user_id', 'Jordan'
655 FROM `redmine_jo`.watchers;
656
657 -- END OF THIS TABLE
658
659 INSERT INTO redmine_dashboard.workflows
660 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.workflows.id) AS 'id', CONCAT_WS('', 'jo-', `redmine_jo`.workflows.tracker_id) AS 'tracker_id', CONCAT_WS('', 'jo-', `redmine_jo`.workflows.old_status_id) AS 'old_status_id', CONCAT_WS('', 'jo-', `redmine_jo`.workflows.new_status_id) AS 'new_status_id', `redmine_jo`.workflows.role_id, `redmine_jo`.workflows.assignee, `redmine_jo`.workflows.author, `redmine_jo`.workflows.type, `redmine_jo`.workflows.field_name, `redmine_jo`.workflows.rule, 'Jordan'
661 FROM `redmine_jo`.workflows;
662
663 -- END OF THIS TABLE
664
665 INSERT INTO redmine_dashboard.issue_categories
666 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.issue_categories.id) AS 'id', CONCAT_WS('', 'jo-', `redmine_jo`.issue_categories.project_id) AS 'project_id', `redmine_jo`.issue_categories.name, CONCAT_WS('', 'jo-', `redmine_jo`.issue_categories.assigned_to_id) AS 'assigned_to_id', 'Jordan'
667 FROM `redmine_jo`.issue_categories;
668
669 -- END OF THIS TABLE
670
671 INSERT INTO redmine_dashboard.enumerations
672 SELECT CONCAT_WS('', 'jo-', `redmine_jo`.enumerations.id) AS 'id', `redmine_jo`.enumerations.name, `redmine_jo`.enumerations.position, `redmine_jo`.enumerations.is_default, `redmine_jo`.enumerations.type, `redmine_jo`.enumerations.active, CONCAT_WS('', 'jo-', `redmine_jo`.enumerations.project_id) AS 'project_id', (`redmine_jo`.enumerations.parent_id) AS 'parent_id', `redmine_jo`.enumerations.position_name, 'Jordan'
673 FROM `redmine_jo`.enumerations;
674
675 -- END OF THIS TABLE
676 -- END OF JORDAN DATABASE...
677 -- SECOND PART OF MERGING(2/4)...
678 -- START OF EGYPT DATABASE...
679
680 INSERT INTO redmine_dashboard.projects
681 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.projects.id) AS 'id', `redmine_eg`.projects.name, `redmine_eg`.projects.description, `redmine_eg`.projects.homepage, `redmine_eg`.projects.is_public, CONCAT_WS('', 'eg-', `redmine_eg`.projects.parent_id) AS 'parent_id' , `redmine_eg`.projects.created_on, `redmine_eg`.projects.updated_on, `redmine_eg`.projects.identifier, `redmine_eg`.projects.status, `redmine_eg`.projects.lft, `redmine_eg`.projects.rgt, `redmine_eg`.projects.inherit_members, `redmine_eg`.projects.default_version_id, 'Egypt'
682 FROM `redmine_eg`.projects;
683
684 UPDATE `redmine_dashboard`.projects
685 SET parent_id = NULL
686 WHERE parent_id = 'eg-';
687
688
689 UPDATE `redmine_dashboard`.projects
690 SET status = 'Active'
691 WHERE status = '1';
692
693 UPDATE `redmine_dashboard`.projects
694 SET status = 'Closed'
695 WHERE status = '5';
696
697 -- END OF THIS TABLE
698
699 INSERT INTO redmine_dashboard.custom_fields
700 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.custom_fields.id) AS 'id', `redmine_eg`.custom_fields.type, `redmine_eg`.custom_fields.name, `redmine_eg`.custom_fields.field_format, `redmine_eg`.custom_fields.possible_values, `redmine_eg`.custom_fields.regexp, `redmine_eg`.custom_fields.min_length, `redmine_eg`.custom_fields.max_length, `redmine_eg`.custom_fields.is_required, `redmine_eg`.custom_fields.is_for_all, `redmine_eg`.custom_fields.is_filter, `redmine_eg`.custom_fields.position, `redmine_eg`.custom_fields.searchable, `redmine_eg`.custom_fields.default_value, `redmine_eg`.custom_fields.editable, `redmine_eg`.custom_fields.visible, `redmine_eg`.custom_fields.multiple, `redmine_eg`.custom_fields.format_store, `redmine_eg`.custom_fields.description, NULL, NULL, NULL, NULL, 'Egypt'
701 FROM `redmine_eg`.custom_fields;
702
703 -- END OF THIS TABLE
704
705 INSERT INTO redmine_dashboard.custom_fields_projects
706 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.custom_fields_projects.custom_field_id) AS 'custom_field_id',CONCAT_WS('', 'eg-', `redmine_eg`.custom_fields_projects.project_id) AS 'project_id', 'Egypt'
707 FROM `redmine_eg`.custom_fields_projects;
708
709 -- END OF THIS TABLE
710
711 INSERT INTO redmine_dashboard.custom_fields_roles
712 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.custom_fields_roles.custom_field_id) AS 'custom_field_id',CONCAT_WS('', 'eg-', `redmine_eg`.custom_fields_roles.role_id) AS 'role_id', 'Egypt'
713 FROM `redmine_eg`.custom_fields_roles;
714
715 -- END OF THIS TABLE
716
717 INSERT INTO redmine_dashboard.custom_fields_trackers
718 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.custom_fields_trackers.custom_field_id) AS 'custom_field_id',CONCAT_WS('', 'eg-', `redmine_eg`.custom_fields_trackers.tracker_id) AS 'tracker_id', 'Egypt'
719 FROM `redmine_eg`.custom_fields_trackers;
720
721 -- END OF THIS TABLE
722
723 INSERT INTO redmine_dashboard.custom_field_enumerations
724 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.custom_field_enumerations.id) AS 'id',CONCAT_WS('', 'eg-', `redmine_eg`.custom_field_enumerations.custom_field_id) AS 'custom_field_id', `redmine_eg`.custom_field_enumerations.name, `redmine_eg`.custom_field_enumerations.active, `redmine_eg`.custom_field_enumerations.position, 'Egypt'
725 FROM `redmine_eg`.custom_field_enumerations;
726
727 -- END OF THIS TABLE
728
729 INSERT INTO redmine_dashboard.custom_values
730 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.custom_values.id) AS 'id', `redmine_eg`.custom_values.customized_type, CONCAT_WS('', 'eg-', `redmine_eg`.custom_values.customized_id) AS 'customized_id', CONCAT_WS('', 'eg-', `redmine_eg`.custom_values.custom_field_id) AS 'custom_field_id', `redmine_eg`.custom_values.value, 'Egypt'
731 FROM `redmine_eg`.custom_values;
732
733 -- END OF THIS TABLE
734
735 INSERT INTO redmine_dashboard.enabled_modules
736 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.enabled_modules.id) AS 'id', CONCAT_WS('', 'eg-', `redmine_eg`.enabled_modules.project_id) AS 'project_id', `redmine_eg`.enabled_modules.name, 'Egypt'
737 FROM `redmine_eg`.enabled_modules;
738
739 -- END OF THIS TABLE
740
741 INSERT INTO redmine_dashboard.issues
742 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.issues.id) AS 'id', CONCAT_WS('', 'eg-', `redmine_eg`.issues.tracker_id) AS 'tracker_id', CONCAT_WS('', 'eg-', `redmine_eg`.issues.project_id) AS 'project_id', `redmine_eg`.issues.subject, `redmine_eg`.issues.description, `redmine_eg`.issues.due_date, `redmine_eg`.issues.category_id, `redmine_eg`.issues.status_id, `redmine_eg`.issues.assigned_to_id, `redmine_eg`.issues.priority_id, `redmine_eg`.issues.fixed_version_id, CONCAT_WS('', 'eg-', `redmine_eg`.issues.author_id) AS 'author_id', `redmine_eg`.issues.lock_version, `redmine_eg`.issues.created_on, `redmine_eg`.issues.updated_on, `redmine_eg`.issues.start_date, `redmine_eg`.issues.done_ratio, `redmine_eg`.issues.estimated_hours, CONCAT_WS('', 'eg-', `redmine_eg`.issues.parent_id) AS 'parent_id', CONCAT_WS('', 'eg-', `redmine_eg`.issues.root_id) AS 'root_id', `redmine_eg`.issues.lft, `redmine_eg`.issues.rgt, `redmine_eg`.issues.is_private, `redmine_eg`.issues.closed_on, 'Egypt'
743 FROM `redmine_eg`.issues;
744
745 UPDATE `redmine_dashboard`.issues
746 SET tracker_id = NULL
747 WHERE tracker_id = 'eg-';
748
749 UPDATE `redmine_dashboard`.issues
750 SET project_id = NULL
751 WHERE project_id = 'eg-';
752
753 UPDATE `redmine_dashboard`.issues
754 SET author_id = NULL
755 WHERE author_id = 'eg-';
756
757 UPDATE `redmine_dashboard`.issues
758 SET parent_id = NULL
759 WHERE parent_id = 'eg-';
760
761 UPDATE `redmine_dashboard`.issues
762 SET root_id = NULL
763 WHERE root_id = 'eg-';
764
765 -- END OF THIS TABLE
766
767 INSERT INTO redmine_dashboard.issue_relations
768 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.issue_relations.id) AS 'id', CONCAT_WS('', 'eg-', `redmine_eg`.issue_relations.issue_from_id) AS 'issue_from_id', CONCAT_WS('', 'eg-', `redmine_eg`.issue_relations.issue_to_id) AS 'issue_to_id', `redmine_eg`.issue_relations.relation_type, `redmine_eg`.issue_relations.delay, 'Egypt'
769 FROM `redmine_eg`.issue_relations;
770
771 -- END OF THIS TABLE
772
773 INSERT INTO redmine_dashboard.issue_statuses
774 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.issue_statuses.id) AS 'id', `redmine_eg`.issue_statuses.name, `redmine_eg`.issue_statuses.is_closed, `redmine_eg`.issue_statuses.position, `redmine_eg`.issue_statuses.default_done_ratio, 'Egypt'
775 FROM `redmine_eg`.issue_statuses;
776
777 -- END OF THIS TABLE
778
779 INSERT INTO redmine_dashboard.journals
780 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.journals.id) AS 'id', `redmine_eg`.journals.journalized_id, `redmine_eg`.journals.journalized_type, CONCAT_WS('', 'eg-', `redmine_eg`.journals.user_id) AS 'user_id', `redmine_eg`.journals.notes, `redmine_eg`.journals.created_on, `redmine_eg`.journals.private_notes, 'Egypt'
781 FROM `redmine_eg`.journals;
782
783 -- END OF THIS TABLE
784
785 INSERT INTO redmine_dashboard.journal_details
786 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.journal_details.id) AS 'id', CONCAT_WS('', 'eg-', `redmine_eg`.journal_details.journal_id) AS 'journal_id', `redmine_eg`.journal_details.property, `redmine_eg`.journal_details.prop_key, `redmine_eg`.journal_details.old_value, `redmine_eg`.journal_details.value, 'Egypt'
787 FROM `redmine_eg`.journal_details;
788
789 -- END OF THIS TABLE
790
791 INSERT INTO redmine_dashboard.projects_trackers
792 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.projects_trackers.project_id) AS 'project_id', CONCAT_WS('', 'eg-', `redmine_eg`.projects_trackers.tracker_id) AS 'tracker_id', 'Egypt'
793 FROM `redmine_eg`.projects_trackers;
794
795 -- END OF THIS TABLE
796
797 INSERT INTO redmine_dashboard.time_entries
798 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.time_entries.id) AS 'id' ,CONCAT_WS('', 'eg-', `redmine_eg`.time_entries.project_id) AS 'project_id', CONCAT_WS('', 'eg-', `redmine_eg`.time_entries.user_id) AS 'user_id', CONCAT_WS('', 'eg-', `redmine_eg`.time_entries.issue_id) AS 'issue_id', `redmine_eg`.time_entries.hours, `redmine_eg`.time_entries.comments, CONCAT_WS('', 'eg-', `redmine_eg`.time_entries.activity_id) AS 'activity_id', `redmine_eg`.time_entries.spent_on, `redmine_eg`.time_entries.tyear, `redmine_eg`.time_entries.tmonth, `redmine_eg`.time_entries.tweek, `redmine_eg`.time_entries.created_on, `redmine_eg`.time_entries.updated_on, 'Egypt'
799 FROM `redmine_eg`.time_entries;
800
801 UPDATE `redmine_dashboard`.time_entries
802 SET project_id = NULL
803 WHERE project_id = 'eg-';
804
805 UPDATE `redmine_dashboard`.time_entries
806 SET user_id = NULL
807 WHERE user_id = 'eg-';
808
809 UPDATE `redmine_dashboard`.time_entries
810 SET issue_id = NULL
811 WHERE issue_id = 'eg-';
812
813 UPDATE `redmine_dashboard`.time_entries
814 SET activity_id = NULL
815 WHERE activity_id = 'eg-';
816
817 -- END OF THIS TABLE
818
819 INSERT INTO redmine_dashboard.trackers
820 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.trackers.id) AS 'id', `redmine_eg`.trackers.name, `redmine_eg`.trackers.is_in_chlog, `redmine_eg`.trackers.position, `redmine_eg`.trackers.is_in_roadmap, `redmine_eg`.trackers.fields_bits, `redmine_eg`.trackers.default_status_id, 'Egypt'
821 FROM `redmine_eg`.trackers;
822
823 -- END OF THIS TABLE
824
825 INSERT INTO redmine_dashboard.users
826 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.users.id) AS 'id', `redmine_eg`.users.login, `redmine_eg`.users.hashed_password, `redmine_eg`.users.firstname, `redmine_eg`.users.lastname, `redmine_eg`.users.admin, `redmine_eg`.users.status, `redmine_eg`.users.last_login_on, `redmine_eg`.users.language, `redmine_eg`.users.auth_source_id, `redmine_eg`.users.created_on, `redmine_eg`.users.updated_on, `redmine_eg`.users.type, `redmine_eg`.users.identity_url, `redmine_eg`.users.mail_notification, `redmine_eg`.users.salt, `redmine_eg`.users.must_change_passwd, `redmine_eg`.users.passwd_changed_on, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Egypt'
827 FROM `redmine_eg`.users;
828
829 -- END OF THIS TABLE
830
831 INSERT INTO redmine_dashboard.watchers
832 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.watchers.id) AS 'id', `redmine_eg`.watchers.watchable_type, CONCAT_WS('', 'eg-', `redmine_eg`.watchers.watchable_id) AS 'watchable_id', CONCAT_WS('', 'eg-', `redmine_eg`.watchers.user_id) AS 'user_id', 'Egypt'
833 FROM `redmine_eg`.watchers;
834
835 -- END OF THIS TABLE
836
837 INSERT INTO redmine_dashboard.workflows
838 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.workflows.id) AS 'id', CONCAT_WS('', 'eg-', `redmine_eg`.workflows.tracker_id) AS 'tracker_id', CONCAT_WS('', 'eg-', `redmine_eg`.workflows.old_status_id) AS 'old_status_id', CONCAT_WS('', 'eg-', `redmine_eg`.workflows.new_status_id) AS 'new_status_id', `redmine_eg`.workflows.role_id, `redmine_eg`.workflows.assignee, `redmine_eg`.workflows.author, `redmine_eg`.workflows.type, `redmine_eg`.workflows.field_name, `redmine_eg`.workflows.rule, 'Egypt'
839 FROM `redmine_eg`.workflows;
840
841 -- END OF THIS TABLE
842
843 INSERT INTO redmine_dashboard.issue_categories
844 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.issue_categories.id) AS 'id', CONCAT_WS('', 'eg-', `redmine_eg`.issue_categories.project_id) AS 'project_id', `redmine_eg`.issue_categories.name, CONCAT_WS('', 'eg-', `redmine_eg`.issue_categories.assigned_to_id) AS 'assigned_to_id', 'Egypt'
845 FROM `redmine_eg`.issue_categories;
846
847 -- END OF THIS TABLE
848
849 INSERT INTO redmine_dashboard.enumerations
850 SELECT CONCAT_WS('', 'eg-', `redmine_eg`.enumerations.id) AS 'id', `redmine_eg`.enumerations.name, `redmine_eg`.enumerations.position, `redmine_eg`.enumerations.is_default, `redmine_eg`.enumerations.type, `redmine_eg`.enumerations.active, CONCAT_WS('', 'eg-', `redmine_eg`.enumerations.project_id) AS 'project_id', (`redmine_eg`.enumerations.parent_id) AS 'parent_id', `redmine_eg`.enumerations.position_name, 'Egypt'
851 FROM `redmine_eg`.enumerations;
852
853 -- END OF THIS TABLE
854 -- END OF EGYPT DATABASE...
855 -- THIRD PART OF MERGING(3/4)...
856 -- START TO COPYING CUSTOM FIELDS AND CUSTOM VALUES TO THE GENERATED DATABASE...
857 INSERT INTO redmine_dashboard.__issue_customfield
858 SELECT redmine_dashboard.issues.id, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
859 FROM redmine_dashboard.issues;
860
861 INSERT INTO redmine_dashboard.__project_customfield
862 SELECT redmine_dashboard.projects.id, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
863 FROM redmine_dashboard.projects;
864
865 INSERT INTO redmine_dashboard.__timeentry_customfield
866 SELECT redmine_dashboard.time_entries.id, NULL, NULL
867 FROM redmine_dashboard.time_entries;
868
869 INSERT INTO redmine_dashboard.__user_customfield
870 SELECT redmine_dashboard.users.id, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
871 FROM redmine_dashboard.users;
872
873
874 UPDATE `redmine_jo`.custom_values
875 SET `value` = NULL
876 WHERE (custom_field_id = 'jo-52' AND value = '') OR (custom_field_id = 'jo-52' AND value = ' ');
877
878 UPDATE `redmine_eg`.custom_values
879 SET `value` = NULL
880 WHERE (custom_field_id = 'eg-37' AND value = '') OR (custom_field_id = 'eg-37' AND value = ' ');
881
882 -- FOURTH PART OF MERGING(4/4)...
883 -- GRAPPING ISSUES CUSTOM VALUES AND CUSTOM FIELD VALUES...
884 UPDATE redmine_dashboard.__issue_customfield
885 INNER JOIN redmine_dashboard.custom_values
886 ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
887 SET redmine_dashboard.__issue_customfield.educational_QC = redmine_dashboard.custom_values.`value`
888 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-4';
889
890 UPDATE redmine_dashboard.__issue_customfield
891 INNER JOIN redmine_dashboard.custom_values
892 ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
893 SET redmine_dashboard.__issue_customfield.storyboard_document_link = redmine_dashboard.custom_values.`value`
894 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-5';
895
896 UPDATE redmine_dashboard.__issue_customfield
897 INNER JOIN redmine_dashboard.custom_values
898 ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
899 SET redmine_dashboard.__issue_customfield.`user` = redmine_dashboard.custom_values.`value`
900 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-7' OR redmine_dashboard.custom_values.custom_field_id = 'eg-1';
901
902 UPDATE redmine_dashboard.__issue_customfield
903 INNER JOIN redmine_dashboard.custom_values
904 ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
905 SET redmine_dashboard.__issue_customfield.issue_type = redmine_dashboard.custom_values.`value`
906 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-35' OR redmine_dashboard.custom_values.custom_field_id = 'eg-2';
907
908 UPDATE redmine_dashboard.__issue_customfield
909 INNER JOIN redmine_dashboard.custom_values
910 ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
911 SET redmine_dashboard.__issue_customfield.critical_path = redmine_dashboard.custom_values.`value`
912 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-37' OR redmine_dashboard.custom_values.custom_field_id = 'eg-3';
913
914 UPDATE redmine_dashboard.__issue_customfield
915 INNER JOIN redmine_dashboard.custom_values
916 ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
917 SET redmine_dashboard.__issue_customfield.approved_task = redmine_dashboard.custom_values.`value`
918 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-45' OR redmine_dashboard.custom_values.custom_field_id = 'eg-30';
919
920 UPDATE redmine_dashboard.__issue_customfield
921 INNER JOIN redmine_dashboard.custom_values
922 ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
923 SET redmine_dashboard.__issue_customfield.deviation_reason = redmine_dashboard.custom_values.`value`
924 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-47' OR redmine_dashboard.custom_values.custom_field_id = 'eg-32';
925
926 UPDATE redmine_dashboard.__issue_customfield
927 INNER JOIN redmine_dashboard.custom_values
928 ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
929 SET redmine_dashboard.__issue_customfield.issue_job_title = redmine_dashboard.custom_values.`value`
930 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-49' OR redmine_dashboard.custom_values.custom_field_id = 'eg-34';
931
932 UPDATE redmine_dashboard.__issue_customfield
933 INNER JOIN redmine_dashboard.custom_values
934 ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
935 SET redmine_dashboard.__issue_customfield.issue_seniorty_level = redmine_dashboard.custom_values.`value`
936 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-50' OR redmine_dashboard.custom_values.custom_field_id = 'eg-35';
937
938 UPDATE redmine_dashboard.__issue_customfield
939 INNER JOIN redmine_dashboard.custom_values
940 ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
941 SET redmine_dashboard.__issue_customfield.product_code = redmine_dashboard.custom_values.`value`
942 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-51' OR redmine_dashboard.custom_values.custom_field_id = 'eg-36';
943
944 UPDATE redmine_dashboard.__issue_customfield
945 INNER JOIN redmine_dashboard.custom_values
946 ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
947 SET redmine_dashboard.__issue_customfield.product_man_days = redmine_dashboard.custom_values.`value`
948 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-52' OR redmine_dashboard.custom_values.custom_field_id = 'eg-37';
949
950 -- GRAPPING PROEJCTS CUSTOM VALUES AND CUSTOM FIELD VALUES...
951 UPDATE redmine_dashboard.__project_customfield
952 INNER JOIN redmine_dashboard.custom_values
953 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
954 SET redmine_dashboard.__project_customfield.business_unit = redmine_dashboard.custom_values.`value`
955 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-8' OR redmine_dashboard.custom_values.custom_field_id = 'eg-5';
956
957 UPDATE redmine_dashboard.__project_customfield
958 INNER JOIN redmine_dashboard.custom_values
959 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
960 SET redmine_dashboard.__project_customfield.contract_name = redmine_dashboard.custom_values.`value`
961 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-9' OR redmine_dashboard.custom_values.custom_field_id = 'eg-6';
962
963 UPDATE redmine_dashboard.__project_customfield
964 INNER JOIN redmine_dashboard.custom_values
965 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
966 SET redmine_dashboard.__project_customfield.project_code = redmine_dashboard.custom_values.`value`
967 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-10' OR redmine_dashboard.custom_values.custom_field_id = 'eg-7';
968
969 UPDATE redmine_dashboard.__project_customfield
970 INNER JOIN redmine_dashboard.custom_values
971 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
972 SET redmine_dashboard.__project_customfield.project_name = redmine_dashboard.custom_values.`value`
973 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-11' OR redmine_dashboard.custom_values.custom_field_id = 'eg-8';
974
975 UPDATE redmine_dashboard.__project_customfield
976 INNER JOIN redmine_dashboard.custom_values
977 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
978 SET redmine_dashboard.__project_customfield.start_date = redmine_dashboard.custom_values.`value`
979 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-12' OR redmine_dashboard.custom_values.custom_field_id = 'eg-9';
980
981 UPDATE redmine_dashboard.__project_customfield
982 INNER JOIN redmine_dashboard.custom_values
983 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
984 SET redmine_dashboard.__project_customfield.project_manager = redmine_dashboard.custom_values.`value`
985 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-13' OR redmine_dashboard.custom_values.custom_field_id = 'eg-10';
986
987 UPDATE redmine_dashboard.__project_customfield
988 INNER JOIN redmine_dashboard.custom_values
989 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
990 SET redmine_dashboard.__project_customfield.phase = redmine_dashboard.custom_values.`value`
991 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-14' OR redmine_dashboard.custom_values.custom_field_id = 'eg-11';
992
993 UPDATE redmine_dashboard.__project_customfield
994 INNER JOIN redmine_dashboard.custom_values
995 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
996 SET redmine_dashboard.__project_customfield.general_status = redmine_dashboard.custom_values.`value`
997 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-15' OR redmine_dashboard.custom_values.custom_field_id = 'eg-12';
998
999 UPDATE redmine_dashboard.__project_customfield
1000 INNER JOIN redmine_dashboard.custom_values
1001 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1002 SET redmine_dashboard.__project_customfield.cost_centre = redmine_dashboard.custom_values.`value`
1003 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-17' OR redmine_dashboard.custom_values.custom_field_id = 'eg-13';
1004
1005 UPDATE redmine_dashboard.__project_customfield
1006 INNER JOIN redmine_dashboard.custom_values
1007 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1008 SET redmine_dashboard.__project_customfield.location = redmine_dashboard.custom_values.`value`
1009 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-18' OR redmine_dashboard.custom_values.custom_field_id = 'eg-14';
1010
1011 UPDATE redmine_dashboard.__project_customfield
1012 INNER JOIN redmine_dashboard.custom_values
1013 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1014 SET redmine_dashboard.__project_customfield.deliverables = redmine_dashboard.custom_values.`value`
1015 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-20' OR redmine_dashboard.custom_values.custom_field_id = 'eg-15';
1016
1017 UPDATE redmine_dashboard.__project_customfield
1018 INNER JOIN redmine_dashboard.custom_values
1019 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1020 SET redmine_dashboard.__project_customfield.notes = redmine_dashboard.custom_values.`value`
1021 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-21' OR redmine_dashboard.custom_values.custom_field_id = 'eg-17';
1022
1023 UPDATE redmine_dashboard.__project_customfield
1024 INNER JOIN redmine_dashboard.custom_values
1025 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1026 SET redmine_dashboard.__project_customfield.`completion` = redmine_dashboard.custom_values.`value`
1027 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-22' OR redmine_dashboard.custom_values.custom_field_id = 'eg-16';
1028
1029 UPDATE redmine_dashboard.__project_customfield
1030 INNER JOIN redmine_dashboard.custom_values
1031 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1032 SET redmine_dashboard.__project_customfield.allocation_type = redmine_dashboard.custom_values.`value`
1033 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-27' OR redmine_dashboard.custom_values.custom_field_id = 'eg-18';
1034
1035 UPDATE redmine_dashboard.__project_customfield
1036 INNER JOIN redmine_dashboard.custom_values
1037 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1038 SET redmine_dashboard.__project_customfield.end_date = redmine_dashboard.custom_values.`value`
1039 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-31' OR redmine_dashboard.custom_values.custom_field_id = 'eg-19';
1040
1041 UPDATE redmine_dashboard.__project_customfield
1042 INNER JOIN redmine_dashboard.custom_values
1043 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1044 SET redmine_dashboard.__project_customfield.customer = redmine_dashboard.custom_values.`value`
1045 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-38' OR redmine_dashboard.custom_values.custom_field_id = 'eg-20';
1046
1047 UPDATE redmine_dashboard.__project_customfield
1048 INNER JOIN redmine_dashboard.custom_values
1049 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1050 SET redmine_dashboard.__project_customfield.top_project = redmine_dashboard.custom_values.`value`
1051 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-43' OR redmine_dashboard.custom_values.custom_field_id = 'eg-21';
1052
1053 UPDATE redmine_dashboard.__project_customfield
1054 INNER JOIN redmine_dashboard.custom_values
1055 ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1056 SET redmine_dashboard.__project_customfield.project_entity = redmine_dashboard.custom_values.`value`
1057 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-48' OR redmine_dashboard.custom_values.custom_field_id = 'eg-33';
1058
1059 -- GRAPPING USERS CUSTOM VALUES AND CUSTOM FIELD VALUES...
1060 UPDATE redmine_dashboard.__user_customfield
1061 INNER JOIN redmine_dashboard.custom_values
1062 ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1063 SET redmine_dashboard.__user_customfield.department = redmine_dashboard.custom_values.`value`
1064 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-23' OR redmine_dashboard.custom_values.custom_field_id = 'eg-22';
1065
1066 UPDATE redmine_dashboard.__user_customfield
1067 INNER JOIN redmine_dashboard.custom_values
1068 ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1069 SET redmine_dashboard.__user_customfield.country = redmine_dashboard.custom_values.`value`
1070 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-24' OR redmine_dashboard.custom_values.custom_field_id = 'eg-23';
1071
1072 UPDATE redmine_dashboard.__user_customfield
1073 INNER JOIN redmine_dashboard.custom_values
1074 ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1075 SET redmine_dashboard.__user_customfield.job_title = redmine_dashboard.custom_values.`value`
1076 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-25' OR redmine_dashboard.custom_values.custom_field_id = 'eg-24';
1077
1078 UPDATE redmine_dashboard.__user_customfield
1079 INNER JOIN redmine_dashboard.custom_values
1080 ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1081 SET redmine_dashboard.__user_customfield.employment_status = redmine_dashboard.custom_values.`value`
1082 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-28' OR redmine_dashboard.custom_values.custom_field_id = 'eg-25';
1083
1084 UPDATE redmine_dashboard.__user_customfield
1085 INNER JOIN redmine_dashboard.custom_values
1086 ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1087 SET redmine_dashboard.__user_customfield.employee_level = redmine_dashboard.custom_values.`value`
1088 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-39' OR redmine_dashboard.custom_values.custom_field_id = 'eg-26';
1089
1090 UPDATE redmine_dashboard.__user_customfield
1091 INNER JOIN redmine_dashboard.custom_values
1092 ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1093 SET redmine_dashboard.__user_customfield.employee_id = redmine_dashboard.custom_values.`value`
1094 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-40' OR redmine_dashboard.custom_values.custom_field_id = 'eg-27';
1095
1096 UPDATE redmine_dashboard.__user_customfield
1097 INNER JOIN redmine_dashboard.custom_values
1098 ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1099 SET redmine_dashboard.__user_customfield.entity = redmine_dashboard.custom_values.`value`
1100 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-41' OR redmine_dashboard.custom_values.custom_field_id = 'eg-28';
1101
1102 UPDATE redmine_dashboard.__user_customfield
1103 INNER JOIN redmine_dashboard.custom_values
1104 ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1105 SET redmine_dashboard.__user_customfield.employee_category = redmine_dashboard.custom_values.`value`
1106 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-53';
1107
1108 -- GRAPPING TIME ENTRIES CUSTOM VALUES AND CUSTOM FIELD VALUES...
1109 UPDATE redmine_dashboard.__timeentry_customfield
1110 INNER JOIN redmine_dashboard.custom_values
1111 ON redmine_dashboard.__timeentry_customfield.time_entry_id = redmine_dashboard.custom_values.customized_id
1112 SET redmine_dashboard.__timeentry_customfield.idle_time_type = redmine_dashboard.custom_values.`value`
1113 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-44' OR redmine_dashboard.custom_values.custom_field_id = 'eg-29';
1114
1115 UPDATE redmine_dashboard.__timeentry_customfield
1116 INNER JOIN redmine_dashboard.custom_values
1117 ON redmine_dashboard.__timeentry_customfield.time_entry_id = redmine_dashboard.custom_values.customized_id
1118 SET redmine_dashboard.__timeentry_customfield.overtime = redmine_dashboard.custom_values.`value`
1119 WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-46' OR redmine_dashboard.custom_values.custom_field_id = 'eg-31';