<?php
/**
* Installation Schematic File
* Generated on Thu, 19 Feb 2009 08:15:47 +0000 GMT
*/
$TABLE[] = "CREATE TABLE forum_perms (
  perm_id int(10) NOT NULL auto_increment,
  perm_name varchar(250) NOT NULL default '',
  PRIMARY KEY  (perm_id)
);";

$TABLE[] = "CREATE TABLE forums (
  id smallint(5) NOT NULL auto_increment,
  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( 255 ) NOT NULL DEFAULT '',
  name varchar(128) NOT NULL default '',
  description text,
  position int(5) unsigned default 0,
  use_ibc tinyint(1) default NULL,
  use_html tinyint(1) default NULL,
  password varchar(32) default NULL,
  password_override varchar(255) default NULL,
  last_title varchar(250) 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) NOT NULL default 'all',
  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',
  redirect_url varchar(250) default '',
  redirect_on tinyint(1) NOT NULL default 0,
  redirect_hits int(10) NOT NULL default 0,
  rules_title varchar(255) NOT NULL default '',
  rules_text text,
  notify_modq_emails text,
  sub_can_post tinyint(1) default 1,
  permission_custom_error text,
  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,
  newest_title varchar(250) default NULL,
  newest_id int(10) NOT NULL default 0,
  min_posts_post int(10) unsigned NOT NULL,
  min_posts_view int(10) unsigned NOT NULL,
  can_view_others tinyint(1) NOT NULL default 1,
  hide_last_info tinyint(1) NOT NULL default 0,
  name_seo varchar(255) default NULL,
  seo_last_title varchar(255) NOT NULL default '',
  seo_last_name varchar(255) NOT NULL default '',
  last_x_topic_ids text,
  forums_bitoptions int(10) unsigned NOT NULL default 0,
  disable_sharelinks INT(1) NOT NULL default 0,
  deleted_posts INT(10) NOT NULL default 0,
  deleted_topics INT(10) NOT NULL default 0,
  tag_predefined TEXT NULL,
  archived_topics INT(10) NOT NULL DEFAULT 0,
  archived_posts INT(10) NOT NULL DEFAULT 0,
  ipseo_priority VARCHAR(3) NOT NULL DEFAULT '',
  viglink TINYINT(1) NOT NULL DEFAULT 1,
  PRIMARY KEY  (id),
  KEY position (position,parent_id),
  KEY ( last_poster_id )
);";
$TABLE[] = "CREATE TABLE forums_archive_posts (
	archive_id				INT(10) DEFAULT 0,
	archive_author_id		INT(10) NOT NULL DEFAULT 0,
	archive_author_name		VARCHAR(255) NOT NULL DEFAULT 0,
	archive_ip_address		VARCHAR(46) NOT NULL DEFAULT '',
	archive_content_date	INT(10) NOT NULL DEFAULT 0,
	archive_content			MEDIUMTEXT,
	archive_queued			INT(1) NOT NULL DEFAULT 1,
	archive_topic_id		INT(10) NOT NULL DEFAULT 0,
	archive_is_first		INT(1) NOT NULL DEFAULT 0,
	archive_bwoptions		INT(10) UNSIGNED NOT NULL DEFAULT 0,
	archive_attach_key		CHAR(32) NOT NULL DEFAULT '',
	archive_html_mode		INT(1) NOT NULL DEFAULT 0,
	archive_show_signature	INT(1) NOT NULL DEFAULT 0,
	archive_show_emoticons	INT(1) NOT NULL DEFAULT 0,
	archive_show_edited_by	INT(1) NOT NULL DEFAULT 0,
	archive_edit_time		INT(10) NOT NULL DEFAULT 0,
	archive_edit_name		VARCHAR(255) NOT NULL DEFAULT '',
	archive_edit_reason		VARCHAR(255) NOT NULL DEFAULT '',
	archive_added			INT(10) NOT NULL DEFAULT 0,
	archive_restored		INT(1) NOT NULL DEFAULT 0,
	archive_forum_id		INT(10) NOT NULL DEFAULT 0,
	PRIMARY KEY (archive_id),
	KEY archive_topic_id (archive_topic_id,archive_queued,archive_content_date),
	KEY archive_author_id (archive_author_id),
	KEY archive_restored (archive_restored),
	KEY archive_content_date (archive_content_date, archive_topic_id)
);";

$TABLE[] = "CREATE TABLE forums_recent_posts (
	post_id		INT(10) NOT NULL DEFAULT 0,
	post_topic_id	INT(10) NOT NULL DEFAULT 0,
	post_forum_id	INT(10) NOT NULL DEFAULT 0,
	post_author_id	INT(10) NOT NULL DEFAULT 0,
	post_date		INT(10) NOT NULL DEFAULT 0,
	PRIMARY KEY (post_id),
	KEY group_lookup (post_author_id, post_forum_id, post_date, post_id )
);";

$TABLE[] = "CREATE TABLE mod_queued_items (
  id int(11) NOT NULL auto_increment,
  type varchar(32) NOT NULL default 'post',
  type_id int(11) NOT NULL default 0,
  PRIMARY KEY  (id),
  KEY type_id (type_id)
);";
$TABLE[] = "CREATE TABLE 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(255) NOT NULL default '',
  ip_address varchar(46) NOT NULL default '0',
  http_referer TEXT NULL DEFAULT NULL,
  ctime int(10) default NULL,
  topic_title TEXT NULL DEFAULT NULL,
  action TEXT NULL DEFAULT NULL,
  query_string TEXT NULL DEFAULT NULL,
  PRIMARY KEY  (id),
  KEY ctime (ctime),
  KEY ip_address (ip_address)
);";
$TABLE[] = "CREATE TABLE moderators (
  mid mediumint(8) NOT NULL auto_increment,
  forum_id text,
  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,
  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,
  mod_bitoptions int(10) unsigned NOT NULL default 0,
  PRIMARY KEY  (mid),
  KEY group_id (group_id),
  KEY member_id (member_id)
);";
$TABLE[] = "CREATE TABLE 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,
  poll_only tinyint(1) NOT NULL default 0,
  poll_view_voters int(1) NOT NULL default 0,
  PRIMARY KEY  (pid),
  KEY tid (tid)
);";
$TABLE[] = "CREATE TABLE 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(255) default NULL,
  use_sig tinyint(1) NOT NULL default 0,
  use_emo tinyint(1) NOT NULL default 0,
  ip_address varchar(46) NOT NULL default '',
  post_date int(10) default NULL,
  post mediumtext,
  queued tinyint(1) NOT NULL default 0,
  topic_id int(10) NOT NULL default 0,
  new_topic tinyint(1) default 0,
  edit_name varchar(255) default NULL,
  post_key varchar(32) NOT NULL default '0',
  post_htmlstate smallint(1) NOT NULL default 0,
  post_edit_reason varchar(255) NOT NULL default '',
  post_bwoptions INT(10) UNSIGNED NOT NULL DEFAULT 0,
  pdelete_time INT NOT NULL DEFAULT 0,
  post_field_int INT(10) NOT NULL DEFAULT 0,
  post_field_t1 TEXT NULL DEFAULT NULL,
  post_field_t2 TEXT NULL DEFAULT NULL,
  PRIMARY KEY  (pid),
  KEY topic_id (topic_id,queued,pid,post_date),
  KEY author_id (author_id , post_date , queued),
  KEY post_date (post_date),
  KEY ip_address (ip_address),
  KEY post_key (post_key),
  KEY queued (queued,pdelete_time)
);";
$TABLE[] = "CREATE TABLE 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,
  topic_reply_postcount tinyint(1) NOT NULL default 0,
  mm_forums text,
  topic_approve tinyint(1) NOT NULL default 0,
  PRIMARY KEY  (mm_id)
);";
$TABLE[] = "CREATE TABLE 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(46) NOT NULL default '',
  PRIMARY KEY  (rating_id),
  KEY rating_tid (rating_tid,rating_member_id),
  KEY rating_ip_address (rating_ip_address)
);";
$TABLE[] = "CREATE TABLE topic_views (
  views_tid int(10) NOT NULL default 0,
  KEY views_tid (views_tid)
);";


$TABLE[] = "CREATE TABLE topics (
  tid int(10) NOT NULL auto_increment,
  title varchar(250) NOT NULL default '',
  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,
  starter_name varchar(255) default NULL,
  last_poster_name varchar(255) 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,
  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,
  title_seo varchar(250) NOT NULL default '',
  seo_last_name varchar(255) NOT NULL default '',
  seo_first_name varchar(255) NOT NULL default '',
  topic_deleted_posts INT(10) NOT NULL default 0,
  tdelete_time INT NOT NULL DEFAULT 0,
  moved_on INT NOT NULL DEFAULT '0',
  topic_archive_status INT(1) NOT NULL DEFAULT 0,
  last_real_post INT(10) NOT NULL DEFAULT 0,
  topic_answered_pid INT(10) NOT NULL DEFAULT 0,
  PRIMARY KEY  (tid),
  KEY topic_firstpost (topic_firstpost),
  KEY last_post (forum_id,pinned,last_post,state),
  KEY forum_id (forum_id,pinned,approved),
  KEY starter_id (starter_id, forum_id, approved, start_date),
  KEY last_post_sorting (last_post,forum_id),
  KEY start_date (start_date),
  KEY last_x_topics (forum_id,approved,start_date),
  KEY approved (approved,tdelete_time),
  KEY moved_redirects ( moved_on, moved_to, pinned ),
  KEY topic_archive_status (topic_archive_status, forum_id),
  KEY ( last_poster_id )
);";

