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




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

--
-- Table structure for table `admin_tax`
--

CREATE TABLE IF NOT EXISTS `admin_tax` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tax` varchar(200) NOT NULL,
  `details` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `admin_tax`
--

INSERT INTO `admin_tax` (`id`, `tax`, `details`) VALUES
(1, '5', 'weekly'),
(2, '5', 'monthly'),
(3, '5', 'other');

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

--
-- Table structure for table `binary_income_value`
--

CREATE TABLE IF NOT EXISTS `binary_income_value` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `value` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `binary_income_value`
--

INSERT INTO `binary_income_value` (`id`, `value`) VALUES
(1, '350');

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

--
-- Table structure for table `color_picker`
--

CREATE TABLE IF NOT EXISTS `color_picker` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `m_id` varchar(30) NOT NULL,
  `color` varchar(50) NOT NULL,
  `css_link` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `color_picker`
--

INSERT INTO `color_picker` (`id`, `m_id`, `color`, `css_link`) VALUES
(1, 'DUKE05125214360', 'Blue', '../resources/css/colors/blue.css'),
(2, 'DUKE05125497316', 'Blue', '../resources/css/colors/blue.css'),
(3, 'DUKE05120627514', 'Blue', '../resources/css/colors/blue.css');

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

--
-- Table structure for table `inbox`
--

CREATE TABLE IF NOT EXISTS `inbox` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sender_id` varchar(50) NOT NULL,
  `receiver_id` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `message` text NOT NULL,
  `status` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `mid`
--

CREATE TABLE IF NOT EXISTS `mid` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `m_id` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `m_stock`
--

CREATE TABLE IF NOT EXISTS `m_stock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `m_id` varchar(50) NOT NULL,
  `stock_id` varchar(200) NOT NULL,
  `stock_total` varchar(200) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_name` varchar(100) NOT NULL,
  `product_code` varchar(100) NOT NULL,
  `product_amt` varchar(100) NOT NULL,
  `mrp` varchar(200) NOT NULL,
  `bv` varchar(200) NOT NULL,
  `pv` varchar(200) NOT NULL,
  `instock` varchar(100) NOT NULL,
  `sales_id` varchar(200) NOT NULL,
  `rate` varchar(200) NOT NULL,
  `vno` varchar(200) NOT NULL,
  `sales_date` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `m_stock`
--

INSERT INTO `m_stock` (`id`, `m_id`, `stock_id`, `stock_total`, `product_id`, `product_name`, `product_code`, `product_amt`, `mrp`, `bv`, `pv`, `instock`, `sales_id`, `rate`, `vno`, `sales_date`) VALUES
(1, 'DUKE05125214360', '1', '20', 1, 'Baby Bar', '', '120', '200', '80', '40', '2', '1', '240', '0001', '19-05-2012'),
(2, 'DUKE05125214360', '3', '50', 2, 'Tiger ', '', '190', '253', '33', '3', '2', '1', '380', '0001', '19-05-2012');

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

--
-- Table structure for table `online_members`
--

CREATE TABLE IF NOT EXISTS `online_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `m_id` varchar(10) NOT NULL,
  `status` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `online_members`
--

INSERT INTO `online_members` (`id`, `m_id`, `status`) VALUES
(1, 'DUKE051252', 'Offline'),
(2, 'DUKE051254', 'Offline'),
(3, 'DUKE051206', 'Offline');

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

--
-- Table structure for table `outbox`
--

CREATE TABLE IF NOT EXISTS `outbox` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sender_id` varchar(50) NOT NULL,
  `receiver_id` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `message` text NOT NULL,
  `status` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `payment`
--

CREATE TABLE IF NOT EXISTS `payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `m_id` varchar(50) NOT NULL,
  `unpaid_left_total` varchar(100) NOT NULL,
  `unpaid_right_total` varchar(30) NOT NULL,
  `paid_left_pair` varchar(200) NOT NULL,
  `paid_right_pair` varchar(200) NOT NULL,
  `carry_forword_left` varchar(200) NOT NULL,
  `carry_forword_right` varchar(200) NOT NULL,
  `closing_type` varchar(200) NOT NULL,
  `weekly_count` varchar(200) NOT NULL,
  `total_repurchase` varchar(30) NOT NULL,
  `binary_income` varchar(30) NOT NULL,
  `own_pv` varchar(100) NOT NULL,
  `total_income` varchar(30) NOT NULL,
  `gross_pay` varchar(50) NOT NULL,
  `tds_amt` varchar(50) NOT NULL,
  `tax_pay` varchar(50) NOT NULL,
  `net_pay` varchar(50) NOT NULL,
  `paid_amt` varchar(30) NOT NULL,
  `pay_date` varchar(50) NOT NULL,
  `entry_date` varchar(100) NOT NULL,
  `pay_period` varchar(100) NOT NULL,
  `voucher_no` varchar(20) NOT NULL,
  `status` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `pin`
--

CREATE TABLE IF NOT EXISTS `pin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pin_no` varchar(100) NOT NULL,
  `gen_id` varchar(30) NOT NULL,
  `gen_name` varchar(50) NOT NULL,
  `gen_date` varchar(20) NOT NULL,
  `hold_id` varchar(30) NOT NULL,
  `hold_name` varchar(50) NOT NULL,
  `hold_date` varchar(20) NOT NULL,
  `pin_status` varchar(20) NOT NULL,
  `wt` int(11) NOT NULL,
  `jamt` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pin_no` (`pin_no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `pin`
--

INSERT INTO `pin` (`id`, `pin_no`, `gen_id`, `gen_name`, `gen_date`, `hold_id`, `hold_name`, `hold_date`, `pin_status`, `wt`, `jamt`) VALUES
(1, '5389276453786398', 'admin', 'DUKE', '19-05-2012', 'DUKE05125214360', 'A', '19-05-2012', 'Used', 1, '1'),
(2, '0835480082565702', 'admin', 'DUKE', '19-05-2012', 'DUKE05125497316', 'A1', '19-05-2012', 'Used', 1, '1'),
(3, '9645264730620083', 'admin', 'DUKE', '19-05-2012', 'DUKE05120627514', 'A1', '19-05-2012', 'Used', 1, '1'),
(4, '3012753217287513', 'admin', 'DUKE', '19-05-2012', '', '', '', 'Active', 1, '1'),
(5, '6971543238063940', 'admin', 'DUKE', '19-05-2012', '', '', '', 'Active', 1, '1'),
(6, '7042608948317208', 'admin', 'DUKE', '19-05-2012', '', '', '', 'Active', 1, '1'),
(7, '1023867258416471', 'admin', 'DUKE', '19-05-2012', '', '', '', 'Active', 2, '1'),
(8, '0725048532006392', 'admin', 'DUKE', '19-05-2012', '', '', '', 'Active', 2, '1'),
(9, '2300456379861847', 'admin', 'DUKE', '19-05-2012', '', '', '', 'Active', 2, '1'),
(10, '3781260589602034', 'admin', 'DUKE', '19-05-2012', '', '', '', 'Active', 2, '1'),
(11, '0296984156906418', 'admin', 'DUKE', '19-05-2012', '', '', '', 'Active', 2, '1');

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

--
-- Table structure for table `pin_amount`
--

CREATE TABLE IF NOT EXISTS `pin_amount` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pin_type` varchar(200) NOT NULL,
  `pin_amount` varchar(50) NOT NULL,
  `bv` varchar(100) NOT NULL,
  `package` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

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

--
-- Table structure for table `product`
--

CREATE TABLE IF NOT EXISTS `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_name` varchar(100) NOT NULL,
  `mrp` varchar(100) NOT NULL,
  `dp` varchar(100) NOT NULL,
  `bv` varchar(100) NOT NULL,
  `pv` varchar(100) NOT NULL,
  `product_date` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`id`, `product_name`, `mrp`, `dp`, `bv`, `pv`, `product_date`) VALUES
(1, 'Baby Bar', '200', '120', '80', '40', '11-05-2012'),
(2, 'Tiger ', '253', '190', '33', '3', '12-05-2012');

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

--
-- Table structure for table `profile_photo`
--

CREATE TABLE IF NOT EXISTS `profile_photo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `m_id` varchar(30) NOT NULL,
  `image` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `rsrv_mid`
--

CREATE TABLE IF NOT EXISTS `rsrv_mid` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `m_id` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

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

--
-- Table structure for table `rsrv_product`
--

CREATE TABLE IF NOT EXISTS `rsrv_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `m_id` varchar(200) NOT NULL,
  `stock_id` varchar(200) NOT NULL,
  `stock_total` varchar(200) NOT NULL,
  `p_id` varchar(200) NOT NULL,
  `product_code` varchar(200) NOT NULL,
  `product_name` varchar(200) NOT NULL,
  `mrp` varchar(200) NOT NULL,
  `dp` varchar(200) NOT NULL,
  `bv` varchar(200) NOT NULL,
  `pv` varchar(200) NOT NULL,
  `qty` varchar(100) NOT NULL,
  `rate` varchar(200) NOT NULL,
  `delivered` varchar(200) NOT NULL,
  `delivery_date` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sale_report`
--

CREATE TABLE IF NOT EXISTS `sale_report` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `m_id` varchar(100) NOT NULL,
  `gsp` varchar(50) NOT NULL,
  `lsd` varchar(50) NOT NULL,
  `tax` varchar(50) NOT NULL,
  `nsp` varchar(50) NOT NULL,
  `pp` varchar(50) NOT NULL,
  `lsd_prcnt` varchar(10) NOT NULL,
  `tx_prcnt` varchar(10) NOT NULL,
  `vouchar_no` varchar(200) NOT NULL,
  `date` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `sale_report`
--

INSERT INTO `sale_report` (`id`, `m_id`, `gsp`, `lsd`, `tax`, `nsp`, `pp`, `lsd_prcnt`, `tx_prcnt`, `vouchar_no`, `date`) VALUES
(1, 'DUKE05125214360', '620', '0', '0', '620', '620', '0', '0', '0001', '19-05-2012');

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

--
-- Table structure for table `spid`
--

CREATE TABLE IF NOT EXISTS `spid` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sp_id` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

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

--
-- Table structure for table `stock`
--

CREATE TABLE IF NOT EXISTS `stock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` varchar(200) NOT NULL,
  `product_qty` varchar(200) NOT NULL,
  `stock_date` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `stock`
--

INSERT INTO `stock` (`id`, `product_id`, `product_qty`, `stock_date`) VALUES
(1, '1', '18', '12-05-2012'),
(3, '2', '48', '12-05-2012');

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

--
-- Table structure for table `tds`
--

CREATE TABLE IF NOT EXISTS `tds` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tds` varchar(200) NOT NULL,
  `details` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `tds`
--

INSERT INTO `tds` (`id`, `tds`, `details`) VALUES
(1, '10', 'with_pan_weekly'),
(2, '20', 'without_pan_weekly'),
(3, '10', 'with_pan_monthly'),
(4, '20', 'without_pan_monthly'),
(5, '10', 'with_pan_policy'),
(6, '20', 'without_pan_policy');

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

--
-- Table structure for table `title_value`
--

CREATE TABLE IF NOT EXISTS `title_value` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title_value` varchar(200) NOT NULL,
  `website_value` varchar(255) NOT NULL,
  `logo_value` text NOT NULL,
  `footer_value` text NOT NULL,
  `receipt_value` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `title_value`
--

INSERT INTO `title_value` (`id`, `title_value`, `website_value`, `logo_value`, `footer_value`, `receipt_value`) VALUES
(1, 'Duke Networks', 'http://www.dukewellness.in/', 'DUKE NETWORKS', 'Duke Networks', 'DUKE NETWORKS');

