<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='GF28'>
/****************************************************************************/
/* GF28 ( 対訳ﾃｰﾌﾞﾙ )                                                       */
/*                                                                          */
/* Created : 2022/11/10 17:41:42                                            */
/****************************************************************************/
<EXEC_SQL exists="0">
SELECT COUNT(*) FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG=0 and RDB$RELATION_TYPE=0 and RDB$RELATION_NAME=UPPER('GF28');
CREATE TABLE GF28 (
   SYSTEM_ID    VARCHAR (  10 )                     NOT NULL                
 , KEYWORD      VARCHAR ( 200 )     DEFAULT '**'                            
 , GENBUN       VARCHAR ( 500 )                     NOT NULL                
 , LANG_YAKU    VARCHAR (   2 )                     NOT NULL                
 , KBYAKU       VARCHAR (   1 )                     NOT NULL                
 , KBHORYU      VARCHAR (   1 )     DEFAULT '0'     NOT NULL                
 , YAKU         VARCHAR ( 500 )                                             
 , ID           VARCHAR (  30 )                                             
 , COMMENTS     VARCHAR ( 500 )                                             
 , UNIQ         BIGINT                              NOT NULL                
 , FGJ          VARCHAR (   1 )     DEFAULT '1'     NOT NULL                
 , DYSET        VARCHAR (  14 )                                             
 , PGSET        VARCHAR (  50 )                                             
 , PGPSET       VARCHAR (  50 )                                             
 , USRSET       VARCHAR (  30 )                                             
 , DYUPD        VARCHAR (  14 )                                             
 , PGUPD        VARCHAR (  50 )                                             
 , PGPUPD       VARCHAR (  50 )                                             
 , USRUPD       VARCHAR (  30 )                                             
);
</EXEC_SQL>

<EXEC_SQL exists="0">
SELECT COUNT(*) FROM RDB$GENERATORS WHERE RDB$GENERATOR_NAME=UPPER('GF28S00');
CREATE SEQUENCE GF28S00 ;
</EXEC_SQL>

<EXEC_SQL>
CREATE TRIGGER GF28T00 FOR GF28
  BEFORE INSERT AS 
  BEGIN 
    NEW.UNIQ = GEN_ID( GF28S00,1 );
  END; 
</EXEC_SQL>
</ROWSET>
