Table Hit List

[xackery]

I'm thinking I'll make a few tables:
[√] character_graph_data <-- hourly snapshot of various char data like exp,aaexp gain
[ ] character_achievement <-- achievement system, based on magelo's
[√] xegony_errors <-- stores errors in a logfile that auto truncates entries excess 30 days
xegony_audit <-- stores unique scope:term entries of malformed data (like a merchantlist entry not used by an npc, or an itemid in a merchant that isn't a real item, etc.
[11:05 AM] Shin: i need to add
guilds,
guildmembers,
[√] fishing,
[√] foraging
[ ] mail
[√] variables
[√] sharedbank
[√] rule
[√] hacker

aa
aa_ability
aa_ranks
aa_required_level_cost

aaentry

√ aa_ability
id
first_rank_id
√ aa_ranks
id (official rank id)
aa_required_level_cost
skill_id ? <-- actuall rank
aa_actions
aaid (link)
rank (pair with aaid)
aa_effects
id <-- i don't think this has any effect
aaid (link)
slot (must be unique?)
aa_rank_effects
rank_id (link?)
slot (must be unique)
effect_id (spell effect)
aa_rank_prereqs
aaid
rank_id
points (number of points to spend?)
ground_spawns, level_exp_mods maybe, mail, npc_emotes, spelleffects