[dev] troll sql script

[Vilius Sumskas]

Hi,

installed latest troll cvs...

mysql> CREATE TABLE troll_articles (
    ->     owner_id  VARCHAR(255) NOT NULL,
    ->     newsgroup VARCHAR(255) NOT NULL,
    ->     articles  VARCHAR(255) NOT NULL DEFAULT '',
    ->
    ->     PRIMARY KEY (owner_id, newsgroup)
    -> );
ERROR 1071: Specified key was too long. Max key length is 500

i corrected this issue lowering owner_id to VARCHAR(245).

--
  Best Regards,

  Vilius Sumskas
  LNK TV system administrator
  Mob. +370-614-75713
  mailto:vilius at lnk.lt
  http://www.lnk.lt