/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.16-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: weblinkltd_tickets
-- ------------------------------------------------------
-- Server version	10.11.16-MariaDB

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `assigns`
--

DROP TABLE IF EXISTS `assigns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `assigns` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `task_id` int(11) DEFAULT NULL,
  `assign_by` int(11) DEFAULT NULL,
  `assign_to` int(11) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `assigned_at` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `assigns`
--

LOCK TABLES `assigns` WRITE;
/*!40000 ALTER TABLE `assigns` DISABLE KEYS */;
INSERT INTO `assigns` VALUES
(1,1,3,4,'Do it in next 2days.','2022-07-25 09:54:37','2022-07-25 03:54:37','2022-07-25 03:54:37'),
(2,2,3,4,'Task done in 4th August.','2022-07-25 10:01:16','2022-07-25 04:01:16','2022-07-25 04:01:16'),
(3,3,3,4,'Talk to Mr.Partho for details.','2022-07-25 10:56:14','2022-07-25 04:56:14','2022-07-25 04:56:14'),
(4,3,4,5,'Please give me related resource.','2022-07-25 10:57:45','2022-07-25 04:57:45','2022-07-25 04:57:45');
/*!40000 ALTER TABLE `assigns` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `comments`
--

DROP TABLE IF EXISTS `comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `task_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `comment` longtext DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` tinyint(4) NOT NULL,
  `updated_by` tinyint(4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `comments`
--

LOCK TABLES `comments` WRITE;
/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
INSERT INTO `comments` VALUES
(1,2,4,'done',1,4,NULL,'2022-07-31 09:18:26',NULL),
(2,2,4,'Functional and Non-functional requirement listing.',1,4,NULL,'2022-07-31 09:19:49',NULL);
/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `daily_other_schedules`
--

DROP TABLE IF EXISTS `daily_other_schedules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `daily_other_schedules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `emp_id` int(11) NOT NULL,
  `other_emp_id` int(11) DEFAULT NULL,
  `date` date NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `updated_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `daily_other_schedules`
--

LOCK TABLES `daily_other_schedules` WRITE;
/*!40000 ALTER TABLE `daily_other_schedules` DISABLE KEYS */;
/*!40000 ALTER TABLE `daily_other_schedules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `departments`
--

DROP TABLE IF EXISTS `departments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `departments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `description` varchar(191) DEFAULT NULL,
  `color` varchar(200) DEFAULT '#ffffff',
  `order_id` int(11) DEFAULT NULL,
  `created_by` tinyint(4) DEFAULT NULL,
  `updated_by` tinyint(4) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `departments`
--

LOCK TABLES `departments` WRITE;
/*!40000 ALTER TABLE `departments` DISABLE KEYS */;
INSERT INTO `departments` VALUES
(1,'Software',NULL,'danger',1,1,1,1,NULL,NULL),
(2,'ISP',NULL,'info',2,1,1,1,NULL,NULL),
(3,'Sales',NULL,'success',3,1,1,1,NULL,NULL),
(4,'Accounts',NULL,'primary',4,1,1,1,NULL,NULL),
(5,'Administration',NULL,'dark',5,1,1,1,NULL,NULL),
(6,'Store',NULL,'secondary',6,1,1,0,NULL,NULL),
(7,'Executive Committee',NULL,'warning',7,1,1,0,NULL,NULL),
(8,'Public',NULL,'#ffffff',NULL,1,1,1,'2022-08-04 09:25:41','2022-08-04 09:25:41');
/*!40000 ALTER TABLE `departments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `designations`
--

DROP TABLE IF EXISTS `designations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `designations` (
  `id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) NOT NULL,
  `remark` text DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `created_by` tinyint(4) DEFAULT NULL,
  `updated_by` tinyint(4) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `designations`
--

LOCK TABLES `designations` WRITE;
/*!40000 ALTER TABLE `designations` DISABLE KEYS */;
INSERT INTO `designations` VALUES
(1,'Manager',NULL,3,NULL,NULL,1,NULL,NULL),
(2,'Ass. Manager (Admin)',NULL,4,NULL,NULL,1,NULL,NULL),
(3,'Officer',NULL,5,NULL,NULL,1,NULL,NULL),
(4,'Accounts Manager',NULL,8,NULL,NULL,1,NULL,NULL),
(5,'House keeping Officer',NULL,9,NULL,NULL,1,NULL,NULL),
(6,'Admin Department',NULL,10,NULL,NULL,1,NULL,NULL),
(7,'Computer Operator',NULL,11,NULL,NULL,1,NULL,NULL),
(8,'Receptionist',NULL,12,NULL,NULL,1,NULL,NULL),
(9,'Cashier',NULL,13,NULL,NULL,1,NULL,NULL),
(10,'Cleaner',NULL,18,NULL,NULL,1,NULL,NULL),
(11,'Peon',NULL,21,NULL,NULL,1,NULL,NULL),
(12,'Store Keeper',NULL,22,NULL,NULL,1,NULL,NULL),
(13,'Store Officer',NULL,23,NULL,NULL,1,NULL,NULL),
(14,'Accounts Officer',NULL,24,NULL,NULL,1,NULL,NULL),
(15,'Executive Director',NULL,25,NULL,NULL,1,NULL,NULL),
(16,'Chairmanr',NULL,26,NULL,NULL,1,NULL,NULL),
(17,'Managing Director',NULL,27,NULL,NULL,1,NULL,NULL),
(18,'Director',NULL,28,NULL,NULL,1,NULL,NULL),
(19,'Technician',NULL,29,NULL,NULL,1,NULL,NULL),
(20,'Security Officer',NULL,32,NULL,NULL,1,NULL,NULL),
(21,'Security Guard',NULL,33,NULL,NULL,1,NULL,NULL),
(22,'Security In Charge',NULL,34,NULL,NULL,1,NULL,NULL),
(23,'Marketing Officer',NULL,42,NULL,NULL,1,NULL,NULL);
/*!40000 ALTER TABLE `designations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `emp_leaves`
--

DROP TABLE IF EXISTS `emp_leaves`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `emp_leaves` (
  `emp_leaves_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `emp_id` int(11) DEFAULT NULL,
  `leave_date` date NOT NULL,
  `leave_for` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`emp_leaves_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `emp_leaves`
--

LOCK TABLES `emp_leaves` WRITE;
/*!40000 ALTER TABLE `emp_leaves` DISABLE KEYS */;
/*!40000 ALTER TABLE `emp_leaves` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoices`
--

DROP TABLE IF EXISTS `invoices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_no` varchar(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `price` double(10,2) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoices`
--

LOCK TABLES `invoices` WRITE;
/*!40000 ALTER TABLE `invoices` DISABLE KEYS */;
INSERT INTO `invoices` VALUES
(11,'0004',2,'Toilet Repairing',20.00,'2022-08-04 16:46:23',NULL),
(12,'0004',2,'Kitchen Repairing',100.00,'2022-08-04 16:46:23',NULL),
(13,'0005',7,'House Cleaning',20.00,'2022-08-04 17:04:42',NULL),
(14,'0006',9,'Sever connection',100.00,'2022-08-07 09:55:11',NULL),
(15,'0006',9,'Domain',30.00,'2022-08-07 09:55:11',NULL),
(16,'0006',9,'Hosting',20.00,'2022-08-07 09:55:11',NULL),
(17,'0007',12,'Sever connection',20.00,'2022-08-07 13:22:03',NULL),
(18,'0007',12,'New connection',10.00,'2022-08-07 13:22:03',NULL),
(19,'0008',13,'Plumber',20.00,'2022-08-08 10:52:19',NULL);
/*!40000 ALTER TABLE `invoices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES
(1,'2014_10_12_000000_create_users_table',1),
(2,'2014_10_12_100000_create_password_resets_table',1),
(3,'2018_09_16_095726_create_tasks_table',1),
(8,'2018_09_25_104807_create_solves_table',2);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notes`
--

DROP TABLE IF EXISTS `notes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `notes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `comment` longtext DEFAULT NULL,
  `order_by` int(11) NOT NULL,
  `department_id` int(11) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_by` int(10) unsigned NOT NULL,
  `updated_by` tinyint(4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notes_created_by_foreign` (`created_by`),
  CONSTRAINT `notes_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notes`
--

LOCK TABLES `notes` WRITE;
/*!40000 ALTER TABLE `notes` DISABLE KEYS */;
/*!40000 ALTER TABLE `notes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_resets` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
INSERT INTO `password_resets` VALUES
('mahfuz@weblinkltd.com','$2y$10$NlbOHIxbnDlcHmJ0Iwqs..wDXpWTBJxfHI5wKp3FUs7KZagmjZy5S','2019-03-25 20:49:21'),
('rakibul@weblinkltd.com','$2y$10$gmzuZBU1HoOxDxyOe1YyTOAh3rueY4hO.OsMSDi4dYUP16vlNvXY.','2019-04-28 15:55:26'),
('siddique@weblinkltd.com','$2y$10$OcQAyxOUkdD.GKYKy4rRiewTqXmU8gpI4yKzgIBTbcx9bXOXozkeK','2020-07-03 20:08:01'),
('admin@weblinkltd.com','$2y$10$6ycWp3nPofnoLl4mcne4UuYb9IovjpAPpyqs/j2o5UbhSvi4lHZ2K','2021-04-11 15:35:33');
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `solves`
--

DROP TABLE IF EXISTS `solves`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `solves` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `task_id` int(10) unsigned NOT NULL,
  `accepted_id` int(4) DEFAULT NULL,
  `accepted_at` timestamp NULL DEFAULT NULL,
  `solved_id` tinyint(4) DEFAULT NULL,
  `solved_at` timestamp NULL DEFAULT NULL,
  `combined_id` varchar(100) DEFAULT NULL,
  `failed_id` tinyint(4) DEFAULT NULL,
  `failed_at` timestamp NULL DEFAULT NULL,
  `accept_comment` longtext DEFAULT NULL,
  `comment` longtext DEFAULT NULL,
  `assign_by` int(11) DEFAULT NULL,
  `assigned_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(4) DEFAULT 0,
  `created_by` tinyint(4) NOT NULL,
  `updated_by` tinyint(4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `solves_task_id_foreign` (`task_id`),
  CONSTRAINT `solves_task_id_foreign` FOREIGN KEY (`task_id`) REFERENCES `tasks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `solves`
--

LOCK TABLES `solves` WRITE;
/*!40000 ALTER TABLE `solves` DISABLE KEYS */;
INSERT INTO `solves` VALUES
(1,1,0,NULL,4,'2022-07-25 04:58:34','3',NULL,NULL,'Do it in next 2days.','Given work is done.',3,'2022-07-25 03:54:37',2,3,4,'2022-07-25 03:53:49',NULL),
(2,2,4,NULL,NULL,NULL,NULL,NULL,NULL,'Task done in 4th August.',NULL,3,'2022-07-25 04:01:16',1,3,NULL,'2022-07-25 03:59:32',NULL),
(3,3,0,NULL,5,'2022-07-25 05:01:58','4',NULL,NULL,'Please give me related resource.','Related requirement mailed.',4,'2022-07-25 04:57:44',2,3,5,'2022-07-25 04:54:58',NULL),
(4,4,0,'2022-07-31 09:26:22',3,'2022-07-31 09:36:52','',NULL,NULL,NULL,'Done.',NULL,NULL,2,4,3,'2022-07-31 09:22:45',NULL),
(5,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7,NULL,'2022-08-04 09:43:04',NULL),
(7,7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7,NULL,'2022-08-04 10:22:51',NULL),
(8,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7,NULL,'2022-08-04 11:22:50',NULL),
(9,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7,NULL,'2022-08-07 03:53:43',NULL),
(11,11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7,NULL,'2022-08-07 04:08:59',NULL),
(12,12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7,NULL,'2022-08-07 07:20:59',NULL),
(13,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,7,NULL,'2022-08-08 04:49:15',NULL);
/*!40000 ALTER TABLE `solves` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tasks`
--

DROP TABLE IF EXISTS `tasks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tasks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ticket_id` bigint(20) NOT NULL,
  `department_id` int(10) NOT NULL DEFAULT 2,
  `task_title` text DEFAULT NULL,
  `task_description` longtext NOT NULL,
  `created_by` tinyint(4) DEFAULT NULL,
  `updated_by` tinyint(4) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `priority` enum('1','2','3','') NOT NULL DEFAULT '2',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tasks`
--

LOCK TABLES `tasks` WRITE;
/*!40000 ALTER TABLE `tasks` DISABLE KEYS */;
INSERT INTO `tasks` VALUES
(1,2507221,1,'Testing Data Updated.','Old data clear and new fresh data entry for QC purpose.',3,NULL,1,'1','2022-07-25 03:53:49',NULL),
(2,2507222,1,'New Software Requirment R&D','Functional and Non-functional requirement  listing.',3,NULL,1,'1','2022-07-25 03:59:32',NULL),
(3,2507223,1,'Database Create','Database create for education management system.',3,NULL,1,'1','2022-07-25 04:54:58',NULL),
(4,3107224,1,'Home visit','I need to go home visit.',4,NULL,1,'2','2022-07-31 09:22:45',NULL),
(5,408225,8,'Rakib first Ticket.','This is first ticket for testing.',7,NULL,1,'1','2022-08-04 09:43:04','2022-08-04 12:26:45'),
(7,408226,8,'Rakib Second Ticket.','This is 2nd testing command.',7,NULL,1,'1','2022-08-04 10:22:51','2022-08-04 12:26:10'),
(8,408228,8,'ggg','s',7,NULL,1,'1','2022-08-04 11:22:50',NULL),
(9,708229,8,'Sever configure.','Sever connection, domain and hosting service.',7,NULL,1,'1','2022-08-07 03:53:43',NULL),
(11,7082210,8,'Garden Nursing.','Cleaning, water channeling, tree plantation.',7,NULL,1,'1','2022-08-07 04:08:59',NULL),
(12,7082212,8,'mR','THIS IS NEW',7,NULL,1,'1','2022-08-07 07:20:59',NULL),
(13,8082213,8,'Plumber','Leak in the Bathroom',7,NULL,1,'1','2022-08-08 04:49:15',NULL);
/*!40000 ALTER TABLE `tasks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `bn_name` varchar(255) DEFAULT NULL,
  `display_name` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `department_id` int(11) DEFAULT NULL,
  `role` enum('1','2','3','4') DEFAULT '2' COMMENT 'super admin=1,admin=2,publisher=3,user=4',
  `joining_date` timestamp NULL DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_bn_name_unique` (`bn_name`),
  UNIQUE KEY `users_designation_unique` (`designation`),
  UNIQUE KEY `users_username_unique` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
(1,'Super Admin',NULL,'Super Admin','superadmin','admin@weblinkltd.xyz','019920','Team Leader','...',NULL,NULL,5,'1','2018-11-27 06:20:31',1,'$2y$10$Kk2u1x5OaCS0/cJ0zyGIIe4vB9n2T4qokydXhCbw2YnZflW60L8Lq','gy2IzyIynSlUVy6xGEB9gjZrWaO1iwyxByAmwM2fGfTgLDbWXod1OOiHeOTW',NULL,'2022-07-24 06:30:00'),
(2,'Super User',NULL,NULL,NULL,'superuser@weblinkltd.xyz','01992029','Tester','...',NULL,NULL,5,'1',NULL,1,'$2y$10$x4JKMydBbGzfr3.221dQZOJ9QTR4eEcDftXDs.J13Uj6NmaxIgFFO','XY8fLqDoq19YsY9XbMpdByWcboenOSRDrilj3ZQO1PMwVtqs18HCYl4OiniU','2022-07-24 06:28:48','2022-08-03 10:23:11'),
(3,'Admin','নাসির',NULL,NULL,'adminuser@weblinkltd.xyz','01711100111','Team Lead','Dhaka.',NULL,NULL,1,'2',NULL,1,'$2y$10$Wf3Uasxi08.nGxetST0hZ.tTNSObdyROnNz8yRX.M4o.1EZEJQFT.','MqsqNVIOpcigy6u3Kbb4Lqp6Dx8kAwpYCdE0RJXhnJQr06QDv6Gtk0rBVJ78','2022-07-24 06:48:48','2022-07-31 09:13:12'),
(4,'User','জাহির',NULL,NULL,'user@weblinkltd.xyz','01711100112','Senior Developer','Dhaka.',NULL,NULL,1,'4',NULL,1,'$2y$10$m5C/9t2btNl2GGfjl73age7eyOk/guAjxZc.luTfJV93A6VNPsUbK','JD0WUI22wn4tBiKkBysUMrqu4TmL2p0lyyO8kGoTgIS7ZHBc1G7SA8VYwOKN','2022-07-24 06:51:34','2022-07-24 07:17:22'),
(5,'Partho','পার্থ',NULL,NULL,'partho@weblinkltd.xyz','01711100113','Junior Developer','Dhaka',NULL,NULL,1,'4',NULL,1,'$2y$10$YRtJjnNCSCU1MDiXmhcfauqLFn1CcXZDn5ppI1VmpWJCsLixeYaw.','E3dWTo7wcPZrng1LI5i3NjJTjahtgVW92YHsGL55ryitDBx6rI2hMZqbMzgT','2022-07-24 06:54:01','2022-08-03 10:25:33'),
(6,'Sakib',NULL,NULL,NULL,'test@test.com','01710011001',NULL,'Dhaka.','1659605532.png',NULL,8,'4',NULL,1,'$2y$10$71kgyPa85QR1ssF6ogplv.KbY5EXyj8eDbGkXM3mb2G9AT9CHI6vu',NULL,'2022-08-04 09:32:12','2022-08-04 09:38:13'),
(7,'Rakib',NULL,NULL,NULL,'demo@test.com','01710011002',NULL,NULL,'1659605617.png',NULL,8,'4',NULL,1,'$2y$10$pbxXw.MzSH62mU1WYnfumOGzPjzXIcqHblFao5U13YHECP8uHAaWK','0hmqKL03aMQs5o4NkXdJHOVELKA9b4ziHpMkRCqWX6oIRegqYUDXZCKq9vor','2022-08-04 09:33:37','2022-08-04 09:38:39'),
(8,'Labib',NULL,NULL,NULL,'demo@demo.com','01710011003',NULL,NULL,NULL,NULL,8,'4',NULL,1,'$2y$10$tHH9.eaL407.tPcrBXsbR.HgjwQ26YWwKErJcGn7i2Hlw0WunjmXW','pEM97PHC9KPrpNXDMRVzzF9QprZSwZvFeoHrb3XHWgzqysuk3313BXmiOit5','2022-08-04 09:37:25','2022-08-04 09:37:25'),
(9,'simon',NULL,'simon',NULL,'simoncrans@gmail.com','09125432121',NULL,NULL,NULL,NULL,1,'4',NULL,1,'$2y$10$VuTtRiAtlsggpFlBR4OnmO73r7wb8rZx2CnXrC3us4zLhWbVVRfuW',NULL,'2022-11-03 10:53:06','2022-11-03 10:53:06');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-05-05 15:39:45
