-- phpMyAdmin SQL Dump
-- version 4.6.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 24, 2020 at 01:57 PM
-- Server version: 5.7.14
-- PHP Version: 5.6.25

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 utf8mb4 */;

--
-- Database: `attrans_new`
--

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

--
-- Table structure for table `agent`
--

CREATE TABLE `agent` (
  `id` int(11) NOT NULL,
  `code` varchar(255) DEFAULT NULL,
  `act_code` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `address` text,
  `city` varchar(255) DEFAULT NULL,
  `district` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `pincode` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `pan` varchar(255) DEFAULT NULL,
  `pan_img` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `company_id` int(11) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `created_id` int(11) DEFAULT NULL,
  `created_datetime` datetime DEFAULT NULL,
  `updated_id` int(11) DEFAULT NULL,
  `updated_datetime` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `agent`
--

INSERT INTO `agent` (`id`, `code`, `act_code`, `name`, `address`, `city`, `district`, `country`, `state`, `pincode`, `contact`, `mobile`, `email`, `pan`, `pan_img`, `status`, `company_id`, `branch_id`, `created_id`, `created_datetime`, `updated_id`, `updated_datetime`) VALUES
(2, 'A-0001', 'ACT-0042', 'heta', 'test', 'vadodara', '', '', 'gujarat', '', '9878998798', '9878998798', 'h@gmail.com', '98799', '22-08-2020-12362.PDF', 0, 1, 1, 1, '2020-08-22 13:18:59', 1, '2020-08-22 15:42:43'),
(4, 'A-0002', 'ACT-0043', 'MEET', 'TEST', 'vadodara', '', '', 'gujarat', '', '9879989698', '7899879698', 'm@gmail.com', '159879', '22-08-2020-2837.JPG', 0, 1, 1, 1, '2020-08-22 14:39:55', 1, '2020-08-22 15:41:51'),
(5, 'A-0003', 'ACT-0039', 'HITARTH', 'test', 'test', '', '', 'test', '', '', '', '', '22ASA2S', '22-08-2020-6636.PDF', 0, 1, 1, 1, '2020-08-22 15:38:01', 1, '2020-08-22 15:41:07'),
(6, 'A-0004', 'ACT-0045', 'ASDAS', 'DFSD', 'SDASDD', '', '', 'AASDSAD', '', '', '', '', '', '', 0, 1, 1, 1, '2020-08-22 16:59:55', 1, '2020-08-22 16:59:55'),
(7, 'A-0005', 'ACT-0046', 'ASDASD', 'SDASD', 'AASDAS', '', '', 'ADASDSAD', '', '', '', '', '', '', 0, 1, 1, 1, '2020-08-22 17:05:03', 1, '2020-08-22 17:08:20');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `agent`
--
ALTER TABLE `agent`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `agent`
--
ALTER TABLE `agent`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
