CREATE TABLE IF NOT EXISTS `avarenadb`.`ROLE` (
  `ID` BIGINT NOT NULL AUTO_INCREMENT,
  `ROLE_NAME` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`ID`))
ENGINE = InnoDB

CREATE TABLE IF NOT EXISTS `avarenadb`.`USER` (
  `ID` BIGINT NOT NULL AUTO_INCREMENT,
  `LOGIN` VARCHAR(45) NOT NULL,
  `PASSWORD` VARCHAR(45) NOT NULL,
  `ROLE_ID` BIGINT NULL,
  PRIMARY KEY (`ID`),
  INDEX `fk_USER_ROLE1_idx` (`ROLE_ID` ASC),
  CONSTRAINT `fk_USER_ROLE1`
    FOREIGN KEY (`ROLE_ID`)
    REFERENCES `avarenadb`.`ROLE` (`ID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB

<set name="userCollection" inverse="true" cascade="save-update">
            <key>
                <column name="ROLE_ID" not-null="true" />
            </key>
            <one-to-many class="com.avarena.model.entity.User" />
        </set>