/*
-- campaign.sql


-- SQL File to load campaign data into the data base.

-- Programmed by Snehavadan Macwan

-- Last Update:		10 July 	1996, VERSION 1.0

-- ===========================================================================

*/
-- This SQL script file loads a set of campaign data into the SoHO Online Data
-- Catalog.  Currently only data for the Instiutes and Campaign tables is
-- loaded.  Before data for any table is inserted, all the data in the 
-- database is cleared.  This will ensure that after this script file
-- is run the database contains a known data set.

-- Delete all rows in the database

DELETE FROM COMMENT_INSTITUTES ;

DELETE FROM INSTITUTES ;

DELETE FROM COMMENT_CAMPAIGN ;

DELETE FROM CAMPAIGN ;

-- DELETE FROM COMMENT_EVENTS ; 

-- DELETE FROM EVENTS ;

-- Add rows to the Campaign Database

-- Add campaign number 0 into campaign table.
INSERT INTO campaign 	
         (cmp_no,
          cmp_name,
          cmp_type,
          cmp_desc,
          date_obs,
          date_end,
          observer,
          comments,
          date_mod,
          time_mod)
       VALUES
         (
          -- Campaign Number 
          0,
          -- Campaign Name
          'Null Campaign',
          -- Campaign Type
          'No Campaign Type',
          -- Campaign Description
          'This campaign defines the NULL campaign',
          -- Starting date of campaign
          '1996/01/01',
          -- Ending date of campaign
          NULL,
          -- Observer in charge
          'J. Len Culhane',
          -- Comments available
          'N',
          -- Date record was last updated
          '1996/01/01',
          -- Time record was last updated
          to_char(sysdate, 'HH:MI:SS.SS')
         )
       ;

-- Add campaign number 1 into campaign table.
INSERT INTO campaign 	
         (cmp_no,
          cmp_name,
          cmp_type,
          cmp_desc,
          date_obs,
          date_end,
          observer,
          comments,
          date_mod,
          time_mod)
       VALUES
         (
          -- Campaign Number 
          1,
          -- Campaign Name
          'Prominence Observing Program',
          -- Campaign Type
          'JOP 012',
          -- Campaign Description
          'To test the programme, to determine T, density and v as a ' ||
	  'function of time in prominences and surrounding. To check the ' ||
	  'Siphon model of Poland and Mariska.',
          -- Starting date of campaign
          '1996/05/01',
          -- Ending date of campaign
          '1996/05/01',
          -- Observer in charge
          'Kucera/Schmieder',
          -- Comments available
          'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_campaign table for campaign number 1
INSERT INTO comment_campaign
	(cmp_no,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  1,
	  -- Comment Number
	  1,
	  -- Comments
	  'Observations from 07:00 - 12:00 UT. ' ||
	  'Large extended prominence which leads to a CME observed by LASCO '||
	  '(G. Simnett, private communication).',          	
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 1
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  1,
	  -- Institution Index
	  1,
	  -- Institution
	  'SoHO/SUMER',
	  -- Observer in Charge
	  'Terry Kucera',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add campaign number 2 into campaign table.
INSERT INTO campaign 	
         (cmp_no,
          cmp_name,
          cmp_type,
          cmp_desc,
          date_obs,
          date_end,
          observer,
          comments,
          date_mod,
          time_mod)
       VALUES
         (
          -- Campaign Number 
          2,
          -- Campaign Name
          'Prominence Observing Program',
          -- Campaign Type
          'JOP 012',
          -- Campaign Description
          'To test the programme, to determine T, density and v as a ' ||
	  'function of time in prominences and surrounding. To check the ' ||
	  'Siphon model of Poland and Mariska.',
          -- Starting date of campaign
          '1996/05/03',
          -- Ending date of campaign
          '1996/05/03',
          -- Observer in charge
          'Terry Kucera/Brigitte Schmieder',
          -- Comments available
          'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_campaign table for campaign number 2
INSERT INTO comment_campaign
	(cmp_no,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  2,
	  -- Comment Number
	  1,
	  -- Comments
	  'Observations from 07:00 - 12:00 UT. ',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 2
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  2,
	  -- Institution Index
	  1,
	  -- Institution
	  'SoHO/SUMER',
	  -- Observer in Charge
	  'Terry Kucera',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add campaign number 3 into campaign table.
INSERT INTO campaign 	
         (cmp_no,
          cmp_name,
          cmp_type,
          cmp_desc,
          date_obs,
          date_end,
          observer,
          comments,
          date_mod,
          time_mod)
       VALUES
         (
          -- Campaign Number 
          3,
          -- Campaign Name
          'Prominence Observing Program',
          -- Campaign Type
          'JOP 012',
          -- Campaign Description
          'To determine T, density and v as a function of time in ' ||
	  'prominences and surrounding. To check the Siphon model of ' ||
	  'Poland and Mariska.',
          -- Starting date of campaign
          '1996/06/03',
          -- Ending date of campaign
          '1996/06/09',
          -- Observer in charge
          'Brigitte Schmieder',
          -- Comments available
          'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_campaign table for campaign number 3
INSERT INTO comment_campaign
	(cmp_no,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  3,
	  -- Comment Number
	  1,
	  -- Comments
	  'Daily observations from 08:00 - 13:00 UT.', 
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_campaign table for campaign number 3
INSERT INTO comment_campaign
	(cmp_no,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  3,
	  -- Comment Number
	  2,
	  -- Comments
	  'It is difficult to forcast the presence of a prominence 24 hours '||
	  'before. Due to that we observed small prominences on June 5 and 6.',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 3
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  3,
	  -- Institution Index
	  1,
	  -- Institution
	  'SoHO/SUMER',
	  -- Observer in Charge
	  'Terry Kucera',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 3
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  3,
	  -- Institution Index
	  2,
	  -- Institution
	  'SoHO/CDS',
	  -- Observer in Charge
	  'Bill Thompson and Terry Kucera',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 3
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  3,
	  -- Institution Index
	  3,
	  -- Institution
	  'Pic du Midi',
	  -- Observer in Charge
	  'B. Schmieder, J. M. Malherbe, and T. Roudier',
	  -- Comments
	  'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_institutes table for campaign number 3
INSERT INTO comment_institutes
	(cmp_no,
	 inst_ind,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  3,
	  -- Institution Index
	  3,
	  -- Comment Number
	  1,
	  -- Comments
	  'Pic du Midi: snowed out on June 3, good weather during the ' ||
	  'campaign with excellent seeing 2 days.',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_institutes table for campaign number 3
INSERT INTO comment_institutes
	(cmp_no,
	 inst_ind,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  3,
	  -- Institution Index
	  3,
	  -- Comment Number
	  2,
	  -- Comments
	  'Instruments: IR and Halpha coros (J. C. Noens) and Telescope ' ||
	  'Tourelle + MSDP.',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 3
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  3,
	  -- Institution Index
	  4,
	  -- Institution
	  'Wroclav',
	  -- Observer in Charge
	  'B. Rompolt',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 3
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  3,
	  -- Institution Index
	  5,
	  -- Institution
	  'Debrecen',
	  -- Observer in Charge
	  'Kalman',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 3
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  3,
	  -- Institution Index
	  6,
	  -- Institution
	  'Izmiran',
	  -- Observer in Charge
	  'Iospha',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 3
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  3,
	  -- Institution Index
	  7,
	  -- Institution
	  'Ondrejov',
	  -- Observer in Charge
	  'Heinzel',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 3
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  3,
	  -- Institution Index
	  8,
	  -- Institution
	  'Crimea',
	  -- Observer in Charge
	  'Stepanian',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 3
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  3,
	  -- Institution Index
	  9,
	  -- Institution
	  'Yohkoh',
	  -- Observer in Charge
	  'Max Weber and H. Hudson',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add campaign number 4 into campaign table.
INSERT INTO campaign 	
         (cmp_no,
          cmp_name,
          cmp_type,
          cmp_desc,
          date_obs,
          date_end,
          observer,
          comments,
          date_mod,
          time_mod)
       VALUES
         (
          -- Campaign Number 
          4,
          -- Campaign Name
          'Quiescent filament or Polar Crown filament',
          -- Campaign Type
          'JOP 017',
          -- Campaign Description
          'To study the dynamics of the transition region of a filament ' ||
	  'using Si IV lines and chromospheric line to coalign with ' ||
	  'Halpha filament.',
          -- Starting date of campaign
          '1996/05/07',
          -- Ending date of campaign
          '1996/05/07',
          -- Observer in charge
          'Brigitte Schmieder',
          -- Comments available
          'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_campaign table for campaign number 4
INSERT INTO comment_campaign
	(cmp_no,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  4,
	  -- Comment Number
	  1,
	  -- Comments
	  'Daily observations from 08:00 - 12:30 UT.', 
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 4
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  4,
	  -- Institution Index
	  1,
	  -- Institution
	  'SoHO/SUMER',
	  -- Observer in Charge
	  'Terry Kucera',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add campaign number 5 into campaign table.
INSERT INTO campaign 	
         (cmp_no,
          cmp_name,
          cmp_type,
          cmp_desc,
          date_obs,
          date_end,
          observer,
          comments,
          date_mod,
          time_mod)
       VALUES
         (
          -- Campaign Number 
          5,
          -- Campaign Name
          'Quiescent filament or Polar Crown filament',
          -- Campaign Type
          'JOP 017',
          -- Campaign Description
          'To study the dynamics of the transition region of a filament ' ||
	  'using Si IV lines and chromospheric line to coalign with ' ||
	  'Halpha filament.',
          -- Starting date of campaign
          '1996/05/16',
          -- Ending date of campaign
          '1996/05/16',
          -- Observer in charge
          'Brigitte Schmieder',
          -- Comments available
          'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_campaign table for campaign number 5
INSERT INTO comment_campaign
	(cmp_no,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  5,
	  -- Comment Number
	  1,
	  -- Comments
	  'Daily observations from 07:00 - 10:00 UT.', 
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 5
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  5,
	  -- Institution Index
	  1,
	  -- Institution
	  'SoHO/SUMER',
	  -- Observer in Charge
	  'Terry Kucera',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add campaign number 6 into campaign table.
INSERT INTO campaign 	
         (cmp_no,
          cmp_name,
          cmp_type,
          cmp_desc,
          date_obs,
          date_end,
          observer,
          comments,
          date_mod,
          time_mod)
       VALUES
         (
          -- Campaign Number 
          6,
          -- Campaign Name
          'Quiescent filament or Polar Crown filament',
          -- Campaign Type
          'JOP 017',
          -- Campaign Description
          'To study the dynamics of the transition region of a filament ' ||
	  'using Si IV lines or O IV and a chromospheric line to ' ||
	  'coalign with Halpha filament.',
          -- Starting date of campaign
          '1996/06/03',
          -- Ending date of campaign
          '1996/06/09',
          -- Observer in charge
          'Brigitte Schmieder',
          -- Comments available
          'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_campaign table for campaign number 6
INSERT INTO comment_campaign
	(cmp_no,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  6,
	  -- Comment Number
	  1,
	  -- Comments
	  'Daily observations from 06:00 - 08:00 UT.', 
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_campaign table for campaign number 6
INSERT INTO comment_campaign
	(cmp_no,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  6,
	  -- Comment Number
	  2,
	  -- Comments
	  'A long N/S filament has been followed from June 6-9 (E40to W9).',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 6
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  6,
	  -- Institution Index
	  1,
	  -- Institution
	  'SoHO/SUMER',
	  -- Observer in Charge
	  'Terry Kucera',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 6
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  6,
	  -- Institution Index
	  2,
	  -- Institution
	  'SoHO/CDS',
	  -- Observer in Charge
	  'Bill Thompson and Terry Kucera',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 6
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  6,
	  -- Institution Index
	  3,
	  -- Institution
	  'Pic du Midi',
	  -- Observer in Charge
	  'B. Schmieder, J. M. Malherbe, and T. Roudier',
	  -- Comments
	  'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_institutes table for campaign number 6
INSERT INTO comment_institutes
	(cmp_no,
	 inst_ind,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  6,
	  -- Institution Index
	  3,
	  -- Comment Number
	  1,
	  -- Comments
	  'Pic du Midi: snowed out on June 3, good weather during the ' ||
	  'campaign with excellent seeing 2 days.',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_institutes table for campaign number 6
INSERT INTO comment_institutes
	(cmp_no,
	 inst_ind,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  6,
	  -- Institution Index
	  3,
	  -- Comment Number
	  2,
	  -- Comments
	  'Instruments: IR and Halpha coros (J. C. Noens) and Telescope ' ||
	  'Tourelle + MSDP.',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 6
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  6,
	  -- Institution Index
	  4,
	  -- Institution
	  'Wroclav',
	  -- Observer in Charge
	  'B. Rompolt',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 6
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  6,
	  -- Institution Index
	  5,
	  -- Institution
	  'Debrecen',
	  -- Observer in Charge
	  'Kalman',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 6
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  6,
	  -- Institution Index
	  6,
	  -- Institution
	  'Izmiran',
	  -- Observer in Charge
	  'Iospha',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 6
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  6,
	  -- Institution Index
	  7,
	  -- Institution
	  'Ondrejov',
	  -- Observer in Charge
	  'Heinzel',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 6
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  6,
	  -- Institution Index
	  8,
	  -- Institution
	  'Crimea',
	  -- Observer in Charge
	  'Stepanian',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 6
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  6,
	  -- Institution Index
	  9,
	  -- Institution
	  'Yohkoh',
	  -- Observer in Charge
	  'Max Weber and H. Hudson',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add campaign number 7 into campaign table.
INSERT INTO campaign 	
         (cmp_no,
          cmp_name,
          cmp_type,
          cmp_desc,
          date_obs,
          date_end,
          observer,
          comments,
          date_mod,
          time_mod)
       VALUES
         (
          -- Campaign Number 
          7,
          -- Campaign Name
          'VLA-SoHO coordinated observations',
          -- Campaign Type
          'Small Campaign',
          -- Campaign Description
          '(1) Sunspot gyroresonance stereoscopy ' ||
	  '(2) Temperature and density structure of active regions ' ||
	  '(3) Temperature and density structure of quite corona',
          -- Starting date of campaign
          '1996/05/23',
          -- Ending date of campaign
          '1996/05/26',
          -- Observer in charge
          'Markus Aschwanden (UMd) markus@astro.umd.edu',
          -- Comments available
          'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_campaign table for campaign number 7
INSERT INTO comment_campaign
	(cmp_no,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  7,
	  -- Comment Number
	  1,
	  -- Comments
	  'Except 05/25, daily onservations over 10 hours (15-01 UT).',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;


-- Add rows in comment_campaign table for campaign number 7
INSERT INTO comment_campaign
	(cmp_no,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  7,
	  -- Comment Number
	  2,
	  -- Comments
	  'Because the Sun was absolutely quiet (no sunspots, no active ' ||
	  'regions), the scientific objective (3) was pursued.',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 7
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  7,
	  -- Institution Index
	  1,
	  -- Institution
	  'SoHO/SUMER',
	  -- Observer in Charge
	  'Stu Jordan',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 7
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  7,
	  -- Institution Index
	  2,
	  -- Institution
	  'SoHO/CDS',
	  -- Observer in Charge
	  'Paal Brekke',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 7
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  7,
	  -- Institution Index
	  3,
	  -- Institution
	  'SoHO/EIT',
	  -- Observer in Charge
	  'Jeff Newmark and Barbara Thompson',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 7
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  7,
	  -- Institution Index
	  4,
	  -- Institution
	  'VLA',
	  -- Observer in Charge
	  'Tim Bastian',
	  -- Comments
	  'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_institutes table for campaign number 7
INSERT INTO comment_institutes
	(cmp_no,
	 inst_ind,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  7,
	  -- Institution Index
	  4,
	  -- Comment Number
	  1,
	  -- Comments
	  'Multifrequency operation at VLA, pointings to solar N and W limb.',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 7
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  7,
	  -- Institution Index
	  5,
	  -- Institution
	  'OVRO',
	  -- Observer in Charge
	  'Dale Gary',
	  -- Comments
	  'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_institutes table for campaign number 7
INSERT INTO comment_institutes
	(cmp_no,
	 inst_ind,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  7,
	  -- Institution Index
	  5,
	  -- Comment Number
	  1,
	  -- Comments
	  'Multifrequency operation at OVRO, pointings to solar N and W limb.',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 7
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  7,
	  -- Institution Index
	  6,
	  -- Institution
	  'Yohkoh',
	  -- Observer in Charge
	  'Nariaki Nitta',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 7
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  7,
	  -- Institution Index
	  7,
	  -- Institution
	  'KPNO',
	  -- Observer in Charge
	  'Karen Harvey and Matt Penn',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add campaign number 8 into campaign table.
INSERT INTO campaign 	
         (cmp_no,
          cmp_name,
          cmp_type,
          cmp_desc,
          date_obs,
          date_end,
          observer,
          comments,
          date_mod,
          time_mod)
       VALUES
         (
          -- Campaign Number 
          8,
          -- Campaign Name
          'Mini Campaign',
          -- Campaign Type
          'JOP 045',
          -- Campaign Description
          'Structure and dynamics of Transient Brightenings and their ' ||
	  'Relation to Magnetic Field Geometry.',
          -- Starting date of campaign
          '1996/06/06',
          -- Ending date of campaign
          '1996/06/06',
          -- Observer in charge
          'George Fisher',
          -- Comments available
          'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_campaign table for campaign number 8
INSERT INTO comment_campaign
	(cmp_no,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  8,
	  -- Comment Number
	  1,
	  -- Comments
	  'Bright Active Region observed at disk center from roughly ' ||
	  '17:00 to 19:00 UT.',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 8
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  8,
	  -- Institution Index
	  1,
	  -- Institution
	  'SoHO/SUMER',
	  -- Observer in Charge
	  'Terry Kucera',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 8
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  8,
	  -- Institution Index
	  2,
	  -- Institution
	  'SoHO/CDS',
	  -- Observer in Charge
	  'Dominic Zarro',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 8
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  8,
	  -- Institution Index
	  3,
	  -- Institution
	  'IVM at Mees Solar Observatory, Hawaii',
	  -- Observer in Charge
	  'Metcalf, Jiao',
	  -- Comments
	  'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;


-- Add rows in comment_institutes table for campaign number 8
INSERT INTO comment_institutes
	(cmp_no,
	 inst_ind,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  8,
	  -- Institution Index
	  3,
	  -- Comment Number
	  1,
	  -- Comments
	  'Observing conditions clear at Mees.',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 8
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  8,
	  -- Institution Index
	  4,
	  -- Institution
	  'Yohkoh SXT',
	  -- Observer in Charge
	  'Lemen and Hudson',
	  -- Comments
	  'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_institutes table for campaign number 8
INSERT INTO comment_institutes
	(cmp_no,
	 inst_ind,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  8,
	  -- Institution Index
	  4,
	  -- Comment Number
	  1,
	  -- Comments
	  'SXT observations from Yohkoh obtained with high time cedence for '||
	  'roughly 40 minutes.',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;


-- Add rows in institutes table for campaign number 8
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  8,
	  -- Institution Index
	  5,
	  -- Institution
	  'NSO-Kitt Peak',
	  -- Observer in Charge
	  'K. Harvey, Penn',
	  -- Comments
	  'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_institutes table for campaign number 8
INSERT INTO comment_institutes
	(cmp_no,
	 inst_ind,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  8,
	  -- Institution Index
	  5,
	  -- Comment Number
	  1,
	  -- Comments
	  'Observing conditions clear at Kitt Peak.',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add campaign number 9 into campaign table.
INSERT INTO campaign 	
         (cmp_no,
          cmp_name,
          cmp_type,
          cmp_desc,
          date_obs,
          date_end,
          observer,
          comments,
          date_mod,
          time_mod)
       VALUES
         (
          -- Campaign Number 
          9,
          -- Campaign Name
          'Filling Factors of Hot Coronal Loops',
          -- Campaign Type
          'Campaign',
          -- Campaign Description
          'To determine the filling factors of hot (> 1 MK) coronal loops. ' ||
	  'Such filling factors are important for understanding coronal ' ||
	  'heating. A secondary objective is to evaluate the meaning of ' ||
	  'filter ratio temperatures measured by the SXT on Yohkoh, given ' ||
	  'that the observed plasma is unlikely to be isothermal along the '||
	  'line-of-sight.',
          -- Starting date of campaign
          '1996/05/13',
          -- Ending date of campaign
          '1996/05/16',
          -- Observer in charge
          'James A. Klimchuk',
          -- Comments available
          'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_campaign table for campaign number 9
INSERT INTO comment_campaign
	(cmp_no,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  9,
	  -- Comment Number
	  1,
	  -- Comments
	  'An active region complex was observed on the disk and at the ' ||
	  'limb. The data seem adequate for the filling factor measurements.',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 9
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  9,
	  -- Institution Index
	  1,
	  -- Institution
	  'SoHO/SUMER',
	  -- Observer in Charge
	  'Klaus Wilhelm, John Mariska',
	  -- Comments
	  'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_institutes table for campaign number 9
INSERT INTO comment_institutes
	(cmp_no,
	 inst_ind,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  9,
	  -- Institution Index
	  1,
	  -- Comment Number
	  1,
	  -- Comments
	  'Both CDS and SUMER observed on the 13th and 14th.',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;


-- Add rows in institutes table for campaign number 9
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  9,
	  -- Institution Index
	  2,
	  -- Institution
	  'SoHO/CDS',
	  -- Observer in Charge
	  'Richard Harrison, Andrzej Fludra',
	  -- Comments
	  'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_institutes table for campaign number 9
INSERT INTO comment_institutes
	(cmp_no,
	 inst_ind,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  9,
	  -- Institution Index
	  2,
	  -- Comment Number
	  1,
	  -- Comments
	  'Both CDS and SUMER observed on the 13th and 14th. Only CDS ' ||
	  ' observed on the 16th. The CDS observations ' ||
	  'from the 14th were interrupted and not completed.',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 9
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  9,
	  -- Institution Index
	  3,
	  -- Institution
	  'Yohkoh/SXT',
	  -- Observer in Charge
	  'Serge Savy, Hugh Hudson',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add campaign number 10 into campaign table.
INSERT INTO campaign 	
         (cmp_no,
          cmp_name,
          cmp_type,
          cmp_desc,
          date_obs,
          date_end,
          observer,
          comments,
          date_mod,
          time_mod)
       VALUES
         (
          -- Campaign Number 
          10,
          -- Campaign Name
          'The Signature of Ca II K Grains in the Transition Region and ' ||
	  'Corona',
          -- Campaign Type
          'JOP 026',
          -- Campaign Description
          'Study of the Ca K grain phenomenon and its impact on the ' ||
	  'higher atmospheric layers by coordinated observations of the ' ||
	  'Ca II K line from ground and selected UV lines from SUMER, ' ||
	  'CDS, and EIT.',
          -- Starting date of campaign
          '1996/06/14',
          -- Ending date of campaign
          '1996/06/25',
          -- Observer in charge
          'Bernhard Fleck',
          -- Comments available
          'Y',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in comment_campaign table for campaign number 10
INSERT INTO comment_campaign
	(cmp_no,
	 comm_no,
	 comment_text,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  10,
	  -- Comment Number
	  1,
	  -- Comments
	  'Date		Tenerife		Seeing	SUMER	CDS	EIT
	   14 June	Ca K Filter		2-5	C+A	x	-  
	   15 June	Ca K, H-a, Mgb2	Filter	2-5	B+D	x	-
	   16 June	Ca K, H-a, Mgb2	Filter	2-4	C+A	x	-
	   17 June	      -			clouds	B+D	x	-
	   18 June	Ca K, H-a, Mgb2 Filter 	2-3	C+E	x	He 304
	   No observations June 19 - 21.
	   22 June	Ca K + Mgb2 Spectra	2-3	-	x	He 304
   	   23 June	Ca  K + Mgb2 +  Filter	1-3	-	x	He 304
	   24 June      Ca  K + Mgb2 +  Filter  2-4	C+A	x	-
	   25 June	Ca  K + Mgb2 +  Filter 	3-4	B+D	x	He 304',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 10
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  10,
	  -- Institution Index
	  1,
	  -- Institution
	  'VTT Tenerife',
	  -- Observer in Charge
	  'Sebastian Steffens, Franz-Ludwig Deubner',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 10
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  10,
	  -- Institution Index
	  2,
	  -- Institution
	  'SoHO/SUMER',
	  -- Observer in Charge
	  'Klaus Wilhelm',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 10
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  10,
	  -- Institution Index
	  3,
	  -- Institution
	  'SoHO/CDS',
	  -- Observer in Charge
	  'Richard Harrison',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;

-- Add rows in institutes table for campaign number 10
INSERT INTO institutes
	(cmp_no,
	 inst_ind,
	 institut,
	 observer,
	 comments,
	 date_mod,
	 time_mod)
       VALUES
	 (
	  -- Campaign Number
	  10,
	  -- Institution Index
	  4,
	  -- Institution
	  'SoHO/EIT',
	  -- Observer in Charge
	  'Joe Gurman',
	  -- Comments
	  'N',
          -- Date record was last updated
          to_char(sysdate, 'YYYY/MM/DD'),
          -- Time record was last updated
          to_char(sysdate, 'HH:MM:SS')
         )
       ;


-- Commit Database Update
COMMIT ;
