mysql_tables.php

sabreipb 2.1.6 utf-8中文版本！

  g_append_edit tinyint(1) default NULL,
  g_access_offline tinyint(1) default NULL,
  g_avoid_q tinyint(1) default NULL,
  g_avoid_flood tinyint(1) default NULL,
  g_icon text NOT NULL,
  g_attach_max bigint(20) default NULL,
  g_avatar_upload tinyint(1) default '0',
  g_calendar_post tinyint(1) default '0',
  prefix varchar(250) default NULL,
  suffix varchar(250) default NULL,
  g_max_messages int(5) default '50',
  g_max_mass_pm int(5) default '0',
  g_search_flood mediumint(6) default '20',
  g_edit_cutoff int(10) default '0',
  g_promotion varchar(10) default '-1&-1',
  g_hide_from_list tinyint(1) default '0',
  g_post_closed tinyint(1) default '0',
  g_perm_id varchar(255) NOT NULL default '',
  g_photo_max_vars varchar(200) default '',
  g_dohtml tinyint(1) NOT NULL default '0',
  g_edit_topic tinyint(1) NOT NULL default '0',
  g_email_limit varchar(15) NOT NULL default '10:15',
  g_bypass_badwords tinyint(1) NOT NULL default '0',
  g_can_msg_attach tinyint(1) NOT NULL default '0',
  g_attach_per_post int(10) NOT NULL default '0',
  g_topic_rate_setting smallint(2) NOT NULL default '0',
  g_dname_changes INT(3) NOT NULL default '0',
  g_dname_date    INT(5) NOT NULL default '0',
  PRIMARY KEY  (g_id)
);";

$TABLE[] = "CREATE TABLE ibf_languages (
  lid mediumint(8) NOT NULL auto_increment,
  ldir varchar(64) NOT NULL default '',
  lname varchar(250) NOT NULL default '',
  lauthor varchar(250) default NULL,
  lemail varchar(250) default NULL,
  PRIMARY KEY  (lid)
);";

$TABLE[] = "CREATE TABLE ibf_login_methods (
  login_id int(10) NOT NULL auto_increment,
  login_title varchar(255) NOT NULL default '',
  login_description varchar(255) NOT NULL default '',
  login_folder_name varchar(255) NOT NULL default '',
  login_maintain_url varchar(255) NOT NULL default '',
  login_register_url varchar(255) NOT NULL default '',
  login_type varchar(30) NOT NULL default '',
  login_alt_login_html text,
  login_date int(10) NOT NULL default '0',
  login_settings int(1) NOT NULL default '0',
  login_enabled int(1) NOT NULL default '0',
  login_safemode int(1) NOT NULL default '0',
  login_installed int(1) NOT NULL default '0',
  login_replace_form int(1) NOT NULL default '0',
  login_allow_create int(1) NOT NULL default '0',
  PRIMARY KEY  (login_id)
);";

$TABLE[] = "CREATE TABLE ibf_mail_error_logs (
  mlog_id int(10) NOT NULL auto_increment,
  mlog_date int(10) NOT NULL default '0',
  mlog_to varchar(250) NOT NULL default '',
  mlog_from varchar(250) NOT NULL default '',
  mlog_subject varchar(250) NOT NULL default '',
  mlog_content varchar(250) NOT NULL default '',
  mlog_msg text NOT NULL,
  mlog_code varchar(200) NOT NULL default '',
  mlog_smtp_msg text NOT NULL,
  PRIMARY KEY  (mlog_id)
);";

$TABLE[] = "CREATE TABLE ibf_mail_queue (
  mail_id int(10) NOT NULL auto_increment,
  mail_date int(10) NOT NULL default '0',
  mail_to varchar(255) NOT NULL default '',
  mail_from varchar(255) NOT NULL default '',
  mail_subject text NOT NULL,
  mail_content text NOT NULL,
  mail_type varchar(200) NOT NULL default '',
  PRIMARY KEY  (mail_id)
);";

$TABLE[] = "CREATE TABLE ibf_member_extra (
  id mediumint(8) NOT NULL default '0',
  notes text,
  links text,
  bio text,
  ta_size char(3) default NULL,
  photo_type varchar(10) default '',
  photo_location varchar(255) default '',
  photo_dimensions varchar(200) default '',
  aim_name varchar(40) NOT NULL default '',
  icq_number int(15) NOT NULL default '0',
  website varchar(250) NOT NULL default '',
  yahoo varchar(40) NOT NULL default '',
  interests text NOT NULL,
  msnname varchar(200) NOT NULL default '',
  vdirs text NOT NULL,
  location varchar(250) NOT NULL default '',
  signature text NOT NULL,
  avatar_location varchar(128) NOT NULL default '',
  avatar_size varchar(9) NOT NULL default '',
  avatar_type varchar(15) NOT NULL default 'local',
  PRIMARY KEY  (id)
);";

$TABLE[] = "CREATE TABLE ibf_members (
  id mediumint(8) NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  mgroup smallint(3) NOT NULL default '0',
  legacy_password varchar(32) NOT NULL default '',
  email varchar(150) NOT NULL default '',
  joined int(10) NOT NULL default '0',
  ip_address varchar(16) NOT NULL default '',
  posts mediumint(7) default '0',
  title varchar(64) default NULL,
  allow_admin_mails tinyint(1) default NULL,
  time_offset varchar(10) default NULL,
  hide_email varchar(8) default NULL,
  email_pm tinyint(1) default '1',
  email_full tinyint(1) default NULL,
  skin smallint(5) default NULL,
  warn_level int(10) default NULL,
  warn_lastwarn int(10) NOT NULL default '0',
  language varchar(32) default NULL,
  last_post int(10) default NULL,
  restrict_post varchar(100) NOT NULL default '0',
  view_sigs tinyint(1) default '1',
  view_img tinyint(1) default '1',
  view_avs tinyint(1) default '1',
  view_pop tinyint(1) default '1',
  bday_day int(2) default NULL,
  bday_month int(2) default NULL,
  bday_year int(4) default NULL,
  new_msg tinyint(2) default '0',
  msg_total smallint(5) default '0',
  show_popup tinyint(1) default '0',
  misc varchar(128) default NULL,
  last_visit int(10) default '0',
  last_activity int(10) default '0',
  dst_in_use tinyint(1) default '0',
  view_prefs varchar(64) default '-1&-1',
  coppa_user tinyint(1) default '0',
  mod_posts varchar(100) NOT NULL default '0',
  auto_track varchar(50) default '0',
  temp_ban varchar(100) default '0',
  sub_end int(10) NOT NULL default '0',
  login_anonymous char(3) NOT NULL default '0&0',
  ignored_users text NOT NULL,
  mgroup_others varchar(255) NOT NULL default '',
  org_perm_id varchar(255) NOT NULL default '',
  member_login_key varchar(32) NOT NULL default '',
  subs_pkg_chosen smallint(3) NOT NULL default '0',
  has_blog tinyint(1) NOT NULL default '0',
  members_markers text NOT NULL,
  members_editor_choice char(3) NOT NULL default 'std',
  members_auto_dst tinyint(1) NOT NULL default '1',
  members_display_name varchar(255) NOT NULL default '',
  members_created_remote tinyint(1) NOT NULL default '0',
  members_cache MEDIUMTEXT default '',
  members_disable_pm INT(1) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY members_display_name (members_display_name),
  KEY name (name),
  KEY mgroup (mgroup),
  KEY bday_day (bday_day),
  KEY bday_month (bday_month)
);";

$TABLE[] = "CREATE TABLE ibf_members_converge (
  converge_id int(10) NOT NULL auto_increment,
  converge_email varchar(250) NOT NULL default '',
  converge_joined int(10) NOT NULL default '0',
  converge_pass_hash varchar(32) NOT NULL default '',
  converge_pass_salt varchar(5) NOT NULL default '',
  PRIMARY KEY  (converge_id),
  KEY converge_email (converge_email)
);";

$TABLE[] = "CREATE TABLE ibf_members_partial (
  partial_id int(10) NOT NULL auto_increment,
  partial_member_id int(8) NOT NULL default '0',
  partial_date int(10) NOT NULL default '0',
  PRIMARY KEY  (partial_id),
  KEY partial_member_id (partial_member_id)
);";

$TABLE[] = "CREATE TABLE ibf_message_text (
  msg_id int(10) NOT NULL auto_increment,
  msg_date int(10) default NULL,
  msg_post text,
  msg_cc_users text,
  msg_sent_to_count smallint(5) NOT NULL default '0',
  msg_deleted_count smallint(5) NOT NULL default '0',
  msg_post_key varchar(32) NOT NULL default '0',
  msg_author_id mediumint(8) NOT NULL default '0',
  msg_ip_address VARCHAR(16) NOT NULL default '0',
  PRIMARY KEY  (msg_id),
  KEY msg_date (msg_date),
  KEY msg_sent_to_count (msg_sent_to_count),
  KEY msg_deleted_count (msg_deleted_count)
);";

$TABLE[] = "CREATE TABLE ibf_message_topics (
  mt_id int(10) NOT NULL auto_increment,
  mt_msg_id int(10) NOT NULL default '0',
  mt_date int(10) NOT NULL default '0',
  mt_title varchar(255) NOT NULL default '',
  mt_from_id mediumint(8) NOT NULL default '0',
  mt_to_id mediumint(8) NOT NULL default '0',
  mt_vid_folder varchar(32) NOT NULL default '',
  mt_read tinyint(1) NOT NULL default '0',
  mt_hasattach smallint(5) NOT NULL default '0',
  mt_hide_cc tinyint(1) default '0',
  mt_tracking tinyint(1) default '0',
  mt_addtosent TINYINT( 1 ) DEFAULT '0' NOT NULL, 
  mt_owner_id mediumint(8) NOT NULL default '0',
  mt_user_read int(10) default '0',
  PRIMARY KEY  (mt_id),
  KEY mt_from_id (mt_from_id),
  KEY mt_owner_id (mt_owner_id,mt_to_id,mt_vid_folder,mt_date)
);";

$TABLE[] = "CREATE TABLE ibf_moderator_logs (
  id int(10) NOT NULL auto_increment,
  forum_id int(5) default '0',
  topic_id int(10) NOT NULL default '0',
  post_id int(10) default NULL,
  member_id mediumint(8) NOT NULL default '0',
  member_name varchar(32) NOT NULL default '',
  ip_address varchar(16) NOT NULL default '0',
  http_referer varchar(255) default NULL,
  ctime int(10) default NULL,
  topic_title varchar(128) default NULL,
  action varchar(128) default NULL,
  query_string varchar(128) default NULL,
  PRIMARY KEY  (id)
);";

$TABLE[] = "CREATE TABLE ibf_moderators (
  mid mediumint(8) NOT NULL auto_increment,
  forum_id int(5) NOT NULL default '0',
  member_name varchar(32) NOT NULL default '',
  member_id mediumint(8) NOT NULL default '0',
  edit_post tinyint(1) default NULL,
  edit_topic tinyint(1) default NULL,
  delete_post tinyint(1) default NULL,
  delete_topic tinyint(1) default NULL,
  view_ip tinyint(1) default NULL,
  open_topic tinyint(1) default NULL,
  close_topic tinyint(1) default NULL,
  mass_move tinyint(1) default NULL,
  mass_prune tinyint(1) default NULL,
  move_topic tinyint(1) default NULL,
  pin_topic tinyint(1) default NULL,
  unpin_topic tinyint(1) default NULL,
  post_q tinyint(1) default NULL,
  topic_q tinyint(1) default NULL,
  allow_warn tinyint(1) default NULL,
  edit_user tinyint(1) NOT NULL default '0',
  is_group tinyint(1) default '0',
  group_id smallint(3) default NULL,
  group_name varchar(200) default NULL,
  split_merge tinyint(1) default '0',
  can_mm tinyint(1) NOT NULL default '0',
  mod_can_set_open_time tinyint(1) NOT NULL default '0',
  mod_can_set_close_time tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (mid),
  KEY forum_id (forum_id),
  KEY group_id (group_id),
  KEY member_id (member_id)
);";

$TABLE[] = "CREATE TABLE ibf_pfields_content (
  member_id mediumint(8) NOT NULL default '0',
  updated int(10) default '0',
  PRIMARY KEY  (member_id)
);";

$TABLE[] = "CREATE TABLE ibf_pfields_data (
  pf_id smallint(5) NOT NULL auto_increment,
  pf_title varchar(250) NOT NULL default '',
  pf_desc varchar(250) NOT NULL default '',
  pf_content text NOT NULL,
  pf_type varchar(250) NOT NULL default '',
  pf_not_null tinyint(1) NOT NULL default '0',
  pf_member_hide tinyint(1) NOT NULL default '0',
  pf_max_input smallint(6) NOT NULL default '0',
  pf_member_edit tinyint(1) NOT NULL default '0',
  pf_position smallint(6) NOT NULL default '0',
  pf_show_on_reg tinyint(1) NOT NULL default '0',
  pf_input_format text NOT NULL,
  pf_admin_only tinyint(1) NOT NULL default '0',
  pf_topic_format text NOT NULL,
  PRIMARY KEY  (pf_id)
);";

$TABLE[] = "CREATE TABLE ibf_polls (
  pid mediumint(8) NOT NULL auto_increment,
  tid int(10) NOT NULL default '0',
  start_date int(10) default NULL,
  choices text,
  starter_id mediumint(8) NOT NULL default '0',
  votes smallint(5) NOT NULL default '0',
  forum_id smallint(5) NOT NULL default '0',
  poll_question varchar(255) default NULL,
  PRIMARY KEY  (pid)
);";

$TABLE[] = "CREATE TABLE ibf_posts (
  pid int(10) NOT NULL auto_increment,
  append_edit tinyint(1) default '0',
  edit_time int(10) default NULL,
  author_id mediumint(8) NOT NULL default '0',
  author_name varchar(32) default NULL,
  use_sig tinyint(1) NOT NULL default '0',
  use_emo tinyint(1) NOT NULL default '0',
  ip_address varchar(16) NOT NULL default '',
  post_date int(10) default NULL,
  icon_id smallint(3) default NULL,
  post text,
  queued tinyint(1) NOT NULL default '0',
  topic_id int(10) NOT NULL default '0',
  post_title varchar(255) default NULL,
  new_topic tinyint(1) default '0',
  edit_name varchar(255) default NULL,
  post_key varchar(32) NOT NULL default '0',
  post_parent int(10) NOT NULL default '0',
  post_htmlstate smallint(1) NOT NULL default '0',
  PRIMARY KEY  (pid),
  KEY topic_id (topic_id,queued,pid),
  KEY author_id (author_id,topic_id),
  KEY post_date (post_date)
);";

$TABLE[] = "CREATE TABLE ibf_reg_antispam (
  regid varchar(32) NOT NULL default '',
  regcode varchar(8) NOT NULL default '',
  ip_address varchar(32) default NULL,
  ctime int(10) default NULL,
  PRIMARY KEY  (regid)
);";

$TABLE[] = "CREATE TABLE ibf_rss_export (
  rss_export_id int(10) NOT NULL auto_increment,
  rss_export_enabled tinyint(1) NOT NULL default '0',
  rss_export_title varchar(255) NOT NULL default '',
  rss_export_desc varchar(255) NOT NULL default '',
  rss_export_image varchar(255) NOT NULL default '',
  rss_export_forums text,
  rss_export_include_post tinyint(1) NOT NULL default '0',
  rss_export_count smallint(3) NOT NULL default '0',
  rss_export_cache_time smallint(3) NOT NULL default '30',
  rss_export_cache_last int(10) NOT NULL default '0',
  rss_export_cache_content mediumtext,
  rss_export_sort varchar(4) NOT NULL default 'DESC',
  rss_export_order varchar(20) NOT NULL default 'start_date',
  PRIMARY KEY  (rss_export_id)
);";

$TABLE[] = "CREATE TABLE ibf_rss_import (
  rss_import_id int(10) NOT NULL auto_increment,
  rss_import_enabled tinyint(1) NOT NULL default '0',
  rss_import_title varchar(255) NOT NULL default '',
  rss_import_url varchar(255) NOT NULL default '',
  rss_import_forum_id int(10) NOT NULL default '0',
  rss_import_mid mediumint(8) NOT NULL default '0',
  rss_import_pergo smallint(3) NOT NULL default '0',
  rss_import_time smallint(3) NOT NULL default '0',
  rss_import_last_import int(10) NOT NULL default '0',
  rss_import_showlink varchar(255) NOT NULL default '0',
  rss_import_topic_open tinyint(1) NOT NULL default '0',
  rss_import_topic_hide tinyint(1) NOT NULL default '0',
  rss_import_inc_pcount tinyint(1) NOT NULL default '0',
  rss_import_topic_pre varchar(50) NOT NULL default '',
  rss_import_charset VARCHAR(200) NOT NULL default '',
  rss_import_allow_html TINYINT(1) NOT NULL default '0',
  rss_import_auth TINYINT( 1 ) DEFAULT '0' NOT NULL ,
  rss_import_auth_user VARCHAR( 255 ) DEFAULT 'Not Needed' NOT NULL,
  rss_import_auth_pass VARCHAR( 255 ) DEFAULT 'Not Needed' NOT NULL,
  PRIMARY KEY  (rss_import_id)
);";

$TABLE[] = "CREATE TABLE ibf_rss_imported (
  rss_imported_guid char(32) NOT NULL default '0',
  rss_imported_tid int(10) NOT NULL default '0',
  rss_imported_impid int(10) NOT NULL default '0',
  PRIMARY KEY  (rss_imported_guid),
  KEY rss_imported_impid (rss_imported_impid)
);";

$TABLE[] = "CREATE TABLE ibf_search_results (
  id varchar(32) NOT NULL default '',
  topic_id text NOT NULL,
  search_date int(12) NOT NULL default '0',
  topic_max int(3) NOT NULL default '0',
  sort_key varchar(32) NOT NULL default 'last_post',
  sort_order varchar(4) NOT NULL default 'desc',
  member_id mediumint(10) default '0',
  ip_address varchar(64) default NULL,
  post_id text,
  post_max int(10) NOT NULL default '0',