-- phpMyAdmin SQL Dump -- version 2.9.1.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Apr 30, 2008 at 06:18 AM -- Server version: 5.0.27 -- PHP Version: 5.2.0 -- -- Database: `bharat` -- -- -------------------------------------------------------- -- -- Table structure for table `mail_status` -- CREATE TABLE `mail_status` ( `id` int(11) NOT NULL auto_increment, `email` varchar(255) collate latin1_general_ci NOT NULL, `mail_status` int(11) NOT NULL, `sent_date` date NOT NULL, `newsletter_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=44 ; -- -- Dumping data for table `mail_status` -- INSERT INTO `mail_status` VALUES (1, 'cpmadhu.menon@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (2, 'madhusudanan.menon@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (3, 'madhu@affordablewebsolutions.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (4, 'sarita.purohit@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (5, 'sarita_pt1123@rediffmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (6, 'sarita.purohit@indiatimes.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (7, 'sarita_pt1@yahoo.co.in', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (8, 'sarita@affordable-web-solutions.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (9, 'krsujesh@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (10, 'krsujesh@rediffmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (11, 'krsujesh_2005@yahoo.co.in', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (12, 'zujesh@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (13, 'jerly81@rediffmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (14, 'krsujesh@zapak.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (15, 'kumarvd@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (16, 'pradeepkumarvd@yahoo.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (17, 'dimple@affordable-web-solutions.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (18, 'angelpickles2002@yahoo.co.in', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (19, 'vinooti@rediffmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (20, 'biswanath_padhy@yahoo.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (21, 'bulu.padhy@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (22, 'biswanath_padhy@rediffmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (23, 'biswanath_mca@yahoo.co.in', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (24, 'biswanath_padhy@zapak.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (25, 'biswanath_padhy@aol.in', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (26, 'biswanath@affordablewebsolutions.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (27, 'biswanath_padhy@indiatimes.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (28, 'anishthettayil@yahoo.co.in', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (29, 'ansihthetayil@rediff.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (30, 'anish.pol@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (31, 'anish.plz@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (32, 'godsownpet@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (33, 'godsownnaughtyboy@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (34, 'godsownbadboy@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (35, 'induani@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (36, 'mailtoanishpaul@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (37, 'timesofanish@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (38, 'myfriendanish@gmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (39, 'anishpaul@lycos.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (40, 'anishforyou@zapak.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (41, 'anishtimes@zapak.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (42, 'sujesh_ravindran@rediffmail.com', 1, '2008-04-09', 1); INSERT INTO `mail_status` VALUES (43, 'vinooti@gmail.com', 1, '2008-04-09', 1); -- -------------------------------------------------------- -- -- Table structure for table `newsletters` -- CREATE TABLE `newsletters` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) collate latin1_general_ci NOT NULL default '', `htmlcontent` text collate latin1_general_ci NOT NULL, `textcontent` text collate latin1_general_ci NOT NULL, `img` varchar(255) collate latin1_general_ci NOT NULL default 'nophoto.jpg', `dateadded` datetime NOT NULL default '0000-00-00 00:00:00', `datesent` datetime NOT NULL default '0000-00-00 00:00:00', `status` enum('Y','N') collate latin1_general_ci default 'N', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `newsletters` -- INSERT INTO `newsletters` VALUES (1, 'Testing', '

Testing the Newsletter

', '', '1.jpg', '2008-03-20 10:33:03', '0000-00-00 00:00:00', 'Y'); -- -------------------------------------------------------- -- -- Table structure for table `reportfiles` -- CREATE TABLE `reportfiles` ( `id` int(11) NOT NULL auto_increment, `dateadded` date NOT NULL, `full_report_name` varchar(255) collate latin1_general_ci NOT NULL, `delivered_report_name` varchar(255) collate latin1_general_ci NOT NULL, `undelivered_report_name` varchar(255) collate latin1_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ; -- -- Dumping data for table `reportfiles` -- -- -------------------------------------------------------- -- -- Table structure for table `test_users` -- CREATE TABLE `test_users` ( `id` int(11) NOT NULL auto_increment, `email` varchar(255) collate latin1_general_ci NOT NULL, `newsletter` enum('Y','N') collate latin1_general_ci NOT NULL default 'N', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=44 ; -- -- Dumping data for table `test_users` -- INSERT INTO `test_users` VALUES (1, 'cpmadhu.menon@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (2, 'madhusudanan.menon@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (3, 'madhu@affordablewebsolutions.com', 'Y'); INSERT INTO `test_users` VALUES (4, 'sarita.purohit@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (5, 'sarita_pt1123@rediffmail.com', 'Y'); INSERT INTO `test_users` VALUES (6, 'sarita.purohit@indiatimes.com', 'Y'); INSERT INTO `test_users` VALUES (7, 'sarita_pt1@yahoo.co.in', 'Y'); INSERT INTO `test_users` VALUES (8, 'sarita@affordable-web-solutions.com', 'Y'); INSERT INTO `test_users` VALUES (9, 'krsujesh@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (10, 'krsujesh@rediffmail.com', 'Y'); INSERT INTO `test_users` VALUES (11, 'krsujesh_2005@yahoo.co.in', 'Y'); INSERT INTO `test_users` VALUES (12, 'zujesh@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (13, 'jerly81@rediffmail.com', 'Y'); INSERT INTO `test_users` VALUES (14, 'krsujesh@zapak.com', 'Y'); INSERT INTO `test_users` VALUES (15, 'kumarvd@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (16, 'pradeepkumarvd@yahoo.com', 'Y'); INSERT INTO `test_users` VALUES (17, 'dimple@affordable-web-solutions.com', 'Y'); INSERT INTO `test_users` VALUES (18, 'angelpickles2002@yahoo.co.in', 'Y'); INSERT INTO `test_users` VALUES (19, 'vinooti@rediffmail.com', 'Y'); INSERT INTO `test_users` VALUES (20, 'biswanath_padhy@yahoo.com', 'Y'); INSERT INTO `test_users` VALUES (21, 'bulu.padhy@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (22, 'biswanath_padhy@rediffmail.com', 'Y'); INSERT INTO `test_users` VALUES (23, 'biswanath_mca@yahoo.co.in', 'Y'); INSERT INTO `test_users` VALUES (24, 'biswanath_padhy@zapak.com', 'Y'); INSERT INTO `test_users` VALUES (25, 'biswanath_padhy@aol.in', 'Y'); INSERT INTO `test_users` VALUES (26, 'biswanath@affordablewebsolutions.com', 'Y'); INSERT INTO `test_users` VALUES (27, 'biswanath_padhy@indiatimes.com', 'Y'); INSERT INTO `test_users` VALUES (28, 'anishthettayil@yahoo.co.in', 'Y'); INSERT INTO `test_users` VALUES (29, 'ansihthetayil@rediff.com', 'Y'); INSERT INTO `test_users` VALUES (30, 'anish.pol@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (31, 'anish.plz@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (32, 'godsownpet@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (33, 'godsownnaughtyboy@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (34, 'godsownbadboy@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (35, 'induani@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (36, 'mailtoanishpaul@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (37, 'timesofanish@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (38, 'myfriendanish@gmail.com', 'Y'); INSERT INTO `test_users` VALUES (39, 'anishpaul@lycos.com', 'Y'); INSERT INTO `test_users` VALUES (40, 'anishforyou@zapak.com', 'Y'); INSERT INTO `test_users` VALUES (41, 'anishtimes@zapak.com', 'Y'); INSERT INTO `test_users` VALUES (42, 'sujesh_ravindran@rediffmail.com', 'Y'); INSERT INTO `test_users` VALUES (43, 'vinooti@gmail.com', 'Y'); -- -------------------------------------------------------- -- -- Table structure for table `unregistered_users` -- CREATE TABLE `unregistered_users` ( `id` int(11) NOT NULL auto_increment, `email` varchar(255) collate latin1_general_ci NOT NULL, `newsletter` enum('Y','N') collate latin1_general_ci NOT NULL default 'N', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ; -- -- Dumping data for table `unregistered_users` -- -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL auto_increment, `user_type_id` int(11) NOT NULL, `username` varchar(15) collate latin1_general_ci NOT NULL, `password` varchar(15) collate latin1_general_ci NOT NULL, `name` varchar(255) collate latin1_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `users` -- INSERT INTO `users` VALUES (1, 1, 'admin', 'admin', 'Administrator');