FINALTEST.sql

INSERT INTO `PUBLISHER` VALUES ('m', 'mi', '01272018460');
INSERT INTO `USER` VALUES ('amr000', 'amr', 'ahmed', '123456789', 'amr_bek@gmail.com', '01272018460','miami', FALSE);
INSERT INTO `USER` VALUES ('root', 'amr', 'ahmed', '123456789', 'bek@gmail.com', '01272018460','miami', TRUE);
INSERT INTO `BOOK` VALUES ('12315', 'abook', 0.5, 'Science', 4,4, 'm' , NULL,'safaa' );
INSERT INTO `BOOK` VALUES ('1315', 'zbook', 0.5, 'Science', 4,4, 'm' , NULL,'amr');
INSERT INTO `BOOK` VALUES ('115', 'cbook', 0.5, 'Science', 4,4, 'm' , NULL,'mirna');
INSERT INTO `BOOK` VALUES ('15', 'vbook', 0.5, 'Art', 4,4, 'm' , NULL,'amr');
INSERT INTO `BOOK` VALUES ('555', 'bbook', 0.5, 'Science', 4,4, 'm' , NULL,'aliaa');
INSERT INTO `BOOK` VALUES ('1515', 'nbook', 0.5, 'Art', 4,4, 'm' , NULL,'radwa');
INSERT INTO `BOOK` VALUES ('315', 'dbook', 0.5, 'Science', 4,4, 'm' , NULL,'radwa');
INSERT INTO `SALES` VALUES (1, '12315', 'amr000', '2017-5-1', 2);
INSERT INTO `SALES` VALUES (2, '15', 'amr000', '2017-4-27', 1);
INSERT INTO `SALES` VALUES (3, '15', 'amr000', '2016-4-27', 1);
INSERT INTO `USER` VALUES ('safaa', 'safaa', 'ahmed', '123456789', 'safaa@gmail.com', '01272018460','miami', true);