![]() |
Database topology
One issue that will develop is the usage of mySQL users and databases. My current thinking is as follows:
databases: master site db-- contains user info, preferences, master for starting templates for new sites, site list, and such board db--contains this discussion board session db--if implemented, will be used in keeping track of users online, when last online, etc. Basicly non-critical info related to users and/or viewers site db--one for each site. contains template/style info, user style preferences, news content, articles, screenshot db,etc. There will be a master account with access to all related databases which administration code will use to set up sites and gather data. There will be an account to handle user management, and such with access to the board and session dbs, master site db, and probably the site dbs. There will be a board account with board db and session db access, and read-only access to parts of the master db. There will be an account for each site with access to its own site db, session db, and read-only access to parts of the master db. The intention of this setup is to minimize risk of one part of the network messing up another part. This is in no way set in stone, and I would like advice. |
Well, as you know im not very... smart concerning mySQL databases... but I think that there possibly should be a database storing all the codes, pics, reviews, etc (so you can add/modify content in a manager like what phpNuke uses)
|
Uh, taco, you were un-invited for a reason. While this is all very exciting, your input is of limited usefullness. I would very much apreciate it if you'd just keep your mouth shut unless you have anything of particular usefulness to say.
|
All times are GMT -6. The time now is 06:15 AM. |
Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
This site is best seen with your eyes open.