source: TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/database/transformed_document.sql @ 7185

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/database/transformed_document.sql@7185
Revision 7185, 469 bytes checked in by sdonegan, 10 years ago (diff)

Adding files from v4.2.0 tag to form basis for v4.3.0 version

Line 
1/*
2 * Basic DB structure to use in test of NERC Discovery upgrad
3 *
4 * C Byrom Apr 08
5 *
6 */
7--CREATE SCHEMA badc;
8--CREATE TABLE badc.records (
9DROP TABLE transformed_document;
10CREATE TABLE transformed_document (
11        transformed_document_id SERIAL primary key,
12                original_document_id    int references original_document(original_document_id),
13                transformed_format      text,
14                transformed_document    text,
15                create_date     timestamp,
16                update_date timestamp,
17                scn                     int
18);
Note: See TracBrowser for help on using the repository browser.