/*
--	$Id: state.interbase,v 1.2 1999/09/10 04:15:52 shevett Exp $
--
--	Table structure for table 'state'
*/

CREATE TABLE state (
  state_rowid INTEGER NOT NULL PRIMARY KEY,
  uid VARCHAR(20) NOT NULL,
  mslip INTEGER,
  mcont INTEGER,
  mresource INTEGER,
  mdataset VARCHAR(10),
  mother INTEGER,
  slipzoom INTEGER,
  reszoom VARCHAR(10),
  filters INTEGER,
  properties VARCHAR(200),
  contzoom VARCHAR(10),
  contlist VARCHAR(200)
);

CREATE INDEX state_uid_idx ON state(uid);

CREATE GENERATOR STATE_GEN;

SET TERM !! ;
CREATE TRIGGER STATE_row_trigger FOR STATE
ACTIVE BEFORE INSERT POSITION 0
	AS BEGIN
     		NEW.STATE_ROWID = GEN_ID (STATE_GEN, 1);
	END !!
COMMIT WORK !!
SET TERM ; !!
