Can I add new MySQL tables to my vB3 Beta3 Database?
 

Okay ... sorry for the extremely newbie question here ... but I've been waiting ages for vB3 to finally get started on making the modifications on my site I've been wanting to do for AGES !!!

Anyhow, I want to be able to create a table for my 'world news' listing on my site's home page. I'd like it to have various fields like date, source_name, source_link, discuss_link, headline_content etc etc ...

I have many other table I want to use for other things related to both my site and it's forum, which is why I think it'd be best just to use one database (the one I'm using for vB3).

Anyhow ... 2 questions I guess ... is this posible, and is it the recommended approach ?

I want to be sure doing something like doesn't comprimise my forum's security and that it doesn't affect performance too much.

I've got tons of other ideas I want to impliment for my site using databases, but I figured I'd start with this one, as it would help me learn the basics one step at a time.

So basically, I know the vB3 RC1 will change the templates and stuff ... but am I correct in assuming the basic database structure won't be changing, and that any additional table(s) I might add shouldn't pose me any problems for future upgrades or for security?

Anyhow ... bla bla bla ... you guys are smart enough to know what I'm talking about by now ... any and all feedback will be greatly appreciated !!! :)

Just want to point out, that I'm not asking how to do this (although if anyone actually has the time ... then that would be great ... lol ... but I have my manuals to reference for now), I'm just looking for some experienced MySQL and PHP users to tell me I can proceed without expecting any major problems for my site and forum now or in the future because of these modifications !!! lol

OK ... anyways ... thanks again !!! :)

yes of course you can add tables yourself, and it won't break up vb's security and the performance is normally not a problem if your codes are written well :)

to avoid problems with future vb tables you can just use an easy trick and use a prefix for your main site tables:
main_news
main_news_category or somethin like :)