php error ->

Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /usr/www/users/username/dev.example.com/board/rdf.php on line 65

sql error ->

(/usr/www/users/username/dev.example.com/board/rdf.php) 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 21
Query: SELECT m.*, u.alias, t.forum_id, p.name AS poll_name, p.total_votes, m2.subject AS th_subject, m3.subject AS reply_subject, f.name AS frm_name, c.name AS cat_name FROM fud26_msg m INNER JOIN fud26_thread t ON m.thread_id=t.id INNER JOIN fud26_forum f ON t.forum_id=f.id INNER JOIN fud26_cat c ON c.id=f.cat_id INNER JOIN fud26_msg m2 ON t.root_msg_id=m2.id LEFT JOIN fud26_msg m3 ON m3.id=m.reply_to LEFT JOIN fud26_users u ON m.poster_id=u.id LEFT JOIN fud26_poll p ON m.poll_id=p.id WHERE m.apr=1 AND m.post_stamp >=1069824412 ORDER BY m.post_stamp DESC LIMIT 0,
Server Version: 4.0.13-standard-log
[Referring Page] http://dev.example.com/board/adm/admrdf.php?S=fa488c20b181e309767c4f40ad7b270f&SQ=1069910797

table structure ->

# --------------------------------------------------------
#
# Table structure for table 'fud26_action_log'
#

CREATE TABLE fud26_action_log (
   id int(11) NOT NULL auto_increment,
   logtime bigint(20) DEFAULT '0' NOT NULL,
   logaction varchar(100),
   user_id int(11) DEFAULT '0' NOT NULL,
   a_res varchar(100),
   a_res_id int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_action_log_i_ul (user_id, logtime)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_ann_forums'
#

CREATE TABLE fud26_ann_forums (
   ann_id int(11) DEFAULT '0' NOT NULL,
   forum_id int(11) DEFAULT '0' NOT NULL,
   KEY fud26_ann_forums_i_fa (forum_id, ann_id),
   KEY fud26_ann_forums_i_a (ann_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_announce'
#

CREATE TABLE fud26_announce (
   id int(11) NOT NULL auto_increment,
   date_started bigint(20) DEFAULT '0' NOT NULL,
   date_ended bigint(20) DEFAULT '0' NOT NULL,
   subject varchar(255) NOT NULL,
   text text NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_announce_i_dd (date_started, date_ended)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_attach'
#

CREATE TABLE fud26_attach (
   id int(11) NOT NULL auto_increment,
   location varchar(255) NOT NULL,
   original_name varchar(255),
   owner int(11) DEFAULT '0' NOT NULL,
   attach_opt int(11) DEFAULT '0' NOT NULL,
   message_id int(11) DEFAULT '0' NOT NULL,
   dlcount int(11) DEFAULT '0' NOT NULL,
   mime_type int(11) DEFAULT '0' NOT NULL,
   fsize int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_attach_i_mp (message_id, attach_opt)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_avatar'
#

CREATE TABLE fud26_avatar (
   id int(11) NOT NULL auto_increment,
   img varchar(255) NOT NULL,
   descr varchar(255) NOT NULL,
   PRIMARY KEY (id),
   UNIQUE fud26_avatar_i_i (img)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_blocked_logins'
#

CREATE TABLE fud26_blocked_logins (
   id int(11) NOT NULL auto_increment,
   login varchar(255) NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_buddy'
#

CREATE TABLE fud26_buddy (
   id int(11) NOT NULL auto_increment,
   bud_id int(11) DEFAULT '0' NOT NULL,
   user_id int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_buddy_i_ub (user_id, bud_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_cat'
#

CREATE TABLE fud26_cat (
   id int(11) NOT NULL auto_increment,
   name varchar(50) NOT NULL,
   description varchar(255),
   cat_opt int(11) DEFAULT '0' NOT NULL,
   view_order int(11) DEFAULT '3' NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_custom_tags'
#

CREATE TABLE fud26_custom_tags (
   id int(11) NOT NULL auto_increment,
   name varchar(255) NOT NULL,
   user_id int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_custom_tags_i_u (user_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_email_block'
#

CREATE TABLE fud26_email_block (
   id int(11) NOT NULL auto_increment,
   email_block_opt int(11) DEFAULT '1' NOT NULL,
   string varchar(255) NOT NULL,
   PRIMARY KEY (id),
   UNIQUE fud26_email_block_i_s (string)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_ext_block'
#

CREATE TABLE fud26_ext_block (
   id int(11) NOT NULL auto_increment,
   ext varchar(32) NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_fc_view'
#

CREATE TABLE fud26_fc_view (
   id int(11) NOT NULL auto_increment,
   c int(11) DEFAULT '0' NOT NULL,
   f int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   UNIQUE fud26_fc_view_i_f (f)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_forum'
#

CREATE TABLE fud26_forum (
   id int(11) NOT NULL auto_increment,
   cat_id int(11) DEFAULT '0' NOT NULL,
   name varchar(100) NOT NULL,
   descr text,
   post_passwd varchar(32),
   forum_icon varchar(255),
   date_created bigint(20) DEFAULT '0' NOT NULL,
   thread_count int(11) DEFAULT '0' NOT NULL,
   post_count int(11) DEFAULT '0' NOT NULL,
   last_post_id int(11) DEFAULT '0' NOT NULL,
   view_order int(11) DEFAULT '0' NOT NULL,
   max_attach_size int(11) DEFAULT '0' NOT NULL,
   max_file_attachments int(11) DEFAULT '1' NOT NULL,
   moderators text,
   message_threshold int(11) DEFAULT '0' NOT NULL,
   forum_opt int(11) DEFAULT '16' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_forum_i_c (cat_id),
   KEY fud26_forum_i_lpi (last_post_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_forum_notify'
#

CREATE TABLE fud26_forum_notify (
   id int(11) NOT NULL auto_increment,
   user_id int(11) DEFAULT '0' NOT NULL,
   forum_id int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_forum_notify_i_uf (user_id, forum_id),
   KEY fud26_forum_notify_i_f (forum_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_forum_read'
#

CREATE TABLE fud26_forum_read (
   id int(11) NOT NULL auto_increment,
   forum_id int(11) DEFAULT '0' NOT NULL,
   user_id int(11) DEFAULT '0' NOT NULL,
   last_view bigint(20) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   UNIQUE fud26_forum_read_i_fu (forum_id, user_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_group_cache'
#

CREATE TABLE fud26_group_cache (
   id int(11) NOT NULL auto_increment,
   user_id int(11) DEFAULT '0' NOT NULL,
   resource_id int(11) DEFAULT '0' NOT NULL,
   group_id int(11) DEFAULT '0' NOT NULL,
   group_cache_opt int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_group_cache_i_ru (resource_id, user_id),
   KEY fud26_group_cache_i_g (group_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_group_members'
#

CREATE TABLE fud26_group_members (
   id int(11) NOT NULL auto_increment,
   user_id int(11) DEFAULT '0' NOT NULL,
   group_id int(11) DEFAULT '0' NOT NULL,
   group_members_opt int(11) DEFAULT '65536' NOT NULL,
   PRIMARY KEY (id),
   UNIQUE fud26_group_members_i_gu (group_id, user_id),
   KEY fud26_group_members_i_gmo (group_members_opt)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_group_resources'
#

CREATE TABLE fud26_group_resources (
   id int(11) NOT NULL auto_increment,
   group_id int(11) DEFAULT '0' NOT NULL,
   resource_id int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_group_resources_i_gr (group_id, resource_id),
   KEY fud26_group_resources_i_r (resource_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_groups'
#

CREATE TABLE fud26_groups (
   id int(11) NOT NULL auto_increment,
   name varchar(255) NOT NULL,
   inherit_id int(11) DEFAULT '0' NOT NULL,
   forum_id int(11) DEFAULT '0' NOT NULL,
   groups_opt int(11) DEFAULT '0' NOT NULL,
   groups_opti int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_groups_i_f (forum_id),
   KEY fud26_groups_i_i (inherit_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_index'
#

CREATE TABLE fud26_index (
   id int(11) NOT NULL auto_increment,
   word_id int(11) DEFAULT '0' NOT NULL,
   msg_id int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_index_i_wm (word_id, msg_id),
   KEY fud26_index_i_m (msg_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_ip_block'
#

CREATE TABLE fud26_ip_block (
   id int(11) NOT NULL auto_increment,
   ca int(11) DEFAULT '0' NOT NULL,
   cb int(11) DEFAULT '0' NOT NULL,
   cc int(11) DEFAULT '0' NOT NULL,
   cd int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_level'
#

CREATE TABLE fud26_level (
   id int(11) NOT NULL auto_increment,
   name varchar(255) NOT NULL,
   post_count int(11) DEFAULT '0' NOT NULL,
   img varchar(255),
   level_opt int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_level_i_p (post_count)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_mime'
#

CREATE TABLE fud26_mime (
   id int(11) NOT NULL auto_increment,
   fl_ext varchar(10) NOT NULL,
   mime_hdr varchar(255) NOT NULL,
   descr varchar(255),
   icon varchar(100) DEFAULT 'unknown.gif' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_mime_f (fl_ext)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_mlist'
#

CREATE TABLE fud26_mlist (
   id int(11) NOT NULL auto_increment,
   forum_id int(11) DEFAULT '0' NOT NULL,
   name varchar(255) NOT NULL,
   subject_regex_haystack text,
   subject_regex_needle text,
   body_regex_haystack text,
   body_regex_needle text,
   additional_headers text,
   mlist_opt int(11) DEFAULT '76' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_mlist_i_f (forum_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_mod'
#

CREATE TABLE fud26_mod (
   id int(11) NOT NULL auto_increment,
   user_id int(11) DEFAULT '0' NOT NULL,
   forum_id int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   UNIQUE fud26_mod_i_uf (user_id, forum_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_mod_que'
#

CREATE TABLE fud26_mod_que (
   id int(11) NOT NULL auto_increment,
   msg_id int(11) DEFAULT '0' NOT NULL,
   forum_id int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_msg'
#

CREATE TABLE fud26_msg (
   id int(11) NOT NULL auto_increment,
   thread_id int(11) DEFAULT '0' NOT NULL,
   poster_id int(11) DEFAULT '0' NOT NULL,
   reply_to int(11) DEFAULT '0' NOT NULL,
   ip_addr varchar(15) DEFAULT '0.0.0.0' NOT NULL,
   host_name varchar(255),
   post_stamp bigint(20) DEFAULT '0' NOT NULL,
   update_stamp bigint(20) DEFAULT '0' NOT NULL,
   updated_by int(11) DEFAULT '0' NOT NULL,
   icon varchar(100),
   subject varchar(100) NOT NULL,
   attach_cnt int(11) DEFAULT '0' NOT NULL,
   poll_id int(11) DEFAULT '0' NOT NULL,
   foff bigint(20) DEFAULT '0' NOT NULL,
   length int(11) DEFAULT '0' NOT NULL,
   file_id int(11) DEFAULT '1' NOT NULL,
   offset_preview bigint(20) DEFAULT '0' NOT NULL,
   length_preview int(11) DEFAULT '0' NOT NULL,
   file_id_preview int(11) DEFAULT '0' NOT NULL,
   attach_cache text,
   poll_cache text,
   mlist_msg_id varchar(100),
   msg_opt int(11) DEFAULT '1' NOT NULL,
   apr int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_msg_i_ta (thread_id, apr),
   KEY fud26_msg_i_ps (post_stamp),
   KEY fud26_msg_i_pa (poster_id, apr),
   KEY fud26_msg_i_a (apr),
   KEY fud26_msg_i_ac (attach_cnt),
   KEY fud26_msg_i_pi (poll_id),
   KEY fud26_msg_i_ip (ip_addr, post_stamp),
   KEY fud26_msg_i_mmi (mlist_msg_id),
   KEY fud26_msg_i_s (subject)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_msg_report'
#

CREATE TABLE fud26_msg_report (
   id int(11) NOT NULL auto_increment,
   msg_id int(11) DEFAULT '0' NOT NULL,
   user_id int(11) DEFAULT '0' NOT NULL,
   reason varchar(255),
   stamp bigint(20) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_msg_report_i_mu (msg_id, user_id),
   KEY fud26_msg_report_i_u (user_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_nntp'
#

CREATE TABLE fud26_nntp (
   id int(11) NOT NULL auto_increment,
   forum_id int(11) DEFAULT '0' NOT NULL,
   nntp_opt int(11) DEFAULT '44' NOT NULL,
   server varchar(255) NOT NULL,
   newsgroup varchar(255) NOT NULL,
   port int(11) DEFAULT '0' NOT NULL,
   timeout int(11) DEFAULT '0' NOT NULL,
   login varchar(255),
   pass varchar(255),
   PRIMARY KEY (id),
   KEY fud26_nntp_i_f (forum_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_pmsg'
#

CREATE TABLE fud26_pmsg (
   id int(11) NOT NULL auto_increment,
   to_list text,
   ouser_id int(11) DEFAULT '0' NOT NULL,
   duser_id int(11) DEFAULT '0' NOT NULL,
   pdest int(11) DEFAULT '0' NOT NULL,
   ip_addr varchar(15) DEFAULT '0.0.0.0' NOT NULL,
   host_name varchar(255),
   post_stamp bigint(20) DEFAULT '0' NOT NULL,
   read_stamp bigint(20) DEFAULT '0' NOT NULL,
   icon varchar(100),
   subject varchar(100) NOT NULL,
   attach_cnt int(11) DEFAULT '0' NOT NULL,
   foff bigint(20) DEFAULT '0' NOT NULL,
   length int(11) DEFAULT '0' NOT NULL,
   ref_msg_id varchar(11),
   fldr int(11) DEFAULT '0' NOT NULL,
   pmsg_opt int(11) DEFAULT '49' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_pmsg_i_dfr (duser_id, fldr, read_stamp),
   KEY fud26_pmsg_i_dfi (duser_id, fldr, id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_poll'
#

CREATE TABLE fud26_poll (
   id int(11) NOT NULL auto_increment,
   name varchar(255) NOT NULL,
   owner int(11) DEFAULT '0' NOT NULL,
   creation_date bigint(20) DEFAULT '0' NOT NULL,
   expiry_date bigint(20) DEFAULT '0' NOT NULL,
   max_votes int(11),
   total_votes int(11) DEFAULT '0' NOT NULL,
   forum_id int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_poll_i_o (owner)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_poll_opt'
#

CREATE TABLE fud26_poll_opt (
   id int(11) NOT NULL auto_increment,
   poll_id int(11) DEFAULT '0' NOT NULL,
   name varchar(255) NOT NULL,
   count int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_poll_opt_i_p (poll_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_poll_opt_track'
#

CREATE TABLE fud26_poll_opt_track (
   id int(11) NOT NULL auto_increment,
   poll_id int(11) DEFAULT '0' NOT NULL,
   user_id int(11) DEFAULT '0' NOT NULL,
   poll_opt int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   UNIQUE fud26_poll_opt_track_i_pu (poll_id, user_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_read'
#

CREATE TABLE fud26_read (
   id int(11) NOT NULL auto_increment,
   thread_id int(11) DEFAULT '0' NOT NULL,
   user_id int(11) DEFAULT '0' NOT NULL,
   msg_id int(11) DEFAULT '0' NOT NULL,
   last_view bigint(20) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   UNIQUE fud26_read_i_tu (thread_id, user_id),
   KEY fud26_read_i_u (user_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_replace'
#

CREATE TABLE fud26_replace (
   id int(11) NOT NULL auto_increment,
   replace_str varchar(255) NOT NULL,
   with_str varchar(255) NOT NULL,
   from_post varchar(255),
   to_msg varchar(255),
   replace_opt int(11) DEFAULT '1' NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_search'
#

CREATE TABLE fud26_search (
   id int(11) NOT NULL auto_increment,
   word varchar(50) NOT NULL,
   PRIMARY KEY (id),
   UNIQUE fud26_search_i_w (word)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_search_cache'
#

CREATE TABLE fud26_search_cache (
   srch_query varchar(32) NOT NULL,
   query_type int(11) DEFAULT '0' NOT NULL,
   expiry int(11) DEFAULT '0' NOT NULL,
   msg_id int(11) DEFAULT '0' NOT NULL,
   n_match int(11) DEFAULT '0' NOT NULL,
   KEY fud26_search_cache_i_sq (srch_query, query_type),
   KEY fud26_search_cache_i_e (expiry)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_ses'
#

CREATE TABLE fud26_ses (
   id int(11) NOT NULL auto_increment,
   ses_id varchar(32) DEFAULT '0' NOT NULL,
   sys_id varchar(32) DEFAULT '0' NOT NULL,
   user_id int(11) DEFAULT '0' NOT NULL,
   action varchar(255),
   forum_id int(11) DEFAULT '0' NOT NULL,
   time_sec bigint(20) DEFAULT '0' NOT NULL,
   data text,
   returnto varchar(255),
   PRIMARY KEY (id),
   UNIQUE fud26_ses_i_s (ses_id),
   UNIQUE fud26_ses_i_u (user_id),
   KEY fud26_ses_i_tu (time_sec, user_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_smiley'
#

CREATE TABLE fud26_smiley (
   id int(11) NOT NULL auto_increment,
   img varchar(255) NOT NULL,
   descr varchar(255) NOT NULL,
   code varchar(25) NOT NULL,
   vieworder int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_stats_cache'
#

CREATE TABLE fud26_stats_cache (
   user_count int(11) DEFAULT '0' NOT NULL,
   last_user_id int(11) DEFAULT '0' NOT NULL,
   online_users_reg int(11) DEFAULT '0' NOT NULL,
   online_users_anon int(11) DEFAULT '0' NOT NULL,
   online_users_hidden int(11) DEFAULT '0' NOT NULL,
   online_users_text text,
   cache_age bigint(20) DEFAULT '0' NOT NULL,
   KEY fud26_stats_cache_i_c (cache_age)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_themes'
#

CREATE TABLE fud26_themes (
   id int(11) NOT NULL auto_increment,
   name varchar(255),
   theme varchar(255),
   lang varchar(255),
   locale varchar(32),
   pspell_lang varchar(32),
   theme_opt int(11) DEFAULT '1' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_themes_i_t (theme_opt)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_thr_exchange'
#

CREATE TABLE fud26_thr_exchange (
   id int(11) NOT NULL auto_increment,
   th int(11) DEFAULT '0' NOT NULL,
   frm int(11) DEFAULT '0' NOT NULL,
   req_by int(11) DEFAULT '0' NOT NULL,
   reason_msg text,
   PRIMARY KEY (id),
   KEY fud26_thr_exchange_i_f (frm)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_thread'
#

CREATE TABLE fud26_thread (
   id int(11) NOT NULL auto_increment,
   forum_id int(11) DEFAULT '0' NOT NULL,
   root_msg_id int(11) DEFAULT '0' NOT NULL,
   last_post_date bigint(20) DEFAULT '0' NOT NULL,
   replies int(11) DEFAULT '0' NOT NULL,
   views int(11) DEFAULT '0' NOT NULL,
   rating int(11) DEFAULT '0' NOT NULL,
   n_rating int(11) DEFAULT '0' NOT NULL,
   last_post_id int(11) DEFAULT '0' NOT NULL,
   moved_to int(11) DEFAULT '0' NOT NULL,
   orderexpiry bigint(20) DEFAULT '0' NOT NULL,
   thread_opt int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_thread_i_flm (forum_id, last_post_date, moved_to),
   KEY fud26_thread_i_t (thread_opt),
   KEY fud26_thread_i_rmi (root_msg_id),
   KEY fud26_thread_i_r (replies)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_thread_notify'
#

CREATE TABLE fud26_thread_notify (
   id int(11) NOT NULL auto_increment,
   user_id int(11) DEFAULT '0' NOT NULL,
   thread_id int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_thread_notify_i_ut (user_id, thread_id),
   KEY fud26_thread_notify_i_t (thread_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_thread_rate_track'
#

CREATE TABLE fud26_thread_rate_track (
   id int(11) NOT NULL auto_increment,
   thread_id int(11) DEFAULT '0' NOT NULL,
   user_id int(11) DEFAULT '0' NOT NULL,
   stamp bigint(20) DEFAULT '0' NOT NULL,
   rating int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   UNIQUE fud26_thread_rate_track_i_tu (thread_id, user_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_thread_view'
#

CREATE TABLE fud26_thread_view (
   forum_id int(11) DEFAULT '0' NOT NULL,
   page int(11) DEFAULT '0' NOT NULL,
   thread_id int(11) DEFAULT '0' NOT NULL,
   pos int(11) NOT NULL auto_increment,
   tmp int(11),
   UNIQUE fud26_thread_view_i_fps (forum_id, page, pos),
   KEY fud26_thread_view_i_ft (forum_id, thread_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_title_index'
#

CREATE TABLE fud26_title_index (
   id int(11) NOT NULL auto_increment,
   word_id int(11) DEFAULT '0' NOT NULL,
   msg_id int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY fud26_title_index_i_wm (word_id, msg_id),
   KEY fud26_title_index_i_m (msg_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_user_ignore'
#

CREATE TABLE fud26_user_ignore (
   id int(11) NOT NULL auto_increment,
   ignore_id int(11) DEFAULT '0' NOT NULL,
   user_id int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   UNIQUE fud26_user_ignore_i_ui (user_id, ignore_id)
);


# --------------------------------------------------------
#
# Table structure for table 'fud26_users'
#

CREATE TABLE fud26_users (
   id int(11) NOT NULL auto_increment,
   login varchar(50) NOT NULL,
   alias varchar(50) binary NOT NULL,
   passwd varchar(32) NOT NULL,
   name varchar(255) NOT NULL,
   email varchar(255) NOT NULL,
   location varchar(255),
   interests varchar(255),
   occupation varchar(255),
   avatar int(11) DEFAULT '0' NOT NULL,
   avatar_loc text,
   icq bigint(20),
   aim varchar(255),
   yahoo varchar(255),
   msnm varchar(255),
   jabber varchar(255),
   affero varchar(255),
   posts_ppg int(11) DEFAULT '0' NOT NULL,
   time_zone varchar(255) DEFAULT 'America/Montreal' NOT NULL,
   bday int(11) DEFAULT '0' NOT NULL,
   join_date bigint(20) DEFAULT '0' NOT NULL,
   conf_key varchar(32) DEFAULT '0' NOT NULL,
   user_image varchar(255),
   theme int(11) DEFAULT '0' NOT NULL,
   posted_msg_count int(11) DEFAULT '0' NOT NULL,
   last_visit bigint(20) DEFAULT '0' NOT NULL,
   referer_id int(11) DEFAULT '0' NOT NULL,
   last_read bigint(20) DEFAULT '0' NOT NULL,
   custom_status text,
   sig text,
   level_id int(11) DEFAULT '0' NOT NULL,
   reset_key varchar(32) DEFAULT '0' NOT NULL,
   u_last_post_id int(11) DEFAULT '0' NOT NULL,
   home_page varchar(255),
   bio text,
   cat_collapse_status text,
   custom_color varchar(255),
   buddy_list text,
   ignore_list text,
   group_leader_list text,
   users_opt int(11) DEFAULT '4488117' NOT NULL,
   PRIMARY KEY (id),
   UNIQUE fud26_users_i_l (login),
   UNIQUE fud26_users_i_e (email),
   UNIQUE fud26_users_i_a (alias),
   KEY fud26_users_i_rk (reset_key),
   KEY fud26_users_i_lv (last_visit),
   KEY fud26_users_i_ck (conf_key),
   KEY fud26_users_i_ri (referer_id),
   KEY fud26_users_i_uo (users_opt)
);