# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.7.39)
# Database: pm
# Generation Time: 2022-09-25 00:37:34 +0000
# ************************************************************




# Dump of table 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;


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');



# Dump of table 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;


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'),
	(16,4,3,3,'2022-09-10 13:20:56','2022-09-10 13:20:56'),
	(17,4,1,2,'2022-09-12 09:48:45','2022-09-12 09:48:45');



# Dump of table 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,
  `color` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `project_types` (`id`, `project_type_name`, `created_at`, `updated_at`, `color`)
VALUES
	(1,'Web Development','2022-08-25 08:30:55','2022-09-10 03:14:41','#b0f0a8'),
	(2,'Website Development','2022-08-25 08:33:30','2022-09-10 03:14:32','#60b6d2');



# Dump of table 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;


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-09-24 17:31:37',1),
	(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-09-10 13:25:57',1);



# Dump of table 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,
  `login_image` text,
  `compay_email` varchar(255) DEFAULT NULL,
  `is_initial_email` int(11) DEFAULT NULL,
  `is_final_email` int(11) DEFAULT NULL,
  `is_new_email` int(11) DEFAULT NULL,
  `is_task_all_task_complete` int(11) DEFAULT NULL,
  `enable_initial_approver` int(11) DEFAULT '1',
  `dark_logo` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO `settings` (`id`, `company_name`, `company_address`, `logo`, `created_at`, `updated_at`, `is_dark`, `layout_type`, `login_image`, `compay_email`, `is_initial_email`, `is_final_email`, `is_new_email`, `is_task_all_task_complete`, `enable_initial_approver`, `dark_logo`)
VALUES
	(1,'Imanila','dfdfdf','imanilalogo-1-08242201464063058300d3c6b.png',NULL,'2022-09-25 08:16:31',1,'defaul-layout','images-090922113015631bcc877dfe3.jpeg','ssample@gmail.com',0,0,0,0,1,'Dunlop_Logo-092522072950632f92ee02f9b.jpg');



# Dump of table 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;


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),
	(15,9,'images-091022011039631c8ccfb4353.jpeg','2022-09-10 13:10:39','2022-09-10 13:10:39',1,'jpeg',2),
	(16,9,'images-091022011103631c8ce7428bc.jpeg','2022-09-10 13:11:03','2022-09-10 13:11:03',1,'jpeg',2),
	(17,9,'images-091022011125631c8cfd910a3.jpeg','2022-09-10 13:11:25','2022-09-10 13:11:25',1,'jpeg',2),
	(18,10,'images-091022012604631c906c22472.jpeg','2022-09-10 13:26:04','2022-09-10 13:26:04',1,'jpeg',2),
	(19,11,'302456447_472975397813278_2298418059730098798_n-091222094936631f00b0e7711.jpg','2022-09-12 09:49:36','2022-09-12 09:49:36',5,'jpg',0),
	(20,11,'302456447_472975397813278_2298418059730098798_n-091222094936631f00b0e7711-091222095240631f016866674.jpg','2022-09-12 09:52:40','2022-09-12 09:52:40',1,'jpg',2);



# Dump of table 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;


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),
	(16,5,5,'Create this task','2022-09-10 11:21:48','2022-09-10 11:21:48',0),
	(17,6,5,'Create this task','2022-09-10 11:22:28','2022-09-10 11:22:28',0),
	(18,7,5,'Create this task','2022-09-10 11:22:51','2022-09-10 11:22:51',0),
	(19,8,5,'Create this task','2022-09-10 11:23:42','2022-09-10 11:23:42',0),
	(20,9,5,'Create this task','2022-09-10 12:51:06','2022-09-10 12:51:06',0),
	(21,9,1,'Start task','2022-09-10 12:57:31','2022-09-10 12:57:31',1),
	(22,10,5,'Create this task','2022-09-10 13:25:16','2022-09-10 13:25:16',0),
	(23,10,1,'Start task','2022-09-10 13:25:57','2022-09-10 13:25:57',1),
	(24,11,5,'Create this task','2022-09-12 09:49:36','2022-09-12 09:49:36',0),
	(25,11,1,'Start task','2022-09-12 09:52:08','2022-09-12 09:52:08',1),
	(26,12,1,'Create this task','2022-09-23 23:56:31','2022-09-23 23:56:31',0),
	(27,12,1,'Start task','2022-09-24 00:20:42','2022-09-24 00:20:42',1),
	(28,12,1,'Start task','2022-09-24 02:58:40','2022-09-24 02:58:40',1),
	(29,12,1,'Start Revision','2022-09-24 11:23:38','2022-09-24 11:23:38',5),
	(30,12,1,'Start Revision','2022-09-24 11:36:43','2022-09-24 11:36:43',7),
	(31,13,1,'Create this task','2022-09-24 11:49:40','2022-09-24 11:49:40',0),
	(32,13,1,'Start task','2022-09-24 11:51:20','2022-09-24 11:51:20',1),
	(33,14,1,'Create this task','2022-09-24 12:01:01','2022-09-24 12:01:01',0),
	(34,14,1,'Start task','2022-09-24 12:01:10','2022-09-24 12:01:10',1),
	(35,14,1,'Start Revision','2022-09-24 12:18:37','2022-09-24 12:18:37',5),
	(36,14,1,'Start Revision','2022-09-24 12:29:37','2022-09-24 12:29:37',5),
	(37,14,1,'Start Revision','2022-09-24 12:35:21','2022-09-24 12:35:21',5),
	(38,15,1,'Create this task','2022-09-24 17:23:57','2022-09-24 17:23:57',0),
	(39,15,1,'Start task','2022-09-24 17:31:37','2022-09-24 17:31:37',1),
	(40,15,1,'Start Revision','2022-09-24 17:48:05','2022-09-24 17:48:05',7),
	(41,15,1,'Start Revision','2022-09-24 17:53:00','2022-09-24 17:53:00',7),
	(42,15,1,'Start Revision','2022-09-24 17:56:45','2022-09-24 17:56:45',7);



# Dump of table 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;


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);



# Dump of table 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;


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),
	(11,'sdsdsd',17,9,1,'2022-09-10 13:11:25','2022-09-10 13:35:44',0,3,2),
	(12,'sdsdsd',18,10,1,'2022-09-10 13:26:04','2022-09-10 13:35:26',0,1,2),
	(13,'this is my initila output',20,11,1,'2022-09-12 09:52:40','2022-09-24 12:55:35',0,1,2),
	(14,'sdsdsdsdsd',0,12,1,'2022-09-24 11:18:40','2022-09-24 11:40:22',1,1,2),
	(15,'sdsdsdsdsdsd',0,12,1,'2022-09-24 11:30:26','2022-09-24 11:40:22',1,2,2),
	(16,'hello word',0,12,1,'2022-09-24 11:37:23','2022-09-24 11:40:22',1,3,2),
	(17,'sds sdsdsd',0,12,1,'2022-09-24 11:40:22','2022-09-24 12:55:24',0,4,2),
	(18,'for initial approval',0,13,1,'2022-09-24 11:53:42','2022-09-24 11:56:11',0,1,2),
	(19,'fot initial approver',0,14,1,'2022-09-24 12:06:54','2022-09-24 12:21:07',1,1,2),
	(20,'ssss',0,14,1,'2022-09-24 12:21:07','2022-09-24 12:22:44',1,2,1),
	(21,'sdfsdfsfsdf',0,14,1,'2022-09-24 12:34:11','2022-09-24 12:34:53',1,3,1),
	(22,'ggggggg',0,14,1,'2022-09-24 12:39:15','2022-09-24 12:40:58',0,4,2),
	(23,'sdsdsd sdsd sd sdsd',0,15,1,'2022-09-24 17:38:14','2022-09-24 17:48:45',1,1,2),
	(24,'sdsd sdsdsdsdsd',0,15,1,'2022-09-24 17:48:45','2022-09-24 17:51:33',1,2,1),
	(25,'sdsdsdsd',0,15,1,'2022-09-24 17:54:21','2022-09-24 17:56:25',1,3,1),
	(26,'sdsdsdsd',0,15,1,'2022-09-24 17:58:27','2022-09-24 17:58:55',0,4,2);



# Dump of table 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;


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),
	(13,'ddfdfdfdf',NULL,0,'2022-09-24 11:21:43','2022-09-24 11:30:16',4,29,12,14),
	(14,'sdsd sdsd sdsd sdsd sdsd',NULL,0,'2022-09-24 11:34:50','2022-09-24 11:37:07',5,31,12,15),
	(15,'red',NULL,0,'2022-09-24 12:14:01','2022-09-24 12:21:01',4,36,14,19),
	(16,'eee',NULL,0,'2022-09-24 12:22:44','2022-09-24 12:29:51',4,37,14,20),
	(17,'sdsd sdsdsd',NULL,0,'2022-09-24 12:34:53','2022-09-24 12:39:08',4,38,14,21),
	(18,'ew333',NULL,0,'2022-09-24 17:46:38','2022-09-24 17:48:37',5,43,15,23),
	(19,'dsfgerwwerwer',NULL,0,'2022-09-24 17:51:33','2022-09-24 17:53:12',5,44,15,24),
	(20,'wewewewewe',NULL,0,'2022-09-24 17:56:25','2022-09-24 17:58:22',5,45,15,25);



# Dump of table 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;


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),
	(24,9,3,0,'2022-09-10 13:18:04','2022-09-10 13:18:04',0,11),
	(25,10,3,0,'2022-09-10 13:26:42','2022-09-10 13:26:42',0,12),
	(26,10,4,0,'2022-09-10 13:35:26','2022-09-10 13:35:26',1,12),
	(27,9,4,0,'2022-09-10 13:35:44','2022-09-10 13:35:44',1,11),
	(28,11,4,0,'2022-09-12 09:54:22','2022-09-12 09:54:22',0,13),
	(29,12,4,1,'2022-09-24 11:21:43','2022-09-24 11:21:43',0,14),
	(30,12,4,0,'2022-09-24 11:33:51','2022-09-24 11:33:51',0,15),
	(31,12,5,1,'2022-09-24 11:34:50','2022-09-24 11:34:50',1,15),
	(32,12,4,0,'2022-09-24 11:48:22','2022-09-24 11:48:22',1,17),
	(34,13,4,0,'2022-09-24 11:55:32','2022-09-24 11:55:32',1,18),
	(35,13,5,0,'2022-09-24 11:56:11','2022-09-24 11:56:11',1,18),
	(36,14,4,1,'2022-09-24 12:14:01','2022-09-24 12:14:01',0,19),
	(37,14,4,1,'2022-09-24 12:22:44','2022-09-24 12:22:44',0,20),
	(38,14,4,1,'2022-09-24 12:34:53','2022-09-24 12:34:53',0,21),
	(39,14,4,0,'2022-09-24 12:39:53','2022-09-24 12:39:53',0,22),
	(40,14,5,0,'2022-09-24 12:40:58','2022-09-24 12:40:58',1,22),
	(41,12,5,0,'2022-09-24 12:55:24','2022-09-24 12:55:24',1,17),
	(42,11,5,0,'2022-09-24 12:55:35','2022-09-24 12:55:35',1,13),
	(43,15,5,1,'2022-09-24 17:46:38','2022-09-24 17:46:38',1,23),
	(44,15,5,1,'2022-09-24 17:51:33','2022-09-24 17:51:33',1,24),
	(45,15,5,1,'2022-09-24 17:56:25','2022-09-24 17:56:25',1,25),
	(46,15,5,0,'2022-09-24 17:58:55','2022-09-24 17:58:55',1,26);



# Dump of table 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;


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');



# Dump of table 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,
  `time_log` decimal(10,2) DEFAULT '0.00',
  `time_pause` int(11) DEFAULT NULL,
  `time_start` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


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`, `time_log`, `time_pause`, `time_start`)
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,NULL,NULL,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,NULL,NULL,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,NULL,NULL,NULL),
	(5,'samle tast dev','2022-09-17 00:00:00',1,1,'sdsd sdsdsd sdsd',1,0,'2022-09-10 11:21:48','2022-09-10 11:21:48',5,NULL,1,'2022-09-10 00:00:00',NULL,NULL,NULL,NULL,NULL),
	(6,'samle tast dev2','2022-09-24 00:00:00',1,1,'wdwewdsdsd',0,0,'2022-09-10 11:22:28','2022-09-10 11:22:28',5,NULL,1,'2022-09-12 00:00:00',NULL,NULL,NULL,NULL,NULL),
	(7,'samle tast dev 33','2022-09-17 00:00:00',1,1,'wewewewe',0,0,'2022-09-10 11:22:51','2022-09-10 11:22:51',5,NULL,1,'2022-09-10 00:00:00',NULL,NULL,NULL,NULL,NULL),
	(8,'samle tast dev 33','2022-09-17 00:00:00',1,1,'wewewewe',0,0,'2022-09-10 11:23:42','2022-09-10 11:23:42',5,NULL,1,'2022-09-10 00:00:00',NULL,NULL,NULL,NULL,NULL),
	(9,'Smart Contract','2022-09-17 00:00:00',3,1,'sdsd',0,8,'2022-09-10 12:51:06','2022-09-10 13:35:44',5,NULL,1,'2022-09-10 00:00:00','2022-09-10 12:57:31',NULL,NULL,NULL,NULL),
	(10,'Web 3','2022-09-30 00:00:00',3,1,'wewewe',0,8,'2022-09-10 13:25:16','2022-09-10 13:35:26',5,NULL,1,'2022-09-10 00:00:00','2022-09-10 13:25:57',NULL,NULL,NULL,NULL),
	(11,'Photo edit','2022-09-17 00:00:00',1,1,'sds sdsdsd',2,8,'2022-09-12 09:49:36','2022-09-24 12:55:35',5,NULL,1,'2022-09-14 00:00:00','2022-09-12 09:52:08','2022-09-24 12:55:35',NULL,NULL,NULL),
	(12,'reeirye','2022-10-01 00:00:00',1,1,'ddddd',0,8,'2022-09-23 23:56:31','2022-09-24 12:55:24',1,NULL,1,'2022-09-25 00:00:00','2022-09-24 02:58:40','2022-09-24 12:55:24',5427.00,1,NULL),
	(13,'test Task 1','2022-10-01 00:00:00',1,1,'sdsdsd',0,8,'2022-09-24 11:49:40','2022-09-24 11:56:11',1,NULL,1,'2022-09-25 00:00:00','2022-09-24 11:51:20','2022-09-24 11:56:11',142.00,1,NULL),
	(14,'samle tast 2','2022-09-30 00:00:00',1,1,'dfgdfg',1,8,'2022-09-24 12:01:01','2022-09-24 12:40:58',1,NULL,1,'2022-09-24 00:00:00','2022-09-24 12:01:10','2022-09-24 12:40:58',1002.00,1,NULL),
	(15,'sample test ena','2022-09-30 00:00:00',1,1,'sdsdsd',0,8,'2022-09-24 17:23:57','2022-09-24 17:58:55',1,NULL,1,'2022-09-25 00:00:00','2022-09-24 17:31:37','2022-09-24 17:58:55',620.00,1,NULL);




