title: UNSIGNED constraint for INT(11) in Hibernate
body: <p>I have been trying to add constraint UNSIGNED to a column using MYSQL. Below is my table.</p>
  
  <pre><code>public class UserActivity implements BaseEntity{
  
  @Id
  @GeneratedValue(strategy = GenerationType.AUTO)
  Long id;
  
  Long entityId;
  
  @Column(columnDefinition = "enum('QUESTION','ANSWER', 'COMMENT', 'TAGS')")
  @Enumerated(EnumType.STRING)
  Type type;
  
  @ManyToOne
  @JoinColumn(nullable = false, columnDefinition="INT(11) UNSIGNED")
  CustomerEntity user;
  </code></pre>
  
  <p>But it is not creating that constraint for user column in the database due to which foreign key  and index are not setting up. <a href="https://stackoverflow.com/questions/26341084/how-can-a-javax-persistence-column-be-defined-as-an-unsigned-tinyint">This</a> and <a href="https://stackoverflow.com/questions/5261094/unsigned-int-in-jpa-and-hibernate/5261992#5261992">this</a> could not help. Kindly help me out. Thanks</p>
  
  <p>LOGS:</p>
  
  <pre><code>Hibernate:
  alter table UserActivity
      add constraint FK_jfw954ii6gw7mbqdth6y3n0rs
      foreign key (user_Id)
      references customerDb.customer (Id)
  12:31:30.350 [localhost-startStop-1] ERROR o.h.tool.hbm2ddl.SchemaExport - HHH000389: Unsuccessful: alter table UserActivity add constraint FK_jfw954ii6gw7mbqdth6y3n0rs foreign key (user_Id) references customerDb.customer (Id)
  12:31:30.350 [localhost-startStop-1] ERROR o.h.tool.hbm2ddl.SchemaExport - Can't create table 'community_db.#sql-43f0_5a07' (errno: 150)
  Hibernate:
  </code></pre>
  
  <p>MySQL Queries : </p>
  
  <pre><code>ALTER TABLE `community_db`.`Question` 
  ADD INDEX `fk_Question_Customer_idx` (`author_Id` ASC);
  ALTER TABLE `community_db`.`Question` 
  ADD CONSTRAINT `fk_Answer_Customer`
  FOREIGN KEY (`author_Id`)
  REFERENCES `customerDb`.`customer` (`Id`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;
  </code></pre>
  
  <p>and below are the logs for the above mysql queries :</p>
  
  <pre><code>Error Code: 1005. Can't create table 'community_db.#sql-43f0_5d19' (errno: 150) 0.048 sec
  </code></pre>