Commit graph

21 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
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
project-topaz
3df25d5215 Commits from upstream, 2020/01/14 to 2020/01/31 2020-01-31 17:43:44 -08:00
Topaz
aa6e168add Commits from upstream, 2019/12/11 to 2019/01/13 2020-01-13 10:25:10 -08:00
nfaletra
fd6141d245 Add EMobDifficulty and CheckMob
Clean up spots in code that call GetRealExp
Fix charm code to make more sense
Update exp_table
2020-01-12 20:48:00 -07:00
Autkast
283ca2259a Fix exp curve
Add Incredibly Easy Prey
Clean up /check code
2020-01-02 14:22:14 -07:00
Topaz
3eb1c1570f Remove DSP branding (copyright notices retained) 2019-12-02 12:40:02 -08:00
isotor
d758578f25 Minor changes to experience table based on wiki information 2019-05-03 20:22:23 +03:00
TeoTwawki
8209f73159 Line ends, round 2. Fight! 2016-01-16 01:26:33 -05:00
Ezekyel38
3f094d4bd3 MISSION: add condition for shadow lord
DB: add new item mods: yhel_jacket, yhel_jacket+1, searing_sash, hecate's_crown, lemegeton_medallion, lemegeton_medallion+1, vivid_strap, vivid_strap+1, Apollo's Ring, Aquilo's Ring, Auster's Ring, Jupiter's Ring, Neptune's Ring, Pluto's Ring, Terra's Ring, Vulcan's Ring (thx Racsr), update xp table (thx Racsr)
2013-01-03 20:57:16 +00:00
onetimeffxi
7a160120a7 2011-09-16 15:56:24 +00:00