useful-qry/z-ㅎㅎㅎ copy.sql

truncate table dbr_reward;
truncate table dbr_reward_bd;
truncate table dbr_credit;
truncate table dbr_credit_bd;


sudo dnf remove mysql-server mysql mysql-common -y
sudo dnf module reset mysql -y
sudo dnf module disable mysql -y
sudo dnf clean all -y
sudo dnf makecache -y

sudo rm -rf /var/lib/mysql
sudo rm -rf /etc/my.cnf
sudo rm -rf /etc/my.cnf.d
sudo rm -rf /etc/mysql


truncate table dbr_sorder;
truncate table dbr_sorder_bd;
truncate table dbr_sales;
truncate table dbr_sales_bd;
truncate table dbr_bal_buyer;

truncate table dbr_bal_item;
truncate table dbr_stock_io;
truncate table dbr_genio;
truncate table dbr_genio_bd;
truncate table dbr_acc_slip;


truncate table dbr_bal_supplier;
truncate table dbr_porder;
truncate table dbr_porder_bd;
truncate table dbr_purch;
truncate table dbr_purch_bd;

truncate table dbr_acc_slip;


truncate table dbr_bal_reward;
truncate table dbr_reward;
truncate table dbr_reward_bd;

truncate table dbr_bal_credit;
truncate table dbr_credit;
truncate table dbr_credit_bd;