DROP TABLE IF EXISTS `bank_process`;
CREATE TABLE `bank_process` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`owner` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`type` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`icon` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`text` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci',
`created` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;
DROP TABLE IF EXISTS `bank_cards`;
CREATE TABLE `bank_cards` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`identifier` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`cardNumber` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`ownerName` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`valid` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`cardType` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`active` INT(11) NOT NULL DEFAULT '0',
`passCode` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;
DROP TABLE IF EXISTS `bank_history`;
CREATE TABLE `bank_history` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`identifier` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`amount` INT(11) NOT NULL DEFAULT '0',
`type` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`date` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB;
DROP TABLE IF EXISTS `bank_accounts`;
CREATE TABLE IF NOT EXISTS `bank_accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`citizenid` varchar(11) DEFAULT NULL,
`account_name` varchar(50) DEFAULT NULL,
`account_balance` int(11) NOT NULL DEFAULT 0,
`account_type` enum('shared','job','gang') NOT NULL,
`users` longtext DEFAULT '[]',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `account_name` (`account_name`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `bank_statements`;
CREATE TABLE IF NOT EXISTS `bank_statements` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`citizenid` varchar(11) DEFAULT NULL,
`account_name` varchar(50) DEFAULT 'checking',
`amount` int(11) DEFAULT NULL,
`reason` varchar(50) DEFAULT NULL,
`statement_type` enum('deposit','withdraw') DEFAULT NULL,
`date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`id`) USING BTREE,
KEY `citizenid` (`citizenid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `bank_process`;
CREATE TABLE `bank_process` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`owner` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`type` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`icon` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
`text` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci',
`created` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;
DROP TABLE IF EXISTS `bank_cards`;
CREATE TABLE `bank_cards` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`identifier` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`cardNumber` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`ownerName` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`valid` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`cardType` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
`active` INT(11) NOT NULL DEFAULT '0',
`passCode` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;
DROP TABLE IF EXISTS `bank_history`;
CREATE TABLE `bank_history` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`identifier` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
`amount` INT(11) NOT NULL DEFAULT '0',
`type` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
`date` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB;
DROP TABLE IF EXISTS `bank_accounts`;
CREATE TABLE IF NOT EXISTS `bank_accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`citizenid` varchar(11) DEFAULT NULL,
`account_name` varchar(50) DEFAULT NULL,
`account_balance` int(11) NOT NULL DEFAULT 0,
`account_type` enum('shared','job','gang') NOT NULL,
`users` longtext DEFAULT '[]',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `account_name` (`account_name`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
DROP TABLE IF EXISTS `bank_statements`;
CREATE TABLE IF NOT EXISTS `bank_statements` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`citizenid` varchar(11) DEFAULT NULL,
`account_name` varchar(50) DEFAULT 'checking',
`amount` int(11) DEFAULT NULL,
`reason` varchar(50) DEFAULT NULL,
`statement_type` enum('deposit','withdraw') DEFAULT NULL,
`date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
PRIMARY KEY (`id`) USING BTREE,
KEY `citizenid` (`citizenid`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;