RP REPORTGROUP

  CREATE TABLE rp_reportgroup
  (
    id             dintkey,
    parent         dforeignkey,
    name           dname,
    description    dtext180,
    lb               dlb,
    rb               drb,
    usergroupname  dname DEFAULT '',
    reserved       dinteger
  );
 
  ALTER TABLE rp_reportgroup
    ADD CONSTRAINT rp_pk_reportgroup PRIMARY KEY (id);
 
  CREATE UNIQUE INDEX rp_x_reportgroup_ugn ON rp_reportgroup
    /*COMPUTED BY (UPPER(usergroupname));*/
    (usergroupname);
 
  CREATE UNIQUE INDEX rp_x_reportgroup_lrn ON
    rp_reportgroup (name, parent);
 
  ALTER TABLE rp_reportgroup ADD CONSTRAINT rp_fk_reportgroup_parent
    FOREIGN KEY (parent) REFERENCES rp_reportgroup(id)
    ON UPDATE CASCADE
    ON DELETE CASCADE;
 
  ALTER TABLE gd_documenttype ADD CONSTRAINT gd_fk_documenttype_rpgroupkey
    FOREIGN KEY (reportgroupkey) REFERENCES rp_reportgroup (id) ON UPDATE CASCADE;