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

Reply via email to