CREATE TABLE IF NOT EXISTS activity ( a_id INT NOT NULL AUTO_INCREMENT, title VARCHAR(80) NOT NULL, description VARCHAR(80) NOT NULL, date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (a_id), FULLTEXT (title, description) );