CREATE TABLE `chat` (
  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `from` VARCHAR(255) NOT NULL DEFAULT '',
  `to` VARCHAR(255) NOT NULL DEFAULT '',
  `message` TEXT NOT NULL,
  `sent` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `recd` INTEGER UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
 INDEX `to` (`to`),
 INDEX `from` (`from`)
)
ENGINE = InnoDB;




CREATE TABLE IF NOT EXISTS `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_name` varchar(64) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;


INSERT INTO `roles` (`id`, `role_name`) VALUES
(1, 'buyer'),
(2, 'programmer');




CREATE TABLE IF NOT EXISTS `sessions` (
  `session_id` varchar(40) NOT NULL DEFAULT '0',
  `ip_address` varchar(16) NOT NULL DEFAULT '0',
  `user_agent` varchar(50) NOT NULL,
  `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
  `user_data` text NOT NULL,
  PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;





CREATE TABLE IF NOT EXISTS `user_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `creator_id` varchar(256) NOT NULL,
  `user_id` varchar(256) NOT NULL,
  `user_name` varchar(256) NOT NULL,
  `user_role` varchar(256) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;





INSERT INTO `user_list` (`id`, `creator_id`, `user_id`, `user_name`, `user_role`) VALUES
(9, '50', '48', 'Sumith', '1'),
(10, '48', '50', 'aaaaaa', '1'),
(11, '54', '62', 'braveheart', '1'),
(12, '50', '55', 'smith', '1'),
(13, '50', '62', 'braveheart', '1'),
(14, '62', '54', 'enabu2', '1');





CREATE TABLE IF NOT EXISTS `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_name` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
  `name` varchar(128) CHARACTER SET utf8 NOT NULL,
  `role_id` smallint(6) NOT NULL,
  `sp_skills` text,
  `password` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
  `email` varchar(128) CHARACTER SET utf8 NOT NULL,
  `profile_desc` text CHARACTER SET utf8,
  `user_status` tinyint(4) NOT NULL DEFAULT '0',
  `activation_key` varchar(32) CHARACTER SET utf8 NOT NULL,
  `country_symbol` char(2) CHARACTER SET utf8 NOT NULL,
  `address` text,
  `state` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  `country` varchar(64) DEFAULT NULL,
  `city` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  `zip_code` int(8) DEFAULT NULL,
  `telephone` int(15) DEFAULT NULL,
  `fax` int(15) DEFAULT NULL,
  `timezone` varchar(20) DEFAULT NULL,
  `project_notify` char(10) CHARACTER SET utf8 DEFAULT NULL,
  `bid_notify` char(10) CHARACTER SET utf8 DEFAULT NULL,
  `message_notify` char(10) CHARACTER SET utf8 NOT NULL,
  `rate` smallint(6) DEFAULT NULL,
  `logo` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
  `created` int(11) NOT NULL,
  `last_activity` int(11) NOT NULL,
  `user_rating` smallint(2) NOT NULL,
  `num_reviews` int(11) NOT NULL,
  `rating_hold` int(11) NOT NULL,
  `tot_rating` int(11) NOT NULL,
  `suspend_status` enum('0','1') NOT NULL DEFAULT '0',
  `ban_status` enum('0','1') NOT NULL DEFAULT '0',
  `online_status` enum('0','1') NOT NULL DEFAULT '0',
  `password_normal` varchar(30) DEFAULT NULL,
  `lock_status` enum('0','1') NOT NULL DEFAULT '0',
  `news_announce` tinyint(2) NOT NULL DEFAULT '0',
  `verify_by_phone` int(11) NOT NULL,
  `verify_billing_address` int(11) NOT NULL,
  `verify_key` int(10) NOT NULL,
  `company_name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=75 ;




INSERT INTO `users` (`id`, `user_name`, `name`, `role_id`, `sp_skills`, `password`, `email`, `profile_desc`, `user_status`, `activation_key`, `country_symbol`, `address`, `state`, `country`, `city`, `zip_code`, `telephone`, `fax`, `timezone`, `project_notify`, `bid_notify`, `message_notify`, `rate`, `logo`, `created`, `last_activity`, `user_rating`, `num_reviews`, `rating_hold`, `tot_rating`, `suspend_status`, `ban_status`, `online_status`, `password_normal`, `lock_status`, `news_announce`, `verify_by_phone`, `verify_billing_address`, `verify_key`, `company_name`) VALUES
(48, 'Sumith', 'Sumith Harshan', 1, '', '96e79218965eb72c92a549dd5a330112', 'sumith.harshan@gmail.com', 'im qui blandit praesent luptatum zzril delenit augue duis dolore te feugait nulla facilisi. Nam liber tempor cum soluta nobis eleifend option congue nihil imperdiet doming id.\n\nquod mazim placerat facer possim assum. Typi non habent claritatem insitam; est usus legentis in iis qui facit eorum claritatem. Investigationes demonstraverunt lectores legere me lius quod ii legunt saepius. Claritas est etiam .\n\nprocessus dynamicus, qui sequitur mutationem consuetudium lectorum. Mirum est notare quam littera gothica, quam nunc putamus parum claram, \nanteposuerit litterarum formas humanitatis per seacula quarta decima et quinta decima. Eodem modo typi, \n\nqui nunc nobis videntur parum clari, fiant sollemnes in futurum.', 1, '63f64504beaaa2795219f526d4b27e3b', 'LK', 'Colombo, Sri Lanka', 'Colombo', '', 'Colombo', 0, 2147483647, 0, '6.0', '', NULL, '', NULL, '67b1726baf7dfe1a47ae41b34f61cb71.png', 1333565472, 1341244331, 10, 2, 0, 20, '0', '0', '1', '111111', '0', 1, 1, 1, 24578, 'CodeArtis (Pvt) Ltd'),
(55, 'smith', 'Harshan ', 2, '', '07e867e0d668e72ea127dcab242b797c', 'smithmail2@gmail.com', '', 1, 'c9e54d62e074301a724699eb00472f6a', 'AR', 'Arizona\nbjklr io er', '11111', 'Argentina', 'areawesang', 0, 1111111, 111111, '5.0', '', NULL, '', 0, NULL, 1335645702, 1341518883, 0, 0, 0, 0, '0', '0', '1', 'sumith111', '0', 0, 0, 0, 0, ''),
(57, 'Suneth', 'Kalhara ', 1, '', '2f172558e8a843eda90faad98020c24c', 'suneth2@gmail.com', '', 1, '1b79618e76f91248e4299c08750f26d6', 'LK', '40,Yakkala', 'Yakkala', 'Sri Lanka', 'Gampaha', 0, 942528854, 0, '6.0', '', '', '', NULL, NULL, 1336121043, 1341499424, 0, 0, 0, 0, '0', '0', '1', '41439508', '0', 0, 0, 0, 0, ''),
(74, 'mohan', 'aaaa aaaa', 2, 'sds', '827ccb0eea8a706c4c34a16891f84e7b', 'wcwm00@gmail.com', 'sdsd', 1, '1da0cf50be88c03654c80078795b237d', 'AO', 'aaaa aaa aaaa', 'assdsds', 'Angola', 'aaaaa', 2323, 323232, 3232323, '-4.0', '', NULL, '', 15, NULL, 1336730182, 0, 0, 0, 0, 0, '0', '0', '0', '12345', '0', 1, 0, 0, 0, ''),
(62, 'braveheart', 'jane mary', 1, '', '3a4869816c66f4d69d641b43c829d5b8', 'nicefella31@hotmail.com', '\nSEO is an acronym for "search engine optimization" or "search engine optimizer." Deciding to hire an SEO is a big decision that can potentially improve your site and save time, but you can also risk damage to your site and reputation. Make sure to research the potential advantages as well as the damage that an irresponsible SEO can do to your site. Many SEOs and other agencies and consultants provide useful services for website owners, including:\n\nReview of your site content or structure\nTechnical advice on website development: for example, hosting, redirects, error pages, use of JavaScript\nContent development\nManagement of online business development campaigns\nKeyword research\nSEO training\nExpertise in specific markets and geographies.\nKeep in mind that the Google search results page includes organic search results and often paid advertisement (denoted by the heading "Sponsored Links") as well. Advertising with Google won''t have any effect on your site''s presence in our search results. Google never accepts money to include or rank sites in our search results, and it costs nothing to appear in our organic search results. Free resources such as Webmaster Tools, the official Webmaster Central blog, and our discussion forum can provide you with a great deal of information about how to optimize your site for organic search.\n\nBefore beginning your search for an SEO, it''s a great idea to become an educated consumer and get familiar with how search engines work. We recommend starting here:', 1, '22f92438e3630b9270e0d48b13b98269', 'BB', '67  ring road', 'edo state', '', 'benin city', 0, 2147483647, 0, '-11.0', '', NULL, '', NULL, NULL, 1336453775, 1341239003, 0, 0, 0, 0, '0', '0', '1', '9055540078', '0', 0, 0, 0, 0, ''),
(66, 'enabu', 'Jane Mary', 2, 'Computer security', 'd41d8cd98f00b204e9800998ecf8427e', 'nicefella31@yahoo.com', '', 1, '6d348f90e14f005f7ea5a9ec71b079e5', 'BH', '67 crawford', 'Edo state', 'Bahrain', 'Benin city', 0, 2147483647, 0, '', 'Instantly', NULL, 'Instantly', 0, NULL, 1336517984, 1338421799, 0, 0, 0, 0, '0', '0', '0', '9055540078', '0', 0, 0, 0, 0, '');