Project

General

Profile

Revision 6583

drop old identifier when upgrading from 1.9.5 to 2.0.0

View differences:

src/upgrade-db-to-2.0.0-oracle.sql
36 36
		FOREIGN KEY (guid) REFERENCES systemMetadata
37 37
);
38 38

  
39
DROP TABLE identifier;
40

  
39 41
CREATE TABLE identifier (
40 42
   guid   VARCHAR2(2000), -- the globally unique string identifier
41 43
   docid  VARCHAR2(250),  -- the local document id #
src/upgrade-db-to-2.0.0-postgres.sql
35 35
		FOREIGN KEY (guid) REFERENCES systemMetadata
36 36
);
37 37

  
38
/*
39
 * Remove the old Identifier table (pre-2.0)
40
 */
41
DROP TABLE identifier;
42
/*
43
 * Create the new one (DataONE features)
44
 */
38 45
CREATE TABLE identifier (
39 46
   guid   text,          -- the globally unique string identifier
40 47
   docid  VARCHAR(250),  -- the local document id #

Also available in: Unified diff