File: control.sql
Size: 884
Date: Sat, 08 May 2021 23:34:22 +0200
Type: 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;