GCMod

Database

Database schema and migration notes for gcm_tattoos.


Tables

gcm_tattoos

  • Stores per-player owned tattoos.
  • Main columns:
    • identifier (VARCHAR(50), unique)
    • tattoos (LONGTEXT, JSON encoded, default [])

gcm_tattoos_locked

  • Stores tattoo lock rules by tattoo hash.
  • Main columns:
    • hash (VARCHAR(255), unique)
    • identifiers (LONGTEXT, JSON encoded allow-list, default [])

Migration notes

  • Import database.sql exactly once.
  • Keep collation utf8mb4_general_ci as shipped unless your DB standard differs globally.
  • Resource can verify table structure at startup when config/database.lua -> checkDatabase = true.