 --     INSTEAD, DATA MANUALLY LOADED FROM CSV USING ADMINER
 --     ON SERVER, THEN EXPORTED AS SQL INSERT AND COPIED BELOW
 --
--- LOAD DATA INFILE '/home/maestro/scc/csv/activity_resource_assignment.csv'
--- INTO TABLE maestro.tbl_activity_resource_assignment
--- CHARACTER SET ascii
--- FIELDS
--- 	TERMINATED BY ','
--- 	OPTIONALLY ENCLOSED BY '"'
--- 	ESCAPED BY '"'
--- LINES
--- 	TERMINATED BY '\r\n'
--- IGNORE 1 LINES
--- (activity_id,resource_id);
-
-INSERT INTO `tbl_activity_resource_assignment` (`activity_id`, `resource_id`) VALUES
-(1,	3),
-(3,	3),
-(7,	3),
-(7,	5),
-(1,	6),
-(3,	6),
-(5,	6),
-(7,	6),
-(7,	7),
-(1,	11),
-(5,	14),
-(7,	14),
-(9,	14),
-(5,	18),
-(7,	18),
-(9,	18),
-(5,	19),
-(2,	20),
-(4,	20),
-(5,	20),
-(6,	20),
-(8,	20),
-(9,	20),
-(10,	20),
-(1,	22),
-(3,	23),
-(5,	23),
-(7,	23),
-(9,	23);
-
+LOAD DATA INFILE '/home/maestro/scc/csv/activity_resource_assignment.csv'
+INTO TABLE maestro.tbl_activity_resource_assignment
+CHARACTER SET ascii
+FIELDS
+	TERMINATED BY ','
+	OPTIONALLY ENCLOSED BY '"'
+	ESCAPED BY '"'
+LINES
+	TERMINATED BY '\r\n'
+IGNORE 1 LINES
+(activity_id,resource_id);
+
+-- INSERT INTO `tbl_activity_resource_assignment` (`activity_id`, `resource_id`) VALUES
+-- (1,	3),
+-- (3,	3),
+-- (7,	3),
+-- (7,	5),
+-- (1,	6),
+-- (3,	6),
+-- (5,	6),
+-- (7,	6),
+-- (7,	7),
+-- (1,	11),
+-- (5,	14),
+-- (7,	14),
+-- (9,	14),
+-- (5,	18),
+-- (7,	18),
+-- (9,	18),
+-- (5,	19),
+-- (2,	20),
+-- (4,	20),
+-- (5,	20),
+-- (6,	20),
+-- (8,	20),
+-- (9,	20),
+-- (10,	20),
+-- (1,	22),
+-- (3,	23),
+-- (5,	23),
+-- (7,	23),
+-- (9,	23);
 
 -- activity_stock_assignment (GanttProject -> csv -> project.ods -> csv)
 -- Windows EOL

--     INSTEAD, DATA MANUALLY LOADED FROM CSV USING ADMINER
--     ON SERVER, THEN EXPORTED AS SQL INSERT AND COPIED BELOW
--
-- LOAD DATA INFILE '/home/maestro/scc/csv/activity_predecessor_assignment.csv'
-- INTO TABLE maestro.tbl_activity_predecessor_assignment
-- CHARACTER SET ascii
-- FIELDS
-- 	TERMINATED BY ','
-- 	OPTIONALLY ENCLOSED BY '"'
-- 	ESCAPED BY '"'
-- LINES
-- 	TERMINATED BY '\r\n'
-- IGNORE 1 LINES
-- (activity_id,predecessor_id);

INSERT INTO `tbl_activity_predecessor_assignment` (`activity_id`, `predecessor_id`) VALUES
(2,	1),
(3,	1),
(4,	3),
(5,	3),
(6,	5),
(7,	5),
(8,	7),
(9,	7),
(10,	9);

-- activity_resource_assignment (GanttProject -> csv -> project.ods -> csv)
-- Windows EOL

--     INSTEAD, DATA MANUALLY LOADED FROM CSV USING ADMINER
--     ON SERVER, THEN EXPORTED AS SQL INSERT AND COPIED BELOW
--
LOAD DATA INFILE '/home/maestro/scc/csv/activity.csv'
INTO TABLE maestro.tbl_activity
CHARACTER SET ascii
FIELDS
	TERMINATED BY ','
	OPTIONALLY ENCLOSED BY '"'
	ESCAPED BY '"'
LINES
	TERMINATED BY '\r\n'
IGNORE 1 LINES
(id,name,begin_date,end_date,duration,completion,outline_number,cost,web_link,notes,coordinator_id,project_id,create_time,create_user_id,update_time,update_user_id);

-- INSERT INTO `tbl_activity` (`id`, `name`, `begin_date`, `end_date`, `duration`, `completion`, `outline_number`, `cost`, `web_link`, `notes`, `coordinator_id`, `project_id`, `create_time`, `create_user_id`, `update_time`, `update_user_id`) VALUES
-- (1,	'prototype 1',	'2015-01-01 00:00:00',	'2015-01-28 00:00:00',	20,	100,	'1.1',	280,	NULL,	'Release of PN 20000004 Rev 00 Parts List with child parts and assemblies for building a small number of prototype units. Assembly includes an earphone, wire for a stubby antenna and preliminary user manual, but no enclosure. Manufacturing process document',	6,	1,	'2015-01-01 00:00:00',	6,	'2015-01-01 00:00:00',	6),
-- (2,	'design gate 1',	'2015-01-29 00:00:00',	'2015-01-29 00:00:00',	0,	0,	'1.2',	0,	NULL,	NULL,	20,	1,	'2015-01-01 00:00:00',	6,	'2015-01-01 00:00:00',	6),
-- (3,	'prototype 2',	'2015-01-29 00:00:00',	'2015-02-25 00:00:00',	20,	20,	'1.3',	280,	NULL,	'Revise electrical schematic to correct connectivity of PCB-type inductor, revise PCB design to correct inductor layout, and generate new PCB CAM files. Correct mechanical dimensions of the PCB, create Master Drawing for the PCB, create assembly drawing an',	6,	1,	'2015-01-01 00:00:00',	6,	'2015-01-01 00:00:00',	6),
-- (4,	'design gate 2',	'2015-02-26 00:00:00',	'2015-02-26 00:00:00',	0,	0,	'1.4',	0,	NULL,	NULL,	20,	1,	'2015-01-01 00:00:00',	6,	'2015-01-01 00:00:00',	6),
-- (5,	'product release',	'2015-02-26 00:00:00',	'2015-03-25 00:00:00',	20,	0,	'1.5',	490,	NULL,	'Restructuring of parts lists for product release, including creation of a new top-level marketing assembly part number. An enclosure with hardware was added, the manual and earphone were moved to the marketing assembly, and the stubby antenna was removed ',	6,	1,	'2015-01-01 00:00:00',	6,	'2015-01-01 00:00:00',	6),
-- (6,	'mfg gate 1',	'2015-03-26 00:00:00',	'2015-03-26 00:00:00',	0,	0,	'1.6',	0,	NULL,	NULL,	20,	1,	'2015-01-01 00:00:00',	6,	'2015-01-01 00:00:00',	6),
-- (7,	'cost/quality improvements',	'2015-03-26 00:00:00',	'2015-04-22 00:00:00',	20,	0,	'1.7',	630,	NULL,	'Circuit board orientation in enclosure was inverted to aid assembly and test (mounted PCA component-side-up in enclosure changed to copper-side-up, allowing direct access to circuit board components and off-board wiring while mounted in the enclosure). Lo',	18,	1,	'2015-01-01 00:00:00',	6,	'2015-01-01 00:00:00',	6),
-- (8,	'mfg gate 2',	'2015-04-23 00:00:00',	'2015-04-23 00:00:00',	0,	0,	'1.8',	0,	NULL,	NULL,	20,	1,	'2015-01-01 00:00:00',	6,	'2015-01-01 00:00:00',	6),
-- (9,	'field service kit',	'2015-04-23 00:00:00',	'2015-05-20 00:00:00',	20,	0,	'1.9',	160,	NULL,	'A kit of parts useful for field service was released. The service kit and contents was created in response to requests from field service technicians to provide more effective and efficient field service.',	14,	1,	'2015-01-01 00:00:00',	6,	'2015-01-01 00:00:00',	6),
-- (10,	'mfg gate 3',	'2015-05-21 00:00:00',	'2015-05-21 00:00:00',	0,	0,	'1.1',	0,	NULL,	NULL,	20,	1,	'2015-01-01 00:00:00',	6,	'2015-01-01 00:00:00',	6);

-- activity_part_assignment (GanttProject -> csv -> project.ods -> csv)
-- Windows EOL
