BBnepal-Accounts/blackb_bbnepal_hr.sql

-- MySQL dump 10.13  Distrib 8.0.31, for Win64 (x86_64)
--
-- Host: localhost    Database: blackb_bbnepal_hr
-- ------------------------------------------------------
-- Server version	8.0.31

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

--
-- Table structure for table `bt_admin`
--

DROP TABLE IF EXISTS `bt_admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bt_admin` (
  `id` int NOT NULL AUTO_INCREMENT,
  `admin_role_ids` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `admin_name` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `status` varchar(64) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Active',
  `can_delete` varchar(16) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Yes',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bt_admin`
--

LOCK TABLES `bt_admin` WRITE;
/*!40000 ALTER TABLE `bt_admin` DISABLE KEYS */;
INSERT INTO `bt_admin` VALUES (1,'1','HR Admin','hr@demo.com','0e7517141fb53f21ee439b355b5a1d0a','Active','No','2021-11-10 04:00:00',NULL),(2,'1','Sanjeet','sanjeet.mandal7@gmail.com','0e7517141fb53f21ee439b355b5a1d0a','Active','Yes','2022-05-08 23:21:22',NULL);
/*!40000 ALTER TABLE `bt_admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bt_admin_menu`
--

DROP TABLE IF EXISTS `bt_admin_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bt_admin_menu` (
  `id` int NOT NULL AUTO_INCREMENT,
  `menu_name` varchar(256) NOT NULL,
  `parent_id` int NOT NULL DEFAULT '0',
  `order_number` int NOT NULL,
  `inactive_icon` varchar(256) NOT NULL,
  `active_icon` varchar(256) NOT NULL,
  `page_link` varchar(256) NOT NULL,
  `status` varchar(64) NOT NULL DEFAULT 'Active',
  `created_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bt_admin_menu`
--

LOCK TABLES `bt_admin_menu` WRITE;
/*!40000 ALTER TABLE `bt_admin_menu` DISABLE KEYS */;
INSERT INTO `bt_admin_menu` VALUES (1,'Dashboard',0,1,'dashboard1.png','dashboard2.png','dashboard','Active','2021-11-12 13:43:57'),(2,'Designation',0,2,'designation1.png','designation2.png','designation','Active','2021-11-12 00:00:16'),(3,'Department',0,3,'department1.png','department2.png','department','Active','2021-11-12 00:00:38'),(4,'Staffs',0,4,'subadmin1.png','subadmin2.png','staffs','Active','2021-11-12 07:00:00'),(5,'Attendance',0,5,'attendance1.png','attendance2.png','attendance','Active','2021-11-12 00:00:00'),(6,'Authorization',0,6,'authorization1.png','authorization2.png','#','Active','2021-11-12 00:00:00'),(7,'Roles',6,1,'','','roles','Active','2021-11-12 00:17:00'),(8,'Users',6,2,'','','users','Active','2021-11-12 00:00:00'),(9,'Payroll',0,7,'pay-roll1.png','pay-roll2.png','pay-roll','Active','2021-12-15 02:08:10'),(10,'Settings',0,8,'settings.png','settings.png','#','Active','2021-12-15 02:08:10'),(11,'Staff Roles',10,1,'','','staff-roles','Active','2021-12-15 02:08:10');
/*!40000 ALTER TABLE `bt_admin_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bt_admin_role_permissions`
--

DROP TABLE IF EXISTS `bt_admin_role_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bt_admin_role_permissions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `admin_role_ids` int NOT NULL,
  `menu_ids` varchar(1024) NOT NULL,
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bt_admin_role_permissions`
--

LOCK TABLES `bt_admin_role_permissions` WRITE;
/*!40000 ALTER TABLE `bt_admin_role_permissions` DISABLE KEYS */;
INSERT INTO `bt_admin_role_permissions` VALUES (1,1,'1,2,3,4,5,6,9,10','2021-11-12 00:00:00',NULL),(2,2,'1,6','2021-11-12 00:00:00',NULL),(3,4,'1,2,6','2021-11-14 15:28:53',NULL),(4,5,'2','2021-12-17 02:10:46',NULL),(5,6,'2,3,4,5','2021-12-17 02:35:21',NULL),(6,7,'4','2021-12-17 02:48:15',NULL);
/*!40000 ALTER TABLE `bt_admin_role_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bt_admin_roles`
--

DROP TABLE IF EXISTS `bt_admin_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bt_admin_roles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `role_name` varchar(64) NOT NULL,
  `role_desc` varchar(512) DEFAULT NULL,
  `status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  `can_delete` varchar(64) NOT NULL DEFAULT 'Yes',
  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bt_admin_roles`
--

LOCK TABLES `bt_admin_roles` WRITE;
/*!40000 ALTER TABLE `bt_admin_roles` DISABLE KEYS */;
INSERT INTO `bt_admin_roles` VALUES (1,'Library Super Admin','','Active','No','2021-11-10 06:00:00',NULL),(2,'Book Manager','bm desc here','Active','Yes','2021-11-12 09:00:00',NULL);
/*!40000 ALTER TABLE `bt_admin_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bt_buses`
--

DROP TABLE IF EXISTS `bt_buses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bt_buses` (
  `id` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bt_buses`
--

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

--
-- Table structure for table `bt_drivers`
--

DROP TABLE IF EXISTS `bt_drivers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `bt_drivers` (
  `id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bt_drivers`
--

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

--
-- Table structure for table `hr_department`
--

DROP TABLE IF EXISTS `hr_department`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hr_department` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT 'yes',
  `created_on` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT 'CURRENT_TIMESTAMP',
  `modified_on` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT 'CURRENT_TIMESTAMP',
  PRIMARY KEY (`id`),
  UNIQUE KEY `title_UNIQUE` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_department`
--

LOCK TABLES `hr_department` WRITE;
/*!40000 ALTER TABLE `hr_department` DISABLE KEYS */;
INSERT INTO `hr_department` VALUES (1,'Primary','no','2079-11-17 14:37:19','2080-01-11 19:00:21'),(2,'Secondary','yes','2079-11-17 17:06:17','2079-11-19 10:52:32'),(3,'+2','yes','2079-11-17 20:12:08','2079-11-17 20:12:08'),(4,'Lower Secondary','yes','2079-12-21 15:37:40','2079-12-21 15:39:06');
/*!40000 ALTER TABLE `hr_department` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hr_designation`
--

DROP TABLE IF EXISTS `hr_designation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `hr_designation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT 'yes',
  `created_on` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT 'CURRENT_TIMESTAMP',
  `modified_on` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT 'CURRENT_TIMESTAMP',
  PRIMARY KEY (`id`),
  UNIQUE KEY `title_UNIQUE` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hr_designation`
--

LOCK TABLES `hr_designation` WRITE;
/*!40000 ALTER TABLE `hr_designation` DISABLE KEYS */;
INSERT INTO `hr_designation` VALUES (1,'Principal','yes','2079-11-18 11:08:59','2079-11-18 11:09:24'),(2,'Vice Principal','yes','2079-11-18 11:09:07','2079-12-12 17:15:34'),(3,'Co-ordinator','yes','2079-12-12 17:17:20','2079-12-12 17:18:16');
/*!40000 ALTER TABLE `hr_designation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staff_roles`
--

DROP TABLE IF EXISTS `staff_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `staff_roles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT 'yes',
  `created_on` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_on` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `title_UNIQUE` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff_roles`
--

LOCK TABLES `staff_roles` WRITE;
/*!40000 ALTER TABLE `staff_roles` DISABLE KEYS */;
INSERT INTO `staff_roles` VALUES (1,'Teacher','yes','2079-11-19 10:52:38','2079-11-19 10:52:38'),(2,'Driver','yes','2079-11-19 13:19:17','2079-11-19 13:21:34'),(3,'IT Head','yes','2079-11-19 13:23:04','2079-12-12 17:28:05'),(4,'New','yes','2079-12-12 17:28:11','2079-12-12 17:28:11'),(5,'Abcd','yes','2079-12-12 17:28:18','2079-12-12 17:28:18');
/*!40000 ALTER TABLE `staff_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staffs`
--

DROP TABLE IF EXISTS `staffs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `staffs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `staffId` varchar(45) NOT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `dob` varchar(50) DEFAULT NULL,
  `role` int DEFAULT NULL,
  `department` int DEFAULT '0',
  `designations` int DEFAULT '0',
  `father_name` varchar(100) DEFAULT NULL,
  `mother_name` varchar(100) DEFAULT NULL,
  `email` varchar(75) DEFAULT NULL,
  `mobile` varchar(15) DEFAULT NULL,
  `martial_status` varchar(10) DEFAULT NULL,
  `emergency_number` varchar(15) DEFAULT NULL,
  `document_type` varchar(50) DEFAULT NULL,
  `document_photo_1` text,
  `document_id` varchar(40) DEFAULT NULL,
  `address` text,
  `province` int DEFAULT '7',
  `country` varchar(100) DEFAULT 'Nepal',
  `qualification` text,
  `experience` text,
  `date_of_joining` varchar(25) DEFAULT NULL,
  `epf_no` varchar(100) DEFAULT NULL,
  `pan` varchar(45) DEFAULT NULL,
  `basic_salary` double(9,2) DEFAULT NULL,
  `contract_type` varchar(15) DEFAULT NULL,
  `bank_account_name` text,
  `bank_account_number` text,
  `bank_name` text,
  `branch_name` text,
  `resume` text,
  `joining_letter` text,
  `other_document` text,
  `photo` text,
  `is_active` varchar(3) NOT NULL DEFAULT 'yes',
  `created_on` varchar(30) DEFAULT NULL,
  `modified_on` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `staffId_UNIQUE` (`staffId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staffs`
--

LOCK TABLES `staffs` WRITE;
/*!40000 ALTER TABLE `staffs` DISABLE KEYS */;
INSERT INTO `staffs` VALUES (1,'Yogesh Kamti','BLBDT2079112501','male','2052-04-10',1,2,1,'','','admin@demo.com','9865650872','unmarried','','driving_licensce','BLBDT2079112501_doc1.png','ewfdsxcd','Dhangadhi',1,'Nepal','','','2079-11-25','','',30000.00,'permanent','','','','','BLBDT2079112501_resume.pdf','BLBDT2079112501_joining_letter.pdf','BLBDT2079112501_doc2.pdf','BLBDT2079112501_profile1.png','yes','2079-11-25 16:30:34','2079-11-29 16:51:15'),(2,'Lalit Nath','BLBDT2079112902','male','2056-02-01',1,3,0,'','','lalitnath1999@gmail.com','9814698278','unmarried','','citizenship','','6789698758','Dhangadhi',7,'Nepal','','','2079-11-29','EPF1','PAN10001',20000.00,'permanent','','','','','','','','BLBDT2079112902_profile.png','yes','2079-11-29 13:31:16','2079-11-29 16:51:50');
/*!40000 ALTER TABLE `staffs` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2024-03-01 10:59:16