This project is read-only.
-- phpMyAdmin SQL Dump
-- version 3.2.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 07, 2009 at 01:59 PM
-- Server version: 5.0.67
-- PHP Version: 5.2.6-2ubuntu4.2

SET SQLMODE="NOAUTOVALUEON_ZERO";

--
-- Database: `MLM1`
--

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

--
-- Table structure for table `_adminuser`
--

CREATE TABLE IF NOT EXISTS `_adminuser` (
`userid` int(50) NOT NULL auto_increment,
`username` varchar(50) NOT NULL,
`password` varchar(20) NOT NULL,
`lastlogin` varchar(20) default NULL,
`islogin` tinyint(1) NOT NULL,
`empty` varchar(20) NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `_adminuser`
--

INSERT INTO `_adminuser` (`userid`, `username`, `password`, `lastlogin`, `islogin`, `empty`) VALUES
(4, 'admin', 'admin', NULL, 0, ''),
(5, 'hrut', 'hrut', NULL, 0, '');

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

--
-- Table structure for table `_commlogic`
--

CREATE TABLE IF NOT EXISTS `_commlogic` (
`id` int(11) NOT NULL,
`level` int(11) NOT NULL,
`pv_comm` double NOT NULL,
`pv_min` double NOT NULL,
`pv_max` double NOT NULL,
`qual_amt` double NOT NULL,
`sales_max` double NOT NULL,
`sales_min` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `_commlogic`
--

INSERT INTO `commlogic` (`id`, `level`, `pvcomm`, `pvmin`, `pvmax`, `qualamt`, `salesmax`, `sales_min`) VALUES
(1, 1, 22, 0, 100, 20000, 20000, 0),
(2, 2, 6, 101, 200, 40000, 40000, 0),
(3, 3, 3, 201, 400, 80000, 80000, 0),
(4, 4, 2, 401, 800, 160000, 160000, 0),
(5, 5, 2, 801, 1600, 320000, 320000, 0),
(6, 6, 2, 1601, 3200, 640000, 640000, 0),
(7, 7, 2, 3201, 6400, 1280000, 1280000, 0),
(8, 8, 2, 6401, 12800, 2560000, 2560000, 0),
(9, 9, 2, 12801, 25600, 5120000, 5120000, 0),
(10, 10, 2, 25601, 51200, 10240000, 10240000, 0),
(11, 11, 2, 51201, 102400, 20480000, 20480000, 0),
(12, 12, 1, 102401, 204800, 40960000, 40960000, 0),
(13, 13, 1, 204801, 409600, 81920000, 81920000, 0),
(14, 14, 1, 409601, 819200, 103840000, 103840000, 0),
(15, 15, 1, 819201, 1638400, 327680000, 327680000, 0);

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

--
-- Table structure for table `_content`
--

CREATE TABLE IF NOT EXISTS `_content` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(30) NOT NULL,
`position` int(11) NOT NULL,
`islive` tinyint(1) NOT NULL,
`content` varchar(1000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `_content`
--

INSERT INTO `_content` (`id`, `name`, `position`, `islive`, `content`) VALUES
(1, 'one', 1, 1, ''),
(2, 'two', 2, 0, '');

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

--
-- Table structure for table `_incentives`
--

CREATE TABLE IF NOT EXISTS `_incentives` (
`id` bigint(20) NOT NULL,
`level` int(11) NOT NULL,
`incentives` varchar(255) NOT NULL,
`notes` varchar(255) NOT NULL,
`last_payed` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `_incentives`
--

INSERT INTO `incentives` (`id`, `level`, `incentives`, `notes`, `lastpayed`) VALUES
(1, 1, 'none', 'abc', '2009-07-15'),
(2, 2, 'Wrist watch', 'abc2', '2009-07-20'),
(3, 3, 'Trolley Bag', 'abc3', '2009-07-21'),
(4, 4, 'Dinner Set', 'abc4', '2009-07-22'),
(5, 5, 'Mixer Grinder', 'abc5', '2009-07-25'),
(6, 6, 'Microwave Oven', 'abc6', '2009-08-03'),
(7, 7, 'Goa Tour', 'abc7', '2009-08-05'),
(8, 8, '21'' Color TV', 'abc8', '2009-08-06'),
(9, 9, 'Laptop', 'abc9', '2009-08-07'),
(10, 10, 'Bangkok / Malaysia Tour', 'abc10', '2009-08-08'),
(11, 11, 'Maruti Alto', 'abc11', '2009-08-09'),
(12, 12, 'Maruti Swift', 'abc12', '2009-08-10'),
(13, 13, 'Maruti sx4', 'abc13', '2009-08-11'),
(14, 14, '2 Bhk Flat + Life Time Pension Rs. 21000', 'abc14', '2009-08-13'),
(15, 15, 'Honda CRV + Life Time Pension Rs. 51000', 'abc15', '2009-08-17');

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

--
-- Table structure for table `_menu`
--

CREATE TABLE IF NOT EXISTS `_menu` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(20) NOT NULL,
`position` int(11) NOT NULL,
`navigate_url` varchar(50) NOT NULL,
`is_live` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `_menu`
--


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

--
-- Table structure for table `_products`
--

CREATE TABLE IF NOT EXISTS `_products` (
`product_id` int(10) NOT NULL,
`product_code` varchar(50) NOT NULL,
`product_group` varchar(50) NOT NULL,
`product_name` varchar(200) NOT NULL,
`product_desc` varchar(500) NOT NULL,
`amount` double NOT NULL,
PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `_products`
--

INSERT INTO `products` (`productid`, `productcode`, `productgroup`, `productname`, `productdesc`, `amount`) VALUES
(1, 'p00109', 'indoor', 'life insurance', 'life insurance', 50000),
(2, 'p00209', 'outdoor', 'mediclaim', 'mediclaim', 10000),
(3, 'p00309', 'indoor', 'education', 'education', 20000),
(4, 'p00409\r\n', 'outdoor', 'general policy', 'general policy', 10000);

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

--
-- Table structure for table `_pvlogic`
--

CREATE TABLE IF NOT EXISTS `_pvlogic` (
`id` int(11) NOT NULL,
`level` int(11) NOT NULL,
`pv2rs` double NOT NULL,
`pv_min` double NOT NULL,
`pv_max` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `_pvlogic`
--

INSERT INTO `pvlogic` (`id`, `level`, `pv2rs`, `pvmin`, `pv_max`) VALUES
(1, 1, 100, 0, 100),
(2, 2, 100, 101, 200),
(3, 3, 100, 201, 400),
(4, 4, 100, 401, 800),
(5, 5, 100, 801, 1600),
(6, 6, 100, 1601, 3200),
(7, 7, 100, 3201, 6400),
(8, 8, 100, 6401, 12800),
(9, 9, 100, 12801, 25600),
(10, 10, 100, 25601, 51200),
(11, 11, 100, 51201, 102400),
(12, 12, 100, 102401, 204800),
(13, 13, 100, 204801, 409600),
(14, 14, 100, 409601, 819200),
(15, 15, 100, 819201, 1638400);

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

--
-- Table structure for table `_relation`
--

CREATE TABLE IF NOT EXISTS `_relation` (
`id` int(11) NOT NULL auto_increment,
`userid` int(10) NOT NULL,
`code` varchar(100) NOT NULL,
`username` varchar(100) NOT NULL,
`level` int(11) NOT NULL,
`parent_id` int(11) default NULL,
`parent_code` varchar(10) NOT NULL,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `_relation`
--

INSERT INTO `relation` (`id`, `userid`, `code`, `username`, `level`, `parentid`, `parent_code`) VALUES
(2, 2, '2PJB0709', 'punit', 1, 1, '1VXZ0709'),
(3, 3, '3ADK0709', 'ankur', 1, 1, '1VXZ0709'),
(4, 4, '4HAT0709', 'harsh', 2, 2, '2PJB0709'),
(5, 5, '5AXD0709', 'amit', 2, 2, '2PJB0709'),
(1, 1, '1VXZ0709', 'Vineet', 0, NULL, '0'),
(6, 6, '6CJJ0709', 'chirag', 2, 3, '3ADK0709'),
(7, 7, '7SHM0709', 'sumeet', 1, 1, '1VXZ0709');

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

--
-- Table structure for table `_testrelation`
--

CREATE TABLE IF NOT EXISTS `_testrelation` (
`id` int(11) NOT NULL auto_increment,
`userid` int(10) NOT NULL,
`code` varchar(100) NOT NULL,
`username` varchar(100) NOT NULL,
`level` int(11) NOT NULL,
`parent_id` int(11) default NULL,
`parent_code` varchar(10) NOT NULL,
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `_testrelation`
--

INSERT INTO `testrelation` (`id`, `userid`, `code`, `username`, `level`, `parentid`, `parent_code`) VALUES
(2, 2, '2PJB0709', 'punit', 1, 1, '1VXZ0709'),
(3, 3, '3ADK0709', 'ankur', 1, 1, '1VXZ0709'),
(4, 4, '4HAT0709', 'harsh', 2, 2, '2PJB0709'),
(5, 5, '5AXD0709', 'amit', 2, 2, '2PJB0709'),
(1, 1, '1VXZ0709', 'Vineet', 0, NULL, '0'),
(6, 6, '6CJJ0709', 'chirag', 2, 3, '3ADK0709'),
(7, 7, '7SHM0709', 'sumeet', 1, 1, '1VXZ0709'),
(8, 8, '8AXZ0709', 'january', 0, 4, '4HAT0709'),
(9, 9, '9AXY0709', 'feb', 0, 4, '4HAT0709'),
(10, 10, '10AXW0709', 'march', 0, 4, '4HAT0709'),
(11, 11, '11AXA0709', 'april', 0, 1, '10AXW0709');

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

--
-- Table structure for table `_userprofit`
--

CREATE TABLE IF NOT EXISTS `_userprofit` (
`id` int(11) NOT NULL,
`username` varchar(100) NOT NULL,
`code` varchar(100) NOT NULL,
`level` int(11) NOT NULL,
`sales` double NOT NULL,
`Income` double NOT NULL,
`payout` double NOT NULL,
`lastcalculated` date default NULL,
`lastpayout` date default NULL,
`pvearned` double NOT NULL,
`pvredeemed` double NOT NULL,
`lastlevelsince` date default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `_userprofit`
--

INSERT INTO `_userprofit` (`id`, `username`, `code`, `level`, `sales`, `Income`, `payout`, `lastcalculated`, `lastpayout`, `pvearned`, `pvredeemed`, `lastlevelsince`) VALUES
(1, 'Vineet', '1VXZ0709', 3, 20000, 16000, 4000, '2009-08-04', '2009-08-06', 240, 100, '2009-08-04'),
(2, 'punit', '2PJB0709', 2, 20000, 14000, 6000, '0000-00-00', '0000-00-00', 80, 40, '0000-00-00'),
(7, 'sumeet', '7SHM0709', 2, 20000, 12000, 8000, NULL, NULL, 40, 20, NULL),
(3, 'ankur', '3ADK0709', 2, 20000, 15000, 5000, NULL, NULL, 70, 20, NULL),
(4, 'harsh', '4HAT0709', 3, 18000, 10000, 8000, NULL, NULL, 50, 25, NULL),
(6, 'chirag', '6CJJ0709', 3, 16000, 10000, 8000, NULL, NULL, 30, 10, NULL);

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

--
-- Table structure for table `_webuser`
--

CREATE TABLE IF NOT EXISTS `_webuser` (
`userid` int(50) NOT NULL auto_increment,
`username` varchar(50) NOT NULL,
`password` varchar(20) NOT NULL,
`code` varchar(20) NOT NULL,
`level` varchar(20) NOT NULL,
`lastlogin` varchar(20) default NULL,
`islogin` bit(1) NOT NULL default '\0',
`isactive` bit(1) NOT NULL default '\0',
`email1` varchar(50) NOT NULL,
`email2` varchar(50) NOT NULL,
PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `_webuser`
--

INSERT INTO `_webuser` (`userid`, `username`, `password`, `code`, `level`, `lastlogin`, `islogin`, `isactive`, `email1`, `email2`) VALUES
(1, 'Vineet', 'vineet', '1VXZ0709', '3', NULL, b'1', b'0', 'vineet@email.com', ''),
(2, 'punit', 'punit', '2PJB0709', '2', NULL, b'1', b'0', 'punit.belani@gmail.com', ''),
(3, 'ankur', 'ankur', '3ADK0709', '2', NULL, b'1', b'0', 'adkalavadia@gmail.com', ''),
(4, 'harsh', 'harsh', '4HAT0709', '1', NULL, b'0', b'0', 'harsh@email.com', ''),
(5, 'amit', 'amit', '5AXD0709', '1', NULL, b'0', b'0', 'amitcsganesh@yahoo.co.in', ''),
(6, 'chirag', 'chirag', '6CJJ0709', '1', NULL, b'0', b'0', 'jagtiani.chirag@gmail.com', ''),
(7, 'sumeet', 'sumeet', '7SHM0709', '2', NULL, b'0', b'0', 'sumeet.mistry@gmail.com', '');

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

--
-- Table structure for table `_webuserprofile`
--

CREATE TABLE IF NOT EXISTS `_webuserprofile` (
`userid` int(50) NOT NULL auto_increment,
`node_id` varchar(20) default NULL,
`first_nm` varchar(50) NOT NULL,
`middle_nm` varchar(20) NOT NULL,
`father_nm` varchar(20) NOT NULL,
`last_nm` varchar(50) NOT NULL,
`initial` varchar(5) NOT NULL,
`dob` varchar(20) default NULL,
`gender` varchar(10) default NULL,
`bldgroup` varchar(10) default NULL,
`per_add` varchar(100) default NULL,
`cur_add` varchar(100) default NULL,
`per_city` varchar(20) default NULL,
`cur_city` varchar(30) default NULL,
`per_state` varchar(30) default NULL,
`cur_state` varchar(20) default NULL,
`per_country` varchar(30) default NULL,
`cur_country` varchar(30) default NULL,
`res_number` varchar(20) default NULL,
`mob_number` varchar(20) default NULL,
`office_number` varchar(20) default NULL,
`personal_email` varchar(30) default NULL,
`office_email` varchar(30) default NULL,
`doj` varchar(20) default NULL,
`pan_no` varchar(10) default NULL,
PRIMARY KEY (`userid`),
KEY `client_id` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `_webuserprofile`
--

INSERT INTO `webuserprofile` (`userid`, `nodeid`, `firstnm`, `middlenm`, `fathernm`, `lastnm`, `initial`, `dob`, `gender`, `bldgroup`, `peradd`, `curadd`, `percity`, `curcity`, `perstate`, `curstate`, `percountry`, `curcountry`, `resnumber`, `mobnumber`, `officenumber`, `personalemail`, `officeemail`, `doj`, `panno`) VALUES
(1, NULL, 'Vineet', 'xoxox', 'xoxox', 'xoxox', 'VXZ', NULL, 'male', NULL, NULL, NULL, 'Baroda', 'Baroda', 'Gujarat', 'Gujarat', 'India', 'India', '000000', '111111', '222222', 'vineet@email.com', NULL, NULL, NULL),
(2, NULL, 'Punit', 'Jitendra', 'Jitendra', 'Belani', 'PJB', NULL, 'Male', NULL, 'Kalawad Road', 'Alembic Colony', 'Rajkot', 'Baroda', 'Gujarat', 'Gujarat', 'India', 'India', '000000', '111111', '222222', 'punit.belani@gmail.com', NULL, NULL, NULL),
(3, NULL, 'Ankur', 'Dhirajlal', 'Dhirajlal', 'Kalavadia', '', '03/08/2009', 'male', 'A-', 'Raj Palace', 'Fatehgunj baroda', 'Upleta', 'Baroda', 'Gujarat', 'Gujarat', 'India', 'India', '000000', '111111', '222222', 'adkalavadia@gmail.com', '', '', ''),
(4, NULL, 'Harsh', 'Ajit Kumar', 'Ajit Kumar', 'Trivedi', '', NULL, 'Male', NULL, 'Sameer Park', 'Sameer Park', 'Baroda', 'Baroda', 'Gujarat', 'Gujarat', 'India', 'India', '000000', '111111', '222222', 'harsh@email.com', NULL, NULL, NULL),
(5, NULL, 'Amit', 'satishkumar', 'satishkumar', 'Degadwala', '', '', 'Male', 'B-', 'B-39, Naranan Nagar', 'hrut infotech', 'Bharuch', 'Baroda', 'Gujarat', 'Gujarat', 'India', 'India', '000000', '111111', '222222', 'amitcsganesh@yahoo.co.in', '', '', ''),
(6, NULL, 'Chirag', 'JogeshBhai', 'JogeshBhai', 'Jagtiani', '', NULL, 'Male', NULL, 'Gokul Nagar', 'Gokul Nagar', 'Baroda', 'Baroda', 'Gujarat', 'Gujarat', 'India', 'India', '000000', '111111', '222222', 'chirag@email.com', NULL, NULL, NULL),
(7, NULL, 'Sumeet', 'Harkishanbhai', 'Harkishanbhai', 'Mistry', '', '25/07/1986', 'Male', 'B+', '33,krishna Nagar', '33,krishna Nagar', 'Bharuch', 'Baroda', 'Gujarat', 'Gujarat', 'India', 'India', '000000', '111111', '222222', 'sumeet.mistry@gmail.com', '', '', '');

Last edited Mar 23, 2010 at 4:23 AM by ankur29, version 1

Comments

No comments yet.