CREATE TABLE `p_bank_accounts` (
`iban` varchar(20) NOT NULL,
`owner` varchar(46) DEFAULT NULL,
`name` varchar(60) NOT NULL,
`balance` int(11) NOT NULL DEFAULT 0,
`type` varchar(10) NOT NULL,
`credit_score` int(11) NOT NULL DEFAULT 0,
`users` longtext NOT NULL DEFAULT '[]',
`invoices` longtext NOT NULL DEFAULT '[]',
`transactions` longtext NOT NULL DEFAULT '[]',
`logs` longtext NOT NULL DEFAULT '[]'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE `p_bank_cards` (
`id` int(11) NOT NULL,
`iban` varchar(30) NOT NULL,
`card_number` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE `p_bank_loans` (
`id` int(11) NOT NULL,
`player` varchar(60) NOT NULL,
`name` varchar(40) NOT NULL,
`amount` int(11) NOT NULL,
`repayment` float NOT NULL,
`duration` bigint(30) NOT NULL,
`paid` int(11) NOT NULL DEFAULT 0,
`last_payment` bigint(30) NOT NULL,
`start_date` bigint(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
ALTER TABLE `p_bank_accounts`
ADD PRIMARY KEY (`iban`);
ALTER TABLE `p_bank_cards`
ADD PRIMARY KEY (`id`);
ALTER TABLE `p_bank_loans`
ADD PRIMARY KEY (`id`);
ALTER TABLE `p_bank_cards`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE `p_bank_loans`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;