-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 17, 2017 at 05:49 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: `arka_ims`
--

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

--
-- Table structure for table `arka_customer_reg_master`
--

CREATE TABLE IF NOT EXISTS `arka_customer_reg_master` (
  `sl_no` int(4) NOT NULL AUTO_INCREMENT,
  `customer_id` varchar(15) NOT NULL,
  `customer_name` varchar(100) NOT NULL,
  `area` varchar(255) NOT NULL,
  `vat_no` varchar(50) NOT NULL,
  `servicetax_no` varchar(15) NOT NULL,
  `address` varchar(255) NOT NULL,
  `address2` varchar(255) NOT NULL,
  `city` varchar(25) NOT NULL,
  `state` varchar(25) NOT NULL,
  `pincode` varchar(25) NOT NULL,
  `pan_no` varchar(50) NOT NULL,
  `cst_no` varchar(50) NOT NULL,
  `contact_person` varchar(30) NOT NULL,
  `designation` varchar(30) NOT NULL,
  `mobile_no` varchar(10) NOT NULL,
  `phone_no` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `created_date` date NOT NULL,
  `created_time` time NOT NULL,
  `created_by` varchar(30) NOT NULL,
  `record_status` tinyint(4) NOT NULL,
  PRIMARY KEY (`sl_no`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=211 ;

--
-- Dumping data for table `arka_customer_reg_master`
--

INSERT INTO `arka_customer_reg_master` (`sl_no`, `customer_id`, `customer_name`, `area`, `vat_no`, `servicetax_no`, `address`, `address2`, `city`, `state`, `pincode`, `pan_no`, `cst_no`, `contact_person`, `designation`, `mobile_no`, `phone_no`, `email`, `created_date`, `created_time`, `created_by`, `record_status`) VALUES
(209, 'CUS10001', 'Mr.Valliappan', 'Guindy', '1223VAT', '23556TXN', 'Ambatur', 'Industrial Estate', 'Chennai`', 'Tamil Nadu', '600032', '1223xxdfd43', '2432CST', 'Valliappan', 'MD', '9884422461', '04481792793', 'valliappan@arkagroup.co.in', '2017-05-16', '06:22:59', 'admin', 1),
(210, 'CUS10002', 'ADROIT SOLUTIONZ', 'Ekkatuthangal', '376VT', '37STN', 'MF 15 Sidco IE', 'Guindy', 'Chennai', 'Tamil Nadu', '600032', 'S436KxPN', '877CST', 'Suresh', 'MD', '9884422641', '0492182322', 'suresh@adroitsolutionz.com', '2017-05-16', '06:31:30', 'admin', 1);