Commit graph

22 commits

Author SHA1 Message Date
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
hooksta4
c4f2d5a3a9 Update Ranger Archer + Marksmanship to A+ fixes issue #746 2021-12-22 20:44:21 -05: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
ibm2431
45bfc2d4f6
GEO SQL and Header changes (#689)
* GEO SQL and header files

* Spell list additions and cleanup

* Adjust automaton controller to use new effect enums
2020-06-06 02:48:43 +00: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
rimtice
aebcf11038 Update skill_ranks.sql
Changed skill ranks to match retail
2015-04-08 16:24:39 -05:00
teschnei
e73496bcce SQL: fix PUP hand-to-hand rank, Asuran Fists job requirements 2013-12-24 20:46:58 +00:00
xdemolish
a803c3aeab CORE / SQL / SCRIPTS: Added teleport effect so player is teleported once the animation has finished. All teleport/warp spells add the hidden effect and teleport the players once it wears. Escape spell zone checks moved to teleports.lua.
CORE: Updated capAllSkills to include blu and geomancy.
SCRIPTS: Updated @capskill command to include geomancy. Updated status.lua with Action IDs.

CORE / SQL: Added new column to skill_caps.
SQL: Added non-job-specific traits to Rune Fencer and Geomancer. Added weapon skills to Rune Fencer and Geomancer.
2013-12-01 20:45:07 +00:00
PrBlahBlahtson
9d145b6b3f SQL: Partial completion of Bug #475. DRG now has a B in Evasion and B- in Parrying. Game breaker right there, lemme tell you. 2013-06-04 03:53:04 +00:00
teschnei
aa61e583a2 PROJECT: merged 032713-Update to trunk 2013-03-31 19:22:04 +00:00
onetimeffxi
7a160120a7 2011-09-16 15:56:24 +00:00