mysql

CREATE TABLE `books` (
`ID` INT NOT NULL AUTO_INCREMENT , `ISBN` VARCHAR (127) NOT NULL , `title` VARCHAR(255) NOT NULL , `author` VARCHAR(127) NOT NULL , `price` decimal(15,2) NOT NULL , `status` TINYINT(1) NOT NULL DEFAULT '1' ,
`date_added` DATE NOT NULL , PRIMARY KEY (`ID`)
) ENGINE = InnoDB CHARSET=utf8 COLLATE utf8_general_ci;