-- phpMyAdmin SQL Dump
-- version 2.8.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Mar 26, 2009 at 05:18 AM
-- Server version: 5.0.18
-- PHP Version: 5.0.5
--
-- Database: `naderco_newsletter`
--
-- --------------------------------------------------------
--
-- Table structure for table `mail_setup`
--
CREATE TABLE `mail_setup` (
`mail_id` int(11) NOT NULL auto_increment,
`admin_email` varchar(100) NOT NULL,
`title` varchar(500) NOT NULL,
`date` varchar(50) NOT NULL,
PRIMARY KEY (`mail_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `mail_setup`
--
INSERT INTO `mail_setup` (`mail_id`, `admin_email`, `title`, `date`) VALUES (1, 'dipak@naderco.com.au', '', '2009-03-24'),
(2, 'dipak@msn.com', 'Web design', '2009-03-24'),
(3, 'info@naderco.com.au', '', '2009-03-25'),
(4, 'dipfor@gmail.com', 'Dipak', '2009-03-25');
-- --------------------------------------------------------
--
-- Table structure for table `message`
--
CREATE TABLE `message` (
`msg_id` int(11) NOT NULL auto_increment,
`title` varchar(500) NOT NULL,
`description` text NOT NULL,
`status` int(11) NOT NULL,
`date` varchar(50) NOT NULL,
PRIMARY KEY (`msg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;
--
-- Dumping data for table `message`
--
INSERT INTO `message` (`msg_id`, `title`, `description`, `status`, `date`) VALUES (1, ' dipak@msn.com', 'aaaaaaaaaaaaaaaaaaa', 0, '2009-03-24'),
(2, ' dipak@msn.com', 'aaaaaaaaaaaaaaaaaaa', 0, '2009-03-24'),
(3, ' dipak@msn.com', '[b]bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb[/b]', 0, '2009-03-24'),
(4, ' dipak@msn.com', '[b]bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb[/b]', 0, '2009-03-24'),
(5, ' dipak@msn.com', '[b]bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb[/b]', 0, '2009-03-24'),
(6, ' dipak@msn.com', '[b]bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb[/b]', 0, '2009-03-24'),
(7, ' dipak@msn.com', '[b]bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb[/b]', 1, '2009-03-24'),
(8, ' dipak@msn.com', 'oihhh', 0, '2009-03-25'),
(9, ' dipak@msn.com', 'oihhh', 0, '2009-03-25'),
(10, ' dipak@msn.com', 'oihhh
test
', 0, '2009-03-25'),
(11, ' dipak@msn.com', 'oihhh
test
', 0, '2009-03-25'),
(12, ' dipak@msn.com', '[b]This is test[/b] [img]http://sydneywebsites.com.au/naderco_email/admin/images/smiley-sealed.gif[/img] sdfsdfgdgdfgfth
', 0, '2009-03-25'),
(13, ' dipak@msn.com', '[b]This is test[/b] [img]http://sydneywebsites.com.au/naderco_email/admin/images/smiley-sealed.gif[/img] sdfsdfgdgdfgfth
', 0, '2009-03-25'),
(14, ' dipak@msn.com', '[img]http://sydneywebsites.com.au/naderco_email/admin/images/smiley-tongue-out.gif[/img] This is testing
', 0, '2009-03-25'),
(15, ' dipak@msn.com', '[b]This is testing[/b]
', 0, '2009-03-25'),
(16, ' dipak@msn.com', '[b]This is testing[/b]
', 0, '2009-03-25'),
(17, ' Web design', '', 0, '2009-03-25'),
(18, 'Test', '
Test
', 0, '2009-03-25'),
(19, 'Test', ' Test
', 0, '2009-03-25'),
(20, 'Test', ' Test
', 0, '2009-03-25'),
(21, 'Test', '
Testing
', 0, '2009-03-26'),
(22, 'Business card offer', '100 Free Business card for every website
', 0, '2009-03-26'),
(23, 'Business card offer', '100 Free Business card for every website
', 0, '2009-03-26'),
(24, 'Testing', 'Testing
', 0, '2009-03-26'),
(25, 'Testing', 'Testing
', 0, '2009-03-26'),
(26, 'Testing', '\n\n\n\nForm Engine\n\n\nTesting
Testing
Web design\n\n', 0, '2009-03-26'),
(27, 'Testing', '\n\n\n\nForm Engine\n\n\nTesting
Testing
Web design\n\n', 0, '2009-03-26');
-- --------------------------------------------------------
--
-- Table structure for table `subs`
--
CREATE TABLE `subs` (
`id` int(11) NOT NULL auto_increment,
`g_id` int(11) NOT NULL,
`email` varchar(150) NOT NULL,
`status` int(11) NOT NULL default '1',
`date` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `subs`
--
INSERT INTO `subs` (`id`, `g_id`, `email`, `status`, `date`) VALUES (1, 2, 'dipak@naderco.com.au', 1, '24-03-2009'),
(7, 2, 'dipak@msn.com', 0, '2009-03-24'),
(8, 3, 'info@walkmedia.com.au', 0, '2009-03-24'),
(9, 3, 'info@naderco.com.au', 0, '2009-03-25');
-- --------------------------------------------------------
--
-- Table structure for table `subs_groups`
--
CREATE TABLE `subs_groups` (
`id` int(11) NOT NULL auto_increment,
`gname` varchar(500) NOT NULL,
`gdes` text NOT NULL,
`date` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `subs_groups`
--
INSERT INTO `subs_groups` (`id`, `gname`, `gdes`, `date`) VALUES (4, 'scooter', 'scooter', '2009-03-24'),
(2, 'Scooter Promotion', 'For Scooter Promotion', ''),
(3, 'tradesmen', 'tradesmen directory group', '2009-03-24'),
(5, 'test', '', '2009-03-25');
-- --------------------------------------------------------
--
-- Table structure for table `user`
--
CREATE TABLE `user` (
`userid` int(11) NOT NULL auto_increment,
`email` varchar(150) NOT NULL,
`user` varchar(100) NOT NULL default '',
`password` varchar(100) default NULL,
`date` varchar(50) NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `user`
--
INSERT INTO `user` (`userid`, `email`, `user`, `password`, `date`) VALUES (2, 'dipak@naderco.com.au', 'admin', 'admin', '');