----------------------------------------------------------------------
--  Filename: INSERT_MATERIAL_TYPES.sql
--
--  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
(code
,description)
values 
('VIRUS'
,'Virus'
);

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

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

insert into material_types
(code
,description)
values 
('GENE'
,'Gene'
);
insert into material_types
(code
,description)
values 
('OLIGO'
,'Oligonucleotide'
);

----------------------------------------------------------------------
--  Filename: INSERT_MATERIALS.sql
--
--  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
--
-----------------------------------------------------------------------

insert into materials
(  id
  ,name
  ,mate_sub_type
  ,maty_code
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'HSV-1'
,'STOB'
,'VIRUS'
,'Study Object: Type 1 Herpes Simplex Virus'
);

insert into materials
(  id
  ,name
  ,mate_sub_type
  ,maty_code
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'HSV-2'
,'STOB'
,'VIRUS'
,'Study Object: Type 2 Herpes Simplex Virus'
);

insert into materials
(  id
  ,name
  ,mate_sub_type
  ,maty_code
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'CELL LINE ABC'
,'MATE'
,'CELLLINE'
,'Cell Line ABC'
);

insert into materials
(  id
  ,name
  ,mate_sub_type
  ,maty_code
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'CELL LINE XYZ'
,'MATE'
,'CELLLINE'
,'Cell Line XYZ'
);

insert into materials
(  id
  ,name
  ,mate_sub_type
  ,maty_code
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'GENE ABC'
,'MATE'
,'GENE'
,'Gene ABC'
);

insert into materials
(  id
  ,name
  ,mate_sub_type
  ,maty_code
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'GENE XYZ'
,'MATE'
,'GENE'
,'Gene XYZ'
);


insert into materials
(  id
  ,name
  ,mate_sub_type
  ,maty_code
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'OLIGO ABC'
,'MATE'
,'OLIGO'
,'Oligo ABC'
);

insert into materials
(  id
  ,name
  ,mate_sub_type
  ,maty_code
  ,description
  )
values 
(nextval('MATERIAL_ID_SEQ')
,'OLIGO XYZ'
,'MATE'
,'OLIGO'
,'Oligo XYZ'
);

----------------------------------------------------------------------
--  Filename: INSERT_EXPERIMENT_TYPES.sql
--
--  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
(code
,description)
values 
('SIRNAHCS'
,'Small Interfering RNA High Content Screening'
);

insert into experiment_types
(code
,description)
values 
('MS-MS'
,'Tandem Mass Spectrometry'
);

insert into experiment_types
(code
,description)
values 
('GC-MS'
,'Gas Chromatography Mass Spectrometry'
);

insert into experiment_types
(code
,description)
values 
('LC-MS'
,'Liquid Chromatography Mass Spectrometry'
);


