security_test_db create database security_test_db; use security_test_db; create table member_info ( mi_seq int not null auto_increment primary key, mi_id varchar(20) not null, mi_pwd varchar(128) not null, mi_name varchar(20) not null, mi_nickname varchar(20) not null, mi_staus int not null default 1, mi_reg_dt datetime not null default current_timestamp, mi_role varchar(10) not null default 'US..