This script ran fine until it got to the end where some foreign keys are
being created
alter table pingtarget add constraint pingtarget_websiteid_fk
foreign key (websiteid) references website(id);
alter table autoping add constraint autoping_websiteid_fk
foreign key (websiteid) references website(id);
alter table autoping add constraint autoping_pingtargetid_fk
foreign key (pingtargetid) references pingtarget(id);
alter table pingcategory add constraint pingcategory_autopingid_fk
foreign key (autopingid) references autoping(id);
alter table pingcategory add constraint pingcategory_categoryid_fk
foreign key (categoryid) references weblogcategory(id);
I get error 1005 from mysql. Google yielded a tip that an index should
be on the field before trying to create the foreign key. Using the first
alter table statement as an example, would that mean that an index needs
to be created on website(id)?
----
Charles H. Baker
O: 864.422.5349 C: 864.201.8456
[EMAIL PROTECTED]
There's nothing wrong with getting a steady paycheck, unless it
interferes with your ability to earn what you're worth. There's the rub.
It usually does. -- T Harv Eker
