summaryrefslogtreecommitdiff
path: root/sql-files
AgeCommit message (Collapse)AuthorFilesLines
2015-03-09ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-03-05ItemDB SQL SyncHercules.ws1-9/+562
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-02-15ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-02-15ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-01-25ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2015-01-22Removed name distinction between (sql) mob/item/mob_skill db and db_re variantsHaru3-8349/+8349
- Since there (currently and in future) is no difference between the table structure for renewal and pre-renewal databases, it makes no sense to have extra code that makes a distinction between their names. A server will always use either one or the other, never both at the same time. - If you have a mob_db_re, mob_skill_db_re and/or item_db_re table, please rename it to mob_db, mob_skill_db and/or item_db_re, respectively. - No upgrade script provided. I'd like to remind everyone that these tables are optional (and deprecated), and they are only offered for convenience for those who need them for web control panels and similar software. Signed-off-by: Haru <haru@dotalux.com>
2015-01-10ItemDB SQL SyncHercules.ws1-1/+10
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-12-28Split mob sql database into mob_db and mob_db_re.malufett2-6/+6
-http://hercules.ws/board/topic/8084-separate-the-mob-db-and-mob-db-re/
2014-12-07ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-11-07ItemDB SQL SyncHercules.ws2-6/+9
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-11-04ItemDB SQL SyncHercules.ws1-0/+3
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-11-04Added missing sql_updates query in main.sqldastgir1-0/+1
2014-11-03ItemDB SQL SyncHercules.ws2-4/+6
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-11-03Follow up 239d480487e24294975f35ed55f210837ad1088eshennetsind1-0/+1
Added missing sql upgrade index entry Signed-off-by: shennetsind <ind@henn.et>
2014-11-03Merge branch 'master' of github.com:HerculesWS/Herculesshennetsind2-90/+107
Signed-off-by: shennetsind <ind@henn.et> Conflicts: src/map/battle.c
2014-11-03Introducing 2014-10-22, Roulette and Per-Char Gender!shennetsind2-0/+4
Details in http://hercules.ws/board/topic/7618-2014-10-22-roulette-and-per-char-gender/ Special Thanks to the all-mighty Yommy, Ziu and Haruna! Signed-off-by: shennetsind <ind@henn.et>
2014-11-02ItemDB SQL SyncHercules.ws2-88/+88
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-10-30ItemDB SQL SyncHercules.ws1-1/+18
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-10-30ItemDB SQL SyncHercules.ws1-3/+3
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-10-24ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-09-20ItemDB SQL SyncHercules.ws2-34/+34
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-09-20Re-generated mob_skill_db_re.sqlHaru1-7420/+7031
Signed-off-by: Haru <haru@dotalux.com>
2014-09-16Merge pull request #333 from dastgir/SQLFixMichieru3-3/+10
Fixes wrong data type in SQL for base_exp,base_drop and base_death.
2014-09-04ItemDB SQL SyncHercules.ws2-68/+68
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-09-02Fixes wrong data type in SQL for base_exp,base_drop and base_death.Dastgir3-3/+10
2014-09-01Re-generated SQL mob databasesHaru6-7484/+8174
Signed-off-by: Haru <haru@dotalux.com>
2014-08-31ItemDB SQL SyncHercules.ws1-1/+1
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-08-29ItemDB SQL SyncHercules.ws2-34/+34
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-08-08ItemDB SQL SyncHercules.ws1-7/+7
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-08-08ItemDB SQL SyncHercules.ws1-7/+7
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-08-07ItemDB SQL SyncHercules.ws1-9/+9
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-08-06ItemDB SQL SyncHercules.ws1-9/+9
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-07-22Update rAthena-main-upgrade.sqljaBote1-9/+43
Updating to adapt the database from current latest rAthena server. Couldn't test since I haven't got a test database right now, but looks good enough. Any issue should happen with it, please address me at Hercules forums rather than here.
2014-07-22Update rAthena-logs-upgrade.sqljaBote1-4/+13
2014-07-17Fixed minor issues in the sql files from 3ecf877bHaru2-29/+29
Signed-off-by: Haru <haru@dotalux.com>
2014-07-10Updated sql-upgrade files.Shido25-225/+242
2014-07-10Organized sql-tools.Shido3-34/+34
2014-07-10SQL Re-Organization.Shido8-1051/+1080
Signed-off-by: KeiKun <the.keikun@gmail.com>
2014-06-26ItemDB SQL SyncHercules.ws1-2/+2
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-06-26ItemDB SQL SyncHercules.ws1-57/+57
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-06-18ItemDB SQL SyncHercules.ws1-11/+11
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-31Removed Quotes from mob_skill_db.sql and mob_skill_db_re.sqlDastgir Pojee2-12374/+12374
This fixes Error Code #1064 (Reference: http://hercules.ws/board/topic/5802-mysql-mob-skill-dbsql/) Also saves a bit CPU load to convert quotes to numbers.
2014-05-31ItemDB SQL SyncHercules.ws3-14445/+14472
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-31ItemDB SQL SyncHercules.ws3-84/+99
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-23Update rAthena-main-upgrade.sqljaBote1-0/+5
Following up 3591de7e7ac2db4e3eeaa9bad2615648e7f94b3a. Upgrader should be up to date as of now.
2014-05-18Follow-up 5f5380e and a42f880e, Fixed crappy coding with sql-update ↵Shido1-1/+1
file(Special thanks to QQfoolsorellina)
2014-05-17Follow-up to 5f5380e8d5fa2e6042813e35101cb33b656e3972Haru1-1/+1
- Fixed a missing semicolon in the upgrade script. Special thanks to QQfoolsorellina Signed-off-by: Haru <haru@dotalux.com>
2014-05-17ItemDB SQL SyncHercules.ws1-1394/+1538
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
2014-05-17Renamed incuvate of Pet System.Shido3-1/+6
2014-05-13Fixed some charset issuesHaru1-1/+1
- Fixed files with mixed character set or invalid CP949 characters. - Uncommented '#music' script in the_sign_quest.txt (now the soundeffect filename should be fixed). - Added a note to the header of CP949 files not to read or save them as UTF8, since it'd break their encoding. It should be safe enough to read them as EUC-KR if your text editor doesn't offer CP949 as an option. - Added FIXME notes about untranslated strings in assassin_skills.txt and WolfchevLaboratory.txt. Signed-off-by: Haru <haru@dotalux.com>