source: TI01-discovery/branches/ingestAutomation-upgrade/database/create_database.sh @ 3807

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/TI01-discovery/branches/ingestAutomation-upgrade/database/create_database.sh@3807
Revision 3807, 133 bytes checked in by cbyrom, 12 years ago (diff)

Create new DB scripts to cope with the document records being stored in Postgres:
ORIGINAL_DOCUMENT - stores the harvested doc with its record ID and format type
TRANSFORMED_DOCUMENT - is a long, thin table allowing multiple transformed docs to be stored
referencing a single original document
ORIGINAL_DOCUMENT_HISTORY - is a mirror table for the ORIGINAL_DOCUMENT table

  • allowing historical records to be kept, e.g. for auditing or versioning purposes

create_database.sh - script to automatically set up the database.

  • Property svn:executable set to *
Line 
1# set up postgres path first
2psql -f original_document.sql -U postgres -d test
3psql -f transformed_document.sql -U postgres -d test
Note: See TracBrowser for help on using the repository browser.