Pre-2005 exp_base table reconstructed from wiki sources

[eyes-and-brain]

Background

The repository already has modules/wotg/sql/2007_exp_tables.sql, which restores the pre-2011-02-15 experience gain table. I noticed there is no equivalent file for the exp_base table (required EXP per level), which was also changed in the April 2005 version update.

That update significantly reduced the required experience points for levels 51–75. Without a corresponding SQL file, there is no way to restore the pre-patch state for era-accurate setups.

Reconstruction

I reconstructed the pre-2005-04-21 exp_base values from the FFXIclopedia wiki article on Experience Points, which documents both the old and new NEXT EXP values alongside a difference column.

Verification:

• The cumulative difference column in the wiki matched the difference between the old NEXT values and the current exp_base.sql exactly across all levels
• Lv1–51 are identical to the current values and require no changes
• Only Lv52–75 differ (24 rows)

A few data points to illustrate the scale of the change:

Level	Pre-2005 NEXT	Post-2005 NEXT
55	20,000	12,800
60	20,000	18,800
65	34,000	26,000
75	44,000	44,000 (same)

SQL

-----------------------------------
-- exp_base: pre-2005-04-21 version
-- Source: FFXIclopedia wiki - Experience Points
-- Note: Lv1-51 are identical to current values.
-----------------------------------
UPDATE exp_base SET exp = 17800  WHERE level = 52;
UPDATE exp_base SET exp = 28800  WHERE level = 53;
UPDATE exp_base SET exp = 41800  WHERE level = 54;
UPDATE exp_base SET exp = 57800  WHERE level = 55;
UPDATE exp_base SET exp = 77800  WHERE level = 56;
UPDATE exp_base SET exp = 97800  WHERE level = 57;
UPDATE exp_base SET exp = 117800 WHERE level = 58;
UPDATE exp_base SET exp = 137800 WHERE level = 59;
UPDATE exp_base SET exp = 157800 WHERE level = 60;
UPDATE exp_base SET exp = 177800 WHERE level = 61;
UPDATE exp_base SET exp = 207800 WHERE level = 62;
UPDATE exp_base SET exp = 238800 WHERE level = 63;
UPDATE exp_base SET exp = 270800 WHERE level = 64;
UPDATE exp_base SET exp = 303800 WHERE level = 65;
UPDATE exp_base SET exp = 337800 WHERE level = 66;
UPDATE exp_base SET exp = 372800 WHERE level = 67;
UPDATE exp_base SET exp = 408800 WHERE level = 68;
UPDATE exp_base SET exp = 445800 WHERE level = 69;
UPDATE exp_base SET exp = 483800 WHERE level = 70;
UPDATE exp_base SET exp = 522800 WHERE level = 71;
UPDATE exp_base SET exp = 562800 WHERE level = 72;
UPDATE exp_base SET exp = 603800 WHERE level = 73;
UPDATE exp_base SET exp = 645800 WHERE level = 74;
UPDATE exp_base SET exp = 688800 WHERE level = 75;

Proposed location

modules/era/sql/2002_exp_base.sql

Source

FFXIclopedia wiki — Experience Points article
(The article explicitly documents the pre-2005-04-21 NEXT EXP table with difference values, making reconstruction straightforward and verifiable.)