Project

General

Profile

« Previous | Next » 

Revision 7392

Added by ben leinfelder over 11 years ago

shorten the systemmetadata* table names for Oracle's 30 character limit. move version to 2.0.5. http://bugzilla.ecoinformatics.org/show_bug.cgi?id=5717

View differences:

upgrade-db-to-2.0.0-oracle.sql
20 20 
		PRIMARY KEY (guid)
21 21 
)
22 22 

  		




  23
  
  
    
CREATE TABLE systemMetadataReplicationPolicy (


  		




  
  23
  
    
CREATE TABLE smReplicationPolicy (


  		




  24
  24
  
    
	guid VARCHAR2(2000),	-- the globally unique string identifier of the object that the system metadata describes


  		




  25
  25
  
    
	member_node VARCHAR(250),	 -- replication member node


  		




  26
  26
  
    
	policy VARCHAR2(2000),	 -- the policy (preferred, blocked, etc...TBD)


  		




  27
  
  
    
	CONSTRAINT systemMetadataReplicationPolicy_fk 


  		




  
  27
  
    
	CONSTRAINT smReplicationPolicy_fk 


  		




  28
  28
  
    
		FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE


  		




  29
  29
  
    
);


  		




  30
  30
  
    

  		




  31
  
  
    
CREATE TABLE systemMetadataReplicationStatus (


  		




  
  31
  
    
CREATE TABLE smReplicationStatus (


  		




  32
  32
  
    
	guid VARCHAR2(2000),	-- the globally unique string identifier of the object that the system metadata describes


  		




  33
  33
  
    
	member_node VARCHAR(250),	 -- replication member node


  		




  34
  34
  
    
	status VARCHAR(250),	 -- replication status


  		




  35
  35
  
    
	date_verified DATE, 	-- the date replication was verified   


  		




  36
  
  
    
	CONSTRAINT systemMetadataReplicationStatus_fk 


  		




  
  36
  
    
	CONSTRAINT smReplicationStatus_fk 


  		




  37
  37
  
    
		FOREIGN KEY (guid) REFERENCES systemMetadata DEFERRABLE


  		




  38
  38
  
    
);


  		




  39
  39
  
    

  		












Also available in:  Unified diff