[dev] troll sql script

[Jan Schneider]

Zitat von Vilius Sumskas <vilius at lnk.lt>:

> 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).

Fixed in CVS.

Jan.

--
http://www.horde.org - The Horde Project
http://www.ammma.de - Neue Wege des Lernens
http://www.tip4all.de - Deine private Tippgemeinschaft