-- d:\jde\mc\mapdata.con
--
-- Generated for Oracle 8 on Thu Mar 26  10:57:08 1998 by Server Generator 2.1.19.2.0
  
PROMPT Creating Primary Key on 'LINE_SEGMENT'
ALTER TABLE LINE_SEGMENT
 ADD CONSTRAINT LS_PK PRIMARY KEY 
  (ID)
/

PROMPT Creating Primary Key on 'LINE'
ALTER TABLE LINE
 ADD CONSTRAINT LI_PK PRIMARY KEY 
  (ID)
/

PROMPT Creating Primary Key on 'STATION'
ALTER TABLE STATION
 ADD CONSTRAINT ST_PK PRIMARY KEY 
  (ID)
/

PROMPT Creating Primary Key on 'STATION_NODE'
ALTER TABLE STATION_NODE
 ADD CONSTRAINT SL_PK PRIMARY KEY 
  (ID)
/

PROMPT Creating Unique Keys on 'STATION_NODE'
ALTER TABLE STATION_NODE 
 ADD CONSTRAINT SL_UK UNIQUE 
  (ST_ID
  ,ORDINAL
  ,LI_ID)
/
  
PROMPT Creating Check Constraints on 'LINE'
ALTER TABLE LINE
 ADD CONSTRAINT LINE_CK CHECK (COLOUR != 'PUCE')
/
  
PROMPT Creating Foreign Keys on 'LINE_SEGMENT'
ALTER TABLE LINE_SEGMENT ADD CONSTRAINT
 LS_SL_FK_FROM FOREIGN KEY 
  (FROM_NODE) REFERENCES STATION_NODE
  (ID) ON DELETE CASCADE ADD CONSTRAINT
 LS_SL_FK_TO FOREIGN KEY 
  (TO_NODE) REFERENCES STATION_NODE
  (ID) ON DELETE CASCADE
/

PROMPT Creating Foreign Keys on 'STATION_NODE'
ALTER TABLE STATION_NODE ADD CONSTRAINT
 SL_LI_FK FOREIGN KEY 
  (LI_ID) REFERENCES LINE
  (ID) ADD CONSTRAINT
 SL_ST_FK FOREIGN KEY 
  (ST_ID) REFERENCES STATION
  (ID)
/