[feat] sql 정적 파일 생성

[sangwonsheep]

기능

• [x] reset.sql

  DROP TABLE PICK_TAG;
  DROP TABLE PICK;
  DROP TABLE TAG;
  DROP TABLE LINK;
  DROP TABLE FOLDER;
  DROP TABLE USER;

• [x] create.sql

테이블 날리는 정적 sql, 테이블 생성하는 정적 sql 생성

[sangwonsheep]

docker sql 경로

docker exec -it techpick-mysql bash

bash-5.1# ls
afs  bin  boot  dev  docker-entrypoint-initdb.d  entrypoint.sh  etc  home  lib  lib64  media  mnt  opt  proc  root  run  sbin  srv  sys  tmp  usr  var

bash-5.1# cd var
bash-5.1# ls
adm  cache  db  empty  ftp  games  kerberos  lib  local  lock  log  mail  nis  opt  preserve  run  spool  tmp  yp

bash-5.1# cd lib
bash-5.1# ls
alternatives  dnf  games  misc  mysql  mysql-files  mysql-keyring  rpm  rpm-state  selinux  supportinfo

bash-5.1# cd mysql-files
bash-5.1# ls
create.sql  reset.sql

테이블 삭제, 추가 명령어

source /var/lib/mysql-files/reset.sql;
source /var/lib/mysql-files/create.sql;