-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 09, 2026 at 01:40 PM
-- Server version: 11.4.9-MariaDB-cll-lve
-- PHP Version: 8.4.17

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


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

--
-- Database: `mdcc5937_mdc`
--

-- --------------------------------------------------------

--
-- Table structure for table `assign`
--

CREATE TABLE `assign` (
  `id` int(11) NOT NULL,
  `week` int(11) DEFAULT NULL,
  `role` varchar(100) DEFAULT NULL,
  `person_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `assign`
--

INSERT INTO `assign` (`id`, `week`, `role`, `person_id`) VALUES
(2, 5, 'WL', 2),
(3, 5, 'WL', 3),
(8, 1, 'Singer', 3),
(10, 1, 'PC', 4),
(11, 1, 'PC', 5),
(12, 1, 'PC', 8),
(16, 1, 'Door Pagi', 6),
(17, 1, 'Door Pagi', 7),
(18, 1, 'Gitar Listrik', 9),
(19, 1, 'WL', 1),
(20, 1, 'WL', 2),
(21, 1, 'WL', 9),
(22, 1, 'Keyboard 2', 9);

-- --------------------------------------------------------

--
-- Table structure for table `assignyt`
--

CREATE TABLE `assignyt` (
  `id` int(11) NOT NULL,
  `week` int(11) DEFAULT NULL,
  `role` varchar(100) DEFAULT NULL,
  `person_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `assignyt`
--

INSERT INTO `assignyt` (`id`, `week`, `role`, `person_id`) VALUES
(2, 5, 'WL', 2),
(3, 5, 'WL', 3),
(8, 1, 'Singer', 3),
(16, 1, 'Door Pagi', 6),
(17, 1, 'Door Pagi', 7),
(18, 1, 'Gitar Listrik', 9),
(19, 1, 'WL', 1),
(20, 1, 'WL', 2),
(21, 1, 'WL', 9),
(22, 1, 'Keyboard 2', 9),
(23, 1, 'PC', 10);

-- --------------------------------------------------------

--
-- Table structure for table `catatan`
--

CREATE TABLE `catatan` (
  `id` int(11) NOT NULL,
  `youtube_link` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `catatan`
--

INSERT INTO `catatan` (`id`, `youtube_link`, `title`, `description`, `notes`, `created_at`) VALUES
(14, 'https://www.youtube.com/embed/5-GkvVm9y7k?si=Z1nZsWu7Tzs17fk8', 'Ibadah Minggu : Hidup yg Berdampak, 08 Februari 2026', 'JURUSELAMAT, MESIAS & TUHAN\r\n\r\nBaca: LUKAS 2:8-20\r\n\"Hari ini telah lahir bagimu Juruselamat, yaitu Mesias, Tuhan, di kota Daud.\" (Lukas 2:11)\r\n\r\nMembaca Alkitab dengan teliti dapat membawa kita menemukan hal-hal yang mungkin selama ini terlewatkan. Ada rincian dari peristiwa tertentu, yang jika tidak dicermati akan terlewat begitu saja dari pengamatan dan pemahaman kita. Saya pun kerap mengalami hal itu, termasuk ketika selama beberapa waktu saya melewatkan detail informasi tentang kabar sukacita yang diterima oleh para gembala saat kelahiran bayi Yesus, yang dibarengi oleh paduan suara surgawi yang tentunya sangat merdu itu.\r\n\r\nAda tiga identitas tentang Yesus yang disampaikan kepada para gembala, yakni Juru Selamat, Mesias (Pribadi Yang Diurapi Allah), dan Tuhan (Penguasa Tunggal atas kehidupan manusia). Menarik sekali bahwa malaikat tidak menyebutkan nama \"Yesus\" kepada para gembala, tetapi justru menyebutkan tiga identitas tadi. Tampaknya pesan yang terdengar berbeda ini sengaja disampaikan, demi menegaskan pribadi Yesus yang ditentukan Allah untuk menyelamatkan manusia dari dosa-dosa mereka, Yang Diurapi Allah untuk melakukan pekerjaan-pekerjaan ajaib, dan kelak Ia akan menjadi Tuhan atas segala yang hidup.\r\n\r\nAllah tentu memiliki alasan soal pemilihan para gembala sebagai kelompok penerima pesan yang mulia itu, meskipun tidak secara eksplisit disebutkan. Namun, bagi kita \"penerima pesan\" melalui tulisan dari Rasul Lukas, kini kita tak hanya mengerti, tetapi juga bersyukur karena Pribadi yang menjadi objek pemberitaan para malaikat, kini berdiam dalam hati kita, sejak kita menerima Yesus sebagai Tuhan dan Juru Selamat pribadi kita.\r\n\r\nPENGENALAN AKAN PRIBADI YESUS PERLU TERUS DIKOBARKAN SETIAP HARI', 'Ibadah Online GKPB MDC Jombang.\r\n\r\nbagi Bpk/Ibu/Sdr/i yang rindu memberikan persembahan dapat Transfer melalui Bank BCA:\r\n\r\nPersembahan Syukur\r\nNo Rek: 1130446562\r\nAn. Eddy Kusmayadi dan Tutik Eliyatie Gunadi\r\n\r\nPersembahan Persepuluhan\r\nNo Rek: 1130174643\r\nAn. Eddy Kusmayadi dan Tutik Eliyatie Gunadi\r\n\r\nPersembahan Khusus\r\nNo Rek: 1130446546\r\nAn. Eddy Kusmayadi dan Tutik Eliyatie Gunadi\r\n\r\nSelamat Beribadah, Tuhan Yesus Memberkati', '2025-03-07 10:19:34');

-- --------------------------------------------------------

--
-- Table structure for table `division_names`
--

CREATE TABLE `division_names` (
  `id` int(11) NOT NULL,
  `division` varchar(50) NOT NULL,
  `name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `division_names`
--

INSERT INTO `division_names` (`id`, `division`, `name`) VALUES
(1, 'leader', 'Sdri. Melati'),
(2, 'leader', 'Sdri. Yesika'),
(3, 'leader', 'Ibu Yohana'),
(4, 'leader', 'Bpk. Christian'),
(5, 'leader', 'Ibu Silvia'),
(6, 'singer', 'Sdri. Astutik'),
(7, 'singer', 'Ibu Yohana'),
(8, 'singer', 'Ibu Titian'),
(9, 'singer', 'Ibu Evi'),
(10, 'keyboard', 'Sdri. Vani'),
(11, 'keyboard', 'Sdr. Freddy'),
(12, 'keyboard', 'Bpk. Christian'),
(13, 'guitar', 'Bpk. Christian'),
(14, 'guitar', 'Sdr. Freddy'),
(15, 'bass', 'Bpk. Christian'),
(16, 'bass', 'Bpk. Anang'),
(17, 'drum', 'Sdr. Arya'),
(18, 'drum', 'Bpk. Christian'),
(19, 'drum', 'Bpk. Sandy'),
(20, 'drum', 'Ibu Yohana'),
(21, 'manager', 'Ibu Yohana'),
(22, 'manager', 'Bpk. Christian'),
(23, 'manager', 'Sdr. Freddy'),
(24, 'manager', 'Sdri. Vani'),
(25, 'manager', 'Sdri. Astutik'),
(26, 'lighting', 'Sdri. Vani'),
(27, 'lighting', 'Bpk. Christian'),
(28, 'lighting', 'Sdri. Seteven'),
(29, 'multimedia', 'Bpk. Ivan'),
(30, 'multimedia', 'Sdri. Vani'),
(31, 'multimedia', 'Bpk. Christian'),
(32, 'multimedia', 'Sdri. Seteven'),
(33, 'multimedia', 'Ibu Silvia'),
(34, 'kamera', 'Sdri. Vani'),
(35, 'kamera', 'Bpk. Christian'),
(36, 'kamera', 'Ibu Silvia'),
(37, 'kamera', 'Ibu Yohana');

-- --------------------------------------------------------

--
-- Table structure for table `kehadiran`
--

CREATE TABLE `kehadiran` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(255) NOT NULL,
  `wa` varchar(20) NOT NULL,
  `gender` varchar(20) NOT NULL,
  `gereja` varchar(100) NOT NULL,
  `alamat` text NOT NULL,
  `scan_time` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `kehadiran`
--

INSERT INTO `kehadiran` (`id`, `nama`, `wa`, `gender`, `gereja`, `alamat`, `scan_time`) VALUES
(1, 'SCARDFLASHER', '+6282132687740', 'Pria', 'GKI', 'Oke', '2025-10-15 13:59:02');

-- --------------------------------------------------------

--
-- Table structure for table `latihan`
--

CREATE TABLE `latihan` (
  `id` int(11) NOT NULL,
  `hari` varchar(20) DEFAULT NULL,
  `jam` varchar(10) DEFAULT NULL,
  `aktif` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `latihan`
--

INSERT INTO `latihan` (`id`, `hari`, `jam`, `aktif`) VALUES
(6, 'Selasa', '20.00', 1);

-- --------------------------------------------------------

--
-- Table structure for table `latihanyt`
--

CREATE TABLE `latihanyt` (
  `id` int(11) NOT NULL,
  `hari` varchar(20) DEFAULT NULL,
  `jam` varchar(10) DEFAULT NULL,
  `aktif` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `latihanyt`
--

INSERT INTO `latihanyt` (`id`, `hari`, `jam`, `aktif`) VALUES
(6, 'Selasa', '20.00', 1);

-- --------------------------------------------------------

--
-- Table structure for table `outfits`
--

CREATE TABLE `outfits` (
  `id` int(11) NOT NULL,
  `week` int(11) DEFAULT NULL,
  `filename` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `outfits`
--

INSERT INTO `outfits` (`id`, `week`, `filename`) VALUES
(3, 4, '1770110936_7109_1000125513.jpg'),
(4, 4, '1770110979_6708_1000126547.jpg'),
(6, 1, '1770618287_4521_1000131257.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `outfitsyt`
--

CREATE TABLE `outfitsyt` (
  `id` int(11) NOT NULL,
  `week` int(11) DEFAULT NULL,
  `filename` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `outfitsyt`
--

INSERT INTO `outfitsyt` (`id`, `week`, `filename`) VALUES
(3, 4, '1770110936_7109_1000125513.jpg'),
(4, 4, '1770110979_6708_1000126547.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `people`
--

CREATE TABLE `people` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `division` enum('Worship','Multimedia','Usher') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `people`
--

INSERT INTO `people` (`id`, `name`, `division`) VALUES
(1, 'Andre', 'Worship'),
(2, 'Maria', 'Worship'),
(4, 'Sinta', 'Multimedia'),
(5, 'Dewi', 'Multimedia'),
(6, 'Yohan', 'Usher'),
(7, 'Anton', 'Usher'),
(9, 'Yulia ', 'Worship'),
(10, 'Rio', 'Multimedia');

-- --------------------------------------------------------

--
-- Table structure for table `peopleyt`
--

CREATE TABLE `peopleyt` (
  `id` int(11) NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `division` enum('Worship','Multimedia','Usher') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `peopleyt`
--

INSERT INTO `peopleyt` (`id`, `name`, `division`) VALUES
(1, 'Andre', 'Worship'),
(2, 'Maria', 'Worship'),
(4, 'Sinta', 'Multimedia'),
(5, 'Dewi', 'Multimedia'),
(6, 'Yohan', 'Usher'),
(7, 'Anton', 'Usher'),
(9, 'Yulia ', 'Worship'),
(10, 'Rio', 'Multimedia');

-- --------------------------------------------------------

--
-- Table structure for table `songs`
--

CREATE TABLE `songs` (
  `id` int(11) NOT NULL,
  `week` int(11) DEFAULT NULL,
  `title` varchar(150) DEFAULT NULL,
  `youtube` text DEFAULT NULL,
  `sequencer` text DEFAULT NULL,
  `lyrics` text DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `songs`
--

INSERT INTO `songs` (`id`, `week`, `title`, `youtube`, `sequencer`, `lyrics`, `ordering`) VALUES
(1, 1, 'Yesus mulai ', 'https://youtu.be/oGbTZ9M7qFA?si=Sk8ocWo2eWwVVY-N', 'https://youtu.be/JX5u-losXUQ?si=9uUiEVHn2WJcOwLY', 'Kurasakan asik', 1),
(2, 1, 'Oke', 'Link', 'Qku', 'Cara ', 2);

-- --------------------------------------------------------

--
-- Table structure for table `songsyt`
--

CREATE TABLE `songsyt` (
  `id` int(11) NOT NULL,
  `week` int(11) DEFAULT NULL,
  `title` varchar(150) DEFAULT NULL,
  `youtube` text DEFAULT NULL,
  `sequencer` text DEFAULT NULL,
  `lyrics` text DEFAULT NULL,
  `ordering` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `songsyt`
--

INSERT INTO `songsyt` (`id`, `week`, `title`, `youtube`, `sequencer`, `lyrics`, `ordering`) VALUES
(1, 1, 'Yesus mulai ', 'https://youtu.be/oGbTZ9M7qFA?si=Sk8ocWo2eWwVVY-N', 'https://youtu.be/JX5u-losXUQ?si=9uUiEVHn2WJcOwLY', 'Kurasakan asik', 1),
(2, 1, 'Oke', 'Link', 'Qku', 'Cara ', 2),
(3, 1, 'Iqjq', 'Jj', 'Qj', 'I', 3);

-- --------------------------------------------------------

--
-- Table structure for table `youth_registrations`
--

CREATE TABLE `youth_registrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(255) NOT NULL,
  `whatsapp` varchar(20) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `gereja` varchar(100) NOT NULL,
  `alamat` text NOT NULL,
  `registered_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `youth_registrations`
--

INSERT INTO `youth_registrations` (`id`, `nama`, `whatsapp`, `gender`, `gereja`, `alamat`, `registered_at`) VALUES
(1, 'SCARDFLASHER', '+6282132687740', 'Pria', 'GPIB', 'Okwn', '2025-10-15 09:04:04'),
(3, 'SCARDFLASHER', '+6282132687746', 'Pria', 'GKI', 'Ahha', '2025-10-15 09:09:26'),
(4, 'SCARDFLASHER', '+6282132687749', 'Pria', 'GSJA', 'Jombang', '2025-10-15 14:04:23');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `assign`
--
ALTER TABLE `assign`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `assignyt`
--
ALTER TABLE `assignyt`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `catatan`
--
ALTER TABLE `catatan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `division_names`
--
ALTER TABLE `division_names`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kehadiran`
--
ALTER TABLE `kehadiran`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_wa` (`wa`),
  ADD KEY `idx_scan_time` (`scan_time`);

--
-- Indexes for table `latihan`
--
ALTER TABLE `latihan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `latihanyt`
--
ALTER TABLE `latihanyt`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `outfits`
--
ALTER TABLE `outfits`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `outfitsyt`
--
ALTER TABLE `outfitsyt`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `people`
--
ALTER TABLE `people`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `peopleyt`
--
ALTER TABLE `peopleyt`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `songs`
--
ALTER TABLE `songs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `songsyt`
--
ALTER TABLE `songsyt`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `youth_registrations`
--
ALTER TABLE `youth_registrations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_whatsapp` (`whatsapp`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `assign`
--
ALTER TABLE `assign`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `assignyt`
--
ALTER TABLE `assignyt`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `catatan`
--
ALTER TABLE `catatan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `division_names`
--
ALTER TABLE `division_names`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `kehadiran`
--
ALTER TABLE `kehadiran`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `latihan`
--
ALTER TABLE `latihan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `latihanyt`
--
ALTER TABLE `latihanyt`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `outfits`
--
ALTER TABLE `outfits`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `outfitsyt`
--
ALTER TABLE `outfitsyt`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `people`
--
ALTER TABLE `people`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `peopleyt`
--
ALTER TABLE `peopleyt`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `songs`
--
ALTER TABLE `songs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `songsyt`
--
ALTER TABLE `songsyt`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `youth_registrations`
--
ALTER TABLE `youth_registrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

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