-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 08, 2011 at 05:28 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `brokecost`
--
-- --------------------------------------------------------
--
-- Table structure for table `ci_sessions`
--
CREATE TABLE `ci_sessions` (
`session_id` text,
`ip_address` text,
`user_agent` text,
`last_activity` text,
`user_data` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ci_sessions`
--
INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES
('79a5e9bd04dc156ce96cc118b7b36e93', '127.0.0.1', 'Mozilla/5.0 (Windows NT 5.1; rv:7.0.1) Gecko/20100101 Firefox/7.0.1', '1320469999', 'a:5:{s:13:"previous_page";s:17:"sitepanel/setting";s:10:"admin_user";s:5:"admin";s:7:"adm_key";s:8:"cnsgkMd4";s:15:"admin_logged_in";b:1;s:17:"flash:old:success";s:36:"Record has been updated successfully";}'),
('345c8cec87afe9db8b6f9628a035f619', '127.0.0.1', 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/13.0.782.112 Safari/535.1', '1320469644', 'a:5:{s:13:"previous_page";s:17:"sitepanel/setting";s:10:"admin_user";s:5:"admin";s:7:"adm_key";s:8:"cnsgkMd4";s:15:"admin_logged_in";b:1;s:15:"flash:old:error";s:28:"Old Password does not match";}'),
('39b77dab24f30be348c78f960b8ecab6', '127.0.0.1', 'Mozilla/5.0 (Windows NT 5.1; rv:7.0.1) Gecko/20100101 Firefox/7.0.1', '1320473037', 'a:2:{s:13:"previous_page";s:24:"products/popularsearch/s";s:8:"srchdata";s:32:"38fcffe4714fcfeef9cc5683e928e5ab";}'),
('3f0f93530f3d8288ef348a5704f1c809', '127.0.0.1', 'Mozilla/5.0 (Windows NT 5.1) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/13.0.782.112 Safari/535.1', '1320479949', 'a:1:{s:13:"previous_page";s:28:"sitepanel/forgotten_password";}'),
('e2c0848b74c283b6b6530624835b96ff', '127.0.0.1', 'Mozilla/5.0 (Windows NT 5.1; rv:7.0.1) Gecko/20100101 Firefox/7.0.1', '1320725902', 'a:2:{s:13:"previous_page";s:17:"products/searched";s:8:"srchdata";s:32:"e2c0848b74c283b6b6530624835b96ff";}');
-- --------------------------------------------------------
--
-- Table structure for table `forum_category`
--
CREATE TABLE `forum_category` (
`cat_id` int(11) NOT NULL auto_increment,
`cat_name` varchar(100) default NULL,
`cat_status` enum('0','1','2') NOT NULL default '1' COMMENT '0=Inactive,1=Active,2=Deleted',
PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
--
-- Dumping data for table `forum_category`
--
INSERT INTO `forum_category` (`cat_id`, `cat_name`, `cat_status`) VALUES
(1, 'Announcements', '1'),
(2, 'Competitions', '1'),
(3, 'Getting involved in GD', '1'),
(4, 'Fashions', '1'),
(5, 'Glasses Direct', '1'),
(6, 'Eye Health', '1'),
(7, 'How we help charitably', '1'),
(8, 'In The Press', '1'),
(9, 'Optical Industry', '1'),
(10, 'Products', '1'),
(11, 'Random', '1'),
(12, 'Research', '1'),
(13, 'Saving Money', '1'),
(14, 'Technology', '1'),
(15, 'Videos', '1');
-- --------------------------------------------------------
--
-- Table structure for table `forum_topics`
--
CREATE TABLE `forum_topics` (
`topicID` int(11) NOT NULL auto_increment,
`created_by` enum('A','U') default 'A' COMMENT 'A=admin,U=user',
`cat_id` int(11) default NULL,
`topicTitle` text,
`topicDesc` text,
`views` int(11) default '0',
`memberID` int(11) default '0',
`status` enum('0','1','2') NOT NULL default '0' COMMENT '0=Inactive,1=Active,2=Deleted',
`recv_date` datetime default '0000-00-00 00:00:00',
PRIMARY KEY (`topicID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `forum_topics`
--
INSERT INTO `forum_topics` (`topicID`, `created_by`, `cat_id`, `topicTitle`, `topicDesc`, `views`, `memberID`, `status`, `recv_date`) VALUES
(1, 'A', 4, 'GFDDGFDG DF', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
\r\n
\r\nIt has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\r\n
\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
\r\n
\r\nIt has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\r\n
\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
\r\n
\r\nIt has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\r\n
\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
\r\n
\r\nIt has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
', 0, 3, '1', '2011-10-19 11:19:41'),
(2, 'A', 4, 'AAAAAAAAAAAAAA', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
\r\n
\r\nIt has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
\r\n
\r\nIt has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
\r\n
\r\nIt has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
', 0, 1, '1', '2011-10-19 11:21:09'),
(3, 'A', 2, 'dfgdfgdfdfdf fdgfgdgdf gdfgdfdfgdfgdf', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
\r\n
\r\nIt has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\r\n
\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
\r\n
\r\nIt has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\r\n
\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
\r\n
\r\nIt has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\r\n
\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
\r\n
\r\nIt has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
\r\n
\r\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.
\r\n
\r\nIt has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
', 0, 2, '1', '2011-10-19 11:24:09'),
(4, 'A', 2, 'werwew rwerr', 'er r rer rwerwe rwe rw r', 0, 3, '1', '2011-11-01 05:15:51'),
(5, 'A', 1, 'fsddfsdfsd', 'sdff df f', 0, 3, '1', '2011-11-01 05:17:08'),
(6, 'A', 9, 'fsd dfsdf f f sdfsdf sfds f', 'sdf fsfffsd weeqw eqw eqw eqwe qwe qweqw eqw ewq ewe qw eqwe', 0, 3, '1', '2011-11-01 05:22:36'),
(7, 'A', 1, 'erter', 'er te t ertert ertr terter tert ertr ter er', 0, 3, '1', '2011-11-01 05:25:33'),
(8, 'A', 1, 'er t ert erteter e ertr er', 't ert ert erter qweqw eqw qwe qwe qweqw ee qwe we qwe qwe qwe qwe qwe qwe qwe qwe we qwe qwew qe qwe qew qe qwe qwe qwew qe qwe qwe wqe wqe qwe re rwer wer wer ewr we wr r', 0, 3, '1', '2011-11-01 05:25:53');
-- --------------------------------------------------------
--
-- Table structure for table `forum_topic_responses`
--
CREATE TABLE `forum_topic_responses` (
`replyID` int(11) NOT NULL auto_increment,
`topicID` int(11) NOT NULL default '0',
`memberID` int(11) default NULL,
`name` varchar(100) default '',
`email` varchar(100) default '',
`heading` varchar(200) default NULL,
`comments` text,
`recv_date` datetime default '0000-00-00 00:00:00',
`status` enum('0','1','2') NOT NULL default '0' COMMENT '0=Inactive,1=Active,2=Deleted',
PRIMARY KEY (`replyID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `forum_topic_responses`
--
INSERT INTO `forum_topic_responses` (`replyID`, `topicID`, `memberID`, `name`, `email`, `heading`, `comments`, `recv_date`, `status`) VALUES
(1, 2, 3, 'Suvrat Tiwari', '', NULL, 'df g dfg dfg df gdfgd g df dfg dfg', '2011-10-31 00:00:00', '1'),
(4, 8, 3, 'Suvrat Tiwari', 'weblink.suvrat@gmail.com', NULL, 'sdfdfsdfs fsd fsdf e qe qweqw ewq ee qwe qwe qwe qwe qwe qwe wqe qe qwe qwe qwe qwe qwe qw ewe qw eqw e', '2011-11-01 05:32:25', '1'),
(5, 8, 3, 'Suvrat Tiwari', 'weblink.suvrat@gmail.com', NULL, 'sff df sdf qeqwe qe qwe qweqw eqwe qwe we qw eqw eq ew eqwe qwe we qwe we qwe qwe qwe qwe qweqw eqw eqw eqwe qwe qwew qe qwe qweqw eqw ewqe qe qwe we qwew eqwe qwe qwe qwe qwe qwe wqe qwew qe e qweqw eqw ew qeqw eqw eqw eqw ew e we qwe qwe qwe we qe qe qwe qw eqwe wq eqw eqw eq we qwe qwe qwe qwe wq ewq', '2011-11-01 05:33:03', '1'),
(6, 0, 3, 'Suvrat Tiwari', 'weblink.suvrat@gmail.com', NULL, ' wrwe rwer werwe rer wr wer wer werwe re wre wrwe eqw eqw eqe we qwe wqe qwe we qw ewqe qwe wq eqw eqw ewq eqw eqw ewq eqw e qwe wqe wqe wq ewq eqw', '2011-11-01 05:33:16', '0'),
(7, 8, 3, 'Suvrat Tiwari', 'weblink.suvrat@gmail.com', NULL, 'sfdfsdfsdsdf sdf dsd fsdf sdf sdfsdf dsf sdf sdf sdfsd fds fsd ew rwe rewr wre wre rwe rw r wer were wr wer wer e wer wrwerwerrwererwe rwer we rwe rwer we rwe rwe r wer ew r wer wer we rwe r', '2011-11-01 05:33:44', '1');
-- --------------------------------------------------------
--
-- Table structure for table `newsletter_subscriber`
--
CREATE TABLE `newsletter_subscriber` (
`subscr_id` int(11) NOT NULL auto_increment,
`subscr_name` varchar(225) NOT NULL default '',
`subscr_email` varchar(225) NOT NULL default '',
`status` enum('Active','Inactive','unverified') NOT NULL default 'unverified',
PRIMARY KEY (`subscr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `newsletter_subscriber`
--
INSERT INTO `newsletter_subscriber` (`subscr_id`, `subscr_name`, `subscr_email`, `status`) VALUES
(1, 'Member', 's@yahoomail.com', 'unverified');
-- --------------------------------------------------------
--
-- Table structure for table `order_details`
--
CREATE TABLE `order_details` (
`order_id` int(15) NOT NULL auto_increment,
`order_no` varchar(50) default NULL,
`products_id` int(11) default NULL,
`product_name` varchar(100) default NULL,
`pcolor` varchar(60) default NULL,
`psize` varchar(30) default NULL,
`product_code` varchar(100) default NULL,
`product_price` float(10,4) default NULL,
`quantity` int(10) NOT NULL default '0',
`shipcharge` decimal(11,2) default NULL,
PRIMARY KEY (`order_id`),
KEY `order_id` (`order_id`),
KEY `order_no` (`order_no`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `order_details`
--
INSERT INTO `order_details` (`order_id`, `order_no`, `products_id`, `product_name`, `pcolor`, `psize`, `product_code`, `product_price`, `quantity`, `shipcharge`) VALUES
(1, 'INC1', 6, 'dgfgdf', 'Red', '30', 'dfggdfg', 34534.0000, 1, '10.00'),
(2, 'INC2', 6, 'dgfgdf', 'Red', '30', 'dfggdfg', 34534.0000, 1, '10.00'),
(3, 'INC3', 6, 'dgfgdf', 'Green', '30', 'dfggdfg', 34534.0000, 1, '10.00'),
(4, 'INC3', 5, 'fsdfsdfs', 'Green', '20', '423423', 333.0000, 1, '10.00'),
(5, 'INC4', 6, 'dgfgdf', 'Red', '30', 'dfggdfg', 34534.0000, 6, '10.00');
-- --------------------------------------------------------
--
-- Table structure for table `order_master`
--
CREATE TABLE `order_master` (
`order_id` int(15) NOT NULL auto_increment,
`order_no` varchar(50) default NULL,
`member_id` int(11) default '0',
`coupen_code` varchar(50) default NULL,
`coupen_discount` int(10) default NULL,
`shipping_method` varchar(200) default NULL,
`total_shiping` float(10,2) default '0.00',
`vat_amt` float(10,2) default NULL,
`total_amount` float(10,4) default '0.0000',
`payment_mode` varchar(100) default '',
`name` varchar(50) default NULL,
`phone` varchar(50) default NULL,
`email` varchar(50) default NULL,
`bill_info` text,
`ship_ship` text,
`bill_name` varchar(100) default NULL,
`bill_address` varchar(223) default NULL,
`bill_phone` varchar(50) default NULL,
`bill_fax` varchar(50) default NULL,
`bill_post_code` varchar(50) default NULL,
`bill_country` varchar(100) default NULL,
`bill_state` varchar(50) default NULL,
`bill_city` varchar(50) default NULL,
`bill_email` varchar(150) default NULL,
`ship_name` varchar(100) default NULL,
`ship_address` varchar(223) default NULL,
`ship_phone` varchar(50) default NULL,
`ship_fax` varchar(50) default NULL,
`ship_post_code` varchar(50) default NULL,
`ship_country` varchar(100) default NULL,
`ship_state` varchar(50) default NULL,
`ship_city` varchar(50) default NULL,
`ship_email` varchar(150) default NULL,
`order_status` enum('Viewed','In Process','Ready For Dispatch','Partially Dispatched','Invoiced','Partially Invoiced','Paid','Closed','Pending','Dispatched','Rejected','Delivered','deleted','Canceled') NOT NULL default 'Pending',
`order_recv_date` datetime default '0000-00-00 00:00:00',
`oder_deliv_date` datetime default '0000-00-00 00:00:00',
`cvalue` float(10,2) default '0.00',
`csymbol` varchar(20) default '',
`curr_code` varchar(10) default NULL,
`payment_status` enum('Paid','Unpaid') NOT NULL default 'Unpaid',
`user_status` enum('Active','Delete') NOT NULL default 'Active',
`ref_no` varchar(50) default NULL,
PRIMARY KEY (`order_id`),
KEY `order_id` (`order_id`),
KEY `order_no` (`order_no`),
KEY `membe_id` (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `order_master`
--
INSERT INTO `order_master` (`order_id`, `order_no`, `member_id`, `coupen_code`, `coupen_discount`, `shipping_method`, `total_shiping`, `vat_amt`, `total_amount`, `payment_mode`, `name`, `phone`, `email`, `bill_info`, `ship_ship`, `bill_name`, `bill_address`, `bill_phone`, `bill_fax`, `bill_post_code`, `bill_country`, `bill_state`, `bill_city`, `bill_email`, `ship_name`, `ship_address`, `ship_phone`, `ship_fax`, `ship_post_code`, `ship_country`, `ship_state`, `ship_city`, `ship_email`, `order_status`, `order_recv_date`, `oder_deliv_date`, `cvalue`, `csymbol`, `curr_code`, `payment_status`, `user_status`, `ref_no`) VALUES
(1, 'INC1', 3, NULL, NULL, NULL, 0.00, NULL, 34534.0000, '', NULL, NULL, 'weblink.suvrat1@gmail.com', 'Suvrat Tiwari
\r\n 33&33A; Rama Road Industrial Area Kirty Nagar,\r\n
\r\n New Delhi,
\r\n Delhi -India - 5345345\r\n
Phone:\r\n 345345345345
Fax: 3453453454
Email: weblink.suvrat@gmail.com ', ' Suvrat Tiwari
\r\n 33&33A; Rama Road Industrial Area Kirty Nagar,\r\n
\r\n New Delhi,
\r\n Delhi -India - 5345345\r\n
Phone:\r\n 345345345345
Fax: 3453453454
Email: weblink.suvrat1@gmail.com ', 'Suvrat Tiwari', '33&33A; Rama Road Industrial Area Kirty Nagar', '345345345345', '3453453454', '5345345', 'India', 'Delhi', 'New Delhi', 'weblink.suvrat@gmail.com', 'Suvrat Tiwari', '33&33A; Rama Road Industrial Area Kirty Nagar', '345345345345', '3453453454', '5345345', 'India', 'Delhi', 'New Delhi', 'weblink.suvrat1@gmail.com', 'Pending', '2011-10-31 04:59:54', '0000-00-00 00:00:00', 0.00, '', NULL, 'Unpaid', 'Active', NULL),
(2, 'INC2', 3, NULL, NULL, NULL, 0.00, NULL, 34534.0000, '', NULL, NULL, 'weblink.suvrat@gmail.com', 'Suvrat Tiwari
\r\n 33&33A; Rama Road Industrial Area Kirty Nagar,\r\n
\r\n New Delhi,
\r\n Delhi -India - 5345345\r\n
Phone:\r\n 345345345345
Fax: 3453453454
Email: weblink.suvrat@gmail.com ', ' Suvrat Tiwari
\r\n 33&33A; Rama Road Industrial Area Kirty Nagar,\r\n
\r\n New Delhi,
\r\n Delhi -India - 5345345\r\n
Phone:\r\n 345345345345
Fax: 3453453454
Email: weblink.suvrat@gmail.com ', 'Suvrat Tiwari', '33&33A; Rama Road Industrial Area Kirty Nagar', '345345345345', '3453453454', '5345345', 'India', 'Delhi', 'New Delhi', 'weblink.suvrat@gmail.com', 'Suvrat Tiwari', '33&33A; Rama Road Industrial Area Kirty Nagar', '345345345345', '3453453454', '5345345', 'India', 'Delhi', 'New Delhi', 'weblink.suvrat@gmail.com', 'Pending', '2011-10-31 05:03:58', '0000-00-00 00:00:00', 0.00, '', NULL, 'Unpaid', 'Active', NULL),
(3, 'INC3', 3, NULL, NULL, NULL, 0.00, NULL, 34867.0000, '', NULL, NULL, 'weblink.suvrat@gmail.com', 'Suvrat Tiwari
\r\n 33&33A; Rama Road Industrial Area Kirty Nagar,\r\n
\r\n New Delhi,
\r\n Delhi -India - 5345345\r\n
Phone:\r\n 345345345345
Fax: 3453453454
Email: weblink.suvrat@gmail.com ', ' Suvrat Tiwari
\r\n 33&33A; Rama Road Industrial Area Kirty Nagar,\r\n
\r\n New Delhi,
\r\n Delhi -India - 5345345\r\n
Phone:\r\n 345345345345
Fax: 3453453454
Email: weblink.suvrat@gmail.com ', 'Suvrat Tiwari', '33&33A; Rama Road Industrial Area Kirty Nagar', '345345345345', '3453453454', '5345345', 'India', 'Delhi', 'New Delhi', 'weblink.suvrat@gmail.com', 'Suvrat Tiwari', '33&33A; Rama Road Industrial Area Kirty Nagar', '345345345345', '3453453454', '5345345', 'India', 'Delhi', 'New Delhi', 'weblink.suvrat@gmail.com', 'Pending', '2011-10-31 05:22:04', '0000-00-00 00:00:00', 0.00, '', NULL, 'Unpaid', 'Active', NULL),
(4, 'INC4', 3, NULL, NULL, NULL, 0.00, NULL, 207204.0000, '', NULL, NULL, 'weblink.suvrat@gmail.com', 'Suvrat Tiwari
\r\n 33&33A; Rama Road Industrial Area Kirty Nagar,\r\n
\r\n New Delhi,
\r\n Delhi -India - 5345345\r\n
Phone:\r\n 345345345345
Fax: 3453453454
Email: weblink.suvrat@gmail.com ', ' Suvrat Tiwari
\r\n 33&33A; Rama Road Industrial Area Kirty Nagar,\r\n
\r\n New Delhi,
\r\n Delhi -India - 5345345\r\n
Phone:\r\n 345345345345
Fax: 3453453454
Email: weblink.suvrat@gmail.com ', 'Suvrat Tiwari', '33&33A; Rama Road Industrial Area Kirty Nagar', '345345345345', '3453453454', '5345345', 'India', 'Delhi', 'New Delhi', 'weblink.suvrat@gmail.com', 'Suvrat Tiwari', '33&33A; Rama Road Industrial Area Kirty Nagar', '345345345345', '3453453454', '5345345', 'India', 'Delhi', 'New Delhi', 'weblink.suvrat@gmail.com', 'Pending', '2011-11-04 04:31:43', '0000-00-00 00:00:00', 0.00, '', NULL, 'Unpaid', 'Active', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `related_product`
--
CREATE TABLE `related_product` (
`recid` int(11) NOT NULL auto_increment,
`ref_pid` int(11) NOT NULL,
`pid` int(11) NOT NULL,
`status` enum('Active','Inactive','Delete') NOT NULL default 'Active',
`rec_order` int(11) default NULL,
`recv_date` datetime NOT NULL,
PRIMARY KEY (`recid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `related_product`
--
INSERT INTO `related_product` (`recid`, `ref_pid`, `pid`, `status`, `rec_order`, `recv_date`) VALUES
(1, 9, 8, 'Active', NULL, '2011-10-29 05:52:26'),
(2, 9, 7, 'Active', NULL, '2011-10-29 05:52:26'),
(3, 9, 6, 'Active', NULL, '2011-10-29 05:52:26'),
(4, 9, 5, 'Active', NULL, '2011-10-29 05:52:26'),
(5, 9, 4, 'Active', NULL, '2011-10-29 05:52:26'),
(6, 9, 3, 'Active', NULL, '2011-10-29 05:52:26'),
(7, 9, 2, 'Active', NULL, '2011-10-29 05:52:26'),
(8, 9, 1, 'Active', NULL, '2011-10-29 05:52:26');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_admin`
--
CREATE TABLE `tbl_admin` (
`admin_id` int(11) NOT NULL auto_increment,
`admin_key` varchar(15) NOT NULL,
`admin_username` varchar(50) NOT NULL,
`admin_password` varchar(100) default NULL,
`admin_email` varchar(255) NOT NULL default '',
`admin_last_login` datetime NOT NULL default '0000-00-00 00:00:00',
`address` text NOT NULL,
`cheque_info` text NOT NULL,
`city` varchar(100) NOT NULL,
`country` varchar(100) NOT NULL,
`phone` varchar(50) NOT NULL,
`shipping_charge` decimal(11,2) NOT NULL,
PRIMARY KEY (`admin_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `tbl_admin`
--
INSERT INTO `tbl_admin` (`admin_id`, `admin_key`, `admin_username`, `admin_password`, `admin_email`, `admin_last_login`, `address`, `cheque_info`, `city`, `country`, `phone`, `shipping_charge`) VALUES
(1, 'cnsgkMd4', 'admin', 'admin', 'shaun.php5@gmail.com', '0000-00-00 00:00:00', '33/33A Rama Road Industrial area kirty nagar', 'sdfsfsdfd fsdf f sdfsd fsd fsdf sdf sdfsd fsdf sdf sdf sdfd ff sdf sdfsd fsd fsd fsf dsf sd sd\r\n', 'New Delhi', 'India', '564564564565', '10.00');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_banner`
--
CREATE TABLE `tbl_banner` (
`banner_id` int(11) NOT NULL auto_increment,
`banner_position` varchar(100) default NULL,
`cat_id` int(11) default NULL,
`banner_pic` varchar(200) default NULL,
`banner_url` varchar(170) default NULL,
`section` varchar(30) default NULL,
`status` enum('1','0','2') default NULL,
`recive_date` datetime default NULL,
PRIMARY KEY (`banner_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `tbl_banner`
--
INSERT INTO `tbl_banner` (`banner_id`, `banner_position`, `cat_id`, `banner_pic`, `banner_url`, `section`, `status`, `recive_date`) VALUES
(1, 'Left', NULL, 'left-bannerzFui.jpg', NULL, NULL, '1', '2011-11-01 07:37:39'),
(2, 'Bottom', NULL, 'bot-bannerZzM4.jpg', NULL, NULL, '1', '2011-11-01 07:40:05'),
(3, 'Left', 2, 'left-bannerySKr.jpg', '', NULL, '1', '2011-11-01 07:40:27'),
(4, 'Right', 7, 'rgt-banner1O7jb.jpg', 'http://www.weblinkindia.com', NULL, '1', '2011-11-01 08:49:04'),
(5, 'Left', 3, 'oct2011bvKEh.jpg', '', NULL, '1', '2011-11-01 09:52:29'),
(6, 'Right', 0, 'oct2011cKCdX.jpg', 'http://www.valueinfracon.com', NULL, '1', '2011-11-01 10:15:20'),
(7, 'Right', 0, 'oct2011b7NFb.jpg', '', NULL, '1', '2011-11-01 10:25:34');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_category`
--
CREATE TABLE `tbl_category` (
`cat_id` int(11) NOT NULL auto_increment,
`display_order` int(11) default '0',
`cat_name` varchar(100) default NULL,
`cat_img` varchar(150) default NULL,
`parent_id` int(11) default NULL,
`meta_title` varchar(220) default NULL,
`meta_keyword` varchar(220) default NULL,
`meta_desc` varchar(220) default NULL,
`cat_desc` text,
`cat_status` enum('0','1','2') default NULL COMMENT '1=active,0=inactive,2=deleted',
`home_menu` enum('1','0') NOT NULL default '0',
`recive_date` datetime NOT NULL,
PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
--
-- Dumping data for table `tbl_category`
--
INSERT INTO `tbl_category` (`cat_id`, `display_order`, `cat_name`, `cat_img`, `parent_id`, `meta_title`, `meta_keyword`, `meta_desc`, `cat_desc`, `cat_status`, `home_menu`, `recive_date`) VALUES
(1, 3, 'Accessories', 'dm-pro252VS.jpg', 0, NULL, NULL, NULL, '
\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam luctus condimentum iaculis. Proin blandit ullamcorper magna ut fermentum. Mauris placerat, purus ut ullamcorper rhoncus, magna libero imperdiet sapien, ac interdum sapien neque sed tortor. Nullam sed neque nec dui aliquet dictum sagittis et sapien. fdsfsd fdf df sdfsdfsd f sdf sdfsd f dfsdfd fsdf df
\r\n', '1', '0', '2011-10-20 10:18:56'),
(2, 2, 'Audio', 'pro-pic5tA3A.jpg', 0, NULL, NULL, NULL, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam luctus condimentum iaculis. Proin blandit ullamcorper magna ut fermentum. Mauris placerat, purus ut ullamcorper rhoncus, magna libero imperdiet sapien, ac interdum sapien neque sed tortor. Nullam sed neque nec dui aliquet dictum sagittis et sapien.', '1', '0', '2011-10-20 10:19:48'),
(3, 1, 'Barebone Kits', 'pro-pic4HsnG.jpg', 0, NULL, NULL, NULL, '
\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam luctus condimentum iaculis. Proin blandit ullamcorper magna ut fermentum. Mauris placerat, purus ut ullamcorper rhoncus, magna libero imperdiet sapien, ac interdum sapien neque sed tortor. Nullam sed neque nec dui aliquet dictum sagittis et sapien.
\r\n', '1', '0', '2011-10-20 10:21:04'),
(4, 4, 'Cables', 'pro-pic3PkXb.jpg', 0, NULL, NULL, NULL, '
\r\nCables
\r\n
\r\n', '1', '0', '2011-10-27 09:54:59'),
(5, 14, 'CD / DVD Burners', 'pro-pic2NO6g.jpg', 0, NULL, NULL, NULL, '\r\nCD / DVD Burners
\r\n
\r\n', '1', '0', '2011-10-27 09:55:21'),
(6, 13, 'Cellular Phones', 'pro-pic1SHjl.jpg', 0, NULL, NULL, NULL, '\r\nCellular Phones
\r\n
\r\n', '1', '0', '2011-10-27 09:55:34'),
(7, 0, 'Home Theater Sysytem', NULL, 1, NULL, NULL, NULL, '
\r\n', '1', '0', '2011-10-27 10:09:11'),
(13, 12, 'Blutetooth', 'dm-pro41YOo.jpg', 0, NULL, NULL, NULL, 'dfs sdfsd f sd
\r\n', '1', '0', '2011-11-01 04:33:41'),
(14, 11, 'Camcorders', 'scroll-pro6PVxE.jpg', 0, NULL, NULL, NULL, '
\r\ndasd asd asd
\r\n', '1', '0', '2011-11-01 04:34:13'),
(15, 10, 'Cameras', 'dm-pro2ZBUx.jpg', 0, NULL, NULL, NULL, '
\r\ndas adasdasd
\r\n', '1', '0', '2011-11-01 04:34:42'),
(16, 9, 'Communications', 'pro-pic2bjmR.jpg', 0, NULL, NULL, NULL, '
\r\nCommunications
\r\n', '1', '0', '2011-11-01 04:35:29'),
(17, 8, 'Computers', 'pro-pic1egdf.jpg', 0, NULL, NULL, NULL, '
\r\nComputers
\r\n', '1', '0', '2011-11-01 04:35:56'),
(18, 7, 'Computer Cases', 'dm-pro1envm.jpg', 0, NULL, NULL, NULL, '
\r\nComputer Cases
\r\n', '1', '0', '2011-11-01 04:36:12'),
(19, 6, 'Computer Parts', 'dm-pro2LsiB.jpg', 0, NULL, NULL, NULL, '
\r\nComputer Parts
\r\n', '1', '0', '2011-11-01 04:36:38'),
(20, 5, 'Cooling Products', 'dm-pro3bdOB.jpg', 0, NULL, NULL, NULL, '
\r\nCooling Products
\r\n', '1', '0', '2011-11-01 04:36:53');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_colour`
--
CREATE TABLE `tbl_colour` (
`colour_id` int(11) NOT NULL auto_increment,
`colour_name` varchar(80) default NULL,
`display_order` int(11) default NULL,
`colour_status` enum('0','1','2') default '1',
`recive_date` datetime default NULL,
PRIMARY KEY (`colour_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `tbl_colour`
--
INSERT INTO `tbl_colour` (`colour_id`, `colour_name`, `display_order`, `colour_status`, `recive_date`) VALUES
(1, 'Green', 0, '1', '2011-07-25 05:03:07'),
(2, 'cccc', 0, '2', '2011-07-25 05:06:09'),
(3, 'Red', 0, '1', '2011-07-30 06:53:29'),
(4, 'Blue', 0, '1', '2011-07-30 06:53:35'),
(5, 'Black', 0, '1', '2011-07-30 06:53:40'),
(6, 'gfdgdfgdfg erewwr', NULL, '2', '2011-10-18 04:54:37'),
(7, 'fsdsdf gfsdfsf', NULL, '2', '2011-10-18 04:55:49'),
(8, 'gfgfgf fddsdsdf', NULL, '2', '2011-10-20 05:54:22');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_contactus`
--
CREATE TABLE `tbl_contactus` (
`id` int(11) NOT NULL auto_increment,
`post_date` date default NULL,
`name` varchar(100) default NULL,
`comp_name` varchar(100) default NULL,
`email` varchar(200) default NULL,
`phone` varchar(50) default NULL,
`fax` varchar(50) default NULL,
`comment` text,
`status` enum('0','1') default '0',
`reply_status` varchar(1) default 'N',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `tbl_contactus`
--
INSERT INTO `tbl_contactus` (`id`, `post_date`, `name`, `comp_name`, `email`, `phone`, `fax`, `comment`, `status`, `reply_status`) VALUES
(1, '2011-10-24', 'erwerwe', 'fsdfdfsd', 's@sss.com', '423423423', '234234', 'we wer werwe rwer er wee re re er wer werwe rwer ewr wer werwe r', '0', 'N'),
(2, '2011-10-24', 'FSDDSSDFSD', 'SDFSDFSDF', 's@sss.com', '4234233', '234234', 'FSDSD F DF SDF SD SDF', '0', 'N'),
(3, '2011-10-24', 'gddfggdfg', 'dfgdfgdfgdf', 's@sss.com', '3453453', '345345345', 'sdf df sd sd sdf', '0', 'N'),
(4, '2011-10-24', 'gddfggdfg', 'dfgdfgdfgdf', 's@sss.com', '3453453', '345345345', 'sdf df sd sd sdf', '0', 'N');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_country`
--
CREATE TABLE `tbl_country` (
`country_id` int(11) NOT NULL auto_increment,
`country_name` varchar(64) NOT NULL default '',
`country_iso_code_2` char(2) NOT NULL default '',
`country_iso_code_3` char(3) NOT NULL default '',
`cont_status` enum('Y','N') NOT NULL default 'N',
PRIMARY KEY (`country_id`),
KEY `IDX_COUNTRIES_NAME` (`country_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=240 ;
--
-- Dumping data for table `tbl_country`
--
INSERT INTO `tbl_country` (`country_id`, `country_name`, `country_iso_code_2`, `country_iso_code_3`, `cont_status`) VALUES
(1, 'Afghanistan', 'AF', 'AFG', 'N'),
(2, 'Albania', 'AL', 'ALB', 'N'),
(3, 'Algeria', 'DZ', 'DZA', 'N'),
(4, 'American Samoa', 'AS', 'ASM', 'N'),
(5, 'Andorra', 'AD', 'AND', 'N'),
(6, 'Angola', 'AO', 'AGO', 'N'),
(7, 'Anguilla', 'AI', 'AIA', 'N'),
(8, 'Antarctica', 'AQ', 'ATA', 'N'),
(9, 'Antigua and Barbuda', 'AG', 'ATG', 'N'),
(10, 'Argentina', 'AR', 'ARG', 'N'),
(11, 'Armenia', 'AM', 'ARM', 'N'),
(12, 'Aruba', 'AW', 'ABW', 'N'),
(13, 'Australia', 'AU', 'AUS', 'Y'),
(14, 'Austria', 'AT', 'AUT', 'N'),
(15, 'Azerbaijan', 'AZ', 'AZE', 'N'),
(16, 'Bahamas', 'BS', 'BHS', 'N'),
(17, 'Bahrain', 'BH', 'BHR', 'N'),
(18, 'Bangladesh', 'BD', 'BGD', 'N'),
(19, 'Barbados', 'BB', 'BRB', 'N'),
(20, 'Belarus', 'BY', 'BLR', 'N'),
(21, 'Belgium', 'BE', 'BEL', 'N'),
(22, 'Belize', 'BZ', 'BLZ', 'N'),
(23, 'Benin', 'BJ', 'BEN', 'N'),
(24, 'Bermuda', 'BM', 'BMU', 'N'),
(25, 'Bhutan', 'BT', 'BTN', 'N'),
(26, 'Bolivia', 'BO', 'BOL', 'N'),
(27, 'Bosnia and Herzegowina', 'BA', 'BIH', 'N'),
(28, 'Botswana', 'BW', 'BWA', 'N'),
(29, 'Bouvet Island', 'BV', 'BVT', 'N'),
(30, 'Brazil', 'BR', 'BRA', 'N'),
(31, 'British Indian Ocean Territory', 'IO', 'IOT', 'N'),
(32, 'Brunei Darussalam', 'BN', 'BRN', 'N'),
(33, 'Bulgaria', 'BG', 'BGR', 'N'),
(34, 'Burkina Faso', 'BF', 'BFA', 'N'),
(35, 'Burundi', 'BI', 'BDI', 'N'),
(36, 'Cambodia', 'KH', 'KHM', 'N'),
(37, 'Cameroon', 'CM', 'CMR', 'N'),
(38, 'Canada', 'CA', 'CAN', 'Y'),
(39, 'Cape Verde', 'CV', 'CPV', 'N'),
(40, 'Cayman Islands', 'KY', 'CYM', 'N'),
(41, 'Central African Republic', 'CF', 'CAF', 'N'),
(42, 'Chad', 'TD', 'TCD', 'N'),
(43, 'Chile', 'CL', 'CHL', 'N'),
(44, 'China', 'CN', 'CHN', 'N'),
(45, 'Christmas Island', 'CX', 'CXR', 'N'),
(46, 'Cocos (Keeling) Islands', 'CC', 'CCK', 'N'),
(47, 'Colombia', 'CO', 'COL', 'N'),
(48, 'Comoros', 'KM', 'COM', 'N'),
(49, 'Congo', 'CG', 'COG', 'N'),
(50, 'Cook Islands', 'CK', 'COK', 'N'),
(51, 'Costa Rica', 'CR', 'CRI', 'N'),
(52, 'Cote D''Ivoire', 'CI', 'CIV', 'N'),
(53, 'Croatia', 'HR', 'HRV', 'N'),
(54, 'Cuba', 'CU', 'CUB', 'N'),
(55, 'Cyprus', 'CY', 'CYP', 'N'),
(56, 'Czech Republic', 'CZ', 'CZE', 'N'),
(57, 'Denmark', 'DK', 'DNK', 'N'),
(58, 'Djibouti', 'DJ', 'DJI', 'N'),
(59, 'Dominica', 'DM', 'DMA', 'N'),
(60, 'Dominican Republic', 'DO', 'DOM', 'N'),
(61, 'East Timor', 'TP', 'TMP', 'N'),
(62, 'Ecuador', 'EC', 'ECU', 'N'),
(63, 'Egypt', 'EG', 'EGY', 'N'),
(64, 'El Salvador', 'SV', 'SLV', 'N'),
(65, 'Equatorial Guinea', 'GQ', 'GNQ', 'N'),
(66, 'Eritrea', 'ER', 'ERI', 'N'),
(67, 'Estonia', 'EE', 'EST', 'N'),
(68, 'Ethiopia', 'ET', 'ETH', 'N'),
(69, 'Falkland Islands (Malvinas)', 'FK', 'FLK', 'N'),
(70, 'Faroe Islands', 'FO', 'FRO', 'N'),
(71, 'Fiji', 'FJ', 'FJI', 'N'),
(72, 'Finland', 'FI', 'FIN', 'N'),
(73, 'France', 'FR', 'FRA', 'N'),
(74, 'France, Metropolitan', 'FX', 'FXX', 'N'),
(75, 'French Guiana', 'GF', 'GUF', 'N'),
(76, 'French Polynesia', 'PF', 'PYF', 'N'),
(77, 'French Southern Territories', 'TF', 'ATF', 'N'),
(78, 'Gabon', 'GA', 'GAB', 'N'),
(79, 'Gambia', 'GM', 'GMB', 'N'),
(80, 'Georgia', 'GE', 'GEO', 'N'),
(81, 'Germany', 'DE', 'DEU', 'N'),
(82, 'Ghana', 'GH', 'GHA', 'N'),
(83, 'Gibraltar', 'GI', 'GIB', 'N'),
(84, 'Greece', 'GR', 'GRC', 'N'),
(85, 'Greenland', 'GL', 'GRL', 'N'),
(86, 'Grenada', 'GD', 'GRD', 'N'),
(87, 'Guadeloupe', 'GP', 'GLP', 'N'),
(88, 'Guam', 'GU', 'GUM', 'N'),
(89, 'Guatemala', 'GT', 'GTM', 'N'),
(90, 'Guinea', 'GN', 'GIN', 'N'),
(91, 'Guinea-bissau', 'GW', 'GNB', 'N'),
(92, 'Guyana', 'GY', 'GUY', 'N'),
(93, 'Haiti', 'HT', 'HTI', 'N'),
(94, 'Heard and Mc Donald Islands', 'HM', 'HMD', 'N'),
(95, 'Honduras', 'HN', 'HND', 'N'),
(96, 'Hong Kong', 'HK', 'HKG', 'N'),
(97, 'Hungary', 'HU', 'HUN', 'N'),
(98, 'Iceland', 'IS', 'ISL', 'N'),
(99, 'India', 'IN', 'IND', 'Y'),
(100, 'Indonesia', 'ID', 'IDN', 'N'),
(101, 'Iran (Islamic Republic of)', 'IR', 'IRN', 'N'),
(102, 'Iraq', 'IQ', 'IRQ', 'N'),
(103, 'Ireland', 'IE', 'IRL', 'N'),
(104, 'Israel', 'IL', 'ISR', 'N'),
(105, 'Italy', 'IT', 'ITA', 'N'),
(106, 'Jamaica', 'JM', 'JAM', 'N'),
(107, 'Japan', 'JP', 'JPN', 'N'),
(108, 'Jordan', 'JO', 'JOR', 'N'),
(109, 'Kazakhstan', 'KZ', 'KAZ', 'N'),
(110, 'Kenya', 'KE', 'KEN', 'N'),
(111, 'Kiribati', 'KI', 'KIR', 'N'),
(112, 'Korea, Democratic People''s Republic of', 'KP', 'PRK', 'N'),
(113, 'Korea, Republic of', 'KR', 'KOR', 'N'),
(114, 'Kuwait', 'KW', 'KWT', 'N'),
(115, 'Kyrgyzstan', 'KG', 'KGZ', 'N'),
(116, 'Lao People''s Democratic Republic', 'LA', 'LAO', 'N'),
(117, 'Latvia', 'LV', 'LVA', 'N'),
(118, 'Lebanon', 'LB', 'LBN', 'N'),
(119, 'Lesotho', 'LS', 'LSO', 'N'),
(120, 'Liberia', 'LR', 'LBR', 'N'),
(121, 'Libyan Arab Jamahiriya', 'LY', 'LBY', 'N'),
(122, 'Liechtenstein', 'LI', 'LIE', 'N'),
(123, 'Lithuania', 'LT', 'LTU', 'N'),
(124, 'Luxembourg', 'LU', 'LUX', 'N'),
(125, 'Macau', 'MO', 'MAC', 'N'),
(126, 'Macedonia, The Former Yugoslav Republic of', 'MK', 'MKD', 'N'),
(127, 'Madagascar', 'MG', 'MDG', 'N'),
(128, 'Malawi', 'MW', 'MWI', 'N'),
(129, 'Malaysia', 'MY', 'MYS', 'N'),
(130, 'Maldives', 'MV', 'MDV', 'N'),
(131, 'Mali', 'ML', 'MLI', 'N'),
(132, 'Malta', 'MT', 'MLT', 'N'),
(133, 'Marshall Islands', 'MH', 'MHL', 'N'),
(134, 'Martinique', 'MQ', 'MTQ', 'N'),
(135, 'Mauritania', 'MR', 'MRT', 'N'),
(136, 'Mauritius', 'MU', 'MUS', 'N'),
(137, 'Mayotte', 'YT', 'MYT', 'N'),
(138, 'Mexico', 'MX', 'MEX', 'N'),
(139, 'Micronesia, Federated States of', 'FM', 'FSM', 'N'),
(140, 'Moldova, Republic of', 'MD', 'MDA', 'N'),
(141, 'Monaco', 'MC', 'MCO', 'N'),
(142, 'Mongolia', 'MN', 'MNG', 'N'),
(143, 'Montserrat', 'MS', 'MSR', 'N'),
(144, 'Morocco', 'MA', 'MAR', 'N'),
(145, 'Mozambique', 'MZ', 'MOZ', 'N'),
(146, 'Myanmar', 'MM', 'MMR', 'N'),
(147, 'Namibia', 'NA', 'NAM', 'N'),
(148, 'Nauru', 'NR', 'NRU', 'N'),
(149, 'Nepal', 'NP', 'NPL', 'N'),
(150, 'Netherlands', 'NL', 'NLD', 'N'),
(151, 'Netherlands Antilles', 'AN', 'ANT', 'N'),
(152, 'New Caledonia', 'NC', 'NCL', 'N'),
(153, 'New Zealand', 'NZ', 'NZL', 'N'),
(154, 'Nicaragua', 'NI', 'NIC', 'N'),
(155, 'Niger', 'NE', 'NER', 'N'),
(156, 'Nigeria', 'NG', 'NGA', 'N'),
(157, 'Niue', 'NU', 'NIU', 'N'),
(158, 'Norfolk Island', 'NF', 'NFK', 'N'),
(159, 'Northern Mariana Islands', 'MP', 'MNP', 'N'),
(160, 'Norway', 'NO', 'NOR', 'N'),
(161, 'Oman', 'OM', 'OMN', 'N'),
(162, 'Pakistan', 'PK', 'PAK', 'Y'),
(163, 'Palau', 'PW', 'PLW', 'N'),
(164, 'Panama', 'PA', 'PAN', 'N'),
(165, 'Papua New Guinea', 'PG', 'PNG', 'N'),
(166, 'Paraguay', 'PY', 'PRY', 'N'),
(167, 'Peru', 'PE', 'PER', 'N'),
(168, 'Philippines', 'PH', 'PHL', 'N'),
(169, 'Pitcairn', 'PN', 'PCN', 'N'),
(170, 'Poland', 'PL', 'POL', 'N'),
(171, 'Portugal', 'PT', 'PRT', 'N'),
(172, 'Puerto Rico', 'PR', 'PRI', 'N'),
(173, 'Qatar', 'QA', 'QAT', 'N'),
(174, 'Reunion', 'RE', 'REU', 'N'),
(175, 'Romania', 'RO', 'ROM', 'N'),
(176, 'Russian Federation', 'RU', 'RUS', 'N'),
(177, 'Rwanda', 'RW', 'RWA', 'N'),
(178, 'Saint Kitts and Nevis', 'KN', 'KNA', 'N'),
(179, 'Saint Lucia', 'LC', 'LCA', 'N'),
(180, 'Saint Vincent and the Grenadines', 'VC', 'VCT', 'N'),
(181, 'Samoa', 'WS', 'WSM', 'N'),
(182, 'San Marino', 'SM', 'SMR', 'N'),
(183, 'Sao Tome and Principe', 'ST', 'STP', 'N'),
(184, 'Saudi Arabia', 'SA', 'SAU', 'N'),
(185, 'Senegal', 'SN', 'SEN', 'N'),
(186, 'Seychelles', 'SC', 'SYC', 'N'),
(187, 'Sierra Leone', 'SL', 'SLE', 'N'),
(188, 'Singapore', 'SG', 'SGP', 'Y'),
(189, 'Slovakia (Slovak Republic)', 'SK', 'SVK', 'N'),
(190, 'Slovenia', 'SI', 'SVN', 'N'),
(191, 'Solomon Islands', 'SB', 'SLB', 'N'),
(192, 'Somalia', 'SO', 'SOM', 'N'),
(193, 'South Africa', 'ZA', 'ZAF', 'Y'),
(194, 'South Georgia and the South Sandwich Islands', 'GS', 'SGS', 'N'),
(195, 'Spain', 'ES', 'ESP', 'N'),
(196, 'Sri Lanka', 'LK', 'LKA', 'N'),
(197, 'St. Helena', 'SH', 'SHN', 'N'),
(198, 'St. Pierre and Miquelon', 'PM', 'SPM', 'N'),
(199, 'Sudan', 'SD', 'SDN', 'N'),
(200, 'Suriname', 'SR', 'SUR', 'N'),
(201, 'Svalbard and Jan Mayen Islands', 'SJ', 'SJM', 'N'),
(202, 'Swaziland', 'SZ', 'SWZ', 'N'),
(203, 'Sweden', 'SE', 'SWE', 'N'),
(204, 'Switzerland', 'CH', 'CHE', 'N'),
(205, 'Syrian Arab Republic', 'SY', 'SYR', 'N'),
(206, 'Taiwan', 'TW', 'TWN', 'N'),
(207, 'Tajikistan', 'TJ', 'TJK', 'N'),
(208, 'Tanzania, United Republic of', 'TZ', 'TZA', 'N'),
(209, 'Thailand', 'TH', 'THA', 'N'),
(210, 'Togo', 'TG', 'TGO', 'N'),
(211, 'Tokelau', 'TK', 'TKL', 'N'),
(212, 'Tonga', 'TO', 'TON', 'N'),
(213, 'Trinidad and Tobago', 'TT', 'TTO', 'N'),
(214, 'Tunisia', 'TN', 'TUN', 'N'),
(215, 'Turkey', 'TR', 'TUR', 'N'),
(216, 'Turkmenistan', 'TM', 'TKM', 'N'),
(217, 'Turks and Caicos Islands', 'TC', 'TCA', 'N'),
(218, 'Tuvalu', 'TV', 'TUV', 'N'),
(219, 'Uganda', 'UG', 'UGA', 'N'),
(220, 'Ukraine', 'UA', 'UKR', 'N'),
(221, 'United Arab Emirates', 'AE', 'ARE', 'N'),
(222, 'United Kingdom', 'GB', 'GBR', 'N'),
(223, 'United States', 'US', 'USA', 'Y'),
(224, 'United States Minor Outlying Islands', 'UM', 'UMI', 'N'),
(225, 'Uruguay', 'UY', 'URY', 'N'),
(226, 'Uzbekistan', 'UZ', 'UZB', 'N'),
(227, 'Vanuatu', 'VU', 'VUT', 'N'),
(228, 'Vatican City State (Holy See)', 'VA', 'VAT', 'N'),
(229, 'Venezuela', 'VE', 'VEN', 'N'),
(230, 'Viet Nam', 'VN', 'VNM', 'N'),
(231, 'Virgin Islands (British)', 'VG', 'VGB', 'N'),
(232, 'Virgin Islands (U.S.)', 'VI', 'VIR', 'N'),
(233, 'Wallis and Futuna Islands', 'WF', 'WLF', 'N'),
(234, 'Western Sahara', 'EH', 'ESH', 'N'),
(235, 'Yemen', 'YE', 'YEM', 'N'),
(236, 'Yugoslavia', 'YU', 'YUG', 'N'),
(237, 'Zaire', 'ZR', 'ZAR', 'N'),
(238, 'Zambia', 'ZM', 'ZMB', 'N'),
(239, 'Zimbabwe', 'ZW', 'ZWE', 'N');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_feedback`
--
CREATE TABLE `tbl_feedback` (
`feedbk_id` int(11) NOT NULL auto_increment,
`post_date` datetime NOT NULL,
`name` varchar(100) NOT NULL,
`comp_name` varchar(100) NOT NULL,
`phone` varchar(50) NOT NULL,
`fax` varchar(50) NOT NULL,
`email` varchar(150) NOT NULL,
`address` varchar(223) NOT NULL,
`city` varchar(100) NOT NULL,
`state` varchar(100) NOT NULL,
`country` varchar(100) NOT NULL,
`comment` text NOT NULL,
`status` enum('0','1','2') NOT NULL default '0' COMMENT '0=New,1=Replied,2=Deleted',
PRIMARY KEY (`feedbk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `tbl_feedback`
--
INSERT INTO `tbl_feedback` (`feedbk_id`, `post_date`, `name`, `comp_name`, `phone`, `fax`, `email`, `address`, `city`, `state`, `country`, `comment`, `status`) VALUES
(2, '2011-10-27 08:57:41', 'SFD', 'SDFDFSD', 'SDFSDFDF', '34534534', 's@sss.com', 'SDFDF', 'dfsdfsdfsdfF', 'sdfsdfsdfd', 'Bangladesh', 'SDFDF F SDF', '0'),
(3, '2011-10-27 09:01:55', 'Suvrat Tiwari', 'weblink India PvtLtd', '3423424', '234244', 'weblink.suvrat@gmail.com', 'weblink.suvrat@gmail.com', 'New Delhi', 'Delhi', 'India', 'testing Email', '0');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_flashbanner`
--
CREATE TABLE `tbl_flashbanner` (
`id` int(11) NOT NULL auto_increment,
`ban_image` varchar(200) default NULL,
`status` enum('0','1','2') NOT NULL default '1' COMMENT '0=Inactive,1=Active,2=Deleted',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `tbl_flashbanner`
--
-- --------------------------------------------------------
--
-- Table structure for table `tbl_help_center`
--
CREATE TABLE `tbl_help_center` (
`help_id` int(11) NOT NULL auto_increment,
`post_date` datetime NOT NULL,
`help_title` varchar(223) NOT NULL,
`help_desc` text NOT NULL,
`status` enum('0','1','2') NOT NULL default '0' COMMENT '0=Inactive,1=Active',
PRIMARY KEY (`help_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `tbl_help_center`
--
INSERT INTO `tbl_help_center` (`help_id`, `post_date`, `help_title`, `help_desc`, `status`) VALUES
(1, '2011-10-21 10:10:42', 'adasasd as asdas dasd asd asd asdas d', '
\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque arcu tortor, ultrices sed rutrum eu, iaculis in quam. Donec quis elementum sem. Aenean ornare ornare euismod. Nam dapibus felis a lectus porttitor at auctor leo mattis. Duis elementum aliquam vestibulum. Nam quis eros justo, id vestibulum augue. Proin purus felis, tempus a auctor quis, pharetra varius sapien. Mauris pretium mollis aliquet. Phasellus dolor massa, congue non vehicula gravida, semper eu erat.', '1'),
(2, '2011-10-21 10:10:54', 'sdadasdasdasdasdasd asd asdas dasd dsa', '
\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque arcu tortor, ultrices sed rutrum eu, iaculis in quam. Donec quis elementum sem. Aenean ornare ornare euismod. Nam dapibus felis a lectus porttitor at auctor leo mattis. Duis elementum aliquam vestibulum. Nam quis eros justo, id vestibulum augue. Proin purus felis, tempus a auctor quis, pharetra varius sapien. Mauris pretium mollis aliquet. Phasellus dolor massa, congue non vehicula gravida, semper eu erat.
\r\n
\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque arcu tortor, ultrices sed rutrum eu, iaculis in quam. Donec quis elementum sem. Aenean ornare ornare euismod. Nam dapibus felis a lectus porttitor at auctor leo mattis. Duis elementum aliquam vestibulum. Nam quis eros justo, id vestibulum augue. Proin purus felis, tempus a auctor quis, pharetra varius sapien. Mauris pretium mollis aliquet. Phasellus dolor massa, congue non vehicula gravida, semper eu erat.
', '1'),
(3, '2011-10-21 10:11:08', 'dasas dasd asd asdas dasd asd asdas dsad asd asdasd asd s', '
\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque arcu tortor, ultrices sed rutrum eu, iaculis in quam. Donec quis elementum sem. Aenean ornare ornare euismod. Nam dapibus felis a lectus porttitor at auctor leo mattis. Duis elementum aliquam vestibulum. Nam quis eros justo, id vestibulum augue. Proin purus felis, tempus a auctor quis, pharetra varius sapien. Mauris pretium mollis aliquet. Phasellus dolor massa, congue non vehicula gravida, semper eu erat.
\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque arcu tortor, ultrices sed rutrum eu, iaculis in quam. Donec quis elementum sem. Aenean ornare ornare euismod. Nam dapibus felis a lectus porttitor at auctor leo mattis. Duis elementum aliquam vestibulum. Nam quis eros justo, id vestibulum augue. Proin purus felis, tempus a auctor quis, pharetra varius sapien. Mauris pretium mollis aliquet. Phasellus dolor massa, congue non vehicula gravida, semper eu erat.
\r\n
\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Quisque arcu tortor, ultrices sed rutrum eu, iaculis in quam. Donec quis elementum sem. Aenean ornare ornare euismod. Nam dapibus felis a lectus porttitor at auctor leo mattis. Duis elementum aliquam vestibulum. Nam quis eros justo, id vestibulum augue. Proin purus felis, tempus a auctor quis, pharetra varius sapien. Mauris pretium mollis aliquet. Phasellus dolor massa, congue non vehicula gravida, semper eu erat.
', '1');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_member`
--
CREATE TABLE `tbl_member` (
`mid` int(11) NOT NULL auto_increment,
`user_name` varchar(50) default NULL,
`password` varchar(50) default NULL,
`name` varchar(50) default NULL,
`phone` varchar(25) default NULL,
`country` varchar(50) default NULL,
`email` varchar(50) default NULL,
`bill_name` varchar(25) default NULL,
`bill_address` varchar(220) default NULL,
`bill_phone` varchar(25) default NULL,
`bill_fax` varchar(25) default NULL,
`bill_post_code` varchar(25) default NULL,
`bill_country` varchar(25) default NULL,
`bill_state` varchar(25) default NULL,
`bill_city` varchar(25) default NULL,
`ship_name` varchar(25) default NULL,
`ship_address` varchar(220) default NULL,
`ship_phone` varchar(25) default NULL,
`ship_fax` varchar(25) default NULL,
`ship_post_code` varchar(25) default NULL,
`ship_country` varchar(25) default NULL,
`ship_state` varchar(25) default NULL,
`ship_city` varchar(25) default NULL,
`is_subscribed` enum('Yes','No') default 'No',
`status` enum('0','1','2') default '1',
`register_date` datetime default NULL,
`current_login` datetime default NULL,
`last_login_date` datetime default NULL,
`ip_address` varchar(50) default NULL,
PRIMARY KEY (`mid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `tbl_member`
--
INSERT INTO `tbl_member` (`mid`, `user_name`, `password`, `name`, `phone`, `country`, `email`, `bill_name`, `bill_address`, `bill_phone`, `bill_fax`, `bill_post_code`, `bill_country`, `bill_state`, `bill_city`, `ship_name`, `ship_address`, `ship_phone`, `ship_fax`, `ship_post_code`, `ship_country`, `ship_state`, `ship_city`, `is_subscribed`, `status`, `register_date`, `current_login`, `last_login_date`, `ip_address`) VALUES
(1, 's@sss.com', '4322', 'fsdsdf', '43234', '234244', NULL, 'fsdfsdf', 'sdfsdf', 'fsdfsdf', 'fsdfdf', 'sdfsdfsd', 'sdfdf', 'fsdfdf', 'fsdf', 'fsdfd', 'fsdfdfsdf', 'ddsf', 'sdfsdfdfdf', 'sdfsdfsdf', 'sdfsdf', 'dfsdfd', 'fsdsdf', 'No', '1', NULL, NULL, NULL, NULL),
(2, 'g@yahoo.com', '234234', 'SDFSDFSD', '42323423', NULL, 'sdfdfsd', 'sdfsdffsdf', 'fsdfsdfsd', 'dfsdfsdf', 'fsdfdfsdfsdf', 'fsdfsdfsdf', 'sdfsd', 'sdfffsd', 'sdfsdfd', 'sdfdf', 'sdfsdf', 'sdfsf', 'sdffsdf', 'sdfsdfsdfsd', 'fsdfdf', 'sdfsfsdf', 'sdffdfsdfd', 'No', '2', '2011-10-12 14:22:12', '2011-10-12 14:22:16', '2011-10-05 14:22:19', NULL),
(3, 'weblink.suvrat@gmail.com', '111111', 'Suvrat Tiwari', '534534534', NULL, NULL, 'Suvrat Tiwari', '33&33A; Rama Road Industrial Area Kirty Nagar', '345345345345', '3453453454', '5345345', 'India', 'Delhi', 'New Delhi', 'Suvrat Tiwari', '33&33A; Rama Road Industrial Area Kirty Nagar', '345345345345', '3453453454', '5345345', 'India', 'Delhi', 'New Delhi', 'No', '1', '2011-10-24 11:04:06', '2011-10-24 11:04:06', '2011-11-04 04:30:33', '127.0.0.1');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_popular_search`
--
CREATE TABLE `tbl_popular_search` (
`id` int(11) NOT NULL auto_increment,
`pkeyword` varchar(100) NOT NULL,
`count` int(11) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
--
-- Dumping data for table `tbl_popular_search`
--
INSERT INTO `tbl_popular_search` (`id`, `pkeyword`, `count`) VALUES
(1, 'fdfsdsdf', 3),
(2, 'sdfssdfd', 2),
(3, 'erwr', 1),
(4, 'jjj', 2),
(5, 'kk', 1),
(6, 'cvc', 1),
(7, 'sdffsdf', 1),
(8, 'dff', 2),
(9, 'ddd', 1),
(10, 'ff', 1),
(11, 'werwere', 1),
(12, 'w', 1),
(13, 's', 5),
(14, 'ss', 1),
(15, 'tr', 1);
-- --------------------------------------------------------
--
-- Table structure for table `tbl_products`
--
CREATE TABLE `tbl_products` (
`product_id` int(11) NOT NULL auto_increment,
`product_name` varchar(220) default NULL,
`product_code` varchar(50) default NULL,
`pbrand` varchar(50) NOT NULL,
`cat_id` int(11) default NULL,
`cat_links` varchar(70) default NULL,
`colour_ids` varchar(120) default NULL,
`size_ids` text,
`pprice` decimal(11,2) NOT NULL,
`discount_price` decimal(11,2) default '0.00',
`pic1` varchar(200) default NULL,
`pic2` varchar(200) default NULL,
`pic3` varchar(200) default NULL,
`pic4` varchar(200) default NULL,
`description` text,
`is_feature` enum('0','1') NOT NULL default '0' COMMENT '0=no,1=yes',
`is_popular_product` enum('1','0') NOT NULL default '0',
`status` enum('0','1','2') NOT NULL default '1' COMMENT '1=active,0=inactive,2=deleted',
`cat_status` enum('0','1','2') default NULL,
`recive_date` datetime default NULL,
PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `tbl_products`
--
INSERT INTO `tbl_products` (`product_id`, `product_name`, `product_code`, `pbrand`, `cat_id`, `cat_links`, `colour_ids`, `size_ids`, `pprice`, `discount_price`, `pic1`, `pic2`, `pic3`, `pic4`, `description`, `is_feature`, `is_popular_product`, `status`, `cat_status`, `recive_date`) VALUES
(1, 'werwere', '4234234', '', 3, '3', '1,4', '2,1', '333.00', '0.00', 'dm-pro1pc0Z.jpg', NULL, NULL, NULL, '
\r\nrewrw we wr er
\r\n', '1', '1', '1', '1', '2011-10-21 05:34:27'),
(2, 'fsdsdfd', 'sdfsdfsdfsdf', '', 3, '3', '1,4', '1', '333.00', '0.00', 'dm-pro3rFoa.jpg', NULL, NULL, NULL, '
\r\neweqw qwew qe qw
\r\n', '1', '1', '1', '1', '2011-10-21 06:14:43'),
(3, 'sdfsfsd sdd', '443', '', 3, '3', '3', '2', '311.00', '0.00', 'dm-pro4PEzK.jpg', NULL, NULL, NULL, '
\r\nrwe r wer r
\r\n', '1', '1', '1', '1', '2011-10-21 06:15:05'),
(4, '@#$%^&***()*()(sdf sdf sdf sdfsd fdf', 'e53454', '', 3, '3', '1', '1', '335.00', '0.00', 'pro-pic2l1Jp.jpg', NULL, NULL, NULL, '
\r\n rw erw rw er e
\r\n', '1', '1', '1', '1', '2011-10-21 06:15:43'),
(5, 'fsdfsdfs', '423423', 'etert et et', 2, '2', '1', '2', '333.00', '0.00', 'dl-pro3nnaM.jpg', NULL, NULL, NULL, '
\r\nf ssdf d
\r\n', '1', '1', '1', '1', '2011-10-29 04:52:20'),
(6, 'dgfgdf', 'dfggdfg', 'ertert rteerteeuutyut', 2, '2', '3,1', '3,2', '34534.00', '0.00', 'dl-pro27Fy1.jpg', NULL, NULL, NULL, '
\r\ngdfgd gfg fdgdf gdfgd fgdf dg ddfgdfdg df
\r\n', '1', '1', '1', '1', '2011-10-29 04:52:47'),
(7, 'df gdf g', 'dfgdfgf g', 'erter tt et e', 2, '2', '1', '2', '5435.00', '0.00', 'dl-pro1Wa5C.jpg', NULL, NULL, NULL, '
\r\ndf gdfg f
\r\n', '1', '1', '1', '1', '2011-10-29 04:53:05'),
(8, 'gdgdgdfgdf', '534534', 'erterttt', 2, '2', '1', '3,2', '454.00', '0.00', 'ds-pro1a0l9.jpg', 'ds-pro226kh.jpg', 'ds-pro3eFUe.jpg', 'ds-pro4jAnk.jpg', '
\r\nda sdassads ds d
\r\n', '0', '0', '1', '1', '2011-10-29 05:40:36'),
(9, 'gdfg', 'dfgdfgdfg', 'tertertert', 2, '2', '3', '3,2', '3434.00', '0.00', 'oct2011c1BQu.jpg', 'oct2011bIbmp.jpg', 'oct2011awM8F.jpg', 'oct2011dSgLg.jpg', '
\r\ndasd asdas dasd asd asdasd asd asd asdas dasd asd asd sd asd asdas das das dasd s asdas d asdas d
\r\n', '0', '0', '1', '1', '2011-10-29 05:43:27'),
(10, 'fsdsdfsdf', '4423424', 'pepsi', 2, '2', '3', '3,2', '345.00', '0.00', 'oct2011bVKrv.jpg', NULL, NULL, NULL, 'r r rwe
\r\n', '0', '0', '1', '1', '2011-10-31 04:41:18');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_search`
--
CREATE TABLE `tbl_search` (
`sl` int(11) NOT NULL auto_increment,
`sys_id` varchar(40) NOT NULL,
`section` varchar(30) NOT NULL,
`fld_key` varchar(40) NOT NULL,
`fld_value` varchar(100) NOT NULL,
`recv_date` datetime NOT NULL,
PRIMARY KEY (`sl`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=44 ;
--
-- Dumping data for table `tbl_search`
--
INSERT INTO `tbl_search` (`sl`, `sys_id`, `section`, `fld_key`, `fld_value`, `recv_date`) VALUES
(8, '2399ec23f68d255174fa8f40cee837f5', 'keyword', 'srch_key', 'erwr', '2011-10-31 08:40:37'),
(9, '2399ec23f68d255174fa8f40cee837f5', 'Price Range', 'prange', 'Select One', '2011-10-31 08:40:37'),
(10, '0707011ab55c01822cadecc830a9cef6', 'Price Range', 'prange', 'Select One', '2011-11-01 10:28:14'),
(22, '0e62fb5315209c8cdf78a24ac7193d2b', 'keyword', 'srch_key', 'cvc', '2011-11-04 06:03:22'),
(23, '8029156ebb6511fe296d6b10e4f8d179', 'keyword', 'srch_key', 'sdffsdf', '2011-11-04 06:11:49'),
(39, '2de9035f2b83c674835f5e5db4b4f2fa', 'Price Range', 'prange', 'Select One', '2011-11-04 06:38:29'),
(40, '38fcffe4714fcfeef9cc5683e928e5ab', 'keyword', 'srch_key', 's', '2011-11-05 06:01:54'),
(41, 'e2c0848b74c283b6b6530624835b96ff', 'keyword', 'srch_key', 'tr', '2011-11-08 04:18:41'),
(42, 'e2c0848b74c283b6b6530624835b96ff', 'Category', 'cat_id', '', '2011-11-08 04:18:41'),
(43, 'e2c0848b74c283b6b6530624835b96ff', 'Price Range', 'prange', '0-100', '2011-11-08 04:18:41');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_size`
--
CREATE TABLE `tbl_size` (
`size_id` int(11) NOT NULL auto_increment,
`size_title` varchar(80) default NULL,
`display_order` int(11) default NULL,
`size_status` enum('0','1','2') NOT NULL default '1',
`recive_date` datetime default NULL,
PRIMARY KEY (`size_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `tbl_size`
--
INSERT INTO `tbl_size` (`size_id`, `size_title`, `display_order`, `size_status`, `recive_date`) VALUES
(1, '10', NULL, '1', '2011-10-21 05:33:45'),
(2, '20', NULL, '1', '2011-10-21 05:33:52'),
(3, '30', NULL, '1', '2011-10-21 05:33:59');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_staticpage`
--
CREATE TABLE `tbl_staticpage` (
`page_id` int(11) NOT NULL auto_increment,
`view_short` enum('Y','N') NOT NULL default 'N',
`pagename` varchar(220) default NULL,
`short_desc` text,
`page_desc` longtext,
`page_status` enum('Active','Inactive') NOT NULL default 'Active',
PRIMARY KEY (`page_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
--
-- Dumping data for table `tbl_staticpage`
--
INSERT INTO `tbl_staticpage` (`page_id`, `view_short`, `pagename`, `short_desc`, `page_desc`, `page_status`) VALUES
(1, 'N', 'About Us', '0', 'About Us', 'Active'),
(2, 'N', 'Contact Us', '0', '3 & 33A, Rama Road Industrial Area, Kirti Nagar,
\r\nNew Delhi - 110015 (India)\r\n\r\n
\r\n Phone : +91-11-47282233, +91-11-47282233
\r\n
\r\n Fax : +91-11-41427820, +91-11-41427820
\r\n
\r\n Email : abc@yahoo.com
\r\n
\r\n', 'Active'),
(3, 'N', 'Login ', NULL, 'fsdfdfsd', 'Active'),
(4, 'N', 'Advanced Search', NULL, 'Advanced Search', 'Active'),
(5, 'N', 'Featured Products', NULL, 'Featured Products', 'Active'),
(6, 'N', 'Popular Products', NULL, 'Popular Products', 'Active'),
(7, 'N', 'Privacy Policy', NULL, 'Privacy Policy', 'Active'),
(8, 'N', 'Terms & Conditions', '0', 'Terms & Conditions', 'Active'),
(9, 'N', 'Edit Account', NULL, 'Edit Account', 'Active'),
(10, 'N', 'Change Password', NULL, 'Change Password', 'Active'),
(11, 'N', 'Order History', NULL, 'Order History', 'Active'),
(12, 'N', 'Wish List', NULL, 'Wish List', 'Active'),
(13, 'N', 'My Account', NULL, 'My Account', 'Active'),
(14, 'N', 'Feedback', NULL, 'Feedback Text', 'Active'),
(15, 'N', 'Order Complete', NULL, 'Order Complete', 'Active');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_testimonial`
--
CREATE TABLE `tbl_testimonial` (
`testimonial_id` int(11) NOT NULL auto_increment,
`title` varchar(255) default NULL,
`name` varchar(255) default NULL,
`poster_email` varchar(100) default NULL,
`description` longtext,
`photo` varchar(255) default NULL,
`post_date` date default NULL,
`status` enum('1','0') NOT NULL default '0',
PRIMARY KEY (`testimonial_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `tbl_testimonial`
--
INSERT INTO `tbl_testimonial` (`testimonial_id`, `title`, `name`, `poster_email`, `description`, `photo`, `post_date`, `status`) VALUES
(1, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor.', 'dfgdfgdg', NULL, '
\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam luctus condimentum iaculis. Proin blandit ullamcorper magna ut fermentum. Mauris placerat, purus ut ullamcorper rhoncus, magna libero imperdiet sapien, ac interdum sapien neque sed tortor. Nullam sed neque nec dui aliquet dictum sagittis et sapien. Phasellus lacinia aliquam nulla, eu suscipit sem ornare a. Vestibulum luctus laoreet molestie. Suspendisse iaculis, purus nec placerat commodo, ipsum sapien mollis massa, ullamcorper dignissim tellus enim vitae metus. Proin eget porta purus. Maecenas pharetra bibendum iaculis. Praesent purus ipsum, dignissim quis venenatis ut, ullamcorper ut enim. Etiam porta convallis enim, consectetur pellentesque leo imperdiet eu. Nam pretium diam vel arcu sodales rhoncus. Duis a lectus leo, id scelerisque nulla. Proin ut consequat odio. Nam ultricies lacus elit.
\r\n
\r\nCum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nullam risus quam, commodo quis posuere vitae, malesuada vel quam. Aenean eu nisl leo, id ultricies purus. In sit amet dolor ac nisi malesuada venenatis ullamcorper id lorem. Proin vitae metus libero. Fusce elementum augue dolor, at ornare arcu. Nunc interdum massa nec lectus congue porttitor. Donec eget sem enim. Donec sed tempus dui. Donec non tellus nisi. Donec quam tellus, egestas ut mattis eget, gravida nec eros. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed vel condimentum odio. Sed porttitor dui et mi posuere vulputate. Quisque quis laoreet velit. Quisque quis purus dui. Fusce quis arcu felis. Aliquam eu est ac dui adipiscing ultricies ut a purus. Nunc ligula ipsum, luctus at porta quis, viverra ultrices justo. Nulla rhoncus elementum orci sit amet dictum.
\r\n
\r\nMorbi nunc quam, sollicitudin id hendrerit non, suscipit ac ligula. Praesent sem ligula, semper volutpat cursus ac, ultrices quis ante. Proin rutrum vulputate massa vel lobortis. Etiam viverra, nibh sit amet condimentum luctus, augue ante semper nunc, sed elementum lorem sapien et mi. Vivamus consequat tortor eget mi porttitor tincidunt. Cras tortor quam, mollis eu fermentum hendrerit, congue suscipit libero. Ut nisi lorem, iaculis nec lacinia vitae, fermentum non sapien. Suspendisse potenti. Nulla facilisi. Suspendisse in diam ipsum, et egestas mi. In ut risus sit amet augue commodo mollis. Nam id libero nisl. Phasellus nec erat ac quam pretium venenatis. Duis laoreet mi sit amet odio dictum tincidunt. Cras venenatis mauris sit amet odio bibendum sollicitudin. Vivamus a odio dui, a gravida odio. Morbi nunc quam, sollicitudin id hendrerit non, suscipit ac ligula. Praesent sem ligula, semper volutpat cursus ac, ultrices quis ante. Proin rutrum vulputate massa vel lobortis. Etiam viverra, nibh sit amet condimentum luctus, augue ante semper nunc, sed elementum lorem sapien et mi. Vivamus consequat tortor eget mi porttitor tincidunt. Cras tortor quam, mollis eu fermentum hendrerit, congue suscipit libero. Ut nisi lorem, iaculis nec lacinia vitae, fermentum non sapien. Suspendisse potenti. Nulla facilisi. Suspendisse in diam ipsum, et egestas mi. In ut risus sit amet augue commodo mollis. Nam id libero nisl. Phasellus nec erat ac quam pretium venenatis. Duis laoreet mi sit amet odio dictum tincidunt. Cras venenatis mauris sit amet odio bibendum sollicitudin. Vivamus a odio dui, a gravida odio. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam luctus condimentum iaculis. Proin blandit ullamcorper magna ut fermentum. Mauris placerat, purus ut ullamcorper rhoncus, magna libero imperdiet sapien, ac interdum sapien neque sed tortor. Nullam sed neque nec dui aliquet dictum sagittis et sapien. Phasellus lacinia aliquam nulla, eu suscipit sem ornare a. Vestibulum luctus laoreet molestie. Suspendisse iaculis, purus nec placerat commodo, ipsum sapien mollis massa, ullamcorper dignissim tellus enim vitae metus. Proin eget porta purus. Maecenas pharetra bibendum iaculis. Praesent purus ipsum, dignissim quis venenatis ut, ullamcorper ut enim. Etiam porta convallis enim, consectetur p ellentesque leo imperdiet eu. Nam pretium diam vel arcu sodales rhoncus. Duis a lectus leo, id scelerisque nulla. Proin ut consequat odio. Nam ultricies lacus elit.
\r\n
\r\nCum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nullam risus quam, commodo quis posuere vitae, malesuada vel quam. Aenean eu nisl leo, id ultricies purus. In sit amet dolor ac nisi malesuada venenatis ullamcorper id lorem. Proin vitae metus libero. Fusce elementum augue dolor, at ornare arcu. Nunc interdum massa nec lectus congue porttitor. Donec eget sem enim. Donec sed tempus dui. Donec non tellus nisi. Donec quam tellus, egestas ut mattis eget, gravida nec eros. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed vel condimentum odio. Sed porttitor dui et mi posuere vulputate. Quisque quis laoreet velit. Quisque quis purus dui. Fusce quis arcu felis. Aliquam eu est ac dui adipiscing ultricies ut a purus. Nunc ligula ipsum, luctus at porta quis, viverra ultrices justo. Nulla rhoncus elementum orci sit amet dictum.
', NULL, '2011-10-24', '1'),
(2, 'sdffsd fsdf sdfsd fsd fsdf sdf sdf sdfsd fsd fsdf sdf sd', 'sdfsdfsd fsd fdfsdfsfsdfsdf', NULL, '
\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam luctus condimentum iaculis. Proin blandit ullamcorper magna ut fermentum. Mauris placerat, purus ut ullamcorper rhoncus, magna libero imperdiet sapien, ac interdum sapien neque sed tortor. Nullam sed neque nec dui aliquet dictum sagittis et sapien. Phasellus lacinia aliquam nulla, eu suscipit sem ornare a. Vestibulum luctus laoreet molestie. Suspendisse iaculis, purus nec placerat commodo, ipsum sapien mollis massa, ullamcorper dignissim tellus enim vitae metus. Proin eget porta purus. Maecenas pharetra bibendum iaculis. Praesent purus ipsum, dignissim quis venenatis ut, ullamcorper ut enim. Etiam porta convallis enim, consectetur pellentesque leo imperdiet eu. Nam pretium diam vel arcu sodales rhoncus. Duis a lectus leo, id scelerisque nulla. Proin ut consequat odio. Nam ultricies lacus elit.
\r\n
\r\nCum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nullam risus quam, commodo quis posuere vitae, malesuada vel quam. Aenean eu nisl leo, id ultricies purus. In sit amet dolor ac nisi malesuada venenatis ullamcorper id lorem. Proin vitae metus libero. Fusce elementum augue dolor, at ornare arcu. Nunc interdum massa nec lectus congue porttitor. Donec eget sem enim. Donec sed tempus dui. Donec non tellus nisi. Donec quam tellus, egestas ut mattis eget, gravida nec eros. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed vel condimentum odio. Sed porttitor dui et mi posuere vulputate. Quisque quis laoreet velit. Quisque quis purus dui. Fusce quis arcu felis. Aliquam eu est ac dui adipiscing ultricies ut a purus. Nunc ligula ipsum, luctus at porta quis, viverra ultrices justo. Nulla rhoncus elementum orci sit amet dictum.
\r\n
\r\nMorbi nunc quam, sollicitudin id hendrerit non, suscipit ac ligula. Praesent sem ligula, semper volutpat cursus ac, ultrices quis ante. Proin rutrum vulputate massa vel lobortis. Etiam viverra, nibh sit amet condimentum luctus, augue ante semper nunc, sed elementum lorem sapien et mi. Vivamus consequat tortor eget mi porttitor tincidunt. Cras tortor quam, mollis eu fermentum hendrerit, congue suscipit libero. Ut nisi lorem, iaculis nec lacinia vitae, fermentum non sapien. Suspendisse potenti. Nulla facilisi. Suspendisse in diam ipsum, et egestas mi. In ut risus sit amet augue commodo mollis. Nam id libero nisl. Phasellus nec erat ac quam pretium venenatis. Duis laoreet mi sit amet odio dictum tincidunt. Cras venenatis mauris sit amet odio bibendum sollicitudin. Vivamus a odio dui, a gravida odio. Morbi nunc quam, sollicitudin id hendrerit non, suscipit ac ligula. Praesent sem ligula, semper volutpat cursus ac, ultrices quis ante. Proin rutrum vulputate massa vel lobortis. Etiam viverra, nibh sit amet condimentum luctus, augue ante semper nunc, sed elementum lorem sapien et mi. Vivamus consequat tortor eget mi porttitor tincidunt. Cras tortor quam, mollis eu fermentum hendrerit, congue suscipit libero. Ut nisi lorem, iaculis nec lacinia vitae, fermentum non sapien. Suspendisse potenti. Nulla facilisi. Suspendisse in diam ipsum, et egestas mi. In ut risus sit amet augue commodo mollis. Nam id libero nisl. Phasellus nec erat ac quam pretium venenatis. Duis laoreet mi sit amet odio dictum tincidunt. Cras venenatis mauris sit amet odio bibendum sollicitudin. Vivamus a odio dui, a gravida odio. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam luctus condimentum iaculis. Proin blandit ullamcorper magna ut fermentum. Mauris placerat, purus ut ullamcorper rhoncus, magna libero imperdiet sapien, ac interdum sapien neque sed tortor. Nullam sed neque nec dui aliquet dictum sagittis et sapien. Phasellus lacinia aliquam nulla, eu suscipit sem ornare a. Vestibulum luctus laoreet molestie. Suspendisse iaculis, purus nec placerat commodo, ipsum sapien mollis massa, ullamcorper dignissim tellus enim vitae metus. Proin eget porta purus. Maecenas pharetra bibendum iaculis. Praesent purus ipsum, dignissim quis venenatis ut, ullamcorper ut enim. Etiam porta convallis enim, consectetur p ellentesque leo imperdiet eu. Nam pretium diam vel arcu sodales rhoncus. Duis a lectus leo, id scelerisque nulla. Proin ut consequat odio. Nam ultricies lacus elit.
\r\n
\r\nCum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nullam risus quam, commodo quis posuere vitae, malesuada vel quam. Aenean eu nisl leo, id ultricies purus. In sit amet dolor ac nisi malesuada venenatis ullamcorper id lorem. Proin vitae metus libero. Fusce elementum augue dolor, at ornare arcu. Nunc interdum massa nec lectus congue porttitor. Donec eget sem enim. Donec sed tempus dui. Donec non tellus nisi. Donec quam tellus, egestas ut mattis eget, gravida nec eros. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed vel condimentum odio. Sed porttitor dui et mi posuere vulputate. Quisque quis laoreet velit. Quisque quis purus dui. Fusce quis arcu felis. Aliquam eu est ac dui adipiscing ultricies ut a purus. Nunc ligula ipsum, luctus at porta quis, viverra ultrices justo. Nulla rhoncus elementum orci sit amet dictum.
', NULL, '2011-10-24', '1'),
(3, 'eqweweqweq e qe', 'adadas', NULL, '
\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam luctus condimentum iaculis. Proin blandit ullamcorper magna ut fermentum. Mauris placerat, purus ut ullamcorper rhoncus, magna libero imperdiet sapien, ac interdum sapien neque sed tortor. Nullam sed neque nec dui aliquet dictum sagittis et sapien. Phasellus lacinia aliquam nulla, eu suscipit sem ornare a. Vestibulum luctus laoreet molestie. Suspendisse iaculis, purus nec placerat commodo, ipsum sapien mollis massa, ullamcorper dignissim tellus enim vitae metus. Proin eget porta purus. Maecenas pharetra bibendum iaculis. Praesent purus ipsum, dignissim quis venenatis ut, ullamcorper ut enim. Etiam porta convallis enim, consectetur pellentesque leo imperdiet eu. Nam pretium diam vel arcu sodales rhoncus. Duis a lectus leo, id scelerisque nulla. Proin ut consequat odio. Nam ultricies lacus elit.
\r\n
\r\nCum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nullam risus quam, commodo quis posuere vitae, malesuada vel quam. Aenean eu nisl leo, id ultricies purus. In sit amet dolor ac nisi malesuada venenatis ullamcorper id lorem. Proin vitae metus libero. Fusce elementum augue dolor, at ornare arcu. Nunc interdum massa nec lectus congue porttitor. Donec eget sem enim. Donec sed tempus dui. Donec non tellus nisi. Donec quam tellus, egestas ut mattis eget, gravida nec eros. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed vel condimentum odio. Sed porttitor dui et mi posuere vulputate. Quisque quis laoreet velit. Quisque quis purus dui. Fusce quis arcu felis. Aliquam eu est ac dui adipiscing ultricies ut a purus. Nunc ligula ipsum, luctus at porta quis, viverra ultrices justo. Nulla rhoncus elementum orci sit amet dictum.
\r\n
\r\nMorbi nunc quam, sollicitudin id hendrerit non, suscipit ac ligula. Praesent sem ligula, semper volutpat cursus ac, ultrices quis ante. Proin rutrum vulputate massa vel lobortis. Etiam viverra, nibh sit amet condimentum luctus, augue ante semper nunc, sed elementum lorem sapien et mi. Vivamus consequat tortor eget mi porttitor tincidunt. Cras tortor quam, mollis eu fermentum hendrerit, congue suscipit libero. Ut nisi lorem, iaculis nec lacinia vitae, fermentum non sapien. Suspendisse potenti. Nulla facilisi. Suspendisse in diam ipsum, et egestas mi. In ut risus sit amet augue commodo mollis. Nam id libero nisl. Phasellus nec erat ac quam pretium venenatis. Duis laoreet mi sit amet odio dictum tincidunt. Cras venenatis mauris sit amet odio bibendum sollicitudin. Vivamus a odio dui, a gravida odio. Morbi nunc quam, sollicitudin id hendrerit non, suscipit ac ligula. Praesent sem ligula, semper volutpat cursus ac, ultrices quis ante. Proin rutrum vulputate massa vel lobortis. Etiam viverra, nibh sit amet condimentum luctus, augue ante semper nunc, sed elementum lorem sapien et mi. Vivamus consequat tortor eget mi porttitor tincidunt. Cras tortor quam, mollis eu fermentum hendrerit, congue suscipit libero. Ut nisi lorem, iaculis nec lacinia vitae, fermentum non sapien. Suspendisse potenti. Nulla facilisi. Suspendisse in diam ipsum, et egestas mi. In ut risus sit amet augue commodo mollis. Nam id libero nisl. Phasellus nec erat ac quam pretium venenatis. Duis laoreet mi sit amet odio dictum tincidunt. Cras venenatis mauris sit amet odio bibendum sollicitudin. Vivamus a odio dui, a gravida odio. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Etiam luctus condimentum iaculis. Proin blandit ullamcorper magna ut fermentum. Mauris placerat, purus ut ullamcorper rhoncus, magna libero imperdiet sapien, ac interdum sapien neque sed tortor. Nullam sed neque nec dui aliquet dictum sagittis et sapien. Phasellus lacinia aliquam nulla, eu suscipit sem ornare a. Vestibulum luctus laoreet molestie. Suspendisse iaculis, purus nec placerat commodo, ipsum sapien mollis massa, ullamcorper dignissim tellus enim vitae metus. Proin eget porta purus. Maecenas pharetra bibendum iaculis. Praesent purus ipsum, dignissim quis venenatis ut, ullamcorper ut enim. Etiam porta convallis enim, consectetur p ellentesque leo imperdiet eu. Nam pretium diam vel arcu sodales rhoncus. Duis a lectus leo, id scelerisque nulla. Proin ut consequat odio. Nam ultricies lacus elit.
\r\n
\r\nCum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Nullam risus quam, commodo quis posuere vitae, malesuada vel quam. Aenean eu nisl leo, id ultricies purus. In sit amet dolor ac nisi malesuada venenatis ullamcorper id lorem. Proin vitae metus libero. Fusce elementum augue dolor, at ornare arcu. Nunc interdum massa nec lectus congue porttitor. Donec eget sem enim. Donec sed tempus dui. Donec non tellus nisi. Donec quam tellus, egestas ut mattis eget, gravida nec eros. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed vel condimentum odio. Sed porttitor dui et mi posuere vulputate. Quisque quis laoreet velit. Quisque quis purus dui. Fusce quis arcu felis. Aliquam eu est ac dui adipiscing ultricies ut a purus. Nunc ligula ipsum, luctus at porta quis, viverra ultrices justo. Nulla rhoncus elementum orci sit amet dictum.
', NULL, '2011-10-24', '1'),
(4, 'erterter', 'ertrertrrtert', '0', 'er t ert ert erert er', NULL, '2011-10-24', '1'),
(5, 'rewe', 'sdfsdfsdf', '0', 'werwe', NULL, '2011-10-24', '1');
-- --------------------------------------------------------
--
-- Table structure for table `tbl_wishlist`
--
CREATE TABLE `tbl_wishlist` (
`id` int(11) NOT NULL auto_increment,
`mem_id` int(11) NOT NULL,
`product_id` int(11) NOT NULL,
`add_date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `tbl_wishlist`
--
INSERT INTO `tbl_wishlist` (`id`, `mem_id`, `product_id`, `add_date`) VALUES
(1, 3, 6, '2011-10-29'),
(4, 3, 1, '2011-11-04'),
(6, 3, 9, '2011-11-04');