📦Database

Upload this to your database

CREATE TABLE `live_offers` (
	`id` int NOT NULL AUTO_INCREMENT,
	`owner` VARCHAR(64) NULL DEFAULT 'available' COLLATE 'utf8mb4_unicode_ci',
    `ownerName` VARCHAR(64) NULL DEFAULT 'available' COLLATE 'utf8mb4_unicode_ci',
	`type`  VARCHAR(32) NULL DEFAULT NULL,
	`amount` INT(11) NULL DEFAULT NULL,
	`price` BIGINT NULL DEFAULT NULL,
	`itemName`  VARCHAR(64) NULL DEFAULT NULL,
	`plate` VARCHAR(32) NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
;
CREATE TABLE `saled_offers` (
	`id` int NOT NULL AUTO_INCREMENT,
	`ownerId` VARCHAR(64) NULL DEFAULT 'available' COLLATE 'utf8mb4_unicode_ci',
    `buyerId` VARCHAR(64) NULL DEFAULT 'available' COLLATE 'utf8mb4_unicode_ci',
	`ownerName` VARCHAR(64) NULL DEFAULT 'available' COLLATE 'utf8mb4_unicode_ci',
    `buyerName` VARCHAR(64) NULL DEFAULT 'available' COLLATE 'utf8mb4_unicode_ci',
	`type`  VARCHAR(32) NULL DEFAULT NULL,
	`amount` INT(11) NULL DEFAULT NULL,
	`price` BIGINT NULL DEFAULT NULL,
	`itemName`  VARCHAR(64) NULL DEFAULT NULL,
	`date`  VARCHAR(123) NULL DEFAULT NULL,
	`plate` VARCHAR(32) NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
;


  ALTER TABLE users
    ADD COLUMN IF NOT EXISTS `last_deal` INT DEFAULT 0,
    ADD COLUMN IF NOT EXISTS `total_amount` INT DEFAULT 0,
    ADD COLUMN IF NOT EXISTS `largest_deal` INT DEFAULT 0,
    ADD COLUMN IF NOT EXISTS `car` INT DEFAULT 0,
    ADD COLUMN IF NOT EXISTS `item` INT DEFAULT 0;