Zelaron Gaming Forum  
Stats Arcade Portal Forum FAQ Community Calendar Today's Posts Search
Go Back   Zelaron Gaming Forum > Zelaron Gaming > General Gaming

 
 
Thread Tools Display Modes

 
Post Database topology
Reply
Posted 2003-01-08, 02:05 PM
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.
Old
Profile PM WWW Search
WetWired read his obituary with confusionWetWired read his obituary with confusionWetWired read his obituary with confusionWetWired read his obituary with confusion
 
 
WetWired
 



 
Reply
Posted 2003-01-08, 02:10 PM in reply to WetWired's post "Database topology"
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)
Old
Profile PM WWW Search
tacoX is neither ape nor machine; has so far settled for the in-betweentacoX is neither ape nor machine; has so far settled for the in-between
 
 
tacoX
 



 
Reply
Posted 2003-01-08, 02:16 PM in reply to WetWired's post "Database topology"
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.
Old
Profile PM WWW Search
WetWired read his obituary with confusionWetWired read his obituary with confusionWetWired read his obituary with confusionWetWired read his obituary with confusion
 
 
WetWired
 



 

Bookmarks

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

Posting Rules [Forum Rules]
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -6. The time now is 02:34 AM.
'Synthesis 2' vBulletin 3.x styles and 'x79' derivative
by WetWired the Unbound and Chruser
Copyright ©2002-2008 zelaron.com
Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
This site is best seen with your eyes open.