PDA

View Full Version : Explain this for me please.


zooman
12-13-2005, 12:27 AM
Remember to prefix the table, if you do not know what is a prefix or
you don't use it then you can run the queries without any changes

--------------------------------------------------------

ALTER TABLE attachment add usedin varchar(30) not null;
ALTER TABLE attachment add itemid int not null;
ALTER TABLE pmtext add attach int not null;
ALTER TABLE attachment add index (usedin,itemid);

Can some one explain what a prefix is please?

And what it means by ?Remember to prefix the table? I would be very grateful if someone could show an eg.

Regards,
Zooman

HMBeaty
12-13-2005, 12:30 AM
prefix in your table meaning attachment would be in your table as "vb_attachment" or instead of "vb_", maybe you use something different. Thats basically all that means

zooman
12-13-2005, 12:48 AM
Thank you so much.

I had ran them without the prefix and was very confused when it was telling me

dbname.attachment did not exsit, I was even more worried when the attachments stopped working.

I was getting ready to reinstall forum.

Again thank you so much all working right now.