CREATE TABLE IF NOT EXISTS product ( p_id INT NOT NULL AUTO_INCREMENT, cents NUMERIC(10,0) NOT NULL, description VARCHAR(80) NOT NULL, PRIMARY KEY (p_id), FULLTEXT (description) );