-- md_script.con
--
-- Generated for Oracle 8 on Wed May 05 11:59:49 1999 by Server Generator 2.1.24.5.0
PROMPT Creating Primary Key on 'DETAIL_TABLE'
ALTER TABLE DETAIL_TABLE
ADD CONSTRAINT DETAIL_PK PRIMARY KEY
(MASTER_KEY
,DETAIL_KEY)
USING INDEX
INITRANS 2
MAXTRANS 255
PCTFREE 10
STORAGE
(
INITIAL 14336
NEXT 14336
PCTINCREASE 1
MINEXTENTS 1
MAXEXTENTS UNLIMITED
)
TABLESPACE COMMON_INDEX
/
PROMPT Creating Primary Key on 'MASTER_TABLE'
ALTER TABLE MASTER_TABLE
ADD CONSTRAINT MASTER_PK PRIMARY KEY
(MASTER_KEY)
USING INDEX
INITRANS 2
MAXTRANS 255
PCTFREE 10
STORAGE
(
INITIAL 14336
NEXT 14336
PCTINCREASE 1
MINEXTENTS 1
MAXEXTENTS UNLIMITED
)
TABLESPACE COMMON_INDEX
/
PROMPT Creating Foreign Keys on 'DETAIL_TABLE'
ALTER TABLE DETAIL_TABLE ADD CONSTRAINT
DETAIL_MASTER_FK FOREIGN KEY
(MASTER_KEY) REFERENCES MASTER_TABLE
(MASTER_KEY)
/