Jump to content
  • 0
noobsee

[ASK]Database Structure

Question

Hi,
I am using:

 - Windows 8.1 (64 bit)

 - XAMPP (Mysql version 14.14)


I just checked out Hercules from:

https://github.com/HerculesWS/Hercules.git

 

and then I tried to install it and imported most of the .sql files (I didn't import all of them, because it's simply too confusing, too many duplicate and error table).

 

I recompiled the solution using VS 2013, and ran the run-server.bat.
Everything just fine, until I tried to login to character selection...the char server crashed!!. Maybe it's related with my database..

 

So, after imported the sql files:

 

- main.sql
- item*.sql
- mob*.sql
- logs.sql

 

I got this structure on my Ragnarok database:

 

 

- account_data

- acc_reg_num_db

- acc_reg_str_db

- auction

- autotrade_data

- autotrade_merchants

- cart_inventory

- char

- charlog

- char_reg_num_db

- char_reg_str_db

- elemental

- friends

- global_acc_reg_num_db

- global_acc_reg_str_db

- global_reg_value

- guild

- guild_alliance

- guild_castle

- guild_expulsion

- guild_member

- guild_position

- guild_skill

- guild_storage

- homunculus

- hotkey

- interlog

- inventory

- ipbanlist

- item_db

- item_db2

- login

- mail

- mapreg

- memo

- mercenary

- mercenary_owner

- mob_db

- mob_skill_db

- npc_market_data

- party

- pet

- quest

- ragsrvinfo

- sc_data

- skill

- skill_homunculus

- sql_updates

- storage

 

and this as Log database:

 

- atcommandlog
- branchlog
- chatlog
- loginlog
- mvplog
- picklog
- zenylog

 

The latest update in trunk/sql-files/upgrades is this file

 

2015-08-27--20-42.sql
 
along with:
- eathena-upgrade.sql
- rAthena-logs-upgrade.sql
- rAthena-main-upgrade.sql
 
Are those correct structure?
Don't we have a single main.sql with all the latest tables (including their structure) ? So, I don't need to import the sql files updates manually.
Or could anyone give me the dump sql files for working database? 
Edited by noobsee

Share this post


Link to post
Share on other sites

6 answers to this question

Recommended Posts

  • 0

you're doing a fresh installation, there's no need to execute any SQL inside the upgrades folder.

 

both main.sql and log.sql is more than enough.

Share this post


Link to post
Share on other sites
  • 0

you're doing a fresh installation, there's no need to execute any SQL inside the upgrades folder.

 

both main.sql and log.sql is more than enough.

 

Hi, 

It doesn't seems it work, I got this error when running the server using the default .sql file (main.sql and log.sql):

 

: DB error - Table 'ragnarok.loginlog' doesn't exist
[Debug]: at ..srcloginloginlog_sql.c:84 - INSERT INTO `loginlog`(`time`,`ip`,
 

 

and 

Share this post


Link to post
Share on other sites
  • 0
 

 

Oh, man, 
I didn't see that, I used eAthena before, and I haven't see this file.

Anyway, it works now, 

So, furthermore, 
for the upgrades files, how I am suppose to import it? I don't need it?

I want to run this server with Renewal and of course Job 3 and all the instances. Any tips or walkthrough on implementing the server?

Share this post


Link to post
Share on other sites
  • 0

You don't need to import upgrade file if its fresh installation, also , the server console will prompt you if any upgrade file is not imported(if any).

 

Default setting is renewal, so just compiling it and running would make it 3rd class and with all instances that's available to Hercules.

Share this post


Link to post
Share on other sites
  • 0

You don't need to import upgrade file if its fresh installation, also , the server console will prompt you if any upgrade file is not imported(if any).

 

Default setting is renewal, so just compiling it and running would make it 3rd class and with all instances that's available to Hercules.

 

Hey, 

Yep, the server is running now, but I got other issue, I posted it here: http://herc.ws/board/topic/10942-char-serverexe-crashed/

For brief, the issue is my char-server.exe crashes everytime user trying to get into character selection.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.