+-+-+-+-+-+-+-+-+-+-+-+-+
| Join www.h4ckz0ne.net |
+-+-+-+-+-+-+-+-+-+-+-+-+

Site = http://www.hazarnis.com/

-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 29, 2011 at 12:37 PM
-- Server version: 5.5.8
-- PHP Version: 5.3.5

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: `ofrece`
--

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

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

CREATE TABLE IF NOT EXISTS `category` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

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

INSERT INTO `category` (`id`, `name`) VALUES
(1, 'Others'),
(2, 'Appliances'),
(3, 'Computers'),
(4, 'Books'),
(5, 'Music'),
(6, 'Cars'),
(7, 'Electronics '),
(8, 'Clothes'),
(9, 'Travels '),
(10, 'Games'),
(11, 'Health '),
(12, 'Mobiles'),
(13, 'Sports');

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

--
-- Table structure for table `customer`
--

CREATE TABLE IF NOT EXISTS `customer` (
  `email` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `name` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `date1` varchar(50) NOT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` (`email`, `password`, `name`, `phone`, `date1`) VALUES
('', '', '', '', ''),
('a', 'a', 'Ofrece', '9', '03/13/2011'),
('bhagyad@gmail.com', 'ambarish', 'Bhagyashree Deokar', '9819842334', '03/14/2011'),
('bhagyod25@gmail.com', 'iloveamba25', 'bhagyashree', '9819842334', '08/25/1990'),
('chinta@hk.com', 'hohoho', 'chintan', '98898', '02/15/2011'),
('chintan@google.com', 'hahaha', 'chintan', '9820045678', '03/01/2011'),
('dfsdf', 'sdfsdf', 'dsaf', 'sdffsdf', '03/01/2011'),
('dhdhh', 'hdhdh', 'hdhdh', 'hdhdhd', 'hdhd'),
('dsd', '', 's2464', '', ''),
('hazarnis@gmail.com', 'faiiash7', 'Ambarish Hazarnis', '9892717166', '02/09/2011'),
('hazarnisa@gmail.com', 'faiiash7', 'Ambarish Hazarnis', '9892717166', '02/11/2011'),
('hazarnisa@yahoo.com', 'faii', 'Ambarish Hazarnis', '98999', '02/25/2011'),
('hhas@gmkl.com', 'bhagyashree', 'asasa', '98154256', ''),
('HHSH', 'JDJD', 'haha', '988', '03/16/2011'),
('jaja', 'HAHSJSJA', 'jajaj', 'KAKA', '04/01/2011'),
('kshitija_cool25@yahoo.co.in', 'asdfghjkl', 'asas', '', ''),
('ofrece@ofrece.com', 'ofrece', 'Ofrece', '9819989211', '02/28/2011'),
('pawan.sirse@gmail.com', '9869', 'PAWAN SIRSE', '9967338517', '07/01/1990'),
('s', 's', 's', 'ss', '03/28/2011'),
('test', 'test', 'bingo', '9999', '02/28/2011');

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

--
-- Table structure for table `follow`
--

CREATE TABLE IF NOT EXISTS `follow` (
  `shopid` int(10) NOT NULL,
  `customer` varchar(50) NOT NULL,
  PRIMARY KEY (`shopid`),
  KEY `shop_id_2` (`shopid`),
  KEY `customer` (`customer`),
  KEY `customer_2` (`customer`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `follow`
--


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

--
-- Table structure for table `owner`
--

CREATE TABLE IF NOT EXISTS `owner` (
  `email` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(100) NOT NULL,
  `name` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  PRIMARY KEY (`email`),
  KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `owner`
--

INSERT INTO `owner` (`email`, `password`, `name`, `phone`) VALUES
('a1ss@ibibo.com', '123', 'sdasd', '9892717166'),
('aa@gmail.com', '123456', 'akshay', '9819842334'),
('amba_hazarnis7@yahoo.com', '123', 'dsd', '9892717166'),
('bhagy@gmail.com', '123', 'bh122', '9819842334'),
('bhagyod25@gmail.com', '123', 'Bhagyashree', '9819842334'),
('bhagyod25@yahoo.com', 'bhagyo', 'Bhagyashree1', '9819842334'),
('hazarnisa@gmail.com', 'hahaha', 'Ambarish', '987654321'),
('pawan@gmail.com', '555', 'pawan sirse', '1234'),
('shree@gmail.com', 'asd', 'shreya', '981842334'),
('ss@yahoo.com', '123123', 'sachi', '9819842334');

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

--
-- Table structure for table `shop`
--

CREATE TABLE IF NOT EXISTS `shop` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `owner_email` varchar(50) NOT NULL DEFAULT 'pawan@gmail.com',
  `email` varchar(100) NOT NULL,
  `website` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `latitude` float NOT NULL,
  `longitude` float NOT NULL,
  `street` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `country` varchar(100) NOT NULL,
  `zip` bigint(20) NOT NULL,
  `page_info` text NOT NULL,
  `start` varchar(50) NOT NULL,
  `end` varchar(50) NOT NULL,
  `sphone` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `owner_email` (`owner_email`),
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=741853 ;

--
-- Dumping data for table `shop`
--

INSERT INTO `shop` (`id`, `owner_email`, `email`, `website`, `name`, `latitude`, `longitude`, `street`, `city`, `state`, `country`, `zip`, `page_info`, `start`, `end`, `sphone`) VALUES
(1, 'pawan@gmail.com', 'ofrece@ofrece.com', '', '', 0, 0, '', 'Vidyavihar', 'Maharashtra', 'India', 0, '', '', '', ''),
(2, 'pawan@gmail.com', 'xyxy', 'fghfgh', 'fhfgh', 456, 456, 'tyut', 'tyutyu', 'tyuyu', 'ytuytu', 789, 'uiuiuiuiiui', '', '', ''),
(3, 'pawan@gmail.com', 'ofrece@ofrece.com', '', '', 0, 0, '', '', 'Bihar', 'India', 0, '', '', '', ''),
(4, 'pawan@gmail.com', '', 'reef', 'Ambo', 0, 0, 'Station', 'Thane', 'Maharashtra', 'India', 400602, 'ffsdd', '01:46:36', '01:46:38', '3234443434'),
(5, 'pawan@gmail.com', 'ofrece@ofrece.com', '', '', 0, 0, 'wsw', 'Thane', 'Maharashtra', 'India', 0, '', '', '', ''),
(6, 'pawan@gmail.com', 'ofrece@ofrece.com', '', '', 0, 0, 'ajs', 'Thane', 'Maharashtra', 'India', 0, '', '', '', ''),
(7, 'pawan@gmail.com', 'pawan_sirse@gmail.com', '', 'PAWAN ', 0, 0, 'RUTU-PARK', 'THANE', 'Maharashtra', 'India', 400601, '', '10:00:00', '22:00:56', '9967338517'),
(8, 'pawan@gmail.com', 'hazarnis@gmail.com', 'www.ofrece.com', 'Ambo', 0, 0, 'Makhamali Talao', 'Thane', 'Maharashtra', 'India', 400601, 'Best shop.', '07:00:00', '22:00:00', '25394971'),
(9, 'pawan@gmail.com', '', 'www.mango.com', 'Mango', 19.1858, 72.9751, 'Station', 'Thane', 'Maharastra', 'India', 400602, 'Stationery .', '10:00:00', '22:00:00', '8373738383'),
(10, 'pawan@gmail.com', 'hazarnis@gmail.com', 'www.ofrece.com', 'Ambooo', 0, 0, 'Makhamali Talao', 'Thane', 'Maharashtra', 'India', 400601, 'Best Shop.', '02:42:52', '02:42:54', '25394971'),
(11, 'pawan@gmail.com', 'bhagyad@gmail.com', 'www.bhagya.com', 'Bhagya Stores', 0, 0, 'Lokppuram', 'Thane', 'Maharashtra', 'India', 78676, 'I m Bhagya .', '14:28:00', '22:00:00', '9897776655'),
(12, 'pawan@gmail.com', 'ofrece@ofrece.com', 'www.ofrece.com', 'Ofrece', 0, 0, 'Station', 'Vidyavihar', 'Maharashtra', 'India', 400609, 'Ofrece Rocks !!!', '11:16:00', '22:00:00', '7888928282'),
(13, 'pawan@gmail.com', 'chintan@google.com', 'wohlig.com', 'Wohlig', 0, 0, 'sion', 'mumbai', 'Maharashtra', 'India', 400022, 'hi!!!!!!', '09:00:00', '22:00:00', '9820045678'),
(14, 'pawan@gmail.com', 'ofrece@ofrece.com', '', '', 0, 0, 'Makhamali', 'Thane', 'Maharashtra', 'India', 0, '', '', '', ''),
(147, 'shree@gmail.com', 'shree@gmail.com', 'www.la.com', 'varsha', 1200, 2544, 'Pokharan Road', 'Thane', 'Maharashtra', 'India', 400601, 'best site', '10:00:00', '18:00:00', '9820141250'),
(753, 'ss@yahoo.com', 'ss@yahoo.com', 'www.asw.com', 'hemant', 1200, 2544, 'asassa', 'rtt', 'Assam', 'India', 789654, 'sasasasassdsds', '12:00:00', '20:00:00', '9833530663'),
(789, 'bhagy@gmail.com', 'bhagy@gmail.com', 'www.ogg.com', 'Bhagyashree', 1200, 2544, 'glady alwaris road', 'Thane', 'Auto Complete', 'India', 4000607, 'best', '05:00:00', '11:00:00', '21716040'),
(896, 'bhagyod25@gmail.com', 'bhagyod25@gmail.com', 'www.westside.com', 'Atharva Deokar', 1200, 2544, 'haaaa road', 'xyz', 'Andaman and Nicobar Islands', 'India', 400607, 'asasass', '08:00:00', '18:00:00', '21716010'),
(7845, 'amba_hazarnis7@yahoo.com', 'amba_hazarnis7@yahoo.com', '1212121sadasd', 'wewe', 1200, 2544, 'treas', 'kashmir', 'Jammu and Kashmir', 'India', 485666, 'adadasdd', '07:00:00', '16:00:00', '21716040'),
(123645, 'bhagyod25@yahoo.com', 'bhagyod25@yahoo.com', 'www.jq.com', 'wer', 1200, 2544, 'raheja street', 'qwe', 'Madhya Pradesh', 'India', 400601, 'sdadasd', '09:00:00', '20:00:00', '21716010'),
(741852, 'aa@gmail.com', 'aa@gmail.com', 'www.lpa.com', 'ROCK', 1200, 2544, 'Sundarban', 'kashmir', 'Jammu and Kashmir', 'India', 485722, 'asddddd', '10:00:00', '20:00:00', '8956478');

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

--
-- Table structure for table `shop_cat`
--

CREATE TABLE IF NOT EXISTS `shop_cat` (
  `shopid` int(10) NOT NULL DEFAULT '0',
  `catid` int(10) NOT NULL DEFAULT '0',
  `cat_status` varchar(150) NOT NULL DEFAULT 'Coming Soon' COMMENT 'Status of shops acc to their categories',
  KEY `catid` (`catid`),
  KEY `shopid` (`shopid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `shop_cat`
--

INSERT INTO `shop_cat` (`shopid`, `catid`, `cat_status`) VALUES
(147, 10, '60 % off on 2 games');