CREATE TABLE `bank_user` (
`id` varchar(36) NOT NULL,
`identifier` varchar(255) NOT NULL,
`firstname` varchar(255) NOT NULL,
`lastname` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`beneficiaries` longtext DEFAULT '{}',
`iban` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
ALTER TABLE `bank_user`
ADD PRIMARY KEY (`email`);
CREATE TABLE `bank_transactions` (
`id` int(11) NOT NULL,
`receiver_identifier` varchar(255) DEFAULT NULL,
`receiver_name` varchar(255) DEFAULT NULL,
`receiver_email` varchar(255) DEFAULT NULL,
`sender_identifier` varchar(255) DEFAULT NULL,
`sender_name` varchar(255) DEFAULT NULL,
`sender_email` varchar(255) DEFAULT NULL,
`date` varchar(255) DEFAULT NULL,
`value` int(50) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
ALTER TABLE `bank_transactions`
ADD PRIMARY KEY (`id`);
ALTER TABLE `bank_transactions`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
CREATE TABLE `societies` (
`id` int(11) NOT NULL,
`label` varchar(255) DEFAULT NULL,
`society_name` varchar(255) DEFAULT NULL,
`value` int(50) DEFAULT NULL,
`iban` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
ALTER TABLE `societies`
ADD PRIMARY KEY (`id`);
ALTER TABLE `societies`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;
Once the download is complete, unzip the file and drag it into the resources folder of your server