source: TI01-discovery/branches/ingestAutomation-upgrade/database/transformed_document.sql @ 3849

/* 
 * Basic DB structure to use in test of NERC Discovery upgrad
 * 
 * C Byrom Apr 08
 * 
 */
--CREATE SCHEMA badc;
--CREATE TABLE badc.records (
DROP TABLE transformed_document;
CREATE TABLE transformed_document (
        transformed_document_id         SERIAL primary key,
                original_record_id      int references original_document(original_document_id),
                transformed_format      text,
                transformed_document    text,
                create_date     timestamp,
                update_date timestamp,
                scn                     int
);

INSERT INTO transformed_document VALUES (DEFAULT, 1,  'moles', null, current_date, null, 1);
INSERT INTO transformed_document VALUES (DEFAULT, 1,  'mdip', 
'<mdip xmlns="http://earth.google.com/kml/2.2">
  <Folder>
        <name>Aggregation of KML documents by NDG Portal</name>
    <visibility>0</visibility>
        <open>0</open>
        <description>The NetworkLink KML resources are those selected by the user when creating the document in the NDG portal (include URL?)</description>
                    <NetworkLink>
                        <name>ARGO Active float data; latitude range 45S to 90S; 18 March</name>
                        <visibility>0</visibility>
                        <open>0</open>
                        <description>ARGO Active float data; latitude range 45S to 90S; 18 March - aggregated by the NDG Portal</description>
                        <refreshVisibility>0</refreshVisibility>
                        <flyToView>0</flyToView>
                        <Link>
                                <href>
                                        http://psdocean.nerc-bas.ac.uk/ARGO/web/Active45S-90S.kmz
                                </href>
                        </Link>
                </NetworkLink>
  </Folder>
</mdip>',
current_date, null, 1);