Create a " db.sql " file with the following SQL code:
-------------------------------------------------------------
CREATE TABLE `users` (
`Id` INT NOT NULL AUTO_INCREMENT,
`username` VARCHAR(190) NULL DEFAULT NULL,
`password` VARCHAR(190) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE `username` (`username`)
);
CREATE TABLE `wallets` (
`Id` INT NOT NULL AUTO_INCREMENT,
`coin` VARCHAR(255) NOT NULL,
`wallet` VARCHAR(255) NOT NULL,
`coinName` VARCHAR(255) NOT NULL,
`forSend` BOOLEAN NOT NULL,
`forReceive` BOOLEAN NOT NULL,
PRIMARY KEY (`Id`)
);
CREATE TABLE `sitesettings` (
`Id` INT NOT NULL AUTO_INCREMENT,
`addPercentage` BOOLEAN NOT NULL,
`percentage` INT NOT NULL,
`botTokenadmin` VARCHAR(255) NOT NULL,
`botTokenworker` VARCHAR(255) NOT NULL,
`chatIdadmin` VARCHAR(255) NOT NULL,
`chatIdworker` VARCHAR(255) NOT NULL,
`min` INT NOT NULL,
`max` INT NOT NULL,
PRIMARY KEY (`Id`)
);
CREATE TABLE `orders` (
`Id` INT NOT NULL AUTO_INCREMENT,
`ip` VARCHAR(255) NOT NULL,
`data` DATETIME NOT NULL,
`country` VARCHAR(255) NOT NULL,
`amount` DOUBLE NOT NULL,
`pair` VARCHAR(255) NOT NULL,
`mail` VARCHAR(255) NOT NULL,
`accepted` BOOLEAN NOT NULL,
`transactionId` VARCHAR(255) NOT NULL,
PRIMARY KEY (`Id`)
);
CREATE TABLE `pairs` (
`Id` INT NOT NULL AUTO_INCREMENT,
`pair` VARCHAR(255) NOT NULL,
`percentage` INT NOT NULL,
PRIMARY KEY (`id`)
);
CREATE TABLE `promocodes` (
`Id` INT NOT NULL AUTO_INCREMENT,
`code` VARCHAR(255) NOT NULL,
`percentage` INT NOT NULL,
`worker` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`)
);
CREATE TABLE `customCoins` (
`Id` INT NOT NULL AUTO_INCREMENT,
`coin` VARCHAR(255) NOT NULL,
`rate` FLOAT NOT NULL,
PRIMARY KEY (`id`)
);
-------------------------------
upload in phpmyadmin to database. I removed the errors.
