-- MySQL dump 10.13  Distrib 5.7.44, for Linux (x86_64)
--
-- Host: localhost    Database: ncrorgza_myt341
-- ------------------------------------------------------
-- Server version	5.7.44

/*!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 */;

--
-- Current Database: `ncrorgza_myt341`
--


--
-- Table structure for table `mt4b_android_udid`
--

DROP TABLE IF EXISTS `mt4b_android_udid`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_android_udid` (
  `user_name` varchar(255) NOT NULL,
  `registration_id` varchar(255) NOT NULL,
  PRIMARY KEY (`registration_id`),
  KEY `mt4b_user_name` (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_android_udid`
--

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

--
-- Table structure for table `mt4b_attachment`
--

DROP TABLE IF EXISTS `mt4b_attachment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_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 `mt4b_task_id` (`task_id`),
  KEY `mt4b_project_id` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_attachment`
--

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

--
-- Table structure for table `mt4b_auth_assignment`
--

DROP TABLE IF EXISTS `mt4b_auth_assignment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_auth_assignment`
--

LOCK TABLES `mt4b_auth_assignment` WRITE;
/*!40000 ALTER TABLE `mt4b_auth_assignment` DISABLE KEYS */;
INSERT INTO `mt4b_auth_assignment` (`itemname`, `userid`, `bizrule`, `data`) VALUES ('Application Manager','1',NULL,'N;'),('Developer','1',NULL,'N;'),('Project Manager','1',NULL,'N;'),('Role Manager','1',NULL,'N;'),('Task Manager','1',NULL,'N;'),('User Manager','1',NULL,'N;');
/*!40000 ALTER TABLE `mt4b_auth_assignment` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mt4b_auth_item`
--

DROP TABLE IF EXISTS `mt4b_auth_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_auth_item`
--

LOCK TABLES `mt4b_auth_item` WRITE;
/*!40000 ALTER TABLE `mt4b_auth_item` DISABLE KEYS */;
INSERT INTO `mt4b_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;');
/*!40000 ALTER TABLE `mt4b_auth_item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mt4b_auth_item_child`
--

DROP TABLE IF EXISTS `mt4b_auth_item_child`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_auth_item_child` (
  `parent` varchar(255) NOT NULL,
  `child` varchar(255) NOT NULL,
  PRIMARY KEY (`parent`,`child`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_auth_item_child`
--

LOCK TABLES `mt4b_auth_item_child` WRITE;
/*!40000 ALTER TABLE `mt4b_auth_item_child` DISABLE KEYS */;
INSERT INTO `mt4b_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');
/*!40000 ALTER TABLE `mt4b_auth_item_child` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mt4b_charge`
--

DROP TABLE IF EXISTS `mt4b_charge`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_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 `mt4b_created_by` (`created_by`),
  KEY `mt4b_last_upd_by` (`last_upd_by`),
  KEY `mt4b_user_id` (`user_id`),
  KEY `mt4b_project_id_charge` (`project_id`),
  KEY `mt4b_task_id_charge` (`task_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_charge`
--

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

--
-- Table structure for table `mt4b_comment`
--

DROP TABLE IF EXISTS `mt4b_comment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_comment`
--

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

--
-- Table structure for table `mt4b_counter_save`
--

DROP TABLE IF EXISTS `mt4b_counter_save`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_counter_save` (
  `save_name` varchar(10) NOT NULL,
  `save_value` int(11) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_counter_save`
--

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

--
-- Table structure for table `mt4b_counter_users`
--

DROP TABLE IF EXISTS `mt4b_counter_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_counter_users`
--

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

--
-- Table structure for table `mt4b_project`
--

DROP TABLE IF EXISTS `mt4b_project`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_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 `mt4b_par_project` (`par_project_id`),
  KEY `mt4b_champion` (`champion_id`),
  KEY `mt4b_created_by_project` (`created_by`),
  KEY `mt4b_status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_project`
--

LOCK TABLES `mt4b_project` WRITE;
/*!40000 ALTER TABLE `mt4b_project` DISABLE KEYS */;
INSERT INTO `mt4b_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:22:21',1,'2017-10-24 15:22:21',1,'Courses','--0',NULL,1,'4',0,NULL,NULL,NULL,NULL,NULL,NULL,1),(2,'2017-10-24 15:22:21',1,'2017-10-24 15:22:21',1,'Vacation','--1',NULL,1,'4',0,NULL,NULL,NULL,NULL,NULL,NULL,1),(3,'2017-10-24 15:22:21',1,'2017-10-24 15:22:21',1,'Public Holiday','--2',NULL,1,'4',0,NULL,NULL,NULL,NULL,NULL,NULL,1),(4,'2017-10-24 15:22:21',1,'2017-10-24 15:22:21',1,'Sick-leave','--3',NULL,1,'4',0,NULL,NULL,NULL,NULL,NULL,NULL,1);
/*!40000 ALTER TABLE `mt4b_project` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mt4b_session`
--

DROP TABLE IF EXISTS `mt4b_session`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_session` (
  `id` char(32) NOT NULL,
  `user_id` int(11) unsigned NOT NULL,
  `expire` int(11) DEFAULT NULL,
  `data` longblob,
  PRIMARY KEY (`id`),
  KEY `mt4b_user_id_session` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_session`
--

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

--
-- Table structure for table `mt4b_task`
--

DROP TABLE IF EXISTS `mt4b_task`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_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 `mt4b_task_ibfk_3` (`parent_id`),
  KEY `mt4b_task_ibfk_2` (`created_by`),
  KEY `mt4b_task_ibfk_1` (`par_project_id`),
  KEY `mt4b_title` (`title`,`par_project_id`),
  KEY `mt4b_status_task` (`status`),
  KEY `mt4b_type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_task`
--

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

--
-- Table structure for table `mt4b_task_status`
--

DROP TABLE IF EXISTS `mt4b_task_status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_task_status`
--

LOCK TABLES `mt4b_task_status` WRITE;
/*!40000 ALTER TABLE `mt4b_task_status` DISABLE KEYS */;
INSERT INTO `mt4b_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);
/*!40000 ALTER TABLE `mt4b_task_status` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mt4b_task_type`
--

DROP TABLE IF EXISTS `mt4b_task_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_task_type`
--

LOCK TABLES `mt4b_task_type` WRITE;
/*!40000 ALTER TABLE `mt4b_task_type` DISABLE KEYS */;
INSERT INTO `mt4b_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);
/*!40000 ALTER TABLE `mt4b_task_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mt4b_user`
--

DROP TABLE IF EXISTS `mt4b_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_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 `mt4b_profile` (`profile_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_user`
--

LOCK TABLES `mt4b_user` WRITE;
/*!40000 ALTER TABLE `mt4b_user` DISABLE KEYS */;
INSERT INTO `mt4b_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:22:21',1,'2017-10-24 15:22:21',1,'admin','$2y$13$dDiuGNOdF9gwhOogZMOPhOyGtU3uQCFk/r0BBzSl0MN1Kd02ghB1q','ptlabela@ncr.org.za',1,'Admin','Admin','M',NULL,NULL,NULL,NULL,NULL,NULL,8.0,NULL,NULL,NULL,NULL,NULL,'N;');
/*!40000 ALTER TABLE `mt4b_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mt4b_user_project`
--

DROP TABLE IF EXISTS `mt4b_user_project`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_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 `mt4b_user_project_ibfk_2` (`project_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_user_project`
--

LOCK TABLES `mt4b_user_project` WRITE;
/*!40000 ALTER TABLE `mt4b_user_project` DISABLE KEYS */;
INSERT INTO `mt4b_user_project` (`id`, `created`, `last_upd`, `user_id`, `project_id`, `rollon_date`, `rolloff_date`) VALUES (1,'2017-10-24 15:22:21','2017-10-24 15:22:21',1,1,'2017-10-24',NULL),(2,'2017-10-24 15:22:21','2017-10-24 15:22:21',1,2,'2017-10-24',NULL),(3,'2017-10-24 15:22:21','2017-10-24 15:22:21',1,3,'2017-10-24',NULL),(4,'2017-10-24 15:22:21','2017-10-24 15:22:21',1,4,'2017-10-24',NULL);
/*!40000 ALTER TABLE `mt4b_user_project` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mt4b_user_task`
--

DROP TABLE IF EXISTS `mt4b_user_task`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mt4b_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 `mt4b_user_task_ibfk_2` (`task_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mt4b_user_task`
--

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

--
-- Dumping events for database 'ncrorgza_myt341'
--

--
-- Dumping routines for database 'ncrorgza_myt341'
--
/*!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 2023-12-08 18:00:14