--
-- Host: localhost    Database: punbb
---------------------------------------------------------

--
-- Table structure for table 'bans'
--

CREATE TABLE bans (
  id int(10) unsigned NOT NULL auto_increment,
  username varchar(200) default NULL,
  ip varchar(255) default NULL,
  email varchar(50) default NULL,
  message varchar(255) default NULL,
  expire int(10) unsigned default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'bans'
--


--
-- Table structure for table 'categories'
--

CREATE TABLE categories (
  id int(10) unsigned NOT NULL auto_increment,
  cat_name varchar(80) NOT NULL default 'New Category',
  disp_position int(10) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'categories'
--

INSERT INTO categories VALUES (1,'Test category',1);

--
-- Table structure for table 'censoring'
--

CREATE TABLE censoring (
  id int(10) unsigned NOT NULL auto_increment,
  search_for varchar(60) NOT NULL default '',
  replace_with varchar(60) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'censoring'
--


--
-- Table structure for table 'config'
--

CREATE TABLE config (
  conf_name varchar(255) NOT NULL default '',
  conf_value text,
  PRIMARY KEY  (conf_name)
) TYPE=MyISAM;

--
-- Dumping data for table 'config'
--

INSERT INTO config VALUES ('o_cur_version','1.2.11');
INSERT INTO config VALUES ('o_board_title','My PunBB forum');
INSERT INTO config VALUES ('o_board_desc','Unfortunately no one can be told what PunBB is - you have to see it for yourself.');
INSERT INTO config VALUES ('o_server_timezone','0');
INSERT INTO config VALUES ('o_time_format','H:i:s');
INSERT INTO config VALUES ('o_date_format','Y-m-d');
INSERT INTO config VALUES ('o_timeout_visit','600');
INSERT INTO config VALUES ('o_timeout_online','300');
INSERT INTO config VALUES ('o_redirect_delay','1');
INSERT INTO config VALUES ('o_show_version','0');
INSERT INTO config VALUES ('o_show_user_info','1');
INSERT INTO config VALUES ('o_show_post_count','1');
INSERT INTO config VALUES ('o_smilies','1');
INSERT INTO config VALUES ('o_smilies_sig','1');
INSERT INTO config VALUES ('o_make_links','1');
INSERT INTO config VALUES ('o_default_lang','English');
INSERT INTO config VALUES ('o_default_style','Oxygen');
INSERT INTO config VALUES ('o_default_user_group','4');
INSERT INTO config VALUES ('o_topic_review','15');
INSERT INTO config VALUES ('o_disp_topics_default','30');
INSERT INTO config VALUES ('o_disp_posts_default','25');
INSERT INTO config VALUES ('o_indent_num_spaces','4');
INSERT INTO config VALUES ('o_quickpost','1');
INSERT INTO config VALUES ('o_users_online','1');
INSERT INTO config VALUES ('o_censoring','0');
INSERT INTO config VALUES ('o_ranks','1');
INSERT INTO config VALUES ('o_show_dot','0');
INSERT INTO config VALUES ('o_quickjump','1');
INSERT INTO config VALUES ('o_gzip','0');
INSERT INTO config VALUES ('o_additional_navlinks','');
INSERT INTO config VALUES ('o_report_method','0');
INSERT INTO config VALUES ('o_regs_report','0');
INSERT INTO config VALUES ('o_mailing_list','blah@yahooz.com');
INSERT INTO config VALUES ('o_avatars','1');
INSERT INTO config VALUES ('o_avatars_dir','img/avatars');
INSERT INTO config VALUES ('o_avatars_width','60');
INSERT INTO config VALUES ('o_avatars_height','60');
INSERT INTO config VALUES ('o_avatars_size','10240');
INSERT INTO config VALUES ('o_search_all_forums','1');
INSERT INTO config VALUES ('o_base_url','http://localhost/~pclouds/punbb');
INSERT INTO config VALUES ('o_admin_email','blah@yahooz.com');
INSERT INTO config VALUES ('o_webmaster_email','blah@yahooz.com');
INSERT INTO config VALUES ('o_subscriptions','1');
INSERT INTO config VALUES ('o_smtp_host',NULL);
INSERT INTO config VALUES ('o_smtp_user',NULL);
INSERT INTO config VALUES ('o_smtp_pass',NULL);
INSERT INTO config VALUES ('o_regs_allow','1');
INSERT INTO config VALUES ('o_regs_verify','0');
INSERT INTO config VALUES ('o_announcement','0');
INSERT INTO config VALUES ('o_announcement_message','Enter your announcement here.');
INSERT INTO config VALUES ('o_rules','0');
INSERT INTO config VALUES ('o_rules_message','Enter your rules here.');
INSERT INTO config VALUES ('o_maintenance','0');
INSERT INTO config VALUES ('o_maintenance_message','The forums are temporarily down for maintenance. Please try again in a few minutes.<br />\n<br />\n/Administrator');
INSERT INTO config VALUES ('p_mod_edit_users','1');
INSERT INTO config VALUES ('p_mod_rename_users','0');
INSERT INTO config VALUES ('p_mod_change_passwords','0');
INSERT INTO config VALUES ('p_mod_ban_users','0');
INSERT INTO config VALUES ('p_message_bbcode','1');
INSERT INTO config VALUES ('p_message_img_tag','1');
INSERT INTO config VALUES ('p_message_all_caps','1');
INSERT INTO config VALUES ('p_subject_all_caps','1');
INSERT INTO config VALUES ('p_sig_all_caps','1');
INSERT INTO config VALUES ('p_sig_bbcode','1');
INSERT INTO config VALUES ('p_sig_img_tag','0');
INSERT INTO config VALUES ('p_sig_length','400');
INSERT INTO config VALUES ('p_sig_lines','4');
INSERT INTO config VALUES ('p_allow_banned_email','1');
INSERT INTO config VALUES ('p_allow_dupe_email','0');
INSERT INTO config VALUES ('p_force_guest_email','1');

--
-- Table structure for table 'forum_perms'
--

CREATE TABLE forum_perms (
  group_id int(10) NOT NULL default '0',
  forum_id int(10) NOT NULL default '0',
  read_forum tinyint(1) NOT NULL default '1',
  post_replies tinyint(1) NOT NULL default '1',
  post_topics tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (group_id,forum_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'forum_perms'
--


--
-- Table structure for table 'forums'
--

CREATE TABLE forums (
  id int(10) unsigned NOT NULL auto_increment,
  forum_name varchar(80) NOT NULL default 'New forum',
  forum_desc text,
  redirect_url varchar(100) default NULL,
  moderators text,
  num_topics mediumint(8) unsigned NOT NULL default '0',
  num_posts mediumint(8) unsigned NOT NULL default '0',
  last_post int(10) unsigned default NULL,
  last_post_id int(10) unsigned default NULL,
  last_poster varchar(200) default NULL,
  sort_by tinyint(1) NOT NULL default '0',
  disp_position int(10) NOT NULL default '0',
  cat_id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'forums'
--

INSERT INTO forums VALUES (1,'Test forum','This is just a test forum',NULL,NULL,1,1,1154943677,1,'root',0,1,1);

--
-- Table structure for table 'groups'
--

CREATE TABLE groups (
  g_id int(10) unsigned NOT NULL auto_increment,
  g_title varchar(50) NOT NULL default '',
  g_user_title varchar(50) default NULL,
  g_read_board tinyint(1) NOT NULL default '1',
  g_post_replies tinyint(1) NOT NULL default '1',
  g_post_topics tinyint(1) NOT NULL default '1',
  g_post_polls tinyint(1) NOT NULL default '1',
  g_edit_posts tinyint(1) NOT NULL default '1',
  g_delete_posts tinyint(1) NOT NULL default '1',
  g_delete_topics tinyint(1) NOT NULL default '1',
  g_set_title tinyint(1) NOT NULL default '1',
  g_search tinyint(1) NOT NULL default '1',
  g_search_users tinyint(1) NOT NULL default '1',
  g_edit_subjects_interval smallint(6) NOT NULL default '300',
  g_post_flood smallint(6) NOT NULL default '30',
  g_search_flood smallint(6) NOT NULL default '30',
  PRIMARY KEY  (g_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'groups'
--

INSERT INTO groups VALUES (1,'Administrators','Administrator',1,1,1,1,1,1,1,1,1,1,0,0,0);
INSERT INTO groups VALUES (2,'Moderators','Moderator',1,1,1,1,1,1,1,1,1,1,0,0,0);
INSERT INTO groups VALUES (3,'Guest',NULL,1,0,0,0,0,0,0,0,1,1,0,0,0);
INSERT INTO groups VALUES (4,'Members',NULL,1,1,1,1,1,1,1,0,1,1,300,60,30);

--
-- Table structure for table 'online'
--

CREATE TABLE online (
  user_id int(10) unsigned NOT NULL default '1',
  ident varchar(200) NOT NULL default '',
  logged int(10) unsigned NOT NULL default '0',
  idle tinyint(1) NOT NULL default '0',
  KEY online_user_id_idx (user_id)
) TYPE=HEAP;

--
-- Dumping data for table 'online'
--


--
-- Table structure for table 'posts'
--

CREATE TABLE posts (
  id int(10) unsigned NOT NULL auto_increment,
  poster varchar(200) NOT NULL default '',
  poster_id int(10) unsigned NOT NULL default '1',
  poster_ip varchar(15) default NULL,
  poster_email varchar(50) default NULL,
  message text NOT NULL,
  hide_smilies tinyint(1) NOT NULL default '0',
  posted int(10) unsigned NOT NULL default '0',
  edited int(10) unsigned default NULL,
  edited_by varchar(200) default NULL,
  topic_id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY posts_topic_id_idx (topic_id),
  KEY posts_multi_idx (poster_id,topic_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'posts'
--

INSERT INTO posts VALUES (1,'root',2,'127.0.0.1',NULL,'If you are looking at this (which I guess you are), the install of PunBB appears to have worked! Now log in and head over to the administration control panel to configure your forum.',0,1154943677,NULL,NULL,1);

--
-- Table structure for table 'ranks'
--

CREATE TABLE ranks (
  id int(10) unsigned NOT NULL auto_increment,
  rank varchar(50) NOT NULL default '',
  min_posts mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'ranks'
--

INSERT INTO ranks VALUES (1,'New member',0);
INSERT INTO ranks VALUES (2,'Member',10);

--
-- Table structure for table 'reports'
--

CREATE TABLE reports (
  id int(10) unsigned NOT NULL auto_increment,
  post_id int(10) unsigned NOT NULL default '0',
  topic_id int(10) unsigned NOT NULL default '0',
  forum_id int(10) unsigned NOT NULL default '0',
  reported_by int(10) unsigned NOT NULL default '0',
  created int(10) unsigned NOT NULL default '0',
  message text NOT NULL,
  zapped int(10) unsigned default NULL,
  zapped_by int(10) unsigned default NULL,
  PRIMARY KEY  (id),
  KEY reports_zapped_idx (zapped)
) TYPE=MyISAM;

--
-- Dumping data for table 'reports'
--


--
-- Table structure for table 'search_cache'
--

CREATE TABLE search_cache (
  id int(10) unsigned NOT NULL default '0',
  ident varchar(200) NOT NULL default '',
  search_data text NOT NULL,
  PRIMARY KEY  (id),
  KEY search_cache_ident_idx (ident(8))
) TYPE=MyISAM;

--
-- Dumping data for table 'search_cache'
--


--
-- Table structure for table 'search_matches'
--

CREATE TABLE search_matches (
  post_id int(10) unsigned NOT NULL default '0',
  word_id mediumint(8) unsigned NOT NULL default '0',
  subject_match tinyint(1) NOT NULL default '0',
  KEY search_matches_word_id_idx (word_id),
  KEY search_matches_post_id_idx (post_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'search_matches'
--


--
-- Table structure for table 'search_words'
--

CREATE TABLE search_words (
  id mediumint(8) unsigned NOT NULL auto_increment,
  word varchar(20) binary NOT NULL default '',
  PRIMARY KEY  (word),
  KEY search_words_id_idx (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'search_words'
--


--
-- Table structure for table 'subscriptions'
--

CREATE TABLE subscriptions (
  user_id int(10) unsigned NOT NULL default '0',
  topic_id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (user_id,topic_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'subscriptions'
--


--
-- Table structure for table 'topics'
--

CREATE TABLE topics (
  id int(10) unsigned NOT NULL auto_increment,
  poster varchar(200) NOT NULL default '',
  subject varchar(255) NOT NULL default '',
  posted int(10) unsigned NOT NULL default '0',
  last_post int(10) unsigned NOT NULL default '0',
  last_post_id int(10) unsigned NOT NULL default '0',
  last_poster varchar(200) default NULL,
  num_views mediumint(8) unsigned NOT NULL default '0',
  num_replies mediumint(8) unsigned NOT NULL default '0',
  closed tinyint(1) NOT NULL default '0',
  sticky tinyint(1) NOT NULL default '0',
  moved_to int(10) unsigned default NULL,
  forum_id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY topics_forum_id_idx (forum_id),
  KEY topics_moved_to_idx (moved_to)
) TYPE=MyISAM;

--
-- Dumping data for table 'topics'
--

INSERT INTO topics VALUES (1,'root','Test post',1154943677,1154943677,1,'root',0,0,0,0,NULL,1);

