WEB LISTING 3: Script to Populate Table 1

INSERT INTO project_activity_schedule  
( activity_code, activity_description, planned_start_date, parent_activity_code )
VALUES ( 'A1','Site Clearance - clearing of trees, garbage etc.','2000-06-20', NULL )

INSERT INTO project_activity_schedule  
( activity_code, activity_description, planned_start_date, parent_activity_code )
VALUES ( 'A2','Excavation for foundation','2000-06-23', NULL )

INSERT INTO project_activity_schedule  
( activity_code, activity_description, planned_start_date, parent_activity_code )
VALUES ( 'A2.1','Arrangement of 25 unskilled labours','2000-06-23','A2' )

INSERT INTO project_activity_schedule  
( activity_code, activity_description, planned_start_date, parent_activity_code )
VALUES ( 'A2.2','Arrangement of machinery','2000-06-23','A2' )

INSERT INTO project_activity_schedule  
( activity_code, activity_description, planned_start_date, parent_activity_code )
VALUES ( 'A2.3','Excavation upto 25m*25m*1m','2000-06-24','A2' )

INSERT INTO project_activity_schedule  
( activity_code, activity_description, planned_start_date, parent_activity_code )
VALUES ( 'A3','Laying of foundation','2000-06-30',NULL )

INSERT INTO project_activity_schedule  
( activity_code, activity_description, planned_start_date, parent_activity_code )
VALUES ( 'A3.1','Foundation activity 1','2000-06-30','A3' )

INSERT INTO project_activity_schedule  
( activity_code, activity_description, planned_start_date, parent_activity_code )
VALUES ( 'A3.2','Foundation activity 2','2000-07-07','A3' )