Changeset 7363


Ignore:
Timestamp:
25/08/10 15:11:18 (9 years ago)
Author:
sdonegan
Message:

adjusted types to match similar elsewhere in db

Location:
TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase/IngestLoggingTable.sql

    r7297 r7363  
    88CREATE TABLE ingest_search_logging ( 
    99    local_ingest_id SERIAL primary key, -- id assigned by postgres 
    10         id text, -- process id supplied by calling function      
     10        id int4, -- process id supplied by calling function      
    1111        ingest_date timestamp, -- time of ingest 
    1212        total_files_processed int, -- total number of files handled 
  • TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase/IngestProblemFileTable.sql

    r7297 r7363  
    88CREATE TABLE ingest_logging_problem_files ( 
    99    problem_file_id SERIAL primary key, --id assigned by postgres 
    10         id text, --process id 
     10        id int4, --process id 
    1111        problem_file_name text, --name of problem file 
    1212        problem_file_message text --error associated with problem file   
  • TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/ingestLoggingDatabase/ingestLoggingProcedures.sql

    r7352 r7363  
    55 *  
    66 */ 
    7 DROP FUNCTION add_ingest_stats(ingest_id_in text, ingest_date_in timestamp,total_files_processed_in int,total_files_processed_successfully_in int, total_files_processed_unsuccessfully_in int,records_created_in int,records_updated_in int,records_deleted_in int,number_problem_files_in int) CASCADE; 
    8 CREATE FUNCTION add_ingest_stats(ingest_id_in text,ingest_date_in timestamp,total_files_processed_in int,total_files_processed_successfully_in int, total_files_processed_unsuccessfully_in int,records_created_in int,records_updated_in int,records_deleted_in int,number_problem_files_in int) RETURNS VOID AS  
     7DROP FUNCTION add_ingest_stats(ingest_id_in int4, ingest_date_in timestamp,total_files_processed_in int,total_files_processed_successfully_in int, total_files_processed_unsuccessfully_in int,records_created_in int,records_updated_in int,records_deleted_in int,number_problem_files_in int) CASCADE; 
     8CREATE FUNCTION add_ingest_stats(ingest_id_in int4,ingest_date_in timestamp,total_files_processed_in int,total_files_processed_successfully_in int, total_files_processed_unsuccessfully_in int,records_created_in int,records_updated_in int,records_deleted_in int,number_problem_files_in int) RETURNS VOID AS  
    99$$ 
    1010    BEGIN 
     
    1515$$ LANGUAGE 'plpgsql'; 
    1616 
    17 DROP FUNCTION add_problem_file(ingest_id_in text, problem_filename_in text, problem_file_message_in text) CASCADE; 
    18 CREATE FUNCTION add_problem_file(ingest_id_in text, problem_filename_in text, problem_file_message_in text) RETURNS VOID AS 
     17DROP FUNCTION add_problem_file(ingest_id_in int4, problem_filename_in text, problem_file_message_in text) CASCADE; 
     18CREATE FUNCTION add_problem_file(ingest_id_in int4, problem_filename_in text, problem_file_message_in text) RETURNS VOID AS 
    1919$$ 
    2020    BEGIN 
Note: See TracChangeset for help on using the changeset viewer.