-- MariaDB dump 10.19  Distrib 10.4.24-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: MAR
-- ------------------------------------------------------
-- Server version	10.4.24-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES ASCII */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `aturkolom`
--

DROP TABLE IF EXISTS `aturkolom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `aturkolom` (
  `kode` varchar(255) DEFAULT NULL,
  `tPenjualan` varchar(255) DEFAULT NULL,
  `dSuplier` varchar(255) DEFAULT NULL,
  `dPelanggan` varchar(255) DEFAULT NULL,
  `dSales` varchar(255) DEFAULT NULL,
  `dKaryawan` varchar(255) DEFAULT NULL,
  `tPembelian` varchar(255) DEFAULT NULL,
  `dBarang_req` varchar(255) DEFAULT NULL,
  `tHutang` varchar(255) DEFAULT NULL,
  `tCashflow` varchar(255) DEFAULT NULL,
  `tBiaya` varchar(255) DEFAULT NULL,
  `tPiutang` varchar(255) DEFAULT NULL,
  `tPenjualanPending_req` varchar(255) DEFAULT NULL,
  `tPembelianPending_req` varchar(255) DEFAULT NULL,
  `tStokOpname` varchar(255) DEFAULT NULL,
  `tPenjualan_req` varchar(255) DEFAULT NULL,
  `tPembelian_req` varchar(255) DEFAULT NULL,
  `tPenjualanDetail` varchar(255) DEFAULT NULL,
  `dBarang` varchar(255) DEFAULT NULL,
  `dBarang_req_penjualan` varchar(255) DEFAULT NULL,
  `dBarang_req_pembelian` varchar(255) DEFAULT NULL,
  `tPenjualan_req_Retur` varchar(255) DEFAULT NULL,
  `tPembelian_req_Retur` varchar(255) DEFAULT NULL,
  `dBarang_req_Stok` varchar(255) DEFAULT NULL,
  `tPembelianDetail` varchar(255) DEFAULT NULL,
  `tReturPenjualan` varchar(250) NOT NULL DEFAULT 'true',
  `dBarang_req_` varchar(250) NOT NULL DEFAULT 'true'
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `aturkolom`
--

LOCK TABLES `aturkolom` WRITE;
/*!40000 ALTER TABLE `aturkolom` DISABLE KEYS */;
INSERT INTO `aturkolom` VALUES ('aturKolom','true-true-true-true-true-true-false-true-false-true-true-false-false-false-true-false-false-true-true-','true-true-true-true-true-true-true-','true-true-true-true-true-true-true-','true-true-true-true-true-true-true-','true-true-true-true-true-true-true-','true-true-true-true-true-true-false-true-true-false-false-false-true-false-true-','true-true-false-true-false-true-false-true-true-true-true-true-','true-true-true-true-true-true-true-true-true-true-true-false-','true-true-true-true-true-true-true-true-true-','true-true-true-true-true-true-true-','true-true-true-true-true-true-true-true-true-true-true-false-','true-true-true-false-false-false-false-true-false-true-true-false-false-false-false-true-false-false-true-','true-true-true-false-false-false-false-true-true-false-false-false-false-false-true-','false-true-true-true-true-true-true-true-true-true-true-true-true-','true-true-true-true-false-false-false-true-false-true-true-false-false-false-false-false-false-false-true-','true-true-true-true-false-false-false-false-true-false-false-false-false-false-true-','true-true-true-true-true-true-true-false-true-true-true-false-true-','true-true-true-true-false-true-true-true-false-true-true-true-','','','true-true-true-true-true-true-false-true-false-false-true-false-false-false-false-false-false-false-true-','true-true-true-true-false-true-false-true-true-false-true-false-true-false-true-','true-true-true-true-true-true-true-true-true-true-true-true-','true-true-true-true-true-true-true-false-false-true-true-false-true-','true','true-true-true-true-true-true-true-true-true-true-true-true-');
/*!40000 ALTER TABLE `aturkolom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `autokode`
--

DROP TABLE IF EXISTS `autokode`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `autokode` (
  `id` varchar(255) DEFAULT NULL,
  `barang` varchar(255) DEFAULT NULL,
  `suplier` varchar(255) DEFAULT NULL,
  `pelanggan` varchar(255) DEFAULT NULL,
  `sales` varchar(255) DEFAULT NULL,
  `petunjuk` varchar(255) DEFAULT NULL,
  `karyawan` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL,
  `kategori` varchar(255) DEFAULT NULL,
  `retur_pembelian` varchar(255) DEFAULT NULL,
  `retur_penjualan` varchar(255) DEFAULT NULL,
  `stokOpname` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `autokode`
--

LOCK TABLES `autokode` WRITE;
/*!40000 ALTER TABLE `autokode` DISABLE KEYS */;
INSERT INTO `autokode` VALUES ('1','BRG0073','SPL0069','PLG0024','SLS0030','PTK0003','KRY0006','OPT0048','KTG0014','RTB0001','RTJ0001','STP0049');
/*!40000 ALTER TABLE `autokode` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `barcode`
--

DROP TABLE IF EXISTS `barcode`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `barcode` (
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `harga` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `barcode`
--

LOCK TABLES `barcode` WRITE;
/*!40000 ALTER TABLE `barcode` DISABLE KEYS */;
INSERT INTO `barcode` VALUES ('BRG004','Aqua Galon 4','16600'),('BRG005','Aqua Galon 5','17000.0'),('BRG006','Aqua Galon 6','17600.0'),('BRG008','Aqua Galon 8','18600.0'),('BRG009','Aqua Galon 9','19000.0');
/*!40000 ALTER TABLE `barcode` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `checkboxediting`
--

DROP TABLE IF EXISTS `checkboxediting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `checkboxediting` (
  `kategori` varchar(255) DEFAULT NULL,
  `mengubah_harga` varchar(255) DEFAULT NULL,
  `mengubah_tanggal` varchar(255) DEFAULT NULL,
  `memberikan_diskon` varchar(255) DEFAULT NULL,
  `update_harga` varchar(255) DEFAULT NULL,
  `harga_jual` varchar(255) DEFAULT NULL,
  `option_print` varchar(255) DEFAULT NULL,
  `pending_faktur` varchar(255) DEFAULT NULL,
  `form_PPN` varchar(255) DEFAULT NULL,
  `nilai_PPN` varchar(255) DEFAULT NULL,
  `diskon_faktur` varchar(255) DEFAULT NULL,
  `konfirmasi_obat` varchar(255) DEFAULT NULL,
  `form_ongkos` varchar(255) DEFAULT NULL,
  `harga_tertinggi` varchar(255) DEFAULT NULL,
  `pembulatan_harga` varchar(255) DEFAULT NULL,
  `angka_pembulatan` varchar(255) DEFAULT NULL,
  `harga_beli` varchar(255) DEFAULT NULL,
  `laba_otomatis` varchar(255) DEFAULT NULL,
  `harga_resep` varchar(255) DEFAULT NULL,
  `print_preview` varchar(255) DEFAULT NULL,
  `konfirmasi_beli` varchar(255) DEFAULT NULL,
  `input_tabel` varchar(255) DEFAULT NULL,
  `faktur_baru` varchar(255) DEFAULT NULL,
  `konfirmasi_barang` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `checkboxediting`
--

LOCK TABLES `checkboxediting` WRITE;
/*!40000 ALTER TABLE `checkboxediting` DISABLE KEYS */;
INSERT INTO `checkboxediting` VALUES ('pembelian','true','true','true','true','false','false','true','true','true','true','true','false','true','false','0','true','false','false','false','','true','false','false'),('penjualan','true','true','true','false','true','false','false','false','true','true','false','false','false','false','200','false','false','false','true','','false','false','false');
/*!40000 ALTER TABLE `checkboxediting` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `comboalasan`
--

DROP TABLE IF EXISTS `comboalasan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `comboalasan` (
  `nama` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `comboalasan`
--

LOCK TABLES `comboalasan` WRITE;
/*!40000 ALTER TABLE `comboalasan` DISABLE KEYS */;
INSERT INTO `comboalasan` VALUES ('Hilang'),('Rusak'),('Dipakai Sendiri');
/*!40000 ALTER TABLE `comboalasan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `comboexpired`
--

DROP TABLE IF EXISTS `comboexpired`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `comboexpired` (
  `nama` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `comboexpired`
--

LOCK TABLES `comboexpired` WRITE;
/*!40000 ALTER TABLE `comboexpired` DISABLE KEYS */;
INSERT INTO `comboexpired` VALUES ('Expired'),('Expired < 90 Hari'),('Expired < 60 Hari'),('Expired < 30 Hari'),('Expired < 7 Hari');
/*!40000 ALTER TABLE `comboexpired` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `combojeniskas`
--

DROP TABLE IF EXISTS `combojeniskas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `combojeniskas` (
  `nama` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `combojeniskas`
--

LOCK TABLES `combojeniskas` WRITE;
/*!40000 ALTER TABLE `combojeniskas` DISABLE KEYS */;
INSERT INTO `combojeniskas` VALUES ('Pemasukan'),('Pengeluaran');
/*!40000 ALTER TABLE `combojeniskas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `combokategori`
--

DROP TABLE IF EXISTS `combokategori`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `combokategori` (
  `nama` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `combokategori`
--

LOCK TABLES `combokategori` WRITE;
/*!40000 ALTER TABLE `combokategori` DISABLE KEYS */;
INSERT INTO `combokategori` VALUES ('Contoh'),('Minuman'),('Bmin'),('KS'),('Min'),('EL'),('BM'),('SM'),('O'),('R'),('DET'),('AN'),('W'),('M'),('SW'),('Pm'),('RR'),('RM'),('PL'),('P'),('MIG'),('BK'),('Bin'),('CB'),('My'),('RK'),('HAR'),('RG'),('PP'),('CP'),('MB'),('AC'),('G'),('MIS'),('T'),('RW'),('AD'),('UMUM');
/*!40000 ALTER TABLE `combokategori` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `combokategoripemasukan`
--

DROP TABLE IF EXISTS `combokategoripemasukan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `combokategoripemasukan` (
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `combokategoripemasukan`
--

LOCK TABLES `combokategoripemasukan` WRITE;
/*!40000 ALTER TABLE `combokategoripemasukan` DISABLE KEYS */;
INSERT INTO `combokategoripemasukan` VALUES ('KTG0014','Penjualan');
/*!40000 ALTER TABLE `combokategoripemasukan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `combokategoripengeluaran`
--

DROP TABLE IF EXISTS `combokategoripengeluaran`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `combokategoripengeluaran` (
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `combokategoripengeluaran`
--

LOCK TABLES `combokategoripengeluaran` WRITE;
/*!40000 ALTER TABLE `combokategoripengeluaran` DISABLE KEYS */;
INSERT INTO `combokategoripengeluaran` VALUES ('KTG0013','Pembelian');
/*!40000 ALTER TABLE `combokategoripengeluaran` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `combosatuan`
--

DROP TABLE IF EXISTS `combosatuan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `combosatuan` (
  `nama` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `combosatuan`
--

LOCK TABLES `combosatuan` WRITE;
/*!40000 ALTER TABLE `combosatuan` DISABLE KEYS */;
INSERT INTO `combosatuan` VALUES ('Dus'),('Botol'),('Strip'),('PCS'),('Vial'),('Tubes'),('Ampul'),('Capsul'),('Box'),('Pak'),('Rnc'),('Btl'),('Krt'),('Slp'),('Tub'),('Tbg'),('Klg'),('Bg'),('Pch'),('Sak'),('Pk'),('Lbr'),('Ktk'),('Bx'),('Kg'),('Sch'),('Cup');
/*!40000 ALTER TABLE `combosatuan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `combostatus`
--

DROP TABLE IF EXISTS `combostatus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `combostatus` (
  `nama` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `combostatus`
--

LOCK TABLES `combostatus` WRITE;
/*!40000 ALTER TABLE `combostatus` DISABLE KEYS */;
INSERT INTO `combostatus` VALUES ('Lunas'),('Belum Lunas');
/*!40000 ALTER TABLE `combostatus` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `combostok`
--

DROP TABLE IF EXISTS `combostok`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `combostok` (
  `nama` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `combostok`
--

LOCK TABLES `combostok` WRITE;
/*!40000 ALTER TABLE `combostok` DISABLE KEYS */;
INSERT INTO `combostok` VALUES ('Stok < stok_min'),('Stok = 0'),('Stok < 10'),('Stok < 30'),('Stok < 50'),('Stok > 50');
/*!40000 ALTER TABLE `combostok` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `combotunaikredit`
--

DROP TABLE IF EXISTS `combotunaikredit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `combotunaikredit` (
  `nama` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `combotunaikredit`
--

LOCK TABLES `combotunaikredit` WRITE;
/*!40000 ALTER TABLE `combotunaikredit` DISABLE KEYS */;
INSERT INTO `combotunaikredit` VALUES ('Tunai'),('Kredit'),('Debit'),('Transfer');
/*!40000 ALTER TABLE `combotunaikredit` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `comboukurancetak`
--

DROP TABLE IF EXISTS `comboukurancetak`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `comboukurancetak` (
  `nama` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `comboukurancetak`
--

LOCK TABLES `comboukurancetak` WRITE;
/*!40000 ALTER TABLE `comboukurancetak` DISABLE KEYS */;
INSERT INTO `comboukurancetak` VALUES ('Kecil (58mm)'),('Kecil (65mm)'),('Sedang (80mm)'),('Besar (180mm)');
/*!40000 ALTER TABLE `comboukurancetak` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dbarang`
--

DROP TABLE IF EXISTS `dbarang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `dbarang` (
  `kode` varchar(255) NOT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `kategori` varchar(255) DEFAULT NULL,
  `stok` varchar(255) DEFAULT NULL,
  `stok_min` varchar(255) DEFAULT NULL,
  `satuan` varchar(255) DEFAULT NULL,
  `harga_beli` varchar(255) DEFAULT NULL,
  `harga_jual` varchar(255) DEFAULT NULL,
  `diskon` varchar(255) DEFAULT NULL,
  `suplier` varchar(255) DEFAULT NULL,
  `lokasi` varchar(255) DEFAULT NULL,
  `expired` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`kode`),
  KEY `kode` (`kode`,`nama`)
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dbarang`
--

LOCK TABLES `dbarang` WRITE;
/*!40000 ALTER TABLE `dbarang` DISABLE KEYS */;
INSERT INTO `dbarang` VALUES ('BRG020','MKOVR PERFC COVER TWC 01 02 03 04','UMUM','2','0','PCS','127500','153000','-','-','-','-'),('BRG021','MKOVR MATTE PWDR FOUNDT POWERSTAY','UMUM','3','0','PCS','152500','183000','-','-','-','-'),('BRG022','MKOVR PERPEC CVR REFF TWC','UMUM','3','0','PCS','84500','101400','0','','','2023-10-15'),('BRG023','MKOVR SILKY SMOOTH TRANS PWD','UMUM','3','0','PCS','98000','117600','-','-','-','-'),('BRG024','MKOVR E/LINER PENCIL CPR','UMUM','1','0','PCS','68000','81600','-','-','-','-'),('BRG025','MKOVR LIP CREAM MATTE','UMUM','5','6','PCS','85000','102000','0','','','-'),('BRG026','MKOVR BO SINGLE 01 02 03 05 08 07','UMUM','1','0','PCS','72500','87000','-','-','-','-'),('BRG027','HSP MYLEA STAY 450','UMUM','0','0','PCS','72500','87000','-','-','-','-'),('BRG028','HSP MYLEA 200','UMUM','0','0','PCS','46000','55200','-','-','-','-'),('BRG029','PIS A FLAMINGO ISI 3','UMUM','2','0','PCS','52500','63000','-','-','-','-');
/*!40000 ALTER TABLE `dbarang` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dkaryawan`
--

DROP TABLE IF EXISTS `dkaryawan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `dkaryawan` (
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `alamat` varchar(255) DEFAULT NULL,
  `no_hp` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `rekening` varchar(255) DEFAULT NULL,
  `keterangan` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dkaryawan`
--

LOCK TABLES `dkaryawan` WRITE;
/*!40000 ALTER TABLE `dkaryawan` DISABLE KEYS */;
/*!40000 ALTER TABLE `dkaryawan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dminimar`
--

DROP TABLE IF EXISTS `dminimar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `dminimar` (
  `kode` text  DEFAULT NULL,
  `nama_apotek` text  DEFAULT NULL,
  `nohp` text  DEFAULT NULL,
  `alamat` text  DEFAULT NULL,
  `header_nota` text  DEFAULT NULL,
  `footer_nota` text  DEFAULT NULL,
  `kode_operator` text  DEFAULT NULL,
  `lokasi_database` text  DEFAULT NULL,
  `logo` text  DEFAULT NULL,
  `logoNota` text  DEFAULT NULL,
  `logoAplikasi` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dminimar`
--

LOCK TABLES `dminimar` WRITE;
/*!40000 ALTER TABLE `dminimar` DISABLE KEYS */;
INSERT INTO `dminimar` VALUES ('minimar','Nama Toko Anda','081359395206','Jln. Alamat Surabaya','Nama Minimarket\n081359395206\nJln. Alamat Surabaya','Terimaskasih telah berbelanja \ndi Nama Minimarket \nBarang yang sudah dibeli \ntidak dapat di tukar/kembalikan','Master','null','logo.png','true','true');
/*!40000 ALTER TABLE `dminimar` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `doperator`
--

DROP TABLE IF EXISTS `doperator`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `doperator` (
  `kode` text DEFAULT NULL,
  `username` text DEFAULT NULL,
  `password` text DEFAULT NULL,
  `atur_kolom` text DEFAULT NULL,
  `printSizeName` text DEFAULT NULL,
  `export_penjualan` varchar(5) DEFAULT NULL,
  `hapus_pembelian` varchar(5) DEFAULT NULL,
  `detail_cashflow` varchar(5) DEFAULT NULL,
  `persediaan` varchar(5) DEFAULT NULL,
  `tambah_biaya` varchar(5) DEFAULT NULL,
  `edit_pelanggan` varchar(5) DEFAULT NULL,
  `edit_barang` varchar(5) DEFAULT NULL,
  `penjualan` varchar(5) DEFAULT NULL,
  `hapus_suplier` varchar(5) DEFAULT NULL,
  `hapus_hutang` varchar(5) DEFAULT NULL,
  `hapus_biaya` varchar(5) DEFAULT NULL,
  `edit_suplier` text DEFAULT NULL,
  `jendela_barang` text DEFAULT NULL,
  `export_sales` text DEFAULT NULL,
  `pembelian` text DEFAULT NULL,
  `operator` text DEFAULT NULL,
  `piutang` text DEFAULT NULL,
  `pengaturan` text DEFAULT NULL,
  `hapus_penjualan` text DEFAULT NULL,
  `hapus_karyawan` text DEFAULT NULL,
  `detail_retur_pembelian` text DEFAULT NULL,
  `edit_sales` text DEFAULT NULL,
  `cashflow` text DEFAULT NULL,
  `detail_biaya` text DEFAULT NULL,
  `tambah_suplier` text DEFAULT NULL,
  `hapus_pelanggan` text DEFAULT NULL,
  `aktivasi` text DEFAULT NULL,
  `barcode` text DEFAULT NULL,
  `jendela_pelanggan` text DEFAULT NULL,
  `apotek` text DEFAULT NULL,
  `tambah_sales` text DEFAULT NULL,
  `jendela_cashflow` text DEFAULT NULL,
  `retur_penjualan` text DEFAULT NULL,
  `export_suplier` text DEFAULT NULL,
  `tambah_hutang` text DEFAULT NULL,
  `cetak_penjualan` text DEFAULT NULL,
  `tambah_retur_pembelian` text DEFAULT NULL,
  `export_pelanggan` text DEFAULT NULL,
  `detail_penjualan` text DEFAULT NULL,
  `export_hutang` text DEFAULT NULL,
  `import_sales` text DEFAULT NULL,
  `hapus_cashflow` text DEFAULT NULL,
  `jendela_sales` text DEFAULT NULL,
  `jendela_biaya` text DEFAULT NULL,
  `export_karyawan` text DEFAULT NULL,
  `import_pelanggan` text DEFAULT NULL,
  `tambah_barang` text DEFAULT NULL,
  `hapus_retur_pembelian` text DEFAULT NULL,
  `hapus_piutang` text DEFAULT NULL,
  `tambah_piutang` text DEFAULT NULL,
  `jendela_karyawan` text DEFAULT NULL,
  `jendela_piutang` text DEFAULT NULL,
  `import_barang` text DEFAULT NULL,
  `detail_pembelian` text DEFAULT NULL,
  `jendela_hutang` text DEFAULT NULL,
  `tambah_pelanggan` text DEFAULT NULL,
  `cetak_stok_opname` text DEFAULT NULL,
  `export_barang` text DEFAULT NULL,
  `import_suplier` text DEFAULT NULL,
  `bayar_hutang` text DEFAULT NULL,
  `tambah_retur_penjualan` text DEFAULT NULL,
  `updates` text DEFAULT NULL,
  `jendela_penjualan` text DEFAULT NULL,
  `tambah_karyawan` text DEFAULT NULL,
  `export_cashflow` text DEFAULT NULL,
  `cetak_piutang` text DEFAULT NULL,
  `cetak_biaya` text DEFAULT NULL,
  `export_biaya` text DEFAULT NULL,
  `hapus_stok_opname` text DEFAULT NULL,
  `export_stok_opname` text DEFAULT NULL,
  `export_piutang` text DEFAULT NULL,
  `cetak_hutang` text DEFAULT NULL,
  `edit_karyawan` text DEFAULT NULL,
  `hapus_retur_penjualan` text DEFAULT NULL,
  `import_karyawan` text DEFAULT NULL,
  `tambah_stok_opname` text DEFAULT NULL,
  `detail_retur_penjualan` text DEFAULT NULL,
  `hapus_sales` text DEFAULT NULL,
  `tambah_penjualan` text DEFAULT NULL,
  `cetak_cashflow` text DEFAULT NULL,
  `hapus_barang` text DEFAULT NULL,
  `jendela_pembelian` text DEFAULT NULL,
  `stok_opname` text DEFAULT NULL,
  `tambah_cashflow` text DEFAULT NULL,
  `detail_stok_opname` text DEFAULT NULL,
  `retur_pembelian` text DEFAULT NULL,
  `hutang` text DEFAULT NULL,
  `cetak_pembelian` text DEFAULT NULL,
  `laporan` text DEFAULT NULL,
  `editing` text DEFAULT NULL,
  `jendela_suplier` text DEFAULT NULL,
  `bayar_piutang` text DEFAULT NULL,
  `tambah_pembelian` text DEFAULT NULL,
  `export_pembelian` text DEFAULT NULL,
  `minimar` text DEFAULT NULL,
  `about` text DEFAULT NULL,
  `import_stok_opname` text DEFAULT NULL,
  `export_pembelian_detail` text DEFAULT NULL,
  `export_penjualan_detail` text DEFAULT NULL,
  `keuangan` text DEFAULT NULL,
  `aplikasi` text DEFAULT NULL,
  `barang` varchar(250) NOT NULL DEFAULT 'true',
  `printer` varchar(250) NOT NULL DEFAULT 'true',
  `display_harga` varchar(250) NOT NULL DEFAULT 'true'
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `doperator`
--

LOCK TABLES `doperator` WRITE;
/*!40000 ALTER TABLE `doperator` DISABLE KEYS */;
INSERT INTO `doperator` VALUES ('Master','Master','Master','true','Kecil (58mm) 2','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true','true'),('OPT0029','Contoh OP 2','123456','false','','true','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','true','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','true','false','false','true','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','true','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','false','true','true','true','true','true','true','true','true','true');
/*!40000 ALTER TABLE `doperator` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dpelanggan`
--

DROP TABLE IF EXISTS `dpelanggan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `dpelanggan` (
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `alamat` varchar(255) DEFAULT NULL,
  `no_hp` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `rekening` varchar(255) DEFAULT NULL,
  `keterangan` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dpelanggan`
--

LOCK TABLES `dpelanggan` WRITE;
/*!40000 ALTER TABLE `dpelanggan` DISABLE KEYS */;
INSERT INTO `dpelanggan` VALUES ('PLG0023','Pelanggan 1','','','','',''),('PLG0024','Pelanggan 2','','','','','');
/*!40000 ALTER TABLE `dpelanggan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dpetunjuk`
--

DROP TABLE IF EXISTS `dpetunjuk`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `dpetunjuk` (
  `kode` varchar(255) DEFAULT NULL,
  `petunjuk` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dpetunjuk`
--

LOCK TABLES `dpetunjuk` WRITE;
/*!40000 ALTER TABLE `dpetunjuk` DISABLE KEYS */;
/*!40000 ALTER TABLE `dpetunjuk` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dsales`
--

DROP TABLE IF EXISTS `dsales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `dsales` (
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `alamat` varchar(255) DEFAULT NULL,
  `no_Hp` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `rekening` varchar(255) DEFAULT NULL,
  `keterangan` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dsales`
--

LOCK TABLES `dsales` WRITE;
/*!40000 ALTER TABLE `dsales` DISABLE KEYS */;
/*!40000 ALTER TABLE `dsales` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dsuplier`
--

DROP TABLE IF EXISTS `dsuplier`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `dsuplier` (
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `alamat` varchar(255) DEFAULT NULL,
  `no_Hp` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `rekening` varchar(255) DEFAULT NULL,
  `keterangan` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dsuplier`
--

LOCK TABLES `dsuplier` WRITE;
/*!40000 ALTER TABLE `dsuplier` DISABLE KEYS */;
INSERT INTO `dsuplier` VALUES ('SPL0064','Suplier 1','Kediri','08100000000','Suplier@gmail.com','',''),('SPL0066','Suplier 2','','','','','');
/*!40000 ALTER TABLE `dsuplier` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `filtertanggal`
--

DROP TABLE IF EXISTS `filtertanggal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `filtertanggal` (
  `tanggal` varchar(255) DEFAULT NULL,
  `pembelian` varchar(255) DEFAULT NULL,
  `penjualan` varchar(255) DEFAULT NULL,
  `hutang` varchar(255) DEFAULT NULL,
  `piutang` varchar(255) DEFAULT NULL,
  `biaya` varchar(255) DEFAULT NULL,
  `cashflow` varchar(255) DEFAULT NULL,
  `returpembelian` varchar(255) DEFAULT NULL,
  `returpenjualan` varchar(255) DEFAULT NULL,
  `stokopname` varchar(255) DEFAULT NULL,
  `pembelianDetail` varchar(255) DEFAULT NULL,
  `penjualanDetail` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `filtertanggal`
--

LOCK TABLES `filtertanggal` WRITE;
/*!40000 ALTER TABLE `filtertanggal` DISABLE KEYS */;
INSERT INTO `filtertanggal` VALUES ('awal','2019-08-01','2019-12-01','2019-11-01','2019-12-09','2019-12-01','2019-10-01','2019-12-07','2019-12-07','2019-11-01','2019-12-27','2019-12-27'),('akhir','2024-05-24','2024-10-31','2024-03-01','2024-06-30','2024-01-31','2024-05-31','2020-03-31','2022-05-24','2024-05-02','2022-03-01','2022-02-06');
/*!40000 ALTER TABLE `filtertanggal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `keluarmasuk`
--

DROP TABLE IF EXISTS `keluarmasuk`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `keluarmasuk` (
  `faktur` varchar(255) DEFAULT NULL,
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `masuk` varchar(255) DEFAULT NULL,
  `keluar` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `sisa` varchar(255) DEFAULT NULL,
  `keterangan` varchar(255) DEFAULT NULL,
  KEY `faktur` (`faktur`,`kode`)
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `keluarmasuk`
--

LOCK TABLES `keluarmasuk` WRITE;
/*!40000 ALTER TABLE `keluarmasuk` DISABLE KEYS */;
INSERT INTO `keluarmasuk` VALUES ('PJL010121-105318','BRG020','MKOVR PERFC COVER TWC 01 02 03 04','0','1','Keluar','2',''),('PJL010121-105318','BRG024','MKOVR E/LINER PENCIL CPR','0','1','Keluar','2',''),('PJL010121-105318','BRG026','MKOVR BO SINGLE 01 02 03 05 08 07','0','2','Keluar','2',''),('PJL010121-105337','BRG027','HSP MYLEA STAY 450','0','1','Keluar','0',''),('PJL010121-105337','BRG024','MKOVR E/LINER PENCIL CPR','0','1','Keluar','1',''),('PJL010121-105337','BRG028','HSP MYLEA 200','0','1','Keluar','0',''),('PJL010121-105337','BRG026','MKOVR BO SINGLE 01 02 03 05 08 07','0','1','Keluar','1',''),('PBL010121-105608','BRG021','MKOVR MATTE PWDR FOUNDT POWERSTAY','1','0','Masuk','3','');
/*!40000 ALTER TABLE `keluarmasuk` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `perubahanharga`
--

DROP TABLE IF EXISTS `perubahanharga`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `perubahanharga` (
  `Faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `Kode` varchar(255) DEFAULT NULL,
  `Waktu` varchar(255) DEFAULT NULL,
  `Nama` varchar(255) DEFAULT NULL,
  `naik_turun` varchar(255) DEFAULT NULL,
  `harga_beli_lama` varchar(255) DEFAULT NULL,
  `harga_beli_baru` varchar(255) DEFAULT NULL,
  `harga_jual_lama` varchar(255) DEFAULT NULL,
  `harga_jual_baru` varchar(255) DEFAULT NULL,
  `Operator` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `perubahanharga`
--

LOCK TABLES `perubahanharga` WRITE;
/*!40000 ALTER TABLE `perubahanharga` DISABLE KEYS */;
/*!40000 ALTER TABLE `perubahanharga` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbiaya`
--

DROP TABLE IF EXISTS `tbiaya`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `tbiaya` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `waktu` varchar(255) DEFAULT NULL,
  `kategori` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `keterangan` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbiaya`
--

LOCK TABLES `tbiaya` WRITE;
/*!40000 ALTER TABLE `tbiaya` DISABLE KEYS */;
/*!40000 ALTER TABLE `tbiaya` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tcashflow`
--

DROP TABLE IF EXISTS `tcashflow`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `tcashflow` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `waktu` varchar(255) DEFAULT NULL,
  `jenis` varchar(255) DEFAULT NULL,
  `kategori` varchar(255) DEFAULT NULL,
  `pemasukan` varchar(255) DEFAULT NULL,
  `pengeluaran` varchar(255) DEFAULT NULL,
  `keterangan` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tcashflow`
--

LOCK TABLES `tcashflow` WRITE;
/*!40000 ALTER TABLE `tcashflow` DISABLE KEYS */;
INSERT INTO `tcashflow` VALUES ('PJL010121-105318','2021-01-01','10:53','Pemasukan','Penjualan','408600','0','Penjualan: PJL010121-105318','Master'),('PJL010121-105337','2021-01-01','10:54','Pemasukan','Penjualan','310800','0','Penjualan: PJL010121-105337','Master'),('PBL010121-105608','2021-01-01','10:56','Pengeluaran','Pembelian','0','152500','Pembelian: PBL010121-105608','Master');
/*!40000 ALTER TABLE `tcashflow` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `thutang`
--

DROP TABLE IF EXISTS `thutang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `thutang` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `waktu` varchar(255) DEFAULT NULL,
  `tempo` varchar(255) DEFAULT NULL,
  `jatuh_tempo` varchar(255) DEFAULT NULL,
  `suplier` varchar(255) DEFAULT NULL,
  `tagihan_awal` varchar(255) DEFAULT NULL,
  `telah_dibayar` varchar(255) DEFAULT NULL,
  `sisa` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `keterangan` varchar(255) DEFAULT NULL,
  KEY `faktur` (`faktur`)
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `thutang`
--

LOCK TABLES `thutang` WRITE;
/*!40000 ALTER TABLE `thutang` DISABLE KEYS */;
/*!40000 ALTER TABLE `thutang` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tpembelian`
--

DROP TABLE IF EXISTS `tpembelian`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `tpembelian` (
  `faktur` varchar(255) NOT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `waktu` varchar(255) DEFAULT NULL,
  `tunai_kredit` varchar(255) DEFAULT NULL,
  `nhari` varchar(255) DEFAULT NULL,
  `jatuh_tempo` varchar(255) DEFAULT NULL,
  `kode_suplier` varchar(255) DEFAULT NULL,
  `suplier` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `dikson_persen` varchar(255) DEFAULT NULL,
  `diskon` varchar(255) DEFAULT NULL,
  `ppn` varchar(255) DEFAULT NULL,
  `bayar` varchar(255) DEFAULT NULL,
  `kembali` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`faktur`)
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tpembelian`
--

LOCK TABLES `tpembelian` WRITE;
/*!40000 ALTER TABLE `tpembelian` DISABLE KEYS */;
INSERT INTO `tpembelian` VALUES ('PBL010121-105608','2021-01-01','10:56:14','Tunai','-','2021-01-01','-','-','152500','0','0','0','160000','7500','Master');
/*!40000 ALTER TABLE `tpembelian` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tpembeliandetail`
--

DROP TABLE IF EXISTS `tpembeliandetail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `tpembeliandetail` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `jumlah` varchar(255) DEFAULT NULL,
  `satuan` varchar(255) DEFAULT NULL,
  `harga` varchar(255) DEFAULT NULL,
  `diskon_persen` varchar(255) DEFAULT NULL,
  `diskon` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `harga_jual` varchar(255) DEFAULT NULL,
  `harga_beli_lama` varchar(255) DEFAULT NULL,
  `expired` varchar(255) DEFAULT NULL,
  KEY `faktur` (`faktur`,`kode`)
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tpembeliandetail`
--

LOCK TABLES `tpembeliandetail` WRITE;
/*!40000 ALTER TABLE `tpembeliandetail` DISABLE KEYS */;
INSERT INTO `tpembeliandetail` VALUES ('PBL010121-105608','2021-01-01','BRG021','MKOVR MATTE PWDR FOUNDT POWERSTAY','1','PCS','152500','0','0','152500','183000','1525000','-');
/*!40000 ALTER TABLE `tpembeliandetail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tpembelianpending`
--

DROP TABLE IF EXISTS `tpembelianpending`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `tpembelianpending` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `waktu` varchar(255) DEFAULT NULL,
  `tunai_kredit` varchar(255) DEFAULT NULL,
  `nhari` varchar(255) DEFAULT NULL,
  `jatuh_tempo` varchar(255) DEFAULT NULL,
  `kode_suplier` varchar(255) DEFAULT NULL,
  `suplier` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `dikson_persen` varchar(255) DEFAULT NULL,
  `diskon` varchar(255) DEFAULT NULL,
  `ppn` varchar(255) DEFAULT NULL,
  `bayar` varchar(255) DEFAULT NULL,
  `kembali` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tpembelianpending`
--

LOCK TABLES `tpembelianpending` WRITE;
/*!40000 ALTER TABLE `tpembelianpending` DISABLE KEYS */;
INSERT INTO `tpembelianpending` VALUES ('PBL030520-105212','2020-05-03','10:53:14','Tunai','-','2020-05-03','-','-','187500','0','0','0','0','0','Master'),('PBL030520-105346','2020-05-03','10:53:54','Tunai','-','2020-05-03','-','-','12500','0','0','0','0','0','Master'),('PBL030520-110049','2020-05-03','11:01:51','Tunai','-','2020-05-03','-','-','422000','0','0','0','0','0','Master'),('PBL030520-110347','2020-05-03','11:04:41','Tunai','-','2020-05-03','-','-','25000','0','0','0','0','0','Master'),('PBL030520-111026','2020-05-03','11:11:16','Tunai','-','2020-05-03','-','-','99750','0','0','0','0','0','Master');
/*!40000 ALTER TABLE `tpembelianpending` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tpembelianpendingdetail`
--

DROP TABLE IF EXISTS `tpembelianpendingdetail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `tpembelianpendingdetail` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `jumlah` varchar(255) DEFAULT NULL,
  `satuan` varchar(255) DEFAULT NULL,
  `harga_lama` varchar(255) DEFAULT NULL,
  `harga_beli` varchar(255) DEFAULT NULL,
  `diskon_persen` varchar(255) DEFAULT NULL,
  `diskon` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `harga_jual` varchar(255) DEFAULT NULL,
  `expired` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tpembelianpendingdetail`
--

LOCK TABLES `tpembelianpendingdetail` WRITE;
/*!40000 ALTER TABLE `tpembelianpendingdetail` DISABLE KEYS */;
INSERT INTO `tpembelianpendingdetail` VALUES ('PBL120220-083107','2020-02-12','BRG001','Aqua Galon 1','1','PCS','12500','0','0','12500','15000','12500','-'),('PBL120220-083107','2020-02-12','BRG001','Aqua Galon 1','1','PCS','12500','0','0','12500','15000','12500','-'),('PBL030520-105212','2020-05-03','BRG001','Aqua Galon 1','1.5','PCS','12500','0','0','187500','15000','125000','-'),('PBL030520-105212','2020-05-03','BRG001','Aqua Galon 1','1.5','PCS','12500','0','0','187500','15000','125000','-'),('PBL030520-105346','2020-05-03','BRG001','Aqua Galon 1','1','PCS','12500','0','0','12500','15000','125000','-'),('PBL030520-105346','2020-05-03','BRG001','Aqua Galon 1','1','PCS','12500','0','0','12500','15000','125000','-'),('PBL030520-110049','2020-05-03','BRG001','Aqua Galon 1','1','PCS','12500','0','0','12500','15000','125000',''),('PBL030520-110049','2020-05-03','BRG002','Aqua Galon 2','1.5','PCS','13000','0','1','195000','15500','130000',''),('PBL030520-110049','2020-05-03','BRG001','Aqua Galon 1','1.5','PCS','12500','0','0','187500','12500','125000',''),('PBL030520-110049','2020-05-03','BRG003','Aqua Galon 3','1','PCS','13500','0','2','13500','16000','135000','-'),('PBL030520-110049','2020-05-03','BRG003','Aqua Galon 3','1','PCS','13500','0','2','13500','16000','135000','-'),('PBL030520-110347','2020-05-03','BRG001','Aqua Galon 1','1','PCS','12500','0','0','12500','12500','125000',''),('PBL030520-110347','2020-05-03','BRG001','Aqua Galon 1','1','PCS','12500','0','0','12500','12500','125000',''),('PBL030520-111026','2020-05-03','BRG001','Aqua Galon 1','1','PCS','12500','0','0','12500','12500','125000',''),('PBL030520-111026','2020-05-03','BRG001','Aqua Galon 1','1','PCS','12500','0','0','12500','12500','125000',''),('PBL030520-111026','2020-05-03','BRG001','Aqua Galon 1','1','PCS','12500','20','250','12250','12500','125000',''),('PBL030520-111026','2020-05-03','BRG001','Aqua Galon 1','5','PCS','12500','0','0','62500','12500','125000','');
/*!40000 ALTER TABLE `tpembelianpendingdetail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tpenjualan`
--

DROP TABLE IF EXISTS `tpenjualan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `tpenjualan` (
  `faktur` varchar(255) NOT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `waktu` varchar(255) DEFAULT NULL,
  `tunai_kredit` varchar(255) DEFAULT NULL,
  `nhari` varchar(255) DEFAULT NULL,
  `jatuh_tempo` varchar(255) DEFAULT NULL,
  `kode_pelanggan` varchar(255) DEFAULT NULL,
  `pelanggan` varchar(255) DEFAULT NULL,
  `kode_sales` varchar(255) DEFAULT NULL,
  `sales` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `dikson_persen` varchar(255) DEFAULT NULL,
  `diskon` varchar(255) DEFAULT NULL,
  `ppn` varchar(255) DEFAULT NULL,
  `bayar` varchar(255) DEFAULT NULL,
  `kembali` varchar(255) DEFAULT NULL,
  `total_harga_beli` varchar(255) DEFAULT NULL,
  `total_laba` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`faktur`)
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tpenjualan`
--

LOCK TABLES `tpenjualan` WRITE;
/*!40000 ALTER TABLE `tpenjualan` DISABLE KEYS */;
INSERT INTO `tpenjualan` VALUES ('PJL010121-105318','2021-01-01','10:53:32','Tunai','-','2021-01-01','-','-','-','-','408600','0','0','0','500000','91400','340500','68100','Master'),('PJL010121-105337','2021-01-01','10:54:01','Tunai','-','2021-01-01','-','-','-','-','310800','0','0','0','350000','39200','259000','51800','Master');
/*!40000 ALTER TABLE `tpenjualan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tpenjualandetail`
--

DROP TABLE IF EXISTS `tpenjualandetail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `tpenjualandetail` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `jumlah` varchar(255) DEFAULT NULL,
  `satuan` varchar(255) DEFAULT NULL,
  `harga` varchar(255) DEFAULT NULL,
  `diskon_persen` varchar(255) DEFAULT NULL,
  `diskon` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `harga_beli` varchar(255) DEFAULT NULL,
  `harga_jual_lama` varchar(255) DEFAULT NULL,
  `laba` varchar(255) DEFAULT NULL,
  KEY `faktur` (`faktur`,`kode`)
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tpenjualandetail`
--

LOCK TABLES `tpenjualandetail` WRITE;
/*!40000 ALTER TABLE `tpenjualandetail` DISABLE KEYS */;
INSERT INTO `tpenjualandetail` VALUES ('PJL010121-105318','2021-01-01','BRG020','MKOVR PERFC COVER TWC 01 02 03 04','1','PCS','153000','0','0','153000','127500','153000','25500'),('PJL010121-105318','2021-01-01','BRG024','MKOVR E/LINER PENCIL CPR','1','PCS','81600','0','0','81600','68000','81600','13600'),('PJL010121-105318','2021-01-01','BRG026','MKOVR BO SINGLE 01 02 03 05 08 07','2','PCS','87000','0','0','174000','145000','87000','29000'),('PJL010121-105337','2021-01-01','BRG027','HSP MYLEA STAY 450','1','PCS','87000','0','0','87000','72500','87000','14500'),('PJL010121-105337','2021-01-01','BRG024','MKOVR E/LINER PENCIL CPR','1','PCS','81600','0','0','81600','68000','81600','13600'),('PJL010121-105337','2021-01-01','BRG028','HSP MYLEA 200','1','PCS','55200','0','0','55200','46000','55200','9200'),('PJL010121-105337','2021-01-01','BRG026','MKOVR BO SINGLE 01 02 03 05 08 07','1','PCS','87000','0','0','87000','72500','87000','14500');
/*!40000 ALTER TABLE `tpenjualandetail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tpenjualanpending`
--

DROP TABLE IF EXISTS `tpenjualanpending`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `tpenjualanpending` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `waktu` varchar(255) DEFAULT NULL,
  `tunai_kredit` varchar(255) DEFAULT NULL,
  `nhari` varchar(255) DEFAULT NULL,
  `jatuh_tempo` varchar(255) DEFAULT NULL,
  `kode_pelanggan` varchar(255) DEFAULT NULL,
  `pelanggan` varchar(255) DEFAULT NULL,
  `kode_sales` varchar(255) DEFAULT NULL,
  `sales` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `dikson_persen` varchar(255) DEFAULT NULL,
  `diskon` varchar(255) DEFAULT NULL,
  `ppn` varchar(255) DEFAULT NULL,
  `bayar` varchar(255) DEFAULT NULL,
  `kembali` varchar(255) DEFAULT NULL,
  `total_harga_beli` varchar(255) DEFAULT NULL,
  `total_laba` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tpenjualanpending`
--

LOCK TABLES `tpenjualanpending` WRITE;
/*!40000 ALTER TABLE `tpenjualanpending` DISABLE KEYS */;
/*!40000 ALTER TABLE `tpenjualanpending` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tpenjualanpendingdetail`
--

DROP TABLE IF EXISTS `tpenjualanpendingdetail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `tpenjualanpendingdetail` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `jumlah` varchar(255) DEFAULT NULL,
  `satuan` varchar(255) DEFAULT NULL,
  `harga` varchar(255) DEFAULT NULL,
  `diskon_persen` varchar(255) DEFAULT NULL,
  `diskon` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `harga_beli` varchar(255) DEFAULT NULL,
  `harga_jual_lama` varchar(255) DEFAULT NULL,
  `laba` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tpenjualanpendingdetail`
--

LOCK TABLES `tpenjualanpendingdetail` WRITE;
/*!40000 ALTER TABLE `tpenjualanpendingdetail` DISABLE KEYS */;
/*!40000 ALTER TABLE `tpenjualanpendingdetail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tpiutang`
--

DROP TABLE IF EXISTS `tpiutang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `tpiutang` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `waktu` varchar(255) DEFAULT NULL,
  `tempo` varchar(255) DEFAULT NULL,
  `jatuh_tempo` varchar(255) DEFAULT NULL,
  `pelanggan` varchar(255) DEFAULT NULL,
  `tagihan_awal` varchar(255) DEFAULT NULL,
  `telah_dibayar` varchar(255) DEFAULT NULL,
  `sisa` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `keterangan` varchar(255) DEFAULT NULL,
  KEY `faktur` (`faktur`)
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tpiutang`
--

LOCK TABLES `tpiutang` WRITE;
/*!40000 ALTER TABLE `tpiutang` DISABLE KEYS */;
/*!40000 ALTER TABLE `tpiutang` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `treturpembelian`
--

DROP TABLE IF EXISTS `treturpembelian`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `treturpembelian` (
  `no_retur` varchar(255) DEFAULT NULL,
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `waktu` varchar(255) DEFAULT NULL,
  `suplier` varchar(255) DEFAULT NULL,
  `total_retur` varchar(255) DEFAULT NULL,
  `total_dibayar` varchar(255) DEFAULT NULL,
  `total_mengurangi_hutang` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `treturpembelian`
--

LOCK TABLES `treturpembelian` WRITE;
/*!40000 ALTER TABLE `treturpembelian` DISABLE KEYS */;
INSERT INTO `treturpembelian` VALUES ('PBL240520-010428','PBL240520-010412','2020-05-24','01:04:29','-','12500','0','0','Master'),('PBL240520-010606','PBL240520-010412','2020-05-24','01:06:08','-','12500','0','0','Master');
/*!40000 ALTER TABLE `treturpembelian` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `treturpembeliandetail`
--

DROP TABLE IF EXISTS `treturpembeliandetail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `treturpembeliandetail` (
  `no_retur` varchar(255) DEFAULT NULL,
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `jumlah` varchar(255) DEFAULT NULL,
  `satuan` varchar(255) DEFAULT NULL,
  `harga` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `treturpembeliandetail`
--

LOCK TABLES `treturpembeliandetail` WRITE;
/*!40000 ALTER TABLE `treturpembeliandetail` DISABLE KEYS */;
INSERT INTO `treturpembeliandetail` VALUES ('PBL240520-010428','BRG001','Aqua Galon 1','1','PCS','12500','12500'),('PBL240520-010606','BRG001','Aqua Galon 1','1','PCS','12500','12500');
/*!40000 ALTER TABLE `treturpembeliandetail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `treturpenjualan`
--

DROP TABLE IF EXISTS `treturpenjualan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `treturpenjualan` (
  `no_retur` varchar(255) DEFAULT NULL,
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `waktu` varchar(255) DEFAULT NULL,
  `pelanggan` varchar(255) DEFAULT NULL,
  `total_retur` varchar(255) DEFAULT NULL,
  `total_dibayar` varchar(255) DEFAULT NULL,
  `total_mengurangi_piutang` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `treturpenjualan`
--

LOCK TABLES `treturpenjualan` WRITE;
/*!40000 ALTER TABLE `treturpenjualan` DISABLE KEYS */;
/*!40000 ALTER TABLE `treturpenjualan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `treturpenjualandetail`
--

DROP TABLE IF EXISTS `treturpenjualandetail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `treturpenjualandetail` (
  `no_retur` varchar(255) DEFAULT NULL,
  `kode_obat` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `jumlah` varchar(255) DEFAULT NULL,
  `satuan` varchar(255) DEFAULT NULL,
  `harga` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `treturpenjualandetail`
--

LOCK TABLES `treturpenjualandetail` WRITE;
/*!40000 ALTER TABLE `treturpenjualandetail` DISABLE KEYS */;
/*!40000 ALTER TABLE `treturpenjualandetail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tstokopname`
--

DROP TABLE IF EXISTS `tstokopname`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = ASCII */;
CREATE TABLE `tstokopname` (
  `kode` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `waktu` varchar(255) DEFAULT NULL,
  `kode_barang` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `satuan` varchar(255) DEFAULT NULL,
  `harga_beli` varchar(255) DEFAULT NULL,
  `stok_komputer` varchar(255) DEFAULT NULL,
  `stok_nyata` varchar(255) DEFAULT NULL,
  `selisih` varchar(255) DEFAULT NULL,
  `total_selisih` varchar(255) DEFAULT NULL,
  `alasan` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ASCII;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tstokopname`
--

LOCK TABLES `tstokopname` WRITE;
/*!40000 ALTER TABLE `tstokopname` DISABLE KEYS */;
/*!40000 ALTER TABLE `tstokopname` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2023-10-16 18:13:53
