-- http://www.phpmyadmin.net
-- 
-- 
-- Database: `frlhtforum`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_auth_access`
-- 

CREATE TABLE `phpbb_auth_access` (
  `group_id` mediumint(8) NOT NULL default '0',
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `auth_view` tinyint(1) NOT NULL default '0',
  `auth_read` tinyint(1) NOT NULL default '0',
  `auth_post` tinyint(1) NOT NULL default '0',
  `auth_reply` tinyint(1) NOT NULL default '0',
  `auth_edit` tinyint(1) NOT NULL default '0',
  `auth_delete` tinyint(1) NOT NULL default '0',
  `auth_sticky` tinyint(1) NOT NULL default '0',
  `auth_announce` tinyint(1) NOT NULL default '0',
  `auth_vote` tinyint(1) NOT NULL default '0',
  `auth_pollcreate` tinyint(1) NOT NULL default '0',
  `auth_attachments` tinyint(1) NOT NULL default '0',
  `auth_mod` tinyint(1) NOT NULL default '0',
  KEY `group_id` (`group_id`),
  KEY `forum_id` (`forum_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_auth_access`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_banlist`
-- 

CREATE TABLE `phpbb_banlist` (
  `ban_id` mediumint(8) unsigned NOT NULL auto_increment,
  `ban_userid` mediumint(8) NOT NULL default '0',
  `ban_ip` varchar(8) NOT NULL default '',
  `ban_email` varchar(255) default NULL,
  PRIMARY KEY  (`ban_id`),
  KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `phpbb_banlist`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_categories`
-- 

CREATE TABLE `phpbb_categories` (
  `cat_id` mediumint(8) unsigned NOT NULL auto_increment,
  `cat_title` varchar(100) default NULL,
  `cat_order` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `cat_order` (`cat_order`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `phpbb_categories`
-- 

INSERT INTO `phpbb_categories` VALUES (1, 'Test category 1', 10);

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_config`
-- 

CREATE TABLE `phpbb_config` (
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`config_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_config`
-- 

INSERT INTO `phpbb_config` VALUES ('allow_autologin', '1');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_local', '0');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_remote', '0');
INSERT INTO `phpbb_config` VALUES ('allow_avatar_upload', '0');
INSERT INTO `phpbb_config` VALUES ('allow_bbcode', '1');
INSERT INTO `phpbb_config` VALUES ('allow_html', '0');
INSERT INTO `phpbb_config` VALUES ('allow_html_tags', 'b,i,u,pre');
INSERT INTO `phpbb_config` VALUES ('allow_namechange', '0');
INSERT INTO `phpbb_config` VALUES ('allow_sig', '1');
INSERT INTO `phpbb_config` VALUES ('allow_smilies', '1');
INSERT INTO `phpbb_config` VALUES ('allow_theme_create', '0');
INSERT INTO `phpbb_config` VALUES ('avatar_filesize', '6144');
INSERT INTO `phpbb_config` VALUES ('avatar_gallery_path', 'images/avatars/gallery');
INSERT INTO `phpbb_config` VALUES ('avatar_max_height', '80');
INSERT INTO `phpbb_config` VALUES ('avatar_max_width', '80');
INSERT INTO `phpbb_config` VALUES ('avatar_path', 'images/avatars');
INSERT INTO `phpbb_config` VALUES ('board_disable', '0');
INSERT INTO `phpbb_config` VALUES ('board_email', 'gauri.lokesh@frlht.org');
INSERT INTO `phpbb_config` VALUES ('board_email_form', '0');
INSERT INTO `phpbb_config` VALUES ('board_email_sig', 'Thanks, The Management');
INSERT INTO `phpbb_config` VALUES ('board_startdate', '1157698506');
INSERT INTO `phpbb_config` VALUES ('board_timezone', '0');
INSERT INTO `phpbb_config` VALUES ('config_id', '1');
INSERT INTO `phpbb_config` VALUES ('cookie_domain', '');
INSERT INTO `phpbb_config` VALUES ('cookie_name', 'phpbb2mysql');
INSERT INTO `phpbb_config` VALUES ('cookie_path', '/');
INSERT INTO `phpbb_config` VALUES ('cookie_secure', '0');
INSERT INTO `phpbb_config` VALUES ('coppa_fax', '');
INSERT INTO `phpbb_config` VALUES ('coppa_mail', '');
INSERT INTO `phpbb_config` VALUES ('default_dateformat', 'D M d, Y g:i a');
INSERT INTO `phpbb_config` VALUES ('default_lang', 'english');
INSERT INTO `phpbb_config` VALUES ('default_style', '2');
INSERT INTO `phpbb_config` VALUES ('enable_confirm', '1');
INSERT INTO `phpbb_config` VALUES ('flood_interval', '15');
INSERT INTO `phpbb_config` VALUES ('gzip_compress', '0');
INSERT INTO `phpbb_config` VALUES ('hot_threshold', '25');
INSERT INTO `phpbb_config` VALUES ('login_reset_time', '30');
INSERT INTO `phpbb_config` VALUES ('max_autologin_time', '0');
INSERT INTO `phpbb_config` VALUES ('max_inbox_privmsgs', '50');
INSERT INTO `phpbb_config` VALUES ('max_login_attempts', '5');
INSERT INTO `phpbb_config` VALUES ('max_poll_options', '10');
INSERT INTO `phpbb_config` VALUES ('max_savebox_privmsgs', '50');
INSERT INTO `phpbb_config` VALUES ('max_sentbox_privmsgs', '25');
INSERT INTO `phpbb_config` VALUES ('max_sig_chars', '255');
INSERT INTO `phpbb_config` VALUES ('override_user_style', '0');
INSERT INTO `phpbb_config` VALUES ('posts_per_page', '15');
INSERT INTO `phpbb_config` VALUES ('privmsg_disable', '0');
INSERT INTO `phpbb_config` VALUES ('prune_enable', '1');
INSERT INTO `phpbb_config` VALUES ('rand_seed', '89db39380e29ba43f02527429b4f7938');
INSERT INTO `phpbb_config` VALUES ('record_online_date', '1157698657');
INSERT INTO `phpbb_config` VALUES ('record_online_users', '1');
INSERT INTO `phpbb_config` VALUES ('require_activation', '0');
INSERT INTO `phpbb_config` VALUES ('script_path', 'phpBB2/');
INSERT INTO `phpbb_config` VALUES ('search_flood_interval', '15');
INSERT INTO `phpbb_config` VALUES ('search_min_chars', '3');
INSERT INTO `phpbb_config` VALUES ('sendmail_fix', '0');
INSERT INTO `phpbb_config` VALUES ('server_name', 'localhost');
INSERT INTO `phpbb_config` VALUES ('server_port', '80');
INSERT INTO `phpbb_config` VALUES ('session_length', '3600');
INSERT INTO `phpbb_config` VALUES ('sitename', 'envis.frlht.org');
INSERT INTO `phpbb_config` VALUES ('site_desc', 'Environment Information System');
INSERT INTO `phpbb_config` VALUES ('smilies_path', 'images/smiles');
INSERT INTO `phpbb_config` VALUES ('smtp_delivery', '1');
INSERT INTO `phpbb_config` VALUES ('smtp_host', '192.168.0.1');
INSERT INTO `phpbb_config` VALUES ('smtp_password', 'lokpriya');
INSERT INTO `phpbb_config` VALUES ('smtp_username', 'gauri');
INSERT INTO `phpbb_config` VALUES ('topics_per_page', '50');
INSERT INTO `phpbb_config` VALUES ('version', '.0.21');

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_confirm`
-- 

CREATE TABLE `phpbb_confirm` (
  `confirm_id` char(32) NOT NULL default '',
  `session_id` char(32) NOT NULL default '',
  `code` char(6) NOT NULL default '',
  PRIMARY KEY  (`session_id`,`confirm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_confirm`
-- 

INSERT INTO `phpbb_confirm` VALUES ('d3aa4490a124178e8e935db22c7f6d00', '2279f16d0cc4958c43e509719490ffad', 'RJA385');
INSERT INTO `phpbb_confirm` VALUES ('94afb00202dab3a6eb2a718ecb0ee436', 'fbc83b43205dc4111f5e1e0ce368aa81', 'T1HDLM');

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_disallow`
-- 

CREATE TABLE `phpbb_disallow` (
  `disallow_id` mediumint(8) unsigned NOT NULL auto_increment,
  `disallow_username` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`disallow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `phpbb_disallow`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_forum_prune`
-- 

CREATE TABLE `phpbb_forum_prune` (
  `prune_id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `prune_days` smallint(5) unsigned NOT NULL default '0',
  `prune_freq` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`prune_id`),
  KEY `forum_id` (`forum_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `phpbb_forum_prune`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_forums`
-- 

CREATE TABLE `phpbb_forums` (
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `cat_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_name` varchar(150) default NULL,
  `forum_desc` text,
  `forum_status` tinyint(4) NOT NULL default '0',
  `forum_order` mediumint(8) unsigned NOT NULL default '1',
  `forum_posts` mediumint(8) unsigned NOT NULL default '0',
  `forum_topics` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `prune_next` int(11) default NULL,
  `prune_enable` tinyint(1) NOT NULL default '0',
  `auth_view` tinyint(2) NOT NULL default '0',
  `auth_read` tinyint(2) NOT NULL default '0',
  `auth_post` tinyint(2) NOT NULL default '0',
  `auth_reply` tinyint(2) NOT NULL default '0',
  `auth_edit` tinyint(2) NOT NULL default '0',
  `auth_delete` tinyint(2) NOT NULL default '0',
  `auth_sticky` tinyint(2) NOT NULL default '0',
  `auth_announce` tinyint(2) NOT NULL default '0',
  `auth_vote` tinyint(2) NOT NULL default '0',
  `auth_pollcreate` tinyint(2) NOT NULL default '0',
  `auth_attachments` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`forum_id`),
  KEY `forums_order` (`forum_order`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_last_post_id` (`forum_last_post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_forums`
-- 

INSERT INTO `phpbb_forums` VALUES (1, 1, 'Test Forum 1', 'This is just a test forum.', 0, 10, 1, 1, 1, NULL, 0, 0, 0, 1, 1, 1, 1, 3, 3, 1, 1, 3);
INSERT INTO `phpbb_forums` VALUES (2, 1, 'Envis', 'this forum is for any queries and information regarding Environment information system', 0, 20, 10, 2, 11, NULL, 0, 0, 0, 0, 0, 1, 1, 3, 3, 1, 1, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_groups`
-- 

CREATE TABLE `phpbb_groups` (
  `group_id` mediumint(8) NOT NULL auto_increment,
  `group_type` tinyint(4) NOT NULL default '1',
  `group_name` varchar(40) NOT NULL default '',
  `group_description` varchar(255) NOT NULL default '',
  `group_moderator` mediumint(8) NOT NULL default '0',
  `group_single_user` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`group_id`),
  KEY `group_single_user` (`group_single_user`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- 
-- Dumping data for table `phpbb_groups`
-- 

INSERT INTO `phpbb_groups` VALUES (1, 1, 'Anonymous', 'Personal User', 0, 1);
INSERT INTO `phpbb_groups` VALUES (2, 1, 'Admin', 'Personal User', 0, 1);
INSERT INTO `phpbb_groups` VALUES (3, 1, '', 'Personal User', 0, 1);
INSERT INTO `phpbb_groups` VALUES (4, 1, '', 'Personal User', 0, 1);
INSERT INTO `phpbb_groups` VALUES (5, 0, 'EnvisUsers', 'this is a group for people who regularly visit evis and correspond to improve it further..', 3, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_posts`
-- 

CREATE TABLE `phpbb_posts` (
  `post_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `poster_id` mediumint(8) NOT NULL default '0',
  `post_time` int(11) NOT NULL default '0',
  `poster_ip` varchar(8) NOT NULL default '',
  `post_username` varchar(25) default NULL,
  `enable_bbcode` tinyint(1) NOT NULL default '1',
  `enable_html` tinyint(1) NOT NULL default '0',
  `enable_smilies` tinyint(1) NOT NULL default '1',
  `enable_sig` tinyint(1) NOT NULL default '1',
  `post_edit_time` int(11) default NULL,
  `post_edit_count` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`post_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_id` (`topic_id`),
  KEY `poster_id` (`poster_id`),
  KEY `post_time` (`post_time`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

-- 
-- Dumping data for table `phpbb_posts`
-- 

INSERT INTO `phpbb_posts` VALUES (1, 1, 1, 2, 972086460, '7F000001', NULL, 1, 0, 1, 1, NULL, 0);
INSERT INTO `phpbb_posts` VALUES (2, 2, 2, 2, 1158039754, '7f000001', '', 1, 0, 1, 0, NULL, 0);
INSERT INTO `phpbb_posts` VALUES (3, 2, 2, 2, 1158039799, '7f000001', '', 1, 0, 1, 0, NULL, 0);
INSERT INTO `phpbb_posts` VALUES (4, 2, 2, 3, 1158040473, '7f000001', '', 1, 0, 1, 0, NULL, 0);
INSERT INTO `phpbb_posts` VALUES (5, 2, 2, 3, 1158040520, '7f000001', '', 1, 0, 1, 0, NULL, 0);
INSERT INTO `phpbb_posts` VALUES (6, 3, 2, 4, 1158041068, '7f000001', '', 1, 0, 1, 0, NULL, 0);
INSERT INTO `phpbb_posts` VALUES (7, 3, 2, 3, 1158041347, '7f000001', '', 1, 0, 1, 0, NULL, 0);
INSERT INTO `phpbb_posts` VALUES (8, 3, 2, 4, 1158043427, '7f000001', '', 1, 0, 1, 0, NULL, 0);
INSERT INTO `phpbb_posts` VALUES (9, 3, 2, 4, 1158056089, '7f000001', '', 1, 0, 1, 0, NULL, 0);
INSERT INTO `phpbb_posts` VALUES (10, 3, 2, 2, 1158058224, '7f000001', '', 1, 0, 1, 0, NULL, 0);
INSERT INTO `phpbb_posts` VALUES (11, 3, 2, 2, 1158058584, '7f000001', '', 1, 0, 1, 0, NULL, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_posts_text`
-- 

CREATE TABLE `phpbb_posts_text` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `bbcode_uid` varchar(10) NOT NULL default '',
  `post_subject` varchar(60) default NULL,
  `post_text` text,
  PRIMARY KEY  (`post_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_posts_text`
-- 

INSERT INTO `phpbb_posts_text` VALUES (1, '', NULL, 'This is an example post in your phpBB 2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!');
INSERT INTO `phpbb_posts_text` VALUES (2, '1eddc656b3', 'how do you find envis site?', 'pls visit our site: envis.frlht.org.in');
INSERT INTO `phpbb_posts_text` VALUES (3, '38b9e448d7', 'Re: how do you find envis site?', '[quote:38b9e448d7="admin"]pls visit our site: envis.frlht.org.in is very informative. make it a bit more lively[/quote:38b9e448d7]');
INSERT INTO `phpbb_posts_text` VALUES (4, 'beb3dd76a6', '', 'I aw the site and the information avaliable is good enough..\r\nOnly if you could upload some more maps...\r\n\r\n\r\nRegards,\r\nPriya');
INSERT INTO `phpbb_posts_text` VALUES (5, '88b2c3d14f', '', '[quote:88b2c3d14f="priya"]I aw the site and the information avaliable is good enough..\r\nOnly if you could upload some more maps and  images for the common plants too..\r\n\r\n\r\nRegards,\r\nPriya[/quote:88b2c3d14f]');
INSERT INTO `phpbb_posts_text` VALUES (6, '9504d515e6', 'CITES', 'what do you mean by CITES listed species?\r\npls let me know..\r\n\r\nreards,\r\ninfomail');
INSERT INTO `phpbb_posts_text` VALUES (7, '06af1d3e5f', '', 'CITES is a short form for :\r\n[size=18:06af1d3e5f][color=violet:06af1d3e5f]Convention on International Trade in Endangered Species of flora and fauna[/color:06af1d3e5f][/size:06af1d3e5f]');
INSERT INTO `phpbb_posts_text` VALUES (8, 'f8645cc078', '', 'Thanks');
INSERT INTO `phpbb_posts_text` VALUES (9, '904a2a68d9', 'Re: CITES', '[quote:904a2a68d9="infomail"]what do you mean by CITES listed species?\r\npls let me know..\r\n\r\nreards,\r\ninfomail[/quote:904a2a68d9]');
INSERT INTO `phpbb_posts_text` VALUES (10, '8b7315b15f', '', 'CITES');
INSERT INTO `phpbb_posts_text` VALUES (11, 'ebca6f6c0f', 'email', 'email');

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_privmsgs`
-- 

CREATE TABLE `phpbb_privmsgs` (
  `privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,
  `privmsgs_type` tinyint(4) NOT NULL default '0',
  `privmsgs_subject` varchar(255) NOT NULL default '0',
  `privmsgs_from_userid` mediumint(8) NOT NULL default '0',
  `privmsgs_to_userid` mediumint(8) NOT NULL default '0',
  `privmsgs_date` int(11) NOT NULL default '0',
  `privmsgs_ip` varchar(8) NOT NULL default '',
  `privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1',
  `privmsgs_enable_html` tinyint(1) NOT NULL default '0',
  `privmsgs_enable_smilies` tinyint(1) NOT NULL default '1',
  `privmsgs_attach_sig` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`privmsgs_id`),
  KEY `privmsgs_from_userid` (`privmsgs_from_userid`),
  KEY `privmsgs_to_userid` (`privmsgs_to_userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `phpbb_privmsgs`
-- 

INSERT INTO `phpbb_privmsgs` VALUES (1, 0, 'First post from infomail', 4, 4, 1158038815, '7f000001', 1, 0, 1, 0);
INSERT INTO `phpbb_privmsgs` VALUES (2, 2, 'First post from infomail', 4, 4, 1158038815, '7f000001', 1, 0, 1, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_privmsgs_text`
-- 

CREATE TABLE `phpbb_privmsgs_text` (
  `privmsgs_text_id` mediumint(8) unsigned NOT NULL default '0',
  `privmsgs_bbcode_uid` varchar(10) NOT NULL default '0',
  `privmsgs_text` text,
  PRIMARY KEY  (`privmsgs_text_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_privmsgs_text`
-- 

INSERT INTO `phpbb_privmsgs_text` VALUES (1, '212287b380', 'this is test post for the forum..\r\n\r\npls chk who all recieve this mail..\r\n\r\n :lol: \r\n\r\nregards,\r\ninfomail');
INSERT INTO `phpbb_privmsgs_text` VALUES (2, '212287b380', 'this is test post for the forum..\r\n\r\npls chk who all recieve this mail..\r\n\r\n :lol: \r\n\r\nregards,\r\ninfomail');

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_ranks`
-- 

CREATE TABLE `phpbb_ranks` (
  `rank_id` smallint(5) unsigned NOT NULL auto_increment,
  `rank_title` varchar(50) NOT NULL default '',
  `rank_min` mediumint(8) NOT NULL default '0',
  `rank_special` tinyint(1) default '0',
  `rank_image` varchar(255) default NULL,
  PRIMARY KEY  (`rank_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `phpbb_ranks`
-- 

INSERT INTO `phpbb_ranks` VALUES (1, 'Site Admin', -1, 1, NULL);

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_search_results`
-- 

CREATE TABLE `phpbb_search_results` (
  `search_id` int(11) unsigned NOT NULL default '0',
  `session_id` varchar(32) NOT NULL default '',
  `search_time` int(11) NOT NULL default '0',
  `search_array` text NOT NULL,
  PRIMARY KEY  (`search_id`),
  KEY `session_id` (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_search_results`
-- 

INSERT INTO `phpbb_search_results` VALUES (1345553467, '4cff5d07d4aa0e0c3dcd7aa9f6e75191', 1158041113, 'a:7:{s:14:"search_results";s:4:"1, 3";s:17:"total_match_count";i:2;s:12:"split_search";N;s:7:"sort_by";i:0;s:8:"sort_dir";s:4:"DESC";s:12:"show_results";s:6:"topics";s:12:"return_chars";i:200;}');

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_search_wordlist`
-- 

CREATE TABLE `phpbb_search_wordlist` (
  `word_text` varchar(50) character set latin1 collate latin1_bin NOT NULL default '',
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word_common` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`word_text`),
  KEY `word_id` (`word_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;

-- 
-- Dumping data for table `phpbb_search_wordlist`
-- 

INSERT INTO `phpbb_search_wordlist` VALUES (0x6176616c6961626c65, 23, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x6177, 24, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x626974, 19, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x6369746573, 34, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x636f6d6d6f6e, 31, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x636f6e76656e74696f6e, 41, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x64656c657465, 5, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x656d61696c, 50, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x656e64616e6765726564, 42, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x656e6f756768, 25, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x656e766973, 13, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x65766572797468696e67, 9, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x6578616d706c65, 1, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x6661756e61, 43, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x666c6f7261, 44, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x666f726d, 45, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x666f72756d, 7, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x66726c6874, 14, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x696d61676573, 32, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x696e666f6d61696c, 35, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x696e666f726d6174696f6e, 26, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x696e666f726d6174697665, 20, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x696e7374616c6c6174696f6e, 4, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x696e7465726e6174696f6e616c, 46, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x6c6574, 36, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x6c6973746564, 37, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x6c6976656c79, 21, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x6d616b65, 22, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x6d617073, 27, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x6d65616e, 38, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x6f7267, 15, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x7068706262, 3, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x706c616e7473, 33, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x706c73, 16, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x706f7374, 2, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x7072697961, 28, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x726561726473, 39, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x72656761726473, 29, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x7365656d73, 10, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x73686f7274, 47, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x73696e6365, 8, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x73697465, 17, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x73706563696573, 40, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x7468616e6b73, 49, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x746f706963, 6, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x7472616465, 48, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x75706c6f6164, 30, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x7669736974, 18, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x77656c636f6d65, 12, 0);
INSERT INTO `phpbb_search_wordlist` VALUES (0x776f726b696e67, 11, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_search_wordmatch`
-- 

CREATE TABLE `phpbb_search_wordmatch` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `word_id` mediumint(8) unsigned NOT NULL default '0',
  `title_match` tinyint(1) NOT NULL default '0',
  KEY `post_id` (`post_id`),
  KEY `word_id` (`word_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_search_wordmatch`
-- 

INSERT INTO `phpbb_search_wordmatch` VALUES (1, 1, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1, 2, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1, 3, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1, 4, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1, 5, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1, 6, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1, 7, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1, 8, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1, 9, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1, 10, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1, 11, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (1, 12, 1);
INSERT INTO `phpbb_search_wordmatch` VALUES (1, 3, 1);
INSERT INTO `phpbb_search_wordmatch` VALUES (2, 13, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (2, 14, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (2, 15, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (2, 16, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (2, 17, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (2, 18, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (2, 13, 1);
INSERT INTO `phpbb_search_wordmatch` VALUES (2, 17, 1);
INSERT INTO `phpbb_search_wordmatch` VALUES (3, 13, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (3, 14, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (3, 15, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (3, 16, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (3, 17, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (3, 18, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (3, 19, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (3, 20, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (3, 21, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (3, 22, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (3, 13, 1);
INSERT INTO `phpbb_search_wordmatch` VALUES (3, 17, 1);
INSERT INTO `phpbb_search_wordmatch` VALUES (4, 17, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (4, 23, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (4, 24, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (4, 25, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (4, 26, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (4, 27, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (4, 28, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (4, 29, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (4, 30, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (5, 17, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (5, 23, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (5, 24, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (5, 25, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (5, 26, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (5, 27, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (5, 28, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (5, 29, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (5, 30, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (5, 31, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (5, 32, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (5, 33, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (6, 34, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (6, 35, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (6, 36, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (6, 37, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (6, 38, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (6, 16, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (6, 39, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (6, 40, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (6, 34, 1);
INSERT INTO `phpbb_search_wordmatch` VALUES (7, 34, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (7, 41, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (7, 42, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (7, 43, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (7, 44, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (7, 45, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (7, 46, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (7, 47, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (7, 40, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (7, 48, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (8, 49, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (9, 34, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (9, 35, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (9, 36, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (9, 37, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (9, 38, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (9, 16, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (9, 39, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (9, 40, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (9, 34, 1);
INSERT INTO `phpbb_search_wordmatch` VALUES (10, 34, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (11, 50, 0);
INSERT INTO `phpbb_search_wordmatch` VALUES (11, 50, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_sessions`
-- 

CREATE TABLE `phpbb_sessions` (
  `session_id` char(32) NOT NULL default '',
  `session_user_id` mediumint(8) NOT NULL default '0',
  `session_start` int(11) NOT NULL default '0',
  `session_time` int(11) NOT NULL default '0',
  `session_ip` char(8) NOT NULL default '0',
  `session_page` int(11) NOT NULL default '0',
  `session_logged_in` tinyint(1) NOT NULL default '0',
  `session_admin` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`session_id`),
  KEY `session_user_id` (`session_user_id`),
  KEY `session_id_ip_user_id` (`session_id`,`session_ip`,`session_user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_sessions`
-- 

INSERT INTO `phpbb_sessions` VALUES ('4f24423b7e605df77fa9cf36806bdec2', 2, 1158129172, 1158130395, '7f000001', 0, 1, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_sessions_keys`
-- 

CREATE TABLE `phpbb_sessions_keys` (
  `key_id` varchar(32) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `last_ip` varchar(8) NOT NULL default '0',
  `last_login` int(11) NOT NULL default '0',
  PRIMARY KEY  (`key_id`,`user_id`),
  KEY `last_login` (`last_login`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_sessions_keys`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_smilies`
-- 

CREATE TABLE `phpbb_smilies` (
  `smilies_id` smallint(5) unsigned NOT NULL auto_increment,
  `code` varchar(50) default NULL,
  `smile_url` varchar(100) default NULL,
  `emoticon` varchar(75) default NULL,
  PRIMARY KEY  (`smilies_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;

-- 
-- Dumping data for table `phpbb_smilies`
-- 

INSERT INTO `phpbb_smilies` VALUES (1, ':D', 'icon_biggrin.gif', 'Very Happy');
INSERT INTO `phpbb_smilies` VALUES (2, ':-D', 'icon_biggrin.gif', 'Very Happy');
INSERT INTO `phpbb_smilies` VALUES (3, ':grin:', 'icon_biggrin.gif', 'Very Happy');
INSERT INTO `phpbb_smilies` VALUES (4, ':)', 'icon_smile.gif', 'Smile');
INSERT INTO `phpbb_smilies` VALUES (5, ':-)', 'icon_smile.gif', 'Smile');
INSERT INTO `phpbb_smilies` VALUES (6, ':smile:', 'icon_smile.gif', 'Smile');
INSERT INTO `phpbb_smilies` VALUES (7, ':(', 'icon_sad.gif', 'Sad');
INSERT INTO `phpbb_smilies` VALUES (8, ':-(', 'icon_sad.gif', 'Sad');
INSERT INTO `phpbb_smilies` VALUES (9, ':sad:', 'icon_sad.gif', 'Sad');
INSERT INTO `phpbb_smilies` VALUES (10, ':o', 'icon_surprised.gif', 'Surprised');
INSERT INTO `phpbb_smilies` VALUES (11, ':-o', 'icon_surprised.gif', 'Surprised');
INSERT INTO `phpbb_smilies` VALUES (12, ':eek:', 'icon_surprised.gif', 'Surprised');
INSERT INTO `phpbb_smilies` VALUES (13, ':shock:', 'icon_eek.gif', 'Shocked');
INSERT INTO `phpbb_smilies` VALUES (14, ':?', 'icon_confused.gif', 'Confused');
INSERT INTO `phpbb_smilies` VALUES (15, ':-?', 'icon_confused.gif', 'Confused');
INSERT INTO `phpbb_smilies` VALUES (16, ':???:', 'icon_confused.gif', 'Confused');
INSERT INTO `phpbb_smilies` VALUES (17, '8)', 'icon_cool.gif', 'Cool');
INSERT INTO `phpbb_smilies` VALUES (18, '8-)', 'icon_cool.gif', 'Cool');
INSERT INTO `phpbb_smilies` VALUES (19, ':cool:', 'icon_cool.gif', 'Cool');
INSERT INTO `phpbb_smilies` VALUES (20, ':lol:', 'icon_lol.gif', 'Laughing');
INSERT INTO `phpbb_smilies` VALUES (21, ':x', 'icon_mad.gif', 'Mad');
INSERT INTO `phpbb_smilies` VALUES (22, ':-x', 'icon_mad.gif', 'Mad');
INSERT INTO `phpbb_smilies` VALUES (23, ':mad:', 'icon_mad.gif', 'Mad');
INSERT INTO `phpbb_smilies` VALUES (24, ':P', 'icon_razz.gif', 'Razz');
INSERT INTO `phpbb_smilies` VALUES (25, ':-P', 'icon_razz.gif', 'Razz');
INSERT INTO `phpbb_smilies` VALUES (26, ':razz:', 'icon_razz.gif', 'Razz');
INSERT INTO `phpbb_smilies` VALUES (27, ':oops:', 'icon_redface.gif', 'Embarassed');
INSERT INTO `phpbb_smilies` VALUES (28, ':cry:', 'icon_cry.gif', 'Crying or Very sad');
INSERT INTO `phpbb_smilies` VALUES (29, ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
INSERT INTO `phpbb_smilies` VALUES (30, ':twisted:', 'icon_twisted.gif', 'Twisted Evil');
INSERT INTO `phpbb_smilies` VALUES (31, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
INSERT INTO `phpbb_smilies` VALUES (32, ':wink:', 'icon_wink.gif', 'Wink');
INSERT INTO `phpbb_smilies` VALUES (33, ';)', 'icon_wink.gif', 'Wink');
INSERT INTO `phpbb_smilies` VALUES (34, ';-)', 'icon_wink.gif', 'Wink');
INSERT INTO `phpbb_smilies` VALUES (35, ':!:', 'icon_exclaim.gif', 'Exclamation');
INSERT INTO `phpbb_smilies` VALUES (36, ':?:', 'icon_question.gif', 'Question');
INSERT INTO `phpbb_smilies` VALUES (37, ':idea:', 'icon_idea.gif', 'Idea');
INSERT INTO `phpbb_smilies` VALUES (38, ':arrow:', 'icon_arrow.gif', 'Arrow');
INSERT INTO `phpbb_smilies` VALUES (39, ':|', 'icon_neutral.gif', 'Neutral');
INSERT INTO `phpbb_smilies` VALUES (40, ':-|', 'icon_neutral.gif', 'Neutral');
INSERT INTO `phpbb_smilies` VALUES (41, ':neutral:', 'icon_neutral.gif', 'Neutral');
INSERT INTO `phpbb_smilies` VALUES (42, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_themes`
-- 

CREATE TABLE `phpbb_themes` (
  `themes_id` mediumint(8) unsigned NOT NULL auto_increment,
  `template_name` varchar(30) NOT NULL default '',
  `style_name` varchar(30) NOT NULL default '',
  `head_stylesheet` varchar(100) default NULL,
  `body_background` varchar(100) default NULL,
  `body_bgcolor` varchar(6) default NULL,
  `body_text` varchar(6) default NULL,
  `body_link` varchar(6) default NULL,
  `body_vlink` varchar(6) default NULL,
  `body_alink` varchar(6) default NULL,
  `body_hlink` varchar(6) default NULL,
  `tr_color1` varchar(6) default NULL,
  `tr_color2` varchar(6) default NULL,
  `tr_color3` varchar(6) default NULL,
  `tr_class1` varchar(25) default NULL,
  `tr_class2` varchar(25) default NULL,
  `tr_class3` varchar(25) default NULL,
  `th_color1` varchar(6) default NULL,
  `th_color2` varchar(6) default NULL,
  `th_color3` varchar(6) default NULL,
  `th_class1` varchar(25) default NULL,
  `th_class2` varchar(25) default NULL,
  `th_class3` varchar(25) default NULL,
  `td_color1` varchar(6) default NULL,
  `td_color2` varchar(6) default NULL,
  `td_color3` varchar(6) default NULL,
  `td_class1` varchar(25) default NULL,
  `td_class2` varchar(25) default NULL,
  `td_class3` varchar(25) default NULL,
  `fontface1` varchar(50) default NULL,
  `fontface2` varchar(50) default NULL,
  `fontface3` varchar(50) default NULL,
  `fontsize1` tinyint(4) default NULL,
  `fontsize2` tinyint(4) default NULL,
  `fontsize3` tinyint(4) default NULL,
  `fontcolor1` varchar(6) default NULL,
  `fontcolor2` varchar(6) default NULL,
  `fontcolor3` varchar(6) default NULL,
  `span_class1` varchar(25) default NULL,
  `span_class2` varchar(25) default NULL,
  `span_class3` varchar(25) default NULL,
  `img_size_poll` smallint(5) unsigned default NULL,
  `img_size_privmsg` smallint(5) unsigned default NULL,
  PRIMARY KEY  (`themes_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `phpbb_themes`
-- 

INSERT INTO `phpbb_themes` VALUES (1, 'subSilver', 'subSilver', 'subSilver.css', '', 'E5E5E5', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, ''Courier New'', sans-serif', 10, 11, 12, '444444', '006600', 'FFA34F', '', '', '', NULL, NULL);
INSERT INTO `phpbb_themes` VALUES (2, 'subSilver', 'MyTheme', '', '', 'BDD394', '008200', '008200', '008200', '008200', '008200', 'FFFFFF', 'EFF7DE', 'FEFEFE', '', '', '', '008200', '848284', 'EFF7DE', '', '', '', 'FFFFFF', 'EFF7DE', '', '', '', '', 'Georgia', 'Georgia', 'Georgia', 12, 12, 12, '000000', '008200', 'FFA24A', '', '', '', NULL, NULL);
INSERT INTO `phpbb_themes` VALUES (3, 'ca_aphrodite_green', 'Aphrodite Green', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'row1', 'row2', '', '', '', '', 10, 11, 12, '', '455995', 'E61A1A', '', '', '', 0, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_themes_name`
-- 

CREATE TABLE `phpbb_themes_name` (
  `themes_id` smallint(5) unsigned NOT NULL default '0',
  `tr_color1_name` char(50) default NULL,
  `tr_color2_name` char(50) default NULL,
  `tr_color3_name` char(50) default NULL,
  `tr_class1_name` char(50) default NULL,
  `tr_class2_name` char(50) default NULL,
  `tr_class3_name` char(50) default NULL,
  `th_color1_name` char(50) default NULL,
  `th_color2_name` char(50) default NULL,
  `th_color3_name` char(50) default NULL,
  `th_class1_name` char(50) default NULL,
  `th_class2_name` char(50) default NULL,
  `th_class3_name` char(50) default NULL,
  `td_color1_name` char(50) default NULL,
  `td_color2_name` char(50) default NULL,
  `td_color3_name` char(50) default NULL,
  `td_class1_name` char(50) default NULL,
  `td_class2_name` char(50) default NULL,
  `td_class3_name` char(50) default NULL,
  `fontface1_name` char(50) default NULL,
  `fontface2_name` char(50) default NULL,
  `fontface3_name` char(50) default NULL,
  `fontsize1_name` char(50) default NULL,
  `fontsize2_name` char(50) default NULL,
  `fontsize3_name` char(50) default NULL,
  `fontcolor1_name` char(50) default NULL,
  `fontcolor2_name` char(50) default NULL,
  `fontcolor3_name` char(50) default NULL,
  `span_class1_name` char(50) default NULL,
  `span_class2_name` char(50) default NULL,
  `span_class3_name` char(50) default NULL,
  PRIMARY KEY  (`themes_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_themes_name`
-- 

INSERT INTO `phpbb_themes_name` VALUES (1, 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', '');
INSERT INTO `phpbb_themes_name` VALUES (2, 'WHITE', 'LIGHT GREEN', 'LIGHT GRAY', '', '', '', 'DARK GREEN', 'DARK GRAY', 'LIGHT GREEN', '', '', '', 'WHITE', 'LIGHT GREEN', '', '', '', '', '', '', '', '', '', '', 'BLACK', 'DARK GREEN', 'ORANGE', '', '', '');

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_topics`
-- 

CREATE TABLE `phpbb_topics` (
  `topic_id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_id` smallint(8) unsigned NOT NULL default '0',
  `topic_title` char(60) NOT NULL default '',
  `topic_poster` mediumint(8) NOT NULL default '0',
  `topic_time` int(11) NOT NULL default '0',
  `topic_views` mediumint(8) unsigned NOT NULL default '0',
  `topic_replies` mediumint(8) unsigned NOT NULL default '0',
  `topic_status` tinyint(3) NOT NULL default '0',
  `topic_vote` tinyint(1) NOT NULL default '0',
  `topic_type` tinyint(3) NOT NULL default '0',
  `topic_first_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_moved_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_moved_id` (`topic_moved_id`),
  KEY `topic_status` (`topic_status`),
  KEY `topic_type` (`topic_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `phpbb_topics`
-- 

INSERT INTO `phpbb_topics` VALUES (1, 1, 'Welcome to phpBB 2', 2, 972086460, 5, 0, 0, 0, 0, 1, 1, 0);
INSERT INTO `phpbb_topics` VALUES (2, 2, 'how do you find envis site?', 2, 1158039754, 8, 3, 0, 0, 0, 2, 5, 0);
INSERT INTO `phpbb_topics` VALUES (3, 2, 'CITES', 4, 1158041068, 18, 5, 0, 0, 0, 6, 11, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_topics_watch`
-- 

CREATE TABLE `phpbb_topics_watch` (
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `notify_status` tinyint(1) NOT NULL default '0',
  KEY `topic_id` (`topic_id`),
  KEY `user_id` (`user_id`),
  KEY `notify_status` (`notify_status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_topics_watch`
-- 

INSERT INTO `phpbb_topics_watch` VALUES (2, 3, 0);
INSERT INTO `phpbb_topics_watch` VALUES (3, 4, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_user_group`
-- 

CREATE TABLE `phpbb_user_group` (
  `group_id` mediumint(8) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `user_pending` tinyint(1) default NULL,
  KEY `group_id` (`group_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_user_group`
-- 

INSERT INTO `phpbb_user_group` VALUES (1, -1, 0);
INSERT INTO `phpbb_user_group` VALUES (2, 2, 0);
INSERT INTO `phpbb_user_group` VALUES (3, 3, 0);
INSERT INTO `phpbb_user_group` VALUES (4, 4, 0);
INSERT INTO `phpbb_user_group` VALUES (5, 3, 0);
INSERT INTO `phpbb_user_group` VALUES (5, 4, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_users`
-- 

CREATE TABLE `phpbb_users` (
  `user_id` mediumint(8) NOT NULL default '0',
  `user_active` tinyint(1) default '1',
  `username` varchar(25) NOT NULL default '',
  `user_password` varchar(32) NOT NULL default '',
  `user_session_time` int(11) NOT NULL default '0',
  `user_session_page` smallint(5) NOT NULL default '0',
  `user_lastvisit` int(11) NOT NULL default '0',
  `user_regdate` int(11) NOT NULL default '0',
  `user_level` tinyint(4) default '0',
  `user_posts` mediumint(8) unsigned NOT NULL default '0',
  `user_timezone` decimal(5,2) NOT NULL default '0.00',
  `user_style` tinyint(4) default NULL,
  `user_lang` varchar(255) default NULL,
  `user_dateformat` varchar(14) NOT NULL default 'd M Y H:i',
  `user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_last_privmsg` int(11) NOT NULL default '0',
  `user_login_tries` smallint(5) unsigned NOT NULL default '0',
  `user_last_login_try` int(11) NOT NULL default '0',
  `user_emailtime` int(11) default NULL,
  `user_viewemail` tinyint(1) default NULL,
  `user_attachsig` tinyint(1) default NULL,
  `user_allowhtml` tinyint(1) default '1',
  `user_allowbbcode` tinyint(1) default '1',
  `user_allowsmile` tinyint(1) default '1',
  `user_allowavatar` tinyint(1) NOT NULL default '1',
  `user_allow_pm` tinyint(1) NOT NULL default '1',
  `user_allow_viewonline` tinyint(1) NOT NULL default '1',
  `user_notify` tinyint(1) NOT NULL default '1',
  `user_notify_pm` tinyint(1) NOT NULL default '0',
  `user_popup_pm` tinyint(1) NOT NULL default '0',
  `user_rank` int(11) default '0',
  `user_avatar` varchar(100) default NULL,
  `user_avatar_type` tinyint(4) NOT NULL default '0',
  `user_email` varchar(255) default NULL,
  `user_icq` varchar(15) default NULL,
  `user_website` varchar(100) default NULL,
  `user_from` varchar(100) default NULL,
  `user_sig` text,
  `user_sig_bbcode_uid` varchar(10) default NULL,
  `user_aim` varchar(255) default NULL,
  `user_yim` varchar(255) default NULL,
  `user_msnm` varchar(255) default NULL,
  `user_occ` varchar(100) default NULL,
  `user_interests` varchar(255) default NULL,
  `user_actkey` varchar(32) default NULL,
  `user_newpasswd` varchar(32) default NULL,
  PRIMARY KEY  (`user_id`),
  KEY `user_session_time` (`user_session_time`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_users`
-- 

INSERT INTO `phpbb_users` VALUES (-1, 0, 'Anonymous', '', 0, 0, 0, 1157698506, 0, 0, 0.00, NULL, '', '', 0, 0, 0, 0, 0, NULL, 0, 0, 1, 1, 1, 1, 0, 1, 0, 1, 0, NULL, '', 0, '', '', '', '', '', NULL, '', '', '', '', '', '', '');
INSERT INTO `phpbb_users` VALUES (2, 1, 'admin', '15eed4d30e4e0fa9dd36f96237b1024c', 1158130395, 0, 1158129103, 1157698506, 1, 5, 0.00, 2, 'english', 'd M Y h:i a', 0, 0, 1158125380, 0, 0, NULL, 1, 0, 0, 1, 1, 1, 1, 1, 0, 1, 1, 1, '', 0, 'gauri.lokesh@frlht.org', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `phpbb_users` VALUES (3, 1, 'priya', '0b1c8bc395a9588a79cd3c191c22a6b4', 1158129143, 0, 1158123293, 1157698935, 0, 3, 0.00, 3, 'english', 'D M d, Y g:i a', 0, 0, 1158041132, 0, 0, NULL, 0, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, '', 0, 'itspriyajoshi@gmail.com', '', '', '', '', '', '', '', '', '', '', 'a547130f19eeadc022f', '1ba9dc75e96cee709a7c0f7ed6b6c4fd');
INSERT INTO `phpbb_users` VALUES (4, 1, 'infomail', '58c0ff970d1599ba83cecf380f0f1f4e', 1158129155, 0, 1158128823, 1157699542, 0, 3, 0.00, 2, 'english', 'D M d, Y g:i a', 0, 0, 1158040905, 0, 0, NULL, 0, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, '', 0, 'infomail@frlht.org', '', '', '', '', '', '', '', '', '', '', '', NULL);

-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_vote_desc`
-- 

CREATE TABLE `phpbb_vote_desc` (
  `vote_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_text` text NOT NULL,
  `vote_start` int(11) NOT NULL default '0',
  `vote_length` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vote_id`),
  KEY `topic_id` (`topic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `phpbb_vote_desc`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_vote_results`
-- 

CREATE TABLE `phpbb_vote_results` (
  `vote_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_option_id` tinyint(4) unsigned NOT NULL default '0',
  `vote_option_text` varchar(255) NOT NULL default '',
  `vote_result` int(11) NOT NULL default '0',
  KEY `vote_option_id` (`vote_option_id`),
  KEY `vote_id` (`vote_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_vote_results`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_vote_voters`
-- 

CREATE TABLE `phpbb_vote_voters` (
  `vote_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_user_id` mediumint(8) NOT NULL default '0',
  `vote_user_ip` char(8) NOT NULL default '',
  KEY `vote_id` (`vote_id`),
  KEY `vote_user_id` (`vote_user_id`),
  KEY `vote_user_ip` (`vote_user_ip`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `phpbb_vote_voters`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `phpbb_words`
-- 

CREATE TABLE `phpbb_words` (
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word` char(100) NOT NULL default '',
  `replacement` char(100) NOT NULL default '',
  PRIMARY KEY  (`word_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `phpbb_words`
-- 

