SQl

-- QBCore players (only pincode)
ALTER TABLE `players` ADD COLUMN `pincode` int(50) NULL DEFAULT NULL;

-- If you are NOT using management_funds:
ALTER TABLE `bank_accounts` ADD COLUMN `iban` varchar(255) DEFAULT NULL;

-- okok tabeller:
CREATE TABLE IF NOT EXISTS `okokbanking_transactions`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `receiver_identifier` varchar(255) NOT NULL,
    `receiver_name` varchar(255) NOT NULL,
    `sender_identifier` varchar(255) NOT NULL,
    `sender_name` varchar(255) NOT NULL,
    `date` varchar(255) NOT NULL,
    `value` int(50) NOT NULL,
    `type` varchar(255) NOT NULL,
    PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `okokbanking_societies`(
    `society` varchar(255) NULL DEFAULT NULL,
    `society_name` varchar(255) NULL DEFAULT NULL,
    `value` int(50) NULL DEFAULT NULL,
    `iban` varchar(255) NOT NULL,
    `is_withdrawing` int(1) NULL DEFAULT NULL
);

Added from https://docs.okokscripts.io/scripts/okokbankingarrow-up-right

Last updated