 DEFAULT CHARACTER SET = utf8
 COLLATE = utf8_general_ci;
 
+CREATE TABLE IF NOT EXISTS `Staff` (
+  `Id` INT(11) NOT NULL,
+  `FullName` VARCHAR(100) NOT NULL,
+  `Password` VARCHAR(45) NOT NULL,
+  `DOB` DATE NOT NULL,
+  `Gender` VARCHAR(45) NOT NULL,
+  `PhoneNumber` VARCHAR(45) NOT NULL,
+  `Email` VARCHAR(45) NULL DEFAULT NULL,
+  `Image` VARCHAR(45) NOT NULL,
+  `StartDate` DATE NOT NULL,
+  `AddressId` INT(11) NOT NULL,
+  `Status` TINYINT(4) NULL DEFAULT NULL,
+  PRIMARY KEY (`Id`),
+  INDEX `fk_Staff_Address1_idx` (`AddressId` ASC),
+  CONSTRAINT `fk_Staff_Address1`
+    FOREIGN KEY (`AddressId`)
+    REFERENCES `Address` (`Id`)
+    ON DELETE NO ACTION
+    ON UPDATE NO ACTION)
+ENGINE = InnoDB
+DEFAULT CHARACTER SET = utf8
+COLLATE = utf8_general_ci;
+
+CREATE TABLE IF NOT EXISTS `ProductRating` (
+  `RatingId` INT(11) NOT NULL,
+  `ProductId` INT(11) NOT NULL,
+  PRIMARY KEY (`RatingId`, `ProductId`),
+  INDEX `fk_Rating_has_Product_Product1_idx` (`ProductId` ASC),
+  INDEX `fk_Rating_has_Product_Rating1_idx` (`RatingId` ASC),
+  CONSTRAINT `fk_Rating_has_Product_Rating1`
+    FOREIGN KEY (`RatingId`)
+    REFERENCES `Rating` (`Id`)
+    ON DELETE NO ACTION
+    ON UPDATE NO ACTION,
+  CONSTRAINT `fk_Rating_has_Product_Product1`
+    FOREIGN KEY (`ProductId`)
+    REFERENCES `Product` (`Id`)
+    ON DELETE NO ACTION
+    ON UPDATE NO ACTION)
+ENGINE = InnoDB
+DEFAULT CHARACTER SET = utf8
+COLLATE = utf8_general_ci;
+
 
 SET SQL_MODE=@OLD_SQL_MODE;
 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;

-- MySQL Workbench Synchronization
-- Generated: 2015-04-13 16:25
-- Model: New Model
-- Version: 1.0
-- Project: Name of the project

  `Date` DATETIME NOT NULL,
  `Price` FLOAT(11) NOT NULL,
  `Quantity` INT(11) NOT NULL,
  `Active` TINYINT(4) NOT NULL DEFAULT 0,
  `ProductId` INT(11) NOT NULL,
  PRIMARY KEY (`Id`),
  INDEX `fk_ShoppingCart_Product1_idx` (`ProductId` ASC),
