mysql_tables.php

sabreipb 2.1.6 utf-8中文版本！

  query_cache text,
  PRIMARY KEY  (id),
  KEY search_date (search_date)
);";

$TABLE[] = "CREATE TABLE ibf_sessions (
  id varchar(32) NOT NULL default '0',
  member_name varchar(64) default NULL,
  member_id mediumint(8) NOT NULL default '0',
  ip_address varchar(16) default NULL,
  browser VARCHAR(200) NOT NULL default '',
  running_time int(10) default NULL,
  login_type char(3) default '',
  location varchar(40) default NULL,
  member_group smallint(3) default NULL,
  in_error tinyint(1) NOT NULL default '0',
  location_1_type varchar(10) NOT NULL default '',
  location_1_id int(10) NOT NULL default '0',
  location_2_type varchar(10) NOT NULL default '',
  location_2_id int(10) NOT NULL default '0',
  location_3_type varchar(10) NOT NULL default '',
  location_3_id int(10) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY location1 (location_1_type,location_1_id),
  KEY location2 (location_2_type,location_2_id),
  KEY location3 (location_3_type,location_3_id)
);";

$TABLE[] = "CREATE TABLE ibf_skin_macro (
  macro_id smallint(3) NOT NULL auto_increment,
  macro_value varchar(200) default NULL,
  macro_replace text,
  macro_can_remove tinyint(1) default '0',
  macro_set smallint(3) NOT NULL default '0',
  PRIMARY KEY  (macro_id),
  KEY macro_set (macro_set)
);";

$TABLE[] = "CREATE TABLE ibf_skin_sets (
  set_skin_set_id int(10) NOT NULL auto_increment,
  set_name varchar(150) NOT NULL default '',
  set_image_dir varchar(200) NOT NULL default '',
  set_hidden tinyint(1) NOT NULL default '0',
  set_default tinyint(1) NOT NULL default '0',
  set_css_method varchar(100) NOT NULL default 'inline',
  set_skin_set_parent smallint(5) NOT NULL default '-1',
  set_author_email varchar(255) NOT NULL default '',
  set_author_name varchar(255) NOT NULL default '',
  set_author_url varchar(255) NOT NULL default '',
  set_css mediumtext NOT NULL,
  set_cache_macro mediumtext NOT NULL,
  set_wrapper mediumtext NOT NULL,
  set_css_updated int(10) NOT NULL default '0',
  set_cache_css mediumtext NOT NULL,
  set_cache_wrapper mediumtext NOT NULL,
  set_emoticon_folder varchar(60) NOT NULL default 'default',
  PRIMARY KEY  (set_skin_set_id)
);";

$TABLE[] = "CREATE TABLE ibf_skin_templates (
  suid int(10) NOT NULL auto_increment,
  set_id int(10) NOT NULL default '0',
  group_name varchar(255) NOT NULL default '',
  section_content mediumtext,
  func_name varchar(255) default NULL,
  func_data text,
  updated int(10) default NULL,
  can_remove tinyint(4) default '0',
  PRIMARY KEY  (suid)
);";

$TABLE[] = "CREATE TABLE ibf_skin_templates_cache (
  template_id varchar(32) NOT NULL default '',
  template_group_name varchar(255) NOT NULL default '',
  template_group_content mediumtext NOT NULL,
  template_set_id int(10) NOT NULL default '0',
  PRIMARY KEY  (template_id),
  KEY template_set_id (template_set_id),
  KEY template_group_name (template_group_name)
);";

$TABLE[] = "CREATE TABLE ibf_spider_logs (
  sid int(10) NOT NULL auto_increment,
  bot varchar(255) NOT NULL default '',
  query_string text NOT NULL,
  entry_date int(10) NOT NULL default '0',
  ip_address varchar(16) NOT NULL default '',
  PRIMARY KEY  (sid)
);";

$TABLE[] = "CREATE TABLE ibf_subscription_currency (
  subcurrency_code varchar(10) NOT NULL default '',
  subcurrency_desc varchar(250) NOT NULL default '',
  subcurrency_exchange decimal(16,8) NOT NULL default '0.00000000',
  subcurrency_default tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (subcurrency_code)
);";

$TABLE[] = "CREATE TABLE ibf_subscription_extra (
  subextra_id smallint(5) NOT NULL auto_increment,
  subextra_sub_id smallint(5) NOT NULL default '0',
  subextra_method_id smallint(5) NOT NULL default '0',
  subextra_product_id varchar(250) NOT NULL default '0',
  subextra_can_upgrade tinyint(1) NOT NULL default '0',
  subextra_recurring tinyint(1) NOT NULL default '0',
  subextra_custom_1 text,
  subextra_custom_2 text,
  subextra_custom_3 text,
  subextra_custom_4 text,
  subextra_custom_5 text,
  PRIMARY KEY  (subextra_id)
);";

$TABLE[] = "CREATE TABLE ibf_subscription_logs (
  sublog_id int(10) NOT NULL auto_increment,
  sublog_date int(10) NOT NULL default '0',
  sublog_member_id mediumint(8) NOT NULL default '0',
  sublog_transid int(10) NOT NULL default '0',
  sublog_ipaddress varchar(16) NOT NULL default '',
  sublog_data text,
  sublog_postdata text,
  PRIMARY KEY  (sublog_id)
);";

$TABLE[] = "CREATE TABLE ibf_subscription_methods (
  submethod_id smallint(5) NOT NULL auto_increment,
  submethod_title varchar(250) NOT NULL default '',
  submethod_name varchar(20) NOT NULL default '',
  submethod_email varchar(250) NOT NULL default '',
  submethod_sid text,
  submethod_custom_1 text,
  submethod_custom_2 text,
  submethod_custom_3 text,
  submethod_custom_4 text,
  submethod_custom_5 text,
  submethod_is_cc tinyint(1) NOT NULL default '0',
  submethod_is_auto tinyint(1) NOT NULL default '0',
  submethod_desc text,
  submethod_logo text,
  submethod_active tinyint(1) NOT NULL default '0',
  submethod_use_currency varchar(10) NOT NULL default 'USD',
  PRIMARY KEY  (submethod_id)
);";

$TABLE[] = "CREATE TABLE ibf_subscription_trans (
  subtrans_id int(10) NOT NULL auto_increment,
  subtrans_sub_id smallint(5) NOT NULL default '0',
  subtrans_member_id mediumint(8) NOT NULL default '0',
  subtrans_old_group smallint(5) NOT NULL default '0',
  subtrans_paid decimal(10,2) NOT NULL default '0.00',
  subtrans_cumulative decimal(10,2) NOT NULL default '0.00',
  subtrans_method varchar(20) NOT NULL default '',
  subtrans_start_date int(11) NOT NULL default '0',
  subtrans_end_date int(11) NOT NULL default '0',
  subtrans_state varchar(200) NOT NULL default '',
  subtrans_trxid varchar(200) NOT NULL default '',
  subtrans_subscrid varchar(200) NOT NULL default '',
  subtrans_currency varchar(10) NOT NULL default 'USD',
  PRIMARY KEY  (subtrans_id)
);";

$TABLE[] = "CREATE TABLE ibf_subscriptions (
  sub_id smallint(5) NOT NULL auto_increment,
  sub_title varchar(250) NOT NULL default '',
  sub_desc text,
  sub_new_group mediumint(8) NOT NULL default '0',
  sub_length smallint(5) NOT NULL default '1',
  sub_unit char(2) NOT NULL default 'm',
  sub_cost decimal(10,2) NOT NULL default '0.00',
  sub_run_module varchar(250) NOT NULL default '',
  PRIMARY KEY  (sub_id)
);";

$TABLE[] = "CREATE TABLE ibf_task_logs (
  log_id int(10) NOT NULL auto_increment,
  log_title varchar(255) NOT NULL default '',
  log_date int(10) NOT NULL default '0',
  log_ip varchar(16) NOT NULL default '0',
  log_desc text NOT NULL,
  PRIMARY KEY  (log_id)
);";

$TABLE[] = "CREATE TABLE ibf_task_manager (
  task_id int(10) NOT NULL auto_increment,
  task_title varchar(255) NOT NULL default '',
  task_file varchar(255) NOT NULL default '',
  task_next_run int(10) NOT NULL default '0',
  task_week_day tinyint(1) NOT NULL default '-1',
  task_month_day smallint(2) NOT NULL default '-1',
  task_hour smallint(2) NOT NULL default '-1',
  task_minute smallint(2) NOT NULL default '-1',
  task_cronkey varchar(32) NOT NULL default '',
  task_log tinyint(1) NOT NULL default '0',
  task_description text NOT NULL,
  task_enabled tinyint(1) NOT NULL default '1',
  task_key varchar(30) NOT NULL default '',
  task_safemode tinyint(1) NOT NULL default '0',
  task_locked int(10) NOT NULL default '0',
  PRIMARY KEY  (task_id),
  KEY task_next_run (task_next_run)
);";

$TABLE[] = "CREATE TABLE ibf_templates_diff_import (
	diff_key			VARCHAR(255) NOT NULL,
	diff_func_group		VARCHAR(150) NOT NULL,
	diff_func_name		VARCHAR(250) NOT NULL,
	diff_func_data		TEXT,
	diff_func_content	MEDIUMTEXT,
	diff_session_id		INT(10) NOT NULL default '0',
	PRIMARY KEY (diff_key),
	KEY diff_func_group (diff_func_group),
	KEY diff_func_name (diff_func_name)
);";

$TABLE[] = "CREATE TABLE ibf_template_diff_session (
	diff_session_id				INT(10) NOT NULL auto_increment,
	diff_session_togo			INT(10) NOT NULL default '0',
	diff_session_done			INT(10) NOT NULL default '0',
	diff_session_updated		INT(10) NOT NULL default '0',
	diff_session_title			VARCHAR(255) NOT NULL default '',
	diff_session_ignore_missing INT(1) NOT NULL default '0',
	PRIMARY KEY (diff_session_id)
);";

$TABLE[] = "CREATE TABLE ibf_template_diff_changes (
	diff_change_key			VARCHAR(255) NOT NULL,
	diff_change_func_group	VARCHAR(150) NOT NULL,
	diff_change_func_name	VARCHAR(250) NOT NULL,
	diff_change_content		MEDIUMTEXT,
	diff_change_type		INT(1) NOT NULL default '0',
	diff_session_id		    INT(10) NOT NULL default '0',
	PRIMARY KEY (diff_change_key),
	KEY diff_change_func_group (diff_change_func_group),
	KEY diff_change_type (diff_change_type)
);";


$TABLE[] = "CREATE TABLE ibf_titles (
  id smallint(5) NOT NULL auto_increment,
  posts int(10) default NULL,
  title varchar(128) default NULL,
  pips varchar(128) default NULL,
  PRIMARY KEY  (id),
  KEY posts (posts)
);";

$TABLE[] = "CREATE TABLE ibf_topic_markers (
  marker_member_id int(8) NOT NULL default '0',
  marker_forum_id int(10) NOT NULL default '0',
  marker_last_update int(10) NOT NULL default '0',
  marker_unread smallint(5) NOT NULL default '0',
  marker_topics_read text NOT NULL,
  marker_last_cleared int(10) NOT NULL default '0',
  UNIQUE KEY marker_forum_id (marker_forum_id,marker_member_id),
  KEY marker_member_id (marker_member_id)
);";

$TABLE[] = "CREATE TABLE ibf_topic_mmod (
  mm_id smallint(5) NOT NULL auto_increment,
  mm_title varchar(250) NOT NULL default '',
  mm_enabled tinyint(1) NOT NULL default '0',
  topic_state varchar(10) NOT NULL default 'leave',
  topic_pin varchar(10) NOT NULL default 'leave',
  topic_move smallint(5) NOT NULL default '0',
  topic_move_link tinyint(1) NOT NULL default '0',
  topic_title_st varchar(250) NOT NULL default '',
  topic_title_end varchar(250) NOT NULL default '',
  topic_reply tinyint(1) NOT NULL default '0',
  topic_reply_content text NOT NULL,
  topic_reply_postcount tinyint(1) NOT NULL default '0',
  mm_forums text NOT NULL,
  topic_approve tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (mm_id)
);";

$TABLE[] = "CREATE TABLE ibf_topic_ratings (
  rating_id int(10) NOT NULL auto_increment,
  rating_tid int(10) NOT NULL default '0',
  rating_member_id mediumint(8) NOT NULL default '0',
  rating_value smallint(6) NOT NULL default '0',
  rating_ip_address varchar(16) NOT NULL default '',
  PRIMARY KEY  (rating_id),
  KEY rating_tid (rating_tid,rating_member_id)
);";

$TABLE[] = "CREATE TABLE ibf_topic_views (
  views_tid int(10) NOT NULL default '0'
);";

$TABLE[] = "CREATE TABLE ibf_topics (
  tid int(10) NOT NULL auto_increment,
  title varchar(250) NOT NULL default '',
  description varchar(70) default NULL,
  state varchar(8) default NULL,
  posts int(10) default NULL,
  starter_id mediumint(8) NOT NULL default '0',
  start_date int(10) default NULL,
  last_poster_id mediumint(8) NOT NULL default '0',
  last_post int(10) default NULL,
  icon_id tinyint(2) default NULL,
  starter_name varchar(32) default NULL,
  last_poster_name varchar(32) default NULL,
  poll_state varchar(8) default NULL,
  last_vote int(10) default NULL,
  views int(10) default NULL,
  forum_id smallint(5) NOT NULL default '0',
  approved tinyint(1) NOT NULL default '0',
  author_mode tinyint(1) default NULL,
  pinned tinyint(1) default NULL,
  moved_to varchar(64) default NULL,
  total_votes int(5) NOT NULL default '0',
  topic_hasattach smallint(5) NOT NULL default '0',
  topic_firstpost int(10) NOT NULL default '0',
  topic_queuedposts int(10) NOT NULL default '0',
  topic_open_time int(10) NOT NULL default '0',
  topic_close_time int(10) NOT NULL default '0',
  topic_rating_total smallint(5) unsigned NOT NULL default '0',
  topic_rating_hits smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (tid),
  KEY topic_firstpost (topic_firstpost),
  KEY last_post (forum_id,pinned,last_post),
  KEY forum_id (forum_id,pinned,approved)
);";

$TABLE[] = "CREATE TABLE ibf_topics_read (
  read_tid int(10) NOT NULL default '0',
  read_mid mediumint(8) NOT NULL default '0',
  read_date int(10) NOT NULL default '0',
  UNIQUE KEY read_tid_mid (read_tid,read_mid)
);";

$TABLE[] = "CREATE TABLE ibf_tracker (
  trid mediumint(8) NOT NULL auto_increment,
  member_id mediumint(8) NOT NULL default '0',
  topic_id int(10) NOT NULL default '0',
  start_date int(10) default NULL,
  last_sent int(10) NOT NULL default '0',
  topic_track_type varchar(100) NOT NULL default 'delayed',
  PRIMARY KEY  (trid),
  KEY topic_id (topic_id)
);";

$TABLE[] = "CREATE TABLE ibf_upgrade_history (
  upgrade_id int(10) NOT NULL auto_increment,
  upgrade_version_id int(10) NOT NULL default '0',
  upgrade_version_human varchar(200) NOT NULL default '',
  upgrade_date int(10) NOT NULL default '0',
  upgrade_mid int(10) NOT NULL default '0',
  upgrade_notes text NOT NULL,
  PRIMARY KEY  (upgrade_id)
);";

$TABLE[] = "CREATE TABLE ibf_validating (
  vid varchar(32) NOT NULL default '',
  member_id mediumint(8) NOT NULL default '0',
  real_group smallint(3) NOT NULL default '0',
  temp_group smallint(3) NOT NULL default '0',
  entry_date int(10) NOT NULL default '0',
  coppa_user tinyint(1) NOT NULL default '0',
  lost_pass tinyint(1) NOT NULL default '0',
  new_reg tinyint(1) NOT NULL default '0',
  email_chg tinyint(1) NOT NULL default '0',
  ip_address varchar(16) NOT NULL default '0',
  user_verified tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (vid),
  KEY new_reg (new_reg)
);";

$TABLE[] = "CREATE TABLE ibf_voters (
  vid int(10) NOT NULL auto_increment,
  ip_address varchar(16) NOT NULL default '',
  vote_date int(10) NOT NULL default '0',
  tid int(10) NOT NULL default '0',
  member_id varchar(32) default NULL,
  forum_id smallint(5) NOT NULL default '0',
  PRIMARY KEY  (vid)
);";

$TABLE[] = "CREATE TABLE ibf_warn_logs (
  wlog_id int(10) NOT NULL auto_increment,
  wlog_mid mediumint(8) NOT NULL default '0',
  wlog_notes text NOT NULL,
  wlog_contact varchar(250) NOT NULL default 'none',
  wlog_contact_content text NOT NULL,
  wlog_date int(10) NOT NULL default '0',
  wlog_type varchar(6) NOT NULL default 'pos',
  wlog_addedby mediumint(8) NOT NULL default '0',
  PRIMARY KEY  (wlog_id)
);";
    
$TABLE[] = "CREATE TABLE ibf_leagues (
  id MEDIUMINT(5) NOT NULL AUTO_INCREMENT,
  title VARCHAR(50) NOT NULL,
  link VARCHAR(255) DEFAULT NULL,
  logo VARCHAR(255) NOT NULL,
  description VARCHAR(255) DEFAULT NULL,
  type TINYINT(1) NOT NULL DEFAULT '0',
  position MEDIUMINT(5) NOT NULL DEFAULT '1',
  PRIMARY KEY (id)
);"

?>