mmo-ref/landsandboat
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
41844 commits 75 branches 0 tags 1.3 GiB
Commit graph

15 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
Zach Toogood
edc817a2d7 [db] Make all tables CHARSET=utf8mb4 2023-02-05 21:13:32 +00: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
Zach Toogood
748dddf705 [sql] Convert MyISAM tables to InnoDB (covered by existing migration) 2021-06-19 13:32:43 +03:00
TeoTwawki
19cdd5550d remove line breaks and tabs from sql rows 2021-04-18 13:46:42 -04:00
claywar
103bd18c33 [Job Points] Cleanup, add map_config capacity_rate 2021-04-17 18:33:07 -04:00
claywar
40bda8f8c5 [Job Points] SQL, Build, and Migration Scripts 2021-04-17 18:33:07 -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
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
Topaz
3eb1c1570f Remove DSP branding (copyright notices retained) 2019-12-02 12:40:02 -08:00
TeoTwawki
7961a0fb71 Redumped job_points.sql after fixing its problems. Should now import all sql tools on all platforms. 2016-05-03 02:25:02 -04:00
some1here
cb8c1fd973 Removed avatar/ 2016-04-10 11:38:16 -06:00
some1here
460b2c0896 Sql job_points 
from windower
 2016-04-09 14:05:47 -06:00