source: TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase/IngestLoggingTable.sql @ 7239

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase/IngestLoggingTable.sql@7239
Revision 7239, 518 bytes checked in by sdonegan, 9 years ago (diff)

Initial commit of ingest & logging database create scripts

Line 
1/*
2 * Simple table to hold test records collected from logging framework
3 *
4 * SJD 23/12/08
5 *
6 */
7DROP TABLE discoverySearchLogging CASCADE;
8CREATE TABLE discoverySearchLogging (
9        local_ingest_id SERIAL primary key,
10        alt_ingest_id text,
11        provider_id text,
12        ingest_date timestamp,
13        total_files_processed int,
14        total_files_processed_successfully int,
15        total_files_processed_unsuccessfully int,
16        records_created int,
17        records_updated int,
18        records_deleted int,
19        number_problem_files int,       
20);
Note: See TracBrowser for help on using the repository browser.