/*
--	$Id: eschema.interbase,v 1.1 1999/06/10 22:44:06 billf Exp $
--
--	Table structure for table 'eschema'
*/

CREATE TABLE eschema (
  eschema_rowid INTEGER NOT NULL PRIMARY KEY,
  etable VARCHAR(15) NOT NULL,
  element VARCHAR(15),
  etype VARCHAR(1),
  eflags VARCHAR(80),
  esequence INTEGER,
  elength INTEGER,
  elabel VARCHAR(20)
);

CREATE INDEX eschema_etable_idx ON eschema(etable);

CREATE GENERATOR eschema_GEN;
COMMIT;

SET TERM !! ;
CREATE TRIGGER eschema_row_trigger FOR eschema
ACTIVE BEFORE INSERT POSITION 0
	AS BEGIN
     		NEW.ESCHEMA_ROWID = GEN_ID (eschema_GEN, 1);
	END !!
COMMIT WORK !!
SET TERM ; !!
