Commit graph

17 commits

Author SHA1 Message Date
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
Zach Toogood
27143ec89b [login] Update features with new mog wardrobes 2022-02-10 17:57:07 +02: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
Mark Klara
9941d4874f
Rename email fields in accounts.sql for clarity
We plan to update xiloader to support adding emails. Currently there are two email fields, but it's not clear what gets stored in which.

Update `email` to `current_email`. This can store the users latest email, in case it changed. Or an empty string if they never provided an email.

Update `email2` to `registration_email`. This should store the email the user used during the account creation process (if any).

NOTE: If you have an existing `accounts` table, you shouldn't re-run this command as it will drop the existing table. Instead you can update your table by using the following commands in MySQL:

ALTER TABLE accounts CHANGE email current_email varchar(64);
ALTER TABLE accounts CHANGE email2 registration_email varchar(64);

fixes #6369
2020-01-12 11:48:55 -08:00
Topaz
3eb1c1570f Remove DSP branding (copyright notices retained) 2019-12-02 12:40:02 -08:00
Zynjec
973437a1ed Enable all expansions and features by default.
Also returned some documentation on how to calculate their values.
2017-11-18 14:28:39 -05:00
Zynjec
102388c2e9 Store expansions/features bitmask in account table. 2017-10-03 01:02:56 -04:00
whasf
16479dbfbf DATABASE: Add fields for email addresses for accounts table [dspweb]
WARNING: If you blindly import this table into an existing and populated database you *will* loose all your account information! Either modify the table structure manually or back up & restore your data from this table!
2013-03-27 22:58:20 +00:00
diatanato
ec1312842c Transport : beta-version of Airships system 2012-01-05 10:12:27 +00:00
onetimeffxi
7a160120a7 2011-09-16 15:56:24 +00:00