# ************************************************************
# Sequel Pro SQL dump
# Version 5446
#
# https://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.7.29)
# Database: pm
# Generation Time: 2022-09-02 09:20:06 +0000
# ************************************************************


/*!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 utf8 */;
SET NAMES utf8mb4;
/*!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 */;


# Dump of table clients
# ------------------------------------------------------------

DROP TABLE IF EXISTS `clients`;

CREATE TABLE `clients` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `client_name` varchar(255) DEFAULT NULL,
  `contract_no` varchar(255) DEFAULT NULL,
  `client_email` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `clients` WRITE;
/*!40000 ALTER TABLE `clients` DISABLE KEYS */;

INSERT INTO `clients` (`id`, `client_name`, `contract_no`, `client_email`, `status`, `created_at`, `updated_at`)
VALUES
	(1,'Imanila','093847383s','kencheetorredes@gmail.com',0,'2022-08-23 23:07:18','2022-08-23 23:11:00');

/*!40000 ALTER TABLE `clients` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table project_members
# ------------------------------------------------------------

DROP TABLE IF EXISTS `project_members`;

CREATE TABLE `project_members` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(255) DEFAULT NULL,
  `project_id` int(255) DEFAULT NULL,
  `role_id` int(11) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `project_members` WRITE;
/*!40000 ALTER TABLE `project_members` DISABLE KEYS */;

INSERT INTO `project_members` (`id`, `user_id`, `project_id`, `role_id`, `created_at`, `updated_at`)
VALUES
	(3,1,2,0,'2022-08-25 00:11:24','2022-08-25 00:11:24'),
	(4,2,2,1,'2022-08-25 00:11:24','2022-08-25 00:11:24'),
	(9,1,1,0,'2022-08-25 02:03:50','2022-08-25 02:03:50'),
	(10,2,1,1,'2022-08-25 02:03:56','2022-08-25 02:03:56'),
	(11,5,1,3,'2022-08-25 02:04:03','2022-08-25 02:04:03'),
	(12,1,2,3,'2022-08-25 02:04:16','2022-08-25 02:04:16'),
	(13,1,3,0,'2022-08-25 09:41:49','2022-08-25 09:41:49'),
	(14,2,3,1,'2022-08-25 09:41:55','2022-08-25 09:41:55'),
	(15,3,3,2,'2022-08-25 09:42:09','2022-08-25 09:42:09');

/*!40000 ALTER TABLE `project_members` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table project_types
# ------------------------------------------------------------

DROP TABLE IF EXISTS `project_types`;

CREATE TABLE `project_types` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `project_type_name` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `project_types` WRITE;
/*!40000 ALTER TABLE `project_types` DISABLE KEYS */;

INSERT INTO `project_types` (`id`, `project_type_name`, `created_at`, `updated_at`)
VALUES
	(1,'Web Development','2022-08-25 08:30:55','2022-08-25 08:33:50'),
	(2,'Website Development','2022-08-25 08:33:30','2022-08-25 08:34:02');

/*!40000 ALTER TABLE `project_types` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table projects
# ------------------------------------------------------------

DROP TABLE IF EXISTS `projects`;

CREATE TABLE `projects` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `project_name` varchar(255) DEFAULT NULL,
  `project_type_id` int(255) DEFAULT NULL,
  `client_id` int(255) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `deadline` datetime DEFAULT NULL,
  `descriptions` longtext,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `projects` WRITE;
/*!40000 ALTER TABLE `projects` DISABLE KEYS */;

INSERT INTO `projects` (`id`, `project_name`, `project_type_id`, `client_id`, `start_date`, `deadline`, `descriptions`, `created_at`, `updated_at`, `status`)
VALUES
	(1,'project 14',1,1,'2022-08-26 00:00:00','2022-09-30 00:00:00','aaaa','2022-08-25 00:10:08','2022-08-25 08:39:36',0),
	(2,'project 2',2,1,'2022-08-26 00:00:00','2022-08-26 00:00:00','ddess','2022-08-25 00:11:24','2022-08-25 00:11:24',0),
	(3,'NFT',1,1,'2022-08-27 00:00:00','2022-08-31 00:00:00','n publishing and graphic design, Lorem ipsum is a placeholder text commonly used to demonstrate the visual form of a document or a typeface without relying on meaningful content. Lorem ipsum may be used as a placeholder before final copy is available.','2022-08-25 08:42:00','2022-08-25 08:42:00',0);

/*!40000 ALTER TABLE `projects` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table settings
# ------------------------------------------------------------

DROP TABLE IF EXISTS `settings`;

CREATE TABLE `settings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) DEFAULT NULL,
  `company_address` text,
  `logo` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `is_dark` int(11) DEFAULT '1',
  `layout_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;

INSERT INTO `settings` (`id`, `company_name`, `company_address`, `logo`, `created_at`, `updated_at`, `is_dark`, `layout_type`)
VALUES
	(1,'Imanila','dfdfdf','imanilalogo-1-08242201464063058300d3c6b.png',NULL,'2022-09-02 00:09:47',1,'modern-sidebar');

/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table task_attachments
# ------------------------------------------------------------

DROP TABLE IF EXISTS `task_attachments`;

CREATE TABLE `task_attachments` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `task_id` int(255) DEFAULT NULL,
  `url` longtext,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `uploaded_by` int(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `task_attachments` WRITE;
/*!40000 ALTER TABLE `task_attachments` DISABLE KEYS */;

INSERT INTO `task_attachments` (`id`, `task_id`, `url`, `created_at`, `updated_at`, `uploaded_by`, `type`, `status`)
VALUES
	(1,1,'box-082822021831630ad07788a42.gif','2022-08-28 02:18:31','2022-08-28 02:18:31',1,'gif',0),
	(2,1,'mov_bbb-082822021852630ad08ca0e1e.mp4','2022-08-28 02:18:52','2022-08-28 02:18:52',1,'mp4',0),
	(3,1,'English-cases(2)-082822021901630ad095d7e52.csv','2022-08-28 02:19:01','2022-08-28 02:19:01',1,'csv',NULL),
	(4,2,'bg-01-082822021642630ad00a9eb63-082822022229630ad16594b77.jpg','2022-08-28 02:22:29','2022-08-28 02:22:29',1,NULL,NULL),
	(5,4,'bg-01-082822021642630ad00a9eb63-082822022229630ad16594b77-082822022847630ad2dfb7ef3.jpg','2022-08-28 02:28:47','2022-08-28 02:28:47',1,'jpg',NULL),
	(6,4,'a3c2a63d2fcf0e061a5066f5f2280adb--notebook-doodles-accent-pieces-082822022847630ad2dfb9b96.jpeg','2022-08-28 02:28:47','2022-08-28 02:28:47',1,'jpeg',NULL),
	(7,1,'a3c2a63d2fcf0e061a5066f5f2280adb--notebook-doodles-accent-pieces-082922115142630ca84ed2721.jpeg','2022-08-29 11:51:42','2022-08-29 11:51:42',1,'jpeg',0),
	(8,1,'logo-083022125759630d60978f8b5.png','2022-08-30 00:57:59','2022-08-30 00:57:59',1,'png',0),
	(9,1,'a3c2a63d2fcf0e061a5066f5f2280adb--notebook-doodles-accent-pieces-083022010158630d61867a6fe.jpeg','2022-08-30 01:01:58','2022-08-30 01:01:58',1,'jpeg',1),
	(10,1,'a3c2a63d2fcf0e061a5066f5f2280adb--notebook-doodles-accent-pieces-083022012156630d663400ffd.jpeg','2022-08-30 01:21:56','2022-08-30 01:21:56',1,'jpeg',2),
	(11,2,'a3c2a63d2fcf0e061a5066f5f2280adb--notebook-doodles-accent-pieces-090222125311631153f795a81.jpeg','2022-09-02 00:53:11','2022-09-02 00:53:11',1,'jpeg',2),
	(12,4,'FORIMANILA-Table1-09022201223963115adf4d79d.csv','2022-09-02 01:22:39','2022-09-02 01:22:39',1,'csv',2),
	(13,2,'FORIMANILA-Table1-090222051726631191e6ea8a7.csv','2022-09-02 05:17:26','2022-09-02 05:17:26',1,'csv',0),
	(14,2,'All-screamingfrog1beforead-Table1-0902220810466311ba8684199.csv','2022-09-02 08:10:46','2022-09-02 08:10:46',1,'csv',2);

/*!40000 ALTER TABLE `task_attachments` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table task_logs
# ------------------------------------------------------------

DROP TABLE IF EXISTS `task_logs`;

CREATE TABLE `task_logs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `task_id` int(255) DEFAULT NULL,
  `created_by` int(255) DEFAULT NULL,
  `action` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `task_logs` WRITE;
/*!40000 ALTER TABLE `task_logs` DISABLE KEYS */;

INSERT INTO `task_logs` (`id`, `task_id`, `created_by`, `action`, `created_at`, `updated_at`, `status`)
VALUES
	(1,1,1,'Created','2022-08-27 11:47:49','2022-08-27 11:47:49',0),
	(2,1,1,'Update task details','2022-08-27 11:48:28','2022-08-27 11:48:28',0),
	(3,2,1,'Create this task','2022-08-28 02:22:29','2022-08-28 02:22:29',0),
	(4,3,1,'Create this task','2022-08-28 02:28:26','2022-08-28 02:28:26',0),
	(5,4,1,'Create this task','2022-08-28 02:28:47','2022-08-28 02:28:47',0),
	(6,1,1,'Start task','2022-08-29 00:11:37','2022-08-29 00:11:37',1),
	(7,2,1,'Start task','2022-08-30 12:35:01','2022-08-30 12:35:01',1),
	(8,4,1,'Start task','2022-09-02 01:22:06','2022-09-02 01:22:06',1),
	(9,2,1,'Start Revision','2022-09-02 06:02:22','2022-09-02 06:02:22',5),
	(10,2,1,'Start Revision','2022-09-02 06:09:22','2022-09-02 06:09:22',5),
	(11,2,1,'Start Revision','2022-09-02 08:09:08','2022-09-02 08:09:08',5),
	(12,2,1,'Start Revision','2022-09-02 08:15:46','2022-09-02 08:15:46',5),
	(13,2,1,'Start Revision','2022-09-02 08:18:06','2022-09-02 08:18:06',5),
	(14,2,1,'Start Revision','2022-09-02 08:25:26','2022-09-02 08:25:26',5),
	(15,2,1,'Start Revision','2022-09-02 08:57:25','2022-09-02 08:57:25',7);

/*!40000 ALTER TABLE `task_logs` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table task_notes
# ------------------------------------------------------------

DROP TABLE IF EXISTS `task_notes`;

CREATE TABLE `task_notes` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(255) DEFAULT NULL,
  `note` longtext,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `task_id` int(255) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `task_notes` WRITE;
/*!40000 ALTER TABLE `task_notes` DISABLE KEYS */;

INSERT INTO `task_notes` (`id`, `user_id`, `note`, `created_at`, `updated_at`, `task_id`, `status`)
VALUES
	(1,1,'samople task on this one','2022-08-28 00:28:00','2022-08-28 00:28:00',1,NULL),
	(2,1,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.','2022-08-28 00:30:54','2022-08-28 00:30:54',1,NULL),
	(3,1,NULL,'2022-08-29 10:37:50','2022-08-29 10:37:50',1,NULL),
	(4,1,NULL,'2022-08-29 10:44:52','2022-08-29 10:44:52',1,NULL),
	(5,1,'eeee','2022-08-29 11:44:16','2022-08-29 11:44:16',1,0),
	(6,1,'dsdsddsdsd','2022-08-29 11:46:34','2022-08-29 11:46:34',1,1),
	(7,1,'sample','2022-08-30 01:21:56','2022-08-30 01:21:56',1,2);

/*!40000 ALTER TABLE `task_notes` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table task_outputs
# ------------------------------------------------------------

DROP TABLE IF EXISTS `task_outputs`;

CREATE TABLE `task_outputs` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `note` longtext,
  `file_id` int(255) DEFAULT NULL,
  `task_id` int(255) DEFAULT NULL,
  `user_id` int(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `is_final` int(11) DEFAULT '1' COMMENT '0 yes 1 no',
  `out_put_no` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '0' COMMENT '0 - waiting for other to approve,1- on going,2 complete',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `task_outputs` WRITE;
/*!40000 ALTER TABLE `task_outputs` DISABLE KEYS */;

INSERT INTO `task_outputs` (`id`, `note`, `file_id`, `task_id`, `user_id`, `created_at`, `updated_at`, `is_final`, `out_put_no`, `status`)
VALUES
	(2,'sdsdsd sdsdsdsd',11,2,1,'2022-09-02 00:53:11','2022-09-02 09:02:28',1,1,2),
	(3,'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.',12,4,1,'2022-09-02 01:22:39','2022-09-02 01:22:39',1,1,0),
	(4,'sdsdsdsdsdsd',0,2,1,'2022-09-02 07:52:43','2022-09-02 09:02:28',1,2,2),
	(5,'sample',14,2,1,'2022-09-02 08:10:46','2022-09-02 09:02:28',1,3,2),
	(6,'wewe wewewe',0,2,1,'2022-09-02 08:16:58','2022-09-02 09:02:28',1,4,2),
	(7,'querty',0,2,1,'2022-09-02 08:27:19','2022-09-02 09:02:28',1,5,2),
	(8,'sdsd sd sdsdsd',0,2,1,'2022-09-02 09:02:28','2022-09-02 09:08:44',0,6,2);

/*!40000 ALTER TABLE `task_outputs` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table task_revision_checklists
# ------------------------------------------------------------

DROP TABLE IF EXISTS `task_revision_checklists`;

CREATE TABLE `task_revision_checklists` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `revision` longtext,
  `file_id` int(255) DEFAULT NULL,
  `status` int(255) DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `user_id` int(255) DEFAULT NULL,
  `revision_id` int(255) DEFAULT NULL,
  `task_id` int(255) DEFAULT NULL,
  `output_id` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `task_revision_checklists` WRITE;
/*!40000 ALTER TABLE `task_revision_checklists` DISABLE KEYS */;

INSERT INTO `task_revision_checklists` (`id`, `revision`, `file_id`, `status`, `created_at`, `updated_at`, `user_id`, `revision_id`, `task_id`, `output_id`)
VALUES
	(1,'revision 1',NULL,0,'2022-09-02 05:17:26','2022-09-02 08:10:27',1,4,2,2),
	(2,'revision 2',NULL,0,'2022-09-02 05:17:26','2022-09-02 08:10:28',1,4,2,2),
	(3,'revision 3',13,0,'2022-09-02 05:17:26','2022-09-02 08:10:28',1,4,2,2),
	(4,'wewe',NULL,0,'2022-09-02 07:59:13','2022-09-02 08:10:22',1,5,2,4),
	(5,'revision 1',NULL,0,'2022-09-02 08:13:42','2022-09-02 08:16:51',1,10,2,5),
	(6,'wewe',NULL,0,'2022-09-02 08:13:42','2022-09-02 08:16:52',1,10,2,5),
	(7,'sdsd',NULL,0,'2022-09-02 08:17:15','2022-09-02 08:25:41',1,11,2,6),
	(8,'wewewe',NULL,0,'2022-09-02 08:17:15','2022-09-02 08:26:39',1,11,2,6),
	(9,'232323',NULL,0,'2022-09-02 08:17:40','2022-09-02 08:26:40',1,12,2,6),
	(10,'fgfgfg',NULL,0,'2022-09-02 08:17:40','2022-09-02 08:27:09',1,12,2,6),
	(11,'revision 1',NULL,0,'2022-09-02 08:54:11','2022-09-02 09:02:21',1,19,2,7),
	(12,'wewewewe',NULL,0,'2022-09-02 08:54:11','2022-09-02 09:02:22',1,19,2,7);

/*!40000 ALTER TABLE `task_revision_checklists` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table task_revisions
# ------------------------------------------------------------

DROP TABLE IF EXISTS `task_revisions`;

CREATE TABLE `task_revisions` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `task_id` int(255) DEFAULT NULL,
  `user_id` int(255) DEFAULT NULL,
  `status` int(11) DEFAULT '1' COMMENT '0 - approved 2 for revision',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `type` int(11) DEFAULT '0' COMMENT '0- initial , 1 - final',
  `output_id` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `task_revisions` WRITE;
/*!40000 ALTER TABLE `task_revisions` DISABLE KEYS */;

INSERT INTO `task_revisions` (`id`, `task_id`, `user_id`, `status`, `created_at`, `updated_at`, `type`, `output_id`)
VALUES
	(1,2,2,0,'2022-09-02 04:18:15','2022-09-02 04:18:15',0,2),
	(2,2,3,0,'2022-09-02 04:28:15','2022-09-02 04:28:15',0,2),
	(4,2,1,1,'2022-09-02 05:17:26','2022-09-02 05:17:26',0,2),
	(5,2,2,1,'2022-09-02 07:59:13','2022-09-02 07:59:13',0,4),
	(6,2,3,0,'2022-09-02 07:59:41','2022-09-02 07:59:41',0,4),
	(7,2,1,0,'2022-09-02 07:59:58','2022-09-02 07:59:58',0,4),
	(8,2,2,0,'2022-09-02 08:11:59','2022-09-02 08:11:59',0,5),
	(9,2,3,0,'2022-09-02 08:12:53','2022-09-02 08:12:53',0,5),
	(10,2,1,1,'2022-09-02 08:13:42','2022-09-02 08:13:42',0,5),
	(11,2,2,1,'2022-09-02 08:17:15','2022-09-02 08:17:15',0,6),
	(12,2,3,1,'2022-09-02 08:17:40','2022-09-02 08:17:40',0,6),
	(13,2,2,0,'2022-09-02 08:17:57','2022-09-02 08:17:57',0,6),
	(14,2,3,0,'2022-09-02 08:24:01','2022-09-02 08:24:01',0,6),
	(15,2,2,0,'2022-09-02 08:29:38','2022-09-02 08:29:38',0,7),
	(16,2,3,0,'2022-09-02 08:29:56','2022-09-02 08:29:56',0,7),
	(18,2,4,0,'2022-09-02 08:34:09','2022-09-02 08:34:09',0,7),
	(19,2,1,1,'2022-09-02 08:54:11','2022-09-02 08:54:11',1,7),
	(21,2,1,0,'2022-09-02 09:07:29','2022-09-02 09:07:29',1,8),
	(22,2,1,0,'2022-09-02 09:08:18','2022-09-02 09:08:18',1,8),
	(23,2,1,0,'2022-09-02 09:08:44','2022-09-02 09:08:44',1,8);

/*!40000 ALTER TABLE `task_revisions` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table task_subtasks
# ------------------------------------------------------------

DROP TABLE IF EXISTS `task_subtasks`;

CREATE TABLE `task_subtasks` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `subtask` varchar(255) DEFAULT NULL,
  `priority_id` int(20) DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `task_id` int(255) DEFAULT NULL,
  `user_id` int(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `task_subtasks` WRITE;
/*!40000 ALTER TABLE `task_subtasks` DISABLE KEYS */;

INSERT INTO `task_subtasks` (`id`, `subtask`, `priority_id`, `status`, `task_id`, `user_id`, `created_at`, `updated_at`)
VALUES
	(1,'wewewewe',0,0,1,1,'2022-08-29 10:55:38','2022-08-29 11:42:00'),
	(2,'wewe232323',1,0,1,1,'2022-08-29 10:55:38','2022-08-29 11:41:17'),
	(5,'jjjj',0,0,1,1,'2022-08-29 11:42:30','2022-08-29 11:42:30'),
	(6,'ll',1,0,1,1,'2022-08-29 11:43:15','2022-08-30 01:16:51'),
	(7,'jjjj',0,0,2,1,'2022-08-30 13:45:42','2022-08-30 13:47:01');

/*!40000 ALTER TABLE `task_subtasks` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table tasks
# ------------------------------------------------------------

DROP TABLE IF EXISTS `tasks`;

CREATE TABLE `tasks` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `task_name` varchar(255) DEFAULT NULL,
  `deadline` datetime DEFAULT NULL,
  `project_id` int(255) DEFAULT NULL,
  `user_id` int(255) DEFAULT NULL,
  `descriptions` longtext,
  `priority_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_by` int(255) DEFAULT NULL,
  `updated_by` int(255) DEFAULT NULL,
  `client_id` int(255) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `actual_start_date` datetime DEFAULT NULL,
  `actual_end_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `tasks` WRITE;
/*!40000 ALTER TABLE `tasks` DISABLE KEYS */;

INSERT INTO `tasks` (`id`, `task_name`, `deadline`, `project_id`, `user_id`, `descriptions`, `priority_id`, `status`, `created_at`, `updated_at`, `created_by`, `updated_by`, `client_id`, `start_date`, `actual_start_date`, `actual_end_date`)
VALUES
	(1,'task 1','2022-09-03 00:00:00',1,1,'wewewe',1,2,'2022-08-27 11:45:47','2022-08-30 01:21:56',1,1,1,NULL,'2022-08-29 00:11:37',NULL),
	(2,'task 2','2022-08-27 00:00:00',2,1,'sdsd sdsdsd',2,8,'2022-08-28 02:22:29','2022-09-02 09:08:44',1,NULL,1,NULL,'2022-08-30 12:35:01',NULL),
	(4,'task 3','2022-08-31 00:00:00',1,2,'sdsdsd',0,2,'2022-08-28 02:28:47','2022-09-02 01:22:39',1,NULL,1,'2022-08-28 00:00:00','2022-09-02 01:22:06',NULL);

/*!40000 ALTER TABLE `tasks` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table users
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int(255) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `surname` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` text,
  `type` int(11) DEFAULT '0',
  `status` int(11) DEFAULT '0',
  `reset_expired` datetime DEFAULT NULL,
  `reset_password` longtext,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `code` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;

INSERT INTO `users` (`id`, `name`, `surname`, `email`, `password`, `type`, `status`, `reset_expired`, `reset_password`, `created_at`, `updated_at`, `code`)
VALUES
	(1,'samurai','torredes','kencheetorredes@gmail.com','$2y$10$yA49tOlokWF/.piZh3HZ6OzK6PqGpRprVzClw5CiJ4Eov.4IX.5/2',0,0,NULL,NULL,'2022-08-24 01:24:31','2022-08-24 22:26:01','63057dcb19d291661304267'),
	(2,'Admin','afdmin','admin@test.com','$2y$10$yfgTHh78z0f6X9Eq79hS8.upF4GeXi71LyJ8mgN9hhXsH3OxSe3o6',0,0,NULL,NULL,'2022-08-24 22:26:23','2022-08-24 22:26:23','6306a58bb41801661379979'),
	(3,'Intial Approver 1','test','initial1@test.com','$2y$10$YUytQ4Bm3twSmXN5QtR0lO0zqzm3A7cRoOT01rismnUewR1NIa/t2',0,0,NULL,NULL,'2022-08-24 22:26:58','2022-08-24 22:26:58','6306a5ae7c82d1661380014'),
	(4,'Intial Approver 2','test','initial2@test.com','$2y$10$xq35EJbOXnWoHJLfJQbSyOkw8uq7SUgrx/iDNWKbHa8ZIMcCitmzO',0,0,NULL,NULL,'2022-08-24 22:27:23','2022-08-24 22:27:23','6306a5c78f2f71661380039'),
	(5,'final approver','test','final@test.com','$2y$10$IfRVfmZR0LhRrzZr0oJ9peiwTgfnfxeR1RZLmOIV/Gz0aR8vh8Ldq',0,0,NULL,NULL,'2022-08-24 22:27:48','2022-08-24 22:27:48','6306a5dfe2bb51661380063');

/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;



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