Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-08-2005, 07:29 AM
Damilis's Avatar
Damilis
Hill Giant
 
Join Date: Dec 2002
Location: Nottingham!!
Posts: 217
Question db schema

Anyone have a db schema for 6.2 in .jpg/.gif/png format?

Additionally, how useful would schema for all the db's, say from 5.0 to current, be to everyone?
__________________
GM/ServerOP - Shadows of Norrath

Last edited by Damilis; 09-13-2005 at 07:35 AM..
Reply With Quote
  #2  
Old 09-08-2005, 01:46 PM
mystic414's Avatar
mystic414
Hill Giant
 
Join Date: Sep 2004
Posts: 100
Default

This is the most informative thing i've found: http://www.eqemulator.net/wiki/wikka...=EQEmuDBSchema
__________________
The PEQ Database Editor is available!
Edit Loot, NPCs, Spawns, Merchants, Factions, NPC Spell Lists, and Tradeskills with ease!
Check it out!
Reply With Quote
  #3  
Old 09-09-2005, 12:59 AM
Damilis's Avatar
Damilis
Hill Giant
 
Join Date: Dec 2002
Location: Nottingham!!
Posts: 217
Default Kinda

Yeah i saw that on the wiki, but what i am looking for is a way to compare, say a 0.6.1 db to an equivilent 0.6.2 db so i can see if there are any formatting/data changes. This way, i can create a converter to add/append/change a heavily customized 0.6.1 db to a 0.6.2 db without losing the customization.
Now granted, i just jumped back into the eqemu thing after a year or two off and there may very well be ablsolutely no difference between a 0.6.1 db and a 0.6.2, but if memory serves me correctly, past trends say there is.

Second question, is there a blank 0.6.2 db from the devs floating about, or is the velious rc-1 from peq pretty much it for 0.6.2 dbs?
__________________
GM/ServerOP - Shadows of Norrath

Last edited by Damilis; 09-13-2005 at 07:35 AM..
Reply With Quote
  #4  
Old 09-09-2005, 10:27 AM
mystic414's Avatar
mystic414
Hill Giant
 
Join Date: Sep 2004
Posts: 100
Default

Any modifications to the database are recorded in the changelog in cvs. you can check there for what you're trying to do
__________________
The PEQ Database Editor is available!
Edit Loot, NPCs, Spawns, Merchants, Factions, NPC Spell Lists, and Tradeskills with ease!
Check it out!
Reply With Quote
  #5  
Old 09-10-2005, 03:53 AM
fathernitwit
Developer
 
Join Date: Jul 2004
Posts: 773
Default

we keep track of changes made to the database between PEQ releases in our compatibility posts on PEQ forums:
http://www.projecteq.net/phpBB2/viewforum.php?f=2

this is prolly your best reference. Otherwise, as mystic stated, the changelog is the only place.
Reply With Quote
  #6  
Old 09-10-2005, 04:02 AM
Damilis's Avatar
Damilis
Hill Giant
 
Join Date: Dec 2002
Location: Nottingham!!
Posts: 217
Talking Thx

Beauty! Thanks a bunch
__________________
GM/ServerOP - Shadows of Norrath

Last edited by Damilis; 09-13-2005 at 07:36 AM..
Reply With Quote
Reply


Posting 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 -4. The time now is 05:24 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3