[ASK]Database Structure

[noobsee]

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? 

 

[Emistry]

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.

 

[noobsee]

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 

 

[Emistry]

double check your settings.

https://github.com/HerculesWS/Hercules/blob/master/conf/inter-server.conf

 

[noobsee]

 

double check your settings.

https://github.com/HerculesWS/Hercules/blob/master/conf/inter-server.conf

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?

 

[Dastgir]

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.

 

[noobsee]

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.