-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Waktu pembuatan: 30 Jun 2026 pada 17.49
-- Versi server: 10.11.17-MariaDB-cll-lve
-- Versi PHP: 8.4.21

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: `davinid_banamor`
--

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

--
-- Struktur dari tabel `direct`
--

CREATE TABLE `direct` (
  `id` int(11) NOT NULL,
  `target` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `url` varchar(100) NOT NULL,
  `click` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `direct`
--

INSERT INTO `direct` (`id`, `target`, `name`, `url`, `click`) VALUES
(1, 'logo', 'Logo', 'https://banamor.my.id/favicon.png', 0),
(2, 'instagram', 'Instagram', 'https://instagram.com/banamor.delight', 58),
(3, 'facebook', 'Facebook', 'https://www.facebook.com/profile.php?id=61556914980502&sk=about', 0),
(4, 'qris', 'Qris', 'https://banamor.my.id/assets/images/payment/qris.png', 0),
(5, 'x', 'X', 'https://x.com/banamordelight', 0),
(6, 'twitter', 'Twitter', 'https://twitter.com/banamordelight', 0),
(7, 'threads', 'Threads', 'https://threads.net/banamordelight', 0),
(8, 'tiktok', 'Tiktok', 'https://tiktok.com/@banamordelight', 45),
(9, 'filterinstagram', 'Filter Instagram', 'https://www.instagram.com/ar/451038064020526/', 16);

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

--
-- Struktur dari tabel `pesanan`
--

CREATE TABLE `pesanan` (
  `id` int(11) NOT NULL,
  `nama` varchar(256) NOT NULL,
  `whatsapp` varchar(256) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `pesanan`
--

INSERT INTO `pesanan` (`id`, `nama`, `whatsapp`, `date`, `time`) VALUES
(1, 'Tes', '081806993369', '2024-03-15', '01:17:21'),
(2, 'Tes 2v9-1', '081806993369', '2024-03-15', '01:27:06'),
(3, 'Panji', '082234494234', '2024-04-22', '20:24:36'),
(4, 'Azka', '085939271055', '2024-04-22', '20:25:26'),
(5, 'Azka', '6285939271055', '2024-05-01', '15:27:28'),
(6, 'Azka', '6285939271055', '2024-05-01', '15:27:34'),
(7, 'Azka', '6285939271055', '2024-05-01', '15:31:31'),
(8, 'Azka', '6285939271055', '2024-05-01', '15:31:36'),
(9, 'Davin', '085156493669', '2024-05-01', '20:30:25'),
(10, 'Davin', '085156493669', '2024-05-01', '20:36:23'),
(11, 'Eldwin Fikhar Ananda', '081225627630', '2024-05-02', '06:37:59'),
(12, 'Aliya', '089650512854', '2024-05-16', '16:14:42'),
(13, 'Davin', '081806993369', '2024-05-16', '21:17:23'),
(14, 'DEMANG', '081213141516', '2024-05-24', '20:42:25'),
(15, '::::;++! $() ', '79464649464984649499464', '2024-05-24', '20:43:31'),
(16, 'Gatau males', '085156493669', '2024-05-24', '20:44:08'),
(17, 'Bebas', '085156493669', '2024-05-24', '20:44:56'),
(18, 'Farhan Rifqi Fauzi', '081315065393', '2024-05-24', '21:16:14');

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

--
-- Struktur dari tabel `transaction`
--

CREATE TABLE `transaction` (
  `id` int(11) NOT NULL,
  `order_id` varchar(200) NOT NULL,
  `amount` varchar(200) NOT NULL,
  `transaction_time` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Struktur dari tabel `whatsapp`
--

CREATE TABLE `whatsapp` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `url` varchar(200) NOT NULL,
  `apikey` varchar(200) NOT NULL,
  `sender` varchar(200) NOT NULL,
  `notification` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data untuk tabel `whatsapp`
--

INSERT INTO `whatsapp` (`id`, `name`, `url`, `apikey`, `sender`, `notification`) VALUES
(1, 'Davin', 'https://davin.gateaway.my.id/send-message', 'vkjeCoQq3uy8sHrRALVUNTxpDvZk3d3P', '6285179794603', '6285156493669');

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `direct`
--
ALTER TABLE `direct`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `pesanan`
--
ALTER TABLE `pesanan`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `transaction`
--
ALTER TABLE `transaction`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `whatsapp`
--
ALTER TABLE `whatsapp`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `direct`
--
ALTER TABLE `direct`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT untuk tabel `pesanan`
--
ALTER TABLE `pesanan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT untuk tabel `transaction`
--
ALTER TABLE `transaction`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `whatsapp`
--
ALTER TABLE `whatsapp`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
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 */;