Na}{

File Content: `database-baru.sql`

/* Untuk Buat Table */

CREATE TABLE `data_member` (
  `id_member` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(30),
  `jenis_cheat` ENUM('Inject Winrate Pragmatic Play','Inject Winrate PG Soft','Inject Super Wild','Inject RTP Maksimal'),
  `winrate` TINYINT(1) DEFAULT 0,      -- 0 = off, 1 = on
  `jackpot` TINYINT(1) DEFAULT 0,      -- 0 = off, 1 = on
  `jam_jp` TIME DEFAULT NULL,          -- Menyimpan jam jackpot
  `nomor_telepon` VARCHAR(13),
  `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
  `last_login` DATETIME,
  `ip_address` VARCHAR(45) AFTER last_login;,
  PRIMARY KEY (`id_member`)
);

CREATE TABLE `data_admin` (
  `id_admin` INT(11) NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(30) NOT NULL,
  `password` VARCHAR(255) NOT NULL, -- Gunakan hashing untuk penyimpanan aman
  `nama_lengkap` VARCHAR(100),
  `role` ENUM('superadmin', 'admin', 'moderator') DEFAULT 'admin',
  `status` TINYINT(1) DEFAULT 1, -- 1 = aktif, 0 = nonaktif
  `last_login` DATETIME DEFAULT NULL,
  PRIMARY KEY (`id_admin`)
);

CREATE TABLE `log_aktivitas_admin` (
  `id_log` INT(11) NOT NULL AUTO_INCREMENT,
  `id_admin` INT(11) NOT NULL,
  `aktivitas` TEXT NOT NULL,
  `waktu` DATETIME DEFAULT CURRENT_TIMESTAMP,
  `ip_address` VARCHAR(45) DEFAULT NULL,
  PRIMARY KEY (`id_log`),
  FOREIGN KEY (`id_admin`) REFERENCES `data_admin`(`id_admin`) ON DELETE CASCADE
);

CREATE TABLE traffic_log (
    id INT AUTO_INCREMENT PRIMARY KEY,
    tanggal DATE NOT NULL,
    jumlah INT NOT NULL DEFAULT 1
);

Name	Size	Permission
adminlte	---	0777
assets	---	0777
member	---	0777
.htaccess	42 bytes	0777
all_data.php	24882 bytes	0777
atur_akses.php	3474 bytes	0777
dashboard_admin.php	11051 bytes	0777
database-baru.sql	1542 bytes	0777
edit_admin.php	2224 bytes	0777
error_log	10607 bytes	0777
export_admin.php	659 bytes	0777
export_member_excel.php	1462 bytes	0777
form_register_admin.php	4243 bytes	0777
ganti_password_admin.php	2078 bytes	0777
get_dashboard_chart_data.php	937 bytes	0777
get_member.php	318 bytes	0777
get_member_data.php	1313 bytes	0777
hapus_admin.php	1310 bytes	0777
hapus_member.php	1160 bytes	0777
hapus_semua_member.php	258 bytes	0777
index.php	2592 bytes	0777
kelola_admin.php	9486 bytes	0777
kelola_member.php	13463 bytes	0777
koneksi.php	466 bytes	0777
logout.php	84 bytes	0777
proses_edit_member.php	1163 bytes	0777
proses_ganti_password_admin.php	848 bytes	0777
proses_login_admin.php	2130 bytes	0777
proses_pengaturan_member.php	1875 bytes	0777
proses_tambah_member.php	2690 bytes	0777
proses_tambah_member_admin.php	768 bytes	0777

File Content: database-baru.sql

File Content: `database-baru.sql`