/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19-11.4.10-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: infokmtj_luckyuydsaisdfk2
-- ------------------------------------------------------
-- Server version	11.4.10-MariaDB-cll-lve-log

/*!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' */;
/*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;

--
-- Table structure for table `jackpot_lucky`
--

DROP TABLE IF EXISTS `jackpot_lucky`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `jackpot_lucky` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mega_jp` text NOT NULL,
  `minor_jp` text NOT NULL,
  `major_jp` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jackpot_lucky`
--

LOCK TABLES `jackpot_lucky` WRITE;
/*!40000 ALTER TABLE `jackpot_lucky` DISABLE KEYS */;
INSERT INTO `jackpot_lucky` (`id`, `mega_jp`, `minor_jp`, `major_jp`) VALUES (1,'6665','5061','8558');
/*!40000 ALTER TABLE `jackpot_lucky` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_statement`
--

DROP TABLE IF EXISTS `log_statement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `log_statement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `log_desc` mediumtext NOT NULL,
  `log_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2193 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_statement`
--

LOCK TABLES `log_statement` WRITE;
/*!40000 ALTER TABLE `log_statement` DISABLE KEYS */;
INSERT INTO `log_statement` (`id`, `log_desc`, `log_date`) VALUES (2192,'Username : [admin] telah login ke dalam system','2025-03-10 15:27:03');
/*!40000 ALTER TABLE `log_statement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `login_cred`
--

DROP TABLE IF EXISTS `login_cred`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `login_cred` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `jam_masuk` text NOT NULL,
  `nama_depan` text NOT NULL,
  `nama_belakang` text NOT NULL,
  `gaji` bigint(20) NOT NULL,
  `tim` varchar(100) NOT NULL,
  `posisi` varchar(50) NOT NULL,
  `disiplin` text NOT NULL,
  `knowledge` text NOT NULL,
  `teamwork` text NOT NULL,
  `attitude` varchar(100) NOT NULL,
  `mulai_kerja` varchar(255) NOT NULL,
  `warning` varchar(50) NOT NULL,
  `no_rekening` varchar(200) NOT NULL,
  `ban_status` tinyint(1) NOT NULL,
  `tggl_daftar` datetime NOT NULL,
  `last_login` text NOT NULL,
  `user_status` varchar(50) NOT NULL,
  `peran` varchar(100) NOT NULL,
  `whitelist_ip` text NOT NULL,
  `dibuat_oleh` varchar(100) NOT NULL,
  `issue_visa` varchar(11) NOT NULL,
  `expire_visa` varchar(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `login_cred`
--

LOCK TABLES `login_cred` WRITE;
/*!40000 ALTER TABLE `login_cred` DISABLE KEYS */;
INSERT INTO `login_cred` (`id`, `username`, `password`, `jam_masuk`, `nama_depan`, `nama_belakang`, `gaji`, `tim`, `posisi`, `disiplin`, `knowledge`, `teamwork`, `attitude`, `mulai_kerja`, `warning`, `no_rekening`, `ban_status`, `tggl_daftar`, `last_login`, `user_status`, `peran`, `whitelist_ip`, `dibuat_oleh`, `issue_visa`, `expire_visa`) VALUES (13,'admin','$2y$10$z5cE5941AjbGCmMt5aUjCeHoWKgGx46Qaj22G779REMFfLr5xqw2G','09:45','Johnny','',10000000,'','','','','','','','','',0,'2023-07-09 19:55:45','2025-03-10 15:27:03','online','admin','','','',''),
(14,'jojo','$2y$10$5VLyoIwo7kveaHBD077NWuNPKxJjr1xJ8yHF8mAfsEWZKAQ68BUUa','09:50','ACHMAD DHANI RIFFY','',7000000,'','','','','','','','','',0,'2023-07-09 19:57:37','','','anggota','','','',''),
(15,'lolo','$2y$10$5VLyoIwo7kveaHBD077NWuNPKxJjr1xJ8yHF8mAfsEWZKAQ68BUUa','09:00','CHRIS','',8000000,'','','','','','','','','',0,'2023-07-09 19:57:37','','','anggota','','','','');
/*!40000 ALTER TABLE `login_cred` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `login_log`
--

DROP TABLE IF EXISTS `login_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `login_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userlog` varchar(255) NOT NULL,
  `tokenlog` text NOT NULL,
  `stat_log` varchar(100) NOT NULL,
  `log_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=424 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `login_log`
--

LOCK TABLES `login_log` WRITE;
/*!40000 ALTER TABLE `login_log` DISABLE KEYS */;
INSERT INTO `login_log` (`id`, `userlog`, `tokenlog`, `stat_log`, `log_date`) VALUES (423,'admin','15kJgfY09baHCrcECoC','active','2025-03-10 15:27:03');
/*!40000 ALTER TABLE `login_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `segment_wheel`
--

DROP TABLE IF EXISTS `segment_wheel`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `segment_wheel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `segment_name` varchar(100) NOT NULL,
  `segment_color` tinytext NOT NULL,
  `segment_textcolor` tinytext NOT NULL,
  `segment_updated` varchar(100) NOT NULL,
  `segment_time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `segment_wheel`
--

LOCK TABLES `segment_wheel` WRITE;
/*!40000 ALTER TABLE `segment_wheel` DISABLE KEYS */;
INSERT INTO `segment_wheel` (`id`, `segment_name`, `segment_color`, `segment_textcolor`, `segment_updated`, `segment_time`) VALUES (1,'Avanza','#e40060','#ffffff','admin','2023-07-20 16:27:58'),
(3,'ZONK','#46001d','#fff','','2023-07-20 16:27:58'),
(4,'90.000','#e40060','#fff','','2023-07-20 16:27:58'),
(5,'100.000','#860038','#fff','','2023-07-20 16:27:58'),
(6,'1.000.000','#e40060','#fff','','2023-07-20 16:27:58'),
(7,'20.000','#860038','#fff','','2023-07-20 18:43:02'),
(8,'10.000.000','#46001d','#ffffff','admin','2023-07-20 16:27:58'),
(9,'ZONK','#5c0000','#ffffff','admin','2023-07-26 20:08:06'),
(15,'20.000','#c2005e','#ffffff','admin','2023-07-26 22:31:04');
/*!40000 ALTER TABLE `segment_wheel` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `voucher`
--

DROP TABLE IF EXISTS `voucher`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `voucher` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kode_voucher` tinytext NOT NULL,
  `user_voucher` varchar(100) NOT NULL,
  `value_voucher` bigint(20) NOT NULL,
  `hadiah_voucher` varchar(255) NOT NULL,
  `creator_voucher` varchar(100) NOT NULL,
  `expire_voucher` tinyint(1) NOT NULL,
  `date_voucher` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `voucher`
--

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

--
-- Table structure for table `web_setting`
--

DROP TABLE IF EXISTS `web_setting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `web_setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama_web` varchar(50) NOT NULL,
  `link_web` text NOT NULL,
  `wa_web` text NOT NULL,
  `lc_web` text NOT NULL,
  `bg_web` text NOT NULL,
  `logo_web` text NOT NULL,
  `seo_homepage` longtext NOT NULL,
  `seo_web` longtext NOT NULL,
  `syarat_ketentuan` longtext NOT NULL,
  `welcome_message` longtext NOT NULL,
  `script_web` longtext NOT NULL,
  `script_web2` longtext NOT NULL,
  `last_updated` datetime NOT NULL,
  `last_set` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `web_setting`
--

LOCK TABLES `web_setting` WRITE;
/*!40000 ALTER TABLE `web_setting` DISABLE KEYS */;
INSERT INTO `web_setting` (`id`, `nama_web`, `link_web`, `wa_web`, `lc_web`, `bg_web`, `logo_web`, `seo_homepage`, `seo_web`, `syarat_ketentuan`, `welcome_message`, `script_web`, `script_web2`, `last_updated`, `last_set`) VALUES (1,'Lucky Spin','#','','#lc','images/bg.png','images/logo.png','<p>Homepage Text Deskripsi</p>',' <title>Lucky Spin</title>\r\n<meta name=\"description\" content=\"Deskripsi Lucky Spin.\">\r\n<meta name=\"og:title\" content=\"Lucky Spin\">\r\n<meta name=\"og:description\" content=\"Deskripsi Lucky Spin.\">\r\n<meta name=\"og:type\" content=\"website\">\r\n<meta name=\"og:url\" content=\"/\">\r\n<meta name=\"og:image\" content=\"images/img-1.png\">\r\n<meta property=\"og:image:width\" content=\"600\">\r\n<meta property=\"og:image:height\" content=\"466\">\r\n<link rel=\"apple-touch-icon\" sizes=\"180x180\" href=\"images/coins-2.png\">\r\n<link rel=\"shortcut icon\" sizes=\"32x32\" href=\"images/coins-2.png\">\r\n<link rel=\"shortcut icon\" sizes=\"16x16\" href=\"images/coins-2.png\">\r\n<link rel=\"shortcut icon\"  href=\"images/coins-2.png\">\r\n<meta name=\"theme-color\" content=\"#630000\">','<p>Syarat &amp; Ketentuan</p>','<h2>Welcome to Lucky Spin</h2>\r\n<p>Semua kata kata Welcome page di isi disini.....</p>','','','2023-09-29 19:44:53','admin');
/*!40000 ALTER TABLE `web_setting` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `winner`
--

DROP TABLE IF EXISTS `winner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `winner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `winner` varchar(100) NOT NULL,
  `winner_voucher` tinytext NOT NULL,
  `prize` tinytext NOT NULL,
  `winner_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `winner`
--

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

--
-- Dumping events for database 'infokmtj_luckyuydsaisdfk2'
--

--
-- Dumping routines for database 'infokmtj_luckyuydsaisdfk2'
--
/*!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 */;
/*M!100616 SET NOTE_VERBOSITY=@OLD_NOTE_VERBOSITY */;

-- Dump completed on 2026-03-16 11:08:30