mysql_tables.php

sabreipb 2.1.6 utf-8中文版本！

<?php

# Don't forget to remove TYPE=MyISAM AND FULLTEXT INDEXES
# ); must be the last character, no spaces!

$TABLE[] = "CREATE TABLE ibf_admin_logs (
  id bigint(20) NOT NULL auto_increment,
  act varchar(255) default NULL,
  code varchar(255) default NULL,
  member_id int(10) default NULL,
  ctime int(10) default NULL,
  note text,
  ip_address varchar(255) default NULL,
  PRIMARY KEY  (id)
);";

# IPB 2.1: BETA 2
$TABLE[] = "CREATE TABLE ibf_admin_permission_rows (
	row_member_id	INT(8) NOT NULL,
	row_perm_cache	MEDIUMTEXT,
	row_updated		INT(10) NOT NULL DEFAULT '0',
	PRIMARY KEY (row_member_id)
);";

# IPB 2.1: BETA 2
$TABLE[] = "CREATE TABLE ibf_admin_permission_keys (
	perm_key	VARCHAR(255) NOT NULL,
	perm_main	VARCHAR(255) NOT NULL,
	perm_child	VARCHAR(255) NOT NULL,
	perm_bit	VARCHAR(255) NOT NULL,
	PRIMARY KEY    (perm_key),
	KEY	perm_main  (perm_main),
	KEY perm_child (perm_child)
);";

$TABLE[] = "CREATE TABLE ibf_admin_sessions (
  session_id varchar(32) NOT NULL default '',
  session_ip_address varchar(32) NOT NULL default '',
  session_member_name varchar(250) NOT NULL default '',
  session_member_id mediumint(8) NOT NULL default '0',
  session_member_login_key varchar(32) NOT NULL default '',
  session_location varchar(64) NOT NULL default '',
  session_log_in_time int(10) NOT NULL default '0',
  session_running_time int(10) NOT NULL default '0',
  PRIMARY KEY  (session_id)
);";

$TABLE[] = "CREATE TABLE ibf_announcements (
  announce_id int(10) unsigned NOT NULL auto_increment,
  announce_title varchar(255) NOT NULL default '',
  announce_post text NOT NULL,
  announce_forum text NOT NULL,
  announce_member_id mediumint(8) unsigned NOT NULL default '0',
  announce_html_enabled tinyint(1) NOT NULL default '0',
  announce_views int(10) unsigned NOT NULL default '0',
  announce_start int(10) unsigned NOT NULL default '0',
  announce_end int(10) unsigned NOT NULL default '0',
  announce_active tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (announce_id)
);";

$TABLE[] = "CREATE TABLE ibf_attachments (
  attach_id int(10) NOT NULL auto_increment,
  attach_ext varchar(10) NOT NULL default '',
  attach_file varchar(250) NOT NULL default '',
  attach_location varchar(250) NOT NULL default '',
  attach_thumb_location varchar(250) NOT NULL default '',
  attach_thumb_width smallint(5) NOT NULL default '0',
  attach_thumb_height smallint(5) NOT NULL default '0',
  attach_is_image tinyint(1) NOT NULL default '0',
  attach_hits int(10) NOT NULL default '0',
  attach_date int(10) NOT NULL default '0',
  attach_temp tinyint(1) NOT NULL default '0',
  attach_pid int(10) NOT NULL default '0',
  attach_post_key varchar(32) NOT NULL default '0',
  attach_msg int(10) NOT NULL default '0',
  attach_member_id mediumint(8) NOT NULL default '0',
  attach_approved int(10) NOT NULL default '1',
  attach_filesize int(10) NOT NULL default '0',
  PRIMARY KEY  (attach_id),
  KEY attach_pid (attach_pid),
  KEY attach_msg (attach_msg),
  KEY attach_post_key (attach_post_key),
  KEY attach_mid_size (attach_member_id,attach_filesize)
);";

$TABLE[] = "CREATE TABLE ibf_attachments_type (
  atype_id int(10) NOT NULL auto_increment,
  atype_extension varchar(18) NOT NULL default '',
  atype_mimetype varchar(255) NOT NULL default '',
  atype_post tinyint(1) NOT NULL default '1',
  atype_photo tinyint(1) NOT NULL default '0',
  atype_img text NOT NULL,
  PRIMARY KEY  (atype_id)
);";

$TABLE[] = "CREATE TABLE ibf_badwords (
  wid int(3) NOT NULL auto_increment,
  type varchar(250) NOT NULL default '',
  swop varchar(250) default NULL,
  m_exact tinyint(1) default '0',
  PRIMARY KEY  (wid)
);";

$TABLE[] = "CREATE TABLE ibf_banfilters (
  ban_id int(10) NOT NULL auto_increment,
  ban_type varchar(10) NOT NULL default 'ip',
  ban_content text NOT NULL,
  ban_date int(10) NOT NULL default '0',
  PRIMARY KEY  (ban_id)
);";

$TABLE[] = "CREATE TABLE ibf_bulk_mail (
  mail_id int(10) NOT NULL auto_increment,
  mail_subject varchar(255) NOT NULL default '',
  mail_content mediumtext NOT NULL,
  mail_groups mediumtext NOT NULL,
  mail_honor tinyint(1) NOT NULL default '1',
  mail_opts mediumtext NOT NULL,
  mail_start int(10) NOT NULL default '0',
  mail_updated int(10) NOT NULL default '0',
  mail_sentto int(10) NOT NULL default '0',
  mail_active tinyint(1) NOT NULL default '0',
  mail_pergo smallint(5) NOT NULL default '0',
  PRIMARY KEY  (mail_id)
);";

$TABLE[] = "CREATE TABLE ibf_cache_store (
  cs_key varchar(255) NOT NULL default '',
  cs_value mediumtext NOT NULL,
  cs_extra varchar(255) NOT NULL default '',
  cs_array tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (cs_key)
);";


$TABLE[] = "CREATE TABLE ibf_cal_calendars (
  cal_id int(10) unsigned NOT NULL auto_increment,
  cal_title varchar(255) NOT NULL default '0',
  cal_moderate tinyint(1) NOT NULL default '0',
  cal_position int(3) NOT NULL default '0',
  cal_event_limit int(2) unsigned NOT NULL default '0',
  cal_bday_limit int(2) unsigned NOT NULL default '0',
  cal_rss_export tinyint(1) NOT NULL default '0',
  cal_rss_export_days int(3) unsigned NOT NULL default '0',
  cal_rss_export_max tinyint(1) NOT NULL default '0',
  cal_rss_update int(3) unsigned NOT NULL default '0',
  cal_rss_update_last int(10) unsigned NOT NULL default '0',
  cal_rss_cache mediumtext NOT NULL,
  cal_permissions mediumtext NOT NULL,
  PRIMARY KEY  (cal_id)
);";

$TABLE[] = "CREATE TABLE ibf_cal_events (
  event_id int(10) unsigned NOT NULL auto_increment,
  event_calendar_id int(10) unsigned NOT NULL default '0',
  event_member_id mediumint(8) unsigned NOT NULL default '0',
  event_content mediumtext NOT NULL,
  event_title varchar(255) NOT NULL default '',
  event_smilies tinyint(1) NOT NULL default '0',
  event_perms text NOT NULL,
  event_private tinyint(1) NOT NULL default '0',
  event_approved tinyint(1) NOT NULL default '0',
  event_unixstamp int(10) unsigned NOT NULL default '0',
  event_recurring int(2) unsigned NOT NULL default '0',
  event_tz int(4) NOT NULL default '0',
  event_timeset VARCHAR( 6 ) DEFAULT '0' NOT NULL,
  event_unix_from int(10) unsigned NOT NULL default '0',
  event_unix_to int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (event_id),
  KEY daterange (event_calendar_id,event_approved,event_unix_from,event_unix_to),
  KEY approved (event_calendar_id,event_approved)
);";


$TABLE[] = "CREATE TABLE ibf_calendar_events (
  eventid mediumint(8) NOT NULL auto_increment,
  userid mediumint(8) NOT NULL default '0',
  year int(4) NOT NULL default '2002',
  month int(2) NOT NULL default '1',
  mday int(2) NOT NULL default '1',
  title varchar(254) NOT NULL default 'no title',
  event_text text NOT NULL,
  read_perms varchar(254) NOT NULL default '*',
  unix_stamp int(10) NOT NULL default '0',
  priv_event tinyint(1) NOT NULL default '0',
  show_emoticons tinyint(1) NOT NULL default '1',
  rating smallint(2) NOT NULL default '1',
  event_ranged tinyint(1) NOT NULL default '0',
  event_repeat tinyint(1) NOT NULL default '0',
  repeat_unit char(2) NOT NULL default '',
  end_day int(2) default NULL,
  end_month int(2) default NULL,
  end_year int(4) default NULL,
  end_unix_stamp int(10) default NULL,
  event_bgcolor varchar(32) NOT NULL default '',
  event_color varchar(32) NOT NULL default '',
  PRIMARY KEY  (eventid),
  KEY unix_stamp (unix_stamp)
);";

$TABLE[] = "CREATE TABLE ibf_components (
  com_id int(10) NOT NULL auto_increment,
  com_title varchar(255) NOT NULL default '',
  com_author varchar(255) NOT NULL default '',
  com_url varchar(255) NOT NULL default '',
  com_version varchar(255) NOT NULL default '',
  com_date_added int(10) NOT NULL default '0',
  com_menu_data mediumtext NOT NULL,
  com_enabled tinyint(1) NOT NULL default '1',
  com_safemode tinyint(1) NOT NULL default '1',
  com_section varchar(255) NOT NULL default '',
  com_filename varchar(255) NOT NULL default '',
  com_description varchar(255) NOT NULL default '',
  com_url_title varchar(255) NOT NULL default '',
  com_url_uri varchar(255) NOT NULL default '',
  com_position int(3) NOT NULL default '10',
  PRIMARY KEY  (com_id)
);";

$TABLE[] = "CREATE TABLE ibf_conf_settings (
  conf_id int(10) NOT NULL auto_increment,
  conf_title text NOT NULL,
  conf_description text NOT NULL,
  conf_group varchar(255) NOT NULL default '',
  conf_type varchar(255) NOT NULL default '',
  conf_key text NOT NULL,
  conf_value text NOT NULL,
  conf_default text NOT NULL,
  conf_extra text NOT NULL,
  conf_evalphp text NOT NULL,
  conf_protected tinyint(1) NOT NULL default '0',
  conf_position smallint(3) NOT NULL default '0',
  conf_start_group varchar(255) NOT NULL default '',
  conf_end_group tinyint(1) NOT NULL default '0',
  conf_help_key varchar(255) NOT NULL default '0',
  conf_add_cache tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (conf_id)
);";

$TABLE[] = "CREATE TABLE ibf_conf_settings_titles (
  conf_title_id smallint(3) NOT NULL auto_increment,
  conf_title_title varchar(255) NOT NULL default '',
  conf_title_desc text NOT NULL,
  conf_title_count smallint(3) NOT NULL default '0',
  conf_title_noshow tinyint(1) NOT NULL default '0',
  conf_title_keyword varchar(200) NOT NULL default '0',
  PRIMARY KEY  (conf_title_id)
);";

$TABLE[] = "CREATE TABLE ibf_contacts (
  id mediumint(8) NOT NULL auto_increment,
  contact_id mediumint(8) NOT NULL default '0',
  member_id mediumint(8) NOT NULL default '0',
  contact_name varchar(32) NOT NULL default '',
  allow_msg tinyint(1) default NULL,
  contact_desc varchar(50) default NULL,
  PRIMARY KEY  (id)
);";

$TABLE[] = "CREATE TABLE ibf_custom_bbcode (
  bbcode_id int(10) NOT NULL auto_increment,
  bbcode_title varchar(255) NOT NULL default '',
  bbcode_desc text NOT NULL,
  bbcode_tag varchar(255) NOT NULL default '',
  bbcode_replace text NOT NULL,
  bbcode_useoption tinyint(1) NOT NULL default '0',
  bbcode_example text NOT NULL,
  PRIMARY KEY  (bbcode_id)
);";

$TABLE[] = "CREATE TABLE ibf_dnames_change (
  dname_id int(10) NOT NULL auto_increment,
  dname_member_id int(8) NOT NULL default '0',
  dname_date int(10) NOT NULL default '0',
  dname_ip_address varchar(16) NOT NULL default '',
  dname_previous varchar(255) NOT NULL default '',
  dname_current varchar(255) NOT NULL default '',
  PRIMARY KEY  (dname_id),
  KEY dname_member_id (dname_member_id),
  KEY date_id (dname_member_id,dname_date)
);";

$TABLE[] = "CREATE TABLE ibf_email_logs (
  email_id int(10) NOT NULL auto_increment,
  email_subject varchar(255) NOT NULL default '',
  email_content text NOT NULL,
  email_date int(10) NOT NULL default '0',
  from_member_id mediumint(8) NOT NULL default '0',
  from_email_address varchar(250) NOT NULL default '',
  from_ip_address varchar(16) NOT NULL default '127.0.0.1',
  to_member_id mediumint(8) NOT NULL default '0',
  to_email_address varchar(250) NOT NULL default '',
  topic_id int(10) NOT NULL default '0',
  PRIMARY KEY  (email_id),
  KEY from_member_id (from_member_id),
  KEY email_date (email_date)
);";

$TABLE[] = "CREATE TABLE ibf_emoticons (
  id smallint(3) NOT NULL auto_increment,
  typed varchar(32) NOT NULL default '',
  image varchar(128) NOT NULL default '',
  clickable smallint(2) NOT NULL default '1',
  emo_set varchar(64) NOT NULL default 'default',
  PRIMARY KEY  (id)
);";

$TABLE[] = "CREATE TABLE ibf_faq (
  id mediumint(8) NOT NULL auto_increment,
  title varchar(128) NOT NULL default '',
  text text,
  description text NOT NULL,
  PRIMARY KEY  (id)
);";

$TABLE[] = "CREATE TABLE ibf_forum_perms (
  perm_id int(10) NOT NULL auto_increment,
  perm_name varchar(250) NOT NULL default '',
  PRIMARY KEY  (perm_id)
);";

$TABLE[] = "CREATE TABLE ibf_forum_tracker (
  frid mediumint(8) NOT NULL auto_increment,
  member_id varchar(32) NOT NULL default '',
  forum_id smallint(5) NOT NULL default '0',
  start_date int(10) default NULL,
  last_sent int(10) NOT NULL default '0',
  forum_track_type varchar(100) NOT NULL default 'delayed',
  PRIMARY KEY  (frid)
);";

$TABLE[] = "CREATE TABLE ibf_forums (
  id smallint(5) NOT NULL default '0',
  topics mediumint(6) default NULL,
  posts mediumint(6) default NULL,
  last_post int(10) default NULL,
  last_poster_id mediumint(8) NOT NULL default '0',
  last_poster_name varchar(32) default NULL,
  name varchar(128) NOT NULL default '',
  description text,
  position tinyint(2) default NULL,
  use_ibc tinyint(1) default NULL,
  use_html tinyint(1) default NULL,
  status tinyint(1) default '1',
  password varchar(32) default NULL,
  last_title varchar(128) default NULL,
  last_id int(10) default NULL,
  sort_key varchar(32) default NULL,
  sort_order varchar(32) default NULL,
  prune tinyint(3) default NULL,
  topicfilter VARCHAR( 32 ) DEFAULT 'all' NOT NULL, 
  show_rules tinyint(1) default NULL,
  preview_posts tinyint(1) default NULL,
  allow_poll tinyint(1) NOT NULL default '1',
  allow_pollbump tinyint(1) NOT NULL default '0',
  inc_postcount tinyint(1) NOT NULL default '1',
  skin_id int(10) default NULL,
  parent_id mediumint(5) default '-1',
  quick_reply tinyint(1) default '0',
  redirect_url varchar(250) default '',
  redirect_on tinyint(1) NOT NULL default '0',
  redirect_hits int(10) NOT NULL default '0',
  redirect_loc varchar(250) default '',
  rules_title varchar(255) NOT NULL default '',
  rules_text text NOT NULL,
  topic_mm_id varchar(250) NOT NULL default '',
  notify_modq_emails text,
  sub_can_post tinyint(1) default '1',
  permission_custom_error text NOT NULL,
  permission_array mediumtext NOT NULL,
  permission_showtopic tinyint(1) NOT NULL default '0',
  queued_topics mediumint(6) NOT NULL default '0',
  queued_posts mediumint(6) NOT NULL default '0',
  forum_allow_rating tinyint(1) NOT NULL default '0',
  forum_last_deletion int(10) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY position (position,parent_id)
);";

$TABLE[] = "CREATE TABLE ibf_groups (
  g_id int(3) unsigned NOT NULL auto_increment,
  g_view_board tinyint(1) default NULL,
  g_mem_info tinyint(1) default NULL,
  g_other_topics tinyint(1) default NULL,
  g_use_search tinyint(1) default NULL,
  g_email_friend tinyint(1) default NULL,
  g_invite_friend tinyint(1) default NULL,
  g_edit_profile tinyint(1) default NULL,
  g_post_new_topics tinyint(1) default NULL,
  g_reply_own_topics tinyint(1) default NULL,
  g_reply_other_topics tinyint(1) default NULL,
  g_edit_posts tinyint(1) default NULL,
  g_delete_own_posts tinyint(1) default NULL,
  g_open_close_posts tinyint(1) default NULL,
  g_delete_own_topics tinyint(1) default NULL,
  g_post_polls tinyint(1) default NULL,
  g_vote_polls tinyint(1) default NULL,
  g_use_pm tinyint(1) default NULL,
  g_is_supmod tinyint(1) default NULL,
  g_access_cp tinyint(1) default NULL,
  g_title varchar(32) NOT NULL default '',
  g_can_remove tinyint(1) default NULL,