-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 27, 2024 at 12:01 PM
-- Server version: 10.4.16-MariaDB
-- PHP Version: 7.4.12

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: `runo`
--

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

--
-- Table structure for table `blank_template`
--

CREATE TABLE `blank_template` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `mobile` double DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `pincode` int(11) DEFAULT NULL,
  `alternate_name` varchar(255) DEFAULT NULL,
  `alternate_phone` varchar(255) DEFAULT NULL,
  `priority` varchar(255) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `appt_date` varchar(255) DEFAULT NULL,
  `reason1` varchar(255) DEFAULT NULL,
  `reason2` varchar(255) DEFAULT NULL,
  `reason3` varchar(255) DEFAULT NULL,
  `callback_date` varchar(255) DEFAULT NULL,
  `reason4` varchar(255) DEFAULT NULL,
  `customer_type` varchar(255) DEFAULT NULL,
  `loan_type` varchar(255) DEFAULT NULL,
  `net_salary` varchar(255) DEFAULT NULL,
  `net_salary2` varchar(255) DEFAULT NULL,
  `loan_amount` varchar(255) DEFAULT NULL,
  `business_loan` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` text NOT NULL,
  `mobile` double NOT NULL,
  `email` varchar(255) NOT NULL,
  `company_name` text NOT NULL,
  `street` text DEFAULT NULL,
  `city` text DEFAULT NULL,
  `state` text DEFAULT NULL,
  `country` text DEFAULT NULL,
  `pincode` int(11) DEFAULT NULL,
  `alternate_name` text DEFAULT NULL,
  `alternate_phone` double DEFAULT NULL,
  `priority` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `reason` text DEFAULT NULL,
  `appt_date` datetime DEFAULT NULL,
  `reason1` text DEFAULT NULL,
  `reason2` text DEFAULT NULL,
  `reason3` text DEFAULT NULL,
  `callback_date` datetime DEFAULT NULL,
  `reason4` text DEFAULT NULL,
  `customer_type` text DEFAULT NULL,
  `loan_type` int(11) DEFAULT NULL,
  `net_salary` int(11) DEFAULT NULL,
  `net_salary2` int(11) DEFAULT NULL,
  `loan_amount` int(11) DEFAULT NULL,
  `business_loan` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `flag` int(11) NOT NULL COMMENT '): show 1:hide'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`id`, `user_id`, `name`, `mobile`, `email`, `company_name`, `street`, `city`, `state`, `country`, `pincode`, `alternate_name`, `alternate_phone`, `priority`, `notes`, `status`, `reason`, `appt_date`, `reason1`, `reason2`, `reason3`, `callback_date`, `reason4`, `customer_type`, `loan_type`, `net_salary`, `net_salary2`, `loan_amount`, `business_loan`, `created_at`, `updated_at`, `flag`) VALUES
(1, 1, 'Kim Taehyung', 9988776655, 'tae@gmail.com', 'bts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Busy on call', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-21 08:31:33', '2024-04-24 13:05:22', 0),
(2, 2, 'salman khan', 6677886655, 'sallu@gmail.com', 'bollywood', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-21 08:31:33', '2024-04-24 13:05:31', 0),
(3, 1, 'Allu Arjun', 9098776699, 'allu@gmail.com', 'tollywood', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NA', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-21 08:31:33', '2024-04-26 07:24:10', 1),
(4, 2, 'Amrapali dube', 9090909090, 'amrapali@gmail.com', 'bhojiwood', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Ringing', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-21 08:31:33', '2024-04-24 13:05:46', 0),
(5, 1, 'Anjelina Joli', 7788990088, 'anjelina@gmail.com', 'hollywood', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'closed', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-21 08:31:33', '2024-04-27 03:25:23', 1),
(6, 2, 'anil ambani', 7788990088, 'anil@gmail.com', 'reliance', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-21 08:31:33', '2024-04-27 03:25:23', 1),
(7, 1, 'lee min ho', 7788990088, 'lee@gmail.com', 'bts', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-04-21 08:31:33', '2024-04-27 03:25:23', 1);

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

--
-- Table structure for table `interaction`
--

CREATE TABLE `interaction` (
  `id` int(11) NOT NULL,
  `cust_id` int(11) NOT NULL,
  `status` varchar(255) NOT NULL,
  `priority` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `interaction`
--

INSERT INTO `interaction` (`id`, `cust_id`, `status`, `priority`, `created_at`, `updated_at`) VALUES
(1, 3, 'busy', 'high', '2024-04-26 07:24:10', '2024-04-26 07:24:10');

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

--
-- Table structure for table `mobile_template`
--

CREATE TABLE `mobile_template` (
  `id` int(11) NOT NULL,
  `mobile` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `process` text NOT NULL,
  `designation` varchar(255) NOT NULL,
  `report` varchar(255) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `name`, `email`, `process`, `designation`, `report`, `updated_at`, `created_at`) VALUES
(1, 'Anuradha', 'anu@gmail.com', 'abcd', 'counseller', 'abcd', '2024-04-21 07:07:33', '2024-04-21 07:07:33'),
(2, 'Archana', 'archu@gmail.com', 'abcd', 'telecaller', 'abcd', '2024-04-21 07:08:46', '2024-04-21 07:08:46'),
(3, 'amarnath', 'amarnath@gmail.com', 'abcd', 'admin', 'abcd', '2024-04-21 08:18:21', '2024-04-21 07:09:36');

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

--
-- Table structure for table `user_permission`
--

CREATE TABLE `user_permission` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_web_panel` int(11) NOT NULL COMMENT '0:Inactive  1:Active',
  `admin_web_panel` int(11) NOT NULL COMMENT '0:Inactive 1:Active',
  `play_call_recording` int(11) NOT NULL COMMENT '0:Inactive 1:Active',
  `download_call_recording` int(11) NOT NULL COMMENT '0:Inactive  1:Active',
  `delete_customer` int(11) NOT NULL COMMENT '0:Inactive 1:Active',
  `delete_personal_call` int(11) NOT NULL COMMENT '0:Inactive 1:Active',
  `interaction_popup` int(11) NOT NULL COMMENT '0:Inactive 1:Active',
  `call_tracking` int(11) NOT NULL COMMENT '0:Inactive 1:Active',
  `process_admin` int(11) NOT NULL COMMENT '0:Inactive 1:Active',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_permission`
--

INSERT INTO `user_permission` (`id`, `user_id`, `user_web_panel`, `admin_web_panel`, `play_call_recording`, `download_call_recording`, `delete_customer`, `delete_personal_call`, `interaction_popup`, `call_tracking`, `process_admin`, `updated_at`, `created_at`) VALUES
(1, 1, 1, 0, 0, 1, 0, 1, 0, 0, 1, '2024-04-21 07:07:33', '2024-04-21 07:07:33'),
(2, 2, 1, 0, 0, 1, 0, 1, 0, 0, 1, '2024-04-21 07:08:46', '2024-04-21 07:08:46'),
(3, 3, 1, 0, 0, 0, 1, 0, 1, 0, 1, '2024-04-21 08:18:21', '2024-04-21 07:09:36');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `blank_template`
--
ALTER TABLE `blank_template`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `interaction`
--
ALTER TABLE `interaction`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mobile_template`
--
ALTER TABLE `mobile_template`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `user_permission`
--
ALTER TABLE `user_permission`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
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 */;
