Changeset 4799 for MSI


Ignore:
Timestamp:
13/01/09 10:19:08 (10 years ago)
Author:
sdonegan
Message:

Updated from basic test with all columns required in simple single table.

File:
1 edited

Legend:

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

    r4710 r4799  
    88CREATE TABLE simpleLogging ( 
    99        search_term_id SERIAL primary key, 
     10        session_ID text, 
     11        start_time timestamp without time zone, 
     12        end_time timestamp without time zone, 
     13        date_of_search timestamp, 
     14        scope text, 
     15        originator_IP text, 
    1016        search_term text, 
    11         date_of_search timestamp, 
    12         scope text 
     17        geographicExtent_As_Text text, 
     18        number_Results_Returned 
    1319); 
Note: See TracChangeset for help on using the changeset viewer.