metacat/src/upgrade-db-to-1.10.0-postgres.sql @ 5352
1 | 5276 | jones | 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); |