FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Will not show Category
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Will not show Category [message #5315 is a reply to message #5314] Tue, 27 August 2002 12:56 Go to previous messageGo to previous message
esm2002 is currently offline  esm2002   United States
Messages: 339
Registered: May 2002
Location: Atlanta Georgia
Karma:
Senior Member
Quote:

ALTER TABLE DROP hidden;
ALTER TABLE DROP hidden;
ALTER TABLE fud2_group_members ADD up_VISIBLE ENUM ('Y', 'N') NOT NULL DEFAULT 'N';
ALTER TABLE fud2_groups CHANGE p_VIEW p_READ ENUM ('I', 'Y', 'N') NOT NULL DEFAULT 'N';
ALTER TABLE fud2_group_members CHANGE up_VIEW up_READ ENUM ('Y', 'N') NOT NULL DEFAULT 'N';
ALTER TABLE DROP style;
ALTER TABLE DROP creation_date;
UPDATE fud2_group_members SET user_id=2147483647 WHERE user_id=4294967295;
UPDATE fud2_group_cache SET user_id=2147483647 WHERE user_id=4294967295;
ALTER TABLE fud2_thread ADD INDEX(is_sticky,orderexpiry);
CREATE TABLE fud2_mlist ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, forum_id INT NOT NULL, name VARCHAR(255) NOT NULL, mlist_post_apr ENUM('Y', 'N') NOT NULL DEFAULT 'N', allow_frm_post ENUM('Y', 'N') NOT NULL DEFAULT 'N', frm_post_apr ENUM('Y', 'N') NOT NULL DEFAULT 'Y', allow_mlist_attch ENUM('Y', 'N') NOT NULL DEFAULT 'Y', allow_mlist_html ENUM('Y', 'N') NOT NULL DEFAULT 'N', complex_reply_match ENUM('Y', 'N') NOT NULL DEFAULT 'N', subject_regex_haystack TEXT, subject_regex_needle TEXT, body_regex_haystack TEXT, body_regex_needle TEXT, index(forum_id) ) ;
CREATE TABLE fud2_nntp ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, forum_id INT NOT NULL, nntp_post_apr ENUM('Y', 'N') NOT NULL DEFAULT 'N', allow_frm_post ENUM('Y', 'N') NOT NULL DEFAULT 'N', frm_post_apr ENUM('Y', 'N') NOT NULL DEFAULT 'Y', allow_nntp_attch ENUM('Y', 'N') NOT NULL DEFAULT 'Y', complex_reply_match ENUM('Y', 'N') NOT NULL DEFAULT 'N', server VARCHAR(255) NOT NULL, newsgroup VARCHAR(255) NOT NULL, port INT NOT NULL, timeout INT NOT NULL, auth ENUM('NONE', 'ORIGINAL', 'SIMPLE') NOT NULL DEFAULT 'NONE', login VARCHAR(255), pass VARCHAR(255), index(forum_id) ) ;



Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Error msg
Next Topic: Registering new users is very slow
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 28 20:00:15 GMT 2024

Total time taken to generate the page: 0.04453 seconds