Change History - this file contains all changes
since last frozen version August 24, 2004 until
May 5, 2005.   It is divided into sections showing
change history for each published draft.


Change history of GDPDM from version
April 29, 2005 to version May 5, 2005
---------------------------------------------

- Updated description for following fields
  and tables:
  div_allele.quality
  div_allele.value
  div_aa_annotation
  div_accession_collecting
  div_allele
  div_allele_assay
  div_annotation_type
  div_obs_unit_sample
  div_poly_type
  div_poly_type.poly_type
  div_trait
  cdv_map_feature
  cdv_marker
  cdv_marker.ref_seq
  
- Updated div_obs_unit.div_locality_id to
  be required.

- Updated div_accession_collecting.div_locality_id
  to not be required.

- Deprecated fields length, position, ref_seq, and
  div_ref_stock_id in table div_allele_assay.  All
  these fields should be used in the cdv_marker table.

- Updated div_passport.source to be required.

-



Change history of GDPDM from version
April 25, 2005 to version April 29, 2005.
---------------------------------------------

- Moved reference to div_scoring_tech_type
  to table div_allele_assay instead of
  div_aa_annotation.

- Corrected div_taxa_family to reflect levels
  for plant instead of animals.

- Added field common_name to the
  div_taxonomy table.

- Changed all primary and foreign keys
  to be unsigned integers.   Effectively
  doubling the range of values as keys
  generally are not negative.

- Changed data type of div_trait_uom.to_accession
  and div_treatment_uom.eo_accession to varchar
  instead of int.  Necessary for integration
  with Gramene.

- For consistency, changed the following
  field names to "comments":
  div_passport.remarks
  div_stock.remarks
  div_synonym.remarks
  div_generation.remarks
  div_obs_unit.summary



Change history of GDPDM from version
August 24, 2004 (frozen) to version April 25, 2005.
------------------------------------------
- Changed all numbers to default to NULL instead
  of zero.

- In table: cdv_map_feature, changed field
  chromosome_number to chromosome_name and changed
  data type to text.

- Updated the documentation for table: div_poly_type
  field: poly_type to have "Categorical" instead of
  "Mobility".

- Added fields referencedb and accession to table
  div_allele.

- Changed data type of these fields
  from varchar to text.
    div_obs_unit_sample.comments
    cdv_marker.ref_seq
    cdv_allele_assay.ref_seq
    div_passport.remarks
    div_stock.remarks
    div_synonym.remarks
    div_trait_uom.trait_protocol
    cdv_curation.comments
    cdv_map_feature.comments
    cdv_reason.description
    div_allele_assay.comments
    div_experiment.comments
    div_obs_unit_summary

- Added table div_scoring_tech_type which
  is referenced by table div_aa_annotation.

- Added field season to table div_obs_unit.

- Added div_taxa_family table to further specify
  the Taxonomy.   The div_taxonomy table references
  this new table.

- Updated descriptions to reflect actual mySQL
  data types for each field.

- Fields div_experiment.originator and
  div_trait.div_statistic_type changed to required.

- Updated description for:
    table: div_accession_collecting
    field: div_passport.accename
    table: div_experiment
    table: div_generation
    table: div_obs_unit
    table: div_passport
    table: div_stock
    table: div_stock_parent
    field: div_stock_parent.div_parent_id
    table: div_synonym
    table: div_trait
    table: div_trait_uom
    field: div_trait_uom.trait_protocol
    table: div_treatment
    table: div_treatment_uom