-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 27, 2010 at 04:21 AM
-- Server version: 5.1.36
-- PHP Version: 5.3.0

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

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

--
-- Table structure for table `admin_user`
--

CREATE TABLE IF NOT EXISTS `admin_user` (
  `adminid` int(11) NOT NULL AUTO_INCREMENT,
  `admin_username` varchar(50) NOT NULL,
  `admin_pwd` varchar(50) NOT NULL,
  PRIMARY KEY (`adminid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin_user`
--

INSERT INTO `admin_user` (`adminid`, `admin_username`, `admin_pwd`) VALUES
(1, 'admin123', 'e10adc3949ba59abbe56e057f20f883e');

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

--
-- Table structure for table `ad_category`
--

CREATE TABLE IF NOT EXISTS `ad_category` (
  `adcid` bigint(20) NOT NULL AUTO_INCREMENT,
  `ad_catname` varchar(50) NOT NULL,
  PRIMARY KEY (`adcid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;

--
-- Dumping data for table `ad_category`
--

INSERT INTO `ad_category` (`adcid`, `ad_catname`) VALUES
(1, 'Adult'),
(2, 'Alumni'),
(3, 'Apparel'),
(4, 'Associations'),
(5, 'Business'),
(6, 'Christian'),
(7, 'Clubs_Nightlife'),
(8, 'Computers'),
(9, 'Culture_Society'),
(10, 'Education'),
(11, 'Finance'),
(12, 'Gaming'),
(13, 'Giants'),
(14, 'Health_Wellness'),
(15, 'Hindu'),
(16, 'Horoscope'),
(17, 'Humour'),
(18, 'Insurance'),
(19, 'Jain'),
(20, 'Jobs'),
(21, 'Leisure'),
(22, 'Lions'),
(23, 'Mobile'),
(24, 'Movies'),
(25, 'Multi Level Marketing'),
(26, 'Music'),
(27, 'Muslim'),
(28, 'News'),
(29, 'Others'),
(30, 'Parents_Staff'),
(31, 'Personal'),
(32, 'Politics'),
(33, 'Real Estate'),
(34, 'Religion_Spirituality'),
(35, 'Retail'),
(36, 'Revisit'),
(37, 'Rotary'),
(38, 'Sikh'),
(39, 'Sports'),
(40, 'Students'),
(41, 'Technology'),
(42, 'Travel');

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

--
-- Table structure for table `ad_circle`
--

CREATE TABLE IF NOT EXISTS `ad_circle` (
  `ad_circleid` bigint(20) NOT NULL AUTO_INCREMENT,
  `adid` bigint(20) NOT NULL,
  `cid` bigint(20) NOT NULL,
  PRIMARY KEY (`ad_circleid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `ad_circle`
--

INSERT INTO `ad_circle` (`ad_circleid`, `adid`, `cid`) VALUES
(1, 1, 11),
(2, 2, 11);

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

--
-- Table structure for table `ad_details`
--

CREATE TABLE IF NOT EXISTS `ad_details` (
  `adid` bigint(20) NOT NULL AUTO_INCREMENT,
  `placement_type` int(11) NOT NULL DEFAULT '0',
  `ad_eid` bigint(20) NOT NULL,
  `ad_text` varchar(160) NOT NULL,
  `ad_budget` bigint(20) NOT NULL,
  `zid` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `adcid` bigint(20) NOT NULL,
  `dayofweek` varchar(30) NOT NULL,
  `startdate` datetime NOT NULL,
  `enddate` datetime NOT NULL,
  `hourofday` varchar(50) NOT NULL,
  `datecreated` date NOT NULL,
  `adstatus` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`adid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `ad_details`
--

INSERT INTO `ad_details` (`adid`, `placement_type`, `ad_eid`, `ad_text`, `ad_budget`, `zid`, `cid`, `adcid`, `dayofweek`, `startdate`, `enddate`, `hourofday`, `datecreated`, `adstatus`) VALUES
(1, 0, 1, 'Attend workshop on programing methodogies, Town Hall, Bangalore on Saturday 31st July', 2000, 4, 11, 8, '6,7', '2010-07-16 13:33:00', '2010-07-30 13:33:03', '9,12,15,18,21', '2010-07-16', 1),
(2, 1, 2, '40% discount on crocodile tshirts at Total Mall, Bangalore. Offer closes  on Sunday', 5000, 4, 11, 3, '1,2,3,4,5,6,7', '2010-07-16 13:35:58', '2010-07-18 13:36:01', '9,12,15,18', '2010-07-16', 1);

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

--
-- Table structure for table `banks`
--

CREATE TABLE IF NOT EXISTS `banks` (
  `bankid` bigint(20) NOT NULL AUTO_INCREMENT,
  `bankname` varchar(100) NOT NULL,
  PRIMARY KEY (`bankid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` (`bankid`, `bankname`) VALUES
(1, 'State Bank of India'),
(2, 'ICICI Bank'),
(3, 'HDFC Bank'),
(4, 'Bank of India'),
(5, 'Central Bank of India'),
(6, 'Standard Chartered Bank'),
(7, 'HSBC'),
(8, 'Punjab National Bank');

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

--
-- Table structure for table `bulkmsg_numbers`
--

CREATE TABLE IF NOT EXISTS `bulkmsg_numbers` (
  `bmid` bigint(20) NOT NULL,
  `phone_number` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bulkmsg_numbers`
--


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

--
-- Table structure for table `bulk_msg`
--

CREATE TABLE IF NOT EXISTS `bulk_msg` (
  `bmid` bigint(20) NOT NULL AUTO_INCREMENT,
  `eid` bigint(20) NOT NULL,
  `msgtype` int(4) NOT NULL,
  `send_option` int(4) NOT NULL,
  `transid` bigint(20) NOT NULL,
  `upload_filename` varchar(100) NOT NULL,
  `send_datetime` datetime NOT NULL,
  `mgid` bigint(20) NOT NULL,
  `upload_datetime` datetime NOT NULL,
  PRIMARY KEY (`bmid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `bulk_msg`
--


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

--
-- Table structure for table `bulk_msg_response`
--

CREATE TABLE IF NOT EXISTS `bulk_msg_response` (
  `bmid` bigint(20) NOT NULL,
  `phone_number` bigint(20) NOT NULL,
  `sent_status` varchar(50) NOT NULL,
  `sent_datetime` datetime NOT NULL,
  `status_msg` int(4) NOT NULL,
  `bm_sendid` bigint(20) NOT NULL,
  PRIMARY KEY (`bmid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bulk_msg_response`
--


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

--
-- Table structure for table `carrier_master`
--

CREATE TABLE IF NOT EXISTS `carrier_master` (
  `cr_id` int(11) NOT NULL AUTO_INCREMENT,
  `cr_name` varchar(50) NOT NULL,
  PRIMARY KEY (`cr_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `carrier_master`
--

INSERT INTO `carrier_master` (`cr_id`, `cr_name`) VALUES
(1, 'Airtel'),
(2, 'BSNL'),
(3, 'AIRCEL'),
(4, 'PING'),
(5, 'Allianz Infratech'),
(6, 'IDEA'),
(7, 'LOOP Telecom'),
(8, 'MTNL'),
(9, 'S. Tel'),
(10, 'Reliance'),
(11, 'Tata Indicom'),
(12, 'Tata Docomo'),
(13, 'Virgin Mobile'),
(14, 'Uninor'),
(15, 'Vodafone'),
(16, 'MTS');

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

--
-- Table structure for table `circle_areacode`
--

CREATE TABLE IF NOT EXISTS `circle_areacode` (
  `ca_id` int(11) NOT NULL AUTO_INCREMENT,
  `ca_cid` int(11) NOT NULL,
  `ca_code` varchar(10) NOT NULL,
  PRIMARY KEY (`ca_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `circle_areacode`
--


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

--
-- Table structure for table `circle_master`
--

CREATE TABLE IF NOT EXISTS `circle_master` (
  `c_id` int(11) NOT NULL AUTO_INCREMENT,
  `c_name` varchar(100) NOT NULL,
  PRIMARY KEY (`c_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

--
-- Dumping data for table `circle_master`
--

INSERT INTO `circle_master` (`c_id`, `c_name`) VALUES
(1, 'Ahmedabad'),
(2, 'AP'),
(3, 'Assam'),
(4, 'BiharJharkhand'),
(5, 'Chennai'),
(6, 'Delhi'),
(7, 'Gujarat'),
(8, 'Haryana'),
(9, 'HP'),
(10, 'JK'),
(11, 'Karnataka'),
(12, 'Kerala'),
(13, 'Kokata'),
(14, 'Maharashtra'),
(15, 'MP'),
(16, 'Mumbai'),
(17, 'NorthEast'),
(18, 'Orissa'),
(19, 'Punjab'),
(20, 'Rajasthan'),
(21, 'Tamilnadu'),
(22, 'UPEast'),
(23, 'UPWest'),
(24, 'Vadodra'),
(25, 'WestBengal');

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

--
-- Table structure for table `euser_group_numbers`
--

CREATE TABLE IF NOT EXISTS `euser_group_numbers` (
  `egnid` bigint(20) NOT NULL AUTO_INCREMENT,
  `egid` bigint(20) NOT NULL,
  `egn_number` bigint(20) NOT NULL,
  PRIMARY KEY (`egnid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `euser_group_numbers`
--


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

--
-- Table structure for table `euser_plan`
--

CREATE TABLE IF NOT EXISTS `euser_plan` (
  `up_id` int(11) NOT NULL AUTO_INCREMENT,
  `up_eid` int(11) NOT NULL,
  `up_plid` int(11) NOT NULL,
  `up_subscribe_date` datetime NOT NULL,
  `up_expiry_date` datetime NOT NULL,
  `up_pmtid` int(11) NOT NULL,
  `up_status` int(4) NOT NULL,
  PRIMARY KEY (`up_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;

--
-- Dumping data for table `euser_plan`
--

INSERT INTO `euser_plan` (`up_id`, `up_eid`, `up_plid`, `up_subscribe_date`, `up_expiry_date`, `up_pmtid`, `up_status`) VALUES
(1, 1, 1, '2010-07-14 16:35:31', '2011-07-13 16:35:35', 1, 1),
(2, 2, 2, '2010-07-15 16:35:58', '2011-07-14 16:36:02', 2, 1),
(29, 7, 2, '2010-07-23 00:00:00', '2011-07-23 00:00:00', 0, 0),
(30, 7, 4, '2010-07-23 00:00:00', '2011-07-23 00:00:00', 10, 0),
(31, 7, 4, '2010-07-23 00:00:00', '2011-07-23 00:00:00', 11, 0),
(32, 7, 4, '2010-07-23 00:00:00', '2011-07-23 00:00:00', 12, 0),
(33, 7, 4, '2010-07-23 00:00:00', '2011-07-23 00:00:00', 0, 0),
(34, 7, 1, '2010-07-23 00:00:00', '2011-07-23 00:00:00', 0, 0),
(35, 10, 4, '2010-07-23 00:00:00', '2011-07-23 00:00:00', 0, 0),
(36, 10, 4, '2010-07-23 00:00:00', '2011-07-23 00:00:00', 13, 0),
(37, 10, 1, '2010-07-23 00:00:00', '2011-07-23 00:00:00', 14, 0),
(38, 10, 3, '2010-07-23 00:00:00', '2011-07-23 00:00:00', 0, 0),
(39, 10, 3, '2010-07-23 00:00:00', '2011-07-23 00:00:00', 15, 0),
(40, 12, 4, '2010-07-26 00:00:00', '2011-07-26 00:00:00', 3, 0);

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

--
-- Table structure for table `e_user`
--

CREATE TABLE IF NOT EXISTS `e_user` (
  `e_id` bigint(11) NOT NULL AUTO_INCREMENT,
  `e_username` bigint(20) NOT NULL,
  `e_email` varchar(100) NOT NULL,
  `e_pwd` varchar(100) NOT NULL,
  `e_mobnumber` bigint(20) NOT NULL,
  `e_name` varchar(100) NOT NULL,
  `e_companyname` varchar(200) NOT NULL,
  `e_address1` varchar(300) NOT NULL,
  `e_city` int(11) NOT NULL DEFAULT '0',
  `e_state` int(11) NOT NULL,
  `e_zipcode` int(6) NOT NULL,
  `e_signupdate` datetime NOT NULL,
  `e_circleid` int(11) NOT NULL,
  `e_status` int(4) NOT NULL DEFAULT '0',
  `e_carrier` int(11) NOT NULL,
  `e_gender` char(4) NOT NULL DEFAULT 'M',
  PRIMARY KEY (`e_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `e_user`
--

INSERT INTO `e_user` (`e_id`, `e_username`, `e_email`, `e_pwd`, `e_mobnumber`, `e_name`, `e_companyname`, `e_address1`, `e_city`, `e_state`, `e_zipcode`, `e_signupdate`, `e_circleid`, `e_status`, `e_carrier`, `e_gender`) VALUES
(1, 20101407928, 'ashish@ostpl.com', 'e10adc3949ba59abbe56e057f20f883e', 9595265383, 'Ashish Nair', 'OSTPL', '22nd Cross, 3rd Block,', 12, 0, 532002, '2010-07-15 11:44:26', 1, 1, 3, 'M'),
(2, 3245985, 'ashish27@ostpl.com', 'e10adc3949ba59abbe56e057f20f883e', 9565645456, 'Ravi Kumar', 'OSTPL', 'dfsdf', 54, 17, 560039, '2010-07-22 04:12:41', 11, 0, 1, 'M'),
(3, 5934244, 'jack@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 9898565645, 'Ashish Nair', 'OSTPL', 'sdfsf', 54, 17, 456512, '2010-07-22 06:47:21', 11, 0, 1, 'M'),
(4, 3253851, 'sdfklsdfjlsdf@ocl.com', 'e10adc3949ba59abbe56e057f20f883e', 8989894564, 'Ashish Nair', 'kdsfljl', 'fgkl', 54, 17, 565656, '2010-07-22 13:32:45', 11, 0, 1, 'M'),
(5, 1745876, 'fgjfdg@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 4654564654, 'fgfdkgj', 'dfsdffsd', 'fgdf', 54, 17, 560039, '2010-07-22 13:34:13', 11, 0, 1, 'M'),
(6, 4731445, 'sdfj@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 1231432132, 'dsdfs', 'dsklj', 'fgfdg', 54, 17, 560039, '2010-07-22 13:35:15', 11, 0, 1, 'M'),
(7, 5940483, 'ashish19@ostpl.com', 'e10adc3949ba59abbe56e057f20f883e', 9898565649, 'jack hover', 'OSTPL', 'fggf', 54, 17, 560039, '2010-07-23 03:48:49', 11, 0, 1, 'M'),
(8, 6155056, 'ashish51@ostpl.com', 'e10adc3949ba59abbe56e057f20f883e', 9663092308, 'ravi kumar', 'OSTPL', 'sdfsf', 54, 17, 560039, '2010-07-23 05:11:10', 11, 0, 1, 'M'),
(9, 7136230, 'ashish24@ostpl.com', 'e10adc3949ba59abbe56e057f20f883e', 9663092304, 'ravi kumar', 'OSTPL', 'fgdfg', 54, 17, 560039, '2010-07-23 05:13:05', 11, 0, 1, 'M'),
(10, 7446560, 'ashish26@ostpl.com', 'e10adc3949ba59abbe56e057f20f883e', 9663092302, 'ravi kumar', 'OSTPL', 'fdgfg', 54, 17, 560039, '2010-07-23 05:16:25', 11, 0, 1, 'M'),
(11, 3449978, 'ashish81@ostpl.com', 'e10adc3949ba59abbe56e057f20f883e', 9663092307, 'Ashish Nair', 'OSTPL', 'dfklsdf', 54, 17, 560039, '2010-07-26 07:13:06', 11, 0, 1, 'M'),
(12, 5630696, 'ashish72@ostpl.com', 'e10adc3949ba59abbe56e057f20f883e', 9663092312, 'Ashish Nair', 'OSTPL', 'sdfsdf', 54, 17, 560039, '2010-07-26 07:14:16', 11, 0, 1, 'M');

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

--
-- Table structure for table `e_user_group`
--

CREATE TABLE IF NOT EXISTS `e_user_group` (
  `egid` int(11) NOT NULL AUTO_INCREMENT,
  `eid` int(11) NOT NULL,
  `e_groupname` varchar(50) NOT NULL,
  `e_gstatus` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`egid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `e_user_group`
--

INSERT INTO `e_user_group` (`egid`, `eid`, `e_groupname`, `e_gstatus`) VALUES
(1, 1, 'JobFair', 1),
(2, 2, 'Shopping', 1),
(3, 1, 'SpecialOffers', 1),
(4, 1, 'Matrimony', 1),
(5, 2, 'RetailOffers', 1),
(6, 2, 'MovieTickets', 1),
(7, 3, 'KnowledgeGroup', 1),
(8, 3, 'JokesGroup', 1),
(9, 10, 'Marketing', 0),
(10, 10, 'SPECIALOFFER', 0),
(11, 10, 'diwali', 0),
(12, 10, 'christmas_offer', 0),
(13, 10, 'Holifest', 0),
(14, 10, 'TEST', 0),
(15, 10, 'on', 0),
(16, 12, 'SHOPPERS', 0),
(17, 12, 'STUDENTS', 0),
(18, 12, 'WOMEN', 0);

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

--
-- Table structure for table `faq`
--

CREATE TABLE IF NOT EXISTS `faq` (
  `faqid` bigint(20) NOT NULL AUTO_INCREMENT,
  `linkid` bigint(20) NOT NULL,
  `faq_question` varchar(200) NOT NULL,
  `faq_answer` varchar(200) NOT NULL,
  PRIMARY KEY (`faqid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `faq`
--


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

--
-- Table structure for table `freemsg_queue`
--

CREATE TABLE IF NOT EXISTS `freemsg_queue` (
  `fmsg_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fuid` bigint(20) NOT NULL,
  `msg_text` varchar(200) NOT NULL,
  `msg_number` bigint(20) NOT NULL,
  `msg_status` int(4) NOT NULL,
  `msg_datecreated` datetime NOT NULL,
  PRIMARY KEY (`fmsg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `freemsg_queue`
--


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

--
-- Table structure for table `freemsg_response`
--

CREATE TABLE IF NOT EXISTS `freemsg_response` (
  `fmrid` bigint(20) NOT NULL AUTO_INCREMENT,
  `fmsgid` bigint(20) NOT NULL,
  `msg_response` int(4) NOT NULL,
  `msg_datetime` datetime NOT NULL,
  PRIMARY KEY (`fmrid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `freemsg_response`
--


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

--
-- Table structure for table `free_user`
--

CREATE TABLE IF NOT EXISTS `free_user` (
  `n_uid` int(11) NOT NULL AUTO_INCREMENT,
  `n_email` varchar(100) NOT NULL,
  `n_pwd` varchar(15) NOT NULL,
  `n_countrycode` varchar(5) NOT NULL,
  `n_mobilenumber` bigint(11) NOT NULL,
  `photopath` varchar(100) NOT NULL,
  `n_name` varchar(100) NOT NULL,
  `n_nickname` varchar(20) NOT NULL,
  `n_dob` date NOT NULL,
  `n_gender` varchar(1) NOT NULL,
  `n_locationid` int(11) NOT NULL DEFAULT '0',
  `n_verifycode` varchar(6) NOT NULL,
  `n_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`n_uid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `free_user`
--

INSERT INTO `free_user` (`n_uid`, `n_email`, `n_pwd`, `n_countrycode`, `n_mobilenumber`, `photopath`, `n_name`, `n_nickname`, `n_dob`, `n_gender`, `n_locationid`, `n_verifycode`, `n_status`) VALUES
(1, 'user@gmail.com', '123456', '123', 9898565645, 'sdfsf', 'user', 'usernickname', '1988-07-11', 'M', 54, '454565', 1),
(2, 'john@hotmail.com', '123456', '24', 656545, 'gdfghdfkh', 'john', 'johnny', '1990-07-10', 'M', 36, '6565', 1);

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

--
-- Table structure for table `group_msg_post`
--

CREATE TABLE IF NOT EXISTS `group_msg_post` (
  `gmpid` bigint(20) NOT NULL AUTO_INCREMENT,
  `egid` bigint(20) NOT NULL,
  `msgtype` int(4) NOT NULL,
  `gmp_msgtext` varchar(200) NOT NULL,
  `gmp_sendoption` int(4) NOT NULL,
  `gmp_send_datetime` datetime NOT NULL,
  `gmp_mgid` bigint(20) NOT NULL,
  `transid` bigint(20) NOT NULL,
  PRIMARY KEY (`gmpid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `group_msg_post`
--

INSERT INTO `group_msg_post` (`gmpid`, `egid`, `msgtype`, `gmp_msgtext`, `gmp_sendoption`, `gmp_send_datetime`, `gmp_mgid`, `transid`) VALUES
(1, 1, 1, 'Get 50% discount on Levi''s Jeans at Big Bazaar. Offer valid till 30th July ', 2, '2010-07-17 12:20:14', 1, 565545124544),
(2, 1, 1, 'Get 30% discount on Buffalo T-Shirts at Big Bazaar. Offer valid till 30th July ', 2, '2010-07-17 12:21:22', 2, 565545124544);

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

--
-- Table structure for table `group_msg_response`
--

CREATE TABLE IF NOT EXISTS `group_msg_response` (
  `gmrid` bigint(20) NOT NULL,
  `gmpid` bigint(20) NOT NULL,
  `phone_number` bigint(11) NOT NULL,
  `send_status` int(4) NOT NULL,
  `send_datetime` datetime NOT NULL,
  `gmr_status` int(4) NOT NULL,
  `gmp_sendid` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `group_msg_response`
--


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

--
-- Table structure for table `industrylist`
--

CREATE TABLE IF NOT EXISTS `industrylist` (
  `indid` int(11) NOT NULL AUTO_INCREMENT,
  `industry_name` varchar(50) NOT NULL,
  PRIMARY KEY (`indid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ;

--
-- Dumping data for table `industrylist`
--

INSERT INTO `industrylist` (`indid`, `industry_name`) VALUES
(1, 'BANKING'),
(2, 'BROKER'),
(3, 'BROKER_INSURANCE'),
(4, 'BROKER_MUTUALFUND'),
(5, 'BROKER_REALESTATE'),
(6, 'BROKER_STOCKS'),
(7, 'CLUBS'),
(8, 'DEALER'),
(9, 'EVENTS'),
(10, 'EDUCATION'),
(11, 'EDUCATION_COACHINGCLASSES'),
(12, 'EDUCATION_COLLEGES'),
(13, 'EDUCATION_COMPUTERTRAINING'),
(14, 'EDUCATION_SCHOOLS'),
(15, 'ENTERTAINMENT'),
(16, 'ENTERTAINMENT_CINEMAHALL'),
(17, 'FMCG'),
(18, 'INSURANCE'),
(19, 'MARKETRESEARCH'),
(20, 'NGO'),
(21, 'POLITICS'),
(22, 'RETAIL'),
(23, 'RETAIL_ELECTRONICS'),
(24, 'RETAIL_GARMENTS'),
(25, 'RETAIL_GENERALSTORE'),
(26, 'RETAIL_JEWELLERY'),
(27, 'RESTAURANT'),
(28, 'SERVICES'),
(29, 'SOFTWARE'),
(30, 'TELECOM'),
(31, 'TECHNOLOGY'),
(32, 'TRANSPORTATION'),
(33, 'TRAVEL'),
(34, 'TRAVEL_HOTEL'),
(35, 'OTHER');

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

--
-- Table structure for table `keyword_group`
--

CREATE TABLE IF NOT EXISTS `keyword_group` (
  `kgid` bigint(20) NOT NULL AUTO_INCREMENT,
  `eid` bigint(20) NOT NULL,
  `k_groupname` varchar(50) NOT NULL,
  `k_responsetype` varchar(50) NOT NULL,
  `k_responseurl` varchar(500) NOT NULL,
  `k_default_response` varchar(200) NOT NULL,
  `k_maskid` bigint(20) NOT NULL,
  `k_activefrom` date NOT NULL,
  `k_activeupto` date NOT NULL,
  `k_status` int(4) NOT NULL,
  `k_datecreated` datetime NOT NULL,
  PRIMARY KEY (`kgid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `keyword_group`
--

INSERT INTO `keyword_group` (`kgid`, `eid`, `k_groupname`, `k_responsetype`, `k_responseurl`, `k_default_response`, `k_maskid`, `k_activefrom`, `k_activeupto`, `k_status`, `k_datecreated`) VALUES
(1, 1, 'Marketing3', '1', 'htp://ostpl.com/getresponse?id=', 'Thank you, we''ll get back in touch shortly with more details', 1, '2010-07-01', '2010-11-30', 1, '2010-07-16 11:43:20'),
(2, 2, 'Business3', '1', 'htp://ostpl.com/getresponse?id=', 'Thank you, we''ll get back in touch shortly with more details', 2, '2010-07-02', '2010-09-30', 1, '2010-07-16 11:44:27');

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

--
-- Table structure for table `kg_keyword`
--

CREATE TABLE IF NOT EXISTS `kg_keyword` (
  `kyid` bigint(20) NOT NULL AUTO_INCREMENT,
  `kgid` bigint(20) NOT NULL,
  `kword_text` varchar(50) NOT NULL,
  `kg_phonecode` bigint(10) NOT NULL,
  `kg_date` date NOT NULL,
  PRIMARY KEY (`kyid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `kg_keyword`
--

INSERT INTO `kg_keyword` (`kyid`, `kgid`, `kword_text`, `kg_phonecode`, `kg_date`) VALUES
(1, 1, 'PIZZA', 9898564565, '2010-07-16'),
(2, 2, 'MBA', 8455465652, '2010-07-16');

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

--
-- Table structure for table `mask`
--

CREATE TABLE IF NOT EXISTS `mask` (
  `mskid` bigint(20) NOT NULL AUTO_INCREMENT,
  `eid` bigint(20) NOT NULL,
  `maskvalue` varchar(15) NOT NULL,
  `mask_datecreated` datetime NOT NULL,
  `mstatus` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`mskid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `mask`
--

INSERT INTO `mask` (`mskid`, `eid`, `maskvalue`, `mask_datecreated`, `mstatus`) VALUES
(1, 1, 'SHOPPING', '2010-07-16 11:36:32', 0),
(2, 1, 'BUSINESS', '2010-07-16 11:37:03', 0),
(3, 10, 'MRKTG', '2010-07-23 00:00:00', 0),
(4, 10, 'SPLOFFER', '2010-07-23 00:00:00', 0),
(5, 10, 'diwoffer', '2010-07-23 00:00:00', 0),
(6, 10, 'christmasoff', '2010-07-23 00:00:00', 0),
(7, 10, 'HOLI', '2010-07-23 00:00:00', 0),
(10, 12, 'SPLOFFER', '2010-07-26 00:00:00', 1),
(11, 12, 'MBACLASSES', '2010-07-26 00:00:00', 1);

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

--
-- Table structure for table `mask_group`
--

CREATE TABLE IF NOT EXISTS `mask_group` (
  `mgid` bigint(20) NOT NULL AUTO_INCREMENT,
  `egid` bigint(20) NOT NULL,
  `emid` bigint(20) NOT NULL,
  PRIMARY KEY (`mgid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `mask_group`
--

INSERT INTO `mask_group` (`mgid`, `egid`, `emid`) VALUES
(1, 1, 1),
(2, 1, 2),
(3, 11, 9),
(4, 12, 5),
(5, 13, 7),
(6, 14, 0),
(7, 15, 0),
(8, 16, 10),
(9, 17, 11),
(10, 18, 10);

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

--
-- Table structure for table `msg_plan`
--

CREATE TABLE IF NOT EXISTS `msg_plan` (
  `pl_id` int(11) NOT NULL AUTO_INCREMENT,
  `pl_name` varchar(150) NOT NULL,
  `pl_rate` float NOT NULL,
  `pl_validity_days` int(11) NOT NULL,
  `pl_msgs` bigint(20) NOT NULL,
  `rate_per_msg` float NOT NULL DEFAULT '0',
  `msging_price` float NOT NULL,
  `service_tax` float NOT NULL,
  `setup_fees` float NOT NULL,
  PRIMARY KEY (`pl_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `msg_plan`
--

INSERT INTO `msg_plan` (`pl_id`, `pl_name`, `pl_rate`, `pl_validity_days`, `pl_msgs`, `rate_per_msg`, `msging_price`, `service_tax`, `setup_fees`) VALUES
(1, ' Ace - Small', 3000, 365, 50000, 5.4, 2720, 280, 0),
(2, 'Ace - Medium', 5000, 365, 100000, 4.5, 4533, 467, 0),
(3, 'Ace - Large', 20000, 365, 500000, 3.6, 18132, 1868, 0),
(4, 'Ace 2.5', 11000, 365, 250000, 4, 9973, 1027, 0);

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

--
-- Table structure for table `msg_queue`
--

CREATE TABLE IF NOT EXISTS `msg_queue` (
  `msgid` bigint(20) NOT NULL AUTO_INCREMENT,
  `gmpid` bigint(20) NOT NULL DEFAULT '0',
  `bmid` bigint(20) NOT NULL DEFAULT '0',
  `schedule_time` datetime NOT NULL,
  PRIMARY KEY (`msgid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `msg_queue`
--


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

--
-- Table structure for table `site_config`
--

CREATE TABLE IF NOT EXISTS `site_config` (
  `configid` int(11) NOT NULL AUTO_INCREMENT,
  `configtype` varchar(100) NOT NULL,
  `configvalue` varchar(200) NOT NULL,
  PRIMARY KEY (`configid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `site_config`
--

INSERT INTO `site_config` (`configid`, `configtype`, `configvalue`) VALUES
(1, 'site_name', 'SMS PRO'),
(2, 'site_url', 'http://localhost/smspro/'),
(3, 'admin_url', 'http://localhost/smspro/admin/'),
(4, 'site_email', 'admin@localhost.com'),
(5, 'site_title', 'SMS PRO - Connect , Share, Enjoy'),
(6, 'enterprise_url', 'http://localhost/smspro/enterprise/'),
(7, 'user_url', 'http://localhost/smspro/user/'),
(8, 'site_bank', 'ICICI Bank'),
(9, 'site_bank_accountname', 'Overtake Solutions & Technologies Pvt. Ltd.'),
(10, 'site_bank_account_number', '120056223621'),
(11, 'site_bank_branch', 'Jayanagar, Bangalore - 560039');

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

--
-- Table structure for table `site_link`
--

CREATE TABLE IF NOT EXISTS `site_link` (
  `linkid` int(11) NOT NULL AUTO_INCREMENT,
  `linktype` int(11) NOT NULL DEFAULT '0',
  `linkname` varchar(50) NOT NULL,
  `linktitle` varchar(100) NOT NULL,
  `linkmetatags` text NOT NULL,
  `linkdesc` varchar(150) NOT NULL,
  `mainlink` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`linkid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;

--
-- Dumping data for table `site_link`
--

INSERT INTO `site_link` (`linkid`, `linktype`, `linkname`, `linktitle`, `linkmetatags`, `linkdesc`, `mainlink`) VALUES
(1, 2, 'plans', 'Plans', 'bulk sms message plans, sms plan, subscription plans', 'Configure Subscription plans ', 0),
(2, 2, 'subscribers', 'Subscribers', 'list of subscribers, enterprise users', 'list of enterprise account holders', 0),
(5, 2, 'configuration', 'Configuration', 'Site configuration, site name, url ,admin email configuraton', 'Site configuration', 0),
(6, 2, 'help', 'Help', 'General Site help topics', 'General Site help topics', 0),
(7, 2, 'faq', 'FAQ', 'Frequently asked questions', 'Frequently asked questions', 0),
(8, 0, 'about', 'About Us', 'about us', 'about us', 0),
(9, 2, 'login', 'Login', 'login', 'login', 0),
(10, 2, 'login/logout_action', 'Log Out', 'log out', 'log out', 0),
(11, 2, 'listing', 'Listing', 'plans listing', 'list of subscription plans', 1),
(12, 2, 'newplan', 'New Plan', 'create new plan', 'create new plan', 1),
(13, 2, 'profiles', 'Profiles', 'listing of subscribers', 'listing of subscribers', 2),
(14, 2, 'groups', 'Groups', 'groups created by subscribers', 'groups created by subscribers', 2),
(15, 2, 'keywords', 'Keywords', 'Keywords by subscribers', 'Keywords by subscribers', 2),
(16, 2, 'messages', 'Messages', 'messages sent by subscribers', 'messages sent by subscribers', 2),
(17, 2, 'ads', 'Ads', 'ads by subscribers', 'ads by subscribers', 2),
(18, 2, 'masks', 'Masks', 'masks by subscribers', 'masks by subscribers', 2),
(19, 2, 'payments', 'Payments', 'payments by subcribers', 'payments by subscribers', 2),
(20, 1, 'signup', 'Sign Up', 'sign up,  register', 'enterprise sign up', 0),
(21, 1, 'groups', 'Groups', 'enterprise groups', 'enterprise groups', 0),
(22, 1, 'messages', 'Messages', 'enterprise messages', 'enterprise messages', 0),
(23, 1, 'masks', 'Masks', 'enterprise masks', 'enterprise masks', 0),
(24, 1, 'keywords', 'Keywords', 'enterprise keywords', 'enterprise keywords', 0),
(25, 1, 'ads', 'Ads', 'enterprise ads', 'enterprise ads', 0),
(26, 1, 'settings', 'Settings', 'enterprise settings', 'enterprise settings', 0),
(27, 1, 'help', 'Help', 'enterprise help', 'enterprise help', 0),
(28, 1, 'login/logout_action', 'Log Out', 'enterprise Log out', 'enterprise Log out', 0),
(29, 1, 'activegroups', 'Active Groups', 'enterprise active groups', 'enterprise active groups', 21),
(30, 1, 'creategroups', 'Create Groups', 'enterprise create groups', 'enterprise create groups', 21),
(31, 1, 'login', 'Log In', 'enterprise Log In', 'enterprise Log In', 0),
(32, 1, 'selectplan', 'Select a messaging plan', 'select plan, messaging plan, yearly subscription plan', 'select  a messaging plan ', 100);

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

--
-- Table structure for table `static_content`
--

CREATE TABLE IF NOT EXISTS `static_content` (
  `pageid` int(11) NOT NULL AUTO_INCREMENT,
  `pagename` varchar(25) NOT NULL,
  `pagetitle` varchar(100) NOT NULL,
  `pagecontent` text NOT NULL,
  PRIMARY KEY (`pageid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `static_content`
--

INSERT INTO `static_content` (`pageid`, `pagename`, `pagetitle`, `pagecontent`) VALUES
(1, 'terms', 'Terms and Conditions', '#site_fullname (hereinafter referred to as "#site_name"), owner of the trademark, brand, logo and service #site_name provides a select group of Users ("User") with a "enterprise grade messaging" service to send SMS to a large number of group members to their group, also called as Sanchar; and with a "advertising service" to insert footer ads in outgoing messages of the SMS portal #site_url also known as Prachar (both together hereinafter referred to  as "the service" or "this service"). This service is subject to the following terms and conditions.\r\n\r\n   1. You, the User of this service, understand that the service allows for you to be able to send messages to people in your group. You also understand that the intent of this service is to communicate only with people you know and not with whom you do not know and those who would not be interested in receiving messages from you.\r\n\r\n   2. You, the User of this service, confirm that you have read the provisions of the NDNC registry of TRAI and understand that the essence of this registry is to reduce or take away the incidence of SPAM for mobile Users. (For more details on NDNC, visit http://ndncregistry.gov.in/ndncregistry/index.jsp)\r\n\r\n   3. You, the User of this service, confirm that the mobile phone numbers to whom messages will be sent using this service are authentic & belong to people you have personal, professional or business relationships with. You further confirm that you have not included in the list any number of any person(s) who is not known to you.\r\n\r\n   4. You, the User of this service, confirm that you can provide, on request, an auditable acceptance or permission from all such people whom you intend to send SMS messages to using this service, to receive messages from you via SMS GupShup.\r\n\r\n   5. You, the User of this service, understand that in light of NDNC and the clauses laid out therein, sending of any unsolicited message could result in penalties being levied.\r\n\r\n   6. You, the User of this service, agree to use this service judiciously and without violating privacy of the people concerned.  You also agree to comply with all necessary laws as maybe applicable.\r\n\r\n   7. You, the User of the service, agree to bear all responsibility for the messages sent to your group by using this service. You agree to indemnify Webaroo against all complaints and claims arising out of violation of the NDNC provisions due to your acts.\r\n\r\n   8. You, the User of the service, agree to follow all laws of the land and respect and abide by all directives, guidelines and circulars issued by TRAI, as maybe applicable, from time to time.\r\n\r\n   9. You, the User of the service, understand the message length of SMS messages, will be measured as follows –\r\n\r\nMessage length (upto) will be measured as per following chart –\r\ni.   	160-characters 	1 message\r\nii. 	306-characters 	2 messages\r\niii. 	459-characters  	3 messages\r\niv. 	612-characters 	4 messages\r\nv.  	724-characters 	5 messages\r\n\r\n  10. You, the User of the service, understand and agree that it is your responsibility to consume the service within validity period offered to you, else the service will lapse after the validity period.  In any case, maximum validity period of the service cannot exceed 1-year from the date of placing confirmed order against payment, after which the service will lapse.\r\n\r\n  11. You, the User of the service, understand and agree that refund claims will not be entertained under any circumstances by #site_name.\r\n\r\n  12. You, the User of the service, understand and agree that delivery reports of messages sent through the service are dependent on data provided to Webaroo by mobile operators, which in turn is shared by Webaroo with you. If the mobile operator does not provide data on delivery reports to Webaroo, Webaroo will not be able to pass on the same to you. \r\n\r\n  13. You, the User of the service, agree to pay #site_name any amount that maybe payable for using the service, in excess to what you are entitled to as per order placed with #site_name.\r\n\r\n  14. You, the User of the service, agree and understand that Interconnect charges, if applicable in future or in retrospect on any Indian or supporting overseas network, shall be charged extra and adjusted in the prepaid amount by #site_name.\r\n\r\n  15. You, the User of the service, understand and agree that response to advertisements placed through the service cannot be guaranteed or assured by Webaroo.\r\n\r\n  16. You, the User of the service, understand and agree that only courts in Mumbai have jurisdiction over any and all matters pertaining to the service.\r\n\r\n#site_name reserves the right to terminate your account at any time without notice or liability, if #site_name determines that you have violated any of these terms and conditions. #site_name reserves the right to modify these policies at any time.\r\n\r\nBy signing on the order booking form (as on the reverse side of this document) and / or by making or issuing payment for the service, you agree to all the terms and conditions above.');

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

--
-- Table structure for table `tblcountry_region`
--

CREATE TABLE IF NOT EXISTS `tblcountry_region` (
  `region_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `country_id` varchar(4) NOT NULL DEFAULT '0',
  `code` varchar(32) NOT NULL DEFAULT '',
  `default_name` varchar(255) DEFAULT NULL,
  `is_unionterritory` enum('yes','no') NOT NULL DEFAULT 'no',
  PRIMARY KEY (`region_id`),
  KEY `FK_REGION_COUNTRY` (`country_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Country regions' AUTO_INCREMENT=36 ;

--
-- Dumping data for table `tblcountry_region`
--

INSERT INTO `tblcountry_region` (`region_id`, `country_id`, `code`, `default_name`, `is_unionterritory`) VALUES
(1, 'IN', 'AN', 'Andaman and Nicobar Islands', 'yes'),
(2, 'IN', 'AP', 'Andhra Pradesh', 'no'),
(3, 'IN', 'AR', 'Arunachal Pradesh', 'no'),
(4, 'IN', 'AS', 'Assam', 'no'),
(5, 'IN', 'BR', 'Bihar', 'no'),
(6, 'IN', 'CH', 'Chandigarh', 'yes'),
(7, 'IN', 'CT', 'Chhattisgarh', 'no'),
(8, 'IN', 'DN', 'Dadra and Nagar Haveli', 'yes'),
(9, 'IN', 'DD', 'Daman and Diu', 'yes'),
(10, 'IN', 'DL', 'Delhi', 'yes'),
(11, 'IN', 'GA', 'Goa', 'no'),
(12, 'IN', 'GJ', 'Gujarat', 'no'),
(13, 'IN', 'HR', 'Haryana', 'no'),
(14, 'IN', 'HP', 'Himachal Pradesh', 'no'),
(15, 'IN', 'JK', 'Jammu and Kashmir', 'no'),
(16, 'IN', 'JH', 'Jharkhand', 'no'),
(17, 'IN', 'KA', 'Karnataka', 'no'),
(18, 'IN', 'KL', 'Kerala', 'no'),
(19, 'IN', 'LD', 'Lakshadweep', 'yes'),
(20, 'IN', 'MP', 'Madhya Pradesh', 'no'),
(21, 'IN', 'MH', 'Maharashtra', 'no'),
(22, 'IN', 'MN', 'Manipur', 'no'),
(23, 'IN', 'ML', 'Meghalaya', 'no'),
(26, 'IN', 'OR', 'Orissa', 'no'),
(27, 'IN', 'PY', 'Puducherry', 'yes'),
(28, 'IN', 'PB', 'Punjab', 'no'),
(29, 'IN', 'RJ', 'Rajasthan', 'no'),
(30, 'US', 'SK', 'Sikkim', 'no'),
(31, 'US', 'TN', 'Tamil Nadu', 'no'),
(32, 'US', 'TR', 'Tripura', 'no'),
(33, 'US', 'UL', 'Uttarakhand', 'no'),
(34, 'US', 'UP', 'Uttar Pradesh', 'no'),
(35, 'US', 'WB', 'West Bengal', 'no');

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

--
-- Table structure for table `tblcountry_region_city`
--

CREATE TABLE IF NOT EXISTS `tblcountry_region_city` (
  `city_id` mediumint(8) unsigned NOT NULL,
  `region_id` mediumint(8) unsigned NOT NULL,
  `code` varchar(32) NOT NULL DEFAULT '',
  `default_name` varchar(255) NOT NULL,
  `top` enum('yes','no') NOT NULL DEFAULT 'no',
  `city_details` mediumtext NOT NULL,
  PRIMARY KEY (`city_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblcountry_region_city`
--

INSERT INTO `tblcountry_region_city` (`city_id`, `region_id`, `code`, `default_name`, `top`, `city_details`) VALUES
(2, 2, 'Hyderabad', 'Hyderabad', 'yes', ''),
(3, 2, 'Tirupati', 'Tirupati', 'no', ''),
(4, 2, 'Vijayawada', 'Vijayawada', 'no', ''),
(5, 2, 'Vishakapatnam', 'Vishakapatnam', 'no', ''),
(6, 2, 'Warangal', 'Warangal', 'no', ''),
(9, 1, 'Port Blair', 'Port Blair', 'no', ''),
(12, 3, 'Itanagar', 'Itanagar', 'no', ''),
(15, 4, 'Guwahati', 'Guwahati', 'no', ''),
(18, 4, 'Others', 'Others', 'no', ''),
(22, 5, 'Patna', 'Patna', 'no', ''),
(23, 5, 'Others', 'Others', 'no', ''),
(24, 3, 'Others', 'Others', 'no', ''),
(25, 2, 'Others', 'Others', 'no', ''),
(26, 1, 'Others', 'Others', 'no', ''),
(27, 6, 'Chandigarh', 'Chandigarh', 'yes', ''),
(29, 7, 'Durg', 'Durg', 'no', ''),
(30, 7, 'Raipur', 'Raipur', 'no', ''),
(31, 7, 'Others', 'Others', 'no', ''),
(33, 8, 'Dadra', 'Dadra', 'no', ''),
(34, 8, 'Silvasa', 'Silvasa', 'no', ''),
(35, 8, 'Others', 'Others', 'no', ''),
(37, 9, 'Daman', 'Daman', 'no', ''),
(38, 9, 'Diu', 'Diu', 'no', ''),
(39, 9, 'Others', 'Others', 'no', ''),
(40, 10, 'Delhi', 'Delhi', 'yes', ''),
(41, 11, 'Goa', 'Goa', 'yes', ''),
(47, 12, 'Ahmedabad', 'Ahmedabad', 'yes', ''),
(49, 12, 'Gandhinagar', 'Gandhinagar ', 'no', ''),
(50, 12, 'Surat', 'Surat', 'no', ''),
(51, 12, 'Vadodara', 'Vadodara', 'no', ''),
(52, 12, 'Rajkot', 'Rajkot', 'no', ''),
(53, 12, 'Others', 'Others', 'no', ''),
(54, 17, 'Bangalore', 'Bangalore', 'yes', 'The name Bangalore is an <a href=\\"http://en.wikipedia.org/wiki/Anglicization\\" title=\\"Anglicization\\" class=\\"mw-redirect\\">anglicised</a> version of the city\\''s name in the <a href=\\"http://en.wikipedia.org/wiki/Kannada_language\\" title=\\"Kannada language\\">Kannada language</a>, <em>Bengaluru</em>. The earliest reference to the name &quot;Bengaluru&quot; was found in a ninth century <a href=\\"http://en.wikipedia.org/wiki/Western_Ganga_Dynasty\\" title=\\"Western Ganga Dynasty\\">Western Ganga Dynasty</a> stone inscription'),
(55, 17, 'Mysore', 'Mysore', 'no', ''),
(56, 17, 'Mangalore', 'Mangalore', 'no', ''),
(57, 31, 'chennai', 'chennai', 'yes', ''),
(58, 35, 'kolkata', 'kolkata', 'yes', ''),
(59, 21, 'mumbai', 'mumbai', 'yes', ''),
(60, 21, 'pune', 'pune', 'yes', ''),
(61, 32, 'agartala', 'agartala', 'no', 'test description'),
(62, 34, 'agra', 'agra', 'no', ''),
(63, 29, 'ajmer', 'ajmer', 'no', ''),
(64, 34, 'allahabad', 'allahabad', 'no', ''),
(65, 28, 'amristar', 'amristar', 'no', ''),
(66, 21, 'aurangabad', 'aurangabad', 'no', ''),
(67, 7, 'bhilai', 'bhilai', 'no', ''),
(68, 17, 'belgaum', 'belgaum', 'no', ''),
(69, 20, 'bhopal', 'bhopal', 'no', ''),
(70, 26, 'bhubaneswar', 'bhubaneswar', 'no', ''),
(71, 29, 'bikaner', 'bikaner', 'no', ''),
(72, 18, 'calicut', 'calicut', 'no', ''),
(73, 17, 'chikamagalur', 'chikamagalur', 'no', ''),
(74, 31, 'coimbatore', 'coimbatore', 'no', ''),
(75, 35, 'darjelling', 'darjelling', 'no', ''),
(76, 33, 'dehradun', 'dehradun', 'no', ''),
(87, 13, 'faridabad', 'faridabad', 'no', ''),
(88, 30, 'gangtok', 'gangtok', 'no', ''),
(89, 34, 'ghaziabad', 'ghaziabad', 'no', ''),
(90, 20, 'gwalior', 'gwalior', 'no', ''),
(91, 13, 'gurgaon', 'gurgaon', 'no', ''),
(92, 33, 'haridwar', 'haridwar', 'no', ''),
(93, 26, 'cuttack', 'cuttack', 'no', ''),
(94, 17, 'hubli', 'hubli', 'no', ''),
(95, 20, 'indore', 'indore', 'no', ''),
(96, 22, 'imphal', 'imphal', 'no', ''),
(107, 20, 'jabalpur', 'jabalpur', 'no', ''),
(108, 29, 'jaipur', 'jaipur', 'no', ''),
(109, 29, 'jaisalmer', 'jaisalmer', 'no', ''),
(110, 28, 'jalandhar', 'jalandhar', 'no', ''),
(111, 21, 'jalagoan', 'jalagoan', 'no', ''),
(112, 15, 'jammu', 'jammu', 'no', ''),
(113, 16, 'jamshedpur', 'jamshedpur', 'no', ''),
(114, 29, 'jodhpur', 'jodhpur', 'no', ''),
(115, 18, 'kochi', 'kochi', 'no', ''),
(116, 31, 'kodaikanal', 'kodaikanal', 'no', ''),
(117, 31, 'kanyakumari', 'kanyakumari', 'no', ''),
(118, 20, 'kolhapur', 'kolhapur', 'no', ''),
(119, 34, 'lucknow', 'lucknow', 'no', ''),
(120, 28, 'ludhiana', 'ludhiana', 'no', ''),
(121, 31, 'madurai', 'madurai', 'no', ''),
(122, 33, 'nainital', 'nainital', 'no', ''),
(123, 20, 'nagpur', 'nagpur', 'no', ''),
(124, 20, 'nasik', 'nasik', 'no', ''),
(125, 34, 'noida', 'noida', 'no', ''),
(126, 31, 'ooty', 'ooty', 'no', ''),
(127, 28, 'patiala', 'patiala', 'no', ''),
(129, 16, 'ranchi', 'ranchi', 'no', ''),
(130, 2, 'secunderabad', 'secunderabad', 'no', ''),
(131, 23, 'shillong', 'shillong', 'no', ''),
(132, 14, 'shimla', 'shimla', 'no', ''),
(133, 15, 'srinagar', 'srinagar', 'no', ''),
(134, 21, 'thane', 'thane', 'no', ''),
(135, 31, 'thiruchirapalli', 'thiruchirapalli', 'no', ''),
(136, 18, 'thiruvananthapuram', 'thiruvananthapuram', 'no', ''),
(197, 31, 'tirupur', 'tirupur', 'no', '');

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

--
-- Table structure for table `usr_payment`
--

CREATE TABLE IF NOT EXISTS `usr_payment` (
  `payid` bigint(20) NOT NULL AUTO_INCREMENT,
  `upid` bigint(20) NOT NULL,
  `pay_option` int(4) NOT NULL DEFAULT '0',
  `pay_amt` float NOT NULL,
  `issue_date` date NOT NULL,
  `issue_bankid` int(11) NOT NULL DEFAULT '0',
  `chequeno` varchar(10) NOT NULL,
  `deposit_bank` varchar(100) NOT NULL,
  `deposit_date` date NOT NULL,
  `deposit_branch` varchar(100) NOT NULL,
  `payment_status` varchar(20) NOT NULL DEFAULT 'not validated',
  PRIMARY KEY (`payid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `usr_payment`
--

INSERT INTO `usr_payment` (`payid`, `upid`, `pay_option`, `pay_amt`, `issue_date`, `issue_bankid`, `chequeno`, `deposit_bank`, `deposit_date`, `deposit_branch`, `payment_status`) VALUES
(1, 1, 1, 5000, '2010-07-08', 1, '712453', '0', '0000-00-00', '', 'not validated'),
(2, 2, 1, 20000, '2010-07-09', 3, '652365', '0', '0000-00-00', '', 'not validated'),
(3, 40, 1, 11000, '2010-07-15', 1, '11245', 'HDFC BANK', '2010-07-27', 'Koramangala', 'not validated');

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

--
-- Table structure for table `zone_circle`
--

CREATE TABLE IF NOT EXISTS `zone_circle` (
  `zcid` int(11) NOT NULL AUTO_INCREMENT,
  `zid` int(11) NOT NULL,
  `c_id` int(11) NOT NULL,
  PRIMARY KEY (`zcid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

--
-- Dumping data for table `zone_circle`
--

INSERT INTO `zone_circle` (`zcid`, `zid`, `c_id`) VALUES
(1, 3, 1),
(2, 4, 2),
(3, 2, 3),
(4, 2, 4),
(5, 4, 5),
(6, 1, 6),
(7, 3, 7),
(8, 1, 8),
(9, 1, 9),
(10, 1, 10),
(11, 4, 11),
(12, 4, 12),
(13, 2, 13),
(14, 3, 14),
(15, 5, 15),
(16, 3, 16),
(17, 1, 17),
(18, 2, 18),
(19, 1, 19),
(20, 3, 20),
(21, 4, 21),
(22, 5, 22),
(23, 5, 23),
(24, 3, 24),
(25, 2, 25);

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

--
-- Table structure for table `zone_master`
--

CREATE TABLE IF NOT EXISTS `zone_master` (
  `zid` int(11) NOT NULL AUTO_INCREMENT,
  `zone_name` varchar(100) NOT NULL,
  PRIMARY KEY (`zid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `zone_master`
--

INSERT INTO `zone_master` (`zid`, `zone_name`) VALUES
(1, 'North'),
(2, 'East'),
(3, 'West'),
(4, 'South'),
(5, 'Central');