PBMiner

• Sources
• PFC125
• security
• control.sql

//changes to tables to alter column 'control' to have a
//width of 128


ALTER TABLE "dba"."security_info"
       DELETE FOREIGN KEY "security_info_template";

ALTER TABLE "dba"."security_info"
	DELETE PRIMARY KEY;

ALTER TABLE "dba"."security_template"
	DELETE PRIMARY KEY;

ALTER TABLE "dba"."security_info"
	MODIFY control varchar(128) NOT NULL;

ALTER TABLE "dba"."security_template"
	MODIFY control varchar(128) NOT NULL;
 
ALTER TABLE "dba"."security_info"
        ADD PRIMARY KEY ("application",
       "window",
       "control",
       "user_name");
 
ALTER TABLE "dba"."security_template"
        ADD PRIMARY KEY ("application",
       "window",
       "control");
 
ALTER TABLE "dba"."security_info"
       ADD FOREIGN KEY "security_info_template" ("application",
       "window",
       "control"
       ) REFERENCES "dba"."security_template"
       ON DELETE  CASCADE;