SQLize | PHPize | SQLtest

CREATE TABLE `products` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(250) NOT NULL, `description` text, `price` decimal(10,2) NOT NULL, `img` varchar(250) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 CREATE TABLE `categories` ( `id` int NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `title_for_get` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 CREATE TABLE `product_category` ( `product_id` int NOT NULL, `category_id` int NOT NULL, KEY `product_id` (`product_id`), KEY `category_id` (`category_id`), CONSTRAINT `product_category_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`), CONSTRAINT `product_category_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 CREATE TABLE `filters` ( `id` int NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `input_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 CREATE TABLE `product_filter` ( `product_id` int NOT NULL, `filter_id` int NOT NULL, KEY `product_id` (`product_id`), KEY `filter_id` (`filter_id`), CONSTRAINT `product_filter_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`), CONSTRAINT `product_filter_ibfk_2` FOREIGN KEY (`filter_id`) REFERENCES `filters` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3