SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; CREATE SCHEMA IF NOT EXISTS `databaas` DEFAULT CHARACTER SET utf8 ; USE `databaas` ; CREATE TABLE IF NOT EXISTS `databaas`.`user` ( `user_id` INT NOT NULL AUTO_INCREMENT, `username` INT NOT NULL, `password` VARCHAR(45) NOT NULL, PRIMARY KEY (`user_id`)) ENGINE = InnoDB; CREATE TABLE IF NOT EXISTS `databaas`.`project` ( `project_id` INT NOT NULL AUTO_INCREMENT, `project_name` VARCHAR(45) NOT NULL, `user_id` INT NOT NULL, PRIMARY KEY (`project_id`), INDEX `fk_project_user1_idx` (`user_id` ASC), CONSTRAINT `fk_project_user1` FOREIGN KEY (`user_id`) REFERENCES `mydb`.`user` (`username`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; CREATE TABLE IF NOT EXISTS `databaas`.`floor` ( `floor_id` INT NOT NULL AUTO_INCREMENT, `floor_name` VARCHAR(45) NOT NULL, `project_id` INT NOT NULL, PRIMARY KEY (`floor_id`), INDEX `fk_floor_project1_idx` (`project_id` ASC), CONSTRAINT `fk_floor_project1` FOREIGN KEY (`project_id`) REFERENCES `mydb`.`project` (`project_id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; CREATE TABLE IF NOT EXISTS `databaas`.`room` ( `room_id` INT NOT NULL AUTO_INCREMENT, `room_name` VARCHAR(45) NOT NULL, `room_width` VARCHAR(45) NOT NULL, `room_height` VARCHAR(45) NOT NULL, `floor_id` INT NOT NULL, PRIMARY KEY (`room_id`), INDEX `fk_room_floor_idx` (`floor_id` ASC), CONSTRAINT `fk_room_floor` FOREIGN KEY (`floor_id`) REFERENCES `mydb`.`floor` (`floor_id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; CREATE TABLE IF NOT EXISTS `databaas`.`item` ( `item_id` INT NOT NULL AUTO_INCREMENT, `item_name` VARCHAR(45) NOT NULL, `item_posX` INT NOT NULL, `item_posY` INT NOT NULL, `room_id` INT NOT NULL, PRIMARY KEY (`item_id`), INDEX `fk_item_room1_idx` (`room_id` ASC), CONSTRAINT `fk_item_room1` FOREIGN KEY (`room_id`) REFERENCES `mydb`.`room` (`room_id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; CREATE TABLE IF NOT EXISTS `databaas`.`rectangle` ( `rectangle_id` INT NOT NULL AUTO_INCREMENT, `rectangle_width` INT NOT NULL, `rectangle_height` INT NOT NULL, `rectangle_localPosX` INT NOT NULL, `rectangle_localPosY` INT NOT NULL, `item_id` INT NOT NULL, PRIMARY KEY (`rectangle_id`), INDEX `fk_rectangle_item1_idx` (`item_id` ASC), CONSTRAINT `fk_rectangle_item1` FOREIGN KEY (`item_id`) REFERENCES `mydb`.`item` (`item_id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;