Revision 5371
Added by berkley almost 13 years ago
| upgrade-db-to-1.10.0-postgres.sql | ||
|---|---|---|
| 1 | 1 |
DROP TABLE identifier; |
| 2 | 2 |
DROP SEQUENCE identifier_id_seq; |
| 3 |
DROP TABLE systemMetadata; |
|
| 4 |
DROP SEQUENCE systemMetadata_id_seq; |
|
| 3 | 5 |
|
| 6 |
CREATE TABLE systemMetadata ( |
|
| 7 |
guid text, -- the globally unique string identifier |
|
| 8 |
docid VARCHAR(250), -- the local document id # |
|
| 9 |
rev INT8, -- the revision part of the local identifier |
|
| 10 |
CONSTRAINT systemMetadata_pk PRIMARY KEY (guid) |
|
| 11 |
); |
|
| 12 |
|
|
| 4 | 13 |
CREATE TABLE identifier ( |
| 5 | 14 |
guid text, -- the globally unique string identifier |
| 6 | 15 |
docid VARCHAR(250), -- the local document id # |
Also available in: Unified diff
added systemMetadata table to the upgrade scripts