hGNgQqRA

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