--
-- Host: localhost    Database: ncrorgza_myt34
-- ------------------------------------------------------


--
-- Current Database: `ncrorgza_myt34`
--


--
-- Table structure for table `mt97_android_udid`
--

CREATE TABLE `mt97_android_udid` (
  `user_name` varchar(255) NOT NULL,
  `registration_id` varchar(255) NOT NULL,
  PRIMARY KEY (`registration_id`),
  KEY `mt97_user_name` (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_android_udid`
--


--
-- Table structure for table `mt97_attachment`
--

CREATE TABLE `mt97_attachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` varchar(30) DEFAULT NULL,
  `uri` text,
  `created` date DEFAULT NULL,
  `task_id` int(11) DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `mega_id` char(8) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mega_id` (`mega_id`),
  KEY `mt97_task_id` (`task_id`),
  KEY `mt97_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_attachment`
--


--
-- Table structure for table `mt97_auth_assignment`
--

CREATE TABLE `mt97_auth_assignment` (
  `itemname` varchar(255) NOT NULL,
  `userid` varchar(255) NOT NULL,
  `bizrule` text,
  `data` text,
  PRIMARY KEY (`itemname`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_auth_assignment`
--

INSERT INTO `mt97_auth_assignment` (`itemname`, `userid`, `bizrule`, `data`) VALUES ('Application Manager','1',NULL,'N;'),('Application Manager','3',NULL,'N;'),('Developer','1',NULL,'N;'),('Developer','3',NULL,'N;'),('Project Manager','1',NULL,'N;'),('Project Manager','2',NULL,'N;'),('Project Manager','3',NULL,'N;'),('Role Manager','1',NULL,'N;'),('Role Manager','2',NULL,'N;'),('Role Manager','3',NULL,'N;'),('Task Manager','1',NULL,'N;'),('Task Manager','2',NULL,'N;'),('Task Manager','3',NULL,'N;'),('User Manager','1',NULL,'N;'),('User Manager','2',NULL,'N;'),('User Manager','3',NULL,'N;');

--
-- Table structure for table `mt97_auth_item`
--

CREATE TABLE `mt97_auth_item` (
  `name` varchar(255) NOT NULL,
  `type` int(11) NOT NULL,
  `description` text,
  `bizrule` text,
  `data` text,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_auth_item`
--

INSERT INTO `mt97_auth_item` (`name`, `type`, `description`, `bizrule`, `data`) VALUES ('adminAllCharge',0,'Charge Admin All',NULL,'N;'),('adminCharge',0,'Charge Admin',NULL,'N;'),('adminConfig',0,'Application Configuration Management',NULL,'N;'),('adminRole',0,'Roles Configuration Management',NULL,'N;'),('Application Manager',2,'',NULL,'N;'),('createCharge',0,'Charge Create',NULL,'N;'),('createProject',0,'Project Create',NULL,'N;'),('createTask',0,'Task Create',NULL,'N;'),('createUser',0,'User Create',NULL,'N;'),('deleteProject',0,'Project Delete',NULL,'N;'),('deleteTask',0,'Task Delete',NULL,'N;'),('deleteUser',0,'User Delete',NULL,'N;'),('Developer',2,'',NULL,'N;'),('indexAllProject',0,'Project View All',NULL,'N;'),('indexAllTask',0,'Task View All',NULL,'N;'),('indexAllUser',0,'User View All',NULL,'N;'),('Project Manager',2,'',NULL,'N;'),('Role Manager',2,'',NULL,'N;'),('Task Manager',2,'',NULL,'N;'),('updateProject',0,'Project Update',NULL,'N;'),('updateTask',0,'Task Update',NULL,'N;'),('updateUser',0,'User Update',NULL,'N;'),('User Manager',2,'',NULL,'N;');

--
-- Table structure for table `mt97_auth_item_child`
--

CREATE TABLE `mt97_auth_item_child` (
  `parent` varchar(255) NOT NULL,
  `child` varchar(255) NOT NULL,
  PRIMARY KEY (`parent`,`child`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_auth_item_child`
--

INSERT INTO `mt97_auth_item_child` (`parent`, `child`) VALUES ('Application Manager','adminAllCharge'),('Application Manager','adminConfig'),('Developer','createCharge'),('Developer','createTask'),('Developer','deleteTask'),('Developer','updateTask'),('Project Manager','adminCharge'),('Project Manager','createCharge'),('Project Manager','createProject'),('Project Manager','deleteProject'),('Project Manager','indexAllProject'),('Project Manager','updateProject'),('Role Manager','adminRole'),('Task Manager','createTask'),('Task Manager','deleteTask'),('Task Manager','indexAllTask'),('Task Manager','updateTask'),('User Manager','createUser'),('User Manager','deleteUser'),('User Manager','updateUser');

--
-- Table structure for table `mt97_charge`
--

CREATE TABLE `mt97_charge` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `last_upd` datetime DEFAULT NULL,
  `last_upd_by` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `task_id` int(11) DEFAULT NULL,
  `day` date DEFAULT NULL,
  `hours` float DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mt97_created_by` (`created_by`),
  KEY `mt97_last_upd_by` (`last_upd_by`),
  KEY `mt97_user_id` (`user_id`),
  KEY `mt97_project_id_charge` (`project_id`),
  KEY `mt97_task_id_charge` (`task_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_charge`
--


--
-- Table structure for table `mt97_comment`
--

CREATE TABLE `mt97_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `last_upd` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_upd_by` int(11) DEFAULT NULL,
  `entity` varchar(255) NOT NULL,
  `entity_id` int(11) NOT NULL,
  `body` text,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_comment`
--


--
-- Table structure for table `mt97_counter_save`
--

CREATE TABLE `mt97_counter_save` (
  `save_name` varchar(10) NOT NULL,
  `save_value` int(11) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_counter_save`
--


--
-- Table structure for table `mt97_counter_users`
--

CREATE TABLE `mt97_counter_users` (
  `user_ip` varchar(39) NOT NULL,
  `user_time` int(11) unsigned NOT NULL,
  UNIQUE KEY `user_ip` (`user_ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_counter_users`
--


--
-- Table structure for table `mt97_project`
--

CREATE TABLE `mt97_project` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `last_upd` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_upd_by` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `prefix` varchar(3) DEFAULT NULL,
  `description` text,
  `champion_id` int(11) DEFAULT NULL,
  `status` varchar(3) DEFAULT NULL,
  `progress` smallint(5) unsigned DEFAULT NULL,
  `par_project_id` int(11) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `eff_start_date` date DEFAULT NULL,
  `eff_end_date` date DEFAULT NULL,
  `client` tinytext,
  `chargeable_flg` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mt97_par_project` (`par_project_id`),
  KEY `mt97_champion` (`champion_id`),
  KEY `mt97_created_by_project` (`created_by`),
  KEY `mt97_status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_project`
--

INSERT INTO `mt97_project` (`id`, `created`, `created_by`, `last_upd`, `last_upd_by`, `name`, `prefix`, `description`, `champion_id`, `status`, `progress`, `par_project_id`, `start_date`, `end_date`, `eff_start_date`, `eff_end_date`, `client`, `chargeable_flg`) VALUES (1,'2017-10-24 15:30:09',1,'2017-10-24 15:30:09',1,'Courses','--0',NULL,1,'4',0,NULL,NULL,NULL,NULL,NULL,NULL,1),(2,'2017-10-24 15:30:09',1,'2017-10-24 15:30:09',1,'Vacation','--1',NULL,1,'4',0,NULL,NULL,NULL,NULL,NULL,NULL,1),(3,'2017-10-24 15:30:09',1,'2017-10-24 15:30:09',1,'Public Holiday','--2',NULL,1,'4',0,NULL,NULL,NULL,NULL,NULL,NULL,1),(4,'2017-10-24 15:30:09',1,'2017-10-24 15:30:09',1,'Sick-leave','--3',NULL,1,'4',0,NULL,NULL,NULL,NULL,NULL,NULL,1),(5,'2017-10-24 13:51:30',1,'2017-10-24 11:51:30',1,'DEBT COUNSELLORS','PRJ','<ul>\r\n	<li><strong><a href=\"http://www.ncr.org.za/ncr-departments/registrations-compliance/debt-counsellors/dc-who-needs-to-register\">Who needs to register?</a></strong></li>\r\n</ul>\r\n',1,'0',0,NULL,'2017-10-25',NULL,NULL,NULL,'',0),(6,'2017-10-25 08:25:26',3,'2017-10-25 06:25:26',3,'Test12','PRX','',3,'0',0,NULL,NULL,NULL,NULL,NULL,'',0);

--
-- Table structure for table `mt97_session`
--

CREATE TABLE `mt97_session` (
  `id` char(32) NOT NULL,
  `user_id` int(11) unsigned NOT NULL,
  `expire` int(11) DEFAULT NULL,
  `data` longblob,
  PRIMARY KEY (`id`),
  KEY `mt97_user_id_session` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_session`
--

INSERT INTO `mt97_session` (`id`, `user_id`, `expire`, `data`) VALUES ('3m9l9cngeigf3tb01lhk9oiu23',0,1532701710,_binary '8cf34fb68ad9367bd91170635313ce70Yii.CWebUser.flashcounters|a:0:{}'),('4bkivt7fjn7tmdkrkhsefp8k30',0,1509012723,_binary '8cf34fb68ad9367bd91170635313ce70__returnUrl|s:16:\"/myt/task/create\";8cf34fb68ad9367bd91170635313ce70Yii.CWebUser.flashcounters|a:0:{}'),('54rtshudna1iidlih5o8eift56',0,1610707519,_binary '8cf34fb68ad9367bd91170635313ce70Yii.CWebUser.flashcounters|a:0:{}'),('874500e4s0d445s6rphkr3qj70',0,1510057282,_binary '8cf34fb68ad9367bd91170635313ce70Yii.CWebUser.flashcounters|a:0:{}'),('8jp63dnhvvnpced3lqggp74km7',0,1508925207,_binary '8cf34fb68ad9367bd91170635313ce70Yii.CWebUser.flashcounters|a:0:{}'),('fb5ubk25fpbk86ggv894kv92t0',0,1509450149,_binary '8cf34fb68ad9367bd91170635313ce70Yii.CWebUser.flashcounters|a:0:{}'),('lfr641h2usdf6rp7sq7o03s4u0',0,1584691857,_binary '8cf34fb68ad9367bd91170635313ce70Yii.CWebUser.flashcounters|a:0:{}'),('ob9bdf19f3gegicicmkmk5lld5',0,1594640249,_binary '8cf34fb68ad9367bd91170635313ce70Yii.CWebUser.flashcounters|a:0:{}'),('oh8gl99qmrks7hhhpp2ajrm8u4',0,1543834311,_binary '8cf34fb68ad9367bd91170635313ce70Yii.CWebUser.flashcounters|a:0:{}'),('qb24lsivg3f63pcthu7vdkel11',0,1582024592,_binary '8cf34fb68ad9367bd91170635313ce70Yii.CWebUser.flashcounters|a:0:{}'),('tlsnm878dahsut1keuhcqs1cr5',3,1508923552,_binary '8cf34fb68ad9367bd91170635313ce70__id|s:1:\"3\";8cf34fb68ad9367bd91170635313ce70__name|s:8:\"Mmadikwa\";8cf34fb68ad9367bd91170635313ce70pageSize|i:10;8cf34fb68ad9367bd91170635313ce70username|s:8:\"Mmadikwa\";8cf34fb68ad9367bd91170635313ce70avatar|s:37:\"/myt/images/user/default_avatar_M.jpg\";8cf34fb68ad9367bd91170635313ce70__states|a:3:{s:8:\"pageSize\";b:1;s:8:\"username\";b:1;s:6:\"avatar\";b:1;}8cf34fb68ad9367bd91170635313ce70navigation|a:4:{s:4:\"home\";b:0;s:7:\"project\";a:2:{s:4:\"type\";s:2:\"my\";s:2:\"id\";s:0:\"\";}s:4:\"task\";a:2:{s:4:\"type\";s:3:\"all\";s:2:\"id\";s:0:\"\";}s:6:\"charge\";a:1:{s:4:\"type\";s:2:\"my\";}}8cf34fb68ad9367bd91170635313ce70task_query|s:0:\"\";8cf34fb68ad9367bd91170635313ce70p_task_query|s:0:\"\";8cf34fb68ad9367bd91170635313ce70Yii.CWebUser.flashcounters|a:0:{}'),('uatg7soec5l33jtctdvmonsa24',0,1557221375,_binary '8cf34fb68ad9367bd91170635313ce70Yii.CWebUser.flashcounters|a:0:{}'),('v6ihr57a55gdro4kdgsih38607',0,1521462822,_binary '8cf34fb68ad9367bd91170635313ce70Yii.CWebUser.flashcounters|a:0:{}');

--
-- Table structure for table `mt97_task`
--

CREATE TABLE `mt97_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `last_upd` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `last_upd_by` int(11) DEFAULT NULL,
  `par_project_id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `description` text,
  `status` int(11) DEFAULT NULL,
  `progress` smallint(5) unsigned DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `eff_start_date` date DEFAULT NULL,
  `eff_end_date` date DEFAULT NULL,
  `priority` smallint(6) DEFAULT NULL,
  `type` smallint(6) DEFAULT NULL,
  `private_flg` tinyint(1) NOT NULL DEFAULT '0',
  `chargeable_flg` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mt97_task_ibfk_3` (`parent_id`),
  KEY `mt97_task_ibfk_2` (`created_by`),
  KEY `mt97_task_ibfk_1` (`par_project_id`),
  KEY `mt97_title` (`title`,`par_project_id`),
  KEY `mt97_status_task` (`status`),
  KEY `mt97_type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_task`
--

INSERT INTO `mt97_task` (`id`, `created`, `created_by`, `last_upd`, `last_upd_by`, `par_project_id`, `parent_id`, `title`, `description`, `status`, `progress`, `start_date`, `end_date`, `eff_start_date`, `eff_end_date`, `priority`, `type`, `private_flg`, `chargeable_flg`) VALUES (1,'2017-10-24 13:52:40',1,'2017-10-24 11:52:40',1,5,NULL,'Who needs to register?','<p>&nbsp;The Act makes provision for the registration of debt counsellors which have complied with all the provisions of The Act and satisfied the training requirements of the NCR.</p>\r\n',1,0,'2017-10-24',NULL,NULL,NULL,1,3,0,0),(2,'2017-10-24 13:57:32',1,'2017-10-24 13:09:41',1,5,NULL,'Search for a Debt Counsellor','<p>http://www.ncr.org.za/register_of_registrants/registered_dc.php</p>\r\n',1,0,'2017-10-24','2017-10-27',NULL,NULL,2,3,0,0),(3,'2017-10-25 08:23:29',3,'2017-10-25 06:23:29',3,5,NULL,'DC Rockets','<p>thi is a test</p>\r\n',1,0,'2017-10-25',NULL,NULL,NULL,1,3,0,0);

--
-- Table structure for table `mt97_task_status`
--

CREATE TABLE `mt97_task_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `group_id` int(11) unsigned NOT NULL,
  `order_by` int(11) unsigned NOT NULL,
  `default_flg` tinyint(1) DEFAULT NULL,
  `active_flg` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_task_status`
--

INSERT INTO `mt97_task_status` (`id`, `name`, `group_id`, `order_by`, `default_flg`, `active_flg`) VALUES (1,'Open',0,0,1,1),(2,'Working On',0,1,0,1),(3,'Suspended',2,2,0,1),(4,'Closed',1,3,0,1),(5,'Cancelled',1,4,0,1);

--
-- Table structure for table `mt97_task_type`
--

CREATE TABLE `mt97_task_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `order_by` int(11) unsigned NOT NULL,
  `default_flg` tinyint(1) DEFAULT NULL,
  `active_flg` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_task_type`
--

INSERT INTO `mt97_task_type` (`id`, `name`, `order_by`, `default_flg`, `active_flg`) VALUES (1,'Bug',0,0,1),(2,'Enhancement',1,0,1),(3,'Task',2,1,1);

--
-- Table structure for table `mt97_user`
--

CREATE TABLE `mt97_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT '1',
  `last_upd` datetime NOT NULL,
  `last_upd_by` int(11) NOT NULL DEFAULT '1',
  `username` varchar(255) NOT NULL,
  `password` varchar(64) NOT NULL,
  `email` varchar(255) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `name` varchar(63) DEFAULT NULL,
  `surname` varchar(63) DEFAULT NULL,
  `gender` char(1) NOT NULL,
  `level` varchar(63) DEFAULT NULL,
  `phone` varchar(63) DEFAULT NULL,
  `mobile` varchar(63) DEFAULT NULL,
  `load_cost` float(7,3) DEFAULT NULL,
  `bill_code` smallint(6) DEFAULT NULL,
  `seat_charge` float(7,3) DEFAULT NULL,
  `daily_hours` float(3,1) DEFAULT NULL,
  `profile_id` int(11) DEFAULT NULL,
  `note` text,
  `confirm_key` varchar(40) DEFAULT NULL,
  `avatar` text,
  `page_size` tinyint(4) DEFAULT NULL,
  `notifications` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `mt97_profile` (`profile_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_user`
--

INSERT INTO `mt97_user` (`id`, `created`, `created_by`, `last_upd`, `last_upd_by`, `username`, `password`, `email`, `active`, `name`, `surname`, `gender`, `level`, `phone`, `mobile`, `load_cost`, `bill_code`, `seat_charge`, `daily_hours`, `profile_id`, `note`, `confirm_key`, `avatar`, `page_size`, `notifications`) VALUES (1,'2017-10-24 15:30:09',1,'2017-10-24 15:30:09',1,'admin','$2y$13$Ca1IQ4WFfHhr8..1sXvCc.Nd0VY7hRcXPIE.iSrpXOfZsEelg9ItG','ptlabela@ncr.org.za',1,'Admin','Admin','M',NULL,NULL,NULL,NULL,NULL,NULL,8.0,NULL,NULL,NULL,NULL,NULL,'N;'),(2,'2017-10-24 15:07:23',1,'2017-10-25 08:52:44',1,'Morris','$2y$13$8cRhOspV7DCfwW5h9sb9PO0TPzYrhewPtKE8ZwBNsL.4rS3ahCAIa','ptlabela@ncr.org.za',1,'Morris','','M','','','',NULL,NULL,NULL,8.0,NULL,NULL,NULL,'',10,'a:2:{s:15:\"taskAssociation\";a:2:{s:5:\"email\";s:1:\"1\";s:7:\"android\";s:1:\"0\";}s:18:\"projectAssociation\";a:2:{s:5:\"email\";s:1:\"1\";s:7:\"android\";s:1:\"0\";}}');

--
-- Table structure for table `mt97_user_project`
--

CREATE TABLE `mt97_user_project` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL,
  `last_upd` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `rollon_date` date DEFAULT NULL,
  `rolloff_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`project_id`),
  KEY `mt97_user_project_ibfk_2` (`project_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_user_project`
--

INSERT INTO `mt97_user_project` (`id`, `created`, `last_upd`, `user_id`, `project_id`, `rollon_date`, `rolloff_date`) VALUES (1,'2017-10-24 15:30:09','2017-10-24 15:30:09',1,1,'2017-10-24',NULL),(2,'2017-10-24 15:30:09','2017-10-24 15:30:09',1,2,'2017-10-24',NULL),(3,'2017-10-24 15:30:09','2017-10-24 15:30:09',1,3,'2017-10-24',NULL),(4,'2017-10-24 15:30:09','2017-10-24 15:30:09',1,4,'2017-10-24',NULL),(5,'2017-10-24 13:51:30','2017-10-24 11:51:30',1,5,'2017-10-24',NULL),(6,'2017-10-24 15:07:23','2017-10-24 13:07:23',2,1,'2017-10-24',NULL),(7,'2017-10-24 15:07:23','2017-10-24 13:07:23',2,2,'2017-10-24',NULL),(8,'2017-10-24 15:07:23','2017-10-24 13:07:23',2,3,'2017-10-24',NULL),(9,'2017-10-24 15:07:23','2017-10-24 13:07:23',2,4,'2017-10-24',NULL),(10,'2017-10-25 08:19:30','2017-10-25 06:19:30',3,1,'2017-10-25',NULL),(11,'2017-10-25 08:19:30','2017-10-25 06:19:30',3,2,'2017-10-25',NULL),(12,'2017-10-25 08:19:30','2017-10-25 06:19:30',3,3,'2017-10-25',NULL),(13,'2017-10-25 08:19:30','2017-10-25 06:19:30',3,4,'2017-10-25',NULL),(14,'2017-10-25 08:25:26','2017-10-25 06:25:26',3,6,'2017-10-25',NULL);

--
-- Table structure for table `mt97_user_task`
--

CREATE TABLE `mt97_user_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL,
  `last_upd` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_id` int(11) NOT NULL,
  `task_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`task_id`),
  KEY `mt97_user_task_ibfk_2` (`task_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `mt97_user_task`
--

INSERT INTO `mt97_user_task` (`id`, `created`, `last_upd`, `user_id`, `task_id`) VALUES (1,'2017-10-24 15:52:40','2017-10-24 13:52:40',1,1),(2,'2017-10-24 15:57:32','2017-10-24 13:57:32',1,2),(3,'2017-10-25 10:23:29','2017-10-25 08:23:29',1,3);

--
-- Dumping events for database 'ncrorgza_myt34'
--

--
-- Dumping routines for database 'ncrorgza_myt34'
--


