Search code examples
mysqlspring-boothibernateenumsentity

How to set an entity with enum column with default property value in SpringBoot


I am using Springboot 2.7.2with Hibernate and Mysql 8. Is there a way to make an Entity class so as to execute a create table Query like this.

CREATE TABLE `settings` (
    `SettingsId` enum('1') NOT NULL,
    ................,
    ................,
     PRIMARY KEY (`SettingsId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Solution

  • I have got the answer from here and made the Entity Class like this

    @Entity
    public class Settings {
        public enum SettingsId {
        }
    
        @Id
        @Enumerated(EnumType.STRING)
        @Column(columnDefinition = "ENUM('1')")
        private SettingsId settingsId;
    
        ........;
        ........;
    }