-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `digimaxoto_ordersystem2022dev`
--

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

--
-- Table structure for table `doto_ho_appauthorization`
--

CREATE TABLE `doto_ho_appauthorization` (
  `appauthid` int NOT NULL,
  `appgroupid` int UNSIGNED NOT NULL,
  `appmenuid` int UNSIGNED NOT NULL,
  `semua` tinyint UNSIGNED NOT NULL COMMENT '0 = tidak ; 1 = iya',
  `baca` tinyint UNSIGNED NOT NULL COMMENT '0 = tidak ; 1 = iya',
  `tambah` tinyint UNSIGNED NOT NULL COMMENT '0 = tidak ; 1 = iya',
  `edit` tinyint UNSIGNED NOT NULL COMMENT '0 = tidak ; 1 = iya',
  `hapus` tinyint UNSIGNED NOT NULL COMMENT '0 = tidak ; 1 = iya'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_ho_appauthorization`
--

INSERT INTO `doto_ho_appauthorization` (`appauthid`, `appgroupid`, `appmenuid`, `semua`, `baca`, `tambah`, `edit`, `hapus`) VALUES
(1, 2, 51, 1, 1, 1, 1, 1);

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

--
-- Table structure for table `doto_ho_appauthorizationapproval`
--

CREATE TABLE `doto_ho_appauthorizationapproval` (
  `appauthid` int UNSIGNED NOT NULL,
  `appgroupid` int UNSIGNED NOT NULL,
  `appmenuid` int UNSIGNED NOT NULL,
  `semua` tinyint UNSIGNED NOT NULL COMMENT '1 = iya ; 2 = tidak',
  `baca` tinyint UNSIGNED NOT NULL,
  `tambah` tinyint UNSIGNED NOT NULL,
  `edit` tinyint UNSIGNED NOT NULL,
  `hapus` tinyint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `doto_ho_appmenu`
--

CREATE TABLE `doto_ho_appmenu` (
  `appmenuid` int UNSIGNED NOT NULL,
  `appmenuname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `appmenulink` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `parentid` tinyint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_ho_appmenu`
--

INSERT INTO `doto_ho_appmenu` (`appmenuid`, `appmenuname`, `appmenulink`, `parentid`) VALUES
(11, 'Group Admin', 'user_group.php', 1),
(12, 'Staff Admin', 'user_manager.php', 1),
(21, 'Kanal Penjualan', 'kanal_manager.php', 0),
(22, 'Kota', 'kota_manager.php', 0),
(23, 'Propinsi', 'propinsi_manager.php', 0),
(24, 'Area', 'area_manager.php', 0),
(25, 'Merek Produk', 'merek_manager.php', 2),
(26, 'Model Produk', 'model_manager.php', 2),
(27, 'Item Produk', 'item_manager.php', 2),
(28, 'Wilayah OTR', 'wilayah_manager.php', 2),
(29, 'Distribusi Item', 'distribusi_manager.php', 2),
(31, 'Rekanan', 'rekanan_manager.php', 3),
(32, 'User Rekanan', 'rekanan_user_manager.php', 0),
(33, 'Toko', 'toko_manager.php', 3),
(41, 'Pesanan', 'order_manager.php', 4),
(42, 'Pembayaran', 'payment_manager.php', 4),
(43, 'Voucher', 'voucher_manager.php', 4),
(51, 'Unduh Laporan', 'fullreport_xl.php', 5);

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

--
-- Table structure for table `doto_ho_appuser`
--

CREATE TABLE `doto_ho_appuser` (
  `userid` int UNSIGNED NOT NULL,
  `fullname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `userpass` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `useremail` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `usergroupid` int UNSIGNED NOT NULL,
  `operationarea` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `registrationdate` datetime NOT NULL,
  `lastlogin` datetime DEFAULT NULL,
  `accessstatus` smallint NOT NULL DEFAULT '0',
  `lastchangepassword` datetime DEFAULT NULL,
  `wrongpassword` smallint NOT NULL DEFAULT '0',
  `statusaktivasi` tinyint UNSIGNED NOT NULL,
  `logintime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_ho_appuser`
--

INSERT INTO `doto_ho_appuser` (`userid`, `fullname`, `username`, `userpass`, `useremail`, `usergroupid`, `operationarea`, `registrationdate`, `lastlogin`, `accessstatus`, `lastchangepassword`, `wrongpassword`, `statusaktivasi`, `logintime`) VALUES
(1, 'Admin Pusat', 'admdoto', '2a9d119df47ff993b662a8ef36f9ea20', 'info@digimaxoto.com', 1, 'Kantor Pusat', '2011-02-22 11:54:37', '2023-05-26 08:27:04', 1, '2018-11-17 00:00:00', 0, 1, '2023-05-26 08:58:24'),
(2, 'Admin Sales', 'admsales', '2a9d119df47ff993b662a8ef36f9ea20', 'candra@dmmgroup.id', 2, NULL, '2023-04-22 00:00:00', '2023-05-26 18:48:32', 1, NULL, 0, 1, '2023-05-26 18:55:55');

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

--
-- Table structure for table `doto_ho_appuserapproval`
--

CREATE TABLE `doto_ho_appuserapproval` (
  `userid` int UNSIGNED NOT NULL,
  `currentuserid` int NOT NULL,
  `fullname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `userpass` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `useremail` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `usergroupid` int UNSIGNED NOT NULL,
  `operationarea` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `registrationdate` datetime NOT NULL,
  `accessstatus` smallint NOT NULL DEFAULT '0',
  `statusaktivasi` tinyint UNSIGNED NOT NULL COMMENT '0 = belum aktivasi ; 1 = sudah aktivasi',
  `sesiaktivasi` varchar(200) NOT NULL,
  `statusdisclaimer` tinyint UNSIGNED NOT NULL COMMENT '0 = belum setuju ; 1 = sudah setuju',
  `userdelete` smallint DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `doto_ho_appusergroup`
--

CREATE TABLE `doto_ho_appusergroup` (
  `usergroupid` int UNSIGNED NOT NULL,
  `usergroupname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_ho_appusergroup`
--

INSERT INTO `doto_ho_appusergroup` (`usergroupid`, `usergroupname`) VALUES
(2, 'SALES ADMIN');

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

--
-- Table structure for table `doto_ho_appusergroupapproval`
--

CREATE TABLE `doto_ho_appusergroupapproval` (
  `usergroupid` int UNSIGNED NOT NULL,
  `currentgroupid` int UNSIGNED NOT NULL,
  `usergroupname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `insertdate` datetime NOT NULL,
  `groupdelete` smallint UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `doto_ho_banktujuanbayar`
--

CREATE TABLE `doto_ho_banktujuanbayar` (
  `idbanktujuanbayar` tinyint UNSIGNED NOT NULL,
  `namabank` varchar(25) NOT NULL,
  `norekening` varchar(25) NOT NULL,
  `namapemilik` varchar(50) NOT NULL,
  `inputoleh` varchar(25) NOT NULL,
  `inputtgl` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `doto_ho_carabayarlunas`
--

CREATE TABLE `doto_ho_carabayarlunas` (
  `idcarabayarlunas` int UNSIGNED NOT NULL,
  `jenispembayaranlunas` varchar(25) NOT NULL,
  `namacarabayarlunas` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `aktif` tinyint UNSIGNED DEFAULT NULL COMMENT 'NULL = tidak aktif ; 1 = aktif',
  `logoicon` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_ho_carabayarlunas`
--

INSERT INTO `doto_ho_carabayarlunas` (`idcarabayarlunas`, `jenispembayaranlunas`, `namacarabayarlunas`, `aktif`, `logoicon`) VALUES
(1, 'Tunai', 'BCA 3198880088 a/n PT DIGITAL CONSUMER ENGAGEMENT', 1, 'bca.png'),
(2, 'Transfer Bank', 'BRI 1234567890 a/n PT DIGITAL CONSUMER ENGAGEMENT', NULL, 'bri.png'),
(3, 'Kredit 12 Bulan', 'ADIRA FINANCE', 1, 'adira.png'),
(4, 'Kredit 24 Bulan', 'ADIRA FINANCE', 1, 'adira.png'),
(5, 'Kredit 36 Bulan', 'ADIRA FINANCE', 1, 'adira.png'),
(6, 'Multi Payment', 'e-wallet, transfer bank, virtual account, dan lain-lain', NULL, NULL);

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

--
-- Table structure for table `doto_ho_carabayartandajadi`
--

CREATE TABLE `doto_ho_carabayartandajadi` (
  `idcarabayartandajadi` tinyint UNSIGNED NOT NULL,
  `namacarabayartandajadi` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_ho_carabayartandajadi`
--

INSERT INTO `doto_ho_carabayartandajadi` (`idcarabayartandajadi`, `namacarabayartandajadi`) VALUES
(1, 'E-WALLET GOPAY-QRIS'),
(2, 'E-WALLET GOPAY'),
(3, ' '),
(4, 'E-WALLET OVO');

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

--
-- Table structure for table `doto_ho_channel`
--

CREATE TABLE `doto_ho_channel` (
  `idchannel` int UNSIGNED NOT NULL,
  `namachannel` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_ho_channel`
--

INSERT INTO `doto_ho_channel` (`idchannel`, `namachannel`) VALUES
(1, 'DMMX'),
(2, 'Toko Kelontong SRC'),
(4, 'Aplikasi Dropper');

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

--
-- Table structure for table `doto_ho_disclaimer`
--

CREATE TABLE `doto_ho_disclaimer` (
  `iddisclaimer` int UNSIGNED NOT NULL,
  `isidisclaimer` text NOT NULL,
  `tgldisclaimer` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_ho_disclaimer`
--

INSERT INTO `doto_ho_disclaimer` (`iddisclaimer`, `isidisclaimer`, `tgldisclaimer`) VALUES
(1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec lectus nisi, fermentum non semper ac, accumsan tempor ex. Pellentesque ultrices ipsum sed volutpat ultricies. Ut convallis tortor felis, a consequat ex mollis scelerisque. Phasellus semper placerat quam eu condimentum. Aenean non efficitur eros, in bibendum tortor. Vivamus turpis nisl, venenatis sit amet imperdiet eget, porttitor et nisl. Nunc massa sapien, mollis sed elementum eu, molestie sed felis. Donec ac tellus placerat, faucibus urna ac, aliquet mauris. Quisque a erat placerat, luctus justo auctor, dignissim ante. Fusce finibus finibus nunc, sed ullamcorper odio condimentum mattis. Aliquam erat volutpat. Vestibulum vel felis et dui semper luctus vitae eu nulla. Maecenas sodales, libero sit amet sodales ultrices, leo augue mollis mi, at sollicitudin dolor massa semper sapien. In non justo eu quam gravida vestibulum in vel arcu. Mauris sem felis, tempus at hendrerit non, ultricies vitae risus.', '2023-01-27');

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

--
-- Table structure for table `doto_ho_download`
--

CREATE TABLE `doto_ho_download` (
  `idfile` int UNSIGNED NOT NULL,
  `iditem` int UNSIGNED NOT NULL,
  `filetitle` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `urlfile` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `filedate` date NOT NULL,
  `jumlahdownload` int UNSIGNED NOT NULL,
  `ukuranfile` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `doto_ho_item`
--

CREATE TABLE `doto_ho_item` (
  `iditem` bigint UNSIGNED NOT NULL,
  `nomorsku` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `idkategoribarang` smallint UNSIGNED NOT NULL,
  `idmerek` int UNSIGNED NOT NULL,
  `idmodel` int UNSIGNED NOT NULL,
  `idwarna` int UNSIGNED NOT NULL,
  `idthnproduksi` int UNSIGNED NOT NULL,
  `tersedia` tinyint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `doto_ho_item`
--

INSERT INTO `doto_ho_item` (`iditem`, `nomorsku`, `idkategoribarang`, `idmerek`, `idmodel`, `idwarna`, `idthnproduksi`, `tersedia`) VALUES
(1, '10101010123', 1, 1, 1, 1, 2, 1),
(2, '10101010223', 1, 1, 1, 2, 2, 1),
(3, '10101010323', 1, 1, 1, 3, 2, 1),
(4, '10101010423', 1, 1, 1, 4, 2, 1),
(5, '10101010523', 1, 1, 1, 5, 2, 1),
(6, '10101010623', 1, 1, 1, 6, 2, 1),
(7, '10101020123', 1, 1, 2, 1, 2, 1),
(8, '10101020223', 1, 1, 2, 2, 2, 1),
(9, '10101020323', 1, 1, 2, 3, 2, 1),
(10, '10101020423', 1, 1, 2, 4, 2, 1),
(11, '10101020523', 1, 1, 2, 5, 2, 1),
(12, '10101020623', 1, 1, 2, 6, 2, 1),
(13, '10101030123', 1, 1, 3, 1, 2, 1),
(14, '10101030223', 1, 1, 3, 2, 2, 1),
(15, '10101030323', 1, 1, 3, 3, 2, 1),
(16, '10101030423', 1, 1, 3, 4, 2, 1),
(17, '10101030523', 1, 1, 3, 5, 2, 1),
(18, '10101030623', 1, 1, 3, 6, 2, 1),
(19, '10101040123', 1, 1, 4, 1, 2, 1),
(20, '10101040223', 1, 1, 4, 2, 2, 1),
(21, '10101040323', 1, 1, 4, 3, 2, 1),
(22, '10101040423', 1, 1, 4, 4, 2, 1),
(23, '10101040523', 1, 1, 4, 5, 2, 1),
(24, '10101040623', 1, 1, 4, 6, 2, 1),
(25, '10101050723', 1, 1, 5, 7, 2, 1),
(26, '10101050823', 1, 1, 5, 8, 2, 1),
(27, '10101050923', 1, 1, 5, 9, 2, 1),
(28, '10101060723', 1, 1, 6, 7, 2, 1),
(29, '10101060823', 1, 1, 6, 8, 2, 1),
(30, '10101060923', 1, 1, 6, 9, 2, 1),
(31, '10101070723', 1, 1, 7, 7, 2, 1),
(32, '10101070823', 1, 1, 7, 8, 2, 1),
(33, '10101070923', 1, 1, 7, 9, 2, 1),
(34, '10101080723', 1, 1, 8, 7, 2, 1),
(35, '10101080823', 1, 1, 8, 8, 2, 1),
(36, '10101080923', 1, 1, 8, 9, 2, 1),
(37, '10101091023', 1, 1, 9, 10, 2, 1),
(38, '10101091123', 1, 1, 9, 11, 2, 1),
(39, '10101091223', 1, 1, 9, 12, 2, 1),
(40, '10101101023', 1, 1, 10, 10, 2, 1),
(41, '10101101123', 1, 1, 10, 11, 2, 1),
(42, '10101101223', 1, 1, 10, 12, 2, 1),
(43, '10101111023', 1, 1, 11, 10, 2, 1),
(44, '10101111123', 1, 1, 11, 11, 2, 1),
(45, '10101111223', 1, 1, 11, 12, 2, 1),
(46, '10101121023', 1, 1, 12, 10, 2, 1),
(47, '10101121123', 1, 1, 12, 11, 2, 1),
(48, '10101121223', 1, 1, 12, 12, 2, 1);

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

--
-- Table structure for table `doto_ho_itemprice`
--

CREATE TABLE `doto_ho_itemprice` (
  `iditemprice` bigint UNSIGNED NOT NULL,
  `iditem` int UNSIGNED DEFAULT NULL,
  `idmodel` int UNSIGNED DEFAULT NULL,
  `idwilayahotr` int UNSIGNED NOT NULL,
  `idthnproduksi` int UNSIGNED DEFAULT NULL,
  `ontheroad` double(12,0) UNSIGNED DEFAULT NULL,
  `hargajual` double(12,0) UNSIGNED NOT NULL,
  `tglinput` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `doto_ho_itemprice`
--

INSERT INTO `doto_ho_itemprice` (`iditemprice`, `iditem`, `idmodel`, `idwilayahotr`, `idthnproduksi`, `ontheroad`, `hargajual`, `tglinput`) VALUES
(1, NULL, 1, 1, 2, 0, 9900000, '2023-03-23 14:46:42'),
(2, NULL, 1, 1, 2, 1, 11800000, '2023-03-23 14:46:42'),
(3, NULL, 2, 1, 2, 0, 15050000, '2023-03-23 14:46:42'),
(4, NULL, 2, 1, 2, 1, 16950000, '2023-03-23 14:46:42'),
(5, NULL, 3, 1, 2, 0, 16800000, '2023-03-23 14:46:42'),
(6, NULL, 3, 1, 2, 1, 18700000, '2023-03-23 14:46:42'),
(7, NULL, 4, 1, 2, 0, 12050000, '2023-03-23 14:46:42'),
(8, NULL, 4, 1, 2, 1, 13950000, '2023-03-23 14:46:42'),
(9, NULL, 5, 1, 2, 0, 9950000, '2023-03-23 14:46:42'),
(10, NULL, 5, 1, 2, 1, 11850000, '2023-03-23 14:46:42'),
(11, NULL, 6, 1, 2, 0, 15600000, '2023-03-23 14:46:42'),
(12, NULL, 6, 1, 2, 1, 17500000, '2023-03-23 14:46:42'),
(13, NULL, 7, 1, 2, 0, 16850000, '2023-03-23 14:46:42'),
(14, NULL, 7, 1, 2, 1, 18750000, '2023-03-23 14:46:42'),
(15, NULL, 8, 1, 2, 0, 12600000, '2023-03-23 14:46:42'),
(16, NULL, 8, 1, 2, 1, 14500000, '2023-03-23 14:46:42'),
(17, NULL, 9, 1, 2, 0, 10350000, '2023-03-23 14:46:42'),
(18, NULL, 9, 1, 2, 1, 12250000, '2023-03-23 14:46:42'),
(19, NULL, 10, 1, 2, 0, 16450000, '2023-03-23 14:46:42'),
(20, NULL, 10, 1, 2, 1, 18350000, '2023-03-23 14:46:42'),
(21, NULL, 11, 1, 2, 0, 17250000, '2023-03-23 14:46:42'),
(22, NULL, 11, 1, 2, 1, 19150000, '2023-03-23 14:46:42'),
(23, NULL, 12, 1, 2, 0, 13450000, '2023-03-23 14:46:42'),
(24, NULL, 12, 1, 2, 1, 15350000, '2023-03-23 14:46:42'),
(25, NULL, 1, 2, 2, 0, 9900000, '2023-03-23 14:46:42'),
(26, NULL, 1, 2, 2, 1, 11900000, '2023-03-23 14:46:42'),
(27, NULL, 2, 2, 2, 0, 15050000, '2023-03-23 14:46:42'),
(28, NULL, 2, 2, 2, 1, 17050000, '2023-03-23 14:46:42'),
(29, NULL, 3, 2, 2, 0, 16800000, '2023-03-23 14:46:42'),
(30, NULL, 3, 2, 2, 1, 18800000, '2023-03-23 14:46:42'),
(31, NULL, 4, 2, 2, 0, 12050000, '2023-03-23 14:46:42'),
(32, NULL, 4, 2, 2, 1, 14050000, '2023-03-23 14:46:42'),
(33, NULL, 5, 2, 2, 0, 9950000, '2023-03-23 14:46:42'),
(34, NULL, 5, 2, 2, 1, 11950000, '2023-03-23 14:46:42'),
(35, NULL, 6, 2, 2, 0, 15600000, '2023-03-23 14:46:42'),
(36, NULL, 6, 2, 2, 1, 17600000, '2023-03-23 14:46:42'),
(37, NULL, 7, 2, 2, 0, 16850000, '2023-03-23 14:46:42'),
(38, NULL, 7, 2, 2, 1, 18850000, '2023-03-23 14:46:42'),
(39, NULL, 8, 2, 2, 0, 12600000, '2023-03-23 14:46:42'),
(40, NULL, 8, 2, 2, 1, 14600000, '2023-03-23 14:46:42'),
(41, NULL, 9, 2, 2, 0, 10350000, '2023-03-23 14:46:42'),
(42, NULL, 9, 2, 2, 1, 12350000, '2023-03-23 14:46:42'),
(43, NULL, 10, 2, 2, 0, 16450000, '2023-03-23 14:46:42'),
(44, NULL, 10, 2, 2, 1, 18450000, '2023-03-23 14:46:42'),
(45, NULL, 11, 2, 2, 0, 17250000, '2023-03-23 14:46:42'),
(46, NULL, 11, 2, 2, 1, 19250000, '2023-03-23 14:46:42'),
(47, NULL, 12, 2, 2, 0, 13450000, '2023-03-23 14:46:42'),
(48, NULL, 12, 2, 2, 1, 15450000, '2023-03-23 14:46:42'),
(49, NULL, 1, 3, 2, 0, 9900000, '2023-03-23 14:46:42'),
(50, NULL, 1, 3, 2, 1, 11700000, '2023-03-23 14:46:42'),
(51, NULL, 2, 3, 2, 0, 15850000, '2023-03-23 14:46:42'),
(52, NULL, 2, 3, 2, 1, 17650000, '2023-03-23 14:46:42'),
(53, NULL, 3, 3, 2, 0, 17600000, '2023-03-23 14:46:42'),
(54, NULL, 3, 3, 2, 1, 19400000, '2023-03-23 14:46:42'),
(55, NULL, 4, 3, 2, 0, 12850000, '2023-03-23 14:46:42'),
(56, NULL, 4, 3, 2, 1, 14650000, '2023-03-23 14:46:42'),
(57, NULL, 5, 3, 2, 0, 9950000, '2023-03-23 14:46:42'),
(58, NULL, 5, 3, 2, 1, 11750000, '2023-03-23 14:46:42'),
(59, NULL, 6, 3, 2, 0, 16400000, '2023-03-23 14:46:42'),
(60, NULL, 6, 3, 2, 1, 18200000, '2023-03-23 14:46:42'),
(61, NULL, 7, 3, 2, 0, 17650000, '2023-03-23 14:46:42'),
(62, NULL, 7, 3, 2, 1, 19450000, '2023-03-23 14:46:42'),
(63, NULL, 8, 3, 2, 0, 13400000, '2023-03-23 14:46:42'),
(64, NULL, 8, 3, 2, 1, 15200000, '2023-03-23 14:46:42'),
(65, NULL, 9, 3, 2, 0, 10350000, '2023-03-23 14:46:42'),
(66, NULL, 9, 3, 2, 1, 12150000, '2023-03-23 14:46:42'),
(67, NULL, 10, 3, 2, 0, 17250000, '2023-03-23 14:46:42'),
(68, NULL, 10, 3, 2, 1, 19050000, '2023-03-23 14:46:42'),
(69, NULL, 11, 3, 2, 0, 18050000, '2023-03-23 14:46:42'),
(70, NULL, 11, 3, 2, 1, 19850000, '2023-03-23 14:46:42'),
(71, NULL, 12, 3, 2, 0, 14250000, '2023-03-23 14:46:42'),
(72, NULL, 12, 3, 2, 1, 16050000, '2023-03-23 14:46:42'),
(73, NULL, 1, 4, 2, 0, 9900000, '2023-03-23 14:46:42'),
(74, NULL, 1, 4, 2, 1, 11700000, '2023-03-23 14:46:42'),
(75, NULL, 2, 4, 2, 0, 15850000, '2023-03-23 14:46:42'),
(76, NULL, 2, 4, 2, 1, 17650000, '2023-03-23 14:46:42'),
(77, NULL, 3, 4, 2, 0, 17600000, '2023-03-23 14:46:42'),
(78, NULL, 3, 4, 2, 1, 19400000, '2023-03-23 14:46:42'),
(79, NULL, 4, 4, 2, 0, 12850000, '2023-03-23 14:46:42'),
(80, NULL, 4, 4, 2, 1, 14650000, '2023-03-23 14:46:42'),
(81, NULL, 5, 4, 2, 0, 9950000, '2023-03-23 14:46:42'),
(82, NULL, 5, 4, 2, 1, 11750000, '2023-03-23 14:46:42'),
(83, NULL, 6, 4, 2, 0, 16400000, '2023-03-23 14:46:42'),
(84, NULL, 6, 4, 2, 1, 18200000, '2023-03-23 14:46:42'),
(85, NULL, 7, 4, 2, 0, 17650000, '2023-03-23 14:46:42'),
(86, NULL, 7, 4, 2, 1, 19450000, '2023-03-23 14:46:42'),
(87, NULL, 8, 4, 2, 0, 13400000, '2023-03-23 14:46:42'),
(88, NULL, 8, 4, 2, 1, 15200000, '2023-03-23 14:46:42'),
(89, NULL, 9, 4, 2, 0, 10350000, '2023-03-23 14:46:42'),
(90, NULL, 9, 4, 2, 1, 12150000, '2023-03-23 14:46:42'),
(91, NULL, 10, 4, 2, 0, 17250000, '2023-03-23 14:46:42'),
(92, NULL, 10, 4, 2, 1, 19050000, '2023-03-23 14:46:42'),
(93, NULL, 11, 4, 2, 0, 18050000, '2023-03-23 14:46:42'),
(94, NULL, 11, 4, 2, 1, 19850000, '2023-03-23 14:46:42'),
(95, NULL, 12, 4, 2, 0, 14250000, '2023-03-23 14:46:42'),
(96, NULL, 12, 4, 2, 1, 16050000, '2023-03-23 14:46:42'),
(97, NULL, 1, 5, 2, 0, 9900000, '2023-03-23 14:46:42'),
(98, NULL, 1, 5, 2, 1, 12500000, '2023-03-23 14:46:42'),
(99, NULL, 2, 5, 2, 0, 15850000, '2023-03-23 14:46:42'),
(100, NULL, 2, 5, 2, 1, 18450000, '2023-03-23 14:46:42'),
(101, NULL, 3, 5, 2, 0, 17600000, '2023-03-23 14:46:42'),
(102, NULL, 3, 5, 2, 1, 20200000, '2023-03-23 14:46:42'),
(103, NULL, 4, 5, 2, 0, 12850000, '2023-03-23 14:46:42'),
(104, NULL, 4, 5, 2, 1, 15450000, '2023-03-23 14:46:42'),
(105, NULL, 5, 5, 2, 0, 9950000, '2023-03-23 14:46:42'),
(106, NULL, 5, 5, 2, 1, 12550000, '2023-03-23 14:46:42'),
(107, NULL, 6, 5, 2, 0, 16400000, '2023-03-23 14:46:42'),
(108, NULL, 6, 5, 2, 1, 19000000, '2023-03-23 14:46:42'),
(109, NULL, 7, 5, 2, 0, 17650000, '2023-03-23 14:46:42'),
(110, NULL, 7, 5, 2, 1, 20250000, '2023-03-23 14:46:42'),
(111, NULL, 8, 5, 2, 0, 13400000, '2023-03-23 14:46:42'),
(112, NULL, 8, 5, 2, 1, 16000000, '2023-03-23 14:46:42'),
(113, NULL, 9, 5, 2, 0, 10350000, '2023-03-23 14:46:42'),
(114, NULL, 9, 5, 2, 1, 12950000, '2023-03-23 14:46:42'),
(115, NULL, 10, 5, 2, 0, 17250000, '2023-03-23 14:46:42'),
(116, NULL, 10, 5, 2, 1, 19850000, '2023-03-23 14:46:42'),
(117, NULL, 11, 5, 2, 0, 18050000, '2023-03-23 14:46:42'),
(118, NULL, 11, 5, 2, 1, 20650000, '2023-03-23 14:46:42'),
(119, NULL, 12, 5, 2, 0, 14250000, '2023-03-23 14:46:42'),
(120, NULL, 12, 5, 2, 1, 16850000, '2023-03-23 14:46:42'),
(121, NULL, 1, 6, 2, 0, 10050000, '2023-03-23 14:46:42'),
(122, NULL, 1, 6, 2, 1, 12125000, '2023-03-23 14:46:42'),
(123, NULL, 2, 6, 2, 0, 16000000, '2023-03-23 14:46:42'),
(124, NULL, 2, 6, 2, 1, 18075000, '2023-03-23 14:46:42'),
(125, NULL, 3, 6, 2, 0, 17750000, '2023-03-23 14:46:42'),
(126, NULL, 3, 6, 2, 1, 19825000, '2023-03-23 14:46:42'),
(127, NULL, 4, 6, 2, 0, 13000000, '2023-03-23 14:46:42'),
(128, NULL, 4, 6, 2, 1, 15075000, '2023-03-23 14:46:42'),
(129, NULL, 5, 6, 2, 0, 10100000, '2023-03-23 14:46:42'),
(130, NULL, 5, 6, 2, 1, 12175000, '2023-03-23 14:46:42'),
(131, NULL, 6, 6, 2, 0, 16550000, '2023-03-23 14:46:42'),
(132, NULL, 6, 6, 2, 1, 18625000, '2023-03-23 14:46:42'),
(133, NULL, 7, 6, 2, 0, 17800000, '2023-03-23 14:46:42'),
(134, NULL, 7, 6, 2, 1, 19875000, '2023-03-23 14:46:42'),
(135, NULL, 8, 6, 2, 0, 13550000, '2023-03-23 14:46:42'),
(136, NULL, 8, 6, 2, 1, 15625000, '2023-03-23 14:46:42'),
(137, NULL, 9, 6, 2, 0, 10500000, '2023-03-23 14:46:42'),
(138, NULL, 9, 6, 2, 1, 12575000, '2023-03-23 14:46:42'),
(139, NULL, 10, 6, 2, 0, 17400000, '2023-03-23 14:46:42'),
(140, NULL, 10, 6, 2, 1, 19475000, '2023-03-23 14:46:42'),
(141, NULL, 11, 6, 2, 0, 18200000, '2023-03-23 14:46:42'),
(142, NULL, 11, 6, 2, 1, 20275000, '2023-03-23 14:46:42'),
(143, NULL, 12, 6, 2, 0, 14400000, '2023-03-23 14:46:42'),
(144, NULL, 12, 6, 2, 1, 16475000, '2023-03-23 14:46:42'),
(145, NULL, 1, 7, 2, 0, 11200000, '2023-03-23 14:46:42'),
(146, NULL, 1, 7, 2, 1, 13200000, '2023-03-23 14:46:42'),
(147, NULL, 2, 7, 2, 0, 17150000, '2023-03-23 14:46:42'),
(148, NULL, 2, 7, 2, 1, 19150000, '2023-03-23 14:46:42'),
(149, NULL, 3, 7, 2, 0, 18900000, '2023-03-23 14:46:42'),
(150, NULL, 3, 7, 2, 1, 20900000, '2023-03-23 14:46:42'),
(151, NULL, 4, 7, 2, 0, 14150000, '2023-03-23 14:46:42'),
(152, NULL, 4, 7, 2, 1, 16150000, '2023-03-23 14:46:42'),
(153, NULL, 5, 7, 2, 0, 11250000, '2023-03-23 14:46:42'),
(154, NULL, 5, 7, 2, 1, 13250000, '2023-03-23 14:46:42'),
(155, NULL, 6, 7, 2, 0, 17700000, '2023-03-23 14:46:42'),
(156, NULL, 6, 7, 2, 1, 19700000, '2023-03-23 14:46:42'),
(157, NULL, 7, 7, 2, 0, 18950000, '2023-03-23 14:46:42'),
(158, NULL, 7, 7, 2, 1, 20950000, '2023-03-23 14:46:42'),
(159, NULL, 8, 7, 2, 0, 14700000, '2023-03-23 14:46:42'),
(160, NULL, 8, 7, 2, 1, 16700000, '2023-03-23 14:46:42'),
(161, NULL, 9, 7, 2, 0, 11650000, '2023-03-23 14:46:42'),
(162, NULL, 9, 7, 2, 1, 13650000, '2023-03-23 14:46:42'),
(163, NULL, 10, 7, 2, 0, 18550000, '2023-03-23 14:46:42'),
(164, NULL, 10, 7, 2, 1, 20550000, '2023-03-23 14:46:42'),
(165, NULL, 11, 7, 2, 0, 19350000, '2023-03-23 14:46:42'),
(166, NULL, 11, 7, 2, 1, 21350000, '2023-03-23 14:46:42'),
(167, NULL, 12, 7, 2, 0, 15550000, '2023-03-23 14:46:42'),
(168, NULL, 12, 7, 2, 1, 17550000, '2023-03-23 14:46:42'),
(169, NULL, 1, 8, 2, 0, 11200000, '2023-03-23 14:46:42'),
(170, NULL, 1, 8, 2, 1, 13200000, '2023-03-23 14:46:42'),
(171, NULL, 2, 8, 2, 0, 17150000, '2023-03-23 14:46:42'),
(172, NULL, 2, 8, 2, 1, 19150000, '2023-03-23 14:46:42'),
(173, NULL, 3, 8, 2, 0, 18900000, '2023-03-23 14:46:42'),
(174, NULL, 3, 8, 2, 1, 20900000, '2023-03-23 14:46:42'),
(175, NULL, 4, 8, 2, 0, 14150000, '2023-03-23 14:46:42'),
(176, NULL, 4, 8, 2, 1, 16150000, '2023-03-23 14:46:42'),
(177, NULL, 5, 8, 2, 0, 11250000, '2023-03-23 14:46:42'),
(178, NULL, 5, 8, 2, 1, 13250000, '2023-03-23 14:46:42'),
(179, NULL, 6, 8, 2, 0, 17700000, '2023-03-23 14:46:42'),
(180, NULL, 6, 8, 2, 1, 19700000, '2023-03-23 14:46:42'),
(181, NULL, 7, 8, 2, 0, 18950000, '2023-03-23 14:46:42'),
(182, NULL, 7, 8, 2, 1, 20950000, '2023-03-23 14:46:42'),
(183, NULL, 8, 8, 2, 0, 14700000, '2023-03-23 14:46:42'),
(184, NULL, 8, 8, 2, 1, 16700000, '2023-03-23 14:46:42'),
(185, NULL, 9, 8, 2, 0, 11650000, '2023-03-23 14:46:42'),
(186, NULL, 9, 8, 2, 1, 13650000, '2023-03-23 14:46:42'),
(187, NULL, 10, 8, 2, 0, 18550000, '2023-03-23 14:46:42'),
(188, NULL, 10, 8, 2, 1, 20550000, '2023-03-23 14:46:42'),
(189, NULL, 11, 8, 2, 0, 19350000, '2023-03-23 14:46:42'),
(190, NULL, 11, 8, 2, 1, 21350000, '2023-03-23 14:46:42'),
(191, NULL, 12, 8, 2, 0, 15550000, '2023-03-23 14:46:42'),
(192, NULL, 12, 8, 2, 1, 17550000, '2023-03-23 14:46:42'),
(193, NULL, 1, 9, 2, 0, 10950000, '2023-03-23 14:46:42'),
(194, NULL, 1, 9, 2, 1, 12950000, '2023-03-23 14:46:42'),
(195, NULL, 2, 9, 2, 0, 16900000, '2023-03-23 14:46:42'),
(196, NULL, 2, 9, 2, 1, 18900000, '2023-03-23 14:46:42'),
(197, NULL, 3, 9, 2, 0, 18650000, '2023-03-23 14:46:42'),
(198, NULL, 3, 9, 2, 1, 20650000, '2023-03-23 14:46:42'),
(199, NULL, 4, 9, 2, 0, 13900000, '2023-03-23 14:46:42'),
(200, NULL, 4, 9, 2, 1, 15900000, '2023-03-23 14:46:42'),
(201, NULL, 5, 9, 2, 0, 11000000, '2023-03-23 14:46:42'),
(202, NULL, 5, 9, 2, 1, 13000000, '2023-03-23 14:46:42'),
(203, NULL, 6, 9, 2, 0, 17450000, '2023-03-23 14:46:42'),
(204, NULL, 6, 9, 2, 1, 19450000, '2023-03-23 14:46:42'),
(205, NULL, 7, 9, 2, 0, 18700000, '2023-03-23 14:46:42'),
(206, NULL, 7, 9, 2, 1, 20700000, '2023-03-23 14:46:42'),
(207, NULL, 8, 9, 2, 0, 14450000, '2023-03-23 14:46:42'),
(208, NULL, 8, 9, 2, 1, 16450000, '2023-03-23 14:46:42'),
(209, NULL, 9, 9, 2, 0, 11400000, '2023-03-23 14:46:42'),
(210, NULL, 9, 9, 2, 1, 13400000, '2023-03-23 14:46:42'),
(211, NULL, 10, 9, 2, 0, 18300000, '2023-03-23 14:46:42'),
(212, NULL, 10, 9, 2, 1, 20300000, '2023-03-23 14:46:42'),
(213, NULL, 11, 9, 2, 0, 19100000, '2023-03-23 14:46:42'),
(214, NULL, 11, 9, 2, 1, 21100000, '2023-03-23 14:46:42'),
(215, NULL, 12, 9, 2, 0, 15300000, '2023-03-23 14:46:42'),
(216, NULL, 12, 9, 2, 1, 17300000, '2023-03-23 14:46:42'),
(217, NULL, 1, 10, 2, 0, 11000000, '2023-03-23 14:46:42'),
(218, NULL, 1, 10, 2, 1, 13000000, '2023-03-23 14:46:42'),
(219, NULL, 2, 10, 2, 0, 16950000, '2023-03-23 14:46:42'),
(220, NULL, 2, 10, 2, 1, 18950000, '2023-03-23 14:46:42'),
(221, NULL, 3, 10, 2, 0, 18700000, '2023-03-23 14:46:42'),
(222, NULL, 3, 10, 2, 1, 20700000, '2023-03-23 14:46:42'),
(223, NULL, 4, 10, 2, 0, 13950000, '2023-03-23 14:46:42'),
(224, NULL, 4, 10, 2, 1, 15950000, '2023-03-23 14:46:42'),
(225, NULL, 5, 10, 2, 0, 11050000, '2023-03-23 14:46:42'),
(226, NULL, 5, 10, 2, 1, 13050000, '2023-03-23 14:46:42'),
(227, NULL, 6, 10, 2, 0, 17500000, '2023-03-23 14:46:42'),
(228, NULL, 6, 10, 2, 1, 19500000, '2023-03-23 14:46:42'),
(229, NULL, 7, 10, 2, 0, 18750000, '2023-03-23 14:46:42'),
(230, NULL, 7, 10, 2, 1, 20750000, '2023-03-23 14:46:42'),
(231, NULL, 8, 10, 2, 0, 14500000, '2023-03-23 14:46:42'),
(232, NULL, 8, 10, 2, 1, 16500000, '2023-03-23 14:46:42'),
(233, NULL, 9, 10, 2, 0, 11450000, '2023-03-23 14:46:42'),
(234, NULL, 9, 10, 2, 1, 13450000, '2023-03-23 14:46:42'),
(235, NULL, 10, 10, 2, 0, 18350000, '2023-03-23 14:46:42'),
(236, NULL, 10, 10, 2, 1, 20350000, '2023-03-23 14:46:42'),
(237, NULL, 11, 10, 2, 0, 19150000, '2023-03-23 14:46:42'),
(238, NULL, 11, 10, 2, 1, 21150000, '2023-03-23 14:46:42'),
(239, NULL, 12, 10, 2, 0, 15350000, '2023-03-23 14:46:42'),
(240, NULL, 12, 10, 2, 1, 17350000, '2023-03-23 14:46:42'),
(241, NULL, 1, 11, 2, 0, 11100000, '2023-03-23 14:46:42'),
(242, NULL, 1, 11, 2, 1, 13100000, '2023-03-23 14:46:42'),
(243, NULL, 2, 11, 2, 0, 17050000, '2023-03-23 14:46:42'),
(244, NULL, 2, 11, 2, 1, 19050000, '2023-03-23 14:46:42'),
(245, NULL, 3, 11, 2, 0, 18800000, '2023-03-23 14:46:42'),
(246, NULL, 3, 11, 2, 1, 20800000, '2023-03-23 14:46:42'),
(247, NULL, 4, 11, 2, 0, 14050000, '2023-03-23 14:46:42'),
(248, NULL, 4, 11, 2, 1, 16050000, '2023-03-23 14:46:42'),
(249, NULL, 5, 11, 2, 0, 11150000, '2023-03-23 14:46:42'),
(250, NULL, 5, 11, 2, 1, 13150000, '2023-03-23 14:46:42'),
(251, NULL, 6, 11, 2, 0, 17600000, '2023-03-23 14:46:42'),
(252, NULL, 6, 11, 2, 1, 19600000, '2023-03-23 14:46:42'),
(253, NULL, 7, 11, 2, 0, 18850000, '2023-03-23 14:46:42'),
(254, NULL, 7, 11, 2, 1, 20850000, '2023-03-23 14:46:42'),
(255, NULL, 8, 11, 2, 0, 14600000, '2023-03-23 14:46:42'),
(256, NULL, 8, 11, 2, 1, 16600000, '2023-03-23 14:46:42'),
(257, NULL, 9, 11, 2, 0, 11550000, '2023-03-23 14:46:42'),
(258, NULL, 9, 11, 2, 1, 13550000, '2023-03-23 14:46:42'),
(259, NULL, 10, 11, 2, 0, 18450000, '2023-03-23 14:46:42'),
(260, NULL, 10, 11, 2, 1, 20450000, '2023-03-23 14:46:42'),
(261, NULL, 11, 11, 2, 0, 19250000, '2023-03-23 14:46:42'),
(262, NULL, 11, 11, 2, 1, 21250000, '2023-03-23 14:46:42'),
(263, NULL, 12, 11, 2, 0, 15450000, '2023-03-23 14:46:42'),
(264, NULL, 12, 11, 2, 1, 17450000, '2023-03-23 14:46:42'),
(265, NULL, 1, 12, 2, 0, 10850000, '2023-03-23 14:46:42'),
(266, NULL, 1, 12, 2, 1, 13150000, '2023-03-23 14:46:42'),
(267, NULL, 2, 12, 2, 0, 16800000, '2023-03-23 14:46:42'),
(268, NULL, 2, 12, 2, 1, 19100000, '2023-03-23 14:46:42'),
(269, NULL, 3, 12, 2, 0, 18550000, '2023-03-23 14:46:42'),
(270, NULL, 3, 12, 2, 1, 20850000, '2023-03-23 14:46:42'),
(271, NULL, 4, 12, 2, 0, 13800000, '2023-03-23 14:46:42'),
(272, NULL, 4, 12, 2, 1, 16100000, '2023-03-23 14:46:42'),
(273, NULL, 5, 12, 2, 0, 10900000, '2023-03-23 14:46:42'),
(274, NULL, 5, 12, 2, 1, 13200000, '2023-03-23 14:46:42'),
(275, NULL, 6, 12, 2, 0, 17350000, '2023-03-23 14:46:42'),
(276, NULL, 6, 12, 2, 1, 19650000, '2023-03-23 14:46:42'),
(277, NULL, 7, 12, 2, 0, 18600000, '2023-03-23 14:46:42'),
(278, NULL, 7, 12, 2, 1, 20900000, '2023-03-23 14:46:42'),
(279, NULL, 8, 12, 2, 0, 14350000, '2023-03-23 14:46:42'),
(280, NULL, 8, 12, 2, 1, 16650000, '2023-03-23 14:46:42'),
(281, NULL, 9, 12, 2, 0, 11300000, '2023-03-23 14:46:42'),
(282, NULL, 9, 12, 2, 1, 13600000, '2023-03-23 14:46:42'),
(283, NULL, 10, 12, 2, 0, 18200000, '2023-03-23 14:46:42'),
(284, NULL, 10, 12, 2, 1, 20500000, '2023-03-23 14:46:42'),
(285, NULL, 11, 12, 2, 0, 19000000, '2023-03-23 14:46:42'),
(286, NULL, 11, 12, 2, 1, 21300000, '2023-03-23 14:46:42'),
(287, NULL, 12, 12, 2, 0, 15200000, '2023-03-23 14:46:42'),
(288, NULL, 12, 12, 2, 1, 17500000, '2023-03-23 14:46:42'),
(289, NULL, 1, 13, 2, 0, 10900000, '2023-03-23 14:46:42'),
(290, NULL, 1, 13, 2, 1, 13200000, '2023-03-23 14:46:42'),
(291, NULL, 2, 13, 2, 0, 16850000, '2023-03-23 14:46:42'),
(292, NULL, 2, 13, 2, 1, 19150000, '2023-03-23 14:46:42'),
(293, NULL, 3, 13, 2, 0, 18600000, '2023-03-23 14:46:42'),
(294, NULL, 3, 13, 2, 1, 20900000, '2023-03-23 14:46:42'),
(295, NULL, 4, 13, 2, 0, 13850000, '2023-03-23 14:46:42'),
(296, NULL, 4, 13, 2, 1, 16150000, '2023-03-23 14:46:42'),
(297, NULL, 5, 13, 2, 0, 10950000, '2023-03-23 14:46:42'),
(298, NULL, 5, 13, 2, 1, 13250000, '2023-03-23 14:46:42'),
(299, NULL, 6, 13, 2, 0, 17400000, '2023-03-23 14:46:42'),
(300, NULL, 6, 13, 2, 1, 19700000, '2023-03-23 14:46:42'),
(301, NULL, 7, 13, 2, 0, 18650000, '2023-03-23 14:46:42'),
(302, NULL, 7, 13, 2, 1, 20950000, '2023-03-23 14:46:42'),
(303, NULL, 8, 13, 2, 0, 14400000, '2023-03-23 14:46:42'),
(304, NULL, 8, 13, 2, 1, 16700000, '2023-03-23 14:46:42'),
(305, NULL, 9, 13, 2, 0, 11350000, '2023-03-23 14:46:42'),
(306, NULL, 9, 13, 2, 1, 13650000, '2023-03-23 14:46:42'),
(307, NULL, 10, 13, 2, 0, 18250000, '2023-03-23 14:46:42'),
(308, NULL, 10, 13, 2, 1, 20550000, '2023-03-23 14:46:42'),
(309, NULL, 11, 13, 2, 0, 19050000, '2023-03-23 14:46:42'),
(310, NULL, 11, 13, 2, 1, 21350000, '2023-03-23 14:46:42'),
(311, NULL, 12, 13, 2, 0, 15250000, '2023-03-23 14:46:42'),
(312, NULL, 12, 13, 2, 1, 17550000, '2023-03-23 14:46:42'),
(313, NULL, 1, 14, 2, 0, 10900000, '2023-03-23 14:46:42'),
(314, NULL, 1, 14, 2, 1, 12900000, '2023-03-23 14:46:42'),
(315, NULL, 2, 14, 2, 0, 16850000, '2023-03-23 14:46:42'),
(316, NULL, 2, 14, 2, 1, 18850000, '2023-03-23 14:46:42'),
(317, NULL, 3, 14, 2, 0, 18600000, '2023-03-23 14:46:42'),
(318, NULL, 3, 14, 2, 1, 20600000, '2023-03-23 14:46:42'),
(319, NULL, 4, 14, 2, 0, 13850000, '2023-03-23 14:46:42'),
(320, NULL, 4, 14, 2, 1, 15850000, '2023-03-23 14:46:42'),
(321, NULL, 5, 14, 2, 0, 10950000, '2023-03-23 14:46:42'),
(322, NULL, 5, 14, 2, 1, 12950000, '2023-03-23 14:46:42'),
(323, NULL, 6, 14, 2, 0, 17400000, '2023-03-23 14:46:42'),
(324, NULL, 6, 14, 2, 1, 19400000, '2023-03-23 14:46:42'),
(325, NULL, 7, 14, 2, 0, 18650000, '2023-03-23 14:46:42'),
(326, NULL, 7, 14, 2, 1, 20650000, '2023-03-23 14:46:42'),
(327, NULL, 8, 14, 2, 0, 14400000, '2023-03-23 14:46:42'),
(328, NULL, 8, 14, 2, 1, 16400000, '2023-03-23 14:46:42'),
(329, NULL, 9, 14, 2, 0, 11350000, '2023-03-23 14:46:42'),
(330, NULL, 9, 14, 2, 1, 13350000, '2023-03-23 14:46:42'),
(331, NULL, 10, 14, 2, 0, 18250000, '2023-03-23 14:46:42'),
(332, NULL, 10, 14, 2, 1, 20250000, '2023-03-23 14:46:42'),
(333, NULL, 11, 14, 2, 0, 19050000, '2023-03-23 14:46:42'),
(334, NULL, 11, 14, 2, 1, 21050000, '2023-03-23 14:46:42'),
(335, NULL, 12, 14, 2, 0, 15250000, '2023-03-23 14:46:42'),
(336, NULL, 12, 14, 2, 1, 17250000, '2023-03-23 14:46:42'),
(337, NULL, 1, 15, 2, 0, 10900000, '2023-03-23 14:46:42'),
(338, NULL, 1, 15, 2, 1, 12900000, '2023-03-23 14:46:42'),
(339, NULL, 2, 15, 2, 0, 16850000, '2023-03-23 14:46:42'),
(340, NULL, 2, 15, 2, 1, 18850000, '2023-03-23 14:46:42'),
(341, NULL, 3, 15, 2, 0, 18600000, '2023-03-23 14:46:42'),
(342, NULL, 3, 15, 2, 1, 20600000, '2023-03-23 14:46:42'),
(343, NULL, 4, 15, 2, 0, 13850000, '2023-03-23 14:46:42'),
(344, NULL, 4, 15, 2, 1, 15850000, '2023-03-23 14:46:42'),
(345, NULL, 5, 15, 2, 0, 10950000, '2023-03-23 14:46:42'),
(346, NULL, 5, 15, 2, 1, 12950000, '2023-03-23 14:46:42'),
(347, NULL, 6, 15, 2, 0, 17400000, '2023-03-23 14:46:42'),
(348, NULL, 6, 15, 2, 1, 19400000, '2023-03-23 14:46:42'),
(349, NULL, 7, 15, 2, 0, 18650000, '2023-03-23 14:46:42'),
(350, NULL, 7, 15, 2, 1, 20650000, '2023-03-23 14:46:42'),
(351, NULL, 8, 15, 2, 0, 14400000, '2023-03-23 14:46:42'),
(352, NULL, 8, 15, 2, 1, 16400000, '2023-03-23 14:46:42'),
(353, NULL, 9, 15, 2, 0, 11350000, '2023-03-23 14:46:42'),
(354, NULL, 9, 15, 2, 1, 13350000, '2023-03-23 14:46:42'),
(355, NULL, 10, 15, 2, 0, 18250000, '2023-03-23 14:46:42'),
(356, NULL, 10, 15, 2, 1, 20250000, '2023-03-23 14:46:42'),
(357, NULL, 11, 15, 2, 0, 19050000, '2023-03-23 14:46:42'),
(358, NULL, 11, 15, 2, 1, 21050000, '2023-03-23 14:46:42'),
(359, NULL, 12, 15, 2, 0, 15250000, '2023-03-23 14:46:42'),
(360, NULL, 12, 15, 2, 1, 17250000, '2023-03-23 14:46:42'),
(361, NULL, 1, 16, 2, 0, 12200000, '2023-03-23 14:46:42'),
(362, NULL, 1, 16, 2, 1, 14000000, '2023-03-23 14:46:42'),
(363, NULL, 2, 16, 2, 0, 18150000, '2023-03-23 14:46:42'),
(364, NULL, 2, 16, 2, 1, 19950000, '2023-03-23 14:46:42'),
(365, NULL, 3, 16, 2, 0, 19900000, '2023-03-23 14:46:42'),
(366, NULL, 3, 16, 2, 1, 21700000, '2023-03-23 14:46:42'),
(367, NULL, 4, 16, 2, 0, 15150000, '2023-03-23 14:46:42'),
(368, NULL, 4, 16, 2, 1, 16950000, '2023-03-23 14:46:42'),
(369, NULL, 5, 16, 2, 0, 12250000, '2023-03-23 14:46:42'),
(370, NULL, 5, 16, 2, 1, 14050000, '2023-03-23 14:46:42'),
(371, NULL, 6, 16, 2, 0, 18700000, '2023-03-23 14:46:42'),
(372, NULL, 6, 16, 2, 1, 20500000, '2023-03-23 14:46:42'),
(373, NULL, 7, 16, 2, 0, 19950000, '2023-03-23 14:46:42'),
(374, NULL, 7, 16, 2, 1, 21750000, '2023-03-23 14:46:42'),
(375, NULL, 8, 16, 2, 0, 15700000, '2023-03-23 14:46:42'),
(376, NULL, 8, 16, 2, 1, 17500000, '2023-03-23 14:46:42'),
(377, NULL, 9, 16, 2, 0, 12650000, '2023-03-23 14:46:42'),
(378, NULL, 9, 16, 2, 1, 14450000, '2023-03-23 14:46:42'),
(379, NULL, 10, 16, 2, 0, 19550000, '2023-03-23 14:46:42'),
(380, NULL, 10, 16, 2, 1, 21350000, '2023-03-23 14:46:42'),
(381, NULL, 11, 16, 2, 0, 20350000, '2023-03-23 14:46:42'),
(382, NULL, 11, 16, 2, 1, 22150000, '2023-03-23 14:46:42'),
(383, NULL, 12, 16, 2, 0, 16550000, '2023-03-23 14:46:42'),
(384, NULL, 12, 16, 2, 1, 18350000, '2023-03-23 14:46:42'),
(385, NULL, 1, 17, 2, 0, 11900000, '2023-03-23 14:46:42'),
(386, NULL, 1, 17, 2, 1, 13400000, '2023-03-23 14:46:42'),
(387, NULL, 2, 17, 2, 0, 17850000, '2023-03-23 14:46:42'),
(388, NULL, 2, 17, 2, 1, 19350000, '2023-03-23 14:46:42'),
(389, NULL, 3, 17, 2, 0, 19600000, '2023-03-23 14:46:42'),
(390, NULL, 3, 17, 2, 1, 21100000, '2023-03-23 14:46:42'),
(391, NULL, 4, 17, 2, 0, 14850000, '2023-03-23 14:46:42'),
(392, NULL, 4, 17, 2, 1, 16350000, '2023-03-23 14:46:42'),
(393, NULL, 5, 17, 2, 0, 11950000, '2023-03-23 14:46:42'),
(394, NULL, 5, 17, 2, 1, 13450000, '2023-03-23 14:46:42'),
(395, NULL, 6, 17, 2, 0, 18400000, '2023-03-23 14:46:42'),
(396, NULL, 6, 17, 2, 1, 19900000, '2023-03-23 14:46:42'),
(397, NULL, 7, 17, 2, 0, 19650000, '2023-03-23 14:46:42'),
(398, NULL, 7, 17, 2, 1, 21150000, '2023-03-23 14:46:42'),
(399, NULL, 8, 17, 2, 0, 15400000, '2023-03-23 14:46:42'),
(400, NULL, 8, 17, 2, 1, 16900000, '2023-03-23 14:46:42'),
(401, NULL, 9, 17, 2, 0, 12350000, '2023-03-23 14:46:42'),
(402, NULL, 9, 17, 2, 1, 13850000, '2023-03-23 14:46:42'),
(403, NULL, 10, 17, 2, 0, 19250000, '2023-03-23 14:46:42'),
(404, NULL, 10, 17, 2, 1, 20750000, '2023-03-23 14:46:42'),
(405, NULL, 11, 17, 2, 0, 20050000, '2023-03-23 14:46:42'),
(406, NULL, 11, 17, 2, 1, 21550000, '2023-03-23 14:46:42'),
(407, NULL, 12, 17, 2, 0, 16250000, '2023-03-23 14:46:42'),
(408, NULL, 12, 17, 2, 1, 17750000, '2023-03-23 14:46:42'),
(409, NULL, 1, 18, 2, 0, 11700000, '2023-03-23 14:46:42'),
(410, NULL, 1, 18, 2, 1, 13200000, '2023-03-23 14:46:42'),
(411, NULL, 2, 18, 2, 0, 17650000, '2023-03-23 14:46:42'),
(412, NULL, 2, 18, 2, 1, 19150000, '2023-03-23 14:46:42'),
(413, NULL, 3, 18, 2, 0, 19400000, '2023-03-23 14:46:42'),
(414, NULL, 3, 18, 2, 1, 20900000, '2023-03-23 14:46:42'),
(415, NULL, 4, 18, 2, 0, 14650000, '2023-03-23 14:46:42'),
(416, NULL, 4, 18, 2, 1, 16150000, '2023-03-23 14:46:42'),
(417, NULL, 5, 18, 2, 0, 11750000, '2023-03-23 14:46:42'),
(418, NULL, 5, 18, 2, 1, 13250000, '2023-03-23 14:46:42'),
(419, NULL, 6, 18, 2, 0, 18200000, '2023-03-23 14:46:42'),
(420, NULL, 6, 18, 2, 1, 19700000, '2023-03-23 14:46:42'),
(421, NULL, 7, 18, 2, 0, 19450000, '2023-03-23 14:46:42'),
(422, NULL, 7, 18, 2, 1, 20950000, '2023-03-23 14:46:42'),
(423, NULL, 8, 18, 2, 0, 15200000, '2023-03-23 14:46:42'),
(424, NULL, 8, 18, 2, 1, 16700000, '2023-03-23 14:46:42'),
(425, NULL, 9, 18, 2, 0, 12150000, '2023-03-23 14:46:42'),
(426, NULL, 9, 18, 2, 1, 13650000, '2023-03-23 14:46:42'),
(427, NULL, 10, 18, 2, 0, 19050000, '2023-03-23 14:46:42'),
(428, NULL, 10, 18, 2, 1, 20550000, '2023-03-23 14:46:42'),
(429, NULL, 11, 18, 2, 0, 19850000, '2023-03-23 14:46:42'),
(430, NULL, 11, 18, 2, 1, 21350000, '2023-03-23 14:46:42'),
(431, NULL, 12, 18, 2, 0, 16050000, '2023-03-23 14:46:42'),
(432, NULL, 12, 18, 2, 1, 17550000, '2023-03-23 14:46:42'),
(433, NULL, 1, 19, 2, 0, 12000000, '2023-03-23 14:46:42'),
(434, NULL, 1, 19, 2, 1, 13500000, '2023-03-23 14:46:42'),
(435, NULL, 2, 19, 2, 0, 17950000, '2023-03-23 14:46:42'),
(436, NULL, 2, 19, 2, 1, 19450000, '2023-03-23 14:46:42'),
(437, NULL, 3, 19, 2, 0, 19700000, '2023-03-23 14:46:42'),
(438, NULL, 3, 19, 2, 1, 21200000, '2023-03-23 14:46:42'),
(439, NULL, 4, 19, 2, 0, 14950000, '2023-03-23 14:46:42'),
(440, NULL, 4, 19, 2, 1, 16450000, '2023-03-23 14:46:42'),
(441, NULL, 5, 19, 2, 0, 12050000, '2023-03-23 14:46:42'),
(442, NULL, 5, 19, 2, 1, 13550000, '2023-03-23 14:46:42'),
(443, NULL, 6, 19, 2, 0, 18500000, '2023-03-23 14:46:42'),
(444, NULL, 6, 19, 2, 1, 20000000, '2023-03-23 14:46:42'),
(445, NULL, 7, 19, 2, 0, 19750000, '2023-03-23 14:46:42'),
(446, NULL, 7, 19, 2, 1, 21250000, '2023-03-23 14:46:42'),
(447, NULL, 8, 19, 2, 0, 15500000, '2023-03-23 14:46:42'),
(448, NULL, 8, 19, 2, 1, 17000000, '2023-03-23 14:46:42'),
(449, NULL, 9, 19, 2, 0, 12450000, '2023-03-23 14:46:42'),
(450, NULL, 9, 19, 2, 1, 13950000, '2023-03-23 14:46:42'),
(451, NULL, 10, 19, 2, 0, 19350000, '2023-03-23 14:46:42'),
(452, NULL, 10, 19, 2, 1, 20850000, '2023-03-23 14:46:42'),
(453, NULL, 11, 19, 2, 0, 20150000, '2023-03-23 14:46:42'),
(454, NULL, 11, 19, 2, 1, 21650000, '2023-03-23 14:46:42'),
(455, NULL, 12, 19, 2, 0, 16350000, '2023-03-23 14:46:42'),
(456, NULL, 12, 19, 2, 1, 17850000, '2023-03-23 14:46:42'),
(457, NULL, 1, 20, 2, 0, 11800000, '2023-03-23 14:46:42'),
(458, NULL, 1, 20, 2, 1, 13300000, '2023-03-23 14:46:42'),
(459, NULL, 2, 20, 2, 0, 17750000, '2023-03-23 14:46:42'),
(460, NULL, 2, 20, 2, 1, 19250000, '2023-03-23 14:46:42'),
(461, NULL, 3, 20, 2, 0, 19500000, '2023-03-23 14:46:42'),
(462, NULL, 3, 20, 2, 1, 21000000, '2023-03-23 14:46:42'),
(463, NULL, 4, 20, 2, 0, 14750000, '2023-03-23 14:46:42'),
(464, NULL, 4, 20, 2, 1, 16250000, '2023-03-23 14:46:42'),
(465, NULL, 5, 20, 2, 0, 11850000, '2023-03-23 14:46:42'),
(466, NULL, 5, 20, 2, 1, 13350000, '2023-03-23 14:46:42'),
(467, NULL, 6, 20, 2, 0, 18300000, '2023-03-23 14:46:42'),
(468, NULL, 6, 20, 2, 1, 19800000, '2023-03-23 14:46:42'),
(469, NULL, 7, 20, 2, 0, 19550000, '2023-03-23 14:46:42'),
(470, NULL, 7, 20, 2, 1, 21050000, '2023-03-23 14:46:42'),
(471, NULL, 8, 20, 2, 0, 15300000, '2023-03-23 14:46:42'),
(472, NULL, 8, 20, 2, 1, 16800000, '2023-03-23 14:46:42'),
(473, NULL, 9, 20, 2, 0, 12250000, '2023-03-23 14:46:42'),
(474, NULL, 9, 20, 2, 1, 13750000, '2023-03-23 14:46:42'),
(475, NULL, 10, 20, 2, 0, 19150000, '2023-03-23 14:46:42'),
(476, NULL, 10, 20, 2, 1, 20650000, '2023-03-23 14:46:42'),
(477, NULL, 11, 20, 2, 0, 19950000, '2023-03-23 14:46:42'),
(478, NULL, 11, 20, 2, 1, 21450000, '2023-03-23 14:46:42'),
(479, NULL, 12, 20, 2, 0, 16150000, '2023-03-23 14:46:42'),
(480, NULL, 12, 20, 2, 1, 17650000, '2023-03-23 14:46:42'),
(481, NULL, 1, 21, 2, 0, 11500000, '2023-03-23 14:46:42'),
(482, NULL, 1, 21, 2, 1, 13600000, '2023-03-23 14:46:42'),
(483, NULL, 2, 21, 2, 0, 17450000, '2023-03-23 14:46:42'),
(484, NULL, 2, 21, 2, 1, 19550000, '2023-03-23 14:46:42'),
(485, NULL, 3, 21, 2, 0, 19200000, '2023-03-23 14:46:42'),
(486, NULL, 3, 21, 2, 1, 21300000, '2023-03-23 14:46:42'),
(487, NULL, 4, 21, 2, 0, 14450000, '2023-03-23 14:46:42'),
(488, NULL, 4, 21, 2, 1, 16550000, '2023-03-23 14:46:42'),
(489, NULL, 5, 21, 2, 0, 11550000, '2023-03-23 14:46:42'),
(490, NULL, 5, 21, 2, 1, 13650000, '2023-03-23 14:46:42'),
(491, NULL, 6, 21, 2, 0, 18000000, '2023-03-23 14:46:42'),
(492, NULL, 6, 21, 2, 1, 20100000, '2023-03-23 14:46:42'),
(493, NULL, 7, 21, 2, 0, 19250000, '2023-03-23 14:46:42'),
(494, NULL, 7, 21, 2, 1, 21350000, '2023-03-23 14:46:42'),
(495, NULL, 8, 21, 2, 0, 15000000, '2023-03-23 14:46:42'),
(496, NULL, 8, 21, 2, 1, 17100000, '2023-03-23 14:46:42'),
(497, NULL, 9, 21, 2, 0, 11950000, '2023-03-23 14:46:42'),
(498, NULL, 9, 21, 2, 1, 14050000, '2023-03-23 14:46:42'),
(499, NULL, 10, 21, 2, 0, 18850000, '2023-03-23 14:46:42'),
(500, NULL, 10, 21, 2, 1, 20950000, '2023-03-23 14:46:42'),
(501, NULL, 11, 21, 2, 0, 19650000, '2023-03-23 14:46:42'),
(502, NULL, 11, 21, 2, 1, 21750000, '2023-03-23 14:46:42'),
(503, NULL, 12, 21, 2, 0, 15850000, '2023-03-23 14:46:42'),
(504, NULL, 12, 21, 2, 1, 17950000, '2023-03-23 14:46:42'),
(505, NULL, 1, 22, 2, 0, 11300000, '2023-03-23 14:46:42'),
(506, NULL, 1, 22, 2, 1, 13400000, '2023-03-23 14:46:42'),
(507, NULL, 2, 22, 2, 0, 17250000, '2023-03-23 14:46:42'),
(508, NULL, 2, 22, 2, 1, 19350000, '2023-03-23 14:46:42'),
(509, NULL, 3, 22, 2, 0, 19000000, '2023-03-23 14:46:42'),
(510, NULL, 3, 22, 2, 1, 21100000, '2023-03-23 14:46:42'),
(511, NULL, 4, 22, 2, 0, 14250000, '2023-03-23 14:46:42'),
(512, NULL, 4, 22, 2, 1, 16350000, '2023-03-23 14:46:42'),
(513, NULL, 5, 22, 2, 0, 11350000, '2023-03-23 14:46:42'),
(514, NULL, 5, 22, 2, 1, 13450000, '2023-03-23 14:46:42'),
(515, NULL, 6, 22, 2, 0, 17800000, '2023-03-23 14:46:42'),
(516, NULL, 6, 22, 2, 1, 19900000, '2023-03-23 14:46:42'),
(517, NULL, 7, 22, 2, 0, 19050000, '2023-03-23 14:46:42'),
(518, NULL, 7, 22, 2, 1, 21150000, '2023-03-23 14:46:42'),
(519, NULL, 8, 22, 2, 0, 14800000, '2023-03-23 14:46:42'),
(520, NULL, 8, 22, 2, 1, 16900000, '2023-03-23 14:46:42'),
(521, NULL, 9, 22, 2, 0, 11750000, '2023-03-23 14:46:42'),
(522, NULL, 9, 22, 2, 1, 13850000, '2023-03-23 14:46:42'),
(523, NULL, 10, 22, 2, 0, 18650000, '2023-03-23 14:46:42'),
(524, NULL, 10, 22, 2, 1, 20750000, '2023-03-23 14:46:42'),
(525, NULL, 11, 22, 2, 0, 19450000, '2023-03-23 14:46:42'),
(526, NULL, 11, 22, 2, 1, 21550000, '2023-03-23 14:46:42'),
(527, NULL, 12, 22, 2, 0, 15650000, '2023-03-23 14:46:42'),
(528, NULL, 12, 22, 2, 1, 17750000, '2023-03-23 14:46:42'),
(529, NULL, 1, 23, 2, 0, 11200000, '2023-03-23 14:46:42'),
(530, NULL, 1, 23, 2, 1, 13300000, '2023-03-23 14:46:42'),
(531, NULL, 2, 23, 2, 0, 17150000, '2023-03-23 14:46:42'),
(532, NULL, 2, 23, 2, 1, 19250000, '2023-03-23 14:46:42'),
(533, NULL, 3, 23, 2, 0, 18900000, '2023-03-23 14:46:42'),
(534, NULL, 3, 23, 2, 1, 21000000, '2023-03-23 14:46:42'),
(535, NULL, 4, 23, 2, 0, 14150000, '2023-03-23 14:46:42'),
(536, NULL, 4, 23, 2, 1, 16250000, '2023-03-23 14:46:42'),
(537, NULL, 5, 23, 2, 0, 11250000, '2023-03-23 14:46:42'),
(538, NULL, 5, 23, 2, 1, 13350000, '2023-03-23 14:46:42'),
(539, NULL, 6, 23, 2, 0, 17700000, '2023-03-23 14:46:42'),
(540, NULL, 6, 23, 2, 1, 19800000, '2023-03-23 14:46:42'),
(541, NULL, 7, 23, 2, 0, 18950000, '2023-03-23 14:46:42'),
(542, NULL, 7, 23, 2, 1, 21050000, '2023-03-23 14:46:42'),
(543, NULL, 8, 23, 2, 0, 14700000, '2023-03-23 14:46:42'),
(544, NULL, 8, 23, 2, 1, 16800000, '2023-03-23 14:46:42'),
(545, NULL, 9, 23, 2, 0, 11650000, '2023-03-23 14:46:42'),
(546, NULL, 9, 23, 2, 1, 13750000, '2023-03-23 14:46:42'),
(547, NULL, 10, 23, 2, 0, 18550000, '2023-03-23 14:46:42'),
(548, NULL, 10, 23, 2, 1, 20650000, '2023-03-23 14:46:42'),
(549, NULL, 11, 23, 2, 0, 19350000, '2023-03-23 14:46:42'),
(550, NULL, 11, 23, 2, 1, 21450000, '2023-03-23 14:46:42'),
(551, NULL, 12, 23, 2, 0, 15550000, '2023-03-23 14:46:42'),
(552, NULL, 12, 23, 2, 1, 17650000, '2023-03-23 14:46:42'),
(553, NULL, 1, 24, 2, 0, 11100000, '2023-03-23 14:46:42'),
(554, NULL, 1, 24, 2, 1, 13200000, '2023-03-23 14:46:42'),
(555, NULL, 2, 24, 2, 0, 17050000, '2023-03-23 14:46:42'),
(556, NULL, 2, 24, 2, 1, 19150000, '2023-03-23 14:46:42'),
(557, NULL, 3, 24, 2, 0, 18800000, '2023-03-23 14:46:42'),
(558, NULL, 3, 24, 2, 1, 20900000, '2023-03-23 14:46:42'),
(559, NULL, 4, 24, 2, 0, 14050000, '2023-03-23 14:46:42'),
(560, NULL, 4, 24, 2, 1, 16150000, '2023-03-23 14:46:42'),
(561, NULL, 5, 24, 2, 0, 11150000, '2023-03-23 14:46:42'),
(562, NULL, 5, 24, 2, 1, 13250000, '2023-03-23 14:46:42'),
(563, NULL, 6, 24, 2, 0, 17600000, '2023-03-23 14:46:42'),
(564, NULL, 6, 24, 2, 1, 19700000, '2023-03-23 14:46:42'),
(565, NULL, 7, 24, 2, 0, 18850000, '2023-03-23 14:46:42'),
(566, NULL, 7, 24, 2, 1, 20950000, '2023-03-23 14:46:42'),
(567, NULL, 8, 24, 2, 0, 14600000, '2023-03-23 14:46:42'),
(568, NULL, 8, 24, 2, 1, 16700000, '2023-03-23 14:46:42'),
(569, NULL, 9, 24, 2, 0, 11550000, '2023-03-23 14:46:42'),
(570, NULL, 9, 24, 2, 1, 13650000, '2023-03-23 14:46:42'),
(571, NULL, 10, 24, 2, 0, 18450000, '2023-03-23 14:46:42'),
(572, NULL, 10, 24, 2, 1, 20550000, '2023-03-23 14:46:42'),
(573, NULL, 11, 24, 2, 0, 19250000, '2023-03-23 14:46:42'),
(574, NULL, 11, 24, 2, 1, 21350000, '2023-03-23 14:46:42'),
(575, NULL, 12, 24, 2, 0, 15450000, '2023-03-23 14:46:42'),
(576, NULL, 12, 24, 2, 1, 17550000, '2023-03-23 14:46:42'),
(577, NULL, 1, 25, 2, 0, 11000000, '2023-03-23 14:46:42'),
(578, NULL, 1, 25, 2, 1, 13100000, '2023-03-23 14:46:42'),
(579, NULL, 2, 25, 2, 0, 16950000, '2023-03-23 14:46:42'),
(580, NULL, 2, 25, 2, 1, 19050000, '2023-03-23 14:46:42'),
(581, NULL, 3, 25, 2, 0, 18700000, '2023-03-23 14:46:42'),
(582, NULL, 3, 25, 2, 1, 20800000, '2023-03-23 14:46:42'),
(583, NULL, 4, 25, 2, 0, 13950000, '2023-03-23 14:46:42'),
(584, NULL, 4, 25, 2, 1, 16050000, '2023-03-23 14:46:42'),
(585, NULL, 5, 25, 2, 0, 11050000, '2023-03-23 14:46:42'),
(586, NULL, 5, 25, 2, 1, 13150000, '2023-03-23 14:46:42'),
(587, NULL, 6, 25, 2, 0, 17500000, '2023-03-23 14:46:42'),
(588, NULL, 6, 25, 2, 1, 19600000, '2023-03-23 14:46:42'),
(589, NULL, 7, 25, 2, 0, 18750000, '2023-03-23 14:46:42'),
(590, NULL, 7, 25, 2, 1, 20850000, '2023-03-23 14:46:42'),
(591, NULL, 8, 25, 2, 0, 14500000, '2023-03-23 14:46:42'),
(592, NULL, 8, 25, 2, 1, 16600000, '2023-03-23 14:46:42'),
(593, NULL, 9, 25, 2, 0, 11450000, '2023-03-23 14:46:42'),
(594, NULL, 9, 25, 2, 1, 13550000, '2023-03-23 14:46:42'),
(595, NULL, 10, 25, 2, 0, 18350000, '2023-03-23 14:46:42'),
(596, NULL, 10, 25, 2, 1, 20450000, '2023-03-23 14:46:42'),
(597, NULL, 11, 25, 2, 0, 19150000, '2023-03-23 14:46:42'),
(598, NULL, 11, 25, 2, 1, 21250000, '2023-03-23 14:46:42'),
(599, NULL, 12, 25, 2, 0, 15350000, '2023-03-23 14:46:42'),
(600, NULL, 12, 25, 2, 1, 17450000, '2023-03-23 14:46:42'),
(601, NULL, 1, 26, 2, 0, 10900000, '2023-03-23 14:46:42'),
(602, NULL, 1, 26, 2, 1, 13000000, '2023-03-23 14:46:42'),
(603, NULL, 2, 26, 2, 0, 16850000, '2023-03-23 14:46:42'),
(604, NULL, 2, 26, 2, 1, 18950000, '2023-03-23 14:46:42'),
(605, NULL, 3, 26, 2, 0, 18600000, '2023-03-23 14:46:42'),
(606, NULL, 3, 26, 2, 1, 20700000, '2023-03-23 14:46:42'),
(607, NULL, 4, 26, 2, 0, 13850000, '2023-03-23 14:46:42'),
(608, NULL, 4, 26, 2, 1, 15950000, '2023-03-23 14:46:42'),
(609, NULL, 5, 26, 2, 0, 10950000, '2023-03-23 14:46:42'),
(610, NULL, 5, 26, 2, 1, 13050000, '2023-03-23 14:46:42'),
(611, NULL, 6, 26, 2, 0, 17400000, '2023-03-23 14:46:42'),
(612, NULL, 6, 26, 2, 1, 19500000, '2023-03-23 14:46:42'),
(613, NULL, 7, 26, 2, 0, 18650000, '2023-03-23 14:46:42'),
(614, NULL, 7, 26, 2, 1, 20750000, '2023-03-23 14:46:42'),
(615, NULL, 8, 26, 2, 0, 14400000, '2023-03-23 14:46:42'),
(616, NULL, 8, 26, 2, 1, 16500000, '2023-03-23 14:46:42'),
(617, NULL, 9, 26, 2, 0, 11350000, '2023-03-23 14:46:42'),
(618, NULL, 9, 26, 2, 1, 13450000, '2023-03-23 14:46:42'),
(619, NULL, 10, 26, 2, 0, 18250000, '2023-03-23 14:46:42'),
(620, NULL, 10, 26, 2, 1, 20350000, '2023-03-23 14:46:42'),
(621, NULL, 11, 26, 2, 0, 19050000, '2023-03-23 14:46:42'),
(622, NULL, 11, 26, 2, 1, 21150000, '2023-03-23 14:46:42'),
(623, NULL, 12, 26, 2, 0, 15250000, '2023-03-23 14:46:42'),
(624, NULL, 12, 26, 2, 1, 17350000, '2023-03-23 14:46:42');

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

--
-- Table structure for table `doto_ho_kategoribarang`
--

CREATE TABLE `doto_ho_kategoribarang` (
  `idkategoribarang` smallint UNSIGNED NOT NULL,
  `kodekategoribarang` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `namakategoribarang` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tersedia` tinyint UNSIGNED NOT NULL COMMENT '0 = tidak tersedia ; 1 = tersedia'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `doto_ho_kategoribarang`
--

INSERT INTO `doto_ho_kategoribarang` (`idkategoribarang`, `kodekategoribarang`, `namakategoribarang`, `tersedia`) VALUES
(1, 'ML', 'Motor Listrik', 1);

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

--
-- Table structure for table `doto_ho_kategoribisnis`
--

CREATE TABLE `doto_ho_kategoribisnis` (
  `idkategoribisnis` smallint UNSIGNED NOT NULL,
  `namakategoribisnis` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `doto_ho_kategoripelanggan`
--

CREATE TABLE `doto_ho_kategoripelanggan` (
  `idkategoripelanggan` smallint UNSIGNED NOT NULL,
  `namakategoripelanggan` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `doto_ho_kota`
--

CREATE TABLE `doto_ho_kota` (
  `idkota` smallint UNSIGNED NOT NULL,
  `idpropinsi` int UNSIGNED NOT NULL,
  `namakota` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_ho_kota`
--

INSERT INTO `doto_ho_kota` (`idkota`, `idpropinsi`, `namakota`) VALUES
(1, 1, 'Aceh Selatan'),
(2, 1, 'Aceh Tenggara'),
(3, 1, 'Aceh Timur'),
(4, 1, 'Aceh Tengah'),
(5, 1, 'Aceh Barat'),
(6, 1, 'Aceh Besar'),
(7, 1, 'Aceh Utara'),
(8, 1, 'Simeulue'),
(9, 1, 'Aceh Singkil'),
(10, 1, 'Bireuen'),
(11, 1, 'Aceh Barat Daya'),
(12, 1, 'Gayo Lues'),
(13, 1, 'Aceh Jaya'),
(14, 1, 'Nagan Raya'),
(15, 1, 'Aceh Tamiang'),
(16, 1, 'Bener Meriah'),
(17, 1, 'Pidie Jaya'),
(18, 1, 'Banda Aceh'),
(19, 1, 'Sabang'),
(20, 1, 'Lhokseumawe'),
(21, 1, 'Langsa'),
(22, 1, 'Subulussalam'),
(23, 2, 'Gunung Sitoli'),
(24, 2, 'Lubuk Pakam'),
(25, 2, 'Perbaungan'),
(26, 2, 'Tapanuli Tengah'),
(27, 2, 'Tapanuli Utara'),
(28, 2, 'Tapanuli Selatan'),
(29, 2, 'Nias'),
(30, 2, 'Langkat'),
(31, 2, 'Stabat'),
(32, 2, 'Karo'),
(33, 2, 'Berastagi'),
(34, 2, 'Tanjung Morawa'),
(35, 2, 'Deli Serdang'),
(36, 2, 'Simalungun'),
(37, 2, 'Asahan'),
(38, 2, 'Labuhan Batu'),
(39, 2, 'Dairi'),
(40, 2, 'Toba Samosir'),
(41, 2, 'Mandailing Natal'),
(42, 2, 'Nias Selatan'),
(43, 2, 'Pakpak Barat'),
(44, 2, 'Humbang Hasundutan'),
(45, 2, 'Samosir'),
(46, 2, 'Serdang Bedagai'),
(47, 2, 'Batubara'),
(48, 2, 'Padang Lawas Utara'),
(49, 2, 'Padang Lawas'),
(50, 2, 'Labuhan Batu Selatan'),
(51, 2, 'Labuhan Batu Utara'),
(52, 2, 'Nias Utara'),
(53, 2, 'Nias Barat'),
(54, 2, 'Medan'),
(55, 2, 'Pematang Siantar'),
(56, 2, 'Sibolga'),
(57, 2, 'Tanjung Balai'),
(58, 2, 'Binjai'),
(59, 2, 'Tebing Tinggi'),
(60, 2, 'Padang Sidimpuan'),
(61, 3, 'Pesisir Selatan'),
(62, 3, 'Solok Kab.'),
(63, 3, 'Sawah Lunto/Sijunjung'),
(64, 3, 'Tanah Datar'),
(65, 3, 'Padang Pariaman'),
(66, 3, 'Agam'),
(67, 3, 'Lima Puluh Kota'),
(68, 3, 'Pasaman'),
(69, 3, 'Kepulauan Mentawai'),
(70, 3, 'Dharmasraya'),
(71, 3, 'Solok Selatan'),
(72, 3, 'Pasaman Barat'),
(73, 3, 'Padang'),
(74, 3, 'Solok'),
(75, 3, 'Sawah Lunto'),
(76, 3, 'Padang Panjang'),
(77, 3, 'Bukittinggi'),
(78, 3, 'Payakumbuh'),
(79, 3, 'Pariaman'),
(80, 4, 'Kampar'),
(81, 4, 'Indragiri Hulu'),
(82, 4, 'Bengkalis'),
(83, 4, 'Indragiri Hilir'),
(84, 4, 'Pelalawan'),
(85, 4, 'Rokan Hulu'),
(86, 4, 'Rokan Hilir'),
(87, 4, 'Siak'),
(88, 4, 'Kuantan Singingi'),
(89, 4, 'Kep. Meranti'),
(90, 4, 'Pekanbaru'),
(91, 4, 'Dumai'),
(92, 5, 'Kerinci'),
(93, 5, 'Merangin'),
(94, 5, 'Sorolangun'),
(95, 5, 'Batang Hari'),
(96, 5, 'Muaro Jambi'),
(97, 5, 'Tanjung Jabung Barat'),
(98, 5, 'Tanjung Jabung Timur'),
(99, 5, 'Bungo'),
(100, 5, 'Tebo'),
(101, 5, 'Jambi'),
(102, 5, 'Sungai Penuh'),
(103, 6, 'Ogan Komering Ulu'),
(104, 6, 'Ogan Komering Ilir'),
(105, 6, 'Muara Enim'),
(106, 6, 'Lahat'),
(107, 6, 'Musi Rawas'),
(108, 6, 'Musi Banyuasin'),
(109, 6, 'Banyuasin'),
(110, 6, 'Oku Timur'),
(111, 6, 'Oku Selatan'),
(112, 6, 'Ogan Ilir'),
(113, 6, 'Empat Lawang'),
(114, 6, 'Palembang'),
(115, 6, 'Pagar Alam'),
(116, 6, 'Lubuk Linggau'),
(117, 6, 'Prabumulih'),
(118, 7, 'Bengkulu Selatan'),
(119, 7, 'Rejang Lebong'),
(120, 7, 'Bengkulu Utara'),
(121, 7, 'Kaur'),
(122, 7, 'Seluma'),
(123, 7, 'Muko Muko'),
(124, 7, 'Lebong'),
(125, 7, 'Kepahiang'),
(126, 7, 'Bengkulu Tengah'),
(127, 7, 'Bengkulu'),
(128, 8, 'Lampung'),
(129, 8, 'Lampung Selatan'),
(130, 8, 'Lampung Tengah'),
(131, 8, 'Lampung Utara'),
(132, 8, 'Lampung Barat'),
(133, 8, 'Tulang Bawang'),
(134, 8, 'Tanggamus'),
(135, 8, 'Lampung Timur'),
(136, 8, 'Way Kanan'),
(137, 8, 'Pesawaran'),
(138, 8, 'Pringsewu'),
(139, 8, 'Mesuji'),
(140, 8, 'Tulang Bawang Barat'),
(141, 8, 'Bandar Lampung'),
(142, 8, 'Metro'),
(143, 9, 'Bangka'),
(144, 9, 'Belitung'),
(145, 9, 'Bangka Selatan'),
(146, 9, 'Bangka Tengah'),
(147, 9, 'Bangka Barat'),
(148, 9, 'Bangka Belitung'),
(149, 9, 'Pangkal Pinang'),
(150, 10, 'Bintan'),
(151, 10, 'Karimun'),
(152, 10, 'Natuna'),
(153, 10, 'Lingga'),
(154, 10, 'Kepulauan Anambas'),
(155, 10, 'Batam'),
(156, 10, 'Tanjung Pinang'),
(157, 11, 'Kepulauan Seribu'),
(158, 11, 'Jakarta Pusat'),
(159, 11, 'Jakarta Utara'),
(160, 11, 'Jakarta Barat'),
(161, 11, 'Jakarta Selatan'),
(162, 11, 'Jakarta Timur'),
(163, 12, 'Bogor Kab.'),
(164, 12, 'Sukabumi Kab.'),
(165, 12, 'Cianjur'),
(166, 12, 'Bandung Kab.'),
(167, 12, 'Garut'),
(168, 12, 'Tasikmalaya Kab.1'),
(169, 12, 'Ciamis'),
(170, 12, 'Kuningan'),
(171, 12, 'Cirebon Kab.'),
(172, 12, 'Majalengka'),
(173, 12, 'Sumedang'),
(174, 12, 'Indramayu'),
(175, 12, 'Subang'),
(176, 12, 'Purwakarta'),
(177, 12, 'Karawang'),
(178, 12, 'Bekasi Kab.'),
(179, 12, 'Bandung Barat'),
(180, 12, 'Bogor'),
(181, 12, 'Sukabumi'),
(182, 12, 'Bandung'),
(183, 12, 'Cirebon'),
(184, 12, 'Bekasi'),
(185, 12, 'Depok'),
(186, 12, 'Cimahi'),
(187, 12, 'Tasikmalaya'),
(188, 13, 'Wonogiri'),
(189, 13, 'Karanganyar'),
(190, 13, 'Sragen'),
(191, 13, 'Grobogan'),
(192, 13, 'Blora'),
(193, 13, 'Rembang'),
(194, 13, 'Pati'),
(195, 13, 'Kudus'),
(196, 13, 'Jepara'),
(197, 13, 'Demak'),
(198, 13, 'Semarang Kab.'),
(199, 13, 'Temanggung'),
(200, 13, 'Kendal'),
(201, 13, 'Batang'),
(202, 13, 'Pekalongan Kab.'),
(203, 13, 'Pemalang'),
(204, 13, 'Tegal Kab.'),
(205, 13, 'Brebes'),
(206, 13, 'Magelang'),
(207, 13, 'Surakarta'),
(208, 13, 'Pedurungan'),
(209, 13, 'Gunung Pati'),
(210, 13, 'Banyumanik'),
(211, 13, 'Gajah Mungkur'),
(212, 13, 'Salatiga'),
(213, 13, 'Tembalang'),
(214, 13, 'Semarang'),
(215, 13, 'Pekalongan'),
(216, 13, 'Solo'),
(217, 13, 'Tegal'),
(218, 13, 'Banjarsari'),
(219, 13, 'Kartosuro'),
(220, 13, 'Ungaran'),
(221, 13, 'Purwokerto'),
(222, 13, 'Cilacap'),
(223, 13, 'Banyumas'),
(224, 13, 'Purbalingga'),
(225, 13, 'Banjarnegara'),
(226, 13, 'Kebumen'),
(227, 13, 'Purworejo'),
(228, 13, 'Wonosobo'),
(229, 13, 'Magelang Kab.'),
(230, 13, 'Boyolali'),
(231, 13, 'Klaten'),
(232, 13, 'Sukoharjo'),
(233, 14, 'Kulon Progo'),
(234, 14, 'Bantul'),
(235, 14, 'Gunung Kidul'),
(236, 14, 'Sleman'),
(237, 14, 'Yogyakarta'),
(238, 15, 'Sidoarjo'),
(239, 15, 'Mojokerto'),
(240, 15, 'Jombang'),
(241, 15, 'Nganjuk'),
(242, 15, 'Madiun Kab.'),
(243, 15, 'Magetan'),
(244, 15, 'Ngawi'),
(245, 15, 'Bojonegoro'),
(246, 15, 'Tuban'),
(247, 15, 'Lamongan'),
(248, 15, 'Gresik'),
(249, 15, 'Bangkalan'),
(250, 15, 'Pandaan'),
(251, 15, 'Sampang'),
(252, 15, 'Pamekasan'),
(253, 15, 'Sumenep'),
(254, 15, 'Kediri'),
(255, 15, 'Blitar'),
(256, 15, 'Malang'),
(257, 15, 'Probolinggo'),
(258, 15, 'Pasuruan'),
(259, 15, 'Pacitan'),
(260, 15, 'Mojokerto'),
(261, 15, 'Madiun'),
(262, 15, 'Surabaya'),
(263, 15, 'Batu'),
(264, 15, 'Ponorogo'),
(265, 15, 'Trenggalek'),
(266, 15, 'Tulungagung'),
(267, 15, 'Blitar Kab.'),
(268, 15, 'Kediri Kab.'),
(269, 15, 'Malang Kab.'),
(270, 15, 'Lumajang'),
(271, 15, 'Jember'),
(272, 15, 'Banyuwangi'),
(273, 15, 'Bondowoso'),
(274, 15, 'Situbondo'),
(275, 15, 'Probolinggo Kab.'),
(276, 15, 'Pasuruan Kab.'),
(277, 16, 'Banten'),
(278, 16, 'Pandeglang'),
(279, 16, 'Lebak'),
(280, 16, 'Tangerang Kab.'),
(281, 16, 'Serang Kab.'),
(282, 16, 'Tangerang'),
(283, 16, 'Cilegon'),
(284, 16, 'Serang'),
(285, 16, 'Tangerang Selatan'),
(286, 17, 'Ubud'),
(287, 17, 'Jembarana'),
(288, 17, 'Tabanan'),
(289, 17, 'Badung'),
(290, 17, 'Gianyar'),
(291, 17, 'Klungkung'),
(292, 17, 'Bangli'),
(293, 17, 'Karangasem'),
(294, 17, 'Buleleng'),
(295, 17, 'Denpasar'),
(296, 18, 'Lombok'),
(297, 18, 'Lombok Barat'),
(298, 18, 'Lombok Tengah'),
(299, 18, 'Lombok Timur'),
(300, 18, 'Sumbawa'),
(301, 18, 'Dompu'),
(302, 18, 'Bima Kab.'),
(303, 18, 'Sumbawa Barat'),
(304, 18, 'Lombok Utara'),
(305, 18, 'Mataram'),
(306, 18, 'Bima'),
(307, 19, 'Kupang Kab.'),
(308, 19, 'Timor Tengah Selatan'),
(309, 19, 'Timor Tengah Utara'),
(310, 19, 'Belu'),
(311, 19, 'Alor'),
(312, 19, 'Flores Timur'),
(313, 19, 'Sikka'),
(314, 19, 'Ende'),
(315, 19, 'Ngada'),
(316, 19, 'Manggarai'),
(317, 19, 'Sumba Timur'),
(318, 19, 'Sumba Barat'),
(319, 19, 'Lembata'),
(320, 19, 'Rote Ndao'),
(321, 19, 'Manggarai Barat'),
(322, 19, 'Nagekeo'),
(323, 19, 'Sumba Tengah'),
(324, 19, 'Sumba Barat Daya'),
(325, 19, 'Manggarai Timur'),
(326, 19, 'Sabu Raijua'),
(327, 19, 'Kupang'),
(328, 20, 'Kab.Mempawah'),
(329, 20, 'Sambas'),
(330, 20, 'Pontianak Kab.'),
(331, 20, 'Sanggau'),
(332, 20, 'Ketapang'),
(333, 20, 'Sintang'),
(334, 20, 'Kapuas Hulu'),
(335, 20, 'Bengkayang'),
(336, 20, 'Landak'),
(337, 20, 'Sekadau'),
(338, 20, 'Melawi'),
(339, 20, 'Kayong Utara'),
(340, 20, 'Kubu Raya'),
(341, 20, 'Pontianak'),
(342, 20, 'Singkawang'),
(343, 21, 'Kotawaringin Barat'),
(344, 21, 'Kotawaringin Timur'),
(345, 21, 'Kapuas'),
(346, 21, 'Barito Selatan'),
(347, 21, 'Barito Utara'),
(348, 21, 'Katingan'),
(349, 21, 'Seruyan'),
(350, 21, 'Sukamara'),
(351, 21, 'Lamandau'),
(352, 21, 'Gunung Mas'),
(353, 21, 'Pulang Pisau'),
(354, 21, 'Murung Raya'),
(355, 21, 'Barito Timur'),
(356, 21, 'Palangkaraya'),
(357, 22, 'Tanah Laut'),
(358, 22, 'Kotabaru'),
(359, 22, 'Banjar'),
(360, 22, 'Barito Kuala'),
(361, 22, 'Tapin'),
(362, 22, 'Hulu Sungai Selatan'),
(363, 22, 'Hulu Sungai Tengah'),
(364, 22, 'Hulu Sungai Utara'),
(365, 22, 'Tabalong'),
(366, 22, 'Tanah Bumbu'),
(367, 22, 'Balangan'),
(368, 22, 'Banjarmasin'),
(369, 22, 'Banjarbaru'),
(370, 23, 'Grogot'),
(371, 23, 'Tenggarong'),
(372, 23, 'Sangatta'),
(373, 23, 'Paser'),
(374, 23, 'Kutai Kertanegara'),
(375, 23, 'Berau'),
(376, 23, 'Bulungan'),
(377, 23, 'Nunukan'),
(378, 23, 'Malinau'),
(379, 23, 'Kutai Barat'),
(380, 23, 'Kutai Timur'),
(381, 23, 'Penajam Paser Utara'),
(382, 23, 'Tana Tidung'),
(383, 23, 'Balikpapan'),
(384, 23, 'Samarinda'),
(385, 23, 'Tarakan'),
(386, 23, 'Bontang'),
(387, 24, 'Bolaang Mangondow'),
(388, 24, 'Minahasa'),
(389, 24, 'Kepulauan Sangihe'),
(390, 24, 'Kepulauan Talaud'),
(391, 24, 'Minahasa Selatan'),
(392, 24, 'Minahasa Utara'),
(393, 24, 'Minahasa Tenggara'),
(394, 24, 'Bolmong Utara'),
(395, 24, 'Kep. Sitaro'),
(396, 24, 'Bolmong Timur'),
(397, 24, 'Bolmong Utara Selatan'),
(398, 24, 'Manado'),
(399, 24, 'Bitung'),
(400, 24, 'Tomohon'),
(401, 24, 'Kotamobagu'),
(402, 25, 'Tojo Una Una'),
(403, 25, 'Sigi'),
(404, 25, 'Palu'),
(405, 25, 'Banggai'),
(406, 25, 'Poso'),
(407, 25, 'Donggala'),
(408, 25, 'Toli Toli'),
(409, 25, 'Buol'),
(410, 25, 'Morowali'),
(411, 25, 'Banggai Kepulauan'),
(412, 25, 'Parigi Moutong'),
(413, 26, 'Kepulauan Selayar'),
(414, 26, 'Bulukumba'),
(415, 26, 'Bantaeng'),
(416, 26, 'Jeneponto'),
(417, 26, 'Takalar'),
(418, 26, 'Gowa'),
(419, 26, 'Sinjai'),
(420, 26, 'Bone'),
(421, 26, 'Maros'),
(422, 26, 'Pangkajene Kepulauan'),
(423, 26, 'Barru'),
(424, 26, 'Soppeng'),
(425, 26, 'Wajo'),
(426, 26, 'Sidenreng Rappang'),
(427, 26, 'Pinrang'),
(428, 26, 'Enrekang'),
(429, 26, 'Luwu'),
(430, 26, 'Tana Toraja'),
(431, 26, 'Luwu Utara'),
(432, 26, 'Luwu Timur'),
(433, 26, 'Toraja Utara'),
(434, 26, 'Makassar'),
(435, 26, 'Pare Pare'),
(436, 26, 'Palopo'),
(437, 26, 'Pangkep'),
(438, 26, 'Belopa'),
(439, 26, 'Segeri Pangkep'),
(440, 27, 'Kolaka'),
(441, 27, 'Konawe'),
(442, 27, 'Muna'),
(443, 27, 'Buton'),
(444, 27, 'Konawe Selatan'),
(445, 27, 'Bombana'),
(446, 27, 'Wakatobi'),
(447, 27, 'Kolaka Utara'),
(448, 27, 'Konawe Utara'),
(449, 27, 'Buton Utara'),
(450, 27, 'Kendari'),
(451, 27, 'Bau Bau'),
(452, 28, 'Gorontalo Kab.'),
(453, 28, 'Boalemo'),
(454, 28, 'Bone Bolango'),
(455, 28, 'Pahuwato'),
(456, 28, 'Gorontalo Utara'),
(457, 28, 'Gorontalo'),
(458, 29, 'Mamuju Utara'),
(459, 29, 'Mamuju'),
(460, 29, 'Mamasa'),
(461, 29, 'Polewali Mandar'),
(462, 29, 'Majene'),
(463, 30, 'Maluku Tengah'),
(464, 30, 'Maluku Tenggara'),
(465, 30, 'Maluku Tenggara Barat'),
(466, 30, 'Buru'),
(467, 30, 'Seram Bagian Barat'),
(468, 30, 'Seram Bagian Timur'),
(469, 30, 'Kepulauan Aru'),
(470, 30, 'Maluku Barat Daya'),
(471, 30, 'Buru Selatan'),
(472, 30, 'Ambon'),
(473, 30, 'Tual'),
(474, 31, 'Halmahera Barat'),
(475, 31, 'Halmahera Tengah'),
(476, 31, 'Halmahera Utara'),
(477, 31, 'Halmahera Selatan'),
(478, 31, 'Kepulauan Sula'),
(479, 31, 'Halmahera Timur'),
(480, 31, 'Pulau Morotai'),
(481, 31, 'Ternate'),
(482, 31, 'Tidore Kepulauan'),
(483, 32, 'Deiyai'),
(484, 32, 'Jayapura'),
(485, 32, 'Merauke'),
(486, 32, 'Jayawijaya'),
(487, 32, 'Jayapura Kab.'),
(488, 32, 'Nabire'),
(489, 32, 'Kepulauan Yapen'),
(490, 32, 'Biak Numfor'),
(491, 32, 'Puncak Jaya'),
(492, 32, 'Paniai'),
(493, 32, 'Mimika'),
(494, 32, 'Sarmi'),
(495, 32, 'Keerom'),
(496, 32, 'Pegunungan Bintang'),
(497, 32, 'Yahukimo'),
(498, 32, 'Tolikara'),
(499, 32, 'Waropen'),
(500, 32, 'Boven Digoel'),
(501, 32, 'Mappi'),
(502, 32, 'Asmat'),
(503, 32, 'Supiori'),
(504, 32, 'Mamberamo Raya'),
(505, 32, 'Mamberamo Tengah'),
(506, 32, 'Yalimo'),
(507, 32, 'Lanny Jaya'),
(508, 32, 'Nduga'),
(509, 32, 'Puncak'),
(510, 32, 'Dogiyai'),
(511, 32, 'Intan Jaya'),
(512, 33, 'Sorong Kab.'),
(513, 33, 'Manokwari'),
(514, 33, 'Fak Fak'),
(515, 33, 'Sorong Selatan'),
(516, 33, 'Raja Ampat'),
(517, 33, 'Teluk Bentuni'),
(518, 33, 'Teluk Wondama'),
(519, 33, 'Kaimana'),
(520, 33, 'Tambrauw'),
(521, 33, 'Maybrat'),
(522, 33, 'Sorong');

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

--
-- Table structure for table `doto_ho_logakses`
--

CREATE TABLE `doto_ho_logakses` (
  `idlogakses` bigint UNSIGNED NOT NULL,
  `username` varchar(25) NOT NULL,
  `keterangan` varchar(50) NOT NULL,
  `tgllogakses` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `doto_ho_logakses`
--

INSERT INTO `doto_ho_logakses` (`idlogakses`, `username`, `keterangan`, `tgllogakses`) VALUES
(1, 'admdoto', 'LOGIN', '2023-04-22 10:05:10'),
(2, 'admdoto', 'LOGIN', '2023-04-22 12:16:26'),
(3, 'admdoto', 'LOGIN', '2023-04-22 13:16:22'),
(4, 'admdoto', 'TAMBAH GROUP PENGGUNA SALES ADMIN', '2023-04-22 13:43:36'),
(5, 'admdoto', 'TAMBAH PENGGUNA ADMSALES', '2023-04-22 14:02:03'),
(6, 'admdoto', 'LOGOUT', '2023-04-22 14:04:21'),
(7, 'admsales', 'LOGIN', '2023-04-22 14:04:45'),
(8, 'admsales', 'LOGIN', '2023-04-22 15:30:25'),
(9, 'admsales', 'LOGIN', '2023-04-22 19:38:10'),
(10, 'admsales', 'LOGIN', '2023-04-23 07:48:01'),
(11, 'admsales', 'LOGIN', '2023-04-23 09:21:14'),
(12, 'admsales', 'LOGIN', '2023-04-23 14:39:07'),
(13, 'admsales', 'LOGIN', '2023-04-23 16:56:38'),
(14, 'admsales', 'LOGIN', '2023-04-24 11:57:40'),
(15, 'admsales', 'LOGIN', '2023-04-24 16:52:58'),
(16, 'admsales', 'LOGIN', '2023-04-25 10:16:22'),
(17, 'admsales', 'LOGIN', '2023-04-25 12:13:10'),
(18, 'admsales', 'LOGIN', '2023-04-25 16:21:24'),
(19, 'admsales', 'LOGIN', '2023-04-25 17:51:19'),
(20, 'admsales', 'LOGIN', '2023-04-26 09:48:42'),
(21, 'admsales', 'LOGIN', '2023-04-26 09:50:15'),
(22, 'admsales', 'LOGIN', '2023-04-26 10:01:46'),
(23, 'admsales', 'LOGIN', '2023-04-26 10:08:16'),
(24, 'admsales', 'LOGIN', '2023-04-26 10:08:25'),
(25, 'admsales', 'LOGIN', '2023-04-26 10:08:40'),
(26, 'admsales', 'LOGIN', '2023-04-26 10:08:55'),
(27, 'admsales', 'LOGIN', '2023-04-26 10:12:07'),
(28, 'admsales', 'LOGIN', '2023-04-26 10:17:38'),
(29, 'admsales', 'LOGIN', '2023-04-26 10:18:41'),
(30, 'admsales', 'LOGIN', '2023-04-26 10:27:14'),
(31, 'admsales', 'LOGIN', '2023-04-26 14:50:41'),
(32, 'admsales', 'LOGIN', '2023-04-26 17:52:02'),
(33, 'admdoto', 'LOGIN', '2023-05-05 12:41:43'),
(34, 'admdoto', 'LOGIN', '2023-05-05 12:45:51'),
(35, 'admdoto', 'LOGIN', '2023-05-05 14:09:40'),
(36, 'admdoto', 'LOGIN', '2023-05-07 13:35:57'),
(37, 'admdoto', 'LOGIN', '2023-05-07 19:10:42'),
(38, 'admdoto', 'LOGIN', '2023-05-08 11:15:42'),
(39, 'admdoto', 'LOGIN', '2023-05-08 15:43:09'),
(40, 'admdoto', 'LOGIN', '2023-05-08 16:43:20'),
(41, 'admdoto', 'LOGIN', '2023-05-09 08:00:42'),
(42, 'admdoto', 'LOGIN', '2023-05-09 14:20:36'),
(43, 'admdoto', 'LOGIN', '2023-05-09 17:14:32'),
(44, 'admdoto', 'LOGIN', '2023-05-10 16:17:01'),
(45, 'admdoto', 'LOGIN', '2023-05-10 17:23:44'),
(46, 'admdoto', 'LOGIN', '2023-05-11 07:44:30'),
(47, 'admdoto', 'LOGIN', '2023-05-11 14:32:41'),
(48, 'admdoto', 'LOGIN', '2023-05-11 15:24:04'),
(49, 'admdoto', 'LOGIN', '2023-05-11 17:57:13'),
(50, 'admdoto', 'LOGIN', '2023-05-14 10:32:47'),
(51, 'admdoto', 'LOGIN', '2023-05-14 14:30:00'),
(52, 'admdoto', 'LOGIN', '2023-05-14 14:54:51'),
(53, 'admdoto', 'LOGIN', '2023-05-17 09:30:19'),
(54, 'admdoto', 'LOGIN', '2023-05-17 15:58:12'),
(55, 'admdoto', 'LOGOUT', '2023-05-17 15:58:50'),
(56, 'admsales', 'LOGIN', '2023-05-17 15:58:57'),
(57, 'admsales', 'LOGOUT', '2023-05-17 16:05:39'),
(58, 'admdoto', 'LOGIN', '2023-05-17 16:05:43'),
(59, 'admdoto', 'LOGIN', '2023-05-19 07:35:16'),
(60, 'admdoto', 'LOGIN', '2023-05-19 09:53:33'),
(61, 'admdoto', 'LOGIN', '2023-05-19 11:24:15'),
(62, 'admdoto', 'LOGIN', '2023-05-19 14:21:15'),
(63, 'admdoto', 'LOGIN', '2023-05-19 15:04:22'),
(64, 'admdoto', 'LOGIN', '2023-05-19 17:10:25'),
(65, 'admdoto', 'LOGIN', '2023-05-19 18:09:54'),
(66, 'admdoto', 'LOGIN', '2023-05-20 14:42:47'),
(67, 'admdoto', 'LOGIN', '2023-05-20 15:17:05'),
(68, 'admdoto', 'LOGIN', '2023-05-20 16:09:46'),
(69, 'admdoto', 'LOGIN', '2023-05-21 14:05:22'),
(70, 'admdoto', 'LOGIN', '2023-05-21 17:04:51'),
(71, 'admdoto', 'LOGIN', '2023-05-21 19:08:48'),
(72, 'admdoto', 'LOGIN', '2023-05-22 10:20:16'),
(73, 'admdoto', 'LOGIN', '2023-05-22 13:05:45'),
(74, 'admdoto', 'LOGOUT', '2023-05-22 14:22:53'),
(75, 'admsales', 'LOGIN', '2023-05-22 14:23:10'),
(76, 'admdoto', 'LOGIN', '2023-05-22 14:26:32'),
(77, 'admdoto', 'LOGIN', '2023-05-22 16:35:47'),
(78, 'admsales', 'LOGIN', '2023-05-23 08:36:50'),
(79, 'admsales', 'LOGIN', '2023-05-23 08:51:58'),
(80, 'admsales', 'LOGIN', '2023-05-23 10:08:12'),
(81, 'admsales', 'LOGIN', '2023-05-23 10:17:43'),
(82, 'admdoto', 'LOGIN', '2023-05-23 10:26:28'),
(83, 'admsales', 'LOGOUT', '2023-05-23 10:43:51'),
(84, 'admsales', 'LOGIN', '2023-05-23 10:50:11'),
(85, 'admsales', 'LOGIN', '2023-05-23 15:06:30'),
(86, 'admsales', 'LOGIN', '2023-05-23 15:19:25'),
(87, 'admsales', 'LOGIN', '2023-05-23 15:30:10'),
(88, 'admsales', 'LOGIN', '2023-05-23 15:37:42'),
(89, 'admdoto', 'LOGIN', '2023-05-23 15:38:29'),
(90, 'admsales', 'LOGIN', '2023-05-23 16:46:51'),
(91, 'admsales', 'LOGIN', '2023-05-24 09:08:31'),
(92, '', 'LOGOUT', '2023-05-24 09:09:25'),
(93, 'admdoto', 'LOGIN', '2023-05-24 09:10:41'),
(94, 'admdoto', 'LOGIN', '2023-05-24 12:12:09'),
(95, 'admsales', 'LOGIN', '2023-05-24 12:12:16'),
(96, 'admsales', 'LOGIN', '2023-05-26 08:26:14'),
(97, 'admdoto', 'LOGIN', '2023-05-26 08:27:04'),
(98, 'admsales', 'LOGIN', '2023-05-26 14:51:04'),
(99, 'admsales', 'LOGIN', '2023-05-26 18:48:32');

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

--
-- Table structure for table `doto_ho_merek`
--

CREATE TABLE `doto_ho_merek` (
  `idmerek` int UNSIGNED NOT NULL,
  `idkategoribarang` int UNSIGNED NOT NULL,
  `kodemerek` varchar(5) NOT NULL,
  `namamerek` varchar(50) NOT NULL,
  `tersedia` tinyint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `doto_ho_merek`
--

INSERT INTO `doto_ho_merek` (`idmerek`, `idkategoribarang`, `kodemerek`, `namamerek`, `tersedia`) VALUES
(1, 1, 'VT', 'Volta', 1);

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

--
-- Table structure for table `doto_ho_model`
--

CREATE TABLE `doto_ho_model` (
  `idmodel` int UNSIGNED NOT NULL,
  `idmerek` int UNSIGNED NOT NULL,
  `groupmodel` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kodemodel` varchar(5) NOT NULL,
  `namamodel` varchar(50) NOT NULL,
  `spesifikasi` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tersedia` tinyint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `doto_ho_model`
--

INSERT INTO `doto_ho_model` (`idmodel`, `idmerek`, `groupmodel`, `kodemodel`, `namamodel`, `spesifikasi`, `tersedia`) VALUES
(1, 1, '401', '401L', '401 Lite', 'doto_ho_spekmotor', 1),
(2, 1, '401', '401R', '401 Reguler', 'doto_ho_spekmotor', 1),
(3, 1, '401', '401S', '401 S', 'doto_ho_spekmotor', 1),
(4, 1, '401', '401VP', 'VoltaPlus 401', 'doto_ho_spekmotor', 1),
(5, 1, 'VIRGO', 'VRGL', 'Virgo Lite', 'doto_ho_spekmotor', 1),
(6, 1, 'VIRGO', 'VRGR', 'Virgo Reguler', 'doto_ho_spekmotor', 1),
(7, 1, 'VIRGO', 'VRGS', 'Virgo S', 'doto_ho_spekmotor', 1),
(8, 1, 'VIRGO', 'VRGVP', 'VoltaPlus Virgo', 'doto_ho_spekmotor', 1),
(9, 1, 'MANDALA', 'MDLL', 'Mandala Lite', 'doto_ho_spekmotor', 1),
(10, 1, 'MANDALA', 'MDLR', 'Mandala Reguler', 'doto_ho_spekmotor', 1),
(11, 1, 'MANDALA', 'MDLS', 'Mandala S', 'doto_ho_spekmotor', 1),
(12, 1, 'MANDALA', 'MDLVP', 'VoltaPlus Mandala', 'doto_ho_spekmotor', 1);

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

--
-- Table structure for table `doto_ho_nilaidp`
--

CREATE TABLE `doto_ho_nilaidp` (
  `idnilaidp` tinyint UNSIGNED NOT NULL,
  `jumlahnilaidp` double(12,0) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `doto_ho_nilaidp`
--

INSERT INTO `doto_ho_nilaidp` (`idnilaidp`, `jumlahnilaidp`) VALUES
(1, 100);

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

--
-- Table structure for table `doto_ho_parent_menu`
--

CREATE TABLE `doto_ho_parent_menu` (
  `parentmenuid` int UNSIGNED NOT NULL,
  `parentmenuname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_ho_parent_menu`
--

INSERT INTO `doto_ho_parent_menu` (`parentmenuid`, `parentmenuname`) VALUES
(1, 'Admin'),
(2, 'Data Master'),
(3, 'Rekanan'),
(4, 'Penjualan'),
(5, 'Laporan');

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

--
-- Table structure for table `doto_ho_propinsi`
--

CREATE TABLE `doto_ho_propinsi` (
  `idpropinsi` smallint UNSIGNED NOT NULL,
  `namapropinsi` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_ho_propinsi`
--

INSERT INTO `doto_ho_propinsi` (`idpropinsi`, `namapropinsi`) VALUES
(1, 'Nanggroe Aceh Darussalam'),
(2, 'Sumatera Utara'),
(3, 'Sumatera Barat'),
(4, 'Riau'),
(5, 'Jambi'),
(6, 'Sumatera Selatan'),
(7, 'Bengkulu'),
(8, 'Lampung'),
(9, 'Kep. Bangka Belitung'),
(10, 'Kep. Riau'),
(11, 'DKI Jakarta'),
(12, 'Jawa Barat'),
(13, 'Jawa Tengah'),
(14, 'DI Yogyakarta'),
(15, 'Jawa Timur'),
(16, 'Banten'),
(17, 'Bali'),
(18, 'Nusa Tenggara Barat'),
(19, 'Nusa Tenggara Timur'),
(20, 'Kalimantan Barat'),
(21, 'Kalimantan Tengah'),
(22, 'Kalimantan Selatan'),
(23, 'Kalimantan Timur'),
(24, 'Sulawesi Utara'),
(25, 'Sulawesi Tengah'),
(26, 'Sulawesi Selatan'),
(27, 'Sulawesi Tenggara'),
(28, 'Gorontalo'),
(29, 'Sulawesi Barat'),
(30, 'Maluku'),
(31, 'Maluku Utara'),
(32, 'Papua'),
(33, 'Papua Barat');

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

--
-- Table structure for table `doto_ho_spekmotor`
--

CREATE TABLE `doto_ho_spekmotor` (
  `idspekmotor` int UNSIGNED NOT NULL,
  `idmodel` int UNSIGNED NOT NULL,
  `tampakkiri` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tampakkanan` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tampakdepan` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tampakbelakang` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tampakatas` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tampakbawah` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tampakdetail1` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tampakdetail2` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kapasitasmesin` varchar(50) DEFAULT NULL,
  `transmisi` varchar(50) DEFAULT NULL,
  `jenisbaterei` varchar(50) DEFAULT NULL,
  `kapasitasbaterei` varchar(50) DEFAULT NULL,
  `dayaangkut` varchar(50) DEFAULT NULL,
  `ban` varchar(50) DEFAULT NULL,
  `suspensidepan` varchar(50) DEFAULT NULL,
  `suspensibelakang` varchar(50) DEFAULT NULL,
  `rem` varchar(50) DEFAULT NULL,
  `dashbor` varchar(50) DEFAULT NULL,
  `lampu` varchar(50) DEFAULT NULL,
  `keamanan` varchar(50) DEFAULT NULL,
  `sistemkunci` varchar(50) DEFAULT NULL,
  `slotbaterei` varchar(50) DEFAULT NULL,
  `usbchargingport` varchar(50) DEFAULT NULL,
  `safetybreakbutton` varchar(50) DEFAULT NULL,
  `threespeedfunction` varchar(50) DEFAULT NULL,
  `reversefunction` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `doto_ho_thnproduksi`
--

CREATE TABLE `doto_ho_thnproduksi` (
  `idthnproduksi` int UNSIGNED NOT NULL,
  `thnproduksi` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kodethnproduksi` varchar(5) NOT NULL,
  `tersedia` tinyint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `doto_ho_thnproduksi`
--

INSERT INTO `doto_ho_thnproduksi` (`idthnproduksi`, `thnproduksi`, `kodethnproduksi`, `tersedia`) VALUES
(1, '2022', '22', 0),
(2, '2023', '23', 1);

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

--
-- Table structure for table `doto_ho_voucher`
--

CREATE TABLE `doto_ho_voucher` (
  `idvoucher` int UNSIGNED NOT NULL,
  `kodevoucher` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `mulaiberlaku` date NOT NULL,
  `selesaiberlaku` date NOT NULL,
  `idrekanan` int UNSIGNED DEFAULT NULL,
  `iditem` int UNSIGNED DEFAULT NULL,
  `idmerek` int UNSIGNED DEFAULT NULL,
  `idmodel` int UNSIGNED DEFAULT NULL,
  `idwarna` int UNSIGNED DEFAULT NULL,
  `idtahunproduksi` int UNSIGNED DEFAULT NULL,
  `idwilayahotr` int UNSIGNED DEFAULT NULL,
  `qtymin` smallint UNSIGNED DEFAULT NULL,
  `tagihanmin` double(12,0) UNSIGNED DEFAULT NULL,
  `diskonrupiah` double(12,0) UNSIGNED DEFAULT NULL,
  `diskonpersen` tinyint UNSIGNED DEFAULT NULL,
  `namahadiah` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `qtyhadiah` smallint UNSIGNED DEFAULT NULL,
  `qtyhadiahterpakai` smallint UNSIGNED DEFAULT NULL,
  `idkategoribisnis` int UNSIGNED DEFAULT NULL,
  `idcarabayar` int UNSIGNED DEFAULT NULL,
  `idkategoripelanggan` int UNSIGNED DEFAULT NULL,
  `aturandanketentuan` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `doto_ho_warna`
--

CREATE TABLE `doto_ho_warna` (
  `idwarna` int UNSIGNED NOT NULL,
  `groupmodel` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kodewarna` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `namawarna` varchar(50) NOT NULL,
  `kodehtml` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tersedia` tinyint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `doto_ho_warna`
--

INSERT INTO `doto_ho_warna` (`idwarna`, `groupmodel`, `kodewarna`, `namawarna`, `kodehtml`, `tersedia`) VALUES
(1, '401', NULL, 'Metallic Grey', '#c0c1c9', 1),
(2, '401', NULL, 'Radiant Red Glossy', 'd10c35', 1),
(3, '401', NULL, 'Pearl White', '#faf9f8', 1),
(4, '401', NULL, 'Midnight Black', '#3e3f48', 1),
(5, '401', NULL, 'Red Matte', '#a92129', 1),
(6, '401', NULL, 'Blue Matte', '#2e54dc', 1),
(7, 'VIRGO', NULL, 'Crimson Red', '#bf0000', 1),
(8, 'VIRGO', NULL, 'Black Onyx', '#0a0a0a', 1),
(9, 'VIRGO', NULL, 'Ivory White', '#f3f3f3', 1),
(10, 'MANDALA', NULL, 'Red Candy', '#be0000', 1),
(11, 'MANDALA', NULL, 'White', '#ead200', 1),
(12, 'MANDALA', NULL, 'Yellow', '#f8fdfd', 1);

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

--
-- Table structure for table `doto_ho_wilayahotr`
--

CREATE TABLE `doto_ho_wilayahotr` (
  `idwilayahotr` int UNSIGNED NOT NULL,
  `namawilayahotr` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `kodewilayahotr` varchar(5) NOT NULL,
  `tersedia` tinyint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `doto_ho_wilayahotr`
--

INSERT INTO `doto_ho_wilayahotr` (`idwilayahotr`, `namawilayahotr`, `kodewilayahotr`, `tersedia`) VALUES
(1, 'DKI Jakarta', 'DKI', 1),
(2, 'BoDeTaBek', 'BOD', 1),
(3, 'Jawa Barat', 'JBR', 1),
(4, 'Jawa Tengah dan DIY', 'JTG', 1),
(5, 'Jawa Timur', 'JTM', 1),
(6, 'Bali', 'BLI', 1),
(7, 'Medan', 'MDN', 1),
(8, 'Banda Aceh', 'BAC', 1),
(9, 'Padang', 'PDG', 1),
(10, 'Pekanbaru', 'PBR', 1),
(11, 'Kepulauan Riau', 'KPR', 1),
(12, 'Jambi', 'JMB', 1),
(13, 'Palembang', 'PLM', 1),
(14, 'Lampung', 'LMP', 1),
(15, 'Bangka Belitung', 'BBL', 1),
(16, 'Kalimantan Utara', 'KUT', 1),
(17, 'Kalimantan Timur', 'KTM', 1),
(18, 'Kalimantan Barat', 'KBR', 1),
(19, 'Kalimantan Tengah', 'KTG', 1),
(20, 'Kalimantan Selatan', 'KSL', 1),
(21, 'Manado', 'MND', 1),
(22, 'Gorontalo', 'GRT', 1),
(23, 'Sulawesi Tengah', 'STG', 1),
(24, 'Sulawesi Barat', 'SBR', 1),
(25, 'Sulawesi Tenggara', 'STR', 1),
(26, 'Sulawesi Selatan', 'SSL', 1);

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

--
-- Table structure for table `doto_rkn_appauthorization`
--

CREATE TABLE `doto_rkn_appauthorization` (
  `appauthid` int NOT NULL,
  `appgroupid` bigint NOT NULL DEFAULT '0',
  `appmenuid` bigint NOT NULL DEFAULT '0',
  `semua` tinyint UNSIGNED NOT NULL COMMENT '0 = tidak ; 1 = iya',
  `baca` tinyint UNSIGNED NOT NULL COMMENT '0 = tidak ; 1 = iya',
  `tambah` tinyint UNSIGNED NOT NULL COMMENT '0 = tidak ; 1 = iya',
  `edit` tinyint UNSIGNED NOT NULL COMMENT '0 = tidak ; 1 = iya',
  `hapus` tinyint UNSIGNED NOT NULL COMMENT '0 = tidak ; 1 = iya'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `doto_rkn_appauthorizationapproval`
--

CREATE TABLE `doto_rkn_appauthorizationapproval` (
  `appauthid` int NOT NULL,
  `appgroupid` bigint NOT NULL DEFAULT '0',
  `appmenuid` bigint NOT NULL DEFAULT '0',
  `semua` tinyint UNSIGNED NOT NULL COMMENT '1 = iya ; 2 = tidak',
  `baca` tinyint UNSIGNED NOT NULL,
  `tambah` tinyint UNSIGNED NOT NULL,
  `edit` tinyint UNSIGNED NOT NULL,
  `hapus` tinyint UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `doto_rkn_appmenu`
--

CREATE TABLE `doto_rkn_appmenu` (
  `appmenuid` int NOT NULL,
  `appmenuname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `appmenulink` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `parentid` tinyint UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_rkn_appmenu`
--

INSERT INTO `doto_rkn_appmenu` (`appmenuid`, `appmenuname`, `appmenulink`, `parentid`) VALUES
(11, 'Toko', 'toko_manager.php', 1),
(21, 'Pesanan', 'order_manager.php', 2),
(31, 'Unduh Pesanan', 'fullreport_xl.php', 3);

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

--
-- Table structure for table `doto_rkn_appuser`
--

CREATE TABLE `doto_rkn_appuser` (
  `userid` bigint NOT NULL,
  `idrekanan` int UNSIGNED NOT NULL,
  `idtoko` int UNSIGNED DEFAULT NULL,
  `fullname` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `userpass` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `useremail` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `nohandphone` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `usergroupid` int UNSIGNED DEFAULT NULL,
  `registrationdate` datetime NOT NULL,
  `lastlogin` datetime DEFAULT NULL,
  `accessstatus` smallint NOT NULL DEFAULT '0',
  `lastchangepassword` datetime DEFAULT NULL,
  `wrongpassword` smallint NOT NULL DEFAULT '0',
  `logintime` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_rkn_appuser`
--

INSERT INTO `doto_rkn_appuser` (`userid`, `idrekanan`, `idtoko`, `fullname`, `username`, `userpass`, `useremail`, `nohandphone`, `usergroupid`, `registrationdate`, `lastlogin`, `accessstatus`, `lastchangepassword`, `wrongpassword`, `logintime`) VALUES
(1, 1, NULL, 'Hariyanto', 'hari', '9c1b5cddf2969ed8ebe4e01286caff89', 'hari@mydigimax.id', '628128121126', 1, '2023-01-27 10:03:47', NULL, 1, NULL, 0, NULL);

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

--
-- Table structure for table `doto_rkn_appuserapproval`
--

CREATE TABLE `doto_rkn_appuserapproval` (
  `userid` bigint NOT NULL,
  `currentuserid` bigint NOT NULL DEFAULT '0',
  `fullname` varchar(200) NOT NULL DEFAULT '',
  `username` varchar(200) NOT NULL DEFAULT '',
  `userpass` varchar(200) NOT NULL DEFAULT '',
  `useremail` varchar(200) NOT NULL,
  `usergroupid` varchar(100) NOT NULL DEFAULT '',
  `operationarea` varchar(200) NOT NULL DEFAULT '',
  `registrationdate` datetime NOT NULL,
  `accessstatus` smallint NOT NULL DEFAULT '0',
  `statusaktivasi` tinyint UNSIGNED NOT NULL COMMENT '0 = belum aktivasi ; 1 = sudah aktivasi',
  `sesiaktivasi` varchar(200) NOT NULL,
  `statusdisclaimer` tinyint UNSIGNED NOT NULL COMMENT '0 = belum setuju ; 1 = sudah setuju',
  `userdelete` smallint DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `doto_rkn_appusergroup`
--

CREATE TABLE `doto_rkn_appusergroup` (
  `usergroupid` bigint NOT NULL,
  `usergroupname` varchar(200) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `doto_rkn_appusergroupapproval`
--

CREATE TABLE `doto_rkn_appusergroupapproval` (
  `usergroupid` bigint NOT NULL,
  `currentgroupid` bigint NOT NULL DEFAULT '0',
  `usergroupname` varchar(200) NOT NULL DEFAULT '',
  `insertdate` datetime NOT NULL,
  `groupdelete` smallint DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `doto_rkn_bpkbstnk`
--

CREATE TABLE `doto_rkn_bpkbstnk` (
  `idbpkbstnk` int UNSIGNED NOT NULL,
  `nomorpesanan` varchar(25) NOT NULL,
  `sesipesanan` varchar(200) NOT NULL,
  `userbpkbstnk` varchar(25) NOT NULL,
  `tglbpkbstnk` datetime NOT NULL,
  `catatanbpkbstnk` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `doto_rkn_lunasbayar`
--

CREATE TABLE `doto_rkn_lunasbayar` (
  `idlunasbayar` int NOT NULL,
  `idrekanan` int NOT NULL,
  `idtoko` bigint NOT NULL,
  `sesipesanan` varchar(50) NOT NULL,
  `nomorpesanan` varchar(25) NOT NULL,
  `idbanktujuan` tinyint NOT NULL,
  `jumlahbayar` double(15,0) NOT NULL,
  `waktubayar` datetime NOT NULL,
  `bankasal` varchar(25) DEFAULT NULL,
  `norekasal` varchar(25) DEFAULT NULL,
  `namapemilikasal` varchar(50) DEFAULT NULL,
  `fotobuktibayar` int NOT NULL,
  `mintaoleh` int NOT NULL,
  `mintatgl` int NOT NULL,
  `tolakoleh` int DEFAULT NULL,
  `tolaktgl` int DEFAULT NULL,
  `tolaksebab` int DEFAULT NULL,
  `setujuoleh` int DEFAULT NULL,
  `setujutgl` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `doto_rkn_papproval`
--

CREATE TABLE `doto_rkn_papproval` (
  `idpapproval` bigint UNSIGNED NOT NULL,
  `idrekanan` int UNSIGNED NOT NULL,
  `idtoko` int UNSIGNED NOT NULL,
  `sesipesanan` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `nomorpesanan` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `kodevoucher` varchar(15) DEFAULT NULL,
  `namalengkap` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `noktp` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `fotoktp` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `alamatlengkap` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `idkota` int UNSIGNED DEFAULT NULL,
  `idpropinsi` int UNSIGNED DEFAULT NULL,
  `nohandphone` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `totaltagihan` double(15,0) NOT NULL,
  `totaldiskon` double(15,0) UNSIGNED NOT NULL,
  `idcarabayarlunas` tinyint UNSIGNED NOT NULL,
  `datasesuai` tinyint UNSIGNED DEFAULT NULL,
  `mintatgl` datetime NOT NULL,
  `mintaoleh` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `setujutgl` datetime DEFAULT NULL,
  `setujuoleh` varchar(25) DEFAULT NULL,
  `tolaktgl` datetime DEFAULT NULL,
  `tolakoleh` varchar(25) DEFAULT NULL,
  `tolaksebab` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_rkn_papproval`
--

INSERT INTO `doto_rkn_papproval` (`idpapproval`, `idrekanan`, `idtoko`, `sesipesanan`, `nomorpesanan`, `kodevoucher`, `namalengkap`, `noktp`, `fotoktp`, `alamatlengkap`, `idkota`, `idpropinsi`, `nohandphone`, `email`, `totaltagihan`, `totaldiskon`, `idcarabayarlunas`, `datasesuai`, `mintatgl`, `mintaoleh`, `setujutgl`, `setujuoleh`, `tolaktgl`, `tolakoleh`, `tolaksebab`) VALUES
(1, 3, 2, '160EE6A43F91AE5E2517D50827DE8068', '160EE6A43F91', NULL, 'hari', '1234567890123456', '20230521140634160EE6A43F91.jpg', 'mangkuluhur', NULL, NULL, '08128121126', 'hari@mydigimax.id', 11800000, 0, 1, NULL, '2023-05-21 14:06:34', 'admdoto', NULL, NULL, '2023-05-21 18:13:13', 'admdoto', 'BATAL UBAH'),
(2, 3, 2, '160EE6A43F91AE5E2517D50827DE8068', '160EE6A43F91', NULL, 'Hariyanto', '1234567890123456', '20230521191609160EE6A43F91.jpg', 'Cendana Golf VI No 31, BGM PIK', NULL, NULL, '628128121126', 'hari@mydigimax.id', 11800000, 0, 4, NULL, '2023-05-21 19:16:09', 'admdoto', NULL, NULL, '2023-05-22 11:52:05', 'admdoto', 'BATAL UBAH'),
(3, 1, 1, '4260B3D88F74D1E1C82EC0F9BC5C323D', '4260B3D88F74', NULL, 'candranata koesoemo', '0317301101283006', '202304261100074260B3D88F74.jpeg', 'pluit', NULL, NULL, '08176702111', 'candranata.koesoemo@gmail.com', 16950000, 0, 4, NULL, '2023-05-22 15:19:26', 'admsales', NULL, NULL, '2023-05-22 16:04:16', 'OTOMATIS', 'BATAL UBAH'),
(4, 1, 1, '4260B3D88F74D1E1C82EC0F9BC5C323D', '4260B3D88F74', NULL, 'candranata koesoemo', '0317301101283006', '202305221604164260B3D88F74.jpg', 'pluit', NULL, NULL, '08176702111', 'candranata.koesoemo@gmail.com', 16950000, 0, 1, NULL, '2023-05-22 16:04:16', 'admsales', NULL, NULL, '2023-05-24 09:27:17', 'admdoto', 'Alamat tidak lengkap sehingga tidak dapat menemukan lokasi pemesan di google map.'),
(5, 1, 1, '4260B3D88F74D1E1C82EC0F9BC5C323D', '4260B3D88F74', NULL, 'candranata koesoemo', '0317301101283006', '202304261100074260B3D88F74.jpeg', 'Apt. Greenbay Pluit', NULL, NULL, '08176702111', 'candranata.koesoemo@gmail.com', 16950000, 0, 1, 1, '2023-05-26 08:54:55', 'admsales', '2023-05-26 08:57:03', 'admdoto', NULL, NULL, NULL);

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

--
-- Table structure for table `doto_rkn_parent_menu`
--

CREATE TABLE `doto_rkn_parent_menu` (
  `parentmenuid` int NOT NULL,
  `parentmenuname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_rkn_parent_menu`
--

INSERT INTO `doto_rkn_parent_menu` (`parentmenuid`, `parentmenuname`) VALUES
(1, 'Toko'),
(2, 'Penjualan'),
(3, 'Laporan');

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

--
-- Table structure for table `doto_rkn_pbatal`
--

CREATE TABLE `doto_rkn_pbatal` (
  `idpbatal` int NOT NULL,
  `idrekanan` int NOT NULL,
  `idtoko` int NOT NULL,
  `sesipesanan` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `nomorpesanan` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `setujuoleh` varchar(25) DEFAULT NULL,
  `setujutgl` datetime DEFAULT NULL,
  `bataloleh` varchar(25) NOT NULL,
  `bataltgl` datetime NOT NULL,
  `batalsebab` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batalrefund` tinyint NOT NULL,
  `tolakoleh` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tolaktgl` datetime DEFAULT NULL,
  `tolaksebab` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `doto_rkn_pdetailapproval`
--

CREATE TABLE `doto_rkn_pdetailapproval` (
  `idpdetailapproval` bigint UNSIGNED NOT NULL,
  `nomorpesanan` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `sesipesanan` varchar(200) NOT NULL,
  `idrekanan` int UNSIGNED NOT NULL,
  `idtoko` int UNSIGNED NOT NULL,
  `iditem` int UNSIGNED NOT NULL,
  `iditemprice` int UNSIGNED NOT NULL,
  `jumlahpesan` int UNSIGNED NOT NULL,
  `hargajual` double(12,0) NOT NULL,
  `subtotal` double(12,0) NOT NULL,
  `jumlahdiskon` double(12,0) DEFAULT NULL,
  `datasesuai` tinyint UNSIGNED DEFAULT NULL COMMENT 'NULL = belum dinyatakan sesuai ; 1 = dinyatakan sesuai',
  `mintatgl` datetime NOT NULL,
  `mintaoleh` varchar(25) NOT NULL,
  `setujutgl` datetime DEFAULT NULL,
  `setujuoleh` varchar(25) DEFAULT NULL,
  `tolaktgl` datetime DEFAULT NULL,
  `tolakoleh` varchar(25) DEFAULT NULL,
  `tolaksebab` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_rkn_pdetailapproval`
--

INSERT INTO `doto_rkn_pdetailapproval` (`idpdetailapproval`, `nomorpesanan`, `sesipesanan`, `idrekanan`, `idtoko`, `iditem`, `iditemprice`, `jumlahpesan`, `hargajual`, `subtotal`, `jumlahdiskon`, `datasesuai`, `mintatgl`, `mintaoleh`, `setujutgl`, `setujuoleh`, `tolaktgl`, `tolakoleh`, `tolaksebab`) VALUES
(1, '160EE6A43F91', '160EE6A43F91AE5E2517D50827DE8068', 3, 2, 14, 30, 1, 18800000, 18300000, 500000, NULL, '2023-05-20 15:30:18', 'admdoto', NULL, NULL, '2023-05-21 19:46:26', 'admdoto', 'BATAL UBAH'),
(2, '160EE6A43F91', '160EE6A43F91AE5E2517D50827DE8068', 3, 2, 2, 2, 1, 11800000, 11800000, NULL, 1, '2023-05-21 20:01:04', 'admdoto', NULL, NULL, NULL, NULL, NULL),
(3, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 1, 1, 31, 14, 1, 18750000, 18250000, 500000, NULL, '2023-05-22 15:18:59', 'admsales', NULL, NULL, '2023-05-22 16:53:25', 'admsales', 'BATAL UBAH'),
(4, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, 1, '2023-05-22 17:06:27', 'admsales', '2023-05-26 08:31:58', 'admdoto', NULL, NULL, NULL);

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

--
-- Table structure for table `doto_rkn_pdetailok`
--

CREATE TABLE `doto_rkn_pdetailok` (
  `idpdetailok` int NOT NULL,
  `idrekanan` int NOT NULL,
  `idtoko` int NOT NULL,
  `sesipesanan` varchar(50) NOT NULL,
  `nomorpesanan` varchar(25) NOT NULL,
  `okoleh` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `oktgl` datetime NOT NULL,
  `tolakoleh` varchar(25) DEFAULT NULL,
  `tolaktgl` datetime DEFAULT NULL,
  `tolaksebab` varchar(200) DEFAULT NULL,
  `setujuoleh` varchar(25) DEFAULT NULL,
  `setujutgl` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `doto_rkn_pengiriman`
--

CREATE TABLE `doto_rkn_pengiriman` (
  `idpengiriman` int UNSIGNED NOT NULL,
  `nomorpesanan` varchar(25) NOT NULL,
  `sesipesanan` varchar(200) NOT NULL,
  `userpengiriman` varchar(25) NOT NULL,
  `tglpengiriman` datetime NOT NULL,
  `catatanpengiriman` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `doto_rkn_pesanan`
--

CREATE TABLE `doto_rkn_pesanan` (
  `idpesanan` bigint UNSIGNED NOT NULL,
  `idrekanan` int UNSIGNED NOT NULL,
  `idtoko` int UNSIGNED NOT NULL,
  `sesipesanan` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `nomorpesanan` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `waktupesanan` datetime NOT NULL,
  `kodevoucher` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `namalengkap` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `noktp` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `fotoktp` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `alamatlengkap` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `idkota` int UNSIGNED DEFAULT NULL,
  `idpropinsi` int UNSIGNED DEFAULT NULL,
  `nohandphone` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `totaltagihan` double(15,0) NOT NULL,
  `totaldiskon` double(15,0) UNSIGNED DEFAULT NULL,
  `idcarabayarlunas` tinyint UNSIGNED DEFAULT NULL,
  `totaltandajadi` double(12,0) UNSIGNED DEFAULT NULL,
  `feetandajadi` double(12,0) UNSIGNED DEFAULT NULL,
  `totaltandajadipaid` double(12,0) UNSIGNED DEFAULT NULL,
  `idcarabayartandajadi` tinyint UNSIGNED DEFAULT NULL,
  `trxidtandajadi` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `statustandajadi` tinyint UNSIGNED DEFAULT NULL COMMENT '1 = sukses ; 2 = gagal',
  `waktutandajadi` datetime DEFAULT NULL,
  `statuswaba` varchar(15) DEFAULT NULL,
  `pesanwaba` varchar(200) DEFAULT NULL,
  `catatan` text,
  `statusorder` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '1 = bayar tanda jadi ; 2 = konfirmasi data ; 3 = sudah lunas ; 4 = pengajuan faktur ; 5 = pengiriman ; 6 = stank selesai ; 7 = bpkb selesai ; 8 = batal',
  `statusdata` tinyint UNSIGNED DEFAULT NULL COMMENT 'NULL = belum sesuai ; 1 = sudah sesuai ; 2 = sudah disetujui'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_rkn_pesanan`
--

INSERT INTO `doto_rkn_pesanan` (`idpesanan`, `idrekanan`, `idtoko`, `sesipesanan`, `nomorpesanan`, `waktupesanan`, `kodevoucher`, `namalengkap`, `noktp`, `fotoktp`, `alamatlengkap`, `idkota`, `idpropinsi`, `nohandphone`, `email`, `totaltagihan`, `totaldiskon`, `idcarabayarlunas`, `totaltandajadi`, `feetandajadi`, `totaltandajadipaid`, `idcarabayartandajadi`, `trxidtandajadi`, `statustandajadi`, `waktutandajadi`, `statuswaba`, `pesanwaba`, `catatan`, `statusorder`, `statusdata`) VALUES
(1, 3, 2, 'E92F408887FD3AE6DB386E89016FD4C7', 'E92F408887FD', '2023-03-07 15:27:24', '', 'hariyanto', '1234567890123456', 'ktp_budi_color.jpg', 'mangkuluhur city tower one lt 18', NULL, NULL, '08128121126', 'hari@mydigimax.id', 17500000, NULL, 1, 2000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL),
(2, 3, 2, 'C2BC8DD023E3A68A0002D0221EFC4367', 'C2BC8DD023E3', '2023-03-07 15:51:21', '', 'hariyanto', '1234567890123456', 'ktp_budi_color.jpg', 'mangkuluhur city tower one lt 18', NULL, NULL, '08128121126', 'hari@mydigimax.id', 17500000, NULL, 1, 2000000, NULL, NULL, NULL, 'QHWKAV98WMOOC4WG', 1, '2023-03-07 15:53:57', NULL, NULL, '', '1', NULL),
(3, 3, 2, '1B2D63CB425A6F2F8ADC63BEF6A3AF39', '1B2D63CB425A', '2023-03-07 16:14:55', '', 'hari lagi', '1234567890123456', 'ktp_budi_color.jpg', 'mangkuluhur city tower one lt 18', NULL, NULL, '08128121126', 'hari@mydigimax.id', 17500000, NULL, 1, 2000000, NULL, NULL, NULL, 'P0TTMTHVP2S8G8O4', NULL, NULL, NULL, NULL, '', NULL, NULL),
(4, 3, 2, 'FED8E7BDD2374729A5DC14546EA75519', 'FED8E7BDD237', '2023-03-07 16:23:56', '', 'hariyanto', '1234567890123456', 'ktp_budi_color.jpg', 'mangkuluhur city tower one lt 18', NULL, NULL, '08128121126', 'hari@mydigimax.id', 35000000, NULL, 1, 4000000, 56000, 8056000, 1, 'SAH7ELWHTA80OO0G', 1, '2023-03-07 16:55:04', NULL, NULL, '', '1', NULL),
(5, 3, 2, '1A1D5A0A758F678386231615203F11BE', '1A1D5A0A758F', '2023-03-07 17:17:58', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15750000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 3, 2, '418F689503127FC38A99934B038777AD', '418F68950312', '2023-03-08 14:47:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 18350000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 3, 2, 'C071407F8C6A4126705DA456B8DA3403', 'C071407F8C6A', '2023-03-09 12:32:26', '', 'hariyanto', '1234567890123456', 'ktp_budi_color.jpg', 'mangkuluhur city tower one lt 18\njl. gatot subroto', NULL, NULL, '08128121126', 'hari@mydigimax.id', 35000000, NULL, 1, 200, 2, 202, 1, 'AVLLC3T8N3KSWGO4', 1, '2023-03-09 12:44:49', NULL, NULL, '', '1', NULL),
(8, 3, 2, 'A35541537999A797DE928C25A4AC2323', 'A35541537999', '2023-03-09 16:43:12', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 18750000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(9, 3, 2, 'D3D6C1C0969F2EE43EF309EFCDD27A8C', 'D3D6C1C0969F', '2023-03-09 17:15:52', '', 'Hariyanto', '1234567890123456', 'image.jpg', 'Mangkuluhur city tower one lt 18', NULL, NULL, '08128121126', 'hari@mydigimax.id', 32700000, NULL, 1, 200, 2, 202, 1, '7O6LCQDOJDGCGK0G', 1, '2023-03-09 17:39:14', NULL, NULL, '', '1', NULL),
(11, 3, 2, '51CA72D925417C9BD7D2A449DFE0942E', '51CA72D92541', '2023-03-09 17:21:30', '', 'Hariyanto', '1234567890123456', '16783573625183579922814502553223.jpg', 'Mangkuluhur city tower one lt 18', NULL, NULL, '08128121126', 'hari@mydigimax.id', 33500000, NULL, 1, 200, 2, 202, 1, 'QMJBDRBP8004G4OS', 1, '2023-03-09 17:24:19', NULL, NULL, '', '1', NULL),
(13, 3, 2, '6380A0F79BD6C06CFE15FE9013FE4625', '6380A0F79BD6', '2023-03-09 17:40:04', 'Haj', 'Tes andy', '3172022011900009', '16783584209342033911615307820049.jpg', 'Hdjjaa', NULL, NULL, '08947282789900', 'aa@mail.com', 17900000, NULL, 1, 100, 1, 101, 1, 'H2UJ8G73BBK8WW0G', 1, '2023-03-09 17:25:00', NULL, NULL, 'Jsjsjs', '1', NULL),
(15, 3, 2, 'DA3B58DE7B4CC26EEF14AC2F662403BC', 'DA3B58DE7B4C', '2023-03-09 17:30:03', '', 'Hariyanto', '1234567890123456', '16783578254579141706904816499853.jpg', 'Mangkuluhur city tower one lt 18', NULL, NULL, '08128121126', 'hari@mydigimax.id', 15750000, NULL, 1, 100, 1, 101, 1, 'K9EA15HZQ8004OOW', 1, '2023-03-09 17:31:33', NULL, NULL, '', '1', NULL),
(22, 3, 2, 'DE079A94C5517B00597A359D7760AA75', 'DE079A94C551', '2023-03-09 17:42:47', '', 'Hariyanto', '1234567890123456', '16783586042772376712276110680812.jpg', 'Mngkuluhur city tower one lt 18', NULL, NULL, '08128121126', 'hari@mydigimax.id', 15750000, NULL, 1, 100, 1, 101, 1, 'XIFUA7C90MSCKG4G', 1, '2023-03-09 17:45:16', NULL, NULL, '', '1', NULL),
(23, 3, 2, '83C61D828CFEBCB7FE5FBAC313D7417D', '83C61D828CFE', '2023-03-09 21:06:32', 'Haj', 'Tes andy', '3172022011900009', 'Screenshot_20230309-171158.png', 'C however', NULL, NULL, '089472827899', 'aa@mail.com', 15750000, NULL, 1, 100, 3, 103, 2, 'RL0OQ6OKU3KK4CG8', 1, '2023-03-09 21:08:50', NULL, NULL, 'Such', '1', NULL),
(24, 3, 2, 'CB62A5E1AA28C1B3C9DF1FA52F32ACFE', 'CB62A5E1AA28', '2023-03-21 09:06:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 15750000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(25, 3, 2, 'EE1FA8C354EC4634FC8B3CD13B276273', 'EE1FA8C354EC', '2023-03-21 12:13:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(26, 3, 2, 'A27ADCB5CCF486573CA6487132E945C7', 'A27ADCB5CCF4', '2023-03-24 19:02:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11800000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(27, 3, 2, 'D557428E113B6DAAA3BFD5E4026AAC80', 'D557428E113B', '2023-03-25 08:10:57', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35400000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(28, 3, 2, 'DD044585A83196931099E3D33F147F9B', 'DD044585A831', '2023-03-25 08:37:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 21700000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(31, 3, 2, 'DDD1CF9F6D16C95431AAF9265EEE0ABF', 'DDD1CF9F6D16', '2023-03-25 14:58:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11800000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(32, 3, 2, '3A59CF3530B82993EB4F17AD7E517B9A', '3A59CF3530B8', '2023-03-25 16:03:43', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 23600000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(35, 3, 3, 'C49289CDC28C3C6F774099E57F94E6CF', 'C49289CDC28C', '2023-03-27 16:40:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11800000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(39, 3, 3, 'EEF9C73D9C6DADD68B45ECD67E5EAE08', 'EEF9C73D9C6D', '2023-03-28 09:20:27', '', 'Hari', '1234567890123456', '16799700618731388305262155390568.jpg', 'Mangkuluhur', NULL, NULL, '08128121126', 'hari@mydigimax.id', 11800000, NULL, 1, 2000000, NULL, NULL, NULL, '8XK84P6OLECC8CW4', NULL, NULL, NULL, NULL, '', NULL, NULL),
(40, 3, 3, 'A907AFC134799361F82214D9247C36A4', 'A907AFC13479', '2023-03-28 09:44:55', '', 'Hari', '1234567890123456', 'IMG-20191003-WA0009.jpeg', 'Mangkuluhur', NULL, NULL, '08128121126', 'hari@mydigimax.id', 11800000, NULL, 1, 2000000, NULL, NULL, NULL, '8OEQ8AZL4ZGGC8GC', NULL, NULL, NULL, NULL, '', NULL, NULL),
(41, 3, 3, 'A2E10FAB26A39830304948DDDA63A623', 'A2E10FAB26A3', '2023-03-28 14:21:47', '', 'Fery', '3174082902960001', 'IMG-20230328-WA0009.jpg', 'depok', NULL, NULL, '089512384083', 'muhammadrahmanferyansyah@gmail.com', 11800000, NULL, 1, 1000, NULL, NULL, NULL, '1R6AM1MVNWHWGWGO', NULL, NULL, NULL, NULL, '', NULL, NULL),
(44, 3, 3, 'B923CA61BB1C4E091C768D5D6BBC0A9C', 'B923CA61BB1C', '2023-03-28 14:24:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11800000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(48, 3, 3, '6B999D10858C2D8BD8DD00B7618EEE61', '6B999D10858C', '2023-03-28 14:55:00', '', 'fery', '3174072899860001', 'IMG-20230328-WA0009.jpg', 'depok', NULL, NULL, '089512384083', 'muhammadrahmanferyansyah@gmail.com', 11800000, NULL, 1, 1000, NULL, NULL, NULL, 'P3RB53W8GI88GG4K', NULL, NULL, NULL, NULL, '', NULL, NULL),
(49, 3, 3, '3C0EE30D9740D48F2DC179F82E67AC1E', '3C0EE30D9740', '2023-03-29 08:29:31', '', 'Rinoldi', '3174031012890007', 'IMG_20210708_092300_736.jpg', 'Pondok KARYA', NULL, NULL, '08128006195', 'rinoldd@gmail.com', 11800000, NULL, 1, 1000, NULL, NULL, NULL, 'MJF3YNTUTJ40KOK0', NULL, NULL, NULL, NULL, 'TEST PRODUCTION BY LDN', NULL, NULL),
(55, 3, 3, '79979CE8AB636A17E3651A8FD9EF270E', '79979CE8AB63', '2023-03-29 13:05:37', '', 'Hari', '1234567890123456', '16800699892617393852580352256513.jpg', 'Mangkuluhur', NULL, NULL, '08128121126', 'hari@mydigimax.id', 11800000, NULL, 1, 1000, NULL, NULL, NULL, '6XCW40Q8M90KG0OO', NULL, NULL, NULL, NULL, '', NULL, NULL),
(58, 3, 2, 'FC8785BA3C4EB119477A1CD04CD7FAEC', 'FC8785BA3C4E', '2023-03-29 14:14:11', '', 'hari', '1234567890123456', 'hero-bg.jpg', 'mangkuluhur', NULL, NULL, '08128121126', 'hari@mydigimax.id', 11800000, NULL, 1, 1000, NULL, NULL, NULL, '6P5ZE5ZA6C080S8G', NULL, NULL, NULL, NULL, '', NULL, NULL),
(74, 3, 2, '160EE6A43F91AE5E2517D50827DE8068', '160EE6A43F91', '2023-03-29 14:23:55', '', 'hari', '1234567890123456', '20230329142439_160ee6a43f91.jpg', 'mangkuluhur', NULL, NULL, '08128121126', 'hari@mydigimax.id', 11800000, NULL, 1, 1000, 7, 1007, 1, 'DZ7DAELBRZ4GKGS0', 1, '2023-03-29 14:29:59', NULL, NULL, '', '1', NULL),
(75, 3, 3, 'A38684870E97944E6BA6AFD47CD53F8F', 'A38684870E97', '2023-03-30 11:16:21', '-', 'fery', '3174082902960001', 'IMG-20230330-WA0008.jpg', 'depok', NULL, NULL, '089512384083', 'muhammadrahmanferyansyah@gmail.com', 11800000, NULL, 1, 1000, NULL, NULL, NULL, 'NBNHZQ8MQBKW44S4', NULL, NULL, NULL, NULL, 'dp volta', NULL, NULL),
(76, 3, 3, '8F73B278901017CF613D4D8D8F1C8E54', '8F73B2789010', '2023-03-30 11:15:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 23600000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(81, 3, 3, '5C87ACB73937C3125FB5608AE3CEC311', '5C87ACB73937', '2023-03-30 11:24:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11800000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(82, 3, 3, 'E4C10481216931882AD150C928E504F2', 'E4C104812169', '2023-03-30 11:25:28', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11800000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(83, 3, 3, '96807301A118C82DBA76B24D7A9F5626', '96807301A118', '2023-04-06 11:37:12', '', 'Rinold', '3174031012890007', 'Screenshot_20230404_162401.jpg', 'Jl pondok karya', NULL, NULL, '08126009156', 'rinoldd@gmail.com', 11800000, NULL, 1, 1000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Volta', NULL, NULL),
(84, 1, 1, '67A865D154A75BC44F4042723665675C', '67A865D154A7', '2023-04-17 08:32:45', '', 'Hari', '1234567890123456', '16816952007323547145228060762108.jpg', 'Mangkuluhur city tower one lt 18', NULL, NULL, '08128121126', 'hari@mydigimax.id', 11800000, NULL, 1, 100, NULL, NULL, NULL, 'D2V382PDHHWSKSG8', NULL, NULL, NULL, NULL, '', NULL, NULL),
(85, 1, 1, '889A98AD6D3BF979D9FC7F156C7F87E8', '889A98AD6D3B', '2023-04-17 13:20:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 21750000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(86, 1, 1, 'D58F95F0E18F0D7C2D2117E7A3C0F533', 'D58F95F0E18F', '2023-04-17 15:15:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(87, 1, 1, 'F65BCFA38EE93DD65C79AD33414A540B', 'F65BCFA38EE9', '2023-04-17 15:17:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 18350000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(88, 1, 1, '3AC7BA57D2769BE95A6194ECDF82CE3E', '3AC7BA57D276', '2023-04-17 15:17:36', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 18350000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(89, 1, 1, 'B6FDD91144A083B464413EC76E7B4CD9', 'B6FDD91144A0', '2023-04-17 15:17:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 36700000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(90, 1, 1, '9256E958F1A6FA8097717F0E5FFEF839', '9256E958F1A6', '2023-04-17 15:19:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(91, 1, 1, 'AB674E48885257C575C340F8AE67E8DE', 'AB674E488852', '2023-04-17 15:28:35', '', 'Neng siska', '3210127502201170', '16817201851603789754797129544074.jpg', 'Keramat sentiong', NULL, NULL, '085315597164', 'siskaintantria98@gmail.com', 16950000, NULL, 1, 100, NULL, NULL, NULL, '5JAFAB6O28G8GKKW', NULL, NULL, NULL, NULL, 'Testing', NULL, NULL),
(92, 1, 1, 'DF0F20B9C0A9B8C3FB2E9F2B79A48C12', 'DF0F20B9C0A9', '2023-04-17 15:56:59', '', 'Hari', '1234567890123456', 'IMG_20230414_090111.jpg', 'Mangkuluhur city tower one lt 18', NULL, NULL, '081234567890', 'hari@dmmgroup.id', 17500000, NULL, 1, 100, NULL, NULL, NULL, '7SZJGX3KO3CWGGG8', NULL, NULL, NULL, NULL, '', NULL, NULL),
(94, 1, 1, 'A1DA8D805907C1D957A73D5DAC522318', 'A1DA8D805907', '2023-04-17 17:02:03', 'Hajl', 'Tes and', '3172022011900008', '16817257449311622576822315569640.jpg', 'Jln', NULL, NULL, '08947282789', 'aab@mail.com', 18350000, NULL, 1, 100, NULL, NULL, NULL, 'A8CS5XC1ZGO40WGC', NULL, NULL, NULL, NULL, 'Jsndnd', NULL, NULL),
(96, 1, 1, '464B66F93AF45A34E1AF9025BD4F970A', '464B66F93AF4', '2023-04-17 17:16:15', '', 'Neng siska', '1237894560981237', '16817266386276430673838536274867.jpg', 'Keramat sentiong', NULL, NULL, '08123456789', 'Siska@gmail.com', 17500000, NULL, 1, 100, NULL, NULL, NULL, '64PFP1PR0PWKWW8O', NULL, NULL, NULL, NULL, 'Testing', NULL, NULL),
(98, 1, 1, '00FA20FE7E964D2A377382FBCBA95A64', '00FA20FE7E96', '2023-04-17 17:30:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(99, 1, 1, '5D75250EA300005AD079F7F4D881EF20', '5D75250EA300', '2023-04-17 18:49:33', '', 'Neng siska', '1237894560981237', '16817322139704012422347563497565.jpg', 'Keramat sentiong', NULL, NULL, '08128121126', 'siskaintantria98@gmail.com', 17500000, NULL, 1, 100, NULL, NULL, NULL, 'HNG073YEW34SWC4C', NULL, NULL, NULL, NULL, 'Ini Testing', NULL, NULL),
(100, 1, 1, '1F8CEEF0815A3CB5C9B2F24594EDF03C', '1F8CEEF0815A', '2023-04-17 19:09:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(101, 1, 1, '1120E79F44CEA9DE5F6DD3483B9F09CE', '1120E79F44CE', '2023-04-17 23:18:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(102, 1, 1, '6491DAE4340F75EB381BB3EA2C991E13', '6491DAE4340F', '2023-04-17 23:19:33', '', 'Hari', '1234567890123456', 'IMG_20191210_115938.jpg', 'Mangkuluhur', NULL, NULL, '08128121126', 'hari@mydigimax.id', 16950000, NULL, 1, 100, 2, 102, 4, 'P19FCWZ41CGCCK8K', 1, '2023-04-18 05:56:31', NULL, NULL, '', '1', NULL),
(103, 1, 1, 'A59C1D0AB963DEB4B22950E05A35FCF6', 'A59C1D0AB963', '2023-04-18 07:49:58', '', 'Hari', '1234567890123456', 'IMG_20191210_115938.jpg', 'Mangkuluhur city tower one lt 18', NULL, NULL, '08128121126', 'hari@mydigimax.id', 17500000, NULL, 1, 100, 2, 102, 4, '57TP54MYH8SOSWCC', 1, '2023-04-18 10:15:23', NULL, NULL, '', '1', NULL),
(104, 1, 1, '34578AE8AE1BF554ECD2364BCC38F621', '34578AE8AE1B', '2023-04-18 07:52:41', '', 'Hari', '1234567890123456', 'IMG_20191210_115938.jpg', 'Mangkuluhur', NULL, NULL, '08128121126', 'hari@mydigimax.id', 17500000, NULL, 1, 100, 2, 102, 4, 'C9YQVWAR0IOGKSOO', 1, '2023-04-18 10:29:24', NULL, NULL, '', '1', NULL),
(105, 1, 1, '906D6E22008FFC8B977CF60E9F394D42', '906D6E22008F', '2023-04-18 09:39:09', '', 'Tes andy', '3172022011901009', '16817855773925448620925633538384.jpg', 'Jln', NULL, NULL, '089675008754', 'achmad.novandy@dmmgroup.id', 18350000, NULL, 1, 100, 2, 102, 4, 'D5Y99O3NBT44OW0O', 1, '2023-04-18 10:33:27', NULL, NULL, 'Tes', '1', NULL),
(106, 1, 1, 'D348963757C5C9EC311042B9A21C38FC', 'D348963757C5', '2023-04-18 10:32:11', '', 'Neng siska', '1237894560981237', '1681788764656603115486023927001.jpg', 'Keramat sentiong', NULL, NULL, '085315597164', 'siskaintantria98@gmail.com', 17500000, NULL, 1, 100, NULL, NULL, NULL, 'GLTNZLLOP7W4OWWG', NULL, NULL, NULL, NULL, 'Ini testing', NULL, NULL),
(107, 1, 1, '6A4CEE791542B235B1E051D5464D1152', '6A4CEE791542', '2023-04-18 10:36:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(108, 1, 1, '4964C205FD24BA06122C5C604FF589F4', '4964C205FD24', '2023-04-18 10:37:56', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 17500000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(109, 1, 1, '76A495683B8D1B6B72A912C066790EA1', '76A495683B8D', '2023-04-18 11:06:56', '', 'Neng siska', '1237894560981237', '16817908522392887076247607915155.jpg', 'Keramat sentiong', NULL, NULL, '085315597164', 'siskaintantria98@gmail.com', 17500000, NULL, 1, 100, NULL, NULL, NULL, '12YZET3ARTUS4WGS', NULL, NULL, NULL, NULL, 'Ini testing', NULL, NULL),
(110, 1, 1, '59E3CA1C4CC4A2F7C0555752FDD5A84B', '59E3CA1C4CC4', '2023-04-18 11:22:42', '', 'Neng siska', '1237894560981237', '16817917952891641921491447147509.jpg', 'Keramar sentiong', NULL, NULL, '085315597164', 'Siska@gmail.com', 16950000, NULL, 1, 100, NULL, NULL, NULL, '181LQYS7TARK48SC', NULL, NULL, NULL, NULL, 'Ini testing', NULL, NULL),
(111, 1, 1, 'BEEA299A564623419381D607E6C9F645', 'BEEA299A5646', '2023-04-18 11:25:43', '', 'Neng siska', '1237894560981237', '16817919690117593551983984715327.jpg', 'Keramat sentiong', NULL, NULL, '085315597164', 'Siska@gmail.com', 16950000, NULL, 1, 100, NULL, NULL, NULL, '7P2S7RAZIZ8CWKOO', NULL, NULL, NULL, NULL, 'Ini testing', NULL, NULL),
(112, 1, 1, '470F0C82A935F3E6CDA3A185DFB1F568', '470F0C82A935', '2023-04-18 11:31:15', '', 'Neng siska', '1237894560981237', '16817923113825673393184282928061.jpg', 'Mangkuluhur', NULL, NULL, '085315597164', 'Siska@gmail.com', 16950000, NULL, 1, 100, NULL, NULL, NULL, 'Q8KFTE8I56O48WO4', NULL, NULL, NULL, NULL, '', NULL, NULL),
(113, 1, 1, '7028BEC11F3A0ABD27ADC0CACB4383B5', '7028BEC11F3A', '2023-04-18 11:32:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(114, 1, 1, '7C2AE24E2A015FCFC8C1B554320326C3', '7C2AE24E2A01', '2023-04-18 13:45:06', '', 'andy aja', '3127894888928903', 'logo_with_name.png', 'jln', NULL, NULL, '089675008754', 'anovandi@hotmail.com', 18350000, NULL, 1, 100, NULL, NULL, NULL, 'GI5D70JUBAOSC0O0', NULL, NULL, NULL, NULL, 'tes', NULL, NULL),
(115, 1, 1, 'FBFD61241178DF9C1EB60A93BEC42F91', 'FBFD61241178', '2023-04-18 16:00:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 18350000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(116, 1, 1, 'D152EE2C20627FA090753E5F85487E3D', 'D152EE2C2062', '2023-04-18 16:24:40', '', 'Tes andy', '3172022011901009', '16818098924285720495485726215519.jpg', 'Jln', NULL, NULL, '089675008754', 'aab@mail.com', 18350000, NULL, 1, 100, 2, 102, 4, '8G8UPJXD80COSCO4', 1, '2023-04-18 16:26:27', NULL, NULL, 'Hkk', '1', NULL),
(118, 1, 1, '5720F8B60173D0197540FBA0A475C390', '5720F8B60173', '2023-04-18 16:30:30', '', 'Neng siska', '1237894560981237', '16818102799454492313445536451026.jpg', 'Sentiong', NULL, NULL, '085315597164', 'Siska@gmail.com', 16950000, NULL, 1, 100, NULL, NULL, NULL, 'G6ZWGCE4USGGGWO8', NULL, NULL, NULL, NULL, 'Ini testing', NULL, NULL),
(119, 1, 1, '11E769EB5BBF0C47FE6FC3C61E94B04F', '11E769EB5BBF', '2023-04-18 16:36:52', '', 'Neng siska', '1237894560981237', '16818106872423738847774709637345.jpg', 'Sentiong', NULL, NULL, '085315597164', 'Siska@gmail.com', 17500000, NULL, 1, 100, 1, 101, 1, '2F5GL7Y0DVDW08KS', 1, '2023-04-18 17:02:14', 'sent', '', 'Ini testing', '1', NULL),
(120, 1, 1, '679787B26EA0DB02566B6DBC29F6F1EC', '679787B26EA0', '2023-04-18 16:41:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(121, 1, 1, '9A2B31EEC9C98321B729A241DFA8FF4F', '9A2B31EEC9C9', '2023-04-18 16:41:56', '', 'Neng siska', '1237894560981237', '16818109446413823760242999970179.jpg', 'Sentiong', NULL, NULL, '085315597164', 'Siska@gmail.com', 16950000, NULL, 1, 100, 2, 102, 4, 'M8IJH5MSGGGCSWGC', 1, '2023-04-18 16:44:08', NULL, NULL, 'Ini testing', '1', NULL),
(122, 1, 1, '4F07A5A99FC39BD8E50CB3697BC9F56F', '4F07A5A99FC3', '2023-04-18 16:58:56', '', 'Tes andy', '3172022011901009', '20230418165956_4f07a5a99fc3.jpg', 'Jln', NULL, NULL, '089675008754', 'aab@mail.com', 17500000, NULL, 1, 100, 2, 102, 4, 'VB003JKTXESW0SKK', 1, '2023-04-18 17:01:44', 'sent', '', 'Jln renz\r\n', '2', NULL),
(123, 1, 1, '183457BE9CAA88DCA07BDCC7D99C6865', '183457BE9CAA', '2023-04-18 17:19:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(124, 1, 1, '2E422261E21098B4BB48967FF131B06D', '2E422261E210', '2023-04-18 17:22:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(125, 1, 1, '08BC6B405000EE6693227837B04A5E24', '08BC6B405000', '2023-04-20 06:15:17', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(129, 1, 1, 'A4BCD2B6F885FCE53A8A012D75489B53', 'A4BCD2B6F885', '2023-04-20 06:32:22', 'Tidak ada', 'Agnes', '1271036912980005', '20230420063454_a4bcd2b6f885.jpg', 'Tebet', NULL, NULL, '08116061025', 'agnesangela1998@gmail.com', 16950000, NULL, 1, 100, NULL, NULL, NULL, 'O4MDUKYDBMS0KSGW', NULL, NULL, NULL, NULL, 'TIDAK ADA', NULL, NULL),
(131, 1, 1, 'DB02C596272FB529C652F8FDE7C12102', 'DB02C596272F', '2023-04-20 06:47:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(132, 1, 1, 'CE4D183F3182DF667887E9413BFBA0D2', 'CE4D183F3182', '2023-04-26 09:39:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(133, 1, 1, 'A773A43DD4C73290BCB45560FFB79F39', 'A773A43DD4C7', '2023-04-26 09:41:18', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(134, 1, 1, '05131DCE9164AFF54FB1BD00801A69F3', '05131DCE9164', '2023-04-26 10:28:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(138, 1, 1, '76227DA5592A426523D45106576AF484', '76227DA5592A', '2023-04-26 10:36:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(139, 1, 1, '4260B3D88F74D1E1C82EC0F9BC5C323D', '4260B3D88F74', '2023-04-26 10:48:29', '', 'candranata koesoemo', '0317301101283006', '202304261100074260B3D88F74.jpeg', 'pluit', NULL, NULL, '08176702111', 'candranata.koesoemo@gmail.com', 16950000, NULL, 1, 100, 2, 102, 4, 'HQJJPH7V6FC4WCO8', 1, '2023-04-26 10:55:50', NULL, NULL, '', '2', NULL),
(142, 1, 1, 'E122627FB99862EB7E00882A7C01EACF', 'E122627FB998', '2023-04-26 15:59:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 17500000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(143, 1, 1, 'F23A12D299FCBA707334971F8C07BCD0', 'F23A12D299FC', '2023-04-26 15:59:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 17500000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(144, 1, 1, '2EB8D62452F89ADB6E2602FAB6404072', '2EB8D62452F8', '2023-04-26 17:42:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 17500000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(145, 1, 1, '8B8CE29903A4CFA7A4F9398335724A5A', '8B8CE29903A4', '2023-04-26 17:45:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(146, 1, 1, 'F06D9FE0B91F8ED78B323414D1FE0979', 'F06D9FE0B91F', '2023-04-28 17:49:50', '', 'Yahsb', '3172022011901009', '20230428175053F06D9FE0B91F.jpg', 'Jlnbshs shjsnsna', NULL, NULL, '089675008754', 'aab@mail.com', 18350000, NULL, 1, 100, NULL, NULL, NULL, 'JA8K9R3NIAOKOOCO', NULL, NULL, NULL, NULL, '', NULL, NULL),
(147, 1, 1, '1A9FD858636A5371ED49089D8B9FE8DF', '1A9FD858636A', '2023-05-04 11:30:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 16950000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `doto_rkn_pesanandetail`
--

CREATE TABLE `doto_rkn_pesanandetail` (
  `idpesanandetail` bigint UNSIGNED NOT NULL,
  `nomorpesanan` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `sesipesanan` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `idrekanan` int UNSIGNED NOT NULL,
  `idtoko` int UNSIGNED NOT NULL,
  `iditem` int UNSIGNED NOT NULL,
  `iditemprice` int UNSIGNED NOT NULL,
  `jumlahpesan` int UNSIGNED NOT NULL,
  `hargajual` double(12,0) NOT NULL,
  `subtotal` double(12,0) NOT NULL,
  `jumlahdiskon` double(12,0) DEFAULT NULL,
  `statusdata` tinyint UNSIGNED DEFAULT NULL COMMENT 'NULL = belum sesuai ; 1 = sudah sesuai ; 2 sudah disetujui'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_rkn_pesanandetail`
--

INSERT INTO `doto_rkn_pesanandetail` (`idpesanandetail`, `nomorpesanan`, `sesipesanan`, `idrekanan`, `idtoko`, `iditem`, `iditemprice`, `jumlahpesan`, `hargajual`, `subtotal`, `jumlahdiskon`, `statusdata`) VALUES
(1, 'E92F408887FD', 'E92F408887FD3AE6DB386E89016FD4C7', 3, 2, 4, 14, 1, 17500000, 17500000, NULL, NULL),
(2, 'C2BC8DD023E3', 'C2BC8DD023E3A68A0002D0221EFC4367', 3, 2, 4, 14, 1, 17500000, 17500000, NULL, NULL),
(3, '1B2D63CB425A', '1B2D63CB425A6F2F8ADC63BEF6A3AF39', 3, 2, 6, 14, 1, 17500000, 17500000, NULL, NULL),
(4, 'FED8E7BDD237', 'FED8E7BDD2374729A5DC14546EA75519', 3, 2, 5, 14, 2, 17500000, 35000000, NULL, NULL),
(5, '1A1D5A0A758F', '1A1D5A0A758F678386231615203F11BE', 3, 2, 3, 2, 1, 15750000, 15750000, NULL, NULL),
(6, '418F68950312', '418F689503127FC38A99934B038777AD', 3, 2, 7, 26, 1, 18350000, 18350000, NULL, NULL),
(7, 'C071407F8C6A', 'C071407F8C6A4126705DA456B8DA3403', 3, 2, 4, 14, 1, 17500000, 17500000, NULL, NULL),
(8, 'C071407F8C6A', 'C071407F8C6A4126705DA456B8DA3403', 3, 2, 5, 14, 1, 17500000, 17500000, NULL, NULL),
(9, 'A35541537999', 'A35541537999A797DE928C25A4AC2323', 3, 2, 7, 30, 1, 18750000, 18750000, NULL, NULL),
(11, 'D3D6C1C0969F', 'D3D6C1C0969F2EE43EF309EFCDD27A8C', 3, 2, 1, 2, 1, 15750000, 15750000, NULL, NULL),
(12, 'D3D6C1C0969F', 'D3D6C1C0969F2EE43EF309EFCDD27A8C', 3, 2, 1, 6, 1, 16950000, 16950000, NULL, NULL),
(15, '51CA72D92541', '51CA72D925417C9BD7D2A449DFE0942E', 3, 2, 1, 2, 1, 15750000, 15750000, NULL, NULL),
(16, '51CA72D92541', '51CA72D925417C9BD7D2A449DFE0942E', 3, 2, 1, 10, 1, 17750000, 17750000, NULL, NULL),
(23, 'DA3B58DE7B4C', 'DA3B58DE7B4CC26EEF14AC2F662403BC', 3, 2, 1, 2, 1, 15750000, 15750000, NULL, NULL),
(25, '6380A0F79BD6', '6380A0F79BD6C06CFE15FE9013FE4625', 3, 2, 4, 16, 1, 17900000, 17900000, NULL, NULL),
(26, 'DE079A94C551', 'DE079A94C5517B00597A359D7760AA75', 3, 2, 3, 2, 1, 15750000, 15750000, NULL, NULL),
(27, '83C61D828CFE', '83C61D828CFEBCB7FE5FBAC313D7417D', 3, 2, 3, 2, 1, 15750000, 15750000, NULL, NULL),
(28, 'CB62A5E1AA28', 'CB62A5E1AA28C1B3C9DF1FA52F32ACFE', 3, 2, 1, 2, 1, 15750000, 15750000, NULL, NULL),
(29, 'A27ADCB5CCF4', 'A27ADCB5CCF486573CA6487132E945C7', 3, 2, 1, 2, 1, 11800000, 11800000, NULL, NULL),
(30, 'D557428E113B', 'D557428E113B6DAAA3BFD5E4026AAC80', 3, 2, 2, 2, 3, 11800000, 35400000, NULL, NULL),
(32, 'DD044585A831', 'DD044585A83196931099E3D33F147F9B', 3, 2, 1, 1, 1, 9900000, 9900000, NULL, NULL),
(33, 'DD044585A831', 'DD044585A83196931099E3D33F147F9B', 3, 2, 1, 2, 1, 11800000, 11800000, NULL, NULL),
(34, 'DDD1CF9F6D16', 'DDD1CF9F6D16C95431AAF9265EEE0ABF', 3, 2, 3, 2, 1, 11800000, 11800000, NULL, NULL),
(38, '3A59CF3530B8', '3A59CF3530B82993EB4F17AD7E517B9A', 3, 2, 1, 2, 1, 11800000, 11800000, NULL, NULL),
(39, '3A59CF3530B8', '3A59CF3530B82993EB4F17AD7E517B9A', 3, 2, 2, 2, 1, 11800000, 11800000, NULL, NULL),
(43, 'C49289CDC28C', 'C49289CDC28C3C6F774099E57F94E6CF', 3, 3, 6, 2, 1, 11800000, 11800000, NULL, NULL),
(44, 'EEF9C73D9C6D', 'EEF9C73D9C6DADD68B45ECD67E5EAE08', 3, 3, 1, 2, 1, 11800000, 11800000, NULL, NULL),
(45, 'A907AFC13479', 'A907AFC134799361F82214D9247C36A4', 3, 3, 1, 2, 1, 11800000, 11800000, NULL, NULL),
(48, 'A2E10FAB26A3', 'A2E10FAB26A39830304948DDDA63A623', 3, 3, 1, 2, 1, 11800000, 11800000, NULL, NULL),
(52, 'B923CA61BB1C', 'B923CA61BB1C4E091C768D5D6BBC0A9C', 3, 3, 1, 2, 1, 11800000, 11800000, NULL, NULL),
(53, '6B999D10858C', '6B999D10858C2D8BD8DD00B7618EEE61', 3, 3, 1, 2, 1, 11800000, 11800000, NULL, NULL),
(59, '3C0EE30D9740', '3C0EE30D9740D48F2DC179F82E67AC1E', 3, 3, 5, 2, 1, 11800000, 11800000, NULL, NULL),
(62, '79979CE8AB63', '79979CE8AB636A17E3651A8FD9EF270E', 3, 3, 1, 2, 1, 11800000, 11800000, NULL, NULL),
(78, 'FC8785BA3C4E', 'FC8785BA3C4EB119477A1CD04CD7FAEC', 3, 2, 2, 2, 1, 11800000, 11800000, NULL, NULL),
(79, '160EE6A43F91', '160EE6A43F91AE5E2517D50827DE8068', 3, 2, 2, 2, 1, 11800000, 11800000, NULL, NULL),
(81, '8F73B2789010', '8F73B278901017CF613D4D8D8F1C8E54', 3, 3, 1, 2, 2, 11800000, 23600000, NULL, NULL),
(85, 'A38684870E97', 'A38684870E97944E6BA6AFD47CD53F8F', 3, 3, 1, 2, 1, 11800000, 11800000, NULL, NULL),
(86, '5C87ACB73937', '5C87ACB73937C3125FB5608AE3CEC311', 3, 3, 1, 2, 1, 11800000, 11800000, NULL, NULL),
(87, 'E4C104812169', 'E4C10481216931882AD150C928E504F2', 3, 3, 1, 2, 1, 11800000, 11800000, NULL, NULL),
(88, '96807301A118', '96807301A118C82DBA76B24D7A9F5626', 3, 3, 6, 2, 1, 11800000, 11800000, NULL, NULL),
(89, '67A865D154A7', '67A865D154A75BC44F4042723665675C', 1, 1, 1, 2, 1, 11800000, 11800000, NULL, NULL),
(90, '889A98AD6D3B', '889A98AD6D3BF979D9FC7F156C7F87E8', 1, 1, 43, 502, 1, 21750000, 21750000, NULL, NULL),
(91, 'D58F95F0E18F', 'D58F95F0E18F0D7C2D2117E7A3C0F533', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(92, 'F65BCFA38EE9', 'F65BCFA38EE93DD65C79AD33414A540B', 1, 1, 40, 20, 1, 18350000, 18350000, NULL, NULL),
(93, '3AC7BA57D276', '3AC7BA57D2769BE95A6194ECDF82CE3E', 1, 1, 40, 20, 1, 18350000, 18350000, NULL, NULL),
(94, 'B6FDD91144A0', 'B6FDD91144A083B464413EC76E7B4CD9', 1, 1, 40, 20, 2, 18350000, 36700000, NULL, NULL),
(95, '9256E958F1A6', '9256E958F1A6FA8097717F0E5FFEF839', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(96, 'AB674E488852', 'AB674E48885257C575C340F8AE67E8DE', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(98, 'DF0F20B9C0A9', 'DF0F20B9C0A9B8C3FB2E9F2B79A48C12', 1, 1, 28, 12, 1, 17500000, 17500000, NULL, NULL),
(100, 'A1DA8D805907', 'A1DA8D805907C1D957A73D5DAC522318', 1, 1, 40, 20, 1, 18350000, 18350000, NULL, NULL),
(102, '464B66F93AF4', '464B66F93AF45A34E1AF9025BD4F970A', 1, 1, 28, 12, 1, 17500000, 17500000, NULL, NULL),
(103, '00FA20FE7E96', '00FA20FE7E964D2A377382FBCBA95A64', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(104, '5D75250EA300', '5D75250EA300005AD079F7F4D881EF20', 1, 1, 28, 12, 1, 17500000, 17500000, NULL, NULL),
(105, '1F8CEEF0815A', '1F8CEEF0815A3CB5C9B2F24594EDF03C', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(106, '1120E79F44CE', '1120E79F44CEA9DE5F6DD3483B9F09CE', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(107, '6491DAE4340F', '6491DAE4340F75EB381BB3EA2C991E13', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(108, 'A59C1D0AB963', 'A59C1D0AB963DEB4B22950E05A35FCF6', 1, 1, 28, 12, 1, 17500000, 17500000, NULL, NULL),
(109, '34578AE8AE1B', '34578AE8AE1BF554ECD2364BCC38F621', 1, 1, 28, 12, 1, 17500000, 17500000, NULL, NULL),
(110, '906D6E22008F', '906D6E22008FFC8B977CF60E9F394D42', 1, 1, 40, 20, 1, 18350000, 18350000, NULL, NULL),
(111, 'D348963757C5', 'D348963757C5C9EC311042B9A21C38FC', 1, 1, 28, 12, 1, 17500000, 17500000, NULL, NULL),
(112, '6A4CEE791542', '6A4CEE791542B235B1E051D5464D1152', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(113, '4964C205FD24', '4964C205FD24BA06122C5C604FF589F4', 1, 1, 28, 12, 1, 17500000, 17500000, NULL, NULL),
(114, '76A495683B8D', '76A495683B8D1B6B72A912C066790EA1', 1, 1, 28, 12, 1, 17500000, 17500000, NULL, NULL),
(115, '59E3CA1C4CC4', '59E3CA1C4CC4A2F7C0555752FDD5A84B', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(116, 'BEEA299A5646', 'BEEA299A564623419381D607E6C9F645', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(117, '470F0C82A935', '470F0C82A935F3E6CDA3A185DFB1F568', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(118, '7028BEC11F3A', '7028BEC11F3A0ABD27ADC0CACB4383B5', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(119, '7C2AE24E2A01', '7C2AE24E2A015FCFC8C1B554320326C3', 1, 1, 40, 20, 1, 18350000, 18350000, NULL, NULL),
(120, 'FBFD61241178', 'FBFD61241178DF9C1EB60A93BEC42F91', 1, 1, 42, 20, 1, 18350000, 18350000, NULL, NULL),
(122, 'D152EE2C2062', 'D152EE2C20627FA090753E5F85487E3D', 1, 1, 40, 20, 1, 18350000, 18350000, NULL, NULL),
(123, '5720F8B60173', '5720F8B60173D0197540FBA0A475C390', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(124, '11E769EB5BBF', '11E769EB5BBF0C47FE6FC3C61E94B04F', 1, 1, 28, 12, 1, 17500000, 17500000, NULL, NULL),
(125, '679787B26EA0', '679787B26EA0DB02566B6DBC29F6F1EC', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(126, '9A2B31EEC9C9', '9A2B31EEC9C98321B729A241DFA8FF4F', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(127, '4F07A5A99FC3', '4F07A5A99FC39BD8E50CB3697BC9F56F', 1, 1, 30, 12, 1, 17500000, 17500000, NULL, NULL),
(128, '183457BE9CAA', '183457BE9CAA88DCA07BDCC7D99C6865', 1, 1, 8, 4, 1, 16950000, 16950000, NULL, NULL),
(129, '2E422261E210', '2E422261E21098B4BB48967FF131B06D', 1, 1, 8, 4, 1, 16950000, 16950000, NULL, NULL),
(133, '08BC6B405000', '08BC6B405000EE6693227837B04A5E24', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(135, 'A4BCD2B6F885', 'A4BCD2B6F885FCE53A8A012D75489B53', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(136, 'DB02C596272F', 'DB02C596272FB529C652F8FDE7C12102', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(137, 'CE4D183F3182', 'CE4D183F3182DF667887E9413BFBA0D2', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(138, 'A773A43DD4C7', 'A773A43DD4C73290BCB45560FFB79F39', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(142, '05131DCE9164', '05131DCE9164AFF54FB1BD00801A69F3', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(143, '76227DA5592A', '76227DA5592A426523D45106576AF484', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(146, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL),
(147, 'E122627FB998', 'E122627FB99862EB7E00882A7C01EACF', 1, 1, 28, 12, 1, 17500000, 17500000, NULL, NULL),
(148, 'F23A12D299FC', 'F23A12D299FCBA707334971F8C07BCD0', 1, 1, 28, 12, 1, 17500000, 17500000, NULL, NULL),
(149, '2EB8D62452F8', '2EB8D62452F89ADB6E2602FAB6404072', 1, 1, 28, 12, 1, 17500000, 17500000, NULL, NULL),
(150, '8B8CE29903A4', '8B8CE29903A4CFA7A4F9398335724A5A', 1, 1, 9, 4, 1, 16950000, 16950000, NULL, NULL),
(151, 'F06D9FE0B91F', 'F06D9FE0B91F8ED78B323414D1FE0979', 1, 1, 40, 20, 1, 18350000, 18350000, NULL, NULL),
(152, '1A9FD858636A', '1A9FD858636A5371ED49089D8B9FE8DF', 1, 1, 7, 4, 1, 16950000, 16950000, NULL, NULL);

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

--
-- Table structure for table `doto_rkn_pesanannote`
--

CREATE TABLE `doto_rkn_pesanannote` (
  `idpesanannote` bigint UNSIGNED NOT NULL,
  `nomorpesanan` varchar(25) NOT NULL,
  `sesipesanan` varchar(50) NOT NULL,
  `idrekanan` int UNSIGNED NOT NULL,
  `idtoko` int UNSIGNED NOT NULL,
  `statusorder` tinyint UNSIGNED NOT NULL,
  `catatan` varchar(200) NOT NULL,
  `catattgl` datetime NOT NULL,
  `catatoleh` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `doto_rkn_pesanannote`
--

INSERT INTO `doto_rkn_pesanannote` (`idpesanannote`, `nomorpesanan`, `sesipesanan`, `idrekanan`, `idtoko`, `statusorder`, `catatan`, `catattgl`, `catatoleh`) VALUES
(1, '160EE6A43F91', '160EE6A43F91AE5E2517D50827DE8068', 3, 2, 1, 'Mengubah data produk yang dipesan.', '2023-05-20 15:30:18', 'admdoto'),
(2, '160EE6A43F91', '160EE6A43F91AE5E2517D50827DE8068', 3, 2, 1, 'Mengubah data pemesan.', '2023-05-21 14:06:34', 'admdoto'),
(3, '160EE6A43F91', '160EE6A43F91AE5E2517D50827DE8068', 3, 2, 1, 'Membatalkan perubahan data produk yang dipesan (ID: 1).', '2023-05-21 18:02:53', 'admdoto'),
(4, '160EE6A43F91', '160EE6A43F91AE5E2517D50827DE8068', 3, 2, 1, 'Membatalkan perubahan data pemesan (ID: 1).', '2023-05-21 18:13:13', 'admdoto'),
(5, '160EE6A43F91', '160EE6A43F91AE5E2517D50827DE8068', 3, 2, 1, 'Mengubah data pemesan.', '2023-05-21 19:16:09', 'admdoto'),
(6, '160EE6A43F91', '160EE6A43F91AE5E2517D50827DE8068', 3, 2, 1, 'Membatalkan perubahan data produk yang dipesan (ID: 1).', '2023-05-21 19:46:26', 'admdoto'),
(7, '160EE6A43F91', '160EE6A43F91AE5E2517D50827DE8068', 3, 2, 1, 'Menyatakan data produk yang dipesan telah sesuai.', '2023-05-21 20:01:04', 'admdoto'),
(8, '160EE6A43F91', '160EE6A43F91AE5E2517D50827DE8068', 3, 2, 1, 'Membatalkan perubahan data pemesan (ID: 2).', '2023-05-22 11:52:05', 'admdoto'),
(9, '160EE6A43F91', '160EE6A43F91AE5E2517D50827DE8068', 3, 2, 1, 'Membatalkan perubahan data faktur (ID: 1).', '2023-05-22 14:03:12', 'admdoto'),
(10, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 1, 1, 1, 'Mengubah data produk yang dipesan.', '2023-05-22 15:18:59', 'admsales'),
(11, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 1, 1, 1, 'Mengubah data pemesan.', '2023-05-22 15:19:26', 'admsales'),
(12, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 1, 1, 1, 'Mengubah data faktur.', '2023-05-22 15:59:19', 'admsales'),
(13, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 1, 1, 1, 'Mengubah data pemesan.', '2023-05-22 16:04:16', 'admsales'),
(14, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 1, 1, 1, 'Membatalkan perubahan data produk yang dipesan (ID: 3).', '2023-05-22 16:53:25', 'admsales'),
(15, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 1, 1, 1, 'Menyatakan data produk yang dipesan telah sesuai.', '2023-05-22 17:06:27', 'admsales'),
(16, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 1, 1, 1, 'Menyetujui data faktur (ID: 139 / No. 4260B3D88F74).', '2023-05-24 09:10:55', 'admsales'),
(18, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 1, 1, 1, 'Menolak data pemesan (ID: 139 / No. 4260B3D88F74) karena alamat tidak lengkap sehingga tidak dapat menemukan lokasi pemesan di google map.', '2023-05-24 09:27:17', 'admdoto'),
(19, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 1, 1, 1, 'Menyetujui data produk (ID: 139 / No. 4260B3D88F74).', '2023-05-26 08:31:58', 'admdoto'),
(20, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 1, 1, 1, 'Mengubah data pemesan.', '2023-05-26 08:54:55', 'admsales'),
(21, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 1, 1, 1, 'Alamat pemesan sudah dilengkapi menjadi apt. Greenbay Pluit (-6.108299459884753, 106.77892737032604)', '2023-05-26 08:56:36', 'admsales'),
(22, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 1, 1, 1, 'Menyetujui data pemesan (ID: 139 / No. 4260B3D88F74).', '2023-05-26 08:57:03', 'admdoto');

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

--
-- Table structure for table `doto_rkn_pfakturapproval`
--

CREATE TABLE `doto_rkn_pfakturapproval` (
  `idpfakturapproval` bigint UNSIGNED NOT NULL,
  `idrekanan` int UNSIGNED NOT NULL,
  `idtoko` int UNSIGNED NOT NULL,
  `nomorpesanan` varchar(25) NOT NULL,
  `sesipesanan` varchar(50) NOT NULL,
  `namalengkap` varchar(100) NOT NULL,
  `noktp` varchar(20) NOT NULL,
  `fotoktp` varchar(50) NOT NULL,
  `nokk` varchar(20) NOT NULL,
  `fotokk` varchar(50) NOT NULL,
  `nonpwp` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fotonpwp` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mintatgl` datetime NOT NULL,
  `mintaoleh` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tolaktgl` datetime DEFAULT NULL,
  `tolakoleh` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tolaksebab` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `setujutgl` datetime DEFAULT NULL,
  `setujuoleh` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pengajuantgl` datetime DEFAULT NULL,
  `pengajuanbukti` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `selesaitgl` datetime DEFAULT NULL,
  `selesaibukti` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `doto_rkn_pfakturapproval`
--

INSERT INTO `doto_rkn_pfakturapproval` (`idpfakturapproval`, `idrekanan`, `idtoko`, `nomorpesanan`, `sesipesanan`, `namalengkap`, `noktp`, `fotoktp`, `nokk`, `fotokk`, `nonpwp`, `fotonpwp`, `mintatgl`, `mintaoleh`, `tolaktgl`, `tolakoleh`, `tolaksebab`, `setujutgl`, `setujuoleh`, `pengajuantgl`, `pengajuanbukti`, `selesaitgl`, `selesaibukti`) VALUES
(1, 3, 2, '160EE6A43F91', '160EE6A43F91AE5E2517D50827DE8068', 'Hariyanto', '1234567890123456', '160EE6A43F9120230522135735_ktp.jpg', '', '', '', '', '2023-05-22 13:57:35', 'admdoto', '2023-05-22 14:03:12', 'admdoto', 'BATAL UBAH', NULL, NULL, NULL, NULL, NULL, NULL),
(2, 1, 1, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 'Budiasto Kusuma', '1234567890123456', '4260B3D88F7420230522152005_ktp.jpg', '', '', '', '', '2023-05-22 15:20:05', 'admsales', '2023-05-22 15:36:05', 'OTOMATIS', 'BATAL UBAH', NULL, NULL, NULL, NULL, NULL, NULL),
(3, 1, 1, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 'Budiasto Kusuma', '1234567890123456', '4260B3D88F7420230522152005_ktp.jpg', '', '4260B3D88F7420230522153605_kk.jpg', '', '', '2023-05-22 15:36:05', 'admsales', '2023-05-22 15:42:40', 'OTOMATIS', 'BATAL UBAH', NULL, NULL, NULL, NULL, NULL, NULL),
(4, 1, 1, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 'Budiasto Kusuma', '1234567890123456', '4260B3D88F7420230522152005_ktp.jpg', '1357924680112233', '4260B3D88F7420230522153605_kk.jpg', '', '', '2023-05-22 15:42:40', 'admsales', '2023-05-22 15:59:19', 'OTOMATIS', 'BATAL UBAH', NULL, NULL, NULL, NULL, NULL, NULL),
(5, 1, 1, '4260B3D88F74', '4260B3D88F74D1E1C82EC0F9BC5C323D', 'Budiasto Kusuma', '1234567890123456', '4260B3D88F7420230522152005_ktp.jpg', '1357924680112233', '4260B3D88F7420230522153605_kk.jpg', '112233445566778', '4260B3D88F7420230522155919_ktp.jpg', '2023-05-22 15:59:19', 'admsales', NULL, NULL, NULL, '2023-05-24 09:10:55', 'admsales', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `doto_rkn_pok`
--

CREATE TABLE `doto_rkn_pok` (
  `idpok` int NOT NULL,
  `idrekanan` int NOT NULL,
  `idtoko` int NOT NULL,
  `sesipesanan` varchar(50) NOT NULL,
  `nomorpesanan` varchar(25) NOT NULL,
  `okoleh` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `oktgl` datetime NOT NULL,
  `tolakoleh` varchar(25) DEFAULT NULL,
  `tolaktgl` datetime DEFAULT NULL,
  `tolaksebab` varchar(200) DEFAULT NULL,
  `setujuoleh` varchar(25) DEFAULT NULL,
  `setujutgl` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `doto_rkn_rekanan`
--

CREATE TABLE `doto_rkn_rekanan` (
  `idrekanan` int UNSIGNED NOT NULL,
  `idchannel` int UNSIGNED NOT NULL,
  `namarekanan` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `koderekanan` varchar(5) NOT NULL,
  `pid` varchar(15) NOT NULL,
  `alamatrekanan` text NOT NULL,
  `idkota` int UNSIGNED NOT NULL,
  `idpropinsi` int UNSIGNED NOT NULL,
  `idwilayah` int UNSIGNED DEFAULT NULL,
  `idarea` int UNSIGNED DEFAULT NULL,
  `namalengkap` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `teleponrekanan` varchar(25) NOT NULL,
  `emailrekanan` varchar(100) NOT NULL,
  `tglinput` date NOT NULL,
  `statussuspend` tinyint UNSIGNED NOT NULL COMMENT '0 = tidak di-suspend ; 1 = di-suspend',
  `statusnonaktif` tinyint UNSIGNED NOT NULL DEFAULT '0' COMMENT '0 = aktif ; 1 = non-aktif'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_rkn_rekanan`
--

INSERT INTO `doto_rkn_rekanan` (`idrekanan`, `idchannel`, `namarekanan`, `koderekanan`, `pid`, `alamatrekanan`, `idkota`, `idpropinsi`, `idwilayah`, `idarea`, `namalengkap`, `teleponrekanan`, `emailrekanan`, `tglinput`, `statussuspend`, `statusnonaktif`) VALUES
(1, 1, 'PT Digital Consumer Engagement', 'DCE', 'JDY9BTGE', 'Mangkuluhur City Tower One Lt. 18, Jl. Gatot Subroto Kav. 1 - 3, Karet Semanggi, Setiabudi, DKI Jakarta 12930', 11, 161, NULL, NULL, 'Candranata Koesoemo', '08176702111', 'candra@dmmgroup.id', '2023-02-16', 0, 0),
(2, 2, 'PT SRCIS', 'SRC', 'X2VISF8T', 'One Pacific Place, Jl. Jend. Sudirman Kav 52-53, Senayan, Kby. Baru, Jakarta Selatan, DKI Jakarta 12190', 161, 11, NULL, NULL, 'Prisca Okke', '081234567890', 'budi.santoso7@sampoerna.com', '2023-02-16', 0, 0),
(3, 3, 'PT Logitek Digital Nusantara', 'LDN', '1A2B3C4D', 'Mall Ambasador Lt. 5 No. 11, Jl. Prof. DR. Satrio No.65, Karet Kuningan, Setiabudi 12940', 161, 11, NULL, NULL, 'Rinoldi', '08128006195', 'rinoldd@gmail.com', '2023-02-16', 0, 0);

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

--
-- Table structure for table `doto_rkn_toko`
--

CREATE TABLE `doto_rkn_toko` (
  `idtoko` int UNSIGNED NOT NULL,
  `idrekanan` int UNSIGNED DEFAULT NULL COMMENT 'NULL = pemilik lokasi bukan partner',
  `mid` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `namatoko` varchar(200) NOT NULL,
  `namapemilik` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `telplokasi` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `alamatlokasi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci,
  `idchannel` int UNSIGNED DEFAULT NULL,
  `idkota` int UNSIGNED DEFAULT NULL,
  `idpropinsi` int UNSIGNED DEFAULT NULL,
  `idwilayah` int UNSIGNED DEFAULT NULL,
  `idarea` int UNSIGNED DEFAULT NULL,
  `latitude` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `longitude` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `jambuka` time DEFAULT NULL,
  `jamtutup` time DEFAULT NULL,
  `statusnonaktif` tinyint NOT NULL COMMENT '0 = aktif ; 1 = tidak aktif',
  `tglinput` date NOT NULL,
  `userinput` varchar(50) NOT NULL,
  `tglnonaktif` date DEFAULT NULL,
  `usernonaktif` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `doto_rkn_toko`
--

INSERT INTO `doto_rkn_toko` (`idtoko`, `idrekanan`, `mid`, `namatoko`, `namapemilik`, `telplokasi`, `alamatlokasi`, `idchannel`, `idkota`, `idpropinsi`, `idwilayah`, `idarea`, `latitude`, `longitude`, `jambuka`, `jamtutup`, `statusnonaktif`, `tglinput`, `userinput`, `tglnonaktif`, `usernonaktif`) VALUES
(1, 1, 'DGO63B10AE61', 'DigimaxOTO', 'PT Digital Consumer Engagement', '622127883335', 'Mangkuluhur City Tower One 18th Floor<br>Jl. Jend. Gatot Subroto Kav. 1-3, Jakarta Selatan, DKI Jakarta 12930\r\nIndonesia', 1, 11, 161, NULL, NULL, '-6.220691085296502', '106.81454608329148', '09:00:00', '18:00:00', 0, '2023-01-01', 'admdigimaxoto', NULL, NULL),
(2, 3, 'LDN123TST456', 'Dropper Point Kasablanka', 'Andi', '6281234567890', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2023-02-17', 'LDN123TST456', NULL, NULL),
(3, 3, 'SKLDN01', 'Agen test', 'LDN TEST', '6282261618727', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '2023-03-27', 'SKLDN01', NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `doto_ho_appauthorization`
--
ALTER TABLE `doto_ho_appauthorization`
  ADD PRIMARY KEY (`appauthid`);

--
-- Indexes for table `doto_ho_appauthorizationapproval`
--
ALTER TABLE `doto_ho_appauthorizationapproval`
  ADD PRIMARY KEY (`appauthid`);

--
-- Indexes for table `doto_ho_appmenu`
--
ALTER TABLE `doto_ho_appmenu`
  ADD PRIMARY KEY (`appmenuid`);

--
-- Indexes for table `doto_ho_appuser`
--
ALTER TABLE `doto_ho_appuser`
  ADD PRIMARY KEY (`userid`);

--
-- Indexes for table `doto_ho_appuserapproval`
--
ALTER TABLE `doto_ho_appuserapproval`
  ADD PRIMARY KEY (`userid`);

--
-- Indexes for table `doto_ho_appusergroup`
--
ALTER TABLE `doto_ho_appusergroup`
  ADD PRIMARY KEY (`usergroupid`);

--
-- Indexes for table `doto_ho_appusergroupapproval`
--
ALTER TABLE `doto_ho_appusergroupapproval`
  ADD PRIMARY KEY (`usergroupid`);

--
-- Indexes for table `doto_ho_banktujuanbayar`
--
ALTER TABLE `doto_ho_banktujuanbayar`
  ADD PRIMARY KEY (`idbanktujuanbayar`);

--
-- Indexes for table `doto_ho_carabayarlunas`
--
ALTER TABLE `doto_ho_carabayarlunas`
  ADD PRIMARY KEY (`idcarabayarlunas`);

--
-- Indexes for table `doto_ho_carabayartandajadi`
--
ALTER TABLE `doto_ho_carabayartandajadi`
  ADD PRIMARY KEY (`idcarabayartandajadi`);

--
-- Indexes for table `doto_ho_channel`
--
ALTER TABLE `doto_ho_channel`
  ADD PRIMARY KEY (`idchannel`);

--
-- Indexes for table `doto_ho_disclaimer`
--
ALTER TABLE `doto_ho_disclaimer`
  ADD PRIMARY KEY (`iddisclaimer`);

--
-- Indexes for table `doto_ho_download`
--
ALTER TABLE `doto_ho_download`
  ADD PRIMARY KEY (`idfile`);

--
-- Indexes for table `doto_ho_item`
--
ALTER TABLE `doto_ho_item`
  ADD PRIMARY KEY (`iditem`),
  ADD UNIQUE KEY `nomorsku` (`nomorsku`);

--
-- Indexes for table `doto_ho_itemprice`
--
ALTER TABLE `doto_ho_itemprice`
  ADD PRIMARY KEY (`iditemprice`);

--
-- Indexes for table `doto_ho_kategoribarang`
--
ALTER TABLE `doto_ho_kategoribarang`
  ADD PRIMARY KEY (`idkategoribarang`);

--
-- Indexes for table `doto_ho_kota`
--
ALTER TABLE `doto_ho_kota`
  ADD PRIMARY KEY (`idkota`);

--
-- Indexes for table `doto_ho_logakses`
--
ALTER TABLE `doto_ho_logakses`
  ADD PRIMARY KEY (`idlogakses`);

--
-- Indexes for table `doto_ho_merek`
--
ALTER TABLE `doto_ho_merek`
  ADD PRIMARY KEY (`idmerek`);

--
-- Indexes for table `doto_ho_model`
--
ALTER TABLE `doto_ho_model`
  ADD PRIMARY KEY (`idmodel`);

--
-- Indexes for table `doto_ho_nilaidp`
--
ALTER TABLE `doto_ho_nilaidp`
  ADD PRIMARY KEY (`idnilaidp`);

--
-- Indexes for table `doto_ho_parent_menu`
--
ALTER TABLE `doto_ho_parent_menu`
  ADD PRIMARY KEY (`parentmenuid`);

--
-- Indexes for table `doto_ho_propinsi`
--
ALTER TABLE `doto_ho_propinsi`
  ADD PRIMARY KEY (`idpropinsi`);

--
-- Indexes for table `doto_ho_spekmotor`
--
ALTER TABLE `doto_ho_spekmotor`
  ADD PRIMARY KEY (`idspekmotor`);

--
-- Indexes for table `doto_ho_thnproduksi`
--
ALTER TABLE `doto_ho_thnproduksi`
  ADD PRIMARY KEY (`idthnproduksi`);

--
-- Indexes for table `doto_ho_voucher`
--
ALTER TABLE `doto_ho_voucher`
  ADD PRIMARY KEY (`idvoucher`);

--
-- Indexes for table `doto_ho_warna`
--
ALTER TABLE `doto_ho_warna`
  ADD PRIMARY KEY (`idwarna`);

--
-- Indexes for table `doto_ho_wilayahotr`
--
ALTER TABLE `doto_ho_wilayahotr`
  ADD PRIMARY KEY (`idwilayahotr`),
  ADD UNIQUE KEY `kodewilayahotr` (`kodewilayahotr`);

--
-- Indexes for table `doto_rkn_appauthorization`
--
ALTER TABLE `doto_rkn_appauthorization`
  ADD PRIMARY KEY (`appauthid`);

--
-- Indexes for table `doto_rkn_appauthorizationapproval`
--
ALTER TABLE `doto_rkn_appauthorizationapproval`
  ADD PRIMARY KEY (`appauthid`);

--
-- Indexes for table `doto_rkn_appmenu`
--
ALTER TABLE `doto_rkn_appmenu`
  ADD PRIMARY KEY (`appmenuid`);

--
-- Indexes for table `doto_rkn_appuser`
--
ALTER TABLE `doto_rkn_appuser`
  ADD PRIMARY KEY (`userid`);

--
-- Indexes for table `doto_rkn_appuserapproval`
--
ALTER TABLE `doto_rkn_appuserapproval`
  ADD PRIMARY KEY (`userid`);

--
-- Indexes for table `doto_rkn_appusergroup`
--
ALTER TABLE `doto_rkn_appusergroup`
  ADD PRIMARY KEY (`usergroupid`);

--
-- Indexes for table `doto_rkn_appusergroupapproval`
--
ALTER TABLE `doto_rkn_appusergroupapproval`
  ADD PRIMARY KEY (`usergroupid`);

--
-- Indexes for table `doto_rkn_bpkbstnk`
--
ALTER TABLE `doto_rkn_bpkbstnk`
  ADD PRIMARY KEY (`idbpkbstnk`);

--
-- Indexes for table `doto_rkn_lunasbayar`
--
ALTER TABLE `doto_rkn_lunasbayar`
  ADD PRIMARY KEY (`idlunasbayar`);

--
-- Indexes for table `doto_rkn_papproval`
--
ALTER TABLE `doto_rkn_papproval`
  ADD PRIMARY KEY (`idpapproval`);

--
-- Indexes for table `doto_rkn_parent_menu`
--
ALTER TABLE `doto_rkn_parent_menu`
  ADD PRIMARY KEY (`parentmenuid`);

--
-- Indexes for table `doto_rkn_pbatal`
--
ALTER TABLE `doto_rkn_pbatal`
  ADD PRIMARY KEY (`idpbatal`);

--
-- Indexes for table `doto_rkn_pdetailapproval`
--
ALTER TABLE `doto_rkn_pdetailapproval`
  ADD PRIMARY KEY (`idpdetailapproval`);

--
-- Indexes for table `doto_rkn_pdetailok`
--
ALTER TABLE `doto_rkn_pdetailok`
  ADD PRIMARY KEY (`idpdetailok`);

--
-- Indexes for table `doto_rkn_pengiriman`
--
ALTER TABLE `doto_rkn_pengiriman`
  ADD PRIMARY KEY (`idpengiriman`);

--
-- Indexes for table `doto_rkn_pesanan`
--
ALTER TABLE `doto_rkn_pesanan`
  ADD PRIMARY KEY (`idpesanan`),
  ADD UNIQUE KEY `sesipesanan` (`sesipesanan`);

--
-- Indexes for table `doto_rkn_pesanandetail`
--
ALTER TABLE `doto_rkn_pesanandetail`
  ADD PRIMARY KEY (`idpesanandetail`);

--
-- Indexes for table `doto_rkn_pesanannote`
--
ALTER TABLE `doto_rkn_pesanannote`
  ADD PRIMARY KEY (`idpesanannote`);

--
-- Indexes for table `doto_rkn_pfakturapproval`
--
ALTER TABLE `doto_rkn_pfakturapproval`
  ADD PRIMARY KEY (`idpfakturapproval`);

--
-- Indexes for table `doto_rkn_pok`
--
ALTER TABLE `doto_rkn_pok`
  ADD PRIMARY KEY (`idpok`);

--
-- Indexes for table `doto_rkn_rekanan`
--
ALTER TABLE `doto_rkn_rekanan`
  ADD PRIMARY KEY (`idrekanan`);

--
-- Indexes for table `doto_rkn_toko`
--
ALTER TABLE `doto_rkn_toko`
  ADD PRIMARY KEY (`idtoko`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `doto_ho_appauthorization`
--
ALTER TABLE `doto_ho_appauthorization`
  MODIFY `appauthid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `doto_ho_appauthorizationapproval`
--
ALTER TABLE `doto_ho_appauthorizationapproval`
  MODIFY `appauthid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_ho_appmenu`
--
ALTER TABLE `doto_ho_appmenu`
  MODIFY `appmenuid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT for table `doto_ho_appuser`
--
ALTER TABLE `doto_ho_appuser`
  MODIFY `userid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `doto_ho_appuserapproval`
--
ALTER TABLE `doto_ho_appuserapproval`
  MODIFY `userid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_ho_appusergroup`
--
ALTER TABLE `doto_ho_appusergroup`
  MODIFY `usergroupid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `doto_ho_appusergroupapproval`
--
ALTER TABLE `doto_ho_appusergroupapproval`
  MODIFY `usergroupid` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_ho_banktujuanbayar`
--
ALTER TABLE `doto_ho_banktujuanbayar`
  MODIFY `idbanktujuanbayar` tinyint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_ho_carabayarlunas`
--
ALTER TABLE `doto_ho_carabayarlunas`
  MODIFY `idcarabayarlunas` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `doto_ho_carabayartandajadi`
--
ALTER TABLE `doto_ho_carabayartandajadi`
  MODIFY `idcarabayartandajadi` tinyint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `doto_ho_channel`
--
ALTER TABLE `doto_ho_channel`
  MODIFY `idchannel` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `doto_ho_disclaimer`
--
ALTER TABLE `doto_ho_disclaimer`
  MODIFY `iddisclaimer` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `doto_ho_download`
--
ALTER TABLE `doto_ho_download`
  MODIFY `idfile` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_ho_item`
--
ALTER TABLE `doto_ho_item`
  MODIFY `iditem` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT for table `doto_ho_itemprice`
--
ALTER TABLE `doto_ho_itemprice`
  MODIFY `iditemprice` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=625;

--
-- AUTO_INCREMENT for table `doto_ho_kategoribarang`
--
ALTER TABLE `doto_ho_kategoribarang`
  MODIFY `idkategoribarang` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `doto_ho_kota`
--
ALTER TABLE `doto_ho_kota`
  MODIFY `idkota` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=523;

--
-- AUTO_INCREMENT for table `doto_ho_logakses`
--
ALTER TABLE `doto_ho_logakses`
  MODIFY `idlogakses` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100;

--
-- AUTO_INCREMENT for table `doto_ho_merek`
--
ALTER TABLE `doto_ho_merek`
  MODIFY `idmerek` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `doto_ho_model`
--
ALTER TABLE `doto_ho_model`
  MODIFY `idmodel` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `doto_ho_nilaidp`
--
ALTER TABLE `doto_ho_nilaidp`
  MODIFY `idnilaidp` tinyint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `doto_ho_parent_menu`
--
ALTER TABLE `doto_ho_parent_menu`
  MODIFY `parentmenuid` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `doto_ho_propinsi`
--
ALTER TABLE `doto_ho_propinsi`
  MODIFY `idpropinsi` smallint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `doto_ho_spekmotor`
--
ALTER TABLE `doto_ho_spekmotor`
  MODIFY `idspekmotor` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_ho_thnproduksi`
--
ALTER TABLE `doto_ho_thnproduksi`
  MODIFY `idthnproduksi` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `doto_ho_voucher`
--
ALTER TABLE `doto_ho_voucher`
  MODIFY `idvoucher` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_ho_warna`
--
ALTER TABLE `doto_ho_warna`
  MODIFY `idwarna` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `doto_ho_wilayahotr`
--
ALTER TABLE `doto_ho_wilayahotr`
  MODIFY `idwilayahotr` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `doto_rkn_appauthorization`
--
ALTER TABLE `doto_rkn_appauthorization`
  MODIFY `appauthid` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_rkn_appauthorizationapproval`
--
ALTER TABLE `doto_rkn_appauthorizationapproval`
  MODIFY `appauthid` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_rkn_appmenu`
--
ALTER TABLE `doto_rkn_appmenu`
  MODIFY `appmenuid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `doto_rkn_appuser`
--
ALTER TABLE `doto_rkn_appuser`
  MODIFY `userid` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `doto_rkn_appuserapproval`
--
ALTER TABLE `doto_rkn_appuserapproval`
  MODIFY `userid` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_rkn_appusergroup`
--
ALTER TABLE `doto_rkn_appusergroup`
  MODIFY `usergroupid` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_rkn_appusergroupapproval`
--
ALTER TABLE `doto_rkn_appusergroupapproval`
  MODIFY `usergroupid` bigint NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_rkn_bpkbstnk`
--
ALTER TABLE `doto_rkn_bpkbstnk`
  MODIFY `idbpkbstnk` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_rkn_lunasbayar`
--
ALTER TABLE `doto_rkn_lunasbayar`
  MODIFY `idlunasbayar` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_rkn_papproval`
--
ALTER TABLE `doto_rkn_papproval`
  MODIFY `idpapproval` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `doto_rkn_parent_menu`
--
ALTER TABLE `doto_rkn_parent_menu`
  MODIFY `parentmenuid` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `doto_rkn_pbatal`
--
ALTER TABLE `doto_rkn_pbatal`
  MODIFY `idpbatal` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_rkn_pdetailapproval`
--
ALTER TABLE `doto_rkn_pdetailapproval`
  MODIFY `idpdetailapproval` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `doto_rkn_pengiriman`
--
ALTER TABLE `doto_rkn_pengiriman`
  MODIFY `idpengiriman` int UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `doto_rkn_pesanan`
--
ALTER TABLE `doto_rkn_pesanan`
  MODIFY `idpesanan` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=148;

--
-- AUTO_INCREMENT for table `doto_rkn_pesanandetail`
--
ALTER TABLE `doto_rkn_pesanandetail`
  MODIFY `idpesanandetail` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=153;

--
-- AUTO_INCREMENT for table `doto_rkn_pesanannote`
--
ALTER TABLE `doto_rkn_pesanannote`
  MODIFY `idpesanannote` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `doto_rkn_pfakturapproval`
--
ALTER TABLE `doto_rkn_pfakturapproval`
  MODIFY `idpfakturapproval` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `doto_rkn_rekanan`
--
ALTER TABLE `doto_rkn_rekanan`
  MODIFY `idrekanan` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `doto_rkn_toko`
--
ALTER TABLE `doto_rkn_toko`
  MODIFY `idtoko` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

