"Fossies" - the Fresh Open Source Software Archive

Member "mod_log_sql-1.101/contrib/create_tables.sql" (11 Jan 2005, 1068 Bytes) of package /linux/www/apache_httpd_modules/old/mod_log_sql-1.101.tar.bz2:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 create table access_log (
    2     id char(19) ,
    3     agent varchar(255) ,
    4     bytes_sent int unsigned ,
    5     child_pid smallint unsigned,
    6     cookie varchar(255),
    7     machine_id varchar(25),
    8     request_file varchar(255),
    9     referer varchar(255) ,
   10     remote_host varchar(50) ,
   11     remote_logname varchar(50) ,
   12     remote_user varchar(50) ,
   13     request_duration smallint unsigned ,
   14     request_line varchar(255),
   15     request_method varchar(10) ,
   16     request_protocol varchar(10) ,
   17     request_time char(28),
   18     request_uri varchar(255),
   19     request_args varchar(255),
   20     server_port smallint unsigned,
   21     ssl_cipher varchar(25),
   22     ssl_keysize smallint unsigned,
   23     ssl_maxkeysize smallint unsigned,
   24     status smallint unsigned ,
   25     time_stamp int unsigned ,
   26     virtual_host varchar(255)
   27 );
   28 
   29 create table notes (
   30     id char(19),
   31     item varchar(80),
   32     val varchar(80)
   33 );
   34 
   35 create table headers_in (
   36     id char(19),
   37     item varchar(80),
   38     val varchar(80)
   39 );
   40 
   41 create table headers_out (
   42     id char(19),
   43     item varchar(80),
   44     val varchar(80)
   45 );
   46 
   47 create table cookies (
   48     id char(19),
   49     item varchar(80),
   50     val varchar(80)
   51 );