text: -- phpMyAdmin SQL Dump
  -- version 5.1.1
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Waktu pembuatan: 01 Jan 2022 pada 15.45
  -- Versi server: 10.4.20-MariaDB
  -- Versi PHP: 7.3.29
  
  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: `db_gundam`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `keys`
  --
  
  CREATE TABLE `keys` (
    `id` int(11) NOT NULL,
    `user_id` int(11) NOT NULL,
    `key` varchar(40) NOT NULL,
    `level` int(2) NOT NULL,
    `ignore_limits` tinyint(1) NOT NULL DEFAULT 0,
    `is_private_key` tinyint(1) NOT NULL DEFAULT 0,
    `ip_addresses` text DEFAULT NULL,
    `date_created` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data untuk tabel `keys`
  --
  
  INSERT INTO `keys` (`id`, `user_id`, `key`, `level`, `ignore_limits`, `is_private_key`, `ip_addresses`, `date_created`) VALUES
  (1, 1, '123456', 1, 0, 0, '1', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `limits`
  --
  
  CREATE TABLE `limits` (
    `id` int(11) NOT NULL,
    `uri` varchar(255) NOT NULL,
    `count` int(10) NOT NULL,
    `hour_started` int(11) NOT NULL,
    `api_key` varchar(40) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data untuk tabel `limits`
  --
  
  INSERT INTO `limits` (`id`, `uri`, `count`, `hour_started`, `api_key`) VALUES
  (1, 'uri:gundam/index:get', 2, 1640938692, '123456'),
  (2, 'method-name:index_get', 2, 1640938910, '123456'),
  (3, 'api-key:123456', 2, 1640939058, '123456');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `tbl_sample`
  --
  
  CREATE TABLE `tbl_sample` (
    `id` int(11) NOT NULL,
    `nama` varchar(250) NOT NULL,
    `harga` varchar(250) NOT NULL,
    `grade` varchar(100) NOT NULL
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data untuk tabel `tbl_sample`
  --
  
  INSERT INTO `tbl_sample` (`id`, `nama`, `harga`, `grade`) VALUES
  (1, 'ASW-G-8 Barbatos', '635000', 'Master Grade'),
  (4, 'Moon gundam', '350000', 'High Grade'),
  (5, 'RX-93 Nu Gundam', '650000', 'Real Grade');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `tb_gundam`
  --
  
  CREATE TABLE `tb_gundam` (
    `id` int(11) NOT NULL,
    `nama` varchar(255) NOT NULL,
    `harga` int(11) NOT NULL,
    `grade` varchar(20) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data untuk tabel `tb_gundam`
  --
  
  INSERT INTO `tb_gundam` (`id`, `nama`, `harga`, `grade`) VALUES
  (0, 'Moon gundam', 350000, 'High Grade'),
  (1, 'ASW-G-08 Gundam Barbatos', 630000, 'Master Grade'),
  (2, 'GAT-X105 Strike Gundam', 650000, 'Master Grade'),
  (3, 'GN-00-R Gundam 00 Raiser', 420000, 'Real Grade');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indeks untuk tabel `keys`
  --
  ALTER TABLE `keys`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `limits`
  --
  ALTER TABLE `limits`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `tbl_sample`
  --
  ALTER TABLE `tbl_sample`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `tb_gundam`
  --
  ALTER TABLE `tb_gundam`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT untuk tabel yang dibuang
  --
  
  --
  -- AUTO_INCREMENT untuk tabel `keys`
  --
  ALTER TABLE `keys`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT untuk tabel `limits`
  --
  ALTER TABLE `limits`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT untuk tabel `tbl_sample`
  --
  ALTER TABLE `tbl_sample`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  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 */;
  