Installation guide — please follow each step carefully and exactly as described to ensure the script works correctly on your server. Skipping or modifying steps may cause the system to not function properly, so follow it step by step.
This script requires some mandatory dependencies to function correctly. Make sure to download and extract them inside your server’s main directory, keeping their original folder structure intact.
This script may cause conflicts or errors if you use other banking systems on your server. Common examples include qb-banking, esx_banking or other similar banking scripts. It’s strongly recommended to remove them completely before installation to prevent compatibility or functionality issues.
This script includes an essential database required for its operation.You must import it before starting your server, preferably using HeidiSQL or any other manager compatible with MariaDB/MySQL.
ESX
lua
DROP TABLE IF EXISTS `bank_process`;
CREATE TABLE `bank_process` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`owner` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`type` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`icon` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`text` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci',
`created` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;
DROP TABLE IF EXISTS `bank_cards`;
CREATE TABLE `bank_cards` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`identifier` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`cardNumber` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`ownerName` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`valid` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`cardType` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`active` INT(11) NOT NULL DEFAULT '0',
`passCode` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;
DROP TABLE IF EXISTS `bank_history`;
CREATE TABLE `bank_history` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`identifier` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`amount` INT(11) NOT NULL DEFAULT '0',
`type` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`date` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB;
QB
sql
DROPTABLE IF EXISTS `bank_process`;
CREATE TABLE `bank_process` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`owner` VARCHAR(50) NOT NULLDEFAULT''COLLATE'utf8mb4_unicode_ci',
`type` VARCHAR(50) NOT NULLDEFAULT''COLLATE'utf8mb4_unicode_ci',
`icon` VARCHAR(50) NOT NULLDEFAULT''COLLATE'utf8mb4_unicode_ci',
`text` TEXT NOT NULLCOLLATE'utf8mb4_unicode_ci',
`created` VARCHAR(50) NOT NULLDEFAULT''COLLATE'utf8mb4_unicode_ci',
PRIMARY KEY (`id`) USING BTREE
) COLLATE='utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT =1;
DROPTABLE IF EXISTS `bank_cards`;
CREATE TABLE `bank_cards` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`identifier` VARCHAR(50) NOT NULLDEFAULT'0'COLLATE'utf8mb4_general_ci',
`cardNumber` VARCHAR(50) NOT NULLDEFAULT'0'COLLATE'utf8mb4_general_ci',
`ownerName` VARCHAR(50) NOT NULLDEFAULT'0'COLLATE'utf8mb4_general_ci',
`valid` VARCHAR(50) NOT NULLDEFAULT'0'COLLATE'utf8mb4_general_ci',
`cardType` VARCHAR(50) NOT NULLDEFAULT'0'COLLATE'utf8mb4_general_ci',
`active` INT(11) NOT NULLDEFAULT'0',
`passCode` VARCHAR(50) NOT NULLDEFAULT'0'COLLATE'utf8mb4_general_ci',
PRIMARY KEY (`id`) USING BTREE
) COLLATE='utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT =1;
DROPTABLE IF EXISTS `bank_history`;
CREATE TABLE `bank_history` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`identifier` VARCHAR(50) NULLDEFAULT''COLLATE'utf8mb4_general_ci',
`amount` INT(11) NOT NULLDEFAULT'0',
`type` VARCHAR(50) NULLDEFAULTNULLCOLLATE'utf8mb4_general_ci',
`date` TIMESTAMPNOT NULLDEFAULTcurrent_timestamp(),
PRIMARY KEY (`id`) USING BTREE
) COLLATE='utf8mb4_general_ci' ENGINE = InnoDB;
DROPTABLE IF EXISTS `bank_accounts`;
CREATE TABLE IF NOTEXISTS `bank_accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`citizenid` varchar(11) DEFAULTNULL,
`account_name` varchar(50) DEFAULTNULL,
`account_balance` int(11) NOT NULLDEFAULT0,
`account_type` enum('shared','job','gang') NOT NULL,
`users` longtext DEFAULT'[]',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `account_name` (`account_name`)
) ENGINE=InnoDB AUTO_INCREMENT=1DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROPTABLE IF EXISTS `bank_statements`;
CREATE TABLE IF NOTEXISTS `bank_statements` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`citizenid` varchar(11) DEFAULTNULL,
`account_name` varchar(50) DEFAULT'checking',
`amount` int(11) DEFAULTNULL,
`reason` varchar(50) DEFAULTNULL,
`statement_type` enum('deposit','withdraw') DEFAULTNULL,
`date` timestampNOT NULLDEFAULTcurrent_timestamp() ONUPDATEcurrent_timestamp(),
PRIMARY KEY (`id`) USING BTREE,
KEY `citizenid` (`citizenid`)
) ENGINE=InnoDB AUTO_INCREMENT=1DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;