[imp] oracle_create script

[Hanser, Kevin]

Hmmm... interesting.  You're right, I left those out.  I was working
primarily off the mysql_create.sql script, since I knew other people were
using that script successfully w/IMP.  And the mysql_create.sql script
didn't have these constraints... does anybody know why?  Why would these be
needed w/oracle but not w/other sql databases?  Or are these type of
constraints not supported and/or not neccessary with MySQL?  (I know most of
nothing about MySQL, and only slightly more about oracle :)

Thanx

Kevin

-----Original Message-----
From: Hernan Morales [mailto:hernanm@la14.com]
Sent: Thursday, October 12, 2000 11:15 AM
To: Hanser, Kevin
Cc: imp
Subject: RE: [imp] oracle_create script


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

-- 
IMP mailing list: http://horde.org/imp/
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: imp-unsubscribe@lists.horde.org