[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