News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

SMF 2P4 database structure abd description

Started by shereif, October 02, 2008, 06:52:09 AM

Previous topic - Next topic

shereif

Dear All,

I need SMF 2 database tables and descriptions so that I can manually re create any table with SQL incase I got a problem , where can I have this description???

Thanks

shadow82x

#1
Not too sure what you mean here, but can't you just download a fresh SMF2 and take a look at the install-2-0.mysql file?

End Result of something like
#### ATTENTION: You do not need to run or use this file!  The install.php script does everything for you!
#### Install script for MySQL 3.23.28+

#
# Table structure for table `admin_info_files`
#

CREATE TABLE {$db_prefix}admin_info_files (
  id_file tinyint(4) unsigned NOT NULL auto_increment,
  filename tinytext NOT NULL,
  path tinytext NOT NULL,
  parameters tinytext NOT NULL,
  data text NOT NULL,
  filetype tinytext NOT NULL,
  PRIMARY KEY (id_file),
  KEY filename (filename(30))
) ENGINE=MYISAM;

#
# Dumping data for table `admin_info_files`
#

INSERT INTO {$db_prefix}admin_info_files
(id_file, filename, path, parameters, data, filetype)
VALUES
(1, 'current-version.js', '/smf/', 'version=%3$s', '', 'text/javascript'),
(2, 'detailed-version.js', '/smf/', 'language=%1$s&version=%3$s', '', 'text/javascript'),
(3, 'latest-news.js', '/smf/', 'language=%1$s&format=%2$s', '', 'text/javascript'),
(4, 'latest-packages.js', '/smf/', 'language=%1$s&version=%3$s', '', 'text/javascript'),
(5, 'latest-smileys.js', '/smf/', 'language=%1$s&version=%3$s', '', 'text/javascript'),
(6, 'latest-support.js', '/smf/', 'language=%1$s&version=%3$s', '', 'text/javascript'),
(7, 'latest-themes.js', '/smf/', 'language=%1$s&version=%3$s', '', 'text/javascript');
# --------------------------------------------------------

#
# Table structure for table `approval_queue`
#

CREATE TABLE {$db_prefix}approval_queue (
  id_msg int(10) unsigned NOT NULL default '0',
  id_attach int(10) unsigned NOT NULL default '0',
  id_event smallint(5) unsigned NOT NULL default '0'
) ENGINE=MYISAM;

#
# Table structure for table `attachments`
#

CREATE TABLE {$db_prefix}attachments (
  id_attach int(10) unsigned NOT NULL auto_increment,
  id_thumb int(10) unsigned NOT NULL default '0',
  id_msg int(10) unsigned NOT NULL default '0',
  id_member mediumint(8) unsigned NOT NULL default '0',
  id_folder tinyint(3) NOT NULL default '1',
  attachment_type tinyint(3) unsigned NOT NULL default '0',
  filename tinytext NOT NULL,
  fileext varchar(8) NOT NULL default '',
  size int(10) unsigned NOT NULL default '0',
  downloads mediumint(8) unsigned NOT NULL default '0',
  width mediumint(8) unsigned NOT NULL default '0',
  height mediumint(8) unsigned NOT NULL default '0',
  mime_type varchar(20) NOT NULL default '',
  approved tinyint(3) NOT NULL default '1',
  PRIMARY KEY (id_attach),
  UNIQUE id_member (id_member, id_attach),
  KEY id_msg (id_msg)
) ENGINE=MyISAM;

#
# Table structure for table `ban_groups`
#

CREATE TABLE {$db_prefix}ban_groups (
  id_ban_group mediumint(8) unsigned NOT NULL auto_increment,
  name varchar(20) NOT NULL default '',
  ban_time int(10) unsigned NOT NULL default '0',
  expire_time int(10) unsigned,
  cannot_access tinyint(3) unsigned NOT NULL default '0',
  cannot_register tinyint(3) unsigned NOT NULL default '0',
  cannot_post tinyint(3) unsigned NOT NULL default '0',
  cannot_login tinyint(3) unsigned NOT NULL default '0',
  reason tinytext NOT NULL,
  notes text NOT NULL,
  PRIMARY KEY (id_ban_group)
) ENGINE=MyISAM;

#
# Table structure for table `ban_items`
#

CREATE TABLE {$db_prefix}ban_items (
  id_ban mediumint(8) unsigned NOT NULL auto_increment,
  id_ban_group smallint(5) unsigned NOT NULL default '0',
  ip_low1 tinyint(3) unsigned NOT NULL default '0',
  ip_high1 tinyint(3) unsigned NOT NULL default '0',
  ip_low2 tinyint(3) unsigned NOT NULL default '0',
  ip_high2 tinyint(3) unsigned NOT NULL default '0',
  ip_low3 tinyint(3) unsigned NOT NULL default '0',
  ip_high3 tinyint(3) unsigned NOT NULL default '0',
  ip_low4 tinyint(3) unsigned NOT NULL default '0',
  ip_high4 tinyint(3) unsigned NOT NULL default '0',
  hostname tinytext NOT NULL,
  email_address tinytext NOT NULL,
  id_member mediumint(8) unsigned NOT NULL default '0',
  hits mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY (id_ban),
  KEY id_ban_group (id_ban_group)
) ENGINE=MyISAM;

#
# Table structure for table `board_permissions`
#

CREATE TABLE {$db_prefix}board_permissions (
  id_group smallint(5) NOT NULL default '0',
  id_profile smallint(5) unsigned NOT NULL default '0',
  permission varchar(30) NOT NULL default '',
  add_deny tinyint(4) NOT NULL default '1',
  PRIMARY KEY (id_group, id_profile, permission)
) ENGINE=MyISAM;

#
# Dumping data for table `board_permissions`
#

INSERT INTO {$db_prefix}board_permissions
(id_group, id_profile, permission)
VALUES (-1, 1, 'poll_view'),
(0, 1, 'remove_own'),
(0, 1, 'lock_own'),
(0, 1, 'mark_any_notify'),
(0, 1, 'mark_notify'),
(0, 1, 'modify_own'),
(0, 1, 'poll_add_own'),
(0, 1, 'poll_edit_own'),
(0, 1, 'poll_lock_own'),
(0, 1, 'poll_post'),
(0, 1, 'poll_view'),
(0, 1, 'poll_vote'),
(0, 1, 'post_attachment'),
(0, 1, 'post_new'),
(0, 1, 'post_reply_any'),
(0, 1, 'post_reply_own'),
(0, 1, 'post_unapproved_topics'),
(0, 1, 'post_unapproved_replies_any'),
(0, 1, 'post_unapproved_replies_own'),
(0, 1, 'post_unapproved_attachments'),
(0, 1, 'delete_own'),
(0, 1, 'report_any'),
(0, 1, 'send_topic'),
(0, 1, 'view_attachments'),
(2, 1, 'moderate_board'),
(2, 1, 'post_new'),
(2, 1, 'post_reply_own'),
(2, 1, 'post_reply_any'),
(2, 1, 'post_unapproved_topics'),
(2, 1, 'post_unapproved_replies_any'),
(2, 1, 'post_unapproved_replies_own'),
(2, 1, 'post_unapproved_attachments'),
(2, 1, 'poll_post'),
(2, 1, 'poll_add_any'),
(2, 1, 'poll_remove_any'),
(2, 1, 'poll_view'),
(2, 1, 'poll_vote'),
(2, 1, 'poll_lock_any'),
(2, 1, 'poll_edit_any'),
(2, 1, 'report_any'),
(2, 1, 'lock_own'),
(2, 1, 'send_topic'),
(2, 1, 'mark_any_notify'),
(2, 1, 'mark_notify'),
(2, 1, 'delete_own'),
(2, 1, 'modify_own'),
(2, 1, 'make_sticky'),
(2, 1, 'lock_any'),
(2, 1, 'remove_any'),
(2, 1, 'move_any'),
(2, 1, 'merge_any'),
(2, 1, 'split_any'),
(2, 1, 'delete_any'),
(2, 1, 'modify_any'),
(2, 1, 'approve_posts'),
(2, 1, 'post_attachment'),
(2, 1, 'view_attachments'),
(3, 1, 'moderate_board'),
(3, 1, 'post_new'),
(3, 1, 'post_reply_own'),
(3, 1, 'post_reply_any'),
(3, 1, 'post_unapproved_topics'),
(3, 1, 'post_unapproved_replies_any'),
(3, 1, 'post_unapproved_replies_own'),
(3, 1, 'post_unapproved_attachments'),
(3, 1, 'poll_post'),
(3, 1, 'poll_add_any'),
(3, 1, 'poll_remove_any'),
(3, 1, 'poll_view'),
(3, 1, 'poll_vote'),
(3, 1, 'poll_lock_any'),
(3, 1, 'poll_edit_any'),
(3, 1, 'report_any'),
(3, 1, 'lock_own'),
(3, 1, 'send_topic'),
(3, 1, 'mark_any_notify'),
(3, 1, 'mark_notify'),
(3, 1, 'delete_own'),
(3, 1, 'modify_own'),
(3, 1, 'make_sticky'),
(3, 1, 'lock_any'),
(3, 1, 'remove_any'),
(3, 1, 'move_any'),
(3, 1, 'merge_any'),
(3, 1, 'split_any'),
(3, 1, 'delete_any'),
(3, 1, 'modify_any'),
(3, 1, 'approve_posts'),
(3, 1, 'post_attachment'),
(3, 1, 'view_attachments'),
(-1, 2, 'poll_view'),
(0, 2, 'remove_own'),
(0, 2, 'lock_own'),
(0, 2, 'mark_any_notify'),
(0, 2, 'mark_notify'),
(0, 2, 'modify_own'),
(0, 2, 'poll_view'),
(0, 2, 'poll_vote'),
(0, 2, 'post_attachment'),
(0, 2, 'post_new'),
(0, 2, 'post_reply_any'),
(0, 2, 'post_reply_own'),
(0, 2, 'post_unapproved_topics'),
(0, 2, 'post_unapproved_replies_any'),
(0, 2, 'post_unapproved_replies_own'),
(0, 2, 'post_unapproved_attachments'),
(0, 2, 'delete_own'),
(0, 2, 'report_any'),
(0, 2, 'send_topic'),
(0, 2, 'view_attachments'),
(2, 2, 'moderate_board'),
(2, 2, 'post_new'),
(2, 2, 'post_reply_own'),
(2, 2, 'post_reply_any'),
(2, 2, 'post_unapproved_topics'),
(2, 2, 'post_unapproved_replies_any'),
(2, 2, 'post_unapproved_replies_own'),
(2, 2, 'post_unapproved_attachments'),
(2, 2, 'poll_post'),
(2, 2, 'poll_add_any'),
(2, 2, 'poll_remove_any'),
(2, 2, 'poll_view'),
(2, 2, 'poll_vote'),
(2, 2, 'poll_lock_any'),
(2, 2, 'poll_edit_any'),
(2, 2, 'report_any'),
(2, 2, 'lock_own'),
(2, 2, 'send_topic'),
(2, 2, 'mark_any_notify'),
(2, 2, 'mark_notify'),
(2, 2, 'delete_own'),
(2, 2, 'modify_own'),
(2, 2, 'make_sticky'),
(2, 2, 'lock_any'),
(2, 2, 'remove_any'),
(2, 2, 'move_any'),
(2, 2, 'merge_any'),
(2, 2, 'split_any'),
(2, 2, 'delete_any'),
(2, 2, 'modify_any'),
(2, 2, 'approve_posts'),
(2, 2, 'post_attachment'),
(2, 2, 'view_attachments'),
(3, 2, 'moderate_board'),
(3, 2, 'post_new'),
(3, 2, 'post_reply_own'),
(3, 2, 'post_reply_any'),
(3, 2, 'post_unapproved_topics'),
(3, 2, 'post_unapproved_replies_any'),
(3, 2, 'post_unapproved_replies_own'),
(3, 2, 'post_unapproved_attachments'),
(3, 2, 'poll_post'),
(3, 2, 'poll_add_any'),
(3, 2, 'poll_remove_any'),
(3, 2, 'poll_view'),
(3, 2, 'poll_vote'),
(3, 2, 'poll_lock_any'),
(3, 2, 'poll_edit_any'),
(3, 2, 'report_any'),
(3, 2, 'lock_own'),
(3, 2, 'send_topic'),
(3, 2, 'mark_any_notify'),
(3, 2, 'mark_notify'),
(3, 2, 'delete_own'),
(3, 2, 'modify_own'),
(3, 2, 'make_sticky'),
(3, 2, 'lock_any'),
(3, 2, 'remove_any'),
(3, 2, 'move_any'),
(3, 2, 'merge_any'),
(3, 2, 'split_any'),
(3, 2, 'delete_any'),
(3, 2, 'modify_any'),
(3, 2, 'approve_posts'),
(3, 2, 'post_attachment'),
(3, 2, 'view_attachments'),
(-1, 3, 'poll_view'),
(0, 3, 'remove_own'),
(0, 3, 'lock_own'),
(0, 3, 'mark_any_notify'),
(0, 3, 'mark_notify'),
(0, 3, 'modify_own'),
(0, 3, 'poll_view'),
(0, 3, 'poll_vote'),
(0, 3, 'post_attachment'),
(0, 3, 'post_reply_any'),
(0, 3, 'post_reply_own'),
(0, 3, 'post_unapproved_replies_any'),
(0, 3, 'post_unapproved_replies_own'),
(0, 3, 'post_unapproved_attachments'),
(0, 3, 'delete_own'),
(0, 3, 'report_any'),
(0, 3, 'send_topic'),
(0, 3, 'view_attachments'),
(2, 3, 'moderate_board'),
(2, 3, 'post_new'),
(2, 3, 'post_reply_own'),
(2, 3, 'post_reply_any'),
(2, 3, 'post_unapproved_topics'),
(2, 3, 'post_unapproved_replies_any'),
(2, 3, 'post_unapproved_replies_own'),
(2, 3, 'post_unapproved_attachments'),
(2, 3, 'poll_post'),
(2, 3, 'poll_add_any'),
(2, 3, 'poll_remove_any'),
(2, 3, 'poll_view'),
(2, 3, 'poll_vote'),
(2, 3, 'poll_lock_any'),
(2, 3, 'poll_edit_any'),
(2, 3, 'report_any'),
(2, 3, 'lock_own'),
(2, 3, 'send_topic'),
(2, 3, 'mark_any_notify'),
(2, 3, 'mark_notify'),
(2, 3, 'delete_own'),
(2, 3, 'modify_own'),
(2, 3, 'make_sticky'),
(2, 3, 'lock_any'),
(2, 3, 'remove_any'),
(2, 3, 'move_any'),
(2, 3, 'merge_any'),
(2, 3, 'split_any'),
(2, 3, 'delete_any'),
(2, 3, 'modify_any'),
(2, 3, 'approve_posts'),
(2, 3, 'post_attachment'),
(2, 3, 'view_attachments'),
(3, 3, 'moderate_board'),
(3, 3, 'post_new'),
(3, 3, 'post_reply_own'),
(3, 3, 'post_reply_any'),
(3, 3, 'post_unapproved_topics'),
(3, 3, 'post_unapproved_replies_any'),
(3, 3, 'post_unapproved_replies_own'),
(3, 3, 'post_unapproved_attachments'),
(3, 3, 'poll_post'),
(3, 3, 'poll_add_any'),
(3, 3, 'poll_remove_any'),
(3, 3, 'poll_view'),
(3, 3, 'poll_vote'),
(3, 3, 'poll_lock_any'),
(3, 3, 'poll_edit_any'),
(3, 3, 'report_any'),
(3, 3, 'lock_own'),
(3, 3, 'send_topic'),
(3, 3, 'mark_any_notify'),
(3, 3, 'mark_notify'),
(3, 3, 'delete_own'),
(3, 3, 'modify_own'),
(3, 3, 'make_sticky'),
(3, 3, 'lock_any'),
(3, 3, 'remove_any'),
(3, 3, 'move_any'),
(3, 3, 'merge_any'),
(3, 3, 'split_any'),
(3, 3, 'delete_any'),
(3, 3, 'modify_any'),
(3, 3, 'approve_posts'),
(3, 3, 'post_attachment'),
(3, 3, 'view_attachments'),
(-1, 4, 'poll_view'),
(0, 4, 'mark_any_notify'),
(0, 4, 'mark_notify'),
(0, 4, 'poll_view'),
(0, 4, 'poll_vote'),
(0, 4, 'report_any'),
(0, 4, 'send_topic'),
(0, 4, 'view_attachments'),
(2, 4, 'moderate_board'),
(2, 4, 'post_new'),
(2, 4, 'post_reply_own'),
(2, 4, 'post_reply_any'),
(2, 4, 'post_unapproved_topics'),
(2, 4, 'post_unapproved_replies_any'),
(2, 4, 'post_unapproved_replies_own'),
(2, 4, 'post_unapproved_attachments'),
(2, 4, 'poll_post'),
(2, 4, 'poll_add_any'),
(2, 4, 'poll_remove_any'),
(2, 4, 'poll_view'),
(2, 4, 'poll_vote'),
(2, 4, 'poll_lock_any'),
(2, 4, 'poll_edit_any'),
(2, 4, 'report_any'),
(2, 4, 'lock_own'),
(2, 4, 'send_topic'),
(2, 4, 'mark_any_notify'),
(2, 4, 'mark_notify'),
(2, 4, 'delete_own'),
(2, 4, 'modify_own'),
(2, 4, 'make_sticky'),
(2, 4, 'lock_any'),
(2, 4, 'remove_any'),
(2, 4, 'move_any'),
(2, 4, 'merge_any'),
(2, 4, 'split_any'),
(2, 4, 'delete_any'),
(2, 4, 'modify_any'),
(2, 4, 'approve_posts'),
(2, 4, 'post_attachment'),
(2, 4, 'view_attachments'),
(3, 4, 'moderate_board'),
(3, 4, 'post_new'),
(3, 4, 'post_reply_own'),
(3, 4, 'post_reply_any'),
(3, 4, 'post_unapproved_topics'),
(3, 4, 'post_unapproved_replies_any'),
(3, 4, 'post_unapproved_replies_own'),
(3, 4, 'post_unapproved_attachments'),
(3, 4, 'poll_post'),
(3, 4, 'poll_add_any'),
(3, 4, 'poll_remove_any'),
(3, 4, 'poll_view'),
(3, 4, 'poll_vote'),
(3, 4, 'poll_lock_any'),
(3, 4, 'poll_edit_any'),
(3, 4, 'report_any'),
(3, 4, 'lock_own'),
(3, 4, 'send_topic'),
(3, 4, 'mark_any_notify'),
(3, 4, 'mark_notify'),
(3, 4, 'delete_own'),
(3, 4, 'modify_own'),
(3, 4, 'make_sticky'),
(3, 4, 'lock_any'),
(3, 4, 'remove_any'),
(3, 4, 'move_any'),
(3, 4, 'merge_any'),
(3, 4, 'split_any'),
(3, 4, 'delete_any'),
(3, 4, 'modify_any'),
(3, 4, 'approve_posts'),
(3, 4, 'post_attachment'),
(3, 4, 'view_attachments');
# --------------------------------------------------------

#
# Table structure for table `boards`
#

CREATE TABLE {$db_prefix}boards (
  id_board smallint(5) unsigned NOT NULL auto_increment,
  id_cat tinyint(4) unsigned NOT NULL default '0',
  child_level tinyint(4) unsigned NOT NULL default '0',
  id_parent smallint(5) unsigned NOT NULL default '0',
  board_order smallint(5) NOT NULL default '0',
  id_last_msg int(10) unsigned NOT NULL default '0',
  id_msg_updated int(10) unsigned NOT NULL default '0',
  member_groups varchar(255) NOT NULL default '-1,0',
  id_profile smallint(5) unsigned NOT NULL default '1',
  name tinytext NOT NULL,
  description text NOT NULL,
  num_topics mediumint(8) unsigned NOT NULL default '0',
  num_posts mediumint(8) unsigned NOT NULL default '0',
  count_posts tinyint(4) NOT NULL default '0',
  id_theme tinyint(4) unsigned NOT NULL default '0',
  override_theme tinyint(4) unsigned NOT NULL default '0',
  unapproved_posts smallint(5) NOT NULL default '0',
  unapproved_topics smallint(5) NOT NULL default '0',
  redirect varchar(255) NOT NULL default '',
  PRIMARY KEY (id_board),
  UNIQUE categories (id_cat, id_board),
  KEY id_parent (id_parent),
  KEY id_msg_updated (id_msg_updated),
  KEY member_groups (member_groups(48))
) ENGINE=MyISAM;

#
# Dumping data for table `boards`
#

INSERT INTO {$db_prefix}boards
(id_board, id_cat, board_order, id_last_msg, id_msg_updated, name, description, num_topics, num_posts, member_groups)
VALUES (1, 1, 1, 1, 1, '{$default_board_name}', '{$default_board_description}', 1, 1, '-1,0,2');
# --------------------------------------------------------

#
# Table structure for table `calendar`
#

CREATE TABLE {$db_prefix}calendar (
  id_event smallint(5) unsigned NOT NULL auto_increment,
  start_date date NOT NULL default '0001-01-01',
  end_date date NOT NULL default '0001-01-01',
  id_board smallint(5) unsigned NOT NULL default '0',
  id_topic mediumint(8) unsigned NOT NULL default '0',
  title varchar(48) NOT NULL default '',
  id_member mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY (id_event),
  KEY start_date (start_date),
  KEY end_date (end_date),
  KEY topic (id_topic, id_member)
) ENGINE=MyISAM;

#
# Table structure for table `calendar_holidays`
#

CREATE TABLE {$db_prefix}calendar_holidays (
  id_holiday smallint(5) unsigned NOT NULL auto_increment,
  event_date date NOT NULL default '0001-01-01',
  title varchar(30) NOT NULL default '',
  PRIMARY KEY (id_holiday),
  KEY event_date (event_date)
) ENGINE=MyISAM;

#
# Dumping data for table `calendar_holidays`
#

INSERT INTO {$db_prefix}calendar_holidays
(title, event_date)
VALUES ('New Year\'s', '0004-01-01'),
('Christmas', '0004-12-25'),
('Valentine\'s Day', '0004-02-14'),
('St. Patrick\'s Day', '0004-03-17'),
('April Fools', '0004-04-01'),
('Earth Day', '0004-04-22'),
('United Nations Day', '0004-10-24'),
('Halloween', '0004-10-31'),
('Mother\'s Day', '2004-05-09'),
('Mother\'s Day', '2005-05-08'),
('Mother\'s Day', '2006-05-14'),
('Mother\'s Day', '2007-05-13'),
('Mother\'s Day', '2008-05-11'),
('Mother\'s Day', '2009-05-10'),
('Mother\'s Day', '2010-05-09'),
('Mother\'s Day', '2011-05-08'),
('Mother\'s Day', '2012-05-13'),
('Mother\'s Day', '2013-05-12'),
('Mother\'s Day', '2014-05-11'),
('Mother\'s Day', '2015-05-10'),
('Mother\'s Day', '2016-05-08'),
('Mother\'s Day', '2017-05-14'),
('Mother\'s Day', '2018-05-13'),
('Mother\'s Day', '2019-05-12'),
('Mother\'s Day', '2020-05-10'),
('Father\'s Day', '2004-06-20'),
('Father\'s Day', '2005-06-19'),
('Father\'s Day', '2006-06-18'),
('Father\'s Day', '2007-06-17'),
('Father\'s Day', '2008-06-15'),
('Father\'s Day', '2009-06-21'),
('Father\'s Day', '2010-06-20'),
('Father\'s Day', '2011-06-19'),
('Father\'s Day', '2012-06-17'),
('Father\'s Day', '2013-06-16'),
('Father\'s Day', '2014-06-15'),
('Father\'s Day', '2015-06-21'),
('Father\'s Day', '2016-06-19'),
('Father\'s Day', '2017-06-18'),
('Father\'s Day', '2018-06-17'),
('Father\'s Day', '2019-06-16'),
('Father\'s Day', '2020-06-21'),
('Summer Solstice', '2004-06-20'),
('Summer Solstice', '2005-06-20'),
('Summer Solstice', '2006-06-21'),
('Summer Solstice', '2007-06-21'),
('Summer Solstice', '2008-06-20'),
('Summer Solstice', '2009-06-20'),
('Summer Solstice', '2010-06-21'),
('Summer Solstice', '2011-06-21'),
('Summer Solstice', '2012-06-20'),
('Summer Solstice', '2013-06-21'),
('Summer Solstice', '2014-06-21'),
('Summer Solstice', '2015-06-21'),
('Summer Solstice', '2016-06-20'),
('Summer Solstice', '2017-06-20'),
('Summer Solstice', '2018-06-21'),
('Summer Solstice', '2019-06-21'),
('Summer Solstice', '2020-06-20'),
('Vernal Equinox', '2004-03-19'),
('Vernal Equinox', '2005-03-20'),
('Vernal Equinox', '2006-03-20'),
('Vernal Equinox', '2007-03-20'),
('Vernal Equinox', '2008-03-19'),
('Vernal Equinox', '2009-03-20'),
('Vernal Equinox', '2010-03-20'),
('Vernal Equinox', '2011-03-20'),
('Vernal Equinox', '2012-03-20'),
('Vernal Equinox', '2013-03-20'),
('Vernal Equinox', '2014-03-20'),
('Vernal Equinox', '2015-03-20'),
('Vernal Equinox', '2016-03-19'),
('Vernal Equinox', '2017-03-20'),
('Vernal Equinox', '2018-03-20'),
('Vernal Equinox', '2019-03-20'),
('Vernal Equinox', '2020-03-19'),
('Winter Solstice', '2004-12-21'),
('Winter Solstice', '2005-12-21'),
('Winter Solstice', '2006-12-22'),
('Winter Solstice', '2007-12-22'),
('Winter Solstice', '2008-12-21'),
('Winter Solstice', '2009-12-21'),
('Winter Solstice', '2010-12-21'),
('Winter Solstice', '2011-12-22'),
('Winter Solstice', '2012-12-21'),
('Winter Solstice', '2013-12-21'),
('Winter Solstice', '2014-12-21'),
('Winter Solstice', '2015-12-21'),
('Winter Solstice', '2016-12-21'),
('Winter Solstice', '2017-12-21'),
('Winter Solstice', '2018-12-21'),
('Winter Solstice', '2019-12-21'),
('Winter Solstice', '2020-12-21'),
('Autumnal Equinox', '2004-09-22'),
('Autumnal Equinox', '2005-09-22'),
('Autumnal Equinox', '2006-09-22'),
('Autumnal Equinox', '2007-09-23'),
('Autumnal Equinox', '2008-09-22'),
('Autumnal Equinox', '2009-09-22'),
('Autumnal Equinox', '2010-09-22'),
('Autumnal Equinox', '2011-09-23'),
('Autumnal Equinox', '2012-09-22'),
('Autumnal Equinox', '2013-09-22'),
('Autumnal Equinox', '2014-09-22'),
('Autumnal Equinox', '2015-09-23'),
('Autumnal Equinox', '2016-09-22'),
('Autumnal Equinox', '2017-09-22'),
('Autumnal Equinox', '2018-09-22'),
('Autumnal Equinox', '2019-09-23'),
('Autumnal Equinox', '2020-09-22');

INSERT INTO {$db_prefix}calendar_holidays
(title, event_date)
VALUES ('Independence Day', '0004-07-04'),
('Cinco de Mayo', '0004-05-05'),
('Flag Day', '0004-06-14'),
('Veterans Day', '0004-11-11'),
('Groundhog Day', '0004-02-02'),
('Thanksgiving', '2004-11-25'),
('Thanksgiving', '2005-11-24'),
('Thanksgiving', '2006-11-23'),
('Thanksgiving', '2007-11-22'),
('Thanksgiving', '2008-11-27'),
('Thanksgiving', '2009-11-26'),
('Thanksgiving', '2010-11-25'),
('Thanksgiving', '2011-11-24'),
('Thanksgiving', '2012-11-22'),
('Thanksgiving', '2013-11-21'),
('Thanksgiving', '2014-11-20'),
('Thanksgiving', '2015-11-26'),
('Thanksgiving', '2016-11-24'),
('Thanksgiving', '2017-11-23'),
('Thanksgiving', '2018-11-22'),
('Thanksgiving', '2019-11-21'),
('Thanksgiving', '2020-11-26'),
('Memorial Day', '2004-05-31'),
('Memorial Day', '2005-05-30'),
('Memorial Day', '2006-05-29'),
('Memorial Day', '2007-05-28'),
('Memorial Day', '2008-05-26'),
('Memorial Day', '2009-05-25'),
('Memorial Day', '2010-05-31'),
('Memorial Day', '2011-05-30'),
('Memorial Day', '2012-05-28'),
('Memorial Day', '2013-05-27'),
('Memorial Day', '2014-05-26'),
('Memorial Day', '2015-05-25'),
('Memorial Day', '2016-05-30'),
('Memorial Day', '2017-05-29'),
('Memorial Day', '2018-05-28'),
('Memorial Day', '2019-05-27'),
('Memorial Day', '2020-05-25'),
('Labor Day', '2004-09-06'),
('Labor Day', '2005-09-05'),
('Labor Day', '2006-09-04'),
('Labor Day', '2007-09-03'),
('Labor Day', '2008-09-01'),
('Labor Day', '2009-09-07'),
('Labor Day', '2010-09-06'),
('Labor Day', '2011-09-05'),
('Labor Day', '2012-09-03'),
('Labor Day', '2013-09-09'),
('Labor Day', '2014-09-08'),
('Labor Day', '2015-09-07'),
('Labor Day', '2016-09-05'),
('Labor Day', '2017-09-04'),
('Labor Day', '2018-09-03'),
('Labor Day', '2019-09-09'),
('Labor Day', '2020-09-07'),
('D-Day', '0004-06-06');
# --------------------------------------------------------

#
# Table structure for table `categories`
#

CREATE TABLE {$db_prefix}categories (
  id_cat tinyint(4) unsigned NOT NULL auto_increment,
  cat_order tinyint(4) NOT NULL default '0',
  name tinytext NOT NULL,
  can_collapse tinyint(1) NOT NULL default '1',
  PRIMARY KEY (id_cat)
) ENGINE=MyISAM;

#
# Dumping data for table `categories`
#

INSERT INTO {$db_prefix}categories
VALUES (1, 0, '{$default_category_name}', 1);
# --------------------------------------------------------

#
# Table structure for table `collapsed_categories`
#

CREATE TABLE {$db_prefix}collapsed_categories (
  id_cat tinyint(4) unsigned NOT NULL default '0',
  id_member mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY (id_cat, id_member)
) ENGINE=MyISAM;

#
# Table structure for table `custom_fields`
#

CREATE TABLE {$db_prefix}custom_fields (
  id_field smallint(5) NOT NULL auto_increment,
  col_name varchar(12) NOT NULL default '',
  field_name varchar(40) NOT NULL default '',
  field_desc tinytext NOT NULL,
  field_type varchar(8) NOT NULL default 'text',
  field_length smallint(5) NOT NULL default '255',
  field_options tinytext NOT NULL,
  mask tinytext NOT NULL,
  show_reg tinyint(3) NOT NULL default '0',
  show_display tinyint(3) NOT NULL default '0',
  show_profile varchar(20) NOT NULL default 'forumProfile',
  private tinyint(3) NOT NULL default '0',
  active tinyint(3) NOT NULL default '1',
  bbc tinyint(3) NOT NULL default '0',
  can_search tinyint(3) NOT NULL default '0',
  default_value tinytext NOT NULL,
  PRIMARY KEY (id_field),
  UNIQUE col_name (col_name)
) ENGINE=MyISAM;

#
# Table structure for table `group_moderators`
#

CREATE TABLE {$db_prefix}group_moderators (
  id_group smallint(5) unsigned NOT NULL default '0',
  id_member mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY (id_group, id_member)
) ENGINE=MyISAM;

#
# Table structure for table `log_actions`
#

CREATE TABLE {$db_prefix}log_actions (
  id_action int(10) unsigned NOT NULL auto_increment,
  id_log tinyint(3) unsigned NOT NULL default '1',
  log_time int(10) unsigned NOT NULL default '0',
  id_member mediumint(8) unsigned NOT NULL default '0',
  ip char(16) NOT NULL default '                ',
  action varchar(30) NOT NULL default '',
  id_board smallint(5) unsigned NOT NULL default '0',
  id_topic mediumint(8) unsigned NOT NULL default '0',
  id_msg int(10) unsigned NOT NULL default '0',
  extra text NOT NULL,
  PRIMARY KEY (id_action),
  KEY id_log (id_log),
  KEY log_time (log_time),
  KEY id_member (id_member),
  KEY id_board (id_board),
  KEY id_msg (id_msg)
) ENGINE=MyISAM;

#
# Table structure for table `log_activity`
#

CREATE TABLE {$db_prefix}log_activity (
  date date NOT NULL default '0001-01-01',
  hits mediumint(8) unsigned NOT NULL default '0',
  topics smallint(5) unsigned NOT NULL default '0',
  posts smallint(5) unsigned NOT NULL default '0',
  registers smallint(5) unsigned NOT NULL default '0',
  most_on smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY (date),
  KEY hits (hits),
  KEY most_on (most_on)
) ENGINE=MyISAM;

#
# Table structure for table `log_banned`
#

CREATE TABLE {$db_prefix}log_banned (
  id_ban_log mediumint(8) unsigned NOT NULL auto_increment,
  id_member mediumint(8) unsigned NOT NULL default '0',
  ip char(16) NOT NULL default '                ',
  email tinytext NOT NULL,
  log_time int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (id_ban_log),
  KEY log_time (log_time)
) ENGINE=MyISAM;

#
# Table structure for table `log_boards`
#

CREATE TABLE {$db_prefix}log_boards (
  id_member mediumint(8) unsigned NOT NULL default '0',
  id_board smallint(5) unsigned NOT NULL default '0',
  id_msg int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (id_member, id_board)
) ENGINE=MyISAM;

#
# Table structure for table `log_comments`
#

CREATE TABLE {$db_prefix}log_comments (
  id_comment mediumint(8) unsigned NOT NULL auto_increment,
  id_member mediumint(8) unsigned NOT NULL default '0',
  member_name varchar(80) NOT NULL default '',
  comment_type varchar(8) NOT NULL default 'warning',
  id_recipient mediumint(8) unsigned NOT NULL default '0',
  recipient_name tinytext NOT NULL,
  log_time int(10) NOT NULL default '0',
  id_notice mediumint(8) unsigned NOT NULL default '0',
  counter tinyint(3) NOT NULL default '0',
  body text NOT NULL,
  PRIMARY KEY (id_comment),
  KEY id_recipient (id_recipient),
  KEY log_time (log_time),
  KEY comment_type (comment_type(8))
) ENGINE=MyISAM;

#
# Table structure for table `log_digest`
#

CREATE TABLE {$db_prefix}log_digest (
  id_topic mediumint(8) unsigned NOT NULL,
  id_msg int(10) unsigned NOT NULL,
  note_type varchar(10) NOT NULL default 'post',
  daily smallint(3) unsigned NOT NULL default '0',
  exclude mediumint(8) unsigned NOT NULL default '0'
) ENGINE=MyISAM;

#
# Table structure for table `log_errors`
#

CREATE TABLE {$db_prefix}log_errors (
  id_error mediumint(8) unsigned NOT NULL auto_increment,
  log_time int(10) unsigned NOT NULL default '0',
  id_member mediumint(8) unsigned NOT NULL default '0',
  ip char(16) NOT NULL default '                ',
  url text NOT NULL,
  message text NOT NULL,
  session char(32) NOT NULL default '                                ',
  error_type char(15) NOT NULL default 'general',
  file tinytext NOT NULL,
  line mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY (id_error),
  KEY log_time (log_time),
  KEY id_member (id_member),
  KEY ip (ip(16))
) ENGINE=MyISAM;

#
# Table structure for table `log_floodcontrol`
#

CREATE TABLE {$db_prefix}log_floodcontrol (
  ip char(16) NOT NULL default '                ',
  log_time int(10) unsigned NOT NULL default '0',
  log_type varchar(8) NOT NULL default 'post',
  PRIMARY KEY (ip(16), log_type(8))
) ENGINE=MyISAM;

#
# Table structure for table `log_group_requests`
#

CREATE TABLE {$db_prefix}log_group_requests (
  id_request mediumint(8) unsigned NOT NULL auto_increment,
  id_member mediumint(8) unsigned NOT NULL default '0',
  id_group smallint(5) unsigned NOT NULL default '0',
  time_applied int(10) unsigned NOT NULL default '0',
  reason text NOT NULL,
  PRIMARY KEY (id_request),
  UNIQUE id_member (id_member, id_group)
) ENGINE=MYISAM;

#
# Table structure for table `log_karma`
#

CREATE TABLE {$db_prefix}log_karma (
  id_target mediumint(8) unsigned NOT NULL default '0',
  id_executor mediumint(8) unsigned NOT NULL default '0',
  log_time int(10) unsigned NOT NULL default '0',
  action tinyint(4) NOT NULL default '0',
  PRIMARY KEY (id_target, id_executor),
  KEY log_time (log_time)
) ENGINE=MyISAM;

#
# Table structure for table `log_mark_read`
#

CREATE TABLE {$db_prefix}log_mark_read (
  id_member mediumint(8) unsigned NOT NULL default '0',
  id_board smallint(5) unsigned NOT NULL default '0',
  id_msg int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (id_member, id_board)
) ENGINE=MyISAM;

#
# Table structure for table `log_member_notices`
#

CREATE TABLE {$db_prefix}log_member_notices (
  id_notice mediumint(8) unsigned NOT NULL auto_increment,
  subject tinytext NOT NULL,
  body text NOT NULL,
  PRIMARY KEY (id_notice)
) ENGINE=MyISAM;

#
# Table structure for table `log_notify`
#

CREATE TABLE {$db_prefix}log_notify (
  id_member mediumint(8) unsigned NOT NULL default '0',
  id_topic mediumint(8) unsigned NOT NULL default '0',
  id_board smallint(5) unsigned NOT NULL default '0',
  sent tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY (id_member, id_topic, id_board),
  KEY id_topic (id_topic, id_member)
) ENGINE=MyISAM;

#
# Table structure for table `log_online`
#

CREATE TABLE {$db_prefix}log_online (
  session varchar(32) NOT NULL default '',
  log_time int(10) NOT NULL default '0',
  id_member mediumint(8) unsigned NOT NULL default '0',
  id_spider smallint(5) unsigned NOT NULL default '0',
  ip int(10) unsigned NOT NULL default '0',
  url text NOT NULL,
  PRIMARY KEY (session),
  KEY log_time (log_time),
  KEY id_member (id_member)
) ENGINE=MyISAM;

#
# Table structure for table `log_packages`
#

CREATE TABLE {$db_prefix}log_packages (
  id_install int(10) NOT NULL auto_increment,
  filename tinytext NOT NULL,
  package_id tinytext NOT NULL,
  name tinytext NOT NULL,
  version tinytext NOT NULL,
  id_member_installed mediumint(8) NOT NULL default '0',
  member_installed tinytext NOT NULL,
  time_installed int(10) NOT NULL default '0',
  id_member_removed mediumint(8) NOT NULL default '0',
  member_removed tinytext NOT NULL,
  time_removed int(10) NOT NULL default '0',
  install_state tinyint(3) NOT NULL default '1',
  failed_steps text NOT NULL,
  themes_installed tinytext NOT NULL,
  db_changes text NOT NULL,
  PRIMARY KEY (id_install),
  KEY filename (filename(15))
) ENGINE=MyISAM;

#
# Table structure for table `log_polls`
#

CREATE TABLE {$db_prefix}log_polls (
  id_poll mediumint(8) unsigned NOT NULL default '0',
  id_member mediumint(8) unsigned NOT NULL default '0',
  id_choice tinyint(3) unsigned NOT NULL default '0',
  KEY id_poll (id_poll, id_member, id_choice)
) ENGINE=MyISAM;

#
# Table structure for table `log_reported`
#

CREATE TABLE {$db_prefix}log_reported (
  id_report mediumint(8) unsigned NOT NULL auto_increment,
  id_msg int(10) unsigned NOT NULL default '0',
  id_topic mediumint(8) unsigned NOT NULL default '0',
  id_board smallint(5) unsigned NOT NULL default '0',
  id_member mediumint(8) unsigned NOT NULL default '0',
  membername tinytext NOT NULL,
  subject tinytext NOT NULL,
  body text NOT NULL,
  time_started int(10) NOT NULL default '0',
  time_updated int(10) NOT NULL default '0',
  num_reports mediumint(6) NOT NULL default '0',
  closed tinyint(3) NOT NULL default '0',
  ignore_all tinyint(3) NOT NULL default '0',
  PRIMARY KEY (id_report),
  KEY id_member (id_member),
  KEY id_topic (id_topic),
  KEY closed (closed),
  KEY time_started (time_started),
  KEY id_msg (id_msg)
) ENGINE=MyISAM;

#
# Table structure for table `log_reported_comments`
#

CREATE TABLE {$db_prefix}log_reported_comments (
  id_comment mediumint(8) unsigned NOT NULL auto_increment,
  id_report mediumint(8) NOT NULL default '0',
  id_member mediumint(8) NOT NULL,
  membername tinytext NOT NULL,
  comment tinytext NOT NULL,
  time_sent int(10) NOT NULL,
  PRIMARY KEY (id_comment),
  KEY id_report (id_report),
  KEY id_member (id_member),
  KEY time_sent (time_sent)
) ENGINE=MyISAM;

#
# Table structure for table `log_scheduled_tasks`
#

CREATE TABLE {$db_prefix}log_scheduled_tasks (
  id_log mediumint(8) NOT NULL auto_increment,
  id_task smallint(5) NOT NULL default '0',
  time_run int(10) NOT NULL default '0',
  time_taken float NOT NULL default '0',
  PRIMARY KEY (id_log)
) ENGINE=MyISAM;

#
# Table structure for table `log_search_messages`
#

CREATE TABLE {$db_prefix}log_search_messages (
  id_search tinyint(3) unsigned NOT NULL default '0',
  id_msg int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (id_search, id_msg)
) ENGINE=MyISAM;

#
# Table structure for table `log_search_results`
#

CREATE TABLE {$db_prefix}log_search_results (
  id_search tinyint(3) unsigned NOT NULL default '0',
  id_topic mediumint(8) unsigned NOT NULL default '0',
  id_msg int(10) unsigned NOT NULL default '0',
  relevance smallint(5) unsigned NOT NULL default '0',
  num_matches smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY (id_search, id_topic)
) ENGINE=MyISAM;

#
# Table structure for table `log_search_subjects`
#

CREATE TABLE {$db_prefix}log_search_subjects (
  word varchar(20) NOT NULL default '',
  id_topic mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY (word, id_topic),
  KEY id_topic (id_topic)
) ENGINE=MyISAM;

#
# Table structure for table `log_search_topics`
#

CREATE TABLE {$db_prefix}log_search_topics (
  id_search tinyint(3) unsigned NOT NULL default '0',
  id_topic mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY (id_search, id_topic)
) ENGINE=MyISAM;

#
# Table structure for table `log_spider_hits`
#

CREATE TABLE {$db_prefix}log_spider_hits (
id_hit int(10) unsigned NOT NULL auto_increment,
  id_spider smallint(5) unsigned NOT NULL default '0',
  log_time int(10) unsigned NOT NULL default '0',
  url tinytext NOT NULL,
  processed tinyint(3) NOT NULL default '0',
  PRIMARY KEY (id_hit),
  KEY id_spider(id_spider),
  KEY log_time(log_time),
  KEY processed (processed)
) ENGINE=MyISAM;

#
# Table structure for table `log_spider_stats`
#

CREATE TABLE {$db_prefix}log_spider_stats (
  id_spider smallint(5) unsigned NOT NULL default '0',
  page_hits smallint(5) unsigned NOT NULL default '0',
  last_seen int(10) unsigned NOT NULL default '0',
  stat_date date NOT NULL default '0001-01-01',
  PRIMARY KEY (stat_date, id_spider)
) ENGINE=MyISAM;

#
# Table structure for table `log_subscribed`
#

CREATE TABLE {$db_prefix}log_subscribed (
  id_sublog int(10) unsigned NOT NULL auto_increment,
  id_subscribe mediumint(8) unsigned NOT NULL default '0',
  id_member int(10) NOT NULL default '0',
  old_id_group smallint(5) NOT NULL default '0',
  start_time int(10) NOT NULL default '0',
  end_time int(10) NOT NULL default '0',
  status tinyint(3) NOT NULL default '0',
  payments_pending tinyint(3) NOT NULL default '0',
  pending_details text NOT NULL,
  reminder_sent tinyint(3) NOT NULL default '0',
  vendor_ref tinytext NOT NULL,
  PRIMARY KEY (id_sublog),
  UNIQUE KEY id_subscribe (id_subscribe, id_member),
  KEY end_time (end_time),
  KEY reminder_sent (reminder_sent),
  KEY payments_pending (payments_pending),
  KEY status (status),
  KEY id_member (id_member)
) ENGINE=MyISAM;

#
# Table structure for table `log_topics`
#

CREATE TABLE {$db_prefix}log_topics (
  id_member mediumint(8) unsigned NOT NULL default '0',
  id_topic mediumint(8) unsigned NOT NULL default '0',
  id_msg int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (id_member, id_topic),
  KEY id_topic (id_topic)
) ENGINE=MyISAM;

#
# Table structure for table `mail_queue`
#

CREATE TABLE {$db_prefix}mail_queue (
  id_mail int(10) unsigned NOT NULL auto_increment,
  time_sent int(10) NOT NULL default '0',
  recipient tinytext NOT NULL,
  body text NOT NULL,
  subject tinytext NOT NULL,
  headers text NOT NULL,
  send_html tinyint(3) NOT NULL default '0',
  priority tinyint(3) NOT NULL default '1',
  PRIMARY KEY  (id_mail),
  KEY time_sent (time_sent),
  KEY mail_priority (priority, id_mail)
) ENGINE=MyISAM;

#
# Table structure for table `membergroups`
#

CREATE TABLE {$db_prefix}membergroups (
  id_group smallint(5) unsigned NOT NULL auto_increment,
  group_name varchar(80) NOT NULL default '',
  description text NOT NULL,
  online_color varchar(20) NOT NULL default '',
  min_posts mediumint(9) NOT NULL default '-1',
  max_messages smallint(5) unsigned NOT NULL default '0',
  stars tinytext NOT NULL,
  group_type tinyint(3) NOT NULL default '0',
  hidden tinyint(3) NOT NULL default '0',
  id_parent smallint(5) NOT NULL default '-2',
  PRIMARY KEY (id_group),
  KEY min_posts (min_posts)
) ENGINE=MyISAM;

#
# Dumping data for table `membergroups`
#

INSERT INTO {$db_prefix}membergroups
(id_group, group_name, description, online_color, min_posts, stars)
VALUES (1, '{$default_administrator_group}', '', '#FF0000', -1, '5#staradmin.gif'),
(2, '{$default_global_moderator_group}', '', '#0000FF', -1, '5#stargmod.gif'),
(3, '{$default_moderator_group}', '', '', -1, '5#starmod.gif'),
(4, '{$default_newbie_group}', '', '', 0, '1#star.gif'),
(5, '{$default_junior_group}', '', '', 50, '2#star.gif'),
(6, '{$default_full_group}', '', '', 100, '3#star.gif'),
(7, '{$default_senior_group}', '', '', 250, '4#star.gif'),
(8, '{$default_hero_group}', '', '', 500, '5#star.gif');
# --------------------------------------------------------

#
# Table structure for table `members`
#

CREATE TABLE {$db_prefix}members (
  id_member mediumint(8) unsigned NOT NULL auto_increment,
  member_name varchar(80) NOT NULL default '',
  date_registered int(10) unsigned NOT NULL default '0',
  posts mediumint(8) unsigned NOT NULL default '0',
  id_group smallint(5) unsigned NOT NULL default '0',
  lngfile tinytext NOT NULL,
  last_login int(10) unsigned NOT NULL default '0',
  real_name tinytext NOT NULL,
  instant_messages smallint(5) NOT NULL default 0,
  unread_messages smallint(5) NOT NULL default 0,
  new_pm tinyint(3) unsigned NOT NULL default '0',
  buddy_list text NOT NULL,
  pm_ignore_list tinytext NOT NULL,
  pm_prefs mediumint(8) NOT NULL default '0',
  mod_prefs varchar(20) NOT NULL default '',
  message_labels text NOT NULL,
  passwd varchar(64) NOT NULL default '',
  openid_uri text NOT NULL,
  email_address tinytext NOT NULL,
  personal_text tinytext NOT NULL,
  gender tinyint(4) unsigned NOT NULL default '0',
  birthdate date NOT NULL default '0001-01-01',
  website_title tinytext NOT NULL,
  website_url tinytext NOT NULL,
  location tinytext NOT NULL,
  icq tinytext NOT NULL,
  aim varchar(16) NOT NULL default '',
  yim varchar(32) NOT NULL default '',
  msn tinytext NOT NULL,
  hide_email tinyint(4) NOT NULL default '0',
  show_online tinyint(4) NOT NULL default '1',
  time_format varchar(80) NOT NULL default '',
  signature text NOT NULL,
  time_offset float NOT NULL default '0',
  avatar tinytext NOT NULL,
  pm_email_notify tinyint(4) NOT NULL default '0',
  karma_bad smallint(5) unsigned NOT NULL default '0',
  karma_good smallint(5) unsigned NOT NULL default '0',
  usertitle tinytext NOT NULL,
  notify_announcements tinyint(4) NOT NULL default '1',
  notify_regularity tinyint(4) NOT NULL default '1',
  notify_send_body tinyint(4) NOT NULL default '0',
  notify_types tinyint(4) NOT NULL default '2',
  member_ip tinytext NOT NULL,
  member_ip2 tinytext NOT NULL,
  secret_question tinytext NOT NULL,
  secret_answer varchar(64) NOT NULL default '',
  id_theme tinyint(4) unsigned NOT NULL default '0',
  is_activated tinyint(3) unsigned NOT NULL default '1',
  validation_code varchar(10) NOT NULL default '',
  id_msg_last_visit int(10) unsigned NOT NULL default '0',
  additional_groups tinytext NOT NULL,
  smiley_set varchar(48) NOT NULL default '',
  id_post_group smallint(5) unsigned NOT NULL default '0',
  total_time_logged_in int(10) unsigned NOT NULL default '0',
  password_salt varchar(5) NOT NULL default '',
  ignore_boards text NOT NULL,
  warning tinyint(4) NOT NULL default '0',
  passwd_flood varchar(12) NOT NULL default '',
  PRIMARY KEY (id_member),
  KEY memberName (member_name(30)),
  KEY date_registered (date_registered),
  KEY id_group (id_group),
  KEY birthdate (birthdate),
  KEY posts (posts),
  KEY last_login (last_login),
  KEY lngfile (lngfile(30)),
  KEY id_post_group (id_post_group),
  KEY warning (warning)
) ENGINE=MyISAM;

#
# Table structure for table `message_icons`
#

CREATE TABLE {$db_prefix}message_icons (
  id_icon smallint(5) unsigned NOT NULL auto_increment,
  title varchar(80) NOT NULL default '',
  filename varchar(80) NOT NULL default '',
  id_board smallint(5) unsigned NOT NULL default '0',
  icon_order smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY (id_icon),
  KEY id_board (id_board)
) ENGINE=MyISAM;

#
# Dumping data for table `message_icons`
#

# // !!! i18n
INSERT INTO {$db_prefix}message_icons
(filename, title, icon_order)
VALUES ('xx', 'Standard', '0'),
('thumbup', 'Thumb Up', '1'),
('thumbdown', 'Thumb Down', '2'),
('exclamation', 'Exclamation point', '3'),
('question', 'Question mark', '4'),
('lamp', 'Lamp', '5'),
('smiley', 'Smiley', '6'),
('angry', 'Angry', '7'),
('cheesy', 'Cheesy', '8'),
('grin', 'Grin', '9'),
('sad', 'Sad', '10'),
('wink', 'Wink', '11');
# --------------------------------------------------------

#
# Table structure for table `messages`
#

CREATE TABLE {$db_prefix}messages (
  id_msg int(10) unsigned NOT NULL auto_increment,
  id_topic mediumint(8) unsigned NOT NULL default '0',
  id_board smallint(5) unsigned NOT NULL default '0',
  poster_time int(10) unsigned NOT NULL default '0',
  id_member mediumint(8) unsigned NOT NULL default '0',
  id_msg_modified int(10) unsigned NOT NULL default '0',
  subject tinytext NOT NULL,
  poster_name tinytext NOT NULL,
  poster_email tinytext NOT NULL,
  poster_ip tinytext NOT NULL,
  smileys_enabled tinyint(4) NOT NULL default '1',
  modified_time int(10) unsigned NOT NULL default '0',
  modified_name tinytext NOT NULL,
  body text NOT NULL,
  icon varchar(16) NOT NULL default 'xx',
  approved tinyint(3) NOT NULL default '1',
  PRIMARY KEY (id_msg),
  UNIQUE topic (id_topic, id_msg),
  UNIQUE id_board (id_board, id_msg),
  UNIQUE id_member (id_member, id_msg),
  KEY approved (approved),
  KEY ip_index (poster_ip(15), id_topic),
  KEY participation (id_member, id_topic),
  KEY show_posts (id_member, id_board),
  KEY id_topic (id_topic)
) ENGINE=MyISAM;

#
# Dumping data for table `messages`
#

INSERT INTO {$db_prefix}messages
(id_msg, id_msg_modified, id_topic, id_board, poster_time, subject, poster_name, poster_email, poster_ip, modified_name, body, icon)
VALUES (1, 1, 1, 1, UNIX_TIMESTAMP(), '{$default_topic_subject}', 'Simple Machines', '[email protected]', '127.0.0.1', '', '{$default_topic_message}', 'xx');
# --------------------------------------------------------

#
# Table structure for table `moderators`
#

CREATE TABLE {$db_prefix}moderators (
  id_board smallint(5) unsigned NOT NULL default '0',
  id_member mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY (id_board, id_member)
) ENGINE=MyISAM;

#
# Table structure for table `openid_assoc`
#

CREATE TABLE {$db_prefix}openid_assoc (
  server_url text NOT NULL,
  handle tinytext NOT NULL,
  secret text NOT NULL,
  issued int(10) NOT NULL default '0',
  expires int(10) NOT NULL default '0',
  assoc_type varchar(64) NOT NULL,
  PRIMARY KEY (server_url(125), handle(125)),
  KEY expires (expires)
) ENGINE=MyISAM;

#
# Table structure for table `package_servers`
#

CREATE TABLE {$db_prefix}package_servers (
  id_server smallint(5) unsigned NOT NULL auto_increment,
  name tinytext NOT NULL,
  url tinytext NOT NULL,
  PRIMARY KEY (id_server)
) ENGINE=MyISAM;

#
# Dumping data for table `package_servers`
#

INSERT INTO {$db_prefix}package_servers
(name, url)
VALUES ('Simple Machines Third-party Mod Site', 'http://mods.simplemachines.org');
# --------------------------------------------------------

#
# Table structure for table `permission_profiles`
#

CREATE TABLE {$db_prefix}permission_profiles (
  id_profile smallint(5) NOT NULL auto_increment,
  profile_name tinytext NOT NULL,
  PRIMARY KEY (id_profile)
) ENGINE=MyISAM;

#
# Dumping data for table `permission_profiles`
#

INSERT INTO {$db_prefix}permission_profiles
(id_profile, profile_name)
VALUES (1, 'default'), (2, 'no_polls'), (3, 'reply_only'), (4, 'read_only');
# --------------------------------------------------------

#
# Table structure for table `permissions`
#

CREATE TABLE {$db_prefix}permissions (
  id_group smallint(5) NOT NULL default '0',
  permission varchar(30) NOT NULL default '',
  add_deny tinyint(4) NOT NULL default '1',
  PRIMARY KEY (id_group, permission)
) ENGINE=MyISAM;

#
# Dumping data for table `permissions`
#

Colin B
Former Spammer, Customize, & Support Team Member

metallica48423

shadow: might i reccommend attaching the file? it cut off :P

In any case, the file he was trying to post can be found in any install package of SMF 2.0
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

QuoteMicrosoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"


Useful Links:
Online Manual!
How to Help us Help you
Search
Settings Repair Tool

Advertisement: