--
-- Host: localhost    Database: infokmtj_luckyuydsaisdfk2
-- ------------------------------------------------------


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

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;

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

INSERT INTO `jackpot_lucky` (`id`, `mega_jp`, `minor_jp`, `major_jp`) VALUES (1,'6665','5061','8558');

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

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;

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

INSERT INTO `log_statement` (`id`, `log_desc`, `log_date`) VALUES (2192,'Username : [admin] telah login ke dalam system','2025-03-10 15:27:03');

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

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;

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

INSERT INTO `login_log` (`id`, `userlog`, `tokenlog`, `stat_log`, `log_date`) VALUES (423,'admin','15kJgfY09baHCrcECoC','active','2025-03-10 15:27:03');

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

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;

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

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');

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

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;

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


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

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;

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

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');

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

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;

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


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

--
-- Dumping routines for database 'infokmtj_luckyuydsaisdfk2'
--


