Revision 4080
Added by daigle about 16 years ago
xmltables-postgres.sql | ||
---|---|---|
416 | 416 |
FOREIGN KEY (harvest_log_id) REFERENCES harvest_log |
417 | 417 |
); |
418 | 418 |
|
419 |
|
|
419 |
/* |
|
420 |
* db_version -- table to store the version history of this database |
|
421 |
*/ |
|
422 |
CREATE SEQUENCE db_version_id_seq; |
|
423 |
CREATE TABLE db_version ( |
|
424 |
db_version_id INT8 default nextval ('db_version_id_seq'), -- the identifier for the version |
|
425 |
version VARCHAR(250), -- the version number |
|
426 |
status INT8, -- status of the version |
|
427 |
date_created TIMESTAMP, -- the datetime on which the version was created |
|
428 |
CONSTRAINT db_version_pk PRIMARY KEY (db_version_id) |
|
429 |
); |
Also available in: Unified diff
Merge 1.9 changes into Head