<prompt> Kujenga meza database kwa ajili ya kuhifadhi historia ya ununuzi wa wateja.  <response>: Here is an example of a SQL statement that can create a database table specifically for the storage of customer purchase history:CREATE TABLE customer_purchase_history id INT PRIMARY KEY AUTO_INCREMENT, customer_id INT, order_id INT, order_date DATE, product_name VARCHAR100, quantity INT, price DECIMAL10, 2, FOREIGN KEY customer_id REFERENCES customersid, FOREIGN KEY order_id REFERENCES ordersid;This database table, named customer_purchase_history, contains columns for storing information about each purchase a customer has made, such as the order_date, product_name, quantity, and price. Each entry is identified by a unique id and has references to a customer_id and an order_id, linking the purchase record to a specific customer and a specific order. 