On Sat, Nov 13, 2010 at 5:59 PM, Ken Stanley <doh...@gmail.com> wrote: > CREATE TABLE documents ( > id INT NOT NULL AUTO_INCREMENT, > language_code CHAR(2), > tags CHAR(30), > text TEXT, > PRIMARY KEY (id) > );
I apologize, but I couldn't leave the typo in my last post without a follow up; it might cause confusion. I copied the OP's original table definition and forgot to remove the tags field. My purposed definition for the documents table should be: CREATE TABLE documents ( id INT NOT NULL AUTO_INCREMENT, language_code CHAR(2), text TEXT, PRIMARY KEY (id) ); - Ken