-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 19, 2022 at 06:42 AM
-- Server version: 10.3.32-MariaDB-cll-lve
-- PHP Version: 7.3.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `u7798619_demo`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `username` varchar(30) NOT NULL,
  `password` varchar(200) NOT NULL,
  `cookie` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `password`, `cookie`) VALUES
(1, 'admin', '$2y$10$SvEPcDZAXzsCo//UdrylxeFzTlH4yv0Qf4rSledPQUBI4F89zsfZO', 'xIDwrvSYgEjiqCeVRbyxTp3mX2kwWvXuNPl68qA8Yg1didQcou0fJ4otf4PmyM9Q');

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

--
-- Table structure for table `bank`
--

CREATE TABLE `bank` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `bank`
--

INSERT INTO `bank` (`id`, `name`) VALUES
(1, 'BCA'),
(2, 'MANDIRI'),
(3, 'BRI'),
(4, 'BNI'),
(5, 'BCA SYARIAH'),
(6, 'BSI'),
(7, 'ATM BERSAMA'),
(8, 'PAYPAL'),
(9, 'JENIUS'),
(10, 'OVO'),
(11, 'DANA'),
(12, 'GOPAY'),
(14, 'BANK JAGO');

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

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `id` int(11) NOT NULL,
  `img` varchar(30) NOT NULL,
  `url` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `banner_popup`
--

CREATE TABLE `banner_popup` (
  `id` int(11) UNSIGNED NOT NULL,
  `img` varchar(30) NOT NULL,
  `delay` int(11) NOT NULL,
  `url` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `icon` varchar(30) NOT NULL,
  `slug` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `color_product`
--

CREATE TABLE `color_product` (
  `id` int(11) NOT NULL,
  `product` int(11) NOT NULL,
  `color` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `coupon`
--

CREATE TABLE `coupon` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `code` varchar(50) NOT NULL,
  `dated` date NOT NULL,
  `min` int(11) NOT NULL,
  `type` int(1) NOT NULL,
  `discount` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `courier`
--

CREATE TABLE `courier` (
  `id` int(11) NOT NULL,
  `pos` int(1) NOT NULL,
  `jne` int(1) NOT NULL,
  `lion` int(1) NOT NULL,
  `ninja` int(1) NOT NULL,
  `ide` int(1) NOT NULL,
  `sicepat` int(1) NOT NULL,
  `sap` int(1) NOT NULL,
  `ncs` int(1) NOT NULL,
  `anteraja` int(1) NOT NULL,
  `rex` int(1) NOT NULL,
  `sc` int(1) NOT NULL,
  `tiki` int(1) NOT NULL,
  `rpx` int(1) NOT NULL,
  `pandu` int(1) NOT NULL,
  `wahana` int(1) NOT NULL,
  `jnt` int(1) NOT NULL,
  `pahala` int(1) NOT NULL,
  `jet` int(1) NOT NULL,
  `slis` int(1) NOT NULL,
  `expedito` int(1) NOT NULL,
  `dse` int(1) NOT NULL,
  `first` int(1) NOT NULL,
  `star` int(1) NOT NULL,
  `idl` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `courier`
--

INSERT INTO `courier` (`id`, `pos`, `jne`, `lion`, `ninja`, `ide`, `sicepat`, `sap`, `ncs`, `anteraja`, `rex`, `sc`, `tiki`, `rpx`, `pandu`, `wahana`, `jnt`, `pahala`, `jet`, `slis`, `expedito`, `dse`, `first`, `star`, `idl`) VALUES
(1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

--
-- Table structure for table `flat_ongkir`
--

CREATE TABLE `flat_ongkir` (
  `id` int(11) NOT NULL,
  `location` varchar(100) NOT NULL,
  `fee` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `footer`
--

CREATE TABLE `footer` (
  `id` int(11) NOT NULL,
  `page` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `footer`
--

INSERT INTO `footer` (`id`, `page`) VALUES
(19, 15),
(20, 14),
(21, 16),
(22, 17);

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

--
-- Table structure for table `general`
--

CREATE TABLE `general` (
  `id` int(11) NOT NULL,
  `app_name` varchar(50) NOT NULL,
  `contact` varchar(20) NOT NULL,
  `logo` varchar(30) NOT NULL,
  `logo-dark` varchar(30) NOT NULL,
  `favicon` varchar(30) NOT NULL,
  `navbar_color` varchar(10) NOT NULL,
  `btncolor` varchar(10) NOT NULL,
  `api_rajaongkir` varchar(70) NOT NULL,
  `social_proof_status` int(1) NOT NULL,
  `pause_social_proof` int(11) NOT NULL,
  `time_social_proof` int(11) NOT NULL,
  `payment_cod_status` int(1) NOT NULL,
  `fee_cod` int(11) NOT NULL,
  `minimal_fee_cod` int(11) NOT NULL,
  `maximal_fee_cod` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `general`
--

INSERT INTO `general` (`id`, `app_name`, `contact`, `logo`, `logo-dark`, `favicon`, `navbar_color`, `btncolor`, `api_rajaongkir`, `social_proof_status`, `pause_social_proof`, `time_social_proof`, `payment_cod_status`, `fee_cod`, `minimal_fee_cod`, `maximal_fee_cod`) VALUES
(1, 'Toko Order', '081234567890', '1603194662693.png', '1602342671558.png', '1602917709094.png', '#6699FF', '#6699FF', 'bc15d2c6b3201e4f47c3c5d92d9328a6', 0, 5, 10, 0, 3, 1000, 20000);

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

--
-- Table structure for table `img_product`
--

CREATE TABLE `img_product` (
  `id` int(20) NOT NULL,
  `id_product` int(11) NOT NULL,
  `img` varchar(200) NOT NULL,
  `ex_img` int(1) NOT NULL,
  `sort` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `invoice`
--

CREATE TABLE `invoice` (
  `id` int(11) NOT NULL,
  `invoice_code` varchar(20) NOT NULL,
  `name` varchar(50) NOT NULL,
  `telp` varchar(20) NOT NULL,
  `regency` int(11) NOT NULL,
  `district` varchar(50) NOT NULL,
  `zipcode` int(11) NOT NULL,
  `address` text NOT NULL,
  `location` varchar(100) NOT NULL,
  `courier` varchar(20) NOT NULL,
  `courier_service` varchar(70) NOT NULL,
  `ongkir` varchar(10) NOT NULL,
  `total_price` int(11) NOT NULL,
  `uniq_number` int(11) NOT NULL,
  `total_all` int(11) NOT NULL,
  `potongan` int(11) NOT NULL,
  `date_input` datetime NOT NULL,
  `dated` date NOT NULL,
  `status` int(1) NOT NULL,
  `resi` varchar(50) NOT NULL,
  `payment` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `logo_payment`
--

CREATE TABLE `logo_payment` (
  `id` int(11) NOT NULL,
  `bca` int(1) NOT NULL,
  `mandiri` int(1) NOT NULL,
  `bri` int(1) NOT NULL,
  `bni` int(1) NOT NULL,
  `bcas` int(1) NOT NULL,
  `bsi` int(1) NOT NULL,
  `atmbersama` int(1) NOT NULL,
  `paypal` int(1) NOT NULL,
  `jenius` int(1) NOT NULL,
  `ovo` int(1) NOT NULL,
  `dana` int(1) NOT NULL,
  `gopay` int(1) NOT NULL,
  `jago` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `logo_payment`
--

INSERT INTO `logo_payment` (`id`, `bca`, `mandiri`, `bri`, `bni`, `bcas`, `bsi`, `atmbersama`, `paypal`, `jenius`, `ovo`, `dana`, `gopay`, `jago`) VALUES
(1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `id` int(11) NOT NULL,
  `page` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`id`, `page`) VALUES
(8, 14),
(9, 15),
(11, 16);

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

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` int(11) NOT NULL,
  `new_order` text NOT NULL,
  `follow_up_1` text NOT NULL,
  `follow_up_2` text NOT NULL,
  `follow_up_3` text NOT NULL,
  `confirmation` text NOT NULL,
  `delivery` text NOT NULL,
  `finish` text NOT NULL,
  `cancel` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `notification`
--

INSERT INTO `notification` (`id`, `new_order`, `follow_up_1`, `follow_up_2`, `follow_up_3`, `confirmation`, `delivery`, `finish`, `cancel`) VALUES
(1, 'Hi kak, saya mau order<div><br></div><div>[detailorder]</div><div><br></div><div>[total]</div><div><br></div><div>-----------------------------------</div><div><br></div><div><b>Nama :</b></div><div>[nama]</div><div><br></div><div><b>Alamat :</b></div><div>[alamat]</div><div>[kecamatan]</div><div><br></div><div><b>Pembayaran :</b></div><div>[rekening]</div><div><br></div><div>Terima Kasih</div>', '<div>Halo kak [nama],&nbsp;<span style=\"font-size: 0.9rem;\">mengingatkan pesanan yang kemarin</span></div><div><div><br></div><div>Mau di transfer lewat BCA atau Mandiri ya kak?</div><div><br></div><div>Agar pesanan segera kami proses hari ini<br></div></div>', 'Oh iya kak, untuk pesanan sebelumnya mau di transfer jam berapa ya<div><br></div><div>Agar pesanan segera kami proses sore hari ini</div>', 'Hi kak [nama],<div>Jika masih ada pertanyaan, jangan ragu hubungi kami</div>', 'Pesanan kamu telah kami konfirmasi dan akan segera di kirim<div><br></div><div><b>Pesanan akan dikirim ke :</b></div><div><br></div><div>Nama : [nama]</div><div>No Hp : [phone]</div><div>Alamat : [alamat]</div><div><br></div><div>Kami akan menghubungi kembali jika produk sudah dikirim.</div><div><br></div><div>Terima kasih,</div><div>Toko Order</div>', 'Pesanan kamu sedang dalam proses pengiriman.<div><br></div><div>Jasa Kurir : [courier]</div><div><br></div><div>Nomor Resi : [resi]</div><div><br></div><div>Order ID : [orderid]</div><div><br></div><div>Lacak Pengiriman : https://tokoorder.com/tracking</div><div><br></div><div><b>Dikirim ke:</b></div><div></div><div>Nama : [nama]</div><div>No HP : [phone]</div><div>Alamat : [alamat]</div><div><br></div><div>Terima kasih,</div><div>Toko Order</div>', 'Terima kasih [nama] sudah berbelanja di toko kami<div><br></div><div>Silakan menghubungi kami, jika ingin pesan produk lainnya.</div><div><br></div><div>Terima Kasih,</div><div>Tokoorder.com</div>', 'Baik kak, kami tidak memaksa, jika tidak jadi order.<div><br></div><div>Oh ya kak, kami juga ada produk lainnya loh,</div><div>Harganya mulai dari 50rb - 100rb, mau lihat kak?</div>');

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `content` text NOT NULL,
  `slug` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `ai_id` int(11) NOT NULL,
  `id` int(20) NOT NULL,
  `title` varchar(100) NOT NULL,
  `category` int(11) NOT NULL,
  `stock` int(11) NOT NULL,
  `weight` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `discount` int(11) NOT NULL,
  `description` text NOT NULL,
  `publish` int(1) NOT NULL,
  `img` varchar(200) NOT NULL,
  `ex_img` int(1) NOT NULL,
  `date_submit` datetime NOT NULL,
  `slug` varchar(110) NOT NULL,
  `transaction` int(11) NOT NULL,
  `viewer` int(11) NOT NULL,
  `variant_name` varchar(30) NOT NULL,
  `wholesaler_count` int(11) NOT NULL,
  `wholesaler_price` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `rating`
--

CREATE TABLE `rating` (
  `id` int(11) UNSIGNED NOT NULL,
  `product` int(11) NOT NULL,
  `star` int(1) NOT NULL,
  `name` varchar(50) NOT NULL,
  `review` text NOT NULL,
  `date_rating` datetime NOT NULL,
  `active` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `rekening`
--

CREATE TABLE `rekening` (
  `id` int(11) NOT NULL,
  `rekening` varchar(100) NOT NULL,
  `name` varchar(50) NOT NULL,
  `number` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `short_desc` text NOT NULL,
  `address` varchar(100) NOT NULL,
  `regency_id` int(11) NOT NULL,
  `chat_help` int(1) NOT NULL,
  `message_chat_help` text NOT NULL,
  `color_chat_help` varchar(20) NOT NULL,
  `wa_admin` varchar(20) NOT NULL,
  `payment_feature` int(1) NOT NULL,
  `uniq_code_feature` int(1) NOT NULL,
  `potongan_feature` int(1) NOT NULL,
  `shipping_feature` int(1) NOT NULL,
  `flatshipping_feature` int(1) NOT NULL,
  `id_pixel` varchar(100) NOT NULL,
  `ga_id` varchar(200) NOT NULL,
  `gs_console` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `short_desc`, `address`, `regency_id`, `chat_help`, `message_chat_help`, `color_chat_help`, `wa_admin`, `payment_feature`, `uniq_code_feature`, `potongan_feature`, `shipping_feature`, `flatshipping_feature`, `id_pixel`, `ga_id`, `gs_console`) VALUES
(1, 'Toko Order adalah online shop berbagai produk yang bisa anda dapatkan langsung via whatsapp dengan harga yang sangat terjangkau.', '', 2096, 0, 'Halo kak', '#44CB78', '', 0, 0, 0, 0, 0, '', '', '');

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

--
-- Table structure for table `sosmed`
--

CREATE TABLE `sosmed` (
  `id` int(11) NOT NULL,
  `name` varchar(20) NOT NULL,
  `icon` varchar(20) NOT NULL,
  `link` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `id` int(11) NOT NULL,
  `id_invoice` varchar(20) NOT NULL,
  `product_name` varchar(100) NOT NULL,
  `price` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `size` varchar(20) NOT NULL,
  `color` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `variant`
--

CREATE TABLE `variant` (
  `id` int(11) NOT NULL,
  `product` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `price` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `wholesaler`
--

CREATE TABLE `wholesaler` (
  `id` int(11) NOT NULL,
  `id_product` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  `price` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`ai_id`);

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `img_product`
--
ALTER TABLE `img_product`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=132;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `ai_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `wholesaler`
--
ALTER TABLE `wholesaler`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75;
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 */;
