-- 
-- Vangtech NZ — MySQL Schema
-- Generated: Wed, 09 Sep 2026 06:04:15 GMT
-- https://vangtech.nz

CREATE TABLE IF NOT EXISTS `players` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `citizenid` VARCHAR(50) NOT NULL,
    `license` VARCHAR(255) NOT NULL,
    `name` VARCHAR(255),
    `money` JSON,
    `charinfo` LONGTEXT,
    `job` LONGTEXT,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;