CREATE TABLE IF NOT EXISTS `bossmenu` (
`job` varchar(100) NOT NULL,
`account_name` varchar(50) DEFAULT NULL,
`type` varchar(50) DEFAULT 'job',
`balance` int(15) DEFAULT 0,
`data` longtext DEFAULT '[]',
`announcements` longtext DEFAULT '[]',
PRIMARY KEY (`job`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE IF NOT EXISTS `bossmenu_outfits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`job` varchar(50) DEFAULT NULL,
`grades` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`gender` tinyint(4) DEFAULT NULL,
`outfit` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE IF NOT EXISTS `bossmenu_permissions` (
`job` varchar(50) DEFAULT NULL,
`grade` int(11) DEFAULT NULL,
`permissions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE IF NOT EXISTS `bossmenu_transactions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(80) DEFAULT NULL,
`executor` varchar(100) DEFAULT NULL,
`executor_identifier` varchar(100) DEFAULT NULL,
`type` varchar(50) DEFAULT NULL,
`amount` int(11) DEFAULT NULL,
`title` longtext DEFAULT NULL,
`date` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;