[feat] 사용자 닉네임 초기값 지정 : 일상00000000

[youngyin]

CUSTOMER 테이블에 nickname_seq 필드 추가.

[youngyin]

• 컬럼추가 완료 : alter table tb_customer add nickname_seq bigint;
• 기존 데이터 수정 완료

  
  update tb_customer A
  set nickname_seq = (
  select Z.seq from (
      select rank() over (order by B.update_date) AS SEQ, customer_id
      from tb_customer B
      ) Z
  where A.customer_id = Z.customer_id
  )
  where 1=1;

select customer_id, nickname_seq, nickname, concat('일상0000000', nickname_seq) from tb_customer;

update tb_customer set nickname = concat('일상0000000', nickname_seq) where 1=1;