-- Create Tables for zerobug-reportsystem
-- Table for tickets
CREATE TABLE IF NOT EXISTS `zerobug_tickets` (
`ticket_id` VARCHAR(50) NOT NULL,
`data` LONGTEXT NOT NULL,
PRIMARY KEY (`ticket_id`)
);
-- Table for gallery
CREATE TABLE IF NOT EXISTS `zerobug_gallery` (
`identifier` VARCHAR(50) NOT NULL,
`data` LONGTEXT NOT NULL,
PRIMARY KEY (`identifier`)
);
-- Table for playtime tracking
CREATE TABLE IF NOT EXISTS `zerobug_playtime` (
`identifier` VARCHAR(50) NOT NULL,
`data` INT NOT NULL DEFAULT 0,
PRIMARY KEY (`identifier`)
);
-- Table for leaderboard
CREATE TABLE IF NOT EXISTS `zerobug_leaderboard` (
`identifier` VARCHAR(50) NOT NULL,
`data` LONGTEXT NOT NULL,
PRIMARY KEY (`identifier`)
);
-- Table for logs
CREATE TABLE IF NOT EXISTS `zerobug_logs` (
`identifier` VARCHAR(50) NOT NULL,
`data` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`identifier`)
) CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;