-- 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)

/