/*
--
--   $Id: ebulk.interbase,v 1.2 2000/02/02 03:57:12 shevett Exp $
--
-- Table structure for table 'ebulk'
--
*/

CREATE TABLE ebulk (
  ebulk_rowid INTEGER NOT NULL PRIMARY KEY,
  btable varchar(15) NOT NULL,
  belement varchar(15),
  bvalue varchar(80),
	bkeyref varchar(80),
  browref INTEGER DEFAULT 0 NOT NULL 
);

CREATE INDEX ebulk_browref_idx ON ebulk(browref);

CREATE GENERATOR ebulk_GEN;
COMMIT;

SET TERM !! ;
CREATE TRIGGER ebulk_row_trigger FOR ebulk
ACTIVE BEFORE INSERT POSITION 0
	AS BEGIN
     		NEW.EBULK_ROWID = GEN_ID (ebulk_GEN, 1);
	END !!
COMMIT WORK !!
SET TERM ; !!
