CREATE TABLE IF NOT EXISTS member (
	m_id			VARCHAR(9) NOT NULL,
	name			VARCHAR(30) NOT NULL,
	second_name		VARCHAR(30) NOT NULL,
	last_name		VARCHAR(30) NOT NULL,
	second_last_name	VARCHAR(30) NOT NULL,
	email			VARCHAR(40) NOT NULL,
	phone_number		VARCHAR(15) NOT NULL,
	status			ENUM("Active", "Inactive") NOT NULL,

	PRIMARY KEY		(m_id),
	FULLTEXT		(name, second_name, last_name, second_last_name)
);
