Module B9 · Migrations & identity

Multi-character and identity systems

Identity is the spine of a roleplay server: who is this player, which character are they on, and what belongs to that character. Every other script, money, inventory, jobs, keys off the character identifier, so if the identity layer is wrong, everything downstream is wrong. This lesson builds a tiny identity store you can run, then takes it apart so you understand the model instead of trusting a framework blindly.

You'll build: A server resource named qu_identity that maps one license to two characters and proves money belongs to the character, not the account.
Time: ~25 minutes.
You need: A framework server, MariaDB wired to oxmysql, and the database lessons.
You'll learn: FiveM identifiers and why license: is the anchor -> the two-table account/character model -> how a framework loads a character on selection -> why keying money on the wrong column shares it across characters.

BEFORE YOU START

Build it

This is a server-only resource. There is no client file and no F8 output: identity lives entirely on the server, against the database, which is the whole point. You will run one command in the server console and read the proof there.

Make the resource folder

The server has one folder for this lesson.

Inside your server's folder, create this folder:

Multi-character and identity systems

Build it

Make the resource folder

Create the files

Write fxmanifest.lua and the tables

Write the lesson code

Start and test it

Keep reading the full lesson