Changeset 4813 for MSI


Ignore:
Timestamp:
15/01/09 15:20:20 (10 years ago)
Author:
sdonegan
Message:

Update query to create table and columns for search parameter logging database

File:
1 edited

Legend:

Unmodified
Added
Removed
  • MSI/Discovery/trunk/DI01-LoggingFramework/sql/basicLoggingTable.sql

    r4799 r4813  
    55 *  
    66 */ 
    7 DROP TABLE simpleLogging CASCADE; 
    8 CREATE TABLE simpleLogging ( 
    9         search_term_id SERIAL primary key, 
     7DROP TABLE discoverySearchLogging CASCADE; 
     8CREATE TABLE discoverySearchLogging ( 
     9        search_term_id SERIAL primary key,       
    1010        session_ID text, 
    11         start_time timestamp without time zone, 
    12         end_time timestamp without time zone, 
     11        search_term text, 
     12        start_time timestamp, 
     13        end_time timestamp, 
    1314        date_of_search timestamp, 
    1415        scope text, 
    1516        originator_IP text, 
    16         search_term text, 
     17        portal_IP text, 
    1718        geographicExtent_As_Text text, 
    18         number_Results_Returned 
     19        number_Results_Returned int 
    1920); 
Note: See TracChangeset for help on using the changeset viewer.