BBnepal-Accounts/blackb_bbnepal_hr.sql

335 lines
14 KiB
MySQL
Raw Permalink Normal View History

2024-07-10 12:43:19 +00:00
-- 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