	----------------------------------------------------------------------
--  Purpose:  Insert an initial data set into the table MATERIAL_TYPES
--
--  Authors: Randy Ramin-Wright (CRW)
--
--  Change History:
--
--  Date          Author       Description
--  21-May-2007   CRW          First Draft
--
-----------------------------------------------------------------------

insert into material_types
(id
,code
,description)
values 
(nextval('MATERIAL_TYPE_ID_SEQ')
,'VIRUS'
,'Virus'
);

insert into material_types
(id
,code
,description)
values 
(nextval('MATERIAL_TYPE_ID_SEQ')
,'CELLLINE'
,'Cell Line or Cell Culture. The growing of cells under controlled conditions.'
);

insert into material_types
(id
,code
,description)
values 
(nextval('MATERIAL_TYPE_ID_SEQ')
,'CELLNUCL'
,'Cell Nucleus'
);

insert into material_types
(id
,code
,description)
values 
(nextval('MATERIAL_TYPE_ID_SEQ')
,'GENE'
,'Gene'
);
insert into material_types
(id
,code
,description)
values 
(nextval('MATERIAL_TYPE_ID_SEQ')
,'OLIGO'
,'Oligo nucleotide'
);
insert into material_types
(id
,code
,description)
values 
(nextval('MATERIAL_TYPE_ID_SEQ')
,'CONTROL'
,'Control of a control layout'
);

----------------------------------------------------------------------
--  Purpose:  Insert an initial data set into the table MATERIALS
--
--  Authors: Randy Ramin-Wright (CRW)
--
--  Change History:
--
--  Date          Author       Description
--  21-May-2007   CRW          First Draft
--  20-Jun-2007   CRW          Added the virus list received from Berend
-----------------------------------------------------------------------

insert into materials
(  id
  ,code
  ,maty_id
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'SV40'
,1
,'Simian Virus 40'
);

insert into materials
(  id
  ,code
  ,maty_id
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'VSV'
,1
,'Vesicular Stomatitis Virus'
);

insert into materials
(  id
  ,code
  ,maty_id
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'SFV'
,1
,'Semliki Forest Virus'
);

insert into materials
(  id
  ,code
  ,maty_id
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'RV'
,1
,'Rotavirus'
);

insert into materials
(  id
  ,code
  ,maty_id
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'RRV'
,1
,'Rhesus Rotavirus'
);

insert into materials
(  id
  ,code
  ,maty_id
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'HSV1'
,1
,'Herpes Simplex Virus 1'
);

insert into materials
(  id
  ,code
  ,maty_id
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'EV1'
,1
,'Echovirus 1'
);

insert into materials
(  id
  ,code
  ,maty_id
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'MHV'
,1
,'Mouse Hepatitis Virus'
);

insert into materials
(  id
  ,code
  ,maty_id
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'FLU'
,1
,'Influenza A virus'
);

insert into materials
(  id
  ,code
  ,maty_id
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'Ad3'
,1
,'Adenovirus 3'
);

insert into materials
(  id
  ,code
  ,maty_id
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'Ad5'
,1
,'Adenovirus 5'
);

insert into materials
(  id
  ,code
  ,maty_id
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'VV'
,1
,'Vaccinia Virus'
);

insert into materials
(  id
  ,code
  ,maty_id
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'YFV'
,1
,'Yellow Fever Virus'
);

insert into materials
(  id
  ,code
  ,maty_id
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'DV'
,1
,'Dengue Virus 1'
);

insert into materials
(  id
  ,code
  ,maty_id
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'HRV2'
,1
,'Human respiratory virus'
);


----------------------------------------------------------------------
--  Purpose:  Insert an initial data set into the table EXPERIMENT_TYPES
--
--  Authors: Randy Ramin-Wright (CRW)
--
--  Change History:
--
--  Date          Author       Description
--  21-May-2007   CRW          First Draft
--
-----------------------------------------------------------------------

insert into experiment_types
(id
,code
,description)
values 
(nextval('EXPERIMENT_TYPE_ID_SEQ')
,'SIRNAHCS'
,'Small Interfering RNA High Content Screening'
);

----------------------------------------------------------------------
--  Purpose:  Insert an initial data set into the table PROCEDURE_TYPES
--
--  Authors: Randy Ramin-Wright (CRW)
--
--  Change History:
--
--  Date          Author       Description
--  14-Jun-2007   CRW          First Draft
--  26-Jun-2007   CRW          Add Experiment Sample Registration
--
-----------------------------------------------------------------------

insert into procedure_types
(id
,code
,description)
values 
(nextval('PROCEDURE_TYPE_ID_SEQ')
,'DATA ACQUISITION'
,'Data Acquisition'
);

insert into procedure_types
(id
,code
,description)
values 
(nextval('PROCEDURE_TYPE_ID_SEQ')
,'EXP SAMPLE REG'
,'Experiment Sample Registration'
);

----------------------------------------------------------------------
--  Purpose:  Insert an initial data set into the table OBSERVABLE_TYPES
--
--  Authors: Randy Ramin-Wright (CRW)
--
--  Change History:
--
--  Date          Author       Description
--  14-Jun-2007   CRW          First Draft
--
-----------------------------------------------------------------------

insert into observable_types
(id
,code
,description)
values 
(nextval('OBSERVABLE_TYPE_ID_SEQ')
,'IMAGE'
,'Image'
);

----------------------------------------------------------------------
--  Purpose:  Insert an initial data set into the table FILE_FORMAT_TYPES
--
--  Authors: Randy Ramin-Wright (CRW)
--
--  Change History:
--
--  Date          Author       Description
--  14-Jun-2007   CRW          First Draft
--
-----------------------------------------------------------------------

insert into file_format_types
(id
,code
,description)
values 
(nextval('FILE_FORMAT_TYPE_ID_SEQ')
,'TIFF'
,'TIFF File'
);

insert into file_format_types
(id
,code
,description)
values 
(nextval('FILE_FORMAT_TYPE_ID_SEQ')
,'MATLAB'
,'MATLAB File'
);

----------------------------------------------------------------------
--  Purpose:  Insert an initial data set into the table LOCATOR_TYPES
--
--  Authors: Randy Ramin-Wright (CRW)
--
--  Change History:
--
--  Date          Author       Description
--  27-Jun-2007   CRW          First Draft
--
-----------------------------------------------------------------------

insert into locator_types
(id
,code
,description)
values 
(nextval('LOCATOR_TYPE_ID_SEQ')
,'RELATIVE LOCATION'
,'Relative Location'
);

----------------------------------------------------------------------
--  Purpose:  Insert an initial data set into the table SAMPLE_TYPES
--
--  Authors: Randy Ramin-Wright (CRW)
--
--  Change History:
--
--  Date          Author       Description
--  26-Jun-2007   CRW          First Draft
--
-----------------------------------------------------------------------

insert into sample_types
(id
,code
,description)
values 
(nextval('SAMPLE_TYPE_ID_SEQ')
,'MASTER PLATE'
,'Master Plate'
);

insert into sample_types
(id
,code
,description)
values 
(nextval('SAMPLE_TYPE_ID_SEQ')
,'DILUTION PLATE'
,'Dilution Plate'
);

insert into sample_types
(id
,code
,description)
values 
(nextval('SAMPLE_TYPE_ID_SEQ')
,'CELL PLATE'
,'Cell Plate'
);

insert into sample_types
(id
,code
,description)
values 
(nextval('SAMPLE_TYPE_ID_SEQ')
,'CONTROL LAYOUT'
,'Control layout'
);

-- add default organization and project to simplify refactoring phase
insert into organizations
(id
,code)
values
(nextval('ORGANIZATION_ID_SEQ')
,'DEFAULT'
);

insert into projects
(id
,code
,orga_id)
values
(nextval('PROJECT_ID_SEQ')
,'DEFAULT'
,1
);