Author: Alexander Barkov
Email: [EMAIL PROTECTED]
Message:
Hello! This seems to be almost right.
The only thing that header_date should be a string type not datetime.
VARCHAR or TEXT should be OK.
> Hello,
> I only found a pgsql version in the distributed source.
> So I made an mysql version of it.
>
> It loads, but I don't know if it does as what it is supposed to do.
> If it breaks your machine you get to keep both parts.
>
> Most notably mysql text columns does not support DEFAULT entries...
>
> #mnogosearch-3.1.16/create/mysql/news-extension.txt
> ALTER TABLE url ADD header_date datetime;
> ALTER TABLE url ALTER header_date SET DEFAULT 'now()';
>
> ALTER TABLE url ADD header_subj text NOT NULL;
>
> ALTER TABLE url ADD header_from text NOT NULL;
>
> ALTER TABLE url ADD header_group text NOT NULL;
>
> ALTER TABLE url ADD header_refs text NOT NULL;
>
> ALTER TABLE url ADD msg_id text NOT NULL;
>
> ALTER TABLE url ADD INDEX url_msg_id (msg_id(15));
>
> CREATE TABLE thread (
> parent int(4) DEFAULT '0' NOT NULL,
> child int(4) DEFAULT '0' NOT NULL,
> KEY thread_parent (parent(4)),
> KEY thread_child (child(4))
> );
>
> # end of file
Reply: <http://www.mnogosearch.org/board/message.php?id=2455>
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
