-- http://www.phpmyadmin.net
--




--
-- Database: `bpca`
--

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

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL,
  `topic_id` int(10) NOT NULL,
  `comment` text NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`id`, `uid`, `topic_id`, `comment`, `created`) VALUES
(1, 55, 1, 'Samsung', '2012-05-18 15:07:28'),
(2, 56, 1, 'are you sure? :)', '2012-05-18 15:14:34'),
(3, 55, 1, 'yup', '2012-05-18 15:16:02'),
(4, 57, 2, 'reading designer''s blog', '2012-05-21 16:14:52'),
(5, 56, 2, 'hey u thr...???', '2012-06-06 16:22:07'),
(6, 57, 2, 'get lost...!!', '2012-06-06 16:25:40');

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

--
-- Table structure for table `topics`
--

CREATE TABLE IF NOT EXISTS `topics` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `from_id` int(10) NOT NULL,
  `to_id` int(10) NOT NULL,
  `title` varchar(255) NOT NULL,
  `desc` text NOT NULL,
  `status` tinyint(4) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `topics`
--

INSERT INTO `topics` (`id`, `from_id`, `to_id`, `title`, `desc`, `status`, `created`) VALUES
(1, 56, 55, 'Wats next?', '', 5, '2012-05-18 12:51:24'),
(2, 56, 57, 'What are you doing?', '', 5, '2012-05-18 17:19:02');

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `md5_id` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `full_name` tinytext COLLATE latin1_general_ci NOT NULL,
  `user_name` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `user_email` varchar(220) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `user_level` tinyint(4) NOT NULL DEFAULT '1',
  `pwd` varchar(220) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `address` text COLLATE latin1_general_ci NOT NULL,
  `country` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `tel` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `fax` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `website` text COLLATE latin1_general_ci NOT NULL,
  `date` date NOT NULL DEFAULT '0000-00-00',
  `users_ip` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `approved` int(1) NOT NULL DEFAULT '0',
  `activation_code` int(10) NOT NULL DEFAULT '0',
  `banned` int(1) NOT NULL DEFAULT '0',
  `ckey` varchar(220) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `ctime` varchar(220) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  FULLTEXT KEY `idx_search` (`full_name`,`address`,`user_email`,`user_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=61 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `md5_id`, `full_name`, `user_name`, `user_email`, `user_level`, `pwd`, `address`, `country`, `tel`, `fax`, `website`, `date`, `users_ip`, `approved`, `activation_code`, `banned`, `ckey`, `ctime`) VALUES
(54, '', 'admin', 'admin', 'admin@localhost', 10, '4c09e75fa6fe36038ac240e9e4e0126cedef6d8c85cf0a1ae', 'admin', 'Switzerland', '4433093999', '', '', '2010-05-04', '', 1, 0, 0, 'dke7y93', '1339135108'),
(55, 'b53b3a3d6ab90ce0268229151c9bde11', 'Nitish Dhar', 'nitishdhar', 'nitish@pioneeringcreativity.com', 5, 'c518bb5246d08f36d0c6b45d502248e2e67643c9727544588', 'Tiramisu New Media Solutions', 'India', '7676313229', '', '', '2012-05-16', '127.0.0.1', 1, 1063, 0, '', ''),
(56, '9f61408e3afb633e50cdf1b20de6f466', 'Abhinay Kulkarni', 'abhinaynk', 'abhinay@pioneeringcreativity.com', 1, '4b0345268c481a1e68f963bf4d22dfa764c83f8ca34212acd', 'Tiramisu New Media Solutions', 'India', '8904670357', '', '', '2012-05-16', '127.0.0.1', 1, 4555, 0, '', ''),
(57, '72b32a1f754ba1c09b3695e0cb6cde7f', 'Guruji', 'Guruji', 'guruprasad@pioneeringcreativity.com', 5, 'c0c5e6956d312f531f6526865b980f0799c4aca5a298c6ca6', 'Tiramisu New Media Solutions', 'India', '9886584030', '', '', '2012-05-18', '127.0.0.1', 1, 6821, 0, '', ''),
(58, '66f041e16a60928b05a7e228a89c3799', 'Ramesh D', 'rameshd', 'abhinay@pioneeringcreativity.com', 1, 'f4e7c5024f16770b2f23a64391a34088717d206a15125b37e', 'Kengeri Upanagara', 'India', '7676313229', '', '', '2012-05-21', '127.0.0.1', 1, 4093, 0, '', ''),
(59, '093f65e080a295f8076b1c5722a46aa2', 'Suresh M', 'sureshm', 'abhinay@pioneeringcreativity.com', 1, '3583745aef6b6f67eb60372827e96d3852da9625d882874c1', 'BMSECE, Basavanagudi', 'India', '7676313229', '', '', '2012-05-21', '127.0.0.1', 1, 2815, 0, '', ''),
(60, '072b030ba126b2f4b2374f342be9ed44', 'Prashanth Kumar', 'prashanth', 'prashanth@pioneeringcreativity.com', 5, '4f9869ba254e4faed3d39965dab88e82efe14544b458fb6e5', 'Tiramisu New Media Solutions', 'India', '9986033395', '', '', '2012-05-21', '127.0.0.1', 1, 8257, 0, '', '');

