-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 192.168.17.159
-- Generation Time: Jan 24, 2023 at 06:16 AM
-- Server version: 5.6.44-log
-- PHP Version: 7.2.34

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
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: `satguru_crm_satish`
--

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

--
-- Table structure for table `account_contacts`
--

CREATE TABLE `account_contacts` (
  `contact_id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `salutation` int(11) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `middle_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `suffix` varchar(50) NOT NULL,
  `contact_owner` int(11) NOT NULL,
  `birthdate` date NOT NULL,
  `title` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `mobile` varchar(100) NOT NULL,
  `nationality` text NOT NULL,
  `reports_to` int(11) NOT NULL,
  `department` varchar(250) NOT NULL,
  `fax` varchar(250) NOT NULL,
  `mailing_street` varchar(150) NOT NULL,
  `mailing_city` varchar(150) NOT NULL,
  `mailing_state_province` varchar(150) NOT NULL,
  `mailing_zip_postal_code` varchar(150) NOT NULL,
  `mailing_country` varchar(150) NOT NULL,
  `created_by` int(11) NOT NULL,
  `status` enum('active','inactive') NOT NULL,
  `created_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_modified_by` int(11) NOT NULL,
  `updated_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `account_contacts`
--

INSERT INTO `account_contacts` (`contact_id`, `account_id`, `salutation`, `first_name`, `middle_name`, `last_name`, `suffix`, `contact_owner`, `birthdate`, `title`, `email`, `phone`, `mobile`, `nationality`, `reports_to`, `department`, `fax`, `mailing_street`, `mailing_city`, `mailing_state_province`, `mailing_zip_postal_code`, `mailing_country`, `created_by`, `status`, `created_on`, `last_modified_by`, `updated_on`) VALUES
(1, 25, 0, 'snehal ', '', 'Salave', '', 1, '1970-01-01', '', '', '', '', '', 0, '', '', '', '', '', '', '', 2, 'active', '2022-09-13 12:47:00', 2, '2022-09-13 12:47:00'),
(2, 26, 0, 'Ajay', '', 'Kumar', '', 1, '1970-01-01', '', '', '', '', '', 0, '', '', '', '', '', '', '', 2, 'active', '2022-09-13 12:47:24', 2, '2022-09-13 12:47:24'),
(3, 26, 80, 'Md', 'Shamim', 'Ansari', '', 1, '2022-06-30', 'Title Test', 'test@gmail.com', '7412589635', '7458745878', 'Indian', 1, 'Test Department', '415263', 'Mailing Street Test', 'Mailing City Test', 'Mailing State/Province Test', 'Mailing Zip/Postal Code Test', 'Mailing Country Test', 1, 'active', '2022-06-30 13:25:35', 1, '2022-09-22 15:21:21'),
(4, 25, 80, 'TEST', '', 'ABC', '', 1, '2022-07-14', '', '', '', '', '', 0, '', '', '', '', '', '', '', 1, 'active', '2022-07-14 05:51:34', 1, '2022-09-22 15:21:27'),
(5, 25, 80, 'pawan', 'r', 'Bhelkar', 's', 2, '0000-00-00', '', '', '', '', '', 4, 's', '', '', '', '', '', '', 2, 'active', '2022-09-08 16:17:07', 2, '2022-09-08 16:17:07'),
(6, 28, 80, 'Rohit', '', 'Shinde', '', 1, '0000-00-00', '', '', '', '', '', 0, '', '', '', '', '', '', '', 1, 'active', '2022-09-08 18:36:32', 1, '2022-09-08 18:36:32'),
(7, 1, 80, 'Tushar', '', 'Bagal', '', 1, '0000-00-00', '', '', '', '', '', 0, '', '', 'P1, Magarpatta Hadapsar', 'Pune', 'Maharashtra', '411013', 'India', 1, 'active', '2022-10-06 12:55:09', 1, '2022-10-06 12:55:09');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `account_contacts`
--
ALTER TABLE `account_contacts`
  ADD PRIMARY KEY (`contact_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `account_contacts`
--
ALTER TABLE `account_contacts`
  MODIFY `contact_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

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