CREATE TABLE IF NOT EXISTS `zerobug_marketplace_products` (
`id` BIGINT(20) NOT NULL,
`title` VARCHAR(255) NOT NULL,
`price` BIGINT(20) NOT NULL,
`quantity` INT(11) NOT NULL,
`item_data` TEXT NOT NULL COMMENT 'All product data (item, metadata, etc.) in JSON format',
`description` TEXT DEFAULT NULL,
`img` VARCHAR(255) DEFAULT NULL,
`type` VARCHAR(50) NOT NULL COMMENT 'E.g., cars, tools, weapons',
`seller_data` TEXT NOT NULL COMMENT 'Seller information in JSON format',
`list_date` BIGINT(20) NOT NULL COMMENT 'UNIX timestamp',
`advertised_until` BIGINT(20) DEFAULT NULL COMMENT 'Expiration time for featured listings (UNIX)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `zerobug_marketplace_auctions` (
`id` BIGINT(20) NOT NULL,
`title` VARCHAR(255) NOT NULL,
`price` BIGINT(20) NOT NULL COMMENT 'Buy-now price, if available',
`quantity` INT(11) NOT NULL,
`item_data` TEXT NOT NULL COMMENT 'Product data in JSON format',
`description` TEXT DEFAULT NULL,
`img` VARCHAR(255) DEFAULT NULL,
`type` VARCHAR(50) NOT NULL,
`seller_data` TEXT NOT NULL COMMENT 'Seller information in JSON format',
`list_date` BIGINT(20) NOT NULL COMMENT 'Start date (UNIX)',
`current_offer` BIGINT(20) NOT NULL,
`current_offer_player` VARCHAR(100) DEFAULT NULL COMMENT 'Identifier of the last bidder',
`starting_price` BIGINT(20) NOT NULL,
`end_date` BIGINT(20) NOT NULL COMMENT 'End date (UNIX)',
`history_list` LONGTEXT NOT NULL COMMENT 'Bid history in JSON format',
`pending_refunds` LONGTEXT NOT NULL COMMENT 'List of refund entries (auction ID, amount, timestamp) to be paid when the player logs in.',
`complate` BOOLEAN NOT NULL DEFAULT FALSE COMMENT 'Auction completed?',
`send_item` BOOLEAN NOT NULL DEFAULT FALSE COMMENT 'Item delivered?',
`send_price` BOOLEAN NOT NULL DEFAULT FALSE COMMENT 'Money delivered?',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `zerobug_marketplace_earnings` (
`identifier` VARCHAR(100) NOT NULL,
`earnings` BIGINT(20) NOT NULL DEFAULT 0,
PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `zerobug_black_marketplace_products` (
`id` BIGINT(20) NOT NULL,
`title` VARCHAR(255) NOT NULL,
`price` BIGINT(20) NOT NULL,
`quantity` INT(11) NOT NULL,
`item_data` TEXT NOT NULL COMMENT 'All product data (item, metadata, etc.) in JSON format',
`description` TEXT DEFAULT NULL,
`img` VARCHAR(255) DEFAULT NULL,
`type` VARCHAR(50) NOT NULL COMMENT 'E.g., cars, tools, weapons',
`seller_data` TEXT NOT NULL COMMENT 'Seller information in JSON format',
`list_date` BIGINT(20) NOT NULL COMMENT 'UNIX timestamp',
`advertised_until` BIGINT(20) DEFAULT NULL COMMENT 'Expiration time for featured listings (UNIX)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `zerobug_black_marketplace_auctions` (
`id` BIGINT(20) NOT NULL,
`title` VARCHAR(255) NOT NULL,
`price` BIGINT(20) NOT NULL COMMENT 'Buy-now price, if available',
`quantity` INT(11) NOT NULL,
`item_data` TEXT NOT NULL COMMENT 'Product data in JSON format',
`description` TEXT DEFAULT NULL,
`img` VARCHAR(255) DEFAULT NULL,
`type` VARCHAR(50) NOT NULL,
`seller_data` TEXT NOT NULL COMMENT 'Seller information in JSON format',
`list_date` BIGINT(20) NOT NULL COMMENT 'Start date (UNIX)',
`current_offer` BIGINT(20) NOT NULL,
`current_offer_player` VARCHAR(100) DEFAULT NULL COMMENT 'Identifier of the last bidder',
`starting_price` BIGINT(20) NOT NULL,
`end_date` BIGINT(20) NOT NULL COMMENT 'End date (UNIX)',
`history_list` LONGTEXT NOT NULL COMMENT 'Bid history in JSON format',
`pending_refunds` LONGTEXT NOT NULL COMMENT 'List of refund entries (auction ID, amount, timestamp) to be paid when the player logs in.',
`complate` BOOLEAN NOT NULL DEFAULT FALSE COMMENT 'Auction completed?',
`send_item` BOOLEAN NOT NULL DEFAULT FALSE COMMENT 'Item delivered?',
`send_price` BOOLEAN NOT NULL DEFAULT FALSE COMMENT 'Money delivered?',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `zerobug_black_marketplace_earnings` (
`identifier` VARCHAR(100) NOT NULL,
`earnings` BIGINT(20) NOT NULL DEFAULT 0,
PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;