Frozen Wiki
Website
  • Documentation
  • 🔹Scripts
    • Frozen Medic Job
      • Installation
      • Dependencies
      • Exports
      • State Bags
      • Customizations
      • Common Issues
        • QBCore
    • Frozen Crutch
    • Frozen Scratch Ticket
      • Installations
    • Frozen Police Job
      • Installation
      • Dependencies
      • Exports
      • State Bags
      • Events
      • Customizations
    • Frozen Inventory
      • Features
      • Examples
      • Dependencies
      • Installation
        • v1.2 installation
    • Helicopter Camera
      • Adding custom helicopters
      • Moving the UI above the minimap
      • Adding controller inputs
      • Exports
      • Events
    • Frozen Poker
      • Installation
      • Dependencies
    • Frozen Fishing
      • Installation
      • Dependencies
      • Shop Items
      • Fishing Equipment Strength
    • Frozen Gym
      • Installation
      • Exports
        • Client Exports
        • Server Exports
  • 🔓Authorization
    • How to get authorized with license system?
Powered by GitBook
On this page
  • Database installation (for ESX)
  • Database installation (for QB)
  1. Scripts
  2. Frozen Gym

Installation

Database installation (for ESX)

ALTER TABLE users ADD COLUMN IF NOT EXISTS statistics LONGTEXT DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `gym_memberships` (
  `owner` varchar(70) DEFAULT NULL,
  `name` varchar(80) DEFAULT NULL,
  `time` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Database installation (for QB)

ALTER TABLE players ADD COLUMN IF NOT EXISTS statistics LONGTEXT DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `gym_memberships` (
  `owner` varchar(70) DEFAULT NULL,
  `name` varchar(80) DEFAULT NULL,
  `time` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

PreviousFrozen GymNextExports

Last updated 7 months ago

🔹