WinterSolstice8
6a5f599a07
Add more missing Blu traits ( #9290 )
...
* [sql] Add missing BLU Undead Killer traits
* [sql] Add missing BLU MAB traits
* [sql] Add missing BLU Magic Burst Bonus trait
* [sql] Add missing BLU MDB traits
* [sql] Add missing JP bonus Rapid Shot trait for BLU
* [sql] Add missing JP bonus BLU Resist Gravity traits
* [sql] Add missing BLU Resist Sleep traits
* [sql] Add missing BLU Skillchain Bonus traits
2026-01-29 17:40:30 +01:00
WinterSolstice8
3df1f8719d
[sql] Add missing BLU Plantoid Killer traits
2026-01-29 08:21:45 -07:00
WinterSolstice8
060e86fbb6
[sql] Add missing BLU Lizard Killer traits
2026-01-29 08:21:45 -07:00
WinterSolstice8
525645f0c0
[sql] Add missing BLU Beast Killer traits
2026-01-29 08:21:45 -07:00
WinterSolstice8
44fe2cf969
[sql] Add missing BLU Fast Cast traits
2026-01-29 08:21:45 -07:00
WinterSolstice8
ad42b27045
[sql] Add missing BLU Evasion Bonus traits
2026-01-29 08:21:45 -07:00
WinterSolstice8
00951612b4
[sql] Add missing BLU Dual Wield traits
2026-01-29 08:21:45 -07:00
WinterSolstice8
abcaf7716e
[sql] Add missing BLU Defense Bonus traits
2026-01-29 08:21:45 -07:00
WinterSolstice8
8a9e1930ee
[sql] Fix Max HP boost trait point values
2026-01-29 08:21:45 -07:00
WinterSolstice8
e9cbe28f78
[sql] Add missing BLU counter traits
2026-01-29 08:21:45 -07:00
WinterSolstice8
672aee051b
[sql] Add mising BLU Conserve MP traits
2026-01-29 08:21:45 -07:00
WinterSolstice8
86937f1776
[sql] Fix & add BLU Clear Mind traits
2026-01-29 08:21:45 -07:00
WinterSolstice8
b7600527af
[sql] Add JP only BLU regen traits, add comment/fix with auto refresh
2026-01-29 08:21:45 -07:00
WinterSolstice8
2500576d97
[sql] Add missing BLU Attack Bonus traits
2026-01-29 08:21:44 -07:00
WinterSolstice8
14eb86da7f
[sql] Add missing Accuracy Bonus traits for BLU
2026-01-29 07:59:04 -07:00
WinterSolstice8
ecd491a0da
[sql] Fix BLU Treasure Hunter/Gilfinder trait
2026-01-28 16:54:29 -07:00
WinterSolstice8
57908cf315
[sql] Add blue mage Store TP 3-5 traits
2026-01-28 16:54:24 -07:00
WinterSolstice8
ba068604cc
[sql] Adjust ranks of Blue Magic traits to match normal ones
2026-01-28 16:48:23 -07:00
WinterSolstice8
1491ee68e7
[sql] Audit BLU trait values
2026-01-28 16:48:15 -07:00
WinterSolstice8
7150810579
[sql] Add Job Point plumbing to blue traits sql
...
Also annotate existing traits
2026-01-28 16:47:57 -07:00
sruon
740bee77c9
MAX_HP_BOOST trait
2025-10-07 16:46:36 -06:00
MowFord
201540e66a
Trait mod fixes:
...
rapid shot (was bp_delay)
evasion bonus (was rdef)
mag. burst bonus (was UFASTCAST)
gilfinder wasn't being added with TH
2024-04-23 16:42:09 -05:00
Corey Sotiropoulos
f202e592e7
[sql] Speed up Aria table inserts
...
See:
https://mariadb.com/kb/en/aria-storage-engine/
2024-01-11 22:33:23 -05:00
Zach Toogood
24f35c4c5e
[sql] Replace MyISAM engine with Aria
2024-01-04 18:43:36 +00:00
Zach Toogood
ca3bdd22fe
[SQL] Add COLLATE=utf8mb4_general_ci to all tables
2024-01-04 18:25:12 +00:00
Corey Sotiropoulos
d92c54d1b4
[dbtool] Add function to dump DB to SQL files
...
Queries database then scans corresponding SQL file, replacing values
in INSERT statements with data from the database.
Is not smart about which INSERT statement gets which data; line-end
comments can get shuffled around if SQL file INSERTs are out of order
or missing. If you're doing INSERT or DELETE operations, make sure
to add a blank "INSERT INTO `table` VALUES ();" or manually remove
the INSERT statement respectively before dumping tables.
2023-08-23 22:50:08 -04:00
Zach Toogood
edc817a2d7
[db] Make all tables CHARSET=utf8mb4
2023-02-05 21:13:32 +00:00
Zach Toogood
05b1a7f961
[chore] Clean up some formatting in SQL files
2022-07-05 12:49:26 +03:00
TeoTwawki
dd02066118
Convert tables that are never written to back to MyISAM. Only tables we write to need InnoDB.
...
MyISAM = table level locking, fast but not safe for multiple simultaneous writes
InnoDB = row level locking, slow, but is safe for multiple simultaneous writes
```
Features MyISAM InnoDB
Type Non-Transactional Transactional
Locking Table locking Row-level locking
Foreign keys No Yes
Table, index, data storage Three separate files Combined Tablespace
ACID No Yes
```
2021-11-10 08:09:45 -05:00
TeoTwawki
2589da530c
Merge branch 'topaz' of https://github.com/DerpyProjectGroup/topaz into freedom
...
# Resolved Conflicts:
# sql/job_points.sql
2021-04-18 13:49:29 -04:00
Ixion
c460a89139
Ixion is Come!
...
- Rebranding.
- Migrate to GitLab.
- Add support for database updates when using Docker.
- Give purpose to version.h (adjust minor version with client updates).
- Add an in-game `!ver` command.
- Remove references to AGPL.
2021-04-17 18:24:14 -04:00
TeoTwawki
276cf1a095
Merge branch 'canary' of https://github.com/topaz-next/topaz into freedom
2021-04-10 22:55:57 -04:00
TeoTwawki
de3066a3cb
Remove even more banding references. The name "topaz" remains in places but all of "tpz" should be gone now.
2021-04-01 16:14:56 -04:00
Zach Toogood
9e4993893d
Migrate all SQL tables from MyISAM to InnoDB
2021-02-05 17:07:08 +02:00
Topaz
3eb1c1570f
Remove DSP branding (copyright notices retained)
2019-12-02 12:40:02 -08:00
TeoTwawki
8209f73159
Line ends, round 2. Fight!
2016-01-16 01:26:33 -05:00
atom0s
d91549b194
SQL: Changed all tables to use MyISAM for much improved import / query times.
...
SQL: Changed all tables to use the charset of utf8.
2014-01-09 03:20:52 +00:00
teschnei
5efe0a0596
CORE: redid traits to only add the highest rank trait, added traits from set blue mage spells
...
SQL: corrected accuracy bonus giving ranged defense for dancer and dragoon, added many missing trait ranks to puppetmaster, ninja, dancer
2013-07-22 05:20:25 +00:00
deviltti
677eb53dfc
SQL: Added BLU traits to Lv. 99.
...
TODO: Locate mob_skill_id for records with temporary values of '0' in blue_spell_list. Will also require new spells and level requirements to be added to spell_list, and additions to mob_skill.
2013-07-13 23:36:44 +00:00
teschnei
e9e4af8c06
SQL: blue_traits table filled in
2013-07-06 01:22:39 +00:00
teschnei
db338f317d
DATABASE: added a table for blue magic traits via setting spells. Going to need an enum with trait categories before any work can be done on it
2013-02-06 01:15:43 +00:00
