...

View Full Version : Referencial Integrity with Merges



mr_ego
08-01-2006, 05:17 AM
Referencial Integrity with Merges

I have two tables:



TABLE ONE:
product_id
product_name

TABLE TWO:
product_id
product_name


And I have One Merge:



MERGE TABLE:
product_id
product_name


All of which are in MyISAM.


My Question is, how do i keep the product_id index in the Merge table to be unique?

mr_ego
08-01-2006, 07:40 AM
Basically,


Is there a way which I can have (referring to PHP here):

OBJECT ONE
- OBJECT TWO
- OBJECT THREE

Where Object Two and Three EXTEND Object One

and object two and three both have unique ID numbers in the DB.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum