mcbb6pVQ

1DROP TABLE IF EXISTS stock_levels;
2CREATE TABLE stock_levels ( id INT AUTO_INCREMENT PRIMARY KEY,
3                            ProductName varchar(100) NOT NULL,
4                            AdjustedStocklevel VARCHAR(50) NOT NULL,
5                            orderdat DATETIME DEFAULT NULL,
6                            actions VARCHAR(50) DEFAULT NULL );
7	
8DELIMITER $$
9CREATE TRIGGER stock_levels
10  AFTER INSERT ON orderitem
11  FOR EACH ROW
12BEGIN
13  INSERT INTO stock_levels
14     SET actions = 'store and update stock levels',
15         ProductName = products.ProductName,
16         AdjustedStocklevel = product.StockAmt - orderitem.ProductQuantity,
17         orderdat = NOW();
18END$$
19DELIMITER ;