-- phpMyAdmin SQL Dump
-- version 4.9.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 18, 2021 at 10:44 PM
-- Server version: 5.6.49-cll-lve
-- PHP Version: 7.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `db_task_manage`
--

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

--
-- Table structure for table `task_docs`
--

CREATE TABLE `task_docs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `task_id` int(10) UNSIGNED NOT NULL,
  `doc_name` text COLLATE utf8mb4_unicode_ci,
  `doc` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `task_docs`
--

INSERT INTO `task_docs` (`id`, `task_id`, `doc_name`, `doc`, `created_at`, `updated_at`) VALUES
(1, 9, '5f99a4ccadf6d.WhatsApp Image 2020-10-28 at 12.58.32.jpeg', '5f99a4ccadf7b.jpeg', '2020-10-29 06:05:16', '2020-10-29 06:05:16'),
(2, 12, '5f9c10348e553.WhatsApp Image 2020-10-30 at 13.07.03.jpeg', '5f9c10348e562.jpeg', '2020-10-31 02:08:04', '2020-10-31 02:08:04'),
(3, 13, '5f9db506c87de.WhatsApp Image 2020-10-31 at 18.56.42.jpeg', '5f9db506c87ee.jpeg', '2020-11-01 08:03:34', '2020-11-01 08:03:34'),
(7, 28, '5fa556cd9d7e9.report (1).xls', '5fa556cd9d7f3.xls', '2020-11-07 02:59:41', '2020-11-07 02:59:41'),
(8, 33, '5fa5864187966.SW Checklist.jpeg', '5fa586418796f.jpeg', '2020-11-07 06:22:09', '2020-11-07 06:22:09'),
(10, 36, '5fa66045c3254.5f95775b472ee.xlsx', '5fa66045c3272.xlsx', '2020-11-07 21:52:21', '2020-11-07 21:52:21'),
(11, 42, 'HOME OFFICE REQUIREMENT (STAFF LIST).docx', '5faea31da7060.docx', '2020-11-13 22:15:41', '2020-11-13 22:15:41'),
(14, 54, 'Requisition of USER & VEMDOR MEETING Tolls.docx', '5fb1117eb494b.docx', '2020-11-15 18:31:10', '2020-11-15 18:31:10'),
(15, 62, 'lion.jpg', '5fb256dc9c87b.jpg', '2020-11-16 17:39:24', '2020-11-16 17:39:24'),
(16, 57, 'GMT New.pptx', '5fb4e41f39589.pptx', '2020-11-18 16:06:39', '2020-11-18 16:06:39'),
(17, 57, 'sha gmt.pptx', '5fb4e442c47b8.pptx', '2020-11-18 16:07:14', '2020-11-18 16:07:14'),
(18, 97, 'ব্যবসায় সহযোগী অংশীদারী চুক্তিপত্র.pdf', '5fba92e7eb87d.pdf', '2020-11-22 23:33:44', '2020-11-22 23:33:44'),
(19, 99, 'Franchise mentioned.jpg', '5fbab90ac7927.jpg', '2020-11-23 02:16:26', '2020-11-23 02:16:26'),
(20, 26, 'Signed Agreement.pdf', '5fbb8dba5bb51.pdf', '2020-11-23 17:23:54', '2020-11-23 17:23:54'),
(21, 113, 'Job Requsition SHA DRIVE.docx', '5fbde13b42c7d.docx', '2020-11-25 11:44:43', '2020-11-25 11:44:43'),
(22, 121, 'SHA GROUP.pptx', '5fbede3d78f9b.pptx', '2020-11-26 05:44:13', '2020-11-26 05:44:13'),
(23, 136, 'Sha Drive Gazette invoice.pdf', '5fc15c3e38a3a.pdf', '2020-11-28 03:06:22', '2020-11-28 03:06:22'),
(24, 136, 'Sha Drive Invoice Feature Update 02- TechOrbital.pdf', '5fc15c3e3f160.pdf', '2020-11-28 03:06:22', '2020-11-28 03:06:22'),
(25, 139, 'Ariful Islam Biodata_20201128_000029225.pdf', '5fc24980ec05f.pdf', '2020-11-28 19:58:40', '2020-11-28 19:58:40'),
(26, 129, 'Screenshot (28).png', '5fc2abc401465.png', '2020-11-29 02:57:56', '2020-11-29 02:57:56'),
(27, 138, 'OFFICE NOTICE From IT Department.docx', '5fc33881a2c9a.docx', '2020-11-29 12:58:25', '2020-11-29 12:58:25'),
(28, 125, 'DrivingLicenseBack.jpeg', '5fc393961365d.jpeg', '2020-11-29 19:27:02', '2020-11-29 19:27:02'),
(29, 125, 'NIDorPassport.jpeg', '5fc39e82b8792.jpeg', '2020-11-29 20:13:38', '2020-11-29 20:13:38'),
(30, 125, 'NIDorPassport.jpeg', '5fc3a1c7a6397.jpeg', '2020-11-29 20:27:35', '2020-11-29 20:27:35'),
(35, 148, 'WhatsApp Image 2020-11-30 at 14.13.46 (2).jpeg', '5fc4fe506b76e.jpeg', '2020-11-30 21:14:40', '2020-11-30 21:14:40'),
(36, 148, 'WhatsApp Image 2020-11-30 at 14.13.46 (1).jpeg', '5fc4fe506bb8f.jpeg', '2020-11-30 21:14:40', '2020-11-30 21:14:40'),
(37, 148, 'WhatsApp Image 2020-11-30 at 14.13.46.jpeg', '5fc4fe506bf9a.jpeg', '2020-11-30 21:14:40', '2020-11-30 21:14:40'),
(38, 148, 'WhatsApp Image 2020-11-30 at 14.13.45.jpeg', '5fc4fe506c359.jpeg', '2020-11-30 21:14:40', '2020-11-30 21:14:40'),
(40, 149, 'WhatsApp Image 2020-11-30 at 14.13.46 (3).jpeg', '5fc50c3ae5614.jpeg', '2020-11-30 22:14:02', '2020-11-30 22:14:02'),
(41, 149, 'WhatsApp Image 2020-11-30 at 14.13.46 (2).jpeg', '5fc50c3ae5a99.jpeg', '2020-11-30 22:14:02', '2020-11-30 22:14:02'),
(42, 149, 'WhatsApp Image 2020-11-30 at 14.13.46 (1).jpeg', '5fc50c3ae5e8b.jpeg', '2020-11-30 22:14:02', '2020-11-30 22:14:02'),
(44, 158, 'Job Requsition Shaprime.docx', '5fc72aed3a82a.docx', '2020-12-02 12:49:33', '2020-12-02 12:49:33'),
(45, 158, 'Software Developer job.docx', '5fc72b755ff12.docx', '2020-12-02 12:51:49', '2020-12-02 12:51:49'),
(46, 119, 'Legal doc list.xlsx', '5fc75b765d51d.xlsx', '2020-12-02 16:16:38', '2020-12-02 16:16:38'),
(47, 26, 'Signed Agreemnt.pdf', '5fc79a05d9284.pdf', '2020-12-02 20:43:33', '2020-12-02 20:43:33'),
(48, 26, 'sunnah  terms.docx', '5fc79a05dba2a.docx', '2020-12-02 20:43:33', '2020-12-02 20:43:33'),
(49, 26, 'Sunnah Agreement - PDF.pdf', '5fc79a05dc0f8.pdf', '2020-12-02 20:43:33', '2020-12-02 20:43:33'),
(50, 26, 'Sunnah Agreement.docx', '5fc79a05df5d6.docx', '2020-12-02 20:43:33', '2020-12-02 20:43:33'),
(51, 26, 'Sunnah Money Transfer_All KYC.pdf', '5fc79a05dfadd.pdf', '2020-12-02 20:43:33', '2020-12-02 20:43:33'),
(52, 26, 'TFL HOME OFFICE DOC.pdf', '5fc79a05e6a50.pdf', '2020-12-02 20:43:33', '2020-12-02 20:43:33'),
(53, 26, 'WhatsApp Image 2020-11-06 at 13.02.34 (1).jpeg', '5fc79a05e790a.jpeg', '2020-12-02 20:43:33', '2020-12-02 20:43:33'),
(54, 26, 'WhatsApp Image 2020-11-06 at 13.02.34.jpeg', '5fc79a05e7d5f.jpeg', '2020-12-02 20:43:33', '2020-12-02 20:43:33'),
(55, 26, 'Agreement Sign Page.jpg', '5fc79a478e6a7.jpg', '2020-12-02 20:44:39', '2020-12-02 20:44:39'),
(56, 26, 'Barakah Agreement - PDF.pdf', '5fc79a4790091.pdf', '2020-12-02 20:44:39', '2020-12-02 20:44:39'),
(57, 26, 'Agreement _4.jpg', '5fc79a7bf3dad.jpg', '2020-12-02 20:45:32', '2020-12-02 20:45:32'),
(58, 26, 'Agreement _5.jpg', '5fc79a7c02076.jpg', '2020-12-02 20:45:32', '2020-12-02 20:45:32'),
(59, 26, 'Agreement 3.jpg', '5fc79a7c02fe3.jpg', '2020-12-02 20:45:32', '2020-12-02 20:45:32'),
(60, 26, 'Agreement 6.jpg', '5fc79a7c04294.jpg', '2020-12-02 20:45:32', '2020-12-02 20:45:32'),
(61, 26, 'Agreement Last Page.jpg', '5fc79a7c04f22.jpg', '2020-12-02 20:45:32', '2020-12-02 20:45:32'),
(62, 26, 'Agreement_1.jpg', '5fc79a7c05b25.jpg', '2020-12-02 20:45:32', '2020-12-02 20:45:32'),
(63, 26, 'Agreement_Front.jpg', '5fc79a7c06d7c.jpg', '2020-12-02 20:45:32', '2020-12-02 20:45:32'),
(64, 26, 'Application Form.pdf', '5fc79a7c08705.pdf', '2020-12-02 20:45:32', '2020-12-02 20:45:32'),
(65, 26, 'Madina Agreement - PDF.pdf', '5fc79a7c0b0eb.pdf', '2020-12-02 20:45:32', '2020-12-02 20:45:32'),
(66, 26, 'Madina Agreement.docx', '5fc79a7c0cbd0.docx', '2020-12-02 20:45:32', '2020-12-02 20:45:32'),
(67, 26, 'Madina Corp LTD Terms.docx', '5fc79a7c0d10b.docx', '2020-12-02 20:45:32', '2020-12-02 20:45:32'),
(68, 26, 'Shop Pic 1.jpeg', '5fc79a7c0d441.jpeg', '2020-12-02 20:45:32', '2020-12-02 20:45:32'),
(69, 26, 'Shop Pic 2.jpeg', '5fc79a7c0db0c.jpeg', '2020-12-02 20:45:32', '2020-12-02 20:45:32'),
(70, 26, 'UTR_1.jpg', '5fc79a7c0dfb9.jpg', '2020-12-02 20:45:32', '2020-12-02 20:45:32'),
(71, 26, 'UTR_2.jpg', '5fc79a7c0e4aa.jpg', '2020-12-02 20:45:32', '2020-12-02 20:45:32'),
(72, 26, 'Signed Agreement.pdf', '5fc79aa11627e.pdf', '2020-12-02 20:46:09', '2020-12-02 20:46:09'),
(73, 26, 'Signed Agreement.pdf', '5fc79ac47c130.pdf', '2020-12-02 20:46:44', '2020-12-02 20:46:44'),
(74, 26, 'Both Party Signed agreement 25.11.2020.pdf', '5fc79adf9fbef.pdf', '2020-12-02 20:47:11', '2020-12-02 20:47:11'),
(75, 26, '03092020_HKPG Correspondent Agreement Worldwide West 2 East (signed).pdf', '5fc79bfe67a35.pdf', '2020-12-02 20:51:58', '2020-12-02 20:51:58'),
(76, 26, 'Agreement_1- 25.11.2020.pdf', '5fc79c2a34197.pdf', '2020-12-02 20:52:42', '2020-12-02 20:52:42'),
(77, 26, 'Agreement_2 - 25.11.2020.pdf', '5fc79c2a3588a.pdf', '2020-12-02 20:52:42', '2020-12-02 20:52:42'),
(78, 26, 'CIAXA _1.pdf', '5fc79c2a35d0f.pdf', '2020-12-02 20:52:42', '2020-12-02 20:52:42'),
(79, 26, 'Ciaxa Agreement 2.pdf', '5fc79c2a39b4d.pdf', '2020-12-02 20:52:42', '2020-12-02 20:52:42'),
(80, 26, 'Ciaxa Agreement 3.pdf', '5fc79c2a3a224.pdf', '2020-12-02 20:52:42', '2020-12-02 20:52:42'),
(81, 26, 'Ciaxa Agreement 4.pdf', '5fc79c2a3a83c.pdf', '2020-12-02 20:52:42', '2020-12-02 20:52:42'),
(82, 26, 'Ciaxa Agreement 5.pdf', '5fc79c2a3abcd.pdf', '2020-12-02 20:52:42', '2020-12-02 20:52:42'),
(83, 26, 'Ciaxa Agreement 6.pdf', '5fc79c2a3b281.pdf', '2020-12-02 20:52:42', '2020-12-02 20:52:42'),
(84, 26, 'Ciaxa Agreement 7.pdf', '5fc79c2a3b786.pdf', '2020-12-02 20:52:42', '2020-12-02 20:52:42'),
(85, 26, 'Ciaxa Agreement 8.pdf', '5fc79c2a3bbf1.pdf', '2020-12-02 20:52:42', '2020-12-02 20:52:42'),
(86, 26, 'ciaxa agreement.pdf', '5fc79c2a3c010.pdf', '2020-12-02 20:52:42', '2020-12-02 20:52:42'),
(87, 26, 'Ciaxa Bank Agreement 1.pdf', '5fc79c2a3c504.pdf', '2020-12-02 20:52:42', '2020-12-02 20:52:42'),
(88, 26, 'Ciaxa_2.pdf', '5fc79c2a3c896.pdf', '2020-12-02 20:52:42', '2020-12-02 20:52:42'),
(89, 26, 'Ciaxa_3.pdf', '5fc79c2a40f56.pdf', '2020-12-02 20:52:42', '2020-12-02 20:52:42'),
(90, 26, 'Latest Commercials.pdf', '5fc79c2a419a6.pdf', '2020-12-02 20:52:42', '2020-12-02 20:52:42'),
(91, 26, 'Jamuna Updated Agreement.pdf', '5fc7a07340c5e.pdf', '2020-12-02 21:10:59', '2020-12-02 21:10:59'),
(92, 160, 'Jamuna Updated Agreement.pdf', '5fc7a0fed9300.pdf', '2020-12-02 21:13:18', '2020-12-02 21:13:18'),
(93, 187, '04 SHA GROUP LEAVE POLICY - ok.docx', '5fca890fcfbdf.docx', '2020-12-05 02:07:59', '2020-12-05 02:07:59'),
(94, 188, 'image.png', '5fccceb459b98.png', '2020-12-06 19:29:40', '2020-12-06 19:29:40'),
(95, 141, 'T shirt and mask distribution.pdf', '5fcdfecc92629.pdf', '2020-12-07 17:07:08', '2020-12-07 17:07:08'),
(96, 196, 'Uk Leave policy.docx', '5fd106faee116.docx', '2020-12-10 00:18:50', '2020-12-10 00:18:50'),
(97, 204, 'over_due_tasks_report.pdf', '5fd7d939eeb6a.pdf', '2020-12-15 04:29:30', '2020-12-15 04:29:30'),
(98, 82, 'Cookie Policy - SHA Global.docx', '5fdb3bd590be9.docx', '2020-12-17 18:07:02', '2020-12-17 18:07:02'),
(99, 231, 'sign board sample.jpeg', '5fe3a2df40db3.jpeg', '2020-12-24 03:04:47', '2020-12-24 03:04:47'),
(101, 236, 'Ecommerce Web Design.docx', '5fea5fbcea870.docx', '2020-12-29 05:44:12', '2020-12-29 05:44:12'),
(102, 236, 'Mobile App Page.docx', '5fea5fbceade8.docx', '2020-12-29 05:44:12', '2020-12-29 05:44:12'),
(103, 236, 'Web Design For Business page.docx', '5fea5fbcecec2.docx', '2020-12-29 05:44:12', '2020-12-29 05:44:12'),
(104, 236, 'Web Marketing Page Design.docx', '5fea5fbced2a6.docx', '2020-12-29 05:44:12', '2020-12-29 05:44:12'),
(106, 235, '04 SHA GROUP LEAVE POLICY -Jan_2021 ok.docx', '5ff14bef29c6b.docx', '2021-01-03 11:45:35', '2021-01-03 11:45:35'),
(108, 256, 'sha drive discount.jpeg', '5ff5e2381188d.jpeg', '2021-01-06 23:15:52', '2021-01-06 23:15:52'),
(109, 264, 'Leave record template.xlsm', '5ffc7c5263346.xlsm', '2021-01-11 23:26:58', '2021-01-11 23:26:58'),
(110, 239, 'SHA Group Yearly Employee training program.pdf', '5ffe90693d0a9.pdf', '2021-01-13 13:17:13', '2021-01-13 13:17:13'),
(112, 274, '72644971-E00B-49A4-AD0C-B527CAB712FE.jpeg', '600213432d3ce.jpeg', '2021-01-16 05:12:19', '2021-01-16 05:12:19'),
(114, 275, 'WhatsApp Image 2021-01-17 at 5.34.55 PM.jpeg', '600423c5a4f28.jpeg', '2021-01-17 18:47:17', '2021-01-17 18:47:17'),
(115, 275, 'WhatsApp Image 2021-01-17 at 5.33.02 PM.jpeg', '600423c5a5849.jpeg', '2021-01-17 18:47:17', '2021-01-17 18:47:17'),
(116, 275, 'WhatsApp Image 2021-01-17 at 5.28.50 PM.jpeg', '600423c5a5f9d.jpeg', '2021-01-17 18:47:17', '2021-01-17 18:47:17'),
(118, 276, 'Pathao car rate.jpeg', '60042cf16c4d8.jpeg', '2021-01-17 19:26:25', '2021-01-17 19:26:25'),
(119, 276, 'shohoj bike.jpeg', '60042cf16c8df.jpeg', '2021-01-17 19:26:25', '2021-01-17 19:26:25'),
(120, 276, 'uber moto.jpeg', '60042cf16f1fc.jpeg', '2021-01-17 19:26:25', '2021-01-17 19:26:25'),
(121, 276, 'uber premier.jpeg', '60042cf16f736.jpeg', '2021-01-17 19:26:25', '2021-01-17 19:26:25'),
(122, 276, 'uber x.jpeg', '60042cf16faa7.jpeg', '2021-01-17 19:26:25', '2021-01-17 19:26:25'),
(123, 241, 'Employee Recognition Program plan.pdf', '6006daa6ed693.pdf', '2021-01-19 20:12:07', '2021-01-19 20:12:07'),
(124, 301, 'Money flow.docx', '60144ea36363e.docx', '2021-01-30 01:06:27', '2021-01-30 01:06:27');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `task_docs`
--
ALTER TABLE `task_docs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=125;
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 */;
