Esx_gangs database structure | Help Please

DrogazDevelopment · October 14, 2020, 8:19pm

Hello, so im making a FiveM Combat Server and i have a script called “esx_gangs” and the database structure is placed in a text file not like a database used to be. Screenshot_3

Please somebody help me with making a query for this because im not getting it how to make it in my database.

Thijs

GTARoleplayCity.com · October 15, 2020, 6:50pm

It’s probably a .sql file, so you need to execute it in some database overview program like HeidiSQL.

This is the database for the addon:

github.com

crowmedic/esx_gangs/blob/master/esx_gangs.sql

USE `essentialmode`;

CREATE TABLE 'gangs' (

  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `label` varchar(255) NOT NULL,

  PRIMARY KEY (`id`)
);

INSERT INTO gangs (name, label)
VALUES ('none', 'Unaffiliated'); 

CREATE TABLE 'gang_grades' (

  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gang_name` varchar(255) NOT NULL,
  `grade` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,

This file has been truncated. show original

system · November 14, 2020, 6:50pm

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.