Life is Feudal Official Forum

[Java1970]

So I read that there are 3 .sql files that of importance.
- new.sql
- patch.sql
- dump.sql

I assume that the new.sql is the base sql file to initially populate the database tables and I wouldn't ever need to modify that.

What, however, is the difference between the dump and patch sql files?

I've read some posts saying to make this change you modify the patch.sql file and other posts saying to make this same change you modify the dump.sql file.

Hence my confusion on some of this stuff.

Any help on understanding the purpose and difference of these two files is greatly appreciated

[Azzerhoden]

When I want something to run on server startup (such as removing stumps and low quality trees) I make changes in patch.sql.

For those one time only changes - I just drop the SQL into the query window on Heidi.

[Sethturace]

hello, i did the same but the game (the server) cleans up 4 tables in the DB on startup and write the standard values into the tables, so i can not make changes to object_types or recipe_requirement.

do someone know why?

her is a part of the logfile:

Code: Select all

^CREATE TABLE IF NOT EXI
ECHO 2016-02-05 10:58:58.756 {02} <initServer> ### Patching database [2/2]...
WARN 2016-02-05 10:58:58.756 {02} <initServer> ### DB::noRS(0 ms) USE `lif_1`;
WARN 2016-02-05 10:58:59.115 {02} <initServer> ### DB::mNoRS(353 ms) /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

DELETE FROM `animal_breeds`;

DELETE FROM `objects_types`;

DELETE FROM `recipe`;

DELETE FROM `recipe_requirement`;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

[MacDante]

dump.sql is last sql run from SQL folder.

sql order run from sql folder:
1. new.sql (run anytime ahen db dont exist)
2. patch.sql (witch actual dews changes to new.sql)
3. dump.sql (with actual recipes and items in game)

dump.sql:
This SQL actualize all recipes and all items in a game. If you want change any type of this elements, you should change in this file, or make another file with changes, and any time when is patch you should copy and paste own changes on end of dump.sql file...

[Sethturace]

i will try it, thank you!

//edit: now it works