CREATE TABLE `category` (`id` INT NOT NULL AUTO_INCREMENT , `category` VARCHAR(255) NOT NULL , `count` INT NOT NULL , `date` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;
CREATE TABLE `products` (
`id` INT NOT NULL PRIMARY KEY AUTO_INCREMENT ,
`category_id` INT NOT NULL ,
`name` VARCHAR(255) NOT NULL ,
`description` TEXT NOT NULL ,
`count` INT NOT NULL ,
`repair_required` VARCHAR(255) NOT NULL ,
`status` VARCHAR(255) NOT NULL ,
`date` DATETIME NOT NULL
) ENGINE = InnoDB;
CREATE TABLE `date` (`id` INT NOT NULL AUTO_INCREMENT , `products_id` INT NOT NULL , `product_status` VARCHAR(255) NOT NULL , `date` DATETIME NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;