SQL

CREATE TABLE IF NOT EXISTS `bit_bankpins` (
  `identifier` varchar(100) COLLATE utf8mb4_bin NOT NULL,
  `pin` int(20) NOT NULL DEFAULT 0
);


CREATE TABLE IF NOT EXISTS `bit_bankrequest` (
  `identifier` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `requestedidentifier` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `amount` int(11) NOT NULL DEFAULT 0,
  `username` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  KEY `id` (`id`)
);


CREATE TABLE IF NOT EXISTS `bit_banktransfers` (
  `identifier` varchar(100) COLLATE utf8mb4_bin NOT NULL,
  `type` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `amount` int(50) NOT NULL DEFAULT 0,
  `sendto` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `receivedfrom` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `date` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL
);


--TO ESX

ALTER TABLE `users` ADD COLUMN (
  `iban` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `nfc` int(50) NOT NULL DEFAULT 1,
);

--TO QB

ALTER TABLE `players` ADD COLUMN (
  `iban` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `nfc` int(50) NOT NULL DEFAULT 1,
);