> For the complete documentation index, see [llms.txt](https://finalz-scripts.gitbook.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://finalz-scripts.gitbook.io/docs/finalz-paid/finalz-marketplace/database.md).

# Database

Upload this to your database

```sql
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;
```