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
);Last updated