RP REPORTGROUP
Материал из GedeminWiki
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;