/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.19-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: padanglawas_sijala
-- ------------------------------------------------------
-- Server version	10.11.19-MariaDB-ubu2404

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

--
-- Table structure for table `tbl_gaji_pokok`
--

DROP TABLE IF EXISTS `tbl_gaji_pokok`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_gaji_pokok` (
  `id_gaji_pokok` int(11) NOT NULL AUTO_INCREMENT,
  `golongan` varchar(5) DEFAULT NULL,
  `masa_kerja` int(11) DEFAULT NULL,
  `gaji_pokok` int(11) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`id_gaji_pokok`)
) ENGINE=InnoDB AUTO_INCREMENT=273 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_gaji_pokok`
--

LOCK TABLES `tbl_gaji_pokok` WRITE;
/*!40000 ALTER TABLE `tbl_gaji_pokok` DISABLE KEYS */;
INSERT INTO `tbl_gaji_pokok` VALUES
(1,'I/a',0,1685700,'2024-02-12 01:47:49',NULL),
(2,'I/a',2,1738800,'2024-02-12 01:47:49',NULL),
(3,'I/a',4,1793500,'2024-02-12 01:52:12',NULL),
(4,'I/a',6,1850000,'2024-02-12 01:53:47',NULL),
(5,'I/a',8,1908300,'2024-02-12 08:55:10',NULL),
(6,'I/a',10,1968400,'2024-02-12 08:56:36',NULL),
(7,'I/a',12,2030400,'2024-02-12 08:56:36',NULL),
(8,'I/a',14,2094300,'2024-02-12 08:57:36',NULL),
(9,'I/a',16,2160300,'2024-02-12 08:57:36',NULL),
(10,'I/a',18,2228300,'2024-02-12 08:59:08',NULL),
(11,'I/a',20,2298500,'2024-02-12 08:59:08',NULL),
(12,'I/a',22,2370900,'2024-02-12 08:59:08',NULL),
(13,'I/a',24,2445500,'2024-02-12 08:59:08',NULL),
(14,'I/a',26,2522600,'2024-02-12 08:59:08',NULL),
(15,'I/b',3,1840800,'2024-02-12 09:07:25',NULL),
(16,'I/b',5,1898800,'2024-02-12 09:07:25',NULL),
(17,'I/b',7,1958600,'2024-02-12 09:07:25',NULL),
(18,'I/b',9,2020300,'2024-02-12 09:07:25',NULL),
(19,'I/b',11,2083900,'2024-02-12 09:07:25',NULL),
(20,'I/b',13,2149600,'2024-02-12 09:07:25',NULL),
(21,'I/b',15,2217300,'2024-02-12 09:07:25',NULL),
(22,'I/b',17,2287100,'2024-02-12 09:07:25',NULL),
(23,'I/b',19,2359100,'2024-02-12 09:07:25',NULL),
(24,'I/b',21,2433400,'2024-02-12 09:07:25',NULL),
(25,'I/b',23,2510100,'2024-02-12 09:07:25',NULL),
(26,'I/b',25,2589100,'2024-02-12 09:07:25',NULL),
(27,'I/b',27,2670700,'2024-02-12 09:07:25',NULL),
(28,'I/c',3,1918700,'2024-02-12 09:11:33',NULL),
(29,'I/c',5,1979100,'2024-02-12 09:11:33',NULL),
(30,'I/c',7,2041500,'2024-02-12 09:11:33',NULL),
(31,'I/c',9,2105800,'2024-02-12 09:11:33',NULL),
(32,'I/c',11,2172100,'2024-02-12 09:11:33',NULL),
(33,'I/c',13,2240500,'2024-02-12 09:11:33',NULL),
(34,'I/c',15,2311100,'2024-02-12 09:11:33',NULL),
(35,'I/c',17,2383900,'2024-02-12 09:11:33',NULL),
(36,'I/c',19,2458900,'2024-02-12 09:11:33',NULL),
(37,'I/c',21,2536400,'2024-02-12 09:11:33',NULL),
(38,'I/c',23,2616300,'2024-02-12 09:11:33',NULL),
(39,'I/c',25,2698700,'2024-02-12 09:11:33',NULL),
(40,'I/c',27,2783700,'2024-02-12 09:11:33',NULL),
(41,'I/d',3,1999900,'2024-02-12 09:13:55',NULL),
(42,'I/d',5,2062900,'2024-02-12 09:13:55',NULL),
(43,'I/d',7,2127800,'2024-02-12 09:13:55',NULL),
(44,'I/d',9,2194800,'2024-02-12 09:13:55',NULL),
(45,'I/d',11,2264000,'2024-02-12 09:13:55',NULL),
(46,'I/d',13,2335300,'2024-02-12 09:13:55',NULL),
(47,'I/d',15,2408800,'2024-02-12 09:13:55',NULL),
(48,'I/d',17,2484700,'2024-02-12 09:13:55',NULL),
(49,'I/d',19,2562900,'2024-02-12 09:13:55',NULL),
(50,'I/d',21,2643700,'2024-02-12 09:13:55',NULL),
(51,'I/d',23,2726900,'2024-02-12 09:13:55',NULL),
(52,'I/d',25,2812800,'2024-02-12 09:13:55',NULL),
(53,'I/d',27,2901400,'2024-02-12 09:13:55',NULL),
(54,'II/a',0,2184000,'2024-02-12 09:22:07',NULL),
(55,'II/a',1,2218400,'2024-02-12 09:22:07',NULL),
(56,'II/a',3,2288200,'2024-02-12 09:22:07',NULL),
(57,'II/a',5,2360300,'2024-02-12 09:22:07',NULL),
(58,'II/a',7,2434600,'2024-02-12 09:22:07',NULL),
(59,'II/a',9,2511300,'2024-02-12 09:22:07',NULL),
(60,'II/a',11,2590400,'2024-02-12 09:22:07',NULL),
(61,'II/a',13,2672000,'2024-02-12 09:22:07',NULL),
(62,'II/a',15,2756200,'2024-02-12 09:22:07',NULL),
(63,'II/a',17,2843000,'2024-02-12 09:22:07',NULL),
(64,'II/a',19,2932500,'2024-02-12 09:22:07',NULL),
(65,'II/a',21,3024900,'2024-02-12 09:22:07',NULL),
(66,'II/a',23,3120100,'2024-02-12 09:22:07',NULL),
(67,'II/a',25,3218400,'2024-02-12 09:22:07',NULL),
(68,'II/a',27,3319800,'2024-02-12 09:22:07',NULL),
(69,'II/a',29,3424300,'2024-02-12 09:22:07',NULL),
(70,'II/a',31,3532200,'2024-02-12 09:22:07',NULL),
(71,'II/a',33,3643400,'2024-02-12 09:22:07',NULL),
(72,'II/b',3,2385000,'2024-02-12 09:22:32',NULL),
(73,'II/b',5,2460100,'2024-02-12 09:22:32',NULL),
(74,'II/b',7,2537600,'2024-02-12 09:22:32',NULL),
(75,'II/b',9,2617500,'2024-02-12 09:22:32',NULL),
(76,'II/b',11,2700000,'2024-02-12 09:22:32',NULL),
(77,'II/b',13,2785000,'2024-02-12 09:22:32',NULL),
(78,'II/b',15,2872700,'2024-02-12 09:22:32',NULL),
(79,'II/b',17,2963200,'2024-02-12 09:22:32',NULL),
(80,'II/b',19,3056500,'2024-02-12 09:22:32',NULL),
(81,'II/b',21,3152800,'2024-02-12 09:22:32',NULL),
(82,'II/b',23,3252100,'2024-02-12 09:22:32',NULL),
(83,'II/b',25,3354500,'2024-02-12 09:22:32',NULL),
(84,'II/b',27,3460200,'2024-02-12 09:22:32',NULL),
(85,'II/b',29,3569200,'2024-02-12 09:22:32',NULL),
(86,'II/b',31,3681600,'2024-02-12 09:22:32',NULL),
(87,'II/b',33,3797500,'2024-02-12 09:22:32',NULL),
(88,'II/c',3,2485900,'2024-02-12 09:25:19',NULL),
(89,'II/c',5,2564200,'2024-02-12 09:25:19',NULL),
(90,'II/c',7,2645000,'2024-02-12 09:25:19',NULL),
(91,'II/c',9,2728300,'2024-02-12 09:25:19',NULL),
(92,'II/c',11,2814200,'2024-02-12 09:25:19',NULL),
(93,'II/c',13,2902800,'2024-02-12 09:25:19',NULL),
(94,'II/c',15,2994300,'2024-02-12 09:25:19',NULL),
(95,'II/c',17,3088600,'2024-02-12 09:25:19',NULL),
(96,'II/c',19,3185800,'2024-02-12 09:25:19',NULL),
(97,'II/c',21,3286200,'2024-02-12 09:25:19',NULL),
(98,'II/c',23,3389700,'2024-02-12 09:25:19',NULL),
(99,'II/c',25,3496400,'2024-02-12 09:25:19',NULL),
(100,'II/c',27,3606500,'2024-02-12 09:25:19',NULL),
(101,'II/c',29,3720100,'2024-02-12 09:25:19',NULL),
(102,'II/c',31,3837300,'2024-02-12 09:25:19',NULL),
(103,'II/c',33,3958200,'2024-02-12 09:25:19',NULL),
(104,'II/d',3,2591100,'2024-02-12 09:28:27',NULL),
(105,'II/d',5,2672700,'2024-02-12 09:28:27',NULL),
(106,'II/d',7,2756800,'2024-02-12 09:28:27',NULL),
(107,'II/d',9,2843700,'2024-02-12 09:28:27',NULL),
(108,'II/d',11,2933200,'2024-02-12 09:28:27',NULL),
(109,'II/d',13,3025600,'2024-02-12 09:28:27',NULL),
(110,'II/d',15,3120900,'2024-02-12 09:28:27',NULL),
(111,'II/d',17,3219200,'2024-02-12 09:28:27',NULL),
(112,'II/d',19,3320600,'2024-02-12 09:28:27',NULL),
(113,'II/d',21,3425200,'2024-02-12 09:28:27',NULL),
(114,'II/d',23,3533100,'2024-02-12 09:28:27',NULL),
(115,'II/d',25,3644300,'2024-02-12 09:28:27',NULL),
(116,'II/d',27,3759100,'2024-02-12 09:28:27',NULL),
(117,'II/d',29,3877500,'2024-02-12 09:28:27',NULL),
(118,'II/d',31,3999600,'2024-02-12 09:28:27',NULL),
(119,'II/d',33,4125600,'2024-02-12 09:28:27',NULL),
(120,'III/a',0,2785700,'2024-02-12 09:51:08',NULL),
(121,'III/a',2,2873500,'2024-02-12 09:51:08',NULL),
(122,'III/a',4,2964000,'2024-02-12 09:51:08',NULL),
(123,'III/a',6,3057300,'2024-02-12 09:51:08',NULL),
(124,'III/a',8,3153600,'2024-02-12 09:51:08',NULL),
(125,'III/a',10,3252900,'2024-02-12 09:51:08',NULL),
(126,'III/a',12,3355400,'2024-02-12 09:51:08',NULL),
(127,'III/a',14,3461100,'2024-02-12 09:51:08',NULL),
(128,'III/a',16,3570100,'2024-02-12 09:51:08',NULL),
(129,'III/a',18,3682500,'2024-02-12 09:51:08',NULL),
(130,'III/a',20,3798500,'2024-02-12 09:51:08',NULL),
(131,'III/a',22,3918100,'2024-02-12 09:51:08',NULL),
(132,'III/a',24,4041500,'2024-02-12 09:51:08',NULL),
(133,'III/a',26,4168800,'2024-02-12 09:51:08',NULL),
(134,'III/a',28,4300100,'2024-02-12 09:51:08',NULL),
(135,'III/a',30,4435500,'2024-02-12 09:51:08',NULL),
(136,'III/a',32,4575200,'2024-02-12 09:51:08',NULL),
(137,'III/b',0,2903600,'2024-02-12 09:51:08',NULL),
(138,'III/b',2,2995000,'2024-02-12 09:51:08',NULL),
(139,'III/b',4,3089300,'2024-02-12 09:51:08',NULL),
(140,'III/b',6,3186600,'2024-02-12 09:51:08',NULL),
(141,'III/b',8,3287000,'2024-02-12 09:51:08',NULL),
(142,'III/b',10,3390500,'2024-02-12 09:51:08',NULL),
(143,'III/b',12,3497300,'2024-02-12 09:51:08',NULL),
(144,'III/b',14,3607500,'2024-02-12 09:51:08',NULL),
(145,'III/b',16,3721100,'2024-02-12 09:51:08',NULL),
(146,'III/b',18,3838300,'2024-02-12 09:51:08',NULL),
(147,'III/b',20,3959200,'2024-02-12 09:51:08',NULL),
(148,'III/b',22,4083900,'2024-02-12 09:51:08',NULL),
(149,'III/b',24,4212500,'2024-02-12 09:51:08',NULL),
(150,'III/b',26,4345100,'2024-02-12 09:51:08',NULL),
(151,'III/b',28,448200,'2024-02-12 09:51:08',NULL),
(152,'III/b',30,4623200,'2024-02-12 09:51:08',NULL),
(153,'III/b',32,4768800,'2024-02-12 09:51:08',NULL),
(154,'III/c',0,3026400,'2024-02-12 09:51:08',NULL),
(155,'III/c',2,3121700,'2024-02-12 09:51:08',NULL),
(156,'III/c',4,3220000,'2024-02-12 09:51:08',NULL),
(157,'III/c',6,3321400,'2024-02-12 09:51:08',NULL),
(158,'III/c',8,3426000,'2024-02-12 09:51:08',NULL),
(159,'III/c',10,3533900,'2024-02-12 09:51:08',NULL),
(160,'III/c',12,3645200,'2024-02-12 09:51:08',NULL),
(161,'III/c',14,3760100,'2024-02-12 09:51:08',NULL),
(162,'III/c',16,3878500,'2024-02-12 09:51:08',NULL),
(163,'III/c',18,4000600,'2024-02-12 09:51:08',NULL),
(164,'III/c',20,4126600,'2024-02-12 09:51:08',NULL),
(165,'III/c',22,4256600,'2024-02-12 09:51:08',NULL),
(166,'III/c',24,4390700,'2024-02-12 09:51:08',NULL),
(167,'III/c',26,4528900,'2024-02-12 09:51:08',NULL),
(168,'III/c',28,4671600,'2024-02-12 09:51:08',NULL),
(169,'III/c',30,4818700,'2024-02-12 09:51:08',NULL),
(170,'III/c',32,4970500,'2024-02-12 09:51:08',NULL),
(171,'III/d',0,3154400,'2024-02-12 09:51:08',NULL),
(172,'III/d',2,3253700,'2024-02-12 09:51:08',NULL),
(173,'III/d',4,3356200,'2024-02-12 09:51:08',NULL),
(174,'III/d',6,3461900,'2024-02-12 09:51:08',NULL),
(175,'III/d',8,3571000,'2024-02-12 09:51:08',NULL),
(176,'III/d',10,3683400,'2024-02-12 09:51:08',NULL),
(177,'III/d',12,3799400,'2024-02-12 09:51:08',NULL),
(178,'III/d',14,3919100,'2024-02-12 09:51:08',NULL),
(179,'III/d',16,4042500,'2024-02-12 09:51:08',NULL),
(180,'III/d',18,4169900,'2024-02-12 09:51:08',NULL),
(181,'III/d',20,4301200,'2024-02-12 09:51:08',NULL),
(182,'III/d',22,4436700,'2024-02-12 09:51:08',NULL),
(183,'III/d',24,4576400,'2024-02-12 09:51:08',NULL),
(184,'III/d',26,4720500,'2024-02-12 09:51:08',NULL),
(185,'III/d',28,4869200,'2024-02-12 09:51:08',NULL),
(186,'III/d',30,5022500,'2024-02-12 09:51:08',NULL),
(187,'III/d',32,5180700,'2024-02-12 09:51:08',NULL),
(188,'IV/a',0,3287800,'2024-02-12 09:51:08',NULL),
(189,'IV/a',2,3391400,'2024-02-12 09:51:08',NULL),
(190,'IV/a',4,3498200,'2024-02-12 09:51:08',NULL),
(191,'IV/a',6,3608400,'2024-02-12 09:51:08',NULL),
(192,'IV/a',8,3722000,'2024-02-12 09:51:08',NULL),
(193,'IV/a',10,3839200,'2024-02-12 09:51:08',NULL),
(194,'IV/a',12,3960200,'2024-02-12 09:51:08',NULL),
(195,'IV/a',14,4084900,'2024-02-12 09:51:08',NULL),
(196,'IV/a',16,4213500,'2024-02-12 09:51:08',NULL),
(197,'IV/a',18,4346200,'2024-02-12 09:51:08',NULL),
(198,'IV/a',20,4483100,'2024-02-12 09:51:08',NULL),
(199,'IV/a',22,4624300,'2024-02-12 09:51:08',NULL),
(200,'IV/a',24,4770000,'2024-02-12 09:51:08',NULL),
(201,'IV/a',26,4920200,'2024-02-12 09:51:08',NULL),
(202,'IV/a',28,5075200,'2024-02-12 09:51:08',NULL),
(203,'IV/a',30,5235000,'2024-02-12 09:51:08',NULL),
(204,'IV/a',32,5399900,'2024-02-12 09:51:08',NULL),
(205,'IV/b',0,3426900,'2024-02-12 09:51:08',NULL),
(206,'IV/b',2,3534800,'2024-02-12 09:51:08',NULL),
(207,'IV/b',4,3646200,'2024-02-12 09:51:08',NULL),
(208,'IV/b',6,3761000,'2024-02-12 09:51:08',NULL),
(209,'IV/b',8,3879500,'2024-02-12 09:51:08',NULL),
(210,'IV/b',10,4001600,'2024-02-12 09:51:08',NULL),
(211,'IV/b',12,4127700,'2024-02-12 09:51:08',NULL),
(212,'IV/b',14,4257700,'2024-02-12 09:51:08',NULL),
(213,'IV/b',16,4391800,'2024-02-12 09:51:08',NULL),
(214,'IV/b',18,4530100,'2024-02-12 09:51:08',NULL),
(215,'IV/b',20,4672800,'2024-02-12 09:51:08',NULL),
(216,'IV/b',22,4819900,'2024-02-12 09:51:08',NULL),
(217,'IV/b',24,4971700,'2024-02-12 09:51:08',NULL),
(218,'IV/b',26,5128300,'2024-02-12 09:51:08',NULL),
(219,'IV/b',28,5289800,'2024-02-12 09:51:08',NULL),
(220,'IV/b',30,5456400,'2024-02-12 09:51:08',NULL),
(221,'IV/b',32,5628300,'2024-02-12 09:51:08',NULL),
(222,'IV/c',0,3571900,'2024-02-12 09:51:08',NULL),
(223,'IV/c',2,3684400,'2024-02-12 09:51:08',NULL),
(224,'IV/c',4,3800400,'2024-02-12 09:51:08',NULL),
(225,'IV/c',6,3920100,'2024-02-12 09:51:08',NULL),
(226,'IV/c',8,4043600,'2024-02-12 09:51:08',NULL),
(227,'IV/c',10,4170900,'2024-02-12 09:51:08',NULL),
(228,'IV/c',12,4302300,'2024-02-12 09:51:08',NULL),
(229,'IV/c',14,4437800,'2024-02-12 09:51:08',NULL),
(230,'IV/c',16,4577500,'2024-02-12 09:51:08',NULL),
(231,'IV/c',18,4721700,'2024-02-12 09:51:08',NULL),
(232,'IV/c',20,4870400,'2024-02-12 09:51:08',NULL),
(233,'IV/c',22,5023800,'2024-02-12 09:51:08',NULL),
(234,'IV/c',24,5182000,'2024-02-12 09:51:08',NULL),
(235,'IV/c',26,5345200,'2024-02-12 09:51:08',NULL),
(236,'IV/c',28,5513600,'2024-02-12 09:51:08',NULL),
(237,'IV/c',30,5687200,'2024-02-12 09:51:08',NULL),
(238,'IV/c',32,5866400,'2024-02-12 09:51:08',NULL),
(239,'IV/d',0,3723000,'2024-02-12 09:51:08',NULL),
(240,'IV/d',2,3840200,'2024-02-12 09:51:08',NULL),
(241,'IV/d',4,3961200,'2024-02-12 09:51:08',NULL),
(242,'IV/d',6,4085900,'2024-02-12 09:51:08',NULL),
(243,'IV/d',8,4214600,'2024-02-12 09:51:08',NULL),
(244,'IV/d',10,4347300,'2024-02-12 09:51:08',NULL),
(245,'IV/d',12,4484300,'2024-02-12 09:51:08',NULL),
(246,'IV/d',14,4625500,'2024-02-12 09:51:08',NULL),
(247,'IV/d',16,4771200,'2024-02-12 09:51:08',NULL),
(248,'IV/d',18,4921400,'2024-02-12 09:51:08',NULL),
(249,'IV/d',20,5076400,'2024-02-12 09:51:08',NULL),
(250,'IV/d',22,5236300,'2024-02-12 09:51:08',NULL),
(251,'IV/d',24,5401200,'2024-02-12 09:51:08',NULL),
(252,'IV/d',26,5571400,'2024-02-12 09:51:08',NULL),
(253,'IV/d',28,5746800,'2024-02-12 09:51:08',NULL),
(254,'IV/d',30,5927800,'2024-02-12 09:51:08',NULL),
(255,'IV/d',32,6114500,'2024-02-12 09:51:08',NULL),
(256,'IV/e',0,3880400,'2024-02-12 09:51:08',NULL),
(257,'IV/e',2,4002700,'2024-02-12 09:51:08',NULL),
(258,'IV/e',4,4128700,'2024-02-12 09:51:08',NULL),
(259,'IV/e',6,4258700,'2024-02-12 09:51:08',NULL),
(260,'IV/e',8,4392900,'2024-02-12 09:51:08',NULL),
(261,'IV/e',10,4531200,'2024-02-12 09:51:08',NULL),
(262,'IV/e',12,4673900,'2024-02-12 09:51:08',NULL),
(263,'IV/e',14,4821100,'2024-02-12 09:51:08',NULL),
(264,'IV/e',16,4973000,'2024-02-12 09:51:08',NULL),
(265,'IV/e',18,5129600,'2024-02-12 09:51:08',NULL),
(266,'IV/e',20,5291200,'2024-02-12 09:51:08',NULL),
(267,'IV/e',22,5457800,'2024-02-12 09:51:08',NULL),
(268,'IV/e',24,5629700,'2024-02-12 09:51:08',NULL),
(269,'IV/e',26,5807000,'2024-02-12 09:51:08',NULL),
(270,'IV/e',28,5989000,'2024-02-12 09:51:08',NULL),
(271,'IV/e',30,6178600,'2024-02-12 09:51:08',NULL),
(272,'IV/e',32,6373200,'2024-02-12 09:51:08',NULL);
/*!40000 ALTER TABLE `tbl_gaji_pokok` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_gaji_pokok_2`
--

DROP TABLE IF EXISTS `tbl_gaji_pokok_2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_gaji_pokok_2` (
  `id_gaji_pokok` int(11) NOT NULL AUTO_INCREMENT,
  `golongan` varchar(5) DEFAULT NULL,
  `masa_kerja` int(11) DEFAULT NULL,
  `gaji_pokok` int(11) DEFAULT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id_gaji_pokok`)
) ENGINE=InnoDB AUTO_INCREMENT=273 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_gaji_pokok_2`
--

LOCK TABLES `tbl_gaji_pokok_2` WRITE;
/*!40000 ALTER TABLE `tbl_gaji_pokok_2` DISABLE KEYS */;
INSERT INTO `tbl_gaji_pokok_2` VALUES
(1,'I/b',5,1758200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(2,'I/a',2,1610000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(3,'I/a',4,1660700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(4,'I/a',6,1713000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(5,'I/a',8,1766900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(6,'I/a',10,1822600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(7,'I/a',12,1880000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(8,'I/a',14,1939200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(9,'I/a',16,2000300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(10,'I/a',18,2063300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(11,'I/a',20,2128300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(12,'I/a',22,2195300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(13,'I/a',24,2264400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(14,'I/a',26,2335800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(15,'I/b',3,1704500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(16,'I/b',7,1813600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(17,'I/b',9,1870700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(18,'I/b',11,1929600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(19,'I/b',13,1990400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(20,'I/b',15,2053100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(21,'I/b',17,2117700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(22,'I/b',19,2184400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(23,'I/b',21,2253200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(24,'I/b',23,2324200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(25,'I/b',25,2397400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(26,'I/c',3,1776600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(27,'I/c',7,1890300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(28,'I/c',5,1832600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(29,'I/c',9,1949800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(30,'I/c',11,2011200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(31,'I/c',13,2074600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(32,'I/c',15,2139900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(33,'I/c',17,2207300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(34,'I/c',19,2276800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(35,'I/c',21,2348500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(36,'I/c',23,2422500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(37,'I/c',25,2498800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(38,'I/c',27,2577500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(39,'I/d',3,1851800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(40,'I/d',5,1910100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(41,'I/d',7,1970200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(42,'I/d',9,2032300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(43,'I/d',11,2096300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(44,'I/d',13,2162300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(45,'I/d',15,2230400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(46,'I/d',17,2300700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(47,'I/d',19,2373100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(48,'I/d',21,2447900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(49,'I/d',23,2525000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(50,'I/d',25,2604500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(51,'I/d',27,2686500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(52,'I/b',27,2472900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(53,'II/a',0,2022200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(54,'II/a',1,2054100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(55,'II/a',3,2118800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(56,'II/a',5,2185500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(57,'II/a',7,2254300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(58,'II/a',9,2325300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(59,'II/a',11,2398600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(60,'II/a',13,2474100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(61,'II/a',15,2552000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(62,'II/a',17,2632400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(63,'II/a',19,2715300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(64,'II/a',21,2800800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(65,'II/a',23,2889100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(66,'II/a',25,2980000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(67,'II/a',27,3073900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(68,'II/a',29,3170700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(69,'II/a',31,3270600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(70,'II/a',33,3373600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(71,'II/b',3,2208400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(72,'II/b',5,2277900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(73,'II/b',7,2349700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(74,'II/b',9,2423700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(75,'II/b',11,2500000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(76,'II/b',13,2578800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(77,'II/b',15,2660000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(78,'II/b',17,2743800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(79,'II/b',19,2830200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(80,'II/b',21,2919300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(81,'II/b',23,3011300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(82,'II/b',25,3106100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(83,'II/b',27,3203900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(84,'II/b',29,3304800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(85,'II/b',31,3408900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(86,'II/b',33,3516300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(87,'II/c',3,2301800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(88,'II/c',5,2374300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(89,'II/c',7,2449100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(90,'II/c',9,2526200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(91,'II/c',13,2687800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(92,'II/c',15,2772500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(93,'II/c',17,2859800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(94,'II/c',19,2949900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(95,'II/c',21,3042800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(96,'II/c',23,3138600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(97,'II/c',25,3237500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(98,'II/c',27,3339400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(99,'II/c',31,3553100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(100,'II/c',33,3665000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(101,'II/d',3,2399200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(102,'II/d',5,2474700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(103,'II/d',7,2552700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(104,'II/d',9,2633100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(105,'II/d',11,2716000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(106,'II/d',13,2801500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(107,'II/d',15,2889800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(108,'II/d',17,2980800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(109,'II/d',19,3074700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(110,'II/d',21,3171500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(111,'II/d',23,3271400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(112,'II/d',25,3374400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(113,'II/d',27,3480700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(114,'II/d',29,3590300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(115,'II/d',31,3703400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(116,'II/d',33,3820000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(117,'III/a',0,2579400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(118,'III/a',2,2660700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(119,'III/a',4,2744500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(120,'III/a',6,2830900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(121,'III/a',8,2920100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(122,'III/a',10,3012000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(123,'III/a',12,3106900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(124,'III/a',14,3204700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(125,'III/a',16,3305700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(126,'III/a',18,3409800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(127,'III/a',20,3517200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(128,'III/a',22,3627900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(129,'III/a',24,3742200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(130,'III/a',26,3860100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(131,'III/a',28,3981600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(132,'III/a',30,4107000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(133,'III/a',32,4236400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(134,'III/b',0,2688500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(135,'III/b',2,2773200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(136,'III/b',4,2860500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(137,'III/b',6,2950600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(138,'III/b',8,3043600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(139,'III/b',10,3139400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(140,'III/b',12,3238300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(141,'III/b',14,3340300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(142,'III/b',16,3445500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(143,'III/b',18,3554000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(144,'III/b',20,3665900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(145,'III/b',22,3781400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(146,'III/b',24,3900500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(147,'III/b',26,4023300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(148,'III/b',28,4150100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(149,'III/b',30,4280800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(150,'III/b',32,4415600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(151,'III/c',0,2802300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(152,'III/c',2,2890500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(153,'III/c',4,2981500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(154,'III/c',6,3075500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(155,'III/c',8,3172300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(156,'III/c',10,3272200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(157,'III/c',12,3375300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(158,'III/c',14,3481600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(159,'III/c',16,3591200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(160,'III/c',18,3704300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(161,'III/c',20,3821000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(162,'III/c',22,3941400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(163,'III/c',24,4065500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(164,'III/c',26,4193500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(165,'III/c',28,4325600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(166,'III/c',30,4461800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(167,'III/c',32,4602400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(168,'III/d',0,2920800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(169,'III/d',2,3012800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(170,'III/d',4,3107700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(171,'III/d',6,3205500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(172,'III/d',8,3306500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(173,'III/d',10,3410600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(174,'III/d',12,3518100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(175,'III/d',14,3628900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(176,'III/d',16,3743100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(177,'III/d',18,3861000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(178,'III/d',20,3982600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(179,'III/d',22,4108100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(180,'III/d',24,4237500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(181,'III/d',26,4370900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(182,'III/d',28,4508600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(183,'III/d',30,4650600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(184,'III/d',32,4797000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(185,'IV/a',0,3044300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(186,'IV/a',2,3140200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(187,'IV/a',4,3239100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(188,'IV/a',6,3341100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(189,'IV/a',8,3446400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(190,'IV/a',10,3554900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(191,'IV/a',12,3666900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(192,'IV/a',14,3782400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(193,'IV/a',16,3901500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(194,'IV/a',18,4024400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(195,'IV/a',20,4151100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(196,'IV/a',22,4281800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(197,'IV/a',24,4416700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(198,'IV/a',26,4555800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(199,'IV/a',28,4699300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(200,'IV/a',30,4847300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(201,'IV/a',32,5000000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(202,'IV/b',0,3173100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(203,'IV/b',2,3273100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(204,'IV/b',4,3376100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(205,'IV/b',6,3482500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(206,'IV/b',8,3592100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(207,'IV/b',10,3705300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(208,'IV/b',12,3822000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(209,'IV/b',14,3942400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(210,'IV/b',16,4066500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(211,'IV/b',18,4194600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(212,'IV/b',20,4326700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(213,'IV/b',22,4463000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(214,'IV/b',24,4603500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(215,'IV/b',26,4748500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(216,'IV/b',28,4898100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(217,'IV/b',30,5052300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(218,'IV/b',32,5211500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(219,'IV/c',0,3307300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(220,'IV/c',2,3411500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(221,'IV/c',4,3518900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(222,'IV/c',6,3629800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(223,'IV/c',8,3744100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(224,'IV/c',10,3862000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(225,'IV/c',12,3983600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(226,'IV/c',14,4109100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(227,'IV/c',16,4238500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(228,'IV/c',18,4372000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(229,'IV/c',20,4509700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(230,'IV/c',22,4651800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(231,'IV/c',24,4798300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(232,'IV/c',26,4949400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(233,'IV/c',28,5105300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(234,'IV/c',30,5266100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(235,'IV/c',32,5431900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(236,'IV/d',0,3447200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(237,'IV/d',2,3555800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(238,'IV/d',4,3667800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(239,'IV/d',6,3783300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(240,'IV/d',8,3902500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(241,'IV/d',10,4025400,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(242,'IV/d',12,4152200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(243,'IV/d',14,4282900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(244,'IV/d',16,4417800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(245,'IV/d',18,4557000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(246,'IV/d',20,4700500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(247,'IV/d',22,4848500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(248,'IV/d',24,5001200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(249,'IV/d',26,5158700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(250,'IV/d',28,5321200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(251,'IV/d',30,5488800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(252,'IV/d',32,5661700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(253,'IV/e',0,3593100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(254,'IV/e',2,3706200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(255,'IV/e',4,3822900,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(256,'IV/e',6,3943300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(257,'IV/e',8,4067500,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(258,'IV/e',10,4195700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(259,'IV/e',12,4327800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(260,'IV/e',14,4464100,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(261,'IV/e',16,4604700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(262,'IV/e',18,4749700,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(263,'IV/e',20,4899300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(264,'IV/e',22,5053600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(265,'IV/e',24,5212800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(266,'IV/e',26,5377000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(267,'IV/e',28,5546300,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(268,'IV/e',30,5721000,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(269,'IV/e',32,5901200,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(270,'II/c',11,2605800,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(271,'II/c',29,3444600,'0000-00-00 00:00:00','0000-00-00 00:00:00'),
(272,'I/a',0,1560800,'0000-00-00 00:00:00','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `tbl_gaji_pokok_2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_histori`
--

DROP TABLE IF EXISTS `tbl_histori`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_histori` (
  `id_histori` int(11) NOT NULL AUTO_INCREMENT,
  `nip` varchar(18) NOT NULL,
  `tahap` int(11) NOT NULL,
  `informasi` text NOT NULL,
  `status` text NOT NULL,
  `created` datetime NOT NULL,
  `modified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `deleted` datetime DEFAULT NULL,
  PRIMARY KEY (`id_histori`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_histori`
--

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

--
-- Table structure for table `tbl_nomor`
--

DROP TABLE IF EXISTS `tbl_nomor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_nomor` (
  `id_nomor` int(11) NOT NULL AUTO_INCREMENT,
  `nomor` int(11) NOT NULL,
  `id_sijala` int(11) NOT NULL DEFAULT 0,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `modified` datetime DEFAULT NULL,
  `deleted` datetime DEFAULT NULL,
  PRIMARY KEY (`id_nomor`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_nomor`
--

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

--
-- Table structure for table `tbl_pp`
--

DROP TABLE IF EXISTS `tbl_pp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_pp` (
  `id_pp` int(11) NOT NULL AUTO_INCREMENT,
  `pp` text NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `deleted` datetime DEFAULT NULL,
  PRIMARY KEY (`id_pp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_pp`
--

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

--
-- Table structure for table `tbl_setting`
--

DROP TABLE IF EXISTS `tbl_setting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_setting` (
  `id_setting` int(11) NOT NULL AUTO_INCREMENT,
  `nama_pejabat_pengesah` varchar(50) NOT NULL,
  `nip` varchar(18) NOT NULL,
  `jabatan_pengesah` text NOT NULL,
  `aktif` int(11) NOT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NULL DEFAULT NULL,
  `deleted` datetime DEFAULT NULL,
  PRIMARY KEY (`id_setting`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_setting`
--

LOCK TABLES `tbl_setting` WRITE;
/*!40000 ALTER TABLE `tbl_setting` DISABLE KEYS */;
INSERT INTO `tbl_setting` VALUES
(1,'BAHARUDDIN, S.Sos., M.Si','196303161986031010','KEPALA BADAN KEPEGAWAIAN DAN PENGEMBANGAN SUMBER DAYA MANUSIA',0,'2020-12-09 09:30:12',NULL,NULL),
(2,'FABILLAH SANDY, SE, M.AP','197403201994031002','Plt. KEPALA BADAN KEPEGAWAIAN DAN PENGEMBANGAN SUMBER DAYA MANUSIA',0,'2023-04-04 23:33:27',NULL,NULL),
(3,'IRWAN SURYADI','197310211993031001','KEPALA BADAN KEPEGAWAIAN DAN PENGEMBANGAN SUMBER DAYA MANUSIA',1,'2020-12-09 09:30:12',NULL,NULL);
/*!40000 ALTER TABLE `tbl_setting` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_sijala`
--

DROP TABLE IF EXISTS `tbl_sijala`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tbl_sijala` (
  `id_sijala` bigint(20) NOT NULL AUTO_INCREMENT,
  `kd_qr` varchar(10) DEFAULT NULL,
  `nomor_sk_kgb` varchar(50) DEFAULT NULL,
  `tgl_sk_kgb` date DEFAULT NULL,
  `nip` char(18) NOT NULL,
  `gaji_pokok_lama` int(11) NOT NULL,
  `gaji_pokok_baru` int(11) NOT NULL,
  `pejabat_sk_lama` text NOT NULL,
  `pejabat_sk_baru` text NOT NULL,
  `tgl_lama` date NOT NULL,
  `tgl_baru` date NOT NULL,
  `nomor_sk_kgb_lama` varchar(50) NOT NULL,
  `tgl_sk_lama` date DEFAULT NULL,
  `tgl_berlaku` date NOT NULL,
  `masa_kerja_baru` varchar(20) NOT NULL,
  `masa_kerja_lama` varchar(20) NOT NULL,
  `status` enum('Preview','Diproses','Disetujui','Ditolak','') DEFAULT 'Diproses',
  `tahap_pengajuan` int(11) NOT NULL DEFAULT 1,
  `jenis_kgb` enum('kenaikan_kgb','kenaikan_pangkat','') DEFAULT NULL,
  `dasar_penetapan` int(11) NOT NULL DEFAULT 0,
  `keterangan` text DEFAULT NULL,
  `file` text DEFAULT NULL,
  `file_kgb` varchar(10) DEFAULT NULL,
  `file_pangkat` varchar(10) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `deleted` datetime DEFAULT NULL,
  PRIMARY KEY (`id_sijala`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_sijala`
--

LOCK TABLES `tbl_sijala` WRITE;
/*!40000 ALTER TABLE `tbl_sijala` DISABLE KEYS */;
INSERT INTO `tbl_sijala` VALUES
(1,NULL,'Kpts.823.3/BKPSDM-MP/2022/204','2023-02-13','197306301996111001',123,321,'Kepala BKPSDM Kota Pekanbaru','BARU','2022-02-07','2024-02-18','','2024-02-18','2022-04-01','18 Tahun 00 Bulan','16 Tahun 00 Bulan','Disetujui',1,NULL,1,NULL,'/2024_02/197306301996111001.pdf',NULL,NULL,'2024-02-18 07:33:35','2024-02-18 07:58:50',NULL);
/*!40000 ALTER TABLE `tbl_sijala` 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 2026-08-22 11:44:11