metacat/src/upgrade-db-to-1.10.0-postgres.sql @ 5356
1 |
DROP TABLE identifier; |
---|---|
2 |
DROP SEQUENCE identifier_id_seq; |
3 |
|
4 |
CREATE TABLE identifier ( |
5 |
guid text, -- the globally unique string identifier |
6 |
docid VARCHAR(250), -- the local document id # |
7 |
rev INT8, -- the revision part of the local identifier |
8 |
CONSTRAINT identifier_pk PRIMARY KEY (guid) |
9 |
);
|
10 |
|
11 |
/*
|
12 |
* update the database version
|
13 |
*/
|
14 |
UPDATE db_version SET status=0; |
15 |
|
16 |
INSERT INTO db_version (version, status, date_created) |
17 |
VALUES ('1.10.0', 1, CURRENT_DATE); |