source: MSI/Discovery/trunk/DI01-LoggingFramework/sql/basicLoggingTable.sql @ 4710

Subversion URL: http://proj.badc.rl.ac.uk/svn/ndg/MSI/Discovery/trunk/DI01-LoggingFramework/sql/basicLoggingTable.sql@4710
Revision 4710, 280 bytes checked in by sdonegan, 12 years ago (diff)

Basic test logging table and sample update sql for logging framework

Line 
1/*
2 * Simple table to hold test records collected from logging framework
3 *
4 * SJD 23/12/08
5 *
6 */
7DROP TABLE simpleLogging CASCADE;
8CREATE TABLE simpleLogging (
9        search_term_id SERIAL primary key,
10        search_term text,
11        date_of_search timestamp,
12        scope text
13);
Note: See TracBrowser for help on using the repository browser.