Create a table book_store with columns Book_idVARCHAR(255) NOT NULL,
Book_Name VARCHAR(255) NOT NULL,
Book_genre VARCHAR(255) NOT NULL,
Status VARCHAR(255) NOT NULL,
PRIMARY KEY (Book_id)
Create a table book with columns Book_idVARCHAR(255) NOT NULL,
Book_Name VARCHAR(255) NOT NULL,
Book_release integer,
Book_price integer ,
Publisher Varchar(10),
Book_genre VARCHAR(255) NOT NULL,
PRIMARY KEY (Book_id)
CREATE TABLE price_logs withcolumns id INT(11) NOT NULL AUTO_INCREMENT,
Book_id VARCHAR(255) NOT NULL,
Old_Book_price DOUBLE NOT NULL,
New_Book_price DOUBLE NOT NULL,
updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ONUPDATE CURRENT_TIMESTAMP,
updated_by varchar(30) NOT NULL,
PRIMARY KEY (id),
KEY Book (Book_id),
CONSTRAINT price_logs_ibfk_1 FOREIGN KEY (Book_id) REFERENCESBook (Book_id) ON DELETE CASCADE ON UPDATE CASCADE
Update Trigger: Create a trigger torecord/insert the price in price_logs table before updating thebook table . Also record the user who updated the price.
