[imp] oracle_create script
Hernan Morales
hernanm@la14.com
Thu, 12 Oct 2000 10:14:38 -0500 (COT)
Hi. Mr. Hanser..
The original oracle_create script has any additional statements that you didn't
use. These statements are:
ALTER TABLE IMP_ADDR ADD (
CONSTRAINT PK_IMP_ADDR
PRIMARY KEY (USERNAME,
ADDRESS)
);
ALTER TABLE IMP_PREF ADD (
CONSTRAINT PK_IMP_PREF
PRIMARY KEY (USERNAME)
);
ALTER TABLE IMP_ADDR ADD (
CONSTRAINT FK_PREF_ADDR
FOREIGN KEY (USERNAME)
REFERENCES IMP_PREF (
USERNAME)
)
I think it would be important include them in your script because these
statements are granting the database referential intregrity.
Do you think this might be in the final oracle_create.sql??
Bye..
Hernan Morales
Servicios Internet
Almacenes La 14
Cali - Colombia
hernanm@la14.com