<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='GE15'>
<EXEC_SQL>
/**************************************************************************/
/* GE15 ( アクセス調査テーブル )                                          */
/*                                                                        */
/* Created : 2010/05/07 16:07:46                                          */
/**************************************************************************/
CREATE TABLE GE15 (
   SYSTEM_ID      VARCHAR(10)                NOT NULL                   
 , USERID         VARCHAR(10)                NOT NULL                   
 , GUIKEY         VARCHAR(30)                                           
 , DYLOGIN        VARCHAR(14)                                           
 , DYLOGOUT       VARCHAR(14)                                           
 , USED_TIME      NUMERIC(9)     DEFAULT 0   NOT NULL                   
 , CNT_ACCESS     NUMERIC(9)     DEFAULT 0   NOT NULL                   
 , CNT_ERROR      NUMERIC(5)     DEFAULT 0   NOT NULL                   
 , CNT_READ       NUMERIC(9)     DEFAULT 0   NOT NULL                   
 , CNT_WRITE      NUMERIC(9)     DEFAULT 0   NOT NULL                   
 , TM_TOTAL_QUERY NUMERIC(18)    DEFAULT 0   NOT NULL                   
 , TM_MAX_QUERY   NUMERIC(9)     DEFAULT 0   NOT NULL                   
 , MAX_QUERY      BLOB                                                  
 , USERADRS       VARCHAR(40)                                           
 , HOSTADRS       VARCHAR(40)                                           
 , UNIQ           BIGINT                     NOT NULL PRIMARY KEY       
 , FGJ            VARCHAR(1)     DEFAULT '1' NOT NULL                   
 , DYSET          VARCHAR(14)                                           
 , PGSET          VARCHAR(10)                                           
 , PGPSET         VARCHAR(10)                                           
 , USRSET         VARCHAR(10)                                           
 , DYUPD          VARCHAR(14)                                           
 , PGUPD          VARCHAR(10)                                           
 , PGPUPD         VARCHAR(10)                                           
 , USRUPD         VARCHAR(10)                                           
)</EXEC_SQL>

<EXEC_SQL>
CREATE SEQUENCE GE15S01 
</EXEC_SQL>


<EXEC_SQL>
CREATE TRIGGER GE15T01 FOR GE15
  BEFORE INSERT 
  AS BEGIN 
    NEW.UNIQ = GEN_ID( GE15S01,1 );
  END; 
</EXEC_SQL>

</ROWSET>
