Author: nicholas
Email: [EMAIL PROTECTED]
Message:
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=2451>
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
