I Want to be a DB editing freak !

[Wumpas]

Well I feel a bit more releaved heh

I learned alot about the database today and thanks to all the commands above by vbemos I acomplished alot for 1 day I think

Really all I did so far was set up a database that drops all the tables if they exist and starts clean and I used the db.sql for most of the creation strings I then went through TCSMyworld, Myras, 0.5.2-Update, latest dumpeditems and pasting them together with a TON of scrolling back and forth

Note: Also through in some fixes from the community like the object fix by Kroeg to fix the forge bag issues. (Before I release this im going to change all those values the right was ad delete the replace strings)

Im going to redue much of it tommorow and try to get my shopkeepers/bankers working My goal was a complete DB with Full shopkeepers from TCS as many spawns as I could get from Myras and movment to be added by me empty grid table (another fun project for me to do!)

Im not sure what tables could be causing merchants/bankers to tell me in not in the magician class guild any thoughts?

When I get to the point where I learned what I will from It ill try to post it if it is mostly functional

Also I am going to start editing zone points they are mostly corect or ballpark, but a few oddballs in the mix.

<note I have no idea how to post it as It is 32MB in size so far ! Ill zip it once I finish with it and see from there>

These are the tables I have so far am I missing any?

aa_timers
acount
altadv_vars
books
bugs
character_
character_backup
city_defence
class_skill
doors
eventlog
faction_list
faction_values
forage
grid
ground_spawns
guild_aliances
guild_controllers
guilds
hackers
items
lootdrop
lootdrop_entries
loottable
loottable_entries
merchantlist
name_filter
npc_faction
npc_faction-entries
npc_spells
npc_spells_entries
npc_types
object
object_contents
petitions
pets
player_corpses
player_corpses_backup
sharedbank
spawn2
spawnentry
spawngroup
start_zones
starting_items
trader
tradeskillrecipe
variables
zone
zone_points
zone_server
zone_state_dump
zonepoints_raw
zoneserver_auth

I think i got a basic handle on the tables and functions of them but How do i figure out what each field means? and in defining them what things like in(11) mean?

Thank you for the help