Something went wrong. Try again.
AECC database project.
Something went wrong. Try again.
1234567891011121314CREATE 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));