Srz9bxqY

1-- DELETE GENERATED DATABASE...
2DROP DATABASE IF EXISTS `redmine_dashboard`;
3
4-- CREATE NEW DATABASE...
5CREATE DATABASE `redmine_dashboard`
6CHARACTER SET utf8
7COLLATE utf8_unicode_ci;
8
9-- MAKE SURE THAT ALL DATABASE DELETED INCLUDED SHERODINGER'S TABLES IF EXISS...
10DROP TABLE IF EXISTS `redmine_dashboard`.custom_field_enumerations;
11DROP TABLE IF EXISTS `redmine_dashboard`.custom_fields;
12DROP TABLE IF EXISTS `redmine_dashboard`.custom_fields_projects;
13DROP TABLE IF EXISTS `redmine_dashboard`.custom_fields_roles;
14DROP TABLE IF EXISTS `redmine_dashboard`.custom_fields_trackers;
15DROP TABLE IF EXISTS `redmine_dashboard`.custom_values;
16DROP TABLE IF EXISTS `redmine_dashboard`.enabled_modules;
17DROP TABLE IF EXISTS `redmine_dashboard`.enumerations;
18DROP TABLE IF EXISTS `redmine_dashboard`.issue_categories;
19DROP TABLE IF EXISTS `redmine_dashboard`.issue_relations;
20DROP TABLE IF EXISTS `redmine_dashboard`.issue_statuses;
21DROP TABLE IF EXISTS `redmine_dashboard`.issues;
22DROP TABLE IF EXISTS `redmine_dashboard`.journal_details;
23DROP TABLE IF EXISTS `redmine_dashboard`.journals;
24DROP TABLE IF EXISTS `redmine_dashboard`.projects;
25DROP TABLE IF EXISTS `redmine_dashboard`.projects_trackers;
26DROP TABLE IF EXISTS `redmine_dashboard`.time_logs;
27DROP TABLE IF EXISTS `redmine_dashboard`.trackers;
28DROP TABLE IF EXISTS `redmine_dashboard`.users;
29DROP TABLE IF EXISTS `redmine_dashboard`.watchers;
30DROP TABLE IF EXISTS `redmine_dashboard`.workflows;
31DROP TABLE IF EXISTS `redmine_dashboard`.__issue_customfield;
32DROP TABLE IF EXISTS `redmine_dashboard`.__project_customfield;
33DROP TABLE IF EXISTS `redmine_dashboard`.__timeentry_customfield;
34DROP 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...
39CREATE 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
49CREATE 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
77CREATE 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
84CREATE 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
91CREATE 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
98CREATE 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
109CREATE 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
117CREATE 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
132CREATE 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
142CREATE 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
154CREATE 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
165CREATE 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` float 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
203CREATE 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
214CREATE 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
229CREATE 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
249CREATE 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
257CREATE 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` float 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
279CREATE 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
290CREATE 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
301CREATE 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
340CREATE 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
351CREATE 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
369CREATE 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` varchar(500) DEFAULT NULL,
377  `deviation_reason` varchar(255) 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` float(50,0) DEFAULT NULL
382);
383
384CREATE 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` varchar(255) DEFAULT NULL,
398  `completion` varchar(50) DEFAULT NULL,
399  `allocation_type` varchar(100) DEFAULT NULL,
400  `end_date` date DEFAULT NULL,
401  `customer` varchar(75) DEFAULT NULL,
402  `top_project` tinyint(1) DEFAULT NULL,
403  `project_entity` varchar(100) DEFAULT NULL
404);
405
406CREATE TABLE `redmine_dashboard`.__timeentry_customfield (
407  `time_entry_id` varchar(20) NOT NULL,
408  `idle_time_type` varchar(100) DEFAULT NULL,
409  `overtime` tinyint(1) DEFAULT NULL
410);
411
412CREATE 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...
426ALTER TABLE `redmine_dashboard`.enumerations
427ADD INDEX(`parent_id`);
428
429ALTER TABLE `redmine_dashboard`.issues
430ADD INDEX(`id`);
431
432ALTER TABLE `redmine_dashboard`.issues
433ADD INDEX(`parent_id`);
434
435ALTER TABLE `redmine_dashboard`.issue_relations
436ADD INDEX(`id`);
437
438ALTER TABLE `redmine_dashboard`.issue_statuses
439ADD INDEX(`id`);
440
441ALTER TABLE `redmine_dashboard`.journals
442ADD INDEX(`id`);
443
444ALTER TABLE `redmine_dashboard`.journal_details
445ADD INDEX(`id`);
446
447ALTER TABLE `redmine_dashboard`.projects
448ADD INDEX(`id`);
449
450ALTER TABLE `redmine_dashboard`.projects
451ADD INDEX(`parent_id`);
452
453ALTER TABLE `redmine_dashboard`.time_entries
454ADD INDEX(`id`);
455
456ALTER TABLE `redmine_dashboard`.time_logs
457ADD INDEX(`id`);
458
459ALTER TABLE `redmine_dashboard`.trackers
460ADD INDEX(`id`);
461
462ALTER TABLE `redmine_dashboard`.trackers
463ADD INDEX(`name`);
464
465ALTER TABLE `redmine_dashboard`.users
466ADD INDEX(`id`);
467
468ALTER TABLE `redmine_dashboard`.watchers
469ADD INDEX(`id`);
470
471ALTER TABLE `redmine_dashboard`.workflows
472ADD INDEX(`id`);
473
474ALTER TABLE `redmine_dashboard`.__issue_customfield
475ADD INDEX(`issue_id`);
476
477ALTER TABLE `redmine_dashboard`.__project_customfield
478ADD INDEX(`project_id`);
479
480ALTER TABLE `redmine_dashboard`.__timeentry_customfield
481ADD INDEX(`time_entry_id`);
482
483ALTER TABLE `redmine_dashboard`.__user_customfield
484ADD INDEX(`user_id`);
485
486
487-- MERGING IN ACTION(1/4)!!!...
488-- START OF JORDAN DATABASE...
489INSERT INTO redmine_dashboard.projects
490SELECT 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'
491FROM `redmine_jo`.projects;
492
493UPDATE `redmine_dashboard`.projects 
494SET parent_id = NULL 
495WHERE parent_id = 'jo-';
496
497UPDATE `redmine_dashboard`.projects
498SET status = 'Active'
499WHERE status = '1';
500
501UPDATE `redmine_dashboard`.projects
502SET status = 'Closed'
503WHERE status = '5';
504
505-- END OF THIS TABLE
506
507INSERT INTO redmine_dashboard.custom_fields
508SELECT 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' 
509FROM `redmine_jo`.custom_fields;
510
511-- END OF THIS TABLE
512
513INSERT INTO redmine_dashboard.custom_fields_projects
514SELECT 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'
515FROM `redmine_jo`.custom_fields_projects;
516
517-- END OF THIS TABLE
518
519INSERT INTO redmine_dashboard.custom_fields_roles
520SELECT 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'
521FROM `redmine_jo`.custom_fields_roles;
522
523-- END OF THIS TABLE
524
525INSERT INTO redmine_dashboard.custom_fields_trackers
526SELECT 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'
527FROM `redmine_jo`.custom_fields_trackers;
528
529-- END OF THIS TABLE
530
531INSERT INTO redmine_dashboard.custom_field_enumerations
532SELECT 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'
533FROM `redmine_jo`.custom_field_enumerations;
534
535-- END OF THIS TABLE
536
537INSERT INTO redmine_dashboard.custom_values
538SELECT 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'
539FROM `redmine_jo`.custom_values;
540
541-- END OF THIS TABLE
542
543INSERT INTO redmine_dashboard.enabled_modules
544SELECT 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'
545FROM `redmine_jo`.enabled_modules;
546
547-- END OF THIS TABLE
548
549INSERT INTO redmine_dashboard.issues
550SELECT 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'
551FROM `redmine_jo`.issues;
552
553UPDATE `redmine_dashboard`.issues
554SET tracker_id = NULL
555WHERE tracker_id = 'jo-';
556
557UPDATE `redmine_dashboard`.issues
558SET project_id = NULL
559WHERE project_id = 'jo-';
560
561UPDATE `redmine_dashboard`.issues
562SET author_id = NULL
563WHERE author_id = 'jo-';
564
565UPDATE `redmine_dashboard`.issues
566SET parent_id = NULL
567WHERE parent_id = 'jo-';
568
569UPDATE `redmine_dashboard`.issues
570SET root_id = NULL
571WHERE root_id = 'jo-';
572
573-- END OF THIS TABLE
574
575INSERT INTO redmine_dashboard.issue_relations
576SELECT 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'
577FROM `redmine_jo`.issue_relations;
578
579-- END OF THIS TABLE
580
581INSERT INTO redmine_dashboard.issue_statuses
582SELECT 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'
583FROM `redmine_jo`.issue_statuses;
584
585-- END OF THIS TABLE
586
587INSERT INTO redmine_dashboard.journals
588SELECT 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'
589FROM `redmine_jo`.journals;
590
591-- END OF THIS TABLE
592
593INSERT INTO redmine_dashboard.journal_details
594SELECT 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'
595FROM `redmine_jo`.journal_details;
596
597-- END OF THIS TABLE
598
599INSERT INTO redmine_dashboard.projects_trackers
600SELECT 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'
601FROM `redmine_jo`.projects_trackers;
602
603-- END OF THIS TABLE
604
605INSERT INTO redmine_dashboard.time_entries
606SELECT 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'
607FROM `redmine_jo`.time_entries;
608
609UPDATE `redmine_dashboard`.time_entries
610SET project_id = NULL
611WHERE project_id = 'jo-';
612
613UPDATE `redmine_dashboard`.time_entries
614SET user_id = NULL
615WHERE user_id = 'jo-';
616
617UPDATE `redmine_dashboard`.time_entries
618SET issue_id = NULL
619WHERE issue_id = 'jo-';
620
621UPDATE `redmine_dashboard`.time_entries
622SET activity_id = NULL
623WHERE activity_id = 'jo-';
624
625-- END OF THIS TABLE
626
627INSERT INTO redmine_dashboard.time_logs
628SELECT 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'
629FROM `redmine_jo`.time_logs;
630
631UPDATE `redmine_dashboard`.time_logs
632SET user_id = NULL
633WHERE user_id = 'jo-';
634
635UPDATE `redmine_dashboard`.time_logs
636SET project_id = NULL
637WHERE project_id = 'jo-';
638
639-- END OF THIS TABLE
640
641INSERT INTO redmine_dashboard.trackers
642SELECT 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'
643FROM `redmine_jo`.trackers;
644
645-- END OF THIS TABLE
646
647INSERT INTO redmine_dashboard.users
648SELECT 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'
649FROM `redmine_jo`.users;
650
651-- END OF THIS TABLE
652
653INSERT INTO redmine_dashboard.watchers
654SELECT 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'
655FROM `redmine_jo`.watchers;
656
657-- END OF THIS TABLE
658
659INSERT INTO redmine_dashboard.workflows
660SELECT 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'
661FROM `redmine_jo`.workflows;
662
663-- END OF THIS TABLE
664
665INSERT INTO redmine_dashboard.issue_categories
666SELECT 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'
667FROM `redmine_jo`.issue_categories;
668
669-- END OF THIS TABLE
670
671INSERT INTO redmine_dashboard.enumerations
672SELECT 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'
673FROM `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
680INSERT INTO redmine_dashboard.projects
681SELECT 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' 
682FROM `redmine_eg`.projects;
683
684UPDATE `redmine_dashboard`.projects
685SET parent_id = NULL
686WHERE parent_id = 'eg-';
687
688
689UPDATE `redmine_dashboard`.projects
690SET status = 'Active'
691WHERE status = '1';
692
693UPDATE `redmine_dashboard`.projects
694SET status = 'Closed'
695WHERE status = '5';
696
697-- END OF THIS TABLE
698
699INSERT INTO redmine_dashboard.custom_fields
700SELECT 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' 
701FROM `redmine_eg`.custom_fields;
702
703-- END OF THIS TABLE
704
705INSERT INTO redmine_dashboard.custom_fields_projects
706SELECT 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' 
707FROM `redmine_eg`.custom_fields_projects;
708
709-- END OF THIS TABLE
710
711INSERT INTO redmine_dashboard.custom_fields_roles
712SELECT 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' 
713FROM `redmine_eg`.custom_fields_roles;
714
715-- END OF THIS TABLE
716
717INSERT INTO redmine_dashboard.custom_fields_trackers
718SELECT 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' 
719FROM `redmine_eg`.custom_fields_trackers;
720
721-- END OF THIS TABLE
722
723INSERT INTO redmine_dashboard.custom_field_enumerations
724SELECT 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' 
725FROM `redmine_eg`.custom_field_enumerations;
726
727-- END OF THIS TABLE
728
729INSERT INTO redmine_dashboard.custom_values
730SELECT 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' 
731FROM `redmine_eg`.custom_values;
732
733-- END OF THIS TABLE
734
735INSERT INTO redmine_dashboard.enabled_modules 
736SELECT 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' 
737FROM `redmine_eg`.enabled_modules;
738
739-- END OF THIS TABLE
740
741INSERT INTO redmine_dashboard.issues
742SELECT 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' 
743FROM `redmine_eg`.issues;
744
745UPDATE `redmine_dashboard`.issues
746SET tracker_id = NULL
747WHERE tracker_id = 'eg-';
748
749UPDATE `redmine_dashboard`.issues
750SET project_id = NULL
751WHERE project_id = 'eg-';
752
753UPDATE `redmine_dashboard`.issues
754SET author_id = NULL
755WHERE author_id = 'eg-';
756
757UPDATE `redmine_dashboard`.issues
758SET parent_id = NULL
759WHERE parent_id = 'eg-';
760
761UPDATE `redmine_dashboard`.issues
762SET root_id = NULL
763WHERE root_id = 'eg-';
764
765-- END OF THIS TABLE
766
767INSERT INTO redmine_dashboard.issue_relations
768SELECT 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' 
769FROM `redmine_eg`.issue_relations;
770
771-- END OF THIS TABLE
772
773INSERT INTO redmine_dashboard.issue_statuses
774SELECT 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' 
775FROM `redmine_eg`.issue_statuses;
776
777-- END OF THIS TABLE
778
779INSERT INTO redmine_dashboard.journals
780SELECT 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' 
781FROM `redmine_eg`.journals;
782
783-- END OF THIS TABLE
784
785INSERT INTO redmine_dashboard.journal_details
786SELECT 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' 
787FROM `redmine_eg`.journal_details;
788
789-- END OF THIS TABLE
790
791INSERT INTO redmine_dashboard.projects_trackers 
792SELECT 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' 
793FROM `redmine_eg`.projects_trackers;
794
795-- END OF THIS TABLE
796
797INSERT INTO redmine_dashboard.time_entries
798SELECT 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' 
799FROM `redmine_eg`.time_entries;
800
801UPDATE `redmine_dashboard`.time_entries
802SET project_id = NULL
803WHERE project_id = 'eg-';
804
805UPDATE `redmine_dashboard`.time_entries
806SET user_id = NULL
807WHERE user_id = 'eg-';
808
809UPDATE `redmine_dashboard`.time_entries
810SET issue_id = NULL
811WHERE issue_id = 'eg-';
812
813UPDATE `redmine_dashboard`.time_entries
814SET activity_id = NULL
815WHERE activity_id = 'eg-';
816
817-- END OF THIS TABLE
818
819INSERT INTO redmine_dashboard.trackers
820SELECT 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' 
821FROM `redmine_eg`.trackers;
822
823-- END OF THIS TABLE
824
825INSERT INTO redmine_dashboard.users
826SELECT 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' 
827FROM `redmine_eg`.users;
828
829-- END OF THIS TABLE
830
831INSERT INTO redmine_dashboard.watchers
832SELECT 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' 
833FROM `redmine_eg`.watchers;
834
835-- END OF THIS TABLE
836
837INSERT INTO redmine_dashboard.workflows
838SELECT 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' 
839FROM `redmine_eg`.workflows;
840
841-- END OF THIS TABLE
842
843INSERT INTO redmine_dashboard.issue_categories
844SELECT 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'
845FROM `redmine_eg`.issue_categories;
846
847-- END OF THIS TABLE
848
849INSERT INTO redmine_dashboard.enumerations
850SELECT 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'
851FROM `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...
857INSERT INTO redmine_dashboard.__issue_customfield
858SELECT redmine_dashboard.issues.id, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
859FROM redmine_dashboard.issues;
860
861INSERT INTO redmine_dashboard.__project_customfield
862SELECT redmine_dashboard.projects.id, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
863FROM redmine_dashboard.projects;
864
865INSERT INTO redmine_dashboard.__timeentry_customfield
866SELECT redmine_dashboard.time_entries.id, NULL, NULL
867FROM redmine_dashboard.time_entries;
868
869INSERT INTO redmine_dashboard.__user_customfield
870SELECT redmine_dashboard.users.id, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
871FROM redmine_dashboard.users;
872
873-- FOURTH PART OF MERGING(4/4)...
874-- GRAPPING ISSUES CUSTOM VALUES AND CUSTOM FIELD VALUES...
875UPDATE redmine_dashboard.__issue_customfield
876INNER JOIN redmine_dashboard.custom_values
877ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
878SET redmine_dashboard.__issue_customfield.educational_QC = redmine_dashboard.custom_values.`value`
879WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-4';
880
881UPDATE redmine_dashboard.__issue_customfield
882INNER JOIN redmine_dashboard.custom_values
883ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
884SET redmine_dashboard.__issue_customfield.storyboard_document_link = redmine_dashboard.custom_values.`value`
885WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-5';
886
887UPDATE redmine_dashboard.__issue_customfield
888INNER JOIN redmine_dashboard.custom_values
889ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
890SET redmine_dashboard.__issue_customfield.`user` = redmine_dashboard.custom_values.`value`
891WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-7' OR redmine_dashboard.custom_values.custom_field_id = 'eg-1';
892
893UPDATE redmine_dashboard.__issue_customfield
894INNER JOIN redmine_dashboard.custom_values
895ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
896SET redmine_dashboard.__issue_customfield.issue_type = redmine_dashboard.custom_values.`value`
897WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-35' OR redmine_dashboard.custom_values.custom_field_id = 'eg-2';
898
899UPDATE redmine_dashboard.__issue_customfield
900INNER JOIN redmine_dashboard.custom_values
901ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
902SET redmine_dashboard.__issue_customfield.critical_path = redmine_dashboard.custom_values.`value`
903WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-37' OR redmine_dashboard.custom_values.custom_field_id = 'eg-3';
904
905UPDATE redmine_dashboard.__issue_customfield
906INNER JOIN redmine_dashboard.custom_values
907ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
908SET redmine_dashboard.__issue_customfield.approved_task = redmine_dashboard.custom_values.`value`
909WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-45' OR redmine_dashboard.custom_values.custom_field_id = 'eg-30';
910
911UPDATE redmine_dashboard.__issue_customfield
912INNER JOIN redmine_dashboard.custom_values
913ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
914SET redmine_dashboard.__issue_customfield.deviation_reason = redmine_dashboard.custom_values.`value`
915WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-47' OR redmine_dashboard.custom_values.custom_field_id = 'eg-32';
916
917UPDATE redmine_dashboard.__issue_customfield
918INNER JOIN redmine_dashboard.custom_values
919ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
920SET redmine_dashboard.__issue_customfield.issue_job_title = redmine_dashboard.custom_values.`value`
921WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-49' OR redmine_dashboard.custom_values.custom_field_id = 'eg-34';
922
923UPDATE redmine_dashboard.__issue_customfield
924INNER JOIN redmine_dashboard.custom_values
925ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
926SET redmine_dashboard.__issue_customfield.issue_seniorty_level = redmine_dashboard.custom_values.`value`
927WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-50' OR redmine_dashboard.custom_values.custom_field_id = 'eg-35';
928
929UPDATE redmine_dashboard.__issue_customfield
930INNER JOIN redmine_dashboard.custom_values
931ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
932SET redmine_dashboard.__issue_customfield.product_code = redmine_dashboard.custom_values.`value`
933WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-51' OR redmine_dashboard.custom_values.custom_field_id = 'eg-36';
934
935UPDATE redmine_dashboard.__issue_customfield
936INNER JOIN redmine_dashboard.custom_values
937ON redmine_dashboard.__issue_customfield.issue_id = redmine_dashboard.custom_values.customized_id
938SET redmine_dashboard.__issue_customfield.product_man_days = redmine_dashboard.custom_values.`value`
939WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-52' OR redmine_dashboard.custom_values.custom_field_id = 'eg-37';
940
941-- GRAPPING PROEJCTS CUSTOM VALUES AND CUSTOM FIELD VALUES...
942UPDATE redmine_dashboard.__project_customfield
943INNER JOIN redmine_dashboard.custom_values
944ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
945SET redmine_dashboard.__project_customfield.business_unit = redmine_dashboard.custom_values.`value`
946WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-8' OR redmine_dashboard.custom_values.custom_field_id = 'eg-5';
947
948UPDATE redmine_dashboard.__project_customfield
949INNER JOIN redmine_dashboard.custom_values
950ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
951SET redmine_dashboard.__project_customfield.contract_name = redmine_dashboard.custom_values.`value`
952WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-9' OR redmine_dashboard.custom_values.custom_field_id = 'eg-6';
953
954UPDATE redmine_dashboard.__project_customfield
955INNER JOIN redmine_dashboard.custom_values
956ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
957SET redmine_dashboard.__project_customfield.project_code = redmine_dashboard.custom_values.`value`
958WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-10' OR redmine_dashboard.custom_values.custom_field_id = 'eg-7';
959
960UPDATE redmine_dashboard.__project_customfield
961INNER JOIN redmine_dashboard.custom_values
962ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
963SET redmine_dashboard.__project_customfield.project_name = redmine_dashboard.custom_values.`value`
964WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-11' OR redmine_dashboard.custom_values.custom_field_id = 'eg-8';
965
966UPDATE redmine_dashboard.__project_customfield
967INNER JOIN redmine_dashboard.custom_values
968ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
969SET redmine_dashboard.__project_customfield.start_date = redmine_dashboard.custom_values.`value`
970WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-12' OR redmine_dashboard.custom_values.custom_field_id = 'eg-9';
971
972UPDATE redmine_dashboard.__project_customfield
973INNER JOIN redmine_dashboard.custom_values
974ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
975SET redmine_dashboard.__project_customfield.project_manager = redmine_dashboard.custom_values.`value`
976WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-13' OR redmine_dashboard.custom_values.custom_field_id = 'eg-10';
977
978UPDATE redmine_dashboard.__project_customfield
979INNER JOIN redmine_dashboard.custom_values
980ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
981SET redmine_dashboard.__project_customfield.phase = redmine_dashboard.custom_values.`value`
982WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-14' OR redmine_dashboard.custom_values.custom_field_id = 'eg-11';
983
984UPDATE redmine_dashboard.__project_customfield
985INNER JOIN redmine_dashboard.custom_values
986ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
987SET redmine_dashboard.__project_customfield.general_status = redmine_dashboard.custom_values.`value`
988WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-15' OR redmine_dashboard.custom_values.custom_field_id = 'eg-12';
989
990UPDATE redmine_dashboard.__project_customfield
991INNER JOIN redmine_dashboard.custom_values
992ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
993SET redmine_dashboard.__project_customfield.cost_centre = redmine_dashboard.custom_values.`value`
994WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-17' OR redmine_dashboard.custom_values.custom_field_id = 'eg-13';
995
996UPDATE redmine_dashboard.__project_customfield
997INNER JOIN redmine_dashboard.custom_values
998ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
999SET redmine_dashboard.__project_customfield.location = redmine_dashboard.custom_values.`value`
1000WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-18' OR redmine_dashboard.custom_values.custom_field_id = 'eg-14';
1001
1002UPDATE redmine_dashboard.__project_customfield
1003INNER JOIN redmine_dashboard.custom_values
1004ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1005SET redmine_dashboard.__project_customfield.deliverables = redmine_dashboard.custom_values.`value`
1006WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-20' OR redmine_dashboard.custom_values.custom_field_id = 'eg-15';
1007
1008UPDATE redmine_dashboard.__project_customfield
1009INNER JOIN redmine_dashboard.custom_values
1010ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1011SET redmine_dashboard.__project_customfield.notes = redmine_dashboard.custom_values.`value`
1012WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-21' OR redmine_dashboard.custom_values.custom_field_id = 'eg-17';
1013
1014UPDATE redmine_dashboard.__project_customfield
1015INNER JOIN redmine_dashboard.custom_values
1016ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1017SET redmine_dashboard.__project_customfield.`completion` = redmine_dashboard.custom_values.`value`
1018WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-22' OR redmine_dashboard.custom_values.custom_field_id = 'eg-16';
1019
1020UPDATE redmine_dashboard.__project_customfield
1021INNER JOIN redmine_dashboard.custom_values
1022ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1023SET redmine_dashboard.__project_customfield.allocation_type = redmine_dashboard.custom_values.`value`
1024WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-27' OR redmine_dashboard.custom_values.custom_field_id = 'eg-18';
1025
1026UPDATE redmine_dashboard.__project_customfield
1027INNER JOIN redmine_dashboard.custom_values
1028ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1029SET redmine_dashboard.__project_customfield.end_date = redmine_dashboard.custom_values.`value`
1030WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-31' OR redmine_dashboard.custom_values.custom_field_id = 'eg-19';
1031
1032UPDATE redmine_dashboard.__project_customfield
1033INNER JOIN redmine_dashboard.custom_values
1034ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1035SET redmine_dashboard.__project_customfield.customer = redmine_dashboard.custom_values.`value`
1036WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-38' OR redmine_dashboard.custom_values.custom_field_id = 'eg-20';
1037
1038UPDATE redmine_dashboard.__project_customfield
1039INNER JOIN redmine_dashboard.custom_values
1040ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1041SET redmine_dashboard.__project_customfield.top_project = redmine_dashboard.custom_values.`value`
1042WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-43' OR redmine_dashboard.custom_values.custom_field_id = 'eg-21';
1043
1044UPDATE redmine_dashboard.__project_customfield
1045INNER JOIN redmine_dashboard.custom_values
1046ON redmine_dashboard.__project_customfield.project_id = redmine_dashboard.custom_values.customized_id
1047SET redmine_dashboard.__project_customfield.project_entity = redmine_dashboard.custom_values.`value`
1048WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-48' OR redmine_dashboard.custom_values.custom_field_id = 'eg-33';
1049
1050-- GRAPPING USERS CUSTOM VALUES AND CUSTOM FIELD VALUES...
1051UPDATE redmine_dashboard.__user_customfield
1052INNER JOIN redmine_dashboard.custom_values
1053ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1054SET redmine_dashboard.__user_customfield.department = redmine_dashboard.custom_values.`value`
1055WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-23' OR redmine_dashboard.custom_values.custom_field_id = 'eg-22';
1056
1057UPDATE redmine_dashboard.__user_customfield
1058INNER JOIN redmine_dashboard.custom_values
1059ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1060SET redmine_dashboard.__user_customfield.country = redmine_dashboard.custom_values.`value`
1061WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-24' OR redmine_dashboard.custom_values.custom_field_id = 'eg-23';
1062
1063UPDATE redmine_dashboard.__user_customfield
1064INNER JOIN redmine_dashboard.custom_values
1065ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1066SET redmine_dashboard.__user_customfield.job_title = redmine_dashboard.custom_values.`value`
1067WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-25' OR redmine_dashboard.custom_values.custom_field_id = 'eg-24';
1068
1069UPDATE redmine_dashboard.__user_customfield
1070INNER JOIN redmine_dashboard.custom_values
1071ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1072SET redmine_dashboard.__user_customfield.employment_status = redmine_dashboard.custom_values.`value`
1073WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-28' OR redmine_dashboard.custom_values.custom_field_id = 'eg-25';
1074
1075UPDATE redmine_dashboard.__user_customfield
1076INNER JOIN redmine_dashboard.custom_values
1077ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1078SET redmine_dashboard.__user_customfield.employee_level = redmine_dashboard.custom_values.`value`
1079WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-39' OR redmine_dashboard.custom_values.custom_field_id = 'eg-26';
1080
1081UPDATE redmine_dashboard.__user_customfield
1082INNER JOIN redmine_dashboard.custom_values
1083ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1084SET redmine_dashboard.__user_customfield.employee_id = redmine_dashboard.custom_values.`value`
1085WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-40' OR redmine_dashboard.custom_values.custom_field_id = 'eg-27';
1086
1087UPDATE redmine_dashboard.__user_customfield
1088INNER JOIN redmine_dashboard.custom_values
1089ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1090SET redmine_dashboard.__user_customfield.entity = redmine_dashboard.custom_values.`value`
1091WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-41' OR redmine_dashboard.custom_values.custom_field_id = 'eg-28';
1092
1093UPDATE redmine_dashboard.__user_customfield
1094INNER JOIN redmine_dashboard.custom_values
1095ON redmine_dashboard.__user_customfield.user_id = redmine_dashboard.custom_values.customized_id
1096SET redmine_dashboard.__user_customfield.employee_category = redmine_dashboard.custom_values.`value`
1097WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-53';
1098
1099-- GRAPPING TIME ENTRIES CUSTOM VALUES AND CUSTOM FIELD VALUES...
1100UPDATE redmine_dashboard.__timeentry_customfield
1101INNER JOIN redmine_dashboard.custom_values
1102ON redmine_dashboard.__timeentry_customfield.time_entry_id = redmine_dashboard.custom_values.customized_id
1103SET redmine_dashboard.__timeentry_customfield.idle_time_type = redmine_dashboard.custom_values.`value`
1104WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-44' OR redmine_dashboard.custom_values.custom_field_id = 'eg-29';
1105
1106UPDATE redmine_dashboard.__timeentry_customfield
1107INNER JOIN redmine_dashboard.custom_values
1108ON redmine_dashboard.__timeentry_customfield.time_entry_id = redmine_dashboard.custom_values.customized_id
1109SET redmine_dashboard.__timeentry_customfield.overtime = redmine_dashboard.custom_values.`value`
1110WHERE redmine_dashboard.custom_values.custom_field_id = 'jo-46' OR redmine_dashboard.custom_values.custom_field_id = 'eg-31';