Project

General

Profile

« Previous | Next » 

Revision d8fd2684

Added by Andreas Müller over 13 years ago

updated test ddls for exsiccatum and primary collector

View differences:

cdmlib-io/src/test/resources/dbscripts/001_cdm.ddl
2884 2884 
        datepublished_freetext varchar(255),
2885 2885 
        datepublished_start varchar(255),
2886 2886 
        title longvarchar,
2887 
		referenceAbstract longvarchar,
2887 
	referenceAbstract longvarchar,
2888 2888 
        pages varchar(255),
2889 2889 
        series varchar(255),
2890 2890 
        volume varchar(255),
......
2933 2933 
        datepublished_freetext varchar(255),
2934 2934 
        datepublished_start varchar(255),
2935 2935 
        title longvarchar,
2936 
		referenceAbstract longvarchar,
2936 
	referenceAbstract longvarchar,
2937 2937 
        pages varchar(255),
2938 2938 
        series varchar(255),
2939 2939 
        volume varchar(255),
......
3409 3409 
        fieldnotes varchar(255),
3410 3410 
        fieldnumber varchar(255),
3411 3411 
        barcode varchar(255),
3412 
        createdby_id integer,
3412 
        exsiccatum varchar(255),
3413 
    	createdby_id integer,
3413 3414 
        updatedby_id integer,
3415 
        primarycollector_id integer,
3414 3416 
        lifestage_id integer,
3415 3417 
        sex_id integer,
3416 3418 
        collection_id integer,
......
3444 3446 
        fieldnotes varchar(255),
3445 3447 
        fieldnumber varchar(255),
3446 3448 
        barcode varchar(255),
3449 
        exsiccatum varchar(255),
3450 
    	primarycollector_id integer,
3447 3451 
        gatheringevent_id integer,
3448 3452 
        accessionnumber varchar(255),
3449 3453 
        catalognumber varchar(255),
......
7475 7479 
        foreign key (derivationevent_id)
7476 7480 
        references DerivationEvent;
7477 7481 

  		




  
  7482
  
    
    alter table SpecimenOrObservationBase 


  		




  
  7483
  
    
        add constraint FK11CB3232F75F225E 


  		




  
  7484
  
    
        foreign key (primarycollector_id) 


  		




  
  7485
  
    
        references AgentBase;


  		




  
  7486
  
    

  		




  7478
  7487
  
    
    alter table SpecimenOrObservationBase 


  		




  7479
  7488
  
    
        add constraint FK21CA3272F95F225A 


  		




  7480
  7489
  
    
        foreign key (gatheringevent_id) 


  		












Also available in:  Unified diff