-- MySQL dump 10.11 -- -- Host: localhost Database: demo_punbb12 -- ------------------------------------------------------ -- Server version 5.0.51a-3ubuntu5.2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `demo_punbb12_bans` -- DROP TABLE IF EXISTS `demo_punbb12_bans`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_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`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_bans` -- LOCK TABLES `demo_punbb12_bans` WRITE; /*!40000 ALTER TABLE `demo_punbb12_bans` DISABLE KEYS */; /*!40000 ALTER TABLE `demo_punbb12_bans` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_categories` -- DROP TABLE IF EXISTS `demo_punbb12_categories`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_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`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_categories` -- LOCK TABLES `demo_punbb12_categories` WRITE; /*!40000 ALTER TABLE `demo_punbb12_categories` DISABLE KEYS */; INSERT INTO `demo_punbb12_categories` VALUES (1,'Test category',1); /*!40000 ALTER TABLE `demo_punbb12_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_censoring` -- DROP TABLE IF EXISTS `demo_punbb12_censoring`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_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`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_censoring` -- LOCK TABLES `demo_punbb12_censoring` WRITE; /*!40000 ALTER TABLE `demo_punbb12_censoring` DISABLE KEYS */; /*!40000 ALTER TABLE `demo_punbb12_censoring` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_config` -- DROP TABLE IF EXISTS `demo_punbb12_config`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_config` ( `conf_name` varchar(255) NOT NULL default '', `conf_value` text, PRIMARY KEY (`conf_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_config` -- LOCK TABLES `demo_punbb12_config` WRITE; /*!40000 ALTER TABLE `demo_punbb12_config` DISABLE KEYS */; INSERT INTO `demo_punbb12_config` VALUES ('o_cur_version','1.2.20'),('o_board_title','PunBB 1.2.20 demo'),('o_board_desc','This forum is a clean PunBB 1.2.20 installation for demonstration purposes. The database is periodically restored from the backup.'),('o_server_timezone','0'),('o_time_format','H:i:s'),('o_date_format','Y-m-d'),('o_timeout_visit','600'),('o_timeout_online','300'),('o_redirect_delay','1'),('o_show_version','0'),('o_show_user_info','1'),('o_show_post_count','1'),('o_smilies','1'),('o_smilies_sig','1'),('o_make_links','1'),('o_default_lang','English'),('o_default_style','Oxygen'),('o_default_user_group','4'),('o_topic_review','15'),('o_disp_topics_default','30'),('o_disp_posts_default','25'),('o_indent_num_spaces','4'),('o_quickpost','1'),('o_users_online','1'),('o_censoring','0'),('o_ranks','1'),('o_show_dot','0'),('o_quickjump','1'),('o_gzip','0'),('o_additional_navlinks',''),('o_report_method','0'),('o_regs_report','0'),('o_mailing_list','anatoly@punbb.org'),('o_avatars','1'),('o_avatars_dir','img/avatars'),('o_avatars_width','60'),('o_avatars_height','60'),('o_avatars_size','10240'),('o_search_all_forums','1'),('o_base_url','http://punbb.informer.com/demo/punbb12'),('o_admin_email','anatoly@punbb.org'),('o_webmaster_email','anatoly@punbb.org'),('o_subscriptions','1'),('o_smtp_host',NULL),('o_smtp_user',NULL),('o_smtp_pass',NULL),('o_regs_allow','1'),('o_regs_verify','0'),('o_announcement','1'),('o_announcement_message','
Administrator account username: admin, password: admin.
\n
Moderator account username: moderator, password: moderator.
\n
Regular user account username: user, password: user.
'),('o_rules','0'),('o_rules_message','Enter your rules here.'),('o_maintenance','0'),('o_maintenance_message','The forums are temporarily down for maintenance. Please try again in a few minutes.
\n
\n/Administrator'),('p_mod_edit_users','1'),('p_mod_rename_users','0'),('p_mod_change_passwords','0'),('p_mod_ban_users','0'),('p_message_bbcode','1'),('p_message_img_tag','1'),('p_message_all_caps','1'),('p_subject_all_caps','1'),('p_sig_all_caps','1'),('p_sig_bbcode','1'),('p_sig_img_tag','0'),('p_sig_length','400'),('p_sig_lines','4'),('p_allow_banned_email','1'),('p_allow_dupe_email','0'),('p_force_guest_email','1'); /*!40000 ALTER TABLE `demo_punbb12_config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_forum_perms` -- DROP TABLE IF EXISTS `demo_punbb12_forum_perms`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_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`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_forum_perms` -- LOCK TABLES `demo_punbb12_forum_perms` WRITE; /*!40000 ALTER TABLE `demo_punbb12_forum_perms` DISABLE KEYS */; /*!40000 ALTER TABLE `demo_punbb12_forum_perms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_forums` -- DROP TABLE IF EXISTS `demo_punbb12_forums`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_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`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_forums` -- LOCK TABLES `demo_punbb12_forums` WRITE; /*!40000 ALTER TABLE `demo_punbb12_forums` DISABLE KEYS */; INSERT INTO `demo_punbb12_forums` VALUES (1,'Test forum','This is just a test forum',NULL,'a:1:{s:9:\"moderator\";i:3;}',1,1,1225960609,1,'admin',0,1,1); /*!40000 ALTER TABLE `demo_punbb12_forums` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_groups` -- DROP TABLE IF EXISTS `demo_punbb12_groups`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_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`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_groups` -- LOCK TABLES `demo_punbb12_groups` WRITE; /*!40000 ALTER TABLE `demo_punbb12_groups` DISABLE KEYS */; INSERT INTO `demo_punbb12_groups` VALUES (1,'Administrators','Administrator',1,1,1,1,1,1,1,1,1,1,0,0,0),(2,'Moderators','Moderator',1,1,1,1,1,1,1,1,1,1,0,0,0),(3,'Guest',NULL,1,0,0,0,0,0,0,0,1,1,0,0,0),(4,'Members',NULL,1,1,1,1,1,1,1,0,1,1,300,60,30); /*!40000 ALTER TABLE `demo_punbb12_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_online` -- DROP TABLE IF EXISTS `demo_punbb12_online`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_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', UNIQUE KEY `demo_punbb12_online_user_id_ident_idx` (`user_id`,`ident`), KEY `demo_punbb12_online_user_id_idx` (`user_id`) ) ENGINE=MEMORY DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_online` -- LOCK TABLES `demo_punbb12_online` WRITE; /*!40000 ALTER TABLE `demo_punbb12_online` DISABLE KEYS */; INSERT INTO `demo_punbb12_online` VALUES (1,'91.201.1.254',1225961138,0),(2,'admin',1225961376,0); /*!40000 ALTER TABLE `demo_punbb12_online` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_posts` -- DROP TABLE IF EXISTS `demo_punbb12_posts`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_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, `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 `demo_punbb12_posts_topic_id_idx` (`topic_id`), KEY `demo_punbb12_posts_multi_idx` (`poster_id`,`topic_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_posts` -- LOCK TABLES `demo_punbb12_posts` WRITE; /*!40000 ALTER TABLE `demo_punbb12_posts` DISABLE KEYS */; INSERT INTO `demo_punbb12_posts` VALUES (1,'admin',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,1225960609,NULL,NULL,1); /*!40000 ALTER TABLE `demo_punbb12_posts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_ranks` -- DROP TABLE IF EXISTS `demo_punbb12_ranks`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_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`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_ranks` -- LOCK TABLES `demo_punbb12_ranks` WRITE; /*!40000 ALTER TABLE `demo_punbb12_ranks` DISABLE KEYS */; INSERT INTO `demo_punbb12_ranks` VALUES (1,'New member',0),(2,'Member',10); /*!40000 ALTER TABLE `demo_punbb12_ranks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_reports` -- DROP TABLE IF EXISTS `demo_punbb12_reports`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_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, `zapped` int(10) unsigned default NULL, `zapped_by` int(10) unsigned default NULL, PRIMARY KEY (`id`), KEY `demo_punbb12_reports_zapped_idx` (`zapped`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_reports` -- LOCK TABLES `demo_punbb12_reports` WRITE; /*!40000 ALTER TABLE `demo_punbb12_reports` DISABLE KEYS */; /*!40000 ALTER TABLE `demo_punbb12_reports` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_search_cache` -- DROP TABLE IF EXISTS `demo_punbb12_search_cache`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_search_cache` ( `id` int(10) unsigned NOT NULL default '0', `ident` varchar(200) NOT NULL default '', `search_data` text, PRIMARY KEY (`id`), KEY `demo_punbb12_search_cache_ident_idx` (`ident`(8)) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_search_cache` -- LOCK TABLES `demo_punbb12_search_cache` WRITE; /*!40000 ALTER TABLE `demo_punbb12_search_cache` DISABLE KEYS */; /*!40000 ALTER TABLE `demo_punbb12_search_cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_search_matches` -- DROP TABLE IF EXISTS `demo_punbb12_search_matches`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_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 `demo_punbb12_search_matches_word_id_idx` (`word_id`), KEY `demo_punbb12_search_matches_post_id_idx` (`post_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_search_matches` -- LOCK TABLES `demo_punbb12_search_matches` WRITE; /*!40000 ALTER TABLE `demo_punbb12_search_matches` DISABLE KEYS */; /*!40000 ALTER TABLE `demo_punbb12_search_matches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_search_words` -- DROP TABLE IF EXISTS `demo_punbb12_search_words`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_search_words` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `word` varchar(20) character set utf8 collate utf8_bin NOT NULL default '', PRIMARY KEY (`word`), KEY `demo_punbb12_search_words_id_idx` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_search_words` -- LOCK TABLES `demo_punbb12_search_words` WRITE; /*!40000 ALTER TABLE `demo_punbb12_search_words` DISABLE KEYS */; /*!40000 ALTER TABLE `demo_punbb12_search_words` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_subscriptions` -- DROP TABLE IF EXISTS `demo_punbb12_subscriptions`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_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`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_subscriptions` -- LOCK TABLES `demo_punbb12_subscriptions` WRITE; /*!40000 ALTER TABLE `demo_punbb12_subscriptions` DISABLE KEYS */; /*!40000 ALTER TABLE `demo_punbb12_subscriptions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_topics` -- DROP TABLE IF EXISTS `demo_punbb12_topics`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_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 `demo_punbb12_topics_forum_id_idx` (`forum_id`), KEY `demo_punbb12_topics_moved_to_idx` (`moved_to`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_topics` -- LOCK TABLES `demo_punbb12_topics` WRITE; /*!40000 ALTER TABLE `demo_punbb12_topics` DISABLE KEYS */; INSERT INTO `demo_punbb12_topics` VALUES (1,'admin','Test post',1225960609,1225960609,1,'admin',0,0,0,0,NULL,1); /*!40000 ALTER TABLE `demo_punbb12_topics` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `demo_punbb12_users` -- DROP TABLE IF EXISTS `demo_punbb12_users`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; CREATE TABLE `demo_punbb12_users` ( `id` int(10) unsigned NOT NULL auto_increment, `group_id` int(10) unsigned NOT NULL default '4', `username` varchar(200) NOT NULL default '', `password` varchar(40) NOT NULL default '', `email` varchar(50) NOT NULL default '', `title` varchar(50) default NULL, `realname` varchar(40) default NULL, `url` varchar(100) default NULL, `jabber` varchar(75) default NULL, `icq` varchar(12) default NULL, `msn` varchar(50) default NULL, `aim` varchar(30) default NULL, `yahoo` varchar(30) default NULL, `location` varchar(30) default NULL, `use_avatar` tinyint(1) NOT NULL default '0', `signature` text, `disp_topics` tinyint(3) unsigned default NULL, `disp_posts` tinyint(3) unsigned default NULL, `email_setting` tinyint(1) NOT NULL default '1', `save_pass` tinyint(1) NOT NULL default '1', `notify_with_post` tinyint(1) NOT NULL default '0', `show_smilies` tinyint(1) NOT NULL default '1', `show_img` tinyint(1) NOT NULL default '1', `show_img_sig` tinyint(1) NOT NULL default '1', `show_avatars` tinyint(1) NOT NULL default '1', `show_sig` tinyint(1) NOT NULL default '1', `timezone` float NOT NULL default '0', `language` varchar(25) NOT NULL default 'English', `style` varchar(25) NOT NULL default 'Oxygen', `num_posts` int(10) unsigned NOT NULL default '0', `last_post` int(10) unsigned default NULL, `registered` int(10) unsigned NOT NULL default '0', `registration_ip` varchar(15) NOT NULL default '0.0.0.0', `last_visit` int(10) unsigned NOT NULL default '0', `admin_note` varchar(30) default NULL, `activate_string` varchar(50) default NULL, `activate_key` varchar(8) default NULL, PRIMARY KEY (`id`), KEY `demo_punbb12_users_registered_idx` (`registered`), KEY `demo_punbb12_users_username_idx` (`username`(8)) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; SET character_set_client = @saved_cs_client; -- -- Dumping data for table `demo_punbb12_users` -- LOCK TABLES `demo_punbb12_users` WRITE; /*!40000 ALTER TABLE `demo_punbb12_users` DISABLE KEYS */; INSERT INTO `demo_punbb12_users` VALUES (1,3,'Guest','Guest','Guest',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,1,1,0,1,1,1,1,1,0,'English','Oxygen',0,NULL,0,'0.0.0.0',0,NULL,NULL,NULL),(2,1,'admin','d033e22ae348aeb5660fc2140aec35850c4da997','anatoly@punbb.org',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,1,1,0,1,1,1,1,1,0,'English','Oxygen',1,1225960609,1225960609,'127.0.0.1',1225961105,NULL,NULL,NULL),(3,2,'moderator','79f52b5b92498b00cb18284f1dcb466bd40ad559','moderator@example.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,1,1,0,1,1,1,1,1,0,'English','Oxygen',0,NULL,1225960985,'91.201.1.254',1225961133,NULL,NULL,NULL),(4,4,'user','12dea96fec20593566ab75692c9949596833adc9','user@example.com',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,1,1,0,1,1,1,1,1,0,'English','Oxygen',0,NULL,1225961064,'91.201.1.254',1225961066,NULL,NULL,NULL); /*!40000 ALTER TABLE `demo_punbb12_users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2008-11-06 8:49:50