Project

General

Profile

« Previous | Next » 

Revision 9576

Added by Jing Tao almost 9 years ago

Add the format_id column on the xml_catalog table.

View differences:

src/xmltables-postgres.sql
130 130
	target_doctype VARCHAR(500),	-- the target public_id for transforms
131 131
	public_id VARCHAR(500),	-- the unique id for this type
132 132
	system_id VARCHAR(1000),	-- the local location of the object
133
  format_id VARCHAR(1000),  -- the format id from dataone 
133 134
   CONSTRAINT xml_catalog_pk PRIMARY KEY (catalog_id),
134 135
   CONSTRAINT xml_catalog_uk UNIQUE
135
              (entry_type, source_doctype, target_doctype, public_id)
136
              (entry_type, source_doctype, target_doctype, public_id, format_id)
136 137
);
137 138

  
138 139
/*

Also available in: Unified diff