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




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

--
-- Table structure for table `banner`
--

CREATE TABLE IF NOT EXISTS `banner` (
  `banner1` text NOT NULL,
  `banner2` text NOT NULL,
  `banner3` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `banner`
--

INSERT INTO `banner` (`banner1`, `banner2`, `banner3`) VALUES
('1.jpg', '2.jpg', '3.jpg');

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

--
-- Table structure for table `category`
--

CREATE TABLE IF NOT EXISTS `category` (
`catid` int(11) NOT NULL,
  `Cat_Name` varchar(200) NOT NULL,
  `Photo_link` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`catid`, `Cat_Name`, `Photo_link`) VALUES
(1, 'Pulses', 'pulses.png'),
(2, 'Rice', '6317791498805062.jpg'),
(3, 'Atta & Others', '5023551498803627.jpg'),
(4, 'Ghee & Vanaspati', '7252531498805881.jpg'),
(5, 'Spices', '6882661498804920.jpg'),
(6, 'Dry Fruits & Nuts', '5630841498804247.jpg'),
(7, 'Edible Oils', '7138701498804789.jpg'),
(8, 'Fresh Fruits', 'fruits.jpg'),
(9, 'Snacks', '5214591498805168.jpg'),
(10, 'Beverages', '6058391498805453.jpg'),
(11, 'Sauces & Jams', '8887041498809389.jpg'),
(12, 'vegetables', '6926001498809602.jpg'),
(13, 'Pasta & Noodles', '6353801498809822.jpg'),
(14, 'Namkeen', '9451611498810158.jpg'),
(15, 'Kitchen Items', 'kitchen.jpg'),
(16, 'Personal Care', '8546771498809506.png'),
(17, 'Household Needs', '3957581498809246.jpg'),
(18, 'Electronics', '547581498803830.jpg'),
(24, 'Breakfast & Dairy', '6874731499677348.png'),
(25, 'Baby & Kids', '7015411499677448.png'),
(26, 'Pet Care', '1568991499677557.png'),
(27, 'Meats & Seafood', '7110321499677940.png'),
(28, 'Organic & Gourmet', '1879351499678035.png'),
(29, 'Biscuits & Chocolates', '3920651499678182.jpg'),
(30, 'Coffee Corner', '3365851499679362.png'),
(31, 'Tea Stall', '8606581499679558.jpg'),
(32, 'Dish Wash', '7820761499679876.jpg'),
(33, 'Gluten Free Foods', '3315491499680592.jpg'),
(34, 'Milk', '7649261499680950.png'),
(35, 'Bakery', '1253141499681567.jpg'),
(36, 'Click here for latest job in smart ', '9900211499864752.jpg');

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

--
-- Table structure for table `members`
--

CREATE TABLE IF NOT EXISTS `members` (
`membershipno` int(11) NOT NULL,
  `name` varchar(32) NOT NULL,
  `dob` text NOT NULL,
  `email` varchar(64) NOT NULL,
  `address` text NOT NULL,
  `city` varchar(32) NOT NULL,
  `pincode` int(11) NOT NULL,
  `state` varchar(32) NOT NULL,
  `phone` varchar(12) NOT NULL,
  `date_created` date NOT NULL,
  `payment` varchar(10) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`membershipno`, `name`, `dob`, `email`, `address`, `city`, `pincode`, `state`, `phone`, `date_created`, `payment`) VALUES
(6, 'Jj', '', 'jj@jj.com', 'Xbxb', 'Ejrj', 45464664, 'Xbxb', '5555666655', '2017-06-28', 'Not receiv'),
(13, 'Rakesh ', '', 'mgodara216@gmail.com', 'Bsjsjj', 'Bzhsj', 125055, 'Haryana ', '8198989691', '2017-06-29', 'Not receiv'),
(25, 'Rahul ', '', 'mgodara216@gmail.com', 'Fgzhbsb', 'Sirsa ', 125055, 'Haryana ', '8653254678', '2017-07-01', 'Not receiv'),
(26, 'Rajkumar', '', 'Rajgo158godara@gmail.com', 'vpo kasumbhi distt & teh sirsa', 'sirsa', 125055, 'Haryana', '8295480808', '2017-07-08', 'Not receiv'),
(28, 'rajkumar', '', 'rajgo158godara@gmail.com', 'vpo kasumbhi distt & teh sirsa', 'sirsa', 125055, 'Haryana', '9996704001', '2017-07-08', 'success'),
(29, 'Vikas ', '', 'amandeepsheoran05@gmail.com', 'Vpo kasumbhi distt and teh sirsa', 'Sirsa', 125055, 'Haryana', '9416212913', '2017-07-08', 'success'),
(35, 'Ashu mehta', '', 'aashumehta28@gmail.com', 'Sirsa', 'Sirsa', 125055, 'Haryana', '9888056775', '2017-07-09', 'Not receiv'),
(37, 'SANDEEP KUMAR', '', 'fun.insan25@gmail.com', 'ward no1 veer singh mc wali gali Mandi Kalanwali ', 'SIRSA', 125201, 'Haryana', '9050361445', '2017-07-09', 'success'),
(40, 'Rakesh', '', 'msjbt24@gmail.com', 'HOUSE No 96, Street No 3,MITC COLINY', 'Sirsa', 125055, 'Haryana', '9812841179', '2017-07-10', 'failure'),
(41, 'Hanuman godara', '', 'hanumang582@email.com', 'Vpo kasumbhi Sirsa haryana', 'Sirsa', 125055, 'Haryana ', '7015764558', '2017-07-11', 'Not receiv'),
(42, 'Sandeep', '', 'sandeepburawad22@gmail.com', 'Kirti nagar, kanganpur road', 'Sirsa', 125055, 'Haryana', '9729141112', '2017-07-11', 'Not receiv'),
(44, 'Anup Singh', '', 'asbhadu@gmail.com', 'Near Sirsa School, HUDA Boosting Station, Quarter No. 1 Sirsa', 'Sirsa', 125053, 'Haryana', '9729875858', '2017-07-11', 'success'),
(47, 'MAHENDER SINGH', '', 'mspjbt@gmail.com', '# 96,Street 3, MITC COLONY', 'Sirsa', 125055, 'Haryana', '9466555899', '2017-07-12', 'Not receiv'),
(49, 'Rakesh kumar', '', 'godarar951@gmail.com', 'Vpo kasumbhi', 'Sirsa', 125055, 'Haryana', '9466735196', '2017-07-13', 'success'),
(50, 'Sunil kumar soni', '', 'sunil.sony365@gmail.com', '#365, street no. 6A, Aggarsain colony', 'Sirsa', 125055, 'Haryana', '9050171611', '2017-07-13', 'success'),
(52, 'Yash phutela', '', 'lovarora0001@gmail.com', 'Gurdawara wali gali village gobindpura vpo ottu rania', 'Rania', 125055, 'Haryana', '.9068614832', '2017-07-15', 'Not receiv'),
(53, 'Manojlakhlan', '', 'Manojlakhlan93@gamil.com', 'Suchan ', 'Sirsa', 125055, 'Haryana', '8570866093', '2017-07-15', 'Not receiv'),
(56, 'Pawan kumar', '', 'pawanlakhlan66@gmail.com', 'Hn.63suchan kotali', 'Sirsa', 125055, 'Haryana', '8930120022', '2017-07-16', 'failure'),
(57, 'Vinod kumar', '', 'vinodghotter@gmail.com', 'Vpo kagdana sirsa haryana', 'Sirsa haryana', 125110, 'Haryana', '9416265093', '2017-07-16', 'Not receiv'),
(58, 'Jasbir singh', '', 'jasbir.rattan67@gmail.com', 'Modern public school', 'Kalanwali', 125055, 'Haryana', '7876461860', '2017-07-21', 'Not receiv'),
(59, 'Jasbir singh', '', 'jasbir.rattan67@gmail.com', 'Modern public school', 'Kalanwali', 125055, 'Haryana', '7015416512', '2017-07-21', 'Not receiv'),
(60, 'Bharti nathani', '', 'arorab852@gmail.com', '67 b krishna paradise,rau', 'Indore', 453331, 'Madhya pradesh', '9009229917', '2017-07-26', 'Not receiv'),
(61, 'Param', '', 'warwalparam@gmail.com', 'Huda 19 indra colony H no 42/2 ', 'Sirsa', 125055, 'Haryana', '9255611151', '2017-07-28', 'failure'),
(62, 'J fjjhhhg', '', 'fjhcgh', 'Vjvxxgh', 'Sirsa ', 1866959, 'Bbkjjk', '477654', '2017-07-30', 'failure'),
(63, 'Kapil ', '', 'kapilsethi75@gmail.com', 'H.no.700 street no12a aggrsain colony', 'Sirsa', 125055, 'Haryana', '9215200775', '2017-08-17', 'Not receiv');

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

--
-- Table structure for table `order_details`
--

CREATE TABLE IF NOT EXISTS `order_details` (
`id` int(11) NOT NULL,
  `name` varchar(64) NOT NULL,
  `price` float NOT NULL,
  `quantity` int(11) NOT NULL,
  `uniqueId` text NOT NULL,
  `transactionId` text NOT NULL,
  `phone` varchar(12) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_details`
--

INSERT INTO `order_details` (`id`, `name`, `price`, `quantity`, `uniqueId`, `transactionId`, `phone`) VALUES
(3, 'Banana', 85, 2, 'HICPWOwz1w66VvT6FnE1R7nuCSpHIOeAGPUCeuLB', '', '8295571519'),
(4, 'Welcome, This service is going to start from September 1st .You ', 0, 1, 'dDiS21orRVdhxGVNu3pTdnIILLvAWYFDcWqnMtOB', '', '9999999999'),
(5, ' Moong dal', 95, 4, 'dDiS21orRVdhxGVNu3pTdnIILLvAWYFDcWqnMtOB', '', '9999999999'),
(6, 'Name of post-Field assistant ', 0, 1, 'dDiS21orRVdhxGVNu3pTdnIILLvAWYFDcWqnMtOB', '', '9999999999'),
(7, 'Channa dal', 68, -23, 'dDiS21orRVdhxGVNu3pTdnIILLvAWYFDcWqnMtOB', '', '9999999999'),
(8, 'Welcome, This service is going to start from September 1st.You c', 0, 1, 'nTKudh0Fy9rjSqv3q21XQvj1MYXmWoZX64MGIWde', '', '8570055827'),
(9, 'Welcome, This service is going to start from September 1st.You c', 0, 1, 'u81ms3oda8fredouqnBjkdFCA0O3psZTxCzzFLp4', '', '8570055827'),
(10, 'Soyabean', 200, 1, 'EPVgQKLK3sTAkaaAqIg1ARARZqA9aC1vFnmdOWsA', '', '9992790731'),
(11, 'You can register for any posts from 09july to 15 August. You can', 0, 15, 'GbCc54ycFCTc87Ry2SFmdEYf89Jae4oA1FHemu7O', '', '7015160988'),
(12, 'Name of post-Custmor advisor ', 0, 1, 'fJxf59q3hxwILWQwPdfkkzMb3Hdx03Vd6Sh5LDCr', '', '8295571519'),
(13, 'Name of post:-Product manager', 0, 1, 'fJxf59q3hxwILWQwPdfkkzMb3Hdx03Vd6Sh5LDCr', '', '8295571519'),
(14, 'Name of post-e-commerce clerk', 0, 1, 'fJxf59q3hxwILWQwPdfkkzMb3Hdx03Vd6Sh5LDCr', '', '8295571519'),
(15, 'Name of post - Category Marchant manager ', 0, 1, 'fJxf59q3hxwILWQwPdfkkzMb3Hdx03Vd6Sh5LDCr', '', '8295571519'),
(16, 'Name of post-Custmor advisor ', 0, 1, 'QIhvQQ4JJs2gCRzkGj5vv9w49JKBG9azdoSNCOYu', '', '8295571519'),
(17, 'Name of post:-Product manager', 0, 1, 'QIhvQQ4JJs2gCRzkGj5vv9w49JKBG9azdoSNCOYu', '', '8295571519'),
(18, 'Name of post-e-commerce clerk', 0, 1, 'QIhvQQ4JJs2gCRzkGj5vv9w49JKBG9azdoSNCOYu', '', '8295571519'),
(19, 'Name of post - Category Marchant manager ', 0, 1, 'QIhvQQ4JJs2gCRzkGj5vv9w49JKBG9azdoSNCOYu', '', '8295571519'),
(20, 'Urad (black)', 62, 1, 'QNyOFVH17nvLNxqKCG2fbVBaqujMjgd5wU2gTHfS', '', '8295571519');

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

--
-- Table structure for table `product_details`
--

CREATE TABLE IF NOT EXISTS `product_details` (
  `ID` int(11) NOT NULL,
  `Product_Code` varchar(200) NOT NULL,
  `Product_Name` varchar(200) NOT NULL,
  `Price` varchar(1000) NOT NULL,
  `Small_Details` text NOT NULL,
  `Big_Details` text NOT NULL,
  `category` varchar(200) NOT NULL,
  `Photo_Link` text,
  `sub1` text NOT NULL,
  `sub2` text NOT NULL,
  `sub3` text NOT NULL,
  `sub4` text NOT NULL,
  `Addbanner` int(11) NOT NULL,
  `Addgroup` int(11) NOT NULL,
  `best_sellers` varchar(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_details`
--

INSERT INTO `product_details` (`ID`, `Product_Code`, `Product_Name`, `Price`, `Small_Details`, `Big_Details`, `category`, `Photo_Link`, `sub1`, `sub2`, `sub3`, `sub4`, `Addbanner`, `Addgroup`, `best_sellers`) VALUES
(8, '001', 'Welcome, This service is going to start from September 1st .You can register only only now From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advanta', 'Job registration can also be closed before 12augest. Go to underside for post of job', 'For any inquiry ±918295571519 ', '', 'Rice', '3198611499567043.jpg', '', '', '', '', 0, 0, '0'),
(9, '001', 'Welcome, This service is going to start from September 1st .You can now register  only From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage o', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Pulses', '1002891499567232.jpg', '', '', '', '', 0, 0, '0'),
(10, '001', 'Welcome, This service is going to start from September 1st .You can now register  only From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage o', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Atta & Others', '7135961499567292.jpg', '', '', '', '', 0, 0, '0'),
(11, '001', 'Welcome, This service is going to start from September 1st .You can now register  only From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage o', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Ghee & Vanaspati', '1739581499567329.jpg', '', '', '', '', 0, 0, '0'),
(12, '001', 'Welcome, This service is going to start from September 1st .You can now register  only From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage o', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Spices', '7748131499567366.jpg', '', '', '', '', 0, 0, '0'),
(13, '001', 'Welcome, This service is going to start from September 1st.You can register only  now From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage of', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Dry Fruits & Nuts', '2529981499567469.jpg', '', '', '', '', 0, 0, '0'),
(14, '001', 'Welcome, This service is going to start from September 1st.You can register only  now From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage of', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Edible Oils', '6714821499567512.jpg', '', '', '', '', 0, 0, '0'),
(15, '001', 'Welcome, This service is going to start from September 1st.You can register only  now From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage of', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Fresh Fruits', '6460001499567536.jpg', '', '', '', '', 0, 0, '0'),
(16, '001', 'Welcome, This service is going to start from September 1st.You can register only  now From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage of', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Snacks', '403231499567561.jpg', '', '', '', '', 0, 0, '0'),
(17, '001', 'Welcome, This service is going to start from September 1st.You can register only  now From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage of', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Beverages', '7553131499567592.jpg', '', '', '', '', 0, 0, '0'),
(18, '001', 'Welcome, This service is going to start from September 1st.You can register only  now From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage of', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Sauces & Jams', '7367891499567623.jpg', '', '', '', '', 0, 0, '0'),
(19, '001', 'Welcome, This service is going to start from September 1st.You can register only  now From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage of', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'vegetables', '8270281499567653.jpg', '', '', '', '', 0, 0, '0'),
(20, '001', 'Welcome, This service is going to start from September 1st.You can register only  now From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage of', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Pasta & Noodles', '5851181499567681.jpg', '', '', '', '', 0, 0, '0'),
(21, '001', 'Welcome, This service is going to start from September 1st.You can register only  now From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage of', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Namkeen', '7009921499567709.jpg', '', '', '', '', 0, 0, '0'),
(22, '001', 'Welcome, This service is going to start from September 1st.You can register only  now From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage of', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Kitchen Items', '1282741499567744.jpg', '', '', '', '', 0, 0, '0'),
(23, '001', 'Welcome, This service is going to start from September 1st.You can register only  now From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage of', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Personal Care', '5607951499567773.jpg', '', '', '', '', 0, 0, '0'),
(24, '001', 'Welcome, This service is going to start from September 1st.You can register only  now From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage of', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Household Needs', '3779661499567808.jpg', '', '', '', '', 0, 0, '0'),
(25, '', 'Moong sabut', '72', 'It is used as an ingredient in both savory and sweet dishes', '', 'Moong sabut', '7279081499497351.jpg', '5309191499497351.jpg', '5432791499497351.', '6873511499497351.', '2507401499497351.', 0, 0, '0'),
(26, '', 'Channa dal', '68', 'Chana dal recipe with step by step - easy to make healthy everyday dal recipe', '', 'Pulses', '3315801499497497.jpg', '3776311499497498.jpg', '9440621499497498.', '2950511499497498.', '9740301499497498.', 0, 0, '0'),
(27, '', 'Masoor dal', '104', 'masoor dal is another dal that is often made in indian homes', '', 'Pulses', '9678351499497534.jpg', '5894511499497534.jpg', '7045931499497534.', '4270381499497534.', '9076551499497534.', 0, 0, '0'),
(28, '', 'Masoor sabut', '60', 'abut masoor or red lentils cooked with aromatic whole spices and tomatoes to make an wholesome gravy.', '', 'Pulses', '3422611499497583.jpg', '8231221499497583.jpg', '1593401499497583.', '2908391499497583.', '4212401499497583.', 0, 0, '0'),
(29, '', 'Urad (black)', '62', 'These Black urad lentils have been split but not skinned and have creamy white interior', '', 'Pulses', '4943901499497690.jpg', '1396871499497690.jpg', '7111241499497690.', '5451401499497690.', '621431499497690.', 0, 0, '0'),
(30, '', 'Urad (hari) ', '65', 'Hari Urad Dal', '', 'Pulses', '8368241499497828.jpg', '2622751499497828.jpg', '9327101499497828.', '3701231499497828.', '2195201499497828.', 0, 0, '0'),
(31, '', 'Matar dal(desi)', '19', 'Matar dal(desi)', '', 'Pulses', '5380301499497859.jpg', '3027111499497859.jpg', '7620881499497859.', '7565031499497859.', '6321451499497859.', 0, 0, '0'),
(32, '', 'Arhar(special)', '60', 'Arhar(special)', '', 'Pulses', '3543151499497883.jpg', '8401811499497883.jpg', '6594271499497883.', '6289411499497883.', '5402271499497883.', 0, 0, '0'),
(33, '', 'Arhar(special)', '60', 'Arhar(special)', '', 'Pulses', '4172121499497892.jpg', '6178021499497892.jpg', '9042071499497892.', '1070031499497892.', '5079091499497892.', 0, 0, '0'),
(34, '', 'Tuar dal', '92', 'Tuar dal', '', 'Pulses', '5664111499497914.jpeg', '1150291499497914.jpeg', '6483801499497914.', '8310261499497914.', '8490011499497914.', 0, 0, '0'),
(35, '', 'Soyabean', '200', 'Soyabean', '', 'Pulses', '7301361499497934.jpg', '2581251499497934.jpg', '6053201499497934.', '3093331499497934.', '7182951499497934.', 0, 0, '0'),
(36, '', ' Moong dal', '95', ' Moong dal', '', 'Pulses', '5299731499497987.jpg', '5495351499497987.jpg', '2911451499497987.', '5482531499497987.', '5576831499497987.', 0, 0, '0'),
(37, '001', 'Welcome, This service is going to start from September 1st.You can register only  now From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage of', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Electronics', '9255691499567862.jpg', '', '', '', '', 0, 0, '0'),
(38, '001', 'Welcome, This service is going to start from September 1st.You can register only  now From 09 July to 15Augest.which is compulsory for you if you want to apply for job or you want to take advantage of', 'Job registration can also be closed before 12augest', 'For any inquiry ±918295571519 ', '', 'Moong sabut', '9979861499567893.jpg', '', '', '', '', 0, 0, '0'),
(39, '', 'Moth', '35', 'Moth Pulse', '', 'Pulses', '4831291499661826.jpg', '528651499661826.jpg', '5755961499661826.', '5381521499661826.', '7535121499661826.', 0, 0, '0'),
(40, '01', 'You can register for any posts from 09july to 15 August. You can apply for one or more than one posts. ', 'सभी documents डाक के  दà¥वारा मंगवाये जाà¤ंगे जिसकी जानकारी mail तथा  contect number के दà¥वारा दी जाà¤गी ', 'Helpline number +918295571519 ', '', 'Click here for latest job in smart ', '9076551499865577.jpg', '', '', '', '', 0, 0, '0'),
(41, '056c', 'Name of post-Custmor advisor ', '00.Candidate must be registered with smart bazar,     Age-18-32,     Quali-10th,    experience - Null', '10th standard by valid board or management ', '', 'Click here for latest job in smart ', '6055341499873608.jpg', '', '', '', '', 0, 0, '0'),
(42, '079', 'Name of post:-Product manager', '00.Candidate must be registered with smart bazar,        Age-18-28,             Quali-12th with any stream ', 'No any experience ', '', 'Click here for latest job in smart ', '5982401499873740.jpg', '', '', '', '', 0, 0, '0'),
(43, '38L', 'Post name :- Smart Bazar specialist', '00.Candidate must be registered with smart bazar,       Age-18-25,     Quali-graduate,       experience - 1year experience in any e-shooping company ', '3 year degree with experience ', '', 'Click here for latest job in smart ', '1626061499873936.jpg', '', '', '', '', 0, 0, '0'),
(44, '', 'Name of post -  senior vendor manager', '00.Candidate must be registered in advance.    Quali- 10th ,  age-18-30', 'No any experience ', '', 'Click here for latest job in smart ', '4840141499867835.jpg', '8212001499867835.jpg', '5591481499867835.', '2920911499867835.', '5419971499867835.', 0, 0, '0'),
(45, '', 'Name of post-e-commerce clerk', '00.Candidate must be registered in advance,      Quali- 10th,         age-18-25,       exper- knowledge of computer ', '10th standard by valid board or management ', '', 'Click here for latest job in smart ', '4096741499868363.jpg', '2805551499868363.jpg', '9408581499868363.', '9613961499868363.', '3094551499868363.', 0, 0, '0'),
(46, '', 'Name of post :-Senior product manager ', '00.Candidate must be registered in advance,      age:-18-32,      Quali-any degree,    exper-Null', 'No any experience ', '', 'Click here for latest job in smart ', '8089321499868847.jpg', '2531811499868847.jpg', '3476931499868847.', '8839741499868847.', '8859571499868847.', 0, 0, '0'),
(47, '', 'Name of post - Account manager ', '00.Candidate must be registered with smart bazar,    age-18-38,       Quali-12th with commerce,       exper-Null', 'No any experience ', '', 'Click here for latest job in smart ', '7115511499869127.jpg', '1229641499869127.jpg', '9507461499869127.', '4766591499869127.', '1601641499869127.', 0, 0, '0'),
(48, '', 'Name of post - senior marketing manager ', '00.Candidate must be registered with smart bazar,   age-18-28,    Quali-graduate with any degree,    exper-6months exper. In field work ', 'Any degree with 6months experience in field work ', '', 'Click here for latest job in smart ', '8337731499869475.jpg', '9921271499869475.jpg', '2997811499869475.', '9427501499869475.', '9488841499869475.', 0, 0, '0'),
(49, '', 'Name of post -  Digital marketing manager ', '00.Candidate must be registered with smart bazar.     Age-18-30,       Quali-BS/MS degree in marketing or related field,      exper- prove working exper. In marketing ', 'Experience must be compulsory ', '', 'Click here for latest job in smart ', '6858551499872009.jpg', '2283701499872009.jpg', '2214431499872009.', '1382221499872009.', '3014591499872009.', 0, 0, '0'),
(50, '', 'Name of post - Category Marchant manager ', '00.Candidate must be registered with smart bazar.      Age-18-30,   Quali-Degree in business or science or technology or engineering or mathematics,     exper - Other related business experience ', 'Degree in any stream ', '', 'Click here for latest job in smart ', '6413311499872303.jpg', '2970041499872303.jpg', '1869281499872303.', '1729211499872303.', '9429641499872303.', 0, 0, '0'),
(51, '', 'Name of post- Programme manager ', '00.Candidate must be registered with smart bazar,      age-18-40,     Quali-any degree,       exper-Depending on educational background ', 'No any special experience ', '', 'Click here for latest job in smart ', '2378001499872758.jpg', '5461781499872758.jpg', '8939831499872758.', '8520221499872758.', '3875791499872758.', 0, 0, '0'),
(52, '', 'Name of post- register table operator ', '00.Candidate must be registered with smart bazar,    Age-18-38,    Quali-12th.      Experience - Null', 'No any experience ', '', 'Click here for latest job in smart ', '6847261499872874.jpg', '5584151499872874.jpg', '5872541499872874.', '5900921499872874.', '5713241499872874.', 0, 0, '0'),
(53, '', 'Name of post- Store keepar', '00.Candidate must be registered with smart bazar.      AGE-18-45,       Quali - 10th,    experience -  Null', 'No any experience ', '', 'Click here for latest job in smart ', '7599511499872973.jpg', '8674031499872973.jpg', '1890951499872973.', '6747171499872973.', '5923501499872973.', 0, 0, '0'),
(54, '', 'Name of post - peon', '00.Candidate must be registered with smart bazar.       Age-18-45,          Quali-8th', 'No any experience ', '', 'Click here for latest job in smart ', '9112261499873061.jpg', '283301499873061.jpg', '9636541499873061.', '6493571499873061.', '4374751499873061.', 0, 0, '0'),
(55, '', 'Name of post-Field assistant ', '00.Candidate must be registered with smart bazar.        Age-18-30,      Quali-12th,         experience - 2 year experience in field work ', 'Field work experience must be compulsory ', '', 'Click here for latest job in smart ', '4515441499873239.jpg', '9068921499873239.jpg', '247291499873239.', '6648901499873239.', '3024971499873239.', 0, 0, '0'),
(56, '', 'Name of post - Head of smart bazar e-shooping ', '00.Candidate must be registered with smart bazar.       Age-18-40,         Quali-12th,      experience - Best knowledge and minimum one year experience in E-shooping sirsa', 'A best experience is compulsory ', '', 'Click here for latest job in smart ', '4731801499873465.jpg', '3122021499873465.jpg', '3122321499873465.', '9249281499873465.', '1312641499873465.', 0, 0, '0');

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

--
-- Table structure for table `temporder`
--

CREATE TABLE IF NOT EXISTS `temporder` (
`id` int(11) NOT NULL,
  `name` varchar(32) NOT NULL,
  `email` varchar(64) NOT NULL,
  `address` text NOT NULL,
  `city` varchar(32) NOT NULL,
  `pincode` varchar(10) NOT NULL,
  `phone` text NOT NULL,
  `amount` float NOT NULL,
  `uniqueId` text NOT NULL,
  `status` text NOT NULL,
  `txnid` text NOT NULL,
  `discount` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=221 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `temporder`
--

INSERT INTO `temporder` (`id`, `name`, `email`, `address`, `city`, `pincode`, `phone`, `amount`, `uniqueId`, `status`, `txnid`, `discount`) VALUES
(202, 'Xjdj', 'Djdj@dh.com', 'Djdj', 'Rjrj', '2656', '565656565665', 391.5, 'uNdQeqH2MV3onhjCZZ670Ri1YAfi3agrzzySRKy5', 'failure', '33b9422ff436eb562a59', 10),
(206, 'Suman', 'Mgodara216@gmail.com ', 'Kusumbhi sirsa', 'Sirsa', '125055', '8295571519', 170, 'HICPWOwz1w66VvT6FnE1R7nuCSpHIOeAGPUCeuLB', '', 'bd9d2d555c93122312e6', 0),
(207, 'Hdshhs', 'Hdh@hdh.ckm', 'Eyehhshsh', 'Dystsysys', '125056', '9999999999', 0, 'dDiS21orRVdhxGVNu3pTdnIILLvAWYFDcWqnMtOB', '', 'd7889bcc6e9199142223', 0),
(208, 'Hdshhs', 'Hdh@hdh.ckm', 'Eyehhshsh', 'Dystsysys', '125056', '9999999999', 0, 'NXqBt9ueM7AfLXHCYxGwLAM5U0CnJDhZfEyQJWgm', '', 'NXqBt9ueM7AfLXHCYxGwLAM5U0CnJDhZfEyQJWgm', 0),
(209, 'Hdshhs', 'Hdh@hdh.ckm', 'Eyehhshsh', 'Dystsysys', '125056', '9999999999', 0, 'uMWDxTV6i1BOTcplUgzQgzz53EMMbiGUI2uq4Hxp', '', '546245b3e300629999b4', 0),
(210, 'Hdshhs', 'Hdh@hdh.ckm', 'Eyehhshsh', 'Dystsysys', '125056', '9999999999', 0, 'BP3s4Mj87hoqpqpGwuhWfA9wDoZ8S2MFcH6o1gwk', 'Offline Payment', 'BP3s4Mj87hoqpqpGwuhWfA9wDoZ8S2MFcH6o1gwk', 0),
(211, 'Tarun Arora', 'tarunarora758@gmail.com', 'Hn 12 near housing board sirsa', 'Sirsa', '125055', '8570055827', 0, 'nTKudh0Fy9rjSqv3q21XQvj1MYXmWoZX64MGIWde', '', 'nTKudh0Fy9rjSqv3q21XQvj1MYXmWoZX64MGIWde', 0),
(212, 'Tarun Arora', 'tarunarora758@gmail.com', 'Hn 12 near housing board sirsa', 'Sirsa', '125055', '8570055827', 0, 'u81ms3oda8fredouqnBjkdFCA0O3psZTxCzzFLp4', '', '987b4f43e45025f77138', 0),
(213, 'Anil suthar', 'Chinnasuthar7777 @gmail.com', 'Darba kalan (sirsa)', 'Darba kalan', '125110', '9992790731', 200, 'EPVgQKLK3sTAkaaAqIg1ARARZqA9aC1vFnmdOWsA', 'Offline Payment', 'EPVgQKLK3sTAkaaAqIg1ARARZqA9aC1vFnmdOWsA', 0),
(214, 'Desraj', 'Desrajnagar333@gmail.com', 'House no. 26, old tehsil road word no. 8, near railway fatak Kalanwali ', 'Sirsa', '125201', '7015160988', 0, 'GbCc54ycFCTc87Ry2SFmdEYf89Jae4oA1FHemu7O', '', 'acc2e853773e11045dce', 0),
(215, 'Mukesh ', 'Mgodara216@gmail.com ', 'Gghhjj', 'Sirsa', '125055', '8295571519', 0, 'fJxf59q3hxwILWQwPdfkkzMb3Hdx03Vd6Sh5LDCr', '', '9fb39d042ad0608f5b45', 0),
(216, 'Mukesh ', 'Mgodara216@gmail.com ', 'Gghhjj', 'Sirsa', '125055', '8295571519', 0, 'QIhvQQ4JJs2gCRzkGj5vv9w49JKBG9azdoSNCOYu', '', 'QIhvQQ4JJs2gCRzkGj5vv9w49JKBG9azdoSNCOYu', 0),
(217, 'Mukesh ', 'Mgodara216@gmail.com ', 'Gghhjj', 'Sirsa', '125055', '8295571519', 0, 'Bh2e9UDvYjSSwOzH3pIkiP2ImwxEGL5HCngwxu7w', '', 'f383e17341309cd2a73c', 0),
(218, 'Mukesh ', 'Mgodara216@gmail.com ', 'Fjhhh', 'Sirsa ', '125055', '8295571519', 62, 'QNyOFVH17nvLNxqKCG2fbVBaqujMjgd5wU2gTHfS', 'failure', 'e8b6e9d8c8d4fd6fc8b6', 0),
(219, 'Mukesh ', 'Mgodara216@gmail.com ', 'Fjhhh', 'Sirsa ', '125055', '8295571519', 0, '4ptJU4FjznYkmM2WUX3a2SZJuxrNKRGd9y3JU8af', '', '72974c4fe206612f36a9', 0),
(220, 'Mukesh ', 'Mgodara216@gmail.com ', 'Fjhhh', 'Sirsa ', '125055', '8295571519', 0, 'W9yWviwRW6cuRyhiS2JLguX7BYoT1srzYAhwJO2k', '', 'c9114b881a987e34ba3b', 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `category`
--
ALTER TABLE `category`
 ADD UNIQUE KEY `catid` (`catid`);

--
-- Indexes for table `members`
--
ALTER TABLE `members`
 ADD PRIMARY KEY (`membershipno`);

--
-- Indexes for table `order_details`
--
ALTER TABLE `order_details`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_details`
--
ALTER TABLE `product_details`
 ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `temporder`
--
ALTER TABLE `temporder`
 ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
MODIFY `catid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=37;
--
-- AUTO_INCREMENT for table `members`
--
ALTER TABLE `members`
MODIFY `membershipno` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=64;
--
-- AUTO_INCREMENT for table `order_details`
--
ALTER TABLE `order_details`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT for table `temporder`
--
ALTER TABLE `temporder`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=221;
