Aeshur
a5cd5e8ebc
[sql] Correct Kilicbaligi fish size
2025-01-23 18:36:24 -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
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
Xaver-DaRed
bda9557f2b
Database: Remove old tables and add new ones
2022-05-18 02:03:17 +02: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
9263c73d10
Redump some SQL tables to fix formatting nonsense. No code changed no comments lost.
2018-04-03 17:41:42 -04:00
TeoTwawki
8209f73159
Line ends, round 2. Fight!
2016-01-16 01:26:33 -05:00
PrBlahBlahtson
4f17f1c285
SCRIPTS: Fixed getMidnight returning the wrong time (for realsies this time)
...
DATABASE: A few missing values in fishing_fish.sql
2013-03-11 20:02:09 +00:00
diatanato
db536e5c3f
CORE: lets try fishing Hydrogauge for Navigating_the_Unfriendly_Seas (need test)
2013-03-11 08:08:51 +00:00
onetimeffxi
7a160120a7
2011-09-16 15:56:24 +00:00
