/*
--	$Id: followups.interbase,v 1.2 1999/09/20 00:44:15 billf Exp $
--
--	Table structure for table 'followups'
--
*/

CREATE TABLE followups (
  FOLLOWUPS_rowid INTEGER NOT NULL PRIMARY KEY,
  f_sid INTEGER DEFAULT 0 NOT NULL,
  f_date INTEGER,
  f_tech VARCHAR(10),
  f_text blob SUB_TYPE 0 SEGMENT SIZE 80,
  f_seq INTEGER,
  f_public INTEGER,
  f_usergen INTEGER,
	f_time INTEGER
);

CREATE GENERATOR followups_GEN;
COMMIT;

SET TERM !! ;
CREATE TRIGGER followup_row_trigger FOR followups
ACTIVE BEFORE INSERT POSITION 0
	AS BEGIN
     		NEW.FOLLOWUPS_ROWID = GEN_ID (FOLLOWUPS_GEN, 1);
	END !!
COMMIT WORK !!
SET TERM ; !!
