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