Hello everyone.
Imagine:
- We have some promo-sites on one hosting.
- Using Yii Framework.
- All sites will have (more or less) same models (MVC) like: NEWS, FEEDBACKS, PHOTOS (in gallery), FAQ, CONTACTS, PERSONS, etc..
So what i want to ask? - How better store data of models in single table with a specific [B]key[/B] which be used for relating to site e.g:
Model: NEWS
+--------+---------+-------------+
+ id | title | site_id |
+--------+---------+-------------+
+ 1 | Sale!!! | candy_shop | of course
+--------+---------+-------------+ site id will
+ 2 | Hello w. | fitness_serv. | int. too.
+--------+---------+-------------+ it's just for visualize
+ 3 | asdasd | candy_shop |
+--------+---------+-------------+
OR maybe better do in separated based?
how u think?
I don't see why you can't use several databases for this. It's a simpler approach because sites don't need to be aware of each other.
Sorry, you need to Log In to post a reply to this thread.