--
-- Host: localhost    Database: vmos
-- ------------------------------------------------------


--
-- Table structure for table `auth_group`
--

CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_group`
--


--
-- Table structure for table `auth_group_permissions`
--

CREATE TABLE `auth_group_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_group_permissions`
--


--
-- Table structure for table `auth_permission`
--

CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_permission`
--

INSERT INTO `auth_permission` VALUES (1,'Can add log entry',1,'add_logentry'),(2,'Can change log entry',1,'change_logentry'),(3,'Can delete log entry',1,'delete_logentry'),(4,'Can add permission',2,'add_permission'),(5,'Can change permission',2,'change_permission'),(6,'Can delete permission',2,'delete_permission'),(7,'Can add group',3,'add_group'),(8,'Can change group',3,'change_group'),(9,'Can delete group',3,'delete_group'),(10,'Can add user',4,'add_user'),(11,'Can change user',4,'change_user'),(12,'Can delete user',4,'delete_user'),(13,'Can add content type',5,'add_contenttype'),(14,'Can change content type',5,'change_contenttype'),(15,'Can delete content type',5,'delete_contenttype'),(16,'Can add session',6,'add_session'),(17,'Can change session',6,'change_session'),(18,'Can delete session',6,'delete_session'),(19,'Can add certificate',7,'add_certificate'),(20,'Can change certificate',7,'change_certificate'),(21,'Can delete certificate',7,'delete_certificate'),(22,'Can add contractor',8,'add_contractor'),(23,'Can change contractor',8,'change_contractor'),(24,'Can delete contractor',8,'delete_contractor'),(25,'Can add experience slab',9,'add_experienceslab'),(26,'Can change experience slab',9,'change_experienceslab'),(27,'Can delete experience slab',9,'delete_experienceslab'),(28,'Can add group',10,'add_group'),(29,'Can change group',10,'change_group'),(30,'Can delete group',10,'delete_group'),(31,'Can add hiring manager',11,'add_hiringmanager'),(32,'Can change hiring manager',11,'change_hiringmanager'),(33,'Can delete hiring manager',11,'delete_hiringmanager'),(34,'Can add idle time',12,'add_idletime'),(35,'Can change idle time',12,'change_idletime'),(36,'Can delete idle time',12,'delete_idletime'),(37,'Can add leaves',13,'add_leaves'),(38,'Can change leaves',13,'change_leaves'),(39,'Can delete leaves',13,'delete_leaves'),(40,'Can add logged time history',14,'add_loggedtimehistory'),(41,'Can change logged time history',14,'change_loggedtimehistory'),(42,'Can delete logged time history',14,'delete_loggedtimehistory'),(43,'Can add menu',15,'add_menu'),(44,'Can change menu',15,'change_menu'),(45,'Can delete menu',15,'delete_menu'),(46,'Can add month working hours',16,'add_monthworkinghours'),(47,'Can change month working hours',16,'change_monthworkinghours'),(48,'Can delete month working hours',16,'delete_monthworkinghours'),(49,'Can add notification',17,'add_notification'),(50,'Can change notification',17,'change_notification'),(51,'Can delete notification',17,'delete_notification'),(52,'Can add password reset code',18,'add_passwordresetcode'),(53,'Can change password reset code',18,'change_passwordresetcode'),(54,'Can delete password reset code',18,'delete_passwordresetcode'),(55,'Can add poc manager',19,'add_pocmanager'),(56,'Can change poc manager',19,'change_pocmanager'),(57,'Can delete poc manager',19,'delete_pocmanager'),(58,'Can add purchase order',20,'add_purchaseorder'),(59,'Can change purchase order',20,'change_purchaseorder'),(60,'Can delete purchase order',20,'delete_purchaseorder'),(61,'Can add qualification certificates',21,'add_qualificationcertificates'),(62,'Can change qualification certificates',21,'change_qualificationcertificates'),(63,'Can delete qualification certificates',21,'delete_qualificationcertificates'),(64,'Can add role menus',22,'add_rolemenus'),(65,'Can change role menus',22,'change_rolemenus'),(66,'Can delete role menus',22,'delete_rolemenus'),(67,'Can add roles',23,'add_roles'),(68,'Can change roles',23,'change_roles'),(69,'Can delete roles',23,'delete_roles'),(70,'Can add set up',24,'add_setup'),(71,'Can change set up',24,'change_setup'),(72,'Can delete set up',24,'delete_setup'),(73,'Can add time sheet',25,'add_timesheet'),(74,'Can change time sheet',25,'change_timesheet'),(75,'Can delete time sheet',25,'delete_timesheet'),(76,'Can add time sheet history',26,'add_timesheethistory'),(77,'Can change time sheet history',26,'change_timesheethistory'),(78,'Can delete time sheet history',26,'delete_timesheethistory'),(79,'Can add user profile',27,'add_userprofile'),(80,'Can change user profile',27,'change_userprofile'),(81,'Can delete user profile',27,'delete_userprofile'),(82,'Can add vendor',28,'add_vendor'),(83,'Can change vendor',28,'change_vendor'),(84,'Can delete vendor',28,'delete_vendor'),(85,'Can add holidays',29,'add_holidays'),(86,'Can change holidays',29,'change_holidays'),(87,'Can delete holidays',29,'delete_holidays');

--
-- Table structure for table `auth_user_groups`
--

CREATE TABLE `auth_user_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
  KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`),
  CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_user_groups`
--


--
-- Table structure for table `auth_user_user_permissions`
--

CREATE TABLE `auth_user_user_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
  KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `auth_user_user_permissions`
--


--
-- Table structure for table `django_admin_log`
--

CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_time` datetime NOT NULL,
  `object_id` longtext,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) unsigned NOT NULL,
  `change_message` longtext NOT NULL,
  `content_type_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
  KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`),
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `django_admin_log`
--

INSERT INTO `django_admin_log` VALUES (1,'2019-12-31 11:04:32','1','1-2',1,'[{\"added\": {}}]',9,1),(2,'2019-12-31 11:04:38','2','2-5',1,'[{\"added\": {}}]',9,1),(3,'2019-12-31 11:04:44','3','5-8',1,'[{\"added\": {}}]',9,1),(4,'2019-12-31 11:04:51','4','8-10',1,'[{\"added\": {}}]',9,1),(5,'2019-12-31 11:04:56','5','10+',1,'[{\"added\": {}}]',9,1),(6,'2019-12-31 11:05:07','1','WDG1',1,'[{\"added\": {}}]',10,1),(7,'2019-12-31 11:13:28','2','Manager',1,'[{\"added\": {}}]',23,1),(8,'2019-12-31 11:13:32','3','Contractor',1,'[{\"added\": {}}]',23,1),(9,'2019-12-31 11:14:06','1','Dashboard',1,'[{\"added\": {}}]',15,1),(10,'2019-12-31 11:14:12','2','Vendors',1,'[{\"added\": {}}]',15,1),(11,'2019-12-31 11:14:23','3','Contractors',1,'[{\"added\": {}}]',15,1),(12,'2019-12-31 11:14:33','4','LMS',1,'[{\"added\": {}}]',15,1),(13,'2019-12-31 11:15:15','1','Admin',1,'[{\"added\": {}}]',22,1),(14,'2019-12-31 11:15:21','2','Manager',1,'[{\"added\": {}}]',22,1),(15,'2019-12-31 11:15:26','3','Contractor',1,'[{\"added\": {}}]',22,1),(16,'2019-12-31 11:15:57','2','Ranganath',1,'[{\"added\": {}}]',11,1),(17,'2019-12-31 11:16:23','3','Arvind',1,'[{\"added\": {}}]',11,1),(18,'2019-12-31 11:16:33','1','IdleTime object (1)',1,'[{\"added\": {}}]',12,1),(19,'2019-12-31 11:17:05','1','12-2019',1,'[{\"added\": {}}]',16,1),(20,'2019-12-31 11:17:15','2','1-2020',1,'[{\"added\": {}}]',16,1),(21,'2019-12-31 11:17:45','1','Kishore',1,'[{\"added\": {}}]',19,1),(22,'2019-12-31 11:18:07','2','Manjunath',1,'[{\"added\": {}}]',19,1),(23,'2019-12-31 11:19:10','1','Brisa Technologies',1,'[{\"added\": {}}]',28,1),(24,'2019-12-31 11:19:34','2','DK Technologies India Pvt Ltd',1,'[{\"added\": {}}]',28,1),(25,'2019-12-31 11:19:47','3','VT Tech India Pvt Ltd',1,'[{\"added\": {}}]',28,1),(26,'2019-12-31 11:20:01','4','MC Technologies Pvt Ltd',1,'[{\"added\": {}}]',28,1),(27,'2019-12-31 11:20:48','1','VT_IN5310-P005656',1,'[{\"added\": {}}]',20,1),(28,'2019-12-31 11:21:13','2','VT_IN5310-P005454',1,'[{\"added\": {}}]',20,1),(29,'2019-12-31 11:21:44','3','VT_IN5310-P005353',1,'[{\"added\": {}}]',20,1),(30,'2019-12-31 11:22:03','4','VT_IN5310-P005252',1,'[{\"added\": {}}]',20,1),(31,'2019-12-31 11:22:22','5','VT_IN5310-P005151',1,'[{\"added\": {}}]',20,1),(32,'2019-12-31 11:22:41','6','IN5310-P005843',1,'[{\"added\": {}}]',20,1),(33,'2019-12-31 11:22:59','7','IN5310-P005888',1,'[{\"added\": {}}]',20,1),(34,'2019-12-31 11:24:22','8','IN5310-P005912',1,'[{\"added\": {}}]',20,1),(35,'2019-12-31 11:24:36','7','IN5310-P005888',2,'[{\"changed\": {\"fields\": [\"vendor\"]}}]',20,1),(36,'2019-12-31 11:24:47','6','IN5310-P005843',2,'[{\"changed\": {\"fields\": [\"vendor\"]}}]',20,1),(37,'2019-12-31 11:25:23','9','IN5310-P005913',1,'[{\"added\": {}}]',20,1),(38,'2019-12-31 11:25:46','10','IN5310-P005914',1,'[{\"added\": {}}]',20,1),(39,'2019-12-31 11:26:07','11','IN5310-P005963',1,'[{\"added\": {}}]',20,1),(40,'2019-12-31 11:26:26','12','IN5310-P005960',1,'[{\"added\": {}}]',20,1),(41,'2019-12-31 11:26:54','13','IN5310-P005958',1,'[{\"added\": {}}]',20,1),(42,'2019-12-31 11:27:17','14','IN5310-P005925',1,'[{\"added\": {}}]',20,1),(43,'2019-12-31 11:27:44','15','IN5310-P101050',1,'[{\"added\": {}}]',20,1),(44,'2019-12-31 11:28:33','16','DK_IN5151-P008321',1,'[{\"added\": {}}]',20,1),(45,'2019-12-31 11:28:56','17','DK_IN5151-P008123',1,'[{\"added\": {}}]',20,1),(46,'2019-12-31 11:29:15','18','DK_IN5151-P008122',1,'[{\"added\": {}}]',20,1),(47,'2019-12-31 11:29:38','19','DK_IN5151-P008011',1,'[{\"added\": {}}]',20,1),(48,'2019-12-31 11:30:00','20','DK_IN5151-P008011',1,'[{\"added\": {}}]',20,1),(49,'2019-12-31 11:30:22','21','MC5151-P101099',1,'[{\"added\": {}}]',20,1),(50,'2019-12-31 11:30:46','22','MC5151-P101072',1,'[{\"added\": {}}]',20,1),(51,'2019-12-31 11:31:08','23','MC5151-P101063',1,'[{\"added\": {}}]',20,1),(52,'2019-12-31 11:31:28','24','MC5151-P101055',1,'[{\"added\": {}}]',20,1),(53,'2019-12-31 11:34:06','1','Adheeth',1,'[{\"added\": {}}]',8,1),(54,'2019-12-31 11:34:48','2','Sudarshan',1,'[{\"added\": {}}]',8,1),(55,'2019-12-31 11:35:34','3','Yassaswini AY',1,'[{\"added\": {}}]',8,1),(56,'2019-12-31 11:36:10','4','Rackesha',1,'[{\"added\": {}}]',8,1),(57,'2019-12-31 11:36:49','5','Srujan Rao',1,'[{\"added\": {}}]',8,1),(58,'2019-12-31 11:37:24','6','Kavitha Mehra',1,'[{\"added\": {}}]',8,1),(59,'2019-12-31 11:38:10','7','Jyothi',1,'[{\"added\": {}}]',8,1),(60,'2019-12-31 11:38:48','8','Mamatha',1,'[{\"added\": {}}]',8,1),(61,'2019-12-31 11:39:35','9','Revathi',1,'[{\"added\": {}}]',8,1),(62,'2019-12-31 11:40:08','10','Sharon',1,'[{\"added\": {}}]',8,1),(63,'2019-12-31 11:41:12','11','Shazia',1,'[{\"added\": {}}]',8,1),(64,'2019-12-31 11:45:23','12','Dheena',1,'[{\"added\": {}}]',8,1),(65,'2019-12-31 11:46:07','13','Ashriya',1,'[{\"added\": {}}]',8,1),(66,'2019-12-31 11:46:43','14','Jasmitha',1,'[{\"added\": {}}]',8,1),(67,'2019-12-31 11:47:20','15','Karthika',1,'[{\"added\": {}}]',8,1),(68,'2019-12-31 11:48:08','16','Kasturi',1,'[{\"added\": {}}]',8,1),(69,'2019-12-31 11:48:43','17','Soundarya',1,'[{\"added\": {}}]',8,1),(70,'2019-12-31 11:49:17','18','Samantha',1,'[{\"added\": {}}]',8,1),(71,'2019-12-31 11:49:47','19','Rohan',1,'[{\"added\": {}}]',8,1),(72,'2019-12-31 11:50:28','20','Likhita',1,'[{\"added\": {}}]',8,1),(73,'2020-01-07 04:41:25','3','Adheeth-12-2019',1,'[{\"added\": {}}]',25,1),(74,'2020-01-07 04:45:22','3','Adheeth-12-2019',2,'[{\"changed\": {\"fields\": [\"total_time\", \"approved_status\"]}}]',25,1),(75,'2020-01-07 04:47:29','3','Adheeth-12-2019',3,'',25,1),(76,'2020-01-07 04:48:23','1','2020-01-07',2,'[{\"changed\": {\"fields\": [\"intime\", \"outtime\", \"total_logged_time\"]}}]',26,1),(77,'2020-10-01 02:28:50','5','Aditya soft',1,'[{\"added\": {}}]',28,25),(78,'2020-10-01 02:29:15','5','Aditya soft',3,'',28,25),(79,'2020-10-01 02:50:40','4','arvind@wd.com',2,'[{\"changed\": {\"fields\": [\"password\"]}}]',4,25),(80,'2020-10-01 03:27:36','5','adheeth@brisa-tech.com',2,'[{\"changed\": {\"fields\": [\"password\"]}}]',4,25);

--
-- Table structure for table `django_content_type`
--

CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `django_content_type`
--

INSERT INTO `django_content_type` VALUES (1,'admin','logentry'),(3,'auth','group'),(2,'auth','permission'),(4,'auth','user'),(5,'contenttypes','contenttype'),(6,'sessions','session'),(7,'vmo_app','certificate'),(8,'vmo_app','contractor'),(9,'vmo_app','experienceslab'),(10,'vmo_app','group'),(11,'vmo_app','hiringmanager'),(29,'vmo_app','holidays'),(12,'vmo_app','idletime'),(13,'vmo_app','leaves'),(14,'vmo_app','loggedtimehistory'),(15,'vmo_app','menu'),(16,'vmo_app','monthworkinghours'),(17,'vmo_app','notification'),(18,'vmo_app','passwordresetcode'),(19,'vmo_app','pocmanager'),(20,'vmo_app','purchaseorder'),(21,'vmo_app','qualificationcertificates'),(22,'vmo_app','rolemenus'),(23,'vmo_app','roles'),(24,'vmo_app','setup'),(25,'vmo_app','timesheet'),(26,'vmo_app','timesheethistory'),(27,'vmo_app','userprofile'),(28,'vmo_app','vendor');

--
-- Table structure for table `django_migrations`
--

CREATE TABLE `django_migrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `django_migrations`
--

INSERT INTO `django_migrations` VALUES (1,'contenttypes','0001_initial','2019-12-31 11:02:07'),(2,'auth','0001_initial','2019-12-31 11:02:07'),(3,'admin','0001_initial','2019-12-31 11:02:07'),(4,'admin','0002_logentry_remove_auto_add','2019-12-31 11:02:07'),(5,'contenttypes','0002_remove_content_type_name','2019-12-31 11:02:08'),(6,'auth','0002_alter_permission_name_max_length','2019-12-31 11:02:08'),(7,'auth','0003_alter_user_email_max_length','2019-12-31 11:02:08'),(8,'auth','0004_alter_user_username_opts','2019-12-31 11:02:08'),(9,'auth','0005_alter_user_last_login_null','2019-12-31 11:02:08'),(10,'auth','0006_require_contenttypes_0002','2019-12-31 11:02:08'),(11,'auth','0007_alter_validators_add_error_messages','2019-12-31 11:02:08'),(12,'auth','0008_alter_user_username_max_length','2019-12-31 11:02:08'),(13,'auth','0009_alter_user_last_name_max_length','2019-12-31 11:02:08'),(14,'sessions','0001_initial','2019-12-31 11:02:08'),(15,'vmo_app','0001_initial','2019-12-31 11:02:09'),(16,'vmo_app','0002_auto_20200106_1743','2020-01-06 12:13:44');

--
-- Table structure for table `vmo_app_certificate`
--

CREATE TABLE `vmo_app_certificate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` datetime NOT NULL,
  `modified_on` datetime NOT NULL,
  `certificate` varchar(100) NOT NULL,
  `comments` varchar(100) NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vmo_app_certificate_created_by_id_3af30d5d_fk_auth_user_id` (`created_by_id`),
  CONSTRAINT `vmo_app_certificate_created_by_id_3af30d5d_fk_auth_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_certificate`
--


--
-- Table structure for table `vmo_app_contractor`
--

CREATE TABLE `vmo_app_contractor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` datetime NOT NULL,
  `modified_on` datetime NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(254) NOT NULL,
  `contact_number` varchar(15) NOT NULL,
  `resume` varchar(100) NOT NULL,
  `bgv_report` varchar(100) DEFAULT NULL,
  `experience_year` int(11) NOT NULL,
  `experience_month` int(11) NOT NULL,
  `experience_day` int(11) NOT NULL,
  `current_experience` varchar(100) DEFAULT NULL,
  `joining_date` date NOT NULL,
  `wd_experience` int(11) NOT NULL,
  `rate` decimal(15,2) NOT NULL,
  `comments` longtext,
  `status` tinyint(1) NOT NULL,
  `status_effective_from` date DEFAULT NULL,
  `status_comments` longtext,
  `status_attachment` varchar(100) DEFAULT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `experience_slab_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `hiring_manager_id` int(11) NOT NULL,
  `po_id` int(11) NOT NULL,
  `reporting_manager_id` int(11) NOT NULL,
  `vendor_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `vmo_app_contractor_created_by_id_e3fd8818_fk_auth_user_id` (`created_by_id`),
  KEY `vmo_app_contractor_experience_slab_id_45d6cbd4_fk_vmo_app_e` (`experience_slab_id`),
  KEY `vmo_app_contractor_group_id_2769b582_fk_vmo_app_group_id` (`group_id`),
  KEY `vmo_app_contractor_hiring_manager_id_e4eb2d76_fk_vmo_app_h` (`hiring_manager_id`),
  KEY `vmo_app_contractor_po_id_6f45c192_fk_vmo_app_purchaseorder_id` (`po_id`),
  KEY `vmo_app_contractor_reporting_manager_id_fd9fc71c_fk_vmo_app_h` (`reporting_manager_id`),
  KEY `vmo_app_contractor_vendor_id_6db71fa0_fk_vmo_app_vendor_id` (`vendor_id`),
  CONSTRAINT `vmo_app_contractor_vendor_id_6db71fa0_fk_vmo_app_vendor_id` FOREIGN KEY (`vendor_id`) REFERENCES `vmo_app_vendor` (`id`),
  CONSTRAINT `vmo_app_contractor_created_by_id_e3fd8818_fk_auth_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `vmo_app_contractor_experience_slab_id_45d6cbd4_fk_vmo_app_e` FOREIGN KEY (`experience_slab_id`) REFERENCES `vmo_app_experienceslab` (`id`),
  CONSTRAINT `vmo_app_contractor_group_id_2769b582_fk_vmo_app_group_id` FOREIGN KEY (`group_id`) REFERENCES `vmo_app_group` (`id`),
  CONSTRAINT `vmo_app_contractor_hiring_manager_id_e4eb2d76_fk_vmo_app_h` FOREIGN KEY (`hiring_manager_id`) REFERENCES `vmo_app_hiringmanager` (`id`),
  CONSTRAINT `vmo_app_contractor_po_id_6f45c192_fk_vmo_app_purchaseorder_id` FOREIGN KEY (`po_id`) REFERENCES `vmo_app_purchaseorder` (`id`),
  CONSTRAINT `vmo_app_contractor_reporting_manager_id_fd9fc71c_fk_vmo_app_h` FOREIGN KEY (`reporting_manager_id`) REFERENCES `vmo_app_hiringmanager` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_contractor`
--

INSERT INTO `vmo_app_contractor` VALUES (1,'2019-12-31 11:34:03','2019-12-31 11:34:03','Adheeth','adheeth@brisa-tech.com','999999999','resumes/linux_commands.docx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,1000000.00,'',1,NULL,'','',1,1,1,2,6,2,1),(2,'2019-12-31 11:34:45','2019-12-31 11:34:45','Sudarshan','sudarshank@brisa-tech.com','999999999','resumes/linux_commands_cQSbJ6v.docx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,1000000.00,'',1,NULL,'','',1,1,1,2,10,2,1),(3,'2019-12-31 11:35:31','2019-12-31 11:35:31','Yassaswini AY','yasaswiniay@brisa-tech.com','9663094686','resumes/interns_competency_technologies.xlsx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,100000.00,'',1,NULL,'','',1,1,1,2,9,2,1),(4,'2019-12-31 11:36:07','2019-12-31 11:36:07','Rackesha','rakesh@brisa-tech.com','9663094686','resumes/linux_commands_leDSXiN.docx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,100000.00,'',1,NULL,'','',1,1,1,2,8,2,1),(5,'2019-12-31 11:36:47','2019-12-31 11:36:47','Srujan Rao','srujan@brisa-tech.com','999999999','resumes/cal.py','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,100000.00,'',1,NULL,'','',1,1,1,2,7,2,1),(6,'2019-12-31 11:37:21','2019-12-31 11:37:21','Kavitha Mehra','kavita@brisa-tech.com','999999999','resumes/interns_competency_technologies_Xw8Dp7B.xlsx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,100000.00,'',1,NULL,'','',1,1,1,2,7,2,1),(7,'2019-12-31 11:38:06','2019-12-31 11:38:06','Jyothi','jyothi@dktech.com','999999999','resumes/linux_commands_cuJkKam.docx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,100000.00,'',1,NULL,'','',1,1,1,2,19,2,2),(8,'2019-12-31 11:38:44','2019-12-31 11:38:44','Mamatha','mamatha@dktech.com','999999999','resumes/interns_competency_technologies_AvA0GHd.xlsx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,10000.00,'',1,NULL,'','',1,2,1,2,19,2,2),(9,'2019-12-31 11:39:32','2019-12-31 11:39:32','Revathi','revathi@dktech.com','999999999','resumes/linux_commands_2zgTrWL.docx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,100000.00,'',1,NULL,'','',1,1,1,2,18,2,2),(10,'2019-12-31 11:40:05','2019-12-31 11:40:05','Sharon','sharon@dktech.com','999999999','resumes/linux_commands_ZG1Y8fV.docx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,100000.00,'',1,NULL,'','',1,1,1,2,17,2,2),(11,'2019-12-31 11:41:09','2019-12-31 11:41:09','Shazia','shazia@dktech.com','999999999','resumes/linux_commands_GPfHbV0.docx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,1000000.00,'',1,NULL,'','',1,1,1,2,16,2,2),(12,'2019-12-31 11:45:20','2019-12-31 11:45:20','Dheena','dheena@mctech.com','999999999','resumes/piq.docx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,100000.00,'',1,NULL,'','',1,1,1,2,15,2,4),(13,'2019-12-31 11:46:04','2019-12-31 11:46:04','Ashriya','arshiya@mctech.com','8888888888','resumes/linux_commands_VU8VhKQ.docx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,100000.00,'',1,NULL,'','',1,1,1,2,24,2,4),(14,'2019-12-31 11:46:40','2019-12-31 11:46:40','Jasmitha','jasmistha@mctech.com','8888888888','resumes/linux_commands_vGuDF2u.docx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,100000.00,'',1,NULL,'','',1,1,1,2,23,2,4),(15,'2019-12-31 11:47:17','2019-12-31 11:47:17','Karthika','karthika@mctech.com','8888888888','resumes/interns_competency_technologies_SSrK6IK.xlsx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,1000000.00,'',1,NULL,'','',1,1,1,2,22,2,4),(16,'2019-12-31 11:48:05','2019-12-31 11:48:05','Kasturi','kathuri@vttech.com','77777777','resumes/linux_commands_MTf0V2k.docx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,100000.00,'',1,NULL,'','',1,1,1,2,5,2,3),(17,'2019-12-31 11:48:40','2019-12-31 11:48:40','Soundarya','soundarya@vttech.com','8888888888','resumes/linux_commands_u08xuTr.docx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,1000000.00,'',1,NULL,'','',1,1,1,2,4,2,3),(18,'2019-12-31 11:49:14','2019-12-31 11:49:14','Samantha','samantha@vttech.com','77777777','resumes/linux_commands_PJzeUQ1.docx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,10000.00,'',1,NULL,'','',1,1,1,2,3,2,3),(19,'2019-12-31 11:49:44','2019-12-31 11:49:44','Rohan','rohan@vttech.com','77777777','resumes/linux_commands_IXcHTLs.docx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,100000.00,'',1,NULL,'','',1,1,1,2,2,2,3),(20,'2019-12-31 11:50:24','2019-12-31 11:50:24','Likhita','likitha@vttech.com','1231231233','resumes/linux_commands_xMmAAtQ.docx','',0,0,0,'0 years 0 months 0 days','2019-12-31',0,1889898.00,'',1,NULL,'','',1,1,1,2,1,2,3);

--
-- Table structure for table `vmo_app_contractor_qualification_certificates`
--

CREATE TABLE `vmo_app_contractor_qualification_certificates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contractor_id` int(11) NOT NULL,
  `qualificationcertificates_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vmo_app_contractor_quali_contractor_id_qualificat_a66432b1_uniq` (`contractor_id`,`qualificationcertificates_id`),
  KEY `vmo_app_contractor_q_qualificationcertifi_cb6141a5_fk_vmo_app_q` (`qualificationcertificates_id`),
  CONSTRAINT `vmo_app_contractor_q_qualificationcertifi_cb6141a5_fk_vmo_app_q` FOREIGN KEY (`qualificationcertificates_id`) REFERENCES `vmo_app_qualificationcertificates` (`id`),
  CONSTRAINT `vmo_app_contractor_q_contractor_id_a8c0a51f_fk_vmo_app_c` FOREIGN KEY (`contractor_id`) REFERENCES `vmo_app_contractor` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_contractor_qualification_certificates`
--


--
-- Table structure for table `vmo_app_experienceslab`
--

CREATE TABLE `vmo_app_experienceslab` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` datetime NOT NULL,
  `modified_on` datetime NOT NULL,
  `slab` varchar(15) NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vmo_app_experienceslab_created_by_id_3a9edb4c_fk_auth_user_id` (`created_by_id`),
  CONSTRAINT `vmo_app_experienceslab_created_by_id_3a9edb4c_fk_auth_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_experienceslab`
--

INSERT INTO `vmo_app_experienceslab` VALUES (1,'2019-12-31 11:04:32','2019-12-31 11:04:32','1-2',1),(2,'2019-12-31 11:04:38','2019-12-31 11:04:38','2-5',1),(3,'2019-12-31 11:04:44','2019-12-31 11:04:44','5-8',1),(4,'2019-12-31 11:04:51','2019-12-31 11:04:51','8-10',1),(5,'2019-12-31 11:04:56','2019-12-31 11:04:56','10+',1);

--
-- Table structure for table `vmo_app_group`
--

CREATE TABLE `vmo_app_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_group`
--

INSERT INTO `vmo_app_group` VALUES (1,'WDG1');

--
-- Table structure for table `vmo_app_hiringmanager`
--

CREATE TABLE `vmo_app_hiringmanager` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` datetime NOT NULL,
  `modified_on` datetime NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(254) NOT NULL,
  `contact_number` varchar(15) NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vmo_app_hiringmanager_created_by_id_939be9de_fk_auth_user_id` (`created_by_id`),
  CONSTRAINT `vmo_app_hiringmanager_created_by_id_939be9de_fk_auth_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_hiringmanager`
--

INSERT INTO `vmo_app_hiringmanager` VALUES (2,'2019-12-31 11:15:54','2019-12-31 11:15:54','Ranganath','ranganath@wd.com','999999999',1),(3,'2019-12-31 11:16:19','2019-12-31 11:16:19','Arvind','arvind@wd.com','8888888888',1);

--
-- Table structure for table `vmo_app_holidays`
--

CREATE TABLE `vmo_app_holidays` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` datetime NOT NULL,
  `modified_on` datetime NOT NULL,
  `day` date NOT NULL,
  `comments` longtext,
  `created_by_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `day` (`day`),
  KEY `vmo_app_holidays_created_by_id_9b950f8a_fk_auth_user_id` (`created_by_id`),
  CONSTRAINT `vmo_app_holidays_created_by_id_9b950f8a_fk_auth_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_holidays`
--


--
-- Table structure for table `vmo_app_leaves`
--

CREATE TABLE `vmo_app_leaves` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` datetime NOT NULL,
  `modified_on` datetime NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `approve_status` smallint(5) unsigned NOT NULL,
  `comments` longtext,
  `approved_on` datetime DEFAULT NULL,
  `approved_by_id` int(11) DEFAULT NULL,
  `contractor_id` int(11) NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `leave_reason` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vmo_app_leaves_approved_by_id_c6799330_fk_auth_user_id` (`approved_by_id`),
  KEY `vmo_app_leaves_contractor_id_33517c54_fk_vmo_app_contractor_id` (`contractor_id`),
  KEY `vmo_app_leaves_created_by_id_f79d172c_fk_auth_user_id` (`created_by_id`),
  CONSTRAINT `vmo_app_leaves_approved_by_id_c6799330_fk_auth_user_id` FOREIGN KEY (`approved_by_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `vmo_app_leaves_contractor_id_33517c54_fk_vmo_app_contractor_id` FOREIGN KEY (`contractor_id`) REFERENCES `vmo_app_contractor` (`id`),
  CONSTRAINT `vmo_app_leaves_created_by_id_f79d172c_fk_auth_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_leaves`
--

INSERT INTO `vmo_app_leaves` VALUES (1,'2019-12-31 11:54:40','2020-10-01 03:26:17','2019-12-31','2019-12-31',2,'fdasfc','2020-10-01 03:26:17',4,1,NULL,NULL),(2,'2020-10-01 03:29:24','2020-10-01 03:30:04','2020-10-03','2020-10-03',3,'Nt Approved','2020-10-01 03:30:04',4,1,NULL,'Training');

--
-- Table structure for table `vmo_app_loggedtimehistory`
--

CREATE TABLE `vmo_app_loggedtimehistory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `start_time` time NOT NULL,
  `end_time` time DEFAULT NULL,
  `new_tag` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_loggedtimehistory`
--

INSERT INTO `vmo_app_loggedtimehistory` VALUES (1,'10:02:12','10:31:58',0),(2,'10:14:53','12:30:11',1),(3,'10:46:11','11:13:13',0),(4,'11:17:11','11:25:26',0),(5,'11:33:11','11:36:26',0),(6,'11:44:11','11:44:46',0),(7,'12:04:11','12:04:49',0),(8,'12:30:11','12:30:11',1);

--
-- Table structure for table `vmo_app_menu`
--

CREATE TABLE `vmo_app_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
  `url` varchar(25) NOT NULL,
  `order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_menu`
--

INSERT INTO `vmo_app_menu` VALUES (1,'Dashboard','dashboard',1),(2,'Vendors','vendors',2),(3,'Contractors','contractors',3),(4,'LMS','lms',4);

--
-- Table structure for table `vmo_app_monthworkinghours`
--

CREATE TABLE `vmo_app_monthworkinghours` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `month` smallint(5) unsigned NOT NULL,
  `year` smallint(5) unsigned NOT NULL,
  `working_hours` smallint(5) unsigned NOT NULL,
  `working_days` smallint(5) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vmo_app_monthworkinghours_month_year_9299c220_uniq` (`month`,`year`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_monthworkinghours`
--

INSERT INTO `vmo_app_monthworkinghours` VALUES (1,12,2019,176,22),(2,1,2020,160,20);

--
-- Table structure for table `vmo_app_notification`
--

CREATE TABLE `vmo_app_notification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` longtext NOT NULL,
  `section` varchar(100) NOT NULL,
  `new_tag` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_notification`
--

INSERT INTO `vmo_app_notification` VALUES (1,'New Leave Application from Adheeth','Leaves',1),(2,'New Leave Application from Adheeth','Leaves',1);

--
-- Table structure for table `vmo_app_passwordresetcode`
--

CREATE TABLE `vmo_app_passwordresetcode` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `vmo_app_passwordresetcode_user_id_590b6ef1_fk_auth_user_id` (`user_id`),
  CONSTRAINT `vmo_app_passwordresetcode_user_id_590b6ef1_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_passwordresetcode`
--


--
-- Table structure for table `vmo_app_pocmanager`
--

CREATE TABLE `vmo_app_pocmanager` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` datetime NOT NULL,
  `modified_on` datetime NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(254) NOT NULL,
  `contact_number` varchar(15) NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vmo_app_pocmanager_created_by_id_25cd1345_fk_auth_user_id` (`created_by_id`),
  CONSTRAINT `vmo_app_pocmanager_created_by_id_25cd1345_fk_auth_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_pocmanager`
--

INSERT INTO `vmo_app_pocmanager` VALUES (1,'2019-12-31 11:17:45','2019-12-31 11:17:45','Kishore','kishore@brisa-tech.com','77777777',1),(2,'2019-12-31 11:18:07','2019-12-31 11:18:07','Manjunath','manjunath@brisa-tech.com','67678678',1);

--
-- Table structure for table `vmo_app_purchaseorder`
--

CREATE TABLE `vmo_app_purchaseorder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` datetime NOT NULL,
  `modified_on` datetime NOT NULL,
  `po_number` varchar(25) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `validity` smallint(5) unsigned NOT NULL,
  `po_value` int(11) NOT NULL,
  `department` varchar(50) NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `manager_id` int(11) NOT NULL,
  `vendor_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `vmo_app_purchaseorder_created_by_id_d5cbfd31_fk_auth_user_id` (`created_by_id`),
  KEY `vmo_app_purchaseorde_manager_id_1c1b7e16_fk_vmo_app_p` (`manager_id`),
  KEY `vmo_app_purchaseorder_vendor_id_7dc8309d_fk_vmo_app_vendor_id` (`vendor_id`),
  CONSTRAINT `vmo_app_purchaseorder_vendor_id_7dc8309d_fk_vmo_app_vendor_id` FOREIGN KEY (`vendor_id`) REFERENCES `vmo_app_vendor` (`id`),
  CONSTRAINT `vmo_app_purchaseorder_created_by_id_d5cbfd31_fk_auth_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `vmo_app_purchaseorde_manager_id_1c1b7e16_fk_vmo_app_p` FOREIGN KEY (`manager_id`) REFERENCES `vmo_app_pocmanager` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_purchaseorder`
--

INSERT INTO `vmo_app_purchaseorder` VALUES (1,'2019-12-31 11:20:48','2019-12-31 11:20:48','VT_IN5310-P005656','2019-10-01','2019-12-31',3,100000,'SW',1,1,3),(2,'2019-12-31 11:21:13','2019-12-31 11:21:13','VT_IN5310-P005454','2019-10-01','2019-12-31',3,100000,'SW',1,1,3),(3,'2019-12-31 11:21:44','2019-12-31 11:21:44','VT_IN5310-P005353','2019-10-01','2019-12-31',3,10000,'SW',1,1,3),(4,'2019-12-31 11:22:03','2019-12-31 11:22:03','VT_IN5310-P005252','2019-10-01','2019-12-31',3,100000,'SW',1,1,3),(5,'2019-12-31 11:22:22','2019-12-31 11:22:22','VT_IN5310-P005151','2019-10-01','2019-12-31',3,100000,'SW',1,1,3),(6,'2019-12-31 11:22:41','2019-12-31 11:24:47','IN5310-P005843','2019-10-01','2019-12-31',3,100000,'SW',1,1,1),(7,'2019-12-31 11:22:59','2019-12-31 11:24:36','IN5310-P005888','2019-10-01','2019-12-31',3,100000,'SW',1,1,1),(8,'2019-12-31 11:24:22','2019-12-31 11:24:22','IN5310-P005912','2019-10-01','2019-12-31',3,10000,'SW',1,1,1),(9,'2019-12-31 11:25:23','2019-12-31 11:25:23','IN5310-P005913','2019-10-01','2019-12-31',3,100000,'SW',1,1,1),(10,'2019-12-31 11:25:46','2019-12-31 11:25:46','IN5310-P005914','2019-10-01','2019-12-31',3,100000,'SW',1,1,1),(11,'2019-12-31 11:26:07','2019-12-31 11:26:07','IN5310-P005963','2019-10-01','2019-12-31',3,100000,'SW',1,1,1),(12,'2019-12-31 11:26:26','2019-12-31 11:26:26','IN5310-P005960','2019-10-01','2019-12-31',3,100000,'SW',1,1,1),(13,'2019-12-31 11:26:54','2019-12-31 11:26:54','IN5310-P005958','2019-10-01','2019-12-31',3,100000,'SW',1,1,1),(14,'2019-12-31 11:27:17','2019-12-31 11:27:17','IN5310-P005925','2019-10-01','2019-12-31',3,100000,'SW',1,1,1),(15,'2019-12-31 11:27:44','2019-12-31 11:27:44','IN5310-P101050','2019-10-01','2019-12-31',3,100000,'SW',1,1,1),(16,'2019-12-31 11:28:33','2019-12-31 11:28:33','DK_IN5151-P008321','2019-10-01','2019-12-31',3,100000,'SW',1,1,2),(17,'2019-12-31 11:28:56','2019-12-31 11:28:56','DK_IN5151-P008123','2019-10-01','2019-12-31',3,100000,'SW',1,1,2),(18,'2019-12-31 11:29:15','2019-12-31 11:29:15','DK_IN5151-P008122','2019-10-01','2019-12-31',3,100000,'SW',1,1,2),(19,'2019-12-31 11:29:38','2019-12-31 11:29:38','DK_IN5151-P008011','2019-10-01','2019-12-31',3,100000,'SW',1,1,2),(20,'2019-12-31 11:30:00','2019-12-31 11:30:00','DK_IN5151-P008011','2019-10-01','2019-12-31',3,10000,'SW',1,1,2),(21,'2019-12-31 11:30:22','2019-12-31 11:30:22','MC5151-P101099','2019-10-01','2019-12-31',3,100000,'SW',1,1,4),(22,'2019-12-31 11:30:46','2019-12-31 11:30:46','MC5151-P101072','2019-10-01','2019-12-31',3,100000,'SW',1,1,4),(23,'2019-12-31 11:31:08','2019-12-31 11:31:08','MC5151-P101063','2019-10-01','2019-12-31',3,100000,'SW',1,1,4),(24,'2019-12-31 11:31:28','2019-12-31 11:31:28','MC5151-P101055','2019-10-01','2019-12-31',3,100000,'SW',1,1,4);

--
-- Table structure for table `vmo_app_qualificationcertificates`
--

CREATE TABLE `vmo_app_qualificationcertificates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `certificate` varchar(100) NOT NULL,
  `comments` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_qualificationcertificates`
--


--
-- Table structure for table `vmo_app_rolemenus`
--

CREATE TABLE `vmo_app_rolemenus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `vmo_app_rolemenus_role_id_c9023f01_fk_vmo_app_roles_id` (`role_id`),
  CONSTRAINT `vmo_app_rolemenus_role_id_c9023f01_fk_vmo_app_roles_id` FOREIGN KEY (`role_id`) REFERENCES `vmo_app_roles` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_rolemenus`
--

INSERT INTO `vmo_app_rolemenus` VALUES (1,1),(2,2),(3,3);

--
-- Table structure for table `vmo_app_rolemenus_menus`
--

CREATE TABLE `vmo_app_rolemenus_menus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rolemenus_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vmo_app_rolemenus_menus_rolemenus_id_menu_id_a6cbde91_uniq` (`rolemenus_id`,`menu_id`),
  KEY `vmo_app_rolemenus_menus_menu_id_d50f44de_fk_vmo_app_menu_id` (`menu_id`),
  CONSTRAINT `vmo_app_rolemenus_menus_menu_id_d50f44de_fk_vmo_app_menu_id` FOREIGN KEY (`menu_id`) REFERENCES `vmo_app_menu` (`id`),
  CONSTRAINT `vmo_app_rolemenus_me_rolemenus_id_43e5598b_fk_vmo_app_r` FOREIGN KEY (`rolemenus_id`) REFERENCES `vmo_app_rolemenus` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_rolemenus_menus`
--

INSERT INTO `vmo_app_rolemenus_menus` VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,2,1),(6,2,3),(7,2,4),(8,3,4);

--
-- Table structure for table `vmo_app_roles`
--

CREATE TABLE `vmo_app_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_roles`
--

INSERT INTO `vmo_app_roles` VALUES (1,'Admin'),(2,'Manager'),(3,'Contractor');

--
-- Table structure for table `vmo_app_setup`
--

CREATE TABLE `vmo_app_setup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` datetime NOT NULL,
  `modified_on` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vmo_app_setup_created_by_id_b568da08_fk_auth_user_id` (`created_by_id`),
  CONSTRAINT `vmo_app_setup_created_by_id_b568da08_fk_auth_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_setup`
--


--
-- Table structure for table `vmo_app_timesheet`
--

CREATE TABLE `vmo_app_timesheet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timesheet` varchar(100) DEFAULT NULL,
  `month` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `total_time` int(11) NOT NULL,
  `approved_status` tinyint(1) NOT NULL,
  `approved_timestamp` datetime DEFAULT NULL,
  `approved_by_id` int(11) DEFAULT NULL,
  `contractor_id` int(11) NOT NULL,
  `comments` longtext,
  PRIMARY KEY (`id`),
  KEY `vmo_app_timesheet_approved_by_id_1313646e_fk_auth_user_id` (`approved_by_id`),
  KEY `vmo_app_timesheet_contractor_id_024dd724_fk_vmo_app_c` (`contractor_id`),
  CONSTRAINT `vmo_app_timesheet_approved_by_id_1313646e_fk_auth_user_id` FOREIGN KEY (`approved_by_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `vmo_app_timesheet_contractor_id_024dd724_fk_vmo_app_c` FOREIGN KEY (`contractor_id`) REFERENCES `vmo_app_contractor` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_timesheet`
--

INSERT INTO `vmo_app_timesheet` VALUES (1,'',1,2020,135,0,NULL,NULL,4,NULL),(2,'',1,2020,69,0,NULL,NULL,3,NULL),(4,'',12,2019,0,0,NULL,NULL,1,NULL);

--
-- Table structure for table `vmo_app_timesheet_history`
--

CREATE TABLE `vmo_app_timesheet_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timesheet_id` int(11) NOT NULL,
  `timesheethistory_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vmo_app_timesheet_histor_timesheet_id_timesheethi_70fec03b_uniq` (`timesheet_id`,`timesheethistory_id`),
  KEY `vmo_app_timesheet_hi_timesheethistory_id_400a4ddb_fk_vmo_app_t` (`timesheethistory_id`),
  CONSTRAINT `vmo_app_timesheet_hi_timesheethistory_id_400a4ddb_fk_vmo_app_t` FOREIGN KEY (`timesheethistory_id`) REFERENCES `vmo_app_timesheethistory` (`id`),
  CONSTRAINT `vmo_app_timesheet_hi_timesheet_id_bcc6fed6_fk_vmo_app_t` FOREIGN KEY (`timesheet_id`) REFERENCES `vmo_app_timesheet` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_timesheet_history`
--

INSERT INTO `vmo_app_timesheet_history` VALUES (1,1,1),(2,2,2),(4,4,3);

--
-- Table structure for table `vmo_app_timesheethistory`
--

CREATE TABLE `vmo_app_timesheethistory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `intime` time DEFAULT NULL,
  `outtime` time DEFAULT NULL,
  `total_logged_time` int(11) NOT NULL,
  `remarks` longtext,
  `leave_tag` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_timesheethistory`
--

INSERT INTO `vmo_app_timesheethistory` VALUES (1,'2020-01-07','10:15:00','12:30:11',135,'',0),(2,'2020-01-07','10:02:12','12:30:11',69,NULL,0),(3,'2019-12-31',NULL,NULL,0,'Pre Approved Leave',1);

--
-- Table structure for table `vmo_app_timesheethistory_logged_time_history`
--

CREATE TABLE `vmo_app_timesheethistory_logged_time_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timesheethistory_id` int(11) NOT NULL,
  `loggedtimehistory_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vmo_app_timesheethistory_timesheethistory_id_logg_c575c7d6_uniq` (`timesheethistory_id`,`loggedtimehistory_id`),
  KEY `vmo_app_timesheethis_loggedtimehistory_id_043427b8_fk_vmo_app_l` (`loggedtimehistory_id`),
  CONSTRAINT `vmo_app_timesheethis_loggedtimehistory_id_043427b8_fk_vmo_app_l` FOREIGN KEY (`loggedtimehistory_id`) REFERENCES `vmo_app_loggedtimehistory` (`id`),
  CONSTRAINT `vmo_app_timesheethis_timesheethistory_id_a1c301ac_fk_vmo_app_t` FOREIGN KEY (`timesheethistory_id`) REFERENCES `vmo_app_timesheethistory` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_timesheethistory_logged_time_history`
--

INSERT INTO `vmo_app_timesheethistory_logged_time_history` VALUES (2,1,2),(1,2,1),(3,2,3),(4,2,4),(5,2,5),(6,2,6),(7,2,7),(8,2,8);

--
-- Table structure for table `vmo_app_userprofile`
--

CREATE TABLE `vmo_app_userprofile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` datetime NOT NULL,
  `modified_on` datetime NOT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `vmo_app_userprofile_created_by_id_e9afb780_fk_auth_user_id` (`created_by_id`),
  KEY `vmo_app_userprofile_role_id_e26a6740_fk_vmo_app_roles_id` (`role_id`),
  KEY `vmo_app_userprofile_user_id_22277c80_fk_auth_user_id` (`user_id`),
  CONSTRAINT `vmo_app_userprofile_user_id_22277c80_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `vmo_app_userprofile_created_by_id_e9afb780_fk_auth_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `vmo_app_userprofile_role_id_e26a6740_fk_vmo_app_roles_id` FOREIGN KEY (`role_id`) REFERENCES `vmo_app_roles` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_userprofile`
--

INSERT INTO `vmo_app_userprofile` VALUES (2,'2019-12-31 11:15:54','2019-12-31 11:15:54',NULL,2,3),(3,'2019-12-31 11:16:20','2019-12-31 11:16:20',NULL,2,4),(4,'2019-12-31 11:34:03','2019-12-31 11:34:03',NULL,3,5),(5,'2019-12-31 11:34:45','2019-12-31 11:34:45',NULL,3,6),(6,'2019-12-31 11:35:31','2019-12-31 11:35:31',NULL,3,7),(7,'2019-12-31 11:36:07','2019-12-31 11:36:07',NULL,3,8),(8,'2019-12-31 11:36:47','2019-12-31 11:36:47',NULL,3,9),(9,'2019-12-31 11:37:21','2019-12-31 11:37:21',NULL,3,10),(10,'2019-12-31 11:38:06','2019-12-31 11:38:06',NULL,3,11),(11,'2019-12-31 11:38:44','2019-12-31 11:38:44',NULL,3,12),(12,'2019-12-31 11:39:32','2019-12-31 11:39:32',NULL,3,13),(13,'2019-12-31 11:40:05','2019-12-31 11:40:05',NULL,3,14),(14,'2019-12-31 11:41:09','2019-12-31 11:41:09',NULL,3,15),(15,'2019-12-31 11:45:20','2019-12-31 11:45:20',NULL,3,16),(16,'2019-12-31 11:46:05','2019-12-31 11:46:05',NULL,3,17),(17,'2019-12-31 11:46:40','2019-12-31 11:46:40',NULL,3,18),(18,'2019-12-31 11:47:17','2019-12-31 11:47:17',NULL,3,19),(19,'2019-12-31 11:48:05','2019-12-31 11:48:05',NULL,3,20),(20,'2019-12-31 11:48:41','2019-12-31 11:48:41',NULL,3,21),(21,'2019-12-31 11:49:14','2019-12-31 11:49:14',NULL,3,22),(22,'2019-12-31 11:49:44','2019-12-31 11:49:44',NULL,3,23),(23,'2019-12-31 11:50:24','2019-12-31 11:50:24',NULL,3,24);

--
-- Table structure for table `vmo_app_vendor`
--

CREATE TABLE `vmo_app_vendor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_on` datetime NOT NULL,
  `modified_on` datetime NOT NULL,
  `name` varchar(100) NOT NULL,
  `address` longtext NOT NULL,
  `msa_start_date` date DEFAULT NULL,
  `msa_end_date` date DEFAULT NULL,
  `nda_start_date` date DEFAULT NULL,
  `nda_end_date` date DEFAULT NULL,
  `created_by_id` int(11) DEFAULT NULL,
  `poc_account_manager_id` int(11) NOT NULL,
  `poc_manager_id` int(11) NOT NULL,
  `poc_secondary_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `vmo_app_vendor_created_by_id_782c190e_fk_auth_user_id` (`created_by_id`),
  KEY `vmo_app_vendor_poc_account_manager__7d53ade0_fk_vmo_app_p` (`poc_account_manager_id`),
  KEY `vmo_app_vendor_poc_manager_id_4868b175_fk_vmo_app_pocmanager_id` (`poc_manager_id`),
  KEY `vmo_app_vendor_poc_secondary_id_32aae50b_fk_vmo_app_p` (`poc_secondary_id`),
  CONSTRAINT `vmo_app_vendor_poc_secondary_id_32aae50b_fk_vmo_app_p` FOREIGN KEY (`poc_secondary_id`) REFERENCES `vmo_app_pocmanager` (`id`),
  CONSTRAINT `vmo_app_vendor_created_by_id_782c190e_fk_auth_user_id` FOREIGN KEY (`created_by_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `vmo_app_vendor_poc_account_manager__7d53ade0_fk_vmo_app_p` FOREIGN KEY (`poc_account_manager_id`) REFERENCES `vmo_app_pocmanager` (`id`),
  CONSTRAINT `vmo_app_vendor_poc_manager_id_4868b175_fk_vmo_app_pocmanager_id` FOREIGN KEY (`poc_manager_id`) REFERENCES `vmo_app_pocmanager` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_vendor`
--

INSERT INTO `vmo_app_vendor` VALUES (1,'2019-12-31 11:19:10','2019-12-31 11:19:10','Brisa Technologies','no 70,\r\nhsr layout,\r\nbengaluru',NULL,NULL,NULL,NULL,1,1,1,1),(2,'2019-12-31 11:19:34','2019-12-31 11:19:34','DK Technologies India Pvt Ltd','Bengaluru',NULL,NULL,NULL,NULL,1,1,1,1),(3,'2019-12-31 11:19:47','2019-12-31 11:19:47','VT Tech India Pvt Ltd','Bengaluru',NULL,NULL,NULL,NULL,1,1,1,1),(4,'2019-12-31 11:20:01','2019-12-31 11:20:01','MC Technologies Pvt Ltd','Bengaluru',NULL,NULL,NULL,NULL,1,1,1,1);

--
-- Table structure for table `vmo_app_vendor_certificates`
--

CREATE TABLE `vmo_app_vendor_certificates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `vendor_id` int(11) NOT NULL,
  `certificate_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vmo_app_vendor_certifica_vendor_id_certificate_id_71b76c0f_uniq` (`vendor_id`,`certificate_id`),
  KEY `vmo_app_vendor_certi_certificate_id_96cb90e7_fk_vmo_app_c` (`certificate_id`),
  CONSTRAINT `vmo_app_vendor_certi_certificate_id_96cb90e7_fk_vmo_app_c` FOREIGN KEY (`certificate_id`) REFERENCES `vmo_app_certificate` (`id`),
  CONSTRAINT `vmo_app_vendor_certi_vendor_id_85efba4e_fk_vmo_app_v` FOREIGN KEY (`vendor_id`) REFERENCES `vmo_app_vendor` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vmo_app_vendor_certificates`
--



