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

CREATE TABLE policy_login (
  policylogin_rowid INTEGER NOT NULL PRIMARY KEY,
  pid INTEGER DEFAULT 0 NOT NULL,
  login VARCHAR(10) NOT NULL,
  acl_view VARCHAR(1),
  acl_delete VARCHAR(1),
  acl_create VARCHAR(1),
  acl_child VARCHAR(1),
  acl_modify VARCHAR(1),
  acl_follow VARCHAR(1),
  acl_email VARCHAR(1),
  acl_close VARCHAR(1)
);

CREATE GENERATOR policylogin_GEN;
COMMIT;

SET TERM !! ;
CREATE TRIGGER policylogin_row_trigger FOR policy_login
ACTIVE BEFORE INSERT POSITION 0
	AS BEGIN
     		NEW.POLICYLOGIN_ROWID = GEN_ID (POLICYLOGIN_GEN, 1);
	END !!
COMMIT WORK !!
SET TERM ; !!
