创建Goods和GoodsDetai表

CREATE TABLE Goods ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(255) NOT NULL, price DECIMAL(10, 2) NOT NULL, description TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP );

CREATE TABLE GoodsDetail ( id INT PRIMARY KEY AUTO_INCREMENT, goods_id INT NOT NULL, color VARCHAR(50) NOT NULL, size VARCHAR(20) NOT NULL, stock INT NOT NULL, FOREIGN KEY (goods_id) REFERENCES Goods(id) );