Koders Code Search: create_table_tlog.sql

download

create_table_tlog.sql
Language: SQL
LOC: 10

Project Info
LOG4PLSQL
Server: Spider_20090401_inc
Type: filesystem

$0011\log4plsql\log4plsql-4.0-beta.zip\log4plsql\sql\install_log_user\$ ...plsql\sql\install_log_user\

   create_sequence_sq_stg.sql
   create_table_tlog.sql
   create_table_tloglevel.sql
   ...e_t_array_log_queue.sql
   ...te_type_t_log_queue.sql
   create_view_vlog.sql
   drop_queue.sql
   dummy.sql
   insert_into_tloglevel.sql
   install.sql
   output_alert.sql
   output_aq.sql
   output_dbms_output.sql
   output_session.sql
   output_trace.sql
   pb_plog.sql
   pb_plog_interface.sql
   pb_plog_out_alert.sql
   pb_plog_out_aq_queue.sql
   pb_plog_out_aq_topic.sql
   ...log_out_dbms_output.sql
   pb_plog_out_session.sql
   pb_plog_out_tlog.sql
   pb_plog_out_trace.sql
   pb_plogparam.sql
   ps_plog.sql
   ps_plog_interface.sql
   ps_plog_out_alert.sql
   ps_plog_out_aq.sql
   ...log_out_dbms_output.sql
   ps_plog_out_session.sql
   ps_plog_out_tlog.sql
   ps_plog_out_trace.sql
   ps_plogparam.sql

-------------------------------------------------------------------
--
--  File : create_table_tlog.sql (SQLPlus script)
--
--  Description : creation of the table TLOG
-------------------------------------------------------------------
--
-- history : who                 created     comment
--     v1    Bertrand Caradec   15-MAY-08    creation
--                                     
--
-------------------------------------------------------------------
/*
 * Copyright (C) LOG4PLSQL project team. All rights reserved.
 *
 * This software is published under the terms of the The LOG4PLSQL 
 * Software License, a copy of which has been included with this
 * distribution in the LICENSE.txt file.  
 * see: <http://log4plsql.sourceforge.net>  */

CREATE TABLE TLOG
(
  ID       NUMBER, 
  LDATE    DATE DEFAULT SYSDATE, 
  LHSECS   NUMBER(38), 
  LLEVEL   NUMBER(38), 
  LSECTION VARCHAR2(2000 BYTE), 
  LTEXT    VARCHAR2(2000 BYTE), 
  LUSER    VARCHAR2(30 BYTE), 
  CONSTRAINT   PK_STG PRIMARY KEY (ID));