CREATE TABLE goods (
goods_id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
name_of_goods VARCHAR (255) NOT NULL,
price_ru DECIMAL NOT NULL);
CREATE TABLE users (
user_id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
username VARCHAR(50) NOT NULL);
CREATE TABLE comments (
comment_id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
goods_id INT NOT NULL,
user_id INT NOT NULL,
comment VARCHAR(255) NOT NULL);
CREATE TABLE purchases (
purchase_id INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
user_id INT NOT NULL,
goods_id INT NOT NULL,
purchase_date DATE NOT NULL);
CREATE TABLE cart (
cart_number INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
user_id INT NOT NULL);