특정 테이블 생성 되지 않는 오류

데모데이 하루전에 db를 밀고  ddl-auto: create 를 했는데, 한개의 테이블(Member)만이 생성이 안되었다.

쿼리를 잘 살펴보니

2024-02-18T23:47:20.726+09:00  WARN 8511 --- [           main] o.h.t.s.i.ExceptionHandlerLoggedImpl     : GenerationTarget encountered exception accepting command : Error executing DDL "
    create table member (
        age integer,
        creat_time datetime(6),
        member_id bigint not null auto_increment,
        token_expiration_time datetime(6),
        update_time datetime(6),
        member_name varchar(20) not null,
        email varchar(50) not null,
        nickname varchar(200),
        password varchar(200),
        profile varchar(200),
        refresh_token varchar(250),
        image varchar(255) default https://mblogthumb-phinf.pstatic.net/MjAyMDA2MTBfMTY1/MDAxNTkxNzQ2ODcyOTI2.Yw5WjjU3IuItPtqbegrIBJr3TSDMd_OPhQ2Nw-0-0ksg.8WgVjtB0fy0RCv0XhhUOOWt90Kz_394Zzb6xPjG6I8gg.PNG.lamute/user.png?type=w800,
        introduction varchar(255),
        my_keyword varchar(255),
        gender VARCHAR(10),
        genre1 VARCHAR(20),
        genre2 VARCHAR(20),
        genre3 VARCHAR(20),
        member_type enum ('KAKAO','NAVER','FORM') not null,
        memo mediumtext,
        role enum ('USER','ADMIN') not null,
        primary key (member_id)
    ) engine=InnoDB" via JDBC [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'https://mblogthumb-phinf.pstatic.net/MjAyMDA2MTBfMTY1/MDAxNTkxNzQ2ODcyOTI2.Yw5Wj' at line 13]

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "

 

@ColumnDefault("https://mblogthumb-phinf.pstatic.net/MjAyMDA2MTBfMTY1/MDAxNTkxNzQ2ODcyOTI2.Yw5WjjU3IuItPtqbegrIBJr3TSDMd_OPhQ2Nw-0-0ksg.8WgVjtB0fy0RCv0XhhUOOWt90Kz_394Zzb6xPjG6I8gg.PNG.lamute/user.png?type=w800")

이부분에서 @ColumnDefault 어노테이션에서 문자열 값을 사용할 때는 SQL에서와는 달리 따옴표를 두 번 사용하여 문자열 값을 감싸주어야 하는 오류였다.

@ColumnDefault("'https://mblogthumb-phinf.pstatic.net/MjAyMDA2MTBfMTY1/MDAxNTkxNzQ2ODcyOTI2.Yw5WjjU3IuItPtqbegrIBJr3TSDMd_OPhQ2Nw-0-0ksg.8WgVjtB0fy0RCv0XhhUOOWt90Kz_394Zzb6xPjG6I8gg.PNG.lamute/user.png?type=w800'")