-- MariaDB dump 10.19  Distrib 10.4.24-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: APTK01
-- ------------------------------------------------------
-- 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 `autokode`
--

DROP TABLE IF EXISTS `autokode`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `autokode` (
  `id` varchar(255) DEFAULT NULL,
  `obat` varchar(255) DEFAULT NULL,
  `suplier` varchar(255) DEFAULT NULL,
  `pelanggan` varchar(255) DEFAULT NULL,
  `sales` varchar(255) DEFAULT NULL,
  `dokter` 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
) 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','OBT0115','SPL0010','PLG0008','SLS0002','DKT0002','PTK0002','KRY0001','OPT0006','KTG0009','RTB0001','RTJ0001');
/*!40000 ALTER TABLE `autokode` 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 = utf8 */;
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,
  `option_print` varchar(255) DEFAULT NULL,
  `print_preview` 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','false','true','false'),('penjualan','true','true','true','false','true','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 = utf8 */;
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 = utf8 */;
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 `combohargalevel`
--

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

--
-- Dumping data for table `combohargalevel`
--

LOCK TABLES `combohargalevel` WRITE;
/*!40000 ALTER TABLE `combohargalevel` DISABLE KEYS */;
INSERT INTO `combohargalevel` VALUES ('harga_Jual_1'),('harga_Jual_2'),('harga_Jual_3'),('harga_Jual_4'),('harga_Jual_5');
/*!40000 ALTER TABLE `combohargalevel` 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 = utf8 */;
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 `combokategoriobat`
--

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

--
-- Dumping data for table `combokategoriobat`
--

LOCK TABLES `combokategoriobat` WRITE;
/*!40000 ALTER TABLE `combokategoriobat` DISABLE KEYS */;
INSERT INTO `combokategoriobat` VALUES ('Obat');
/*!40000 ALTER TABLE `combokategoriobat` 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 = utf8 */;
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 ('KTG0013','Biaya listrik'),('KTG0007','saldo awal'),('KTG0009','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 = utf8 */;
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','Biaya listrik'),('KTG0014','jual barang bekas'),('KTG0002','saldo awal');
/*!40000 ALTER TABLE `combokategoripengeluaran` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `combosatuanobat`
--

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

--
-- Dumping data for table `combosatuanobat`
--

LOCK TABLES `combosatuanobat` WRITE;
/*!40000 ALTER TABLE `combosatuanobat` DISABLE KEYS */;
INSERT INTO `combosatuanobat` VALUES ('Pcs'),('Tablet');
/*!40000 ALTER TABLE `combosatuanobat` 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 = utf8 */;
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 = utf8 */;
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');
/*!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 = utf8 */;
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)'),('Sedang (90mm)'),('Besar (A4)'),('Surat Jalan'),('Besar (150mm)');
/*!40000 ALTER TABLE `comboukurancetak` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dapotek`
--

DROP TABLE IF EXISTS `dapotek`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dapotek` (
  `kode` varchar(255) DEFAULT NULL,
  `nama_apotek` varchar(255) DEFAULT NULL,
  `nohp` varchar(255) DEFAULT NULL,
  `alamat` varchar(255) DEFAULT NULL,
  `header_nota` varchar(255) DEFAULT NULL,
  `footer_nota` varchar(255) DEFAULT NULL,
  `kode_operator` varchar(255) DEFAULT NULL,
  `lokasi_database` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ascii;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dapotek`
--

LOCK TABLES `dapotek` WRITE;
/*!40000 ALTER TABLE `dapotek` DISABLE KEYS */;
INSERT INTO `dapotek` VALUES ('apotek','Nama Apotek Anda','081359395206','Jln. Harinjing Kepung - Kediri','Nama Apotek Kita\n081359395206\nJln. Harinjing Kepung - Kediri','Terimaskasih telah berbelanja \ndi Nama Apotek Kita \nBarang yang sudah dibeli \ntidak dapat di tukar/kembalikan','Master','null');
/*!40000 ALTER TABLE `dapotek` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ddokter`
--

DROP TABLE IF EXISTS `ddokter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ddokter` (
  `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 `ddokter`
--

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

--
-- Table structure for table `dediting`
--

DROP TABLE IF EXISTS `dediting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dediting` (
  `kode` varchar(255) DEFAULT NULL,
  `tanggal_pembelian` varchar(255) DEFAULT NULL,
  `harga_pembelian` varchar(255) DEFAULT NULL,
  `diskon_refaktur_pembelian` varchar(255) DEFAULT NULL,
  `tanggal_penjualan` varchar(255) DEFAULT NULL,
  `harga_penjualan` varchar(255) DEFAULT NULL,
  `dikson_refaktur_penjualan` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=ascii;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dediting`
--

LOCK TABLES `dediting` WRITE;
/*!40000 ALTER TABLE `dediting` DISABLE KEYS */;
INSERT INTO `dediting` VALUES ('editing','Tanggal pembelian bisa dirubah','harga pembelian bisa dirubah','Dapat memberi diskon pembelian','Tanggal penjualan bisa dirubah','harga penjualan bisa dirubah','Dapat memberi diskon penjualan');
/*!40000 ALTER TABLE `dediting` 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 = utf8 */;
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 `dobat`
--

DROP TABLE IF EXISTS `dobat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dobat` (
  `kode` varchar(255) NOT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `kategori` varchar(255) DEFAULT NULL,
  `satuan` varchar(255) DEFAULT NULL,
  `harga_beli` varchar(255) DEFAULT NULL,
  `stok` varchar(255) DEFAULT NULL,
  `stok_min` varchar(255) DEFAULT NULL,
  `harga_jual_1` varchar(255) DEFAULT NULL,
  `harga_jual_2` varchar(255) DEFAULT NULL,
  `harga_jual_3` varchar(255) DEFAULT NULL,
  `harga_jual_4` varchar(255) DEFAULT NULL,
  `harga_jual_5` varchar(255) DEFAULT NULL,
  `suplier` varchar(255) DEFAULT NULL,
  `expired` varchar(255) DEFAULT NULL,
  `indikasi` varchar(255) DEFAULT NULL,
  `pabrik` varchar(255) DEFAULT NULL,
  `komposisi` varchar(255) DEFAULT NULL,
  `lokasi` 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 `dobat`
--

LOCK TABLES `dobat` WRITE;
/*!40000 ALTER TABLE `dobat` DISABLE KEYS */;
INSERT INTO `dobat` VALUES ('OBT0114','Contoh','Obat','Pcs','10000','29','30','15000','0','0','0','0','test','-','indikasi','','komposisi	',''),('OBT0115','Contoh','Obat','Pcs','10000','29','0','15000','0','0','0','0','test','-','indikasi','','komposisi	',''),('OBT0116','Contoh','Obat','Pcs','10000','29','0','15000','0','0','0','0','test','-','indikasi','','komposisi	',''),('OBT0117','Contoh','Obat','Pcs','10000','29','0','15000','0','0','0','0','test','-','indikasi','','komposisi	',''),('OBT0118','Contoh','Obat','Pcs','10000','28','0','15000','0','0','0','0','test','-','indikasi','','komposisi	',''),('OBT0119','Contoh','Obat','Pcs','10000','29','0','15000','0','0','0','0','test','-','indikasi','','komposisi	',''),('OBT0120','Contoh','Obat','Pcs','10000','29','0','15000','16000','19000','0','0','test','-','indikasi','','komposisi	',''),('OBT0121','Contoh','Obat','Pcs','10000','29','0','15000','0','0','0','0','test','-','indikasi','','komposisi	',''),('OBT0122','Contoh','Obat','Pcs','10000','24','0','15000','0','0','0','0','test','-','indikasi','','komposisi	','');
/*!40000 ALTER TABLE `dobat` 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 = utf8 */;
CREATE TABLE `doperator` (
  `kode` text DEFAULT NULL,
  `username` text DEFAULT NULL,
  `password` text DEFAULT NULL,
  `retur_pembelian` text DEFAULT NULL,
  `retur_penjualan` text DEFAULT NULL,
  `tambah_dokter` text DEFAULT NULL,
  `export_penjualan` text DEFAULT NULL,
  `hapus_pembelian` text DEFAULT NULL,
  `jendela_obat` text DEFAULT NULL,
  `tambah_biaya` text DEFAULT NULL,
  `edit_pelanggan` text DEFAULT NULL,
  `penjualan` text DEFAULT NULL,
  `hapus_suplier` text DEFAULT NULL,
  `hapus_biaya` text DEFAULT NULL,
  `tambah_petunjuk` text DEFAULT NULL,
  `edit_suplier` text DEFAULT NULL,
  `export_dokter` 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,
  `jendela_petunjuk` text DEFAULT NULL,
  `edit_sales` text DEFAULT NULL,
  `cashflow` text DEFAULT NULL,
  `detail_biaya` text DEFAULT NULL,
  `import_dokter` text DEFAULT NULL,
  `tambah_suplier` text DEFAULT NULL,
  `hapus_pelanggan` text DEFAULT NULL,
  `barcode` text DEFAULT NULL,
  `aktivasi` text DEFAULT NULL,
  `jendela_pelanggan` text DEFAULT NULL,
  `apotek` text DEFAULT NULL,
  `edit_obat` text DEFAULT NULL,
  `tambah_sales` text DEFAULT NULL,
  `jendela_cashflow` text DEFAULT NULL,
  `jendela_dokter` text DEFAULT NULL,
  `export_suplier` text DEFAULT NULL,
  `cetak_penjualan` text DEFAULT NULL,
  `import_obat` text DEFAULT NULL,
  `hapus_dokter` text DEFAULT NULL,
  `export_pelanggan` text DEFAULT NULL,
  `detail_penjualan` text DEFAULT NULL,
  `export_hutang` text DEFAULT NULL,
  `import_sales` text DEFAULT NULL,
  `tambah_obat` 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,
  `jendela_karyawan` text DEFAULT NULL,
  `jendela_piutang` text DEFAULT NULL,
  `detail_pembelian` text DEFAULT NULL,
  `jendela_hutang` text DEFAULT NULL,
  `tambah_pelanggan` text DEFAULT NULL,
  `import_suplier` text DEFAULT NULL,
  `bayar_hutang` text DEFAULT NULL,
  `jendela_penjualan` text DEFAULT NULL,
  `tambah_karyawan` text DEFAULT NULL,
  `export_cashflow` text DEFAULT NULL,
  `export_obat` text DEFAULT NULL,
  `cetak_piutang` text DEFAULT NULL,
  `edit_dokter` text DEFAULT NULL,
  `cetak_biaya` text DEFAULT NULL,
  `export_biaya` text DEFAULT NULL,
  `export_piutang` text DEFAULT NULL,
  `import_petunjuk` text DEFAULT NULL,
  `cetak_hutang` text DEFAULT NULL,
  `edit_karyawan` text DEFAULT NULL,
  `hapus_petunjuk` text DEFAULT NULL,
  `import_karyawan` text DEFAULT NULL,
  `edit_petunjuk` text DEFAULT NULL,
  `hapus_sales` text DEFAULT NULL,
  `tambah_penjualan` text DEFAULT NULL,
  `export_petunjuk` text DEFAULT NULL,
  `cetak_cashflow` text DEFAULT NULL,
  `jendela_pembelian` text DEFAULT NULL,
  `tambah_cashflow` text DEFAULT NULL,
  `hutang` text DEFAULT NULL,
  `cetak_pembelian` text DEFAULT NULL,
  `laporan` text DEFAULT NULL,
  `editing` text DEFAULT NULL,
  `detail_cashflow` text DEFAULT NULL,
  `jendela_suplier` text DEFAULT NULL,
  `bayar_piutang` text DEFAULT NULL,
  `tambah_pembelian` text DEFAULT NULL,
  `hapus_obat` text DEFAULT NULL,
  `export_pembelian` text DEFAULT NULL,
  `detail_retur_pembelian` text DEFAULT NULL,
  `tambah_retur_pembelian` text DEFAULT NULL,
  `hapus_retur_pembelian` text DEFAULT NULL,
  `tambah_retur_penjualan` text DEFAULT NULL,
  `hapus_retur_penjualan` text DEFAULT NULL,
  `detail_retur_penjualan` text DEFAULT NULL,
  `stok_opname` text DEFAULT NULL,
  `updates` text DEFAULT NULL,
  `about` text DEFAULT NULL,
  `cetak_retur_penjualan` text DEFAULT NULL,
  `hapus_hutang` text DEFAULT NULL,
  `export_retur_penjualan` text DEFAULT NULL,
  `hapus_piutang` text DEFAULT NULL,
  `cetak_retur_pembelian` text DEFAULT NULL,
  `export_retur_pembelian` text DEFAULT NULL,
  `tambah_stok_opname` text DEFAULT NULL,
  `detail_stok_opname` text DEFAULT NULL,
  `hapus_stok_opname` text DEFAULT NULL,
  `cetak_stok_opname` text DEFAULT NULL,
  `export_stok_opname` text DEFAULT NULL,
  `tambah_hutang` text DEFAULT NULL,
  `tambah_piutang` text DEFAULT NULL,
  `printSizeName` text DEFAULT NULL,
  `keuangan` text DEFAULT NULL,
  `obat` text DEFAULT NULL,
  `total_pembelian` text DEFAULT NULL,
  `total_penjualan` text DEFAULT NULL
) 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','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','true','true','true','true','true','Kecil (Z_58mm)','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 = utf8 */;
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 ('PLG0008','test','','','','','');
/*!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 = utf8 */;
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 = utf8 */;
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 = utf8 */;
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 ('SPL0009','test','','','','','');
/*!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 = utf8 */;
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
) 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','','','2020-07-01','','','2020-07-01','','',''),('akhir','','','2020-07-16','','','2020-07-19','','','');
/*!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 = utf8 */;
CREATE TABLE `keluarmasuk` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `masuk` varchar(255) DEFAULT NULL,
  `keluar` varchar(255) DEFAULT NULL,
  `sisa` varchar(255) DEFAULT NULL,
  `satuan` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL,
  `status` 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 ('PBL150720-193636','2020-07-15','OBT0114','Contoh','1','0','4','Pcs','Master','Masuk','Pembelian'),('PJL160720-113724','2020-07-16','OBT0114','Contoh','0','1','0','Pcs','Master','Keluar','Penjualan'),('PBL160720-114039','2020-07-16','OBT0114','Contoh','10','0','10','Pcs','Master','Masuk','Pembelian'),('PBL160720-114433','2020-07-16','OBT0114','Contoh','1','0','11','Pcs','Master','Masuk','Pembelian'),('PJL160720-114933','2020-07-16','OBT0114','Contoh','0','1','10','Pcs','Master','Keluar','Penjualan'),('PBL160720-114944','2020-07-16','OBT0114','Contoh','20','0','30','Pcs','Master','Masuk','Pembelian'),('PJL190720-183507','2020-07-19','OBT0114','Contoh','0','1','29','Pcs','Master','Keluar','Penjualan'),('PJL190720-192219','2020-07-19','OBT0122','Contoh','0','5','24','Pcs','Master','Keluar','Penjualan'),('PJL190720-192227','2020-07-19','OBT0118','Contoh','0','1','28','Pcs','Master','Keluar','Penjualan');
/*!40000 ALTER TABLE `keluarmasuk` 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 = utf8 */;
CREATE TABLE `tbiaya` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` 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 = utf8 */;
CREATE TABLE `tcashflow` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` 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 ('PJL150720-113557','2020-07-15','Pemasukan','Penjualan','16000','0','Penjualan: PJL150720-113557','Master'),('PJL150720-133234','2020-07-15','Pemasukan','Penjualan','16000','0','Penjualan: PJL150720-133234','Master'),('PJL150720-134055','2020-07-15','Pemasukan','Penjualan','45000','0','Penjualan: PJL150720-134055','Master'),('PBL150720-134408','2020-07-15','Pengeluaran','Pembelian','0','10000','Pembelian: PBL150720-134408','Master'),('PJL150720-134754','2020-07-15','Pemasukan','Penjualan','30000','0','Penjualan: PJL150720-134754','Master'),('PJL150720-135329','2020-07-15','Pemasukan','Penjualan','15000','0','Penjualan: PJL150720-135329','Master'),('PJL150720-135439','2020-07-15','Pemasukan','Penjualan','15000','0','Penjualan: PJL150720-135439','Master'),('PJL150720-140828','2020-07-15','Pemasukan','Penjualan','30000','0','Penjualan: PJL150720-140828','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 = utf8 */;
CREATE TABLE `thutang` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `tempo` varchar(255) DEFAULT NULL,
  `jatuh_tempo` varchar(255) DEFAULT NULL,
  `suplier` 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,
  `keterangan` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL,
  `status` 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 */;
INSERT INTO `thutang` VALUES ('PBL160720-114944','2020-07-16','Kredit','28-07-2020','test','','200000','0','200000','-','Master','Belum Lunas');
/*!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 = utf8 */;
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 ('PBL150720-193636','2020-07-15','19:36','Tunai','','15-07-2020','-','','10000','0','0','0','10000','0','Master'),('PBL160720-114039','2020-07-16','11:40','Kredit','12','28-07-2020','SPL0009','test','100000','0','0','0','0','0','Master'),('PBL160720-114433','2020-07-16','11:44','Kredit','12','28-07-2020','SPL0009','test','10000','0','0','0','0','0','Master'),('PBL160720-114944','2020-07-16','11:49','Kredit','12','28-07-2020','SPL0009','test','200000','0','0','0','0','0','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 = utf8 */;
CREATE TABLE `tpembeliandetail` (
  `faktur` 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` varchar(255) DEFAULT NULL,
  `total` 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 ('PBL150720-193636','OBT0114','Contoh','1','Pcs','10000','0','10000'),('PBL160720-114039','OBT0114','Contoh','10','Pcs','10000','0','100000'),('PBL160720-114433','OBT0114','Contoh','1','Pcs','10000','0','10000'),('PBL160720-114944','OBT0114','Contoh','20','Pcs','10000','0','200000');
/*!40000 ALTER TABLE `tpembeliandetail` 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 = utf8 */;
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,
  `dokter` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `dikson_persen` varchar(255) DEFAULT NULL,
  `diskon` varchar(255) DEFAULT NULL,
  `bayar` varchar(255) DEFAULT NULL,
  `kembali` varchar(255) DEFAULT NULL,
  `hpp` varchar(255) DEFAULT NULL,
  `laba` varchar(255) DEFAULT NULL,
  `ppn` 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 ('PJL160720-113724','2020-07-16','11:37','Tunai','','16-07-2020','-','','-','','','15000','0','0','16000','1000','10000','5000','0','Master'),('PJL160720-114933','2020-07-16','11:49','Kredit','12','28-07-2020','PLG0008','test','-','test','','15000','0','0','0','0','10000','5000','0','Master'),('PJL190720-183507','2020-07-19','18:35','Tunai','','19-07-2020','-','','-','','','15000','0','0','15000','0','10000','5000','0','Master'),('PJL190720-192219','2020-07-19','19:22','Tunai','','19-07-2020','-','','-','','','75000','0','0','90000','15000','50000','25000','0','Master'),('PJL190720-192227','2020-07-19','19:22','Tunai','','19-07-2020','-','','-','','','15000','0','0','15000','0','10000','5000','0','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 = utf8 */;
CREATE TABLE `tpenjualandetail` (
  `faktur` 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` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `hpp` varchar(255) DEFAULT NULL,
  `laba` varchar(255) DEFAULT NULL,
  `index_harga` 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 ('PJL160720-113724','OBT0114','Contoh','1','Pcs','15000','0','15000','10000','5000','1'),('PJL160720-114933','OBT0114','Contoh','1','Pcs','15000','0','15000','10000','5000','1'),('PJL190720-183507','OBT0114','Contoh','1','Pcs','15000','0','15000','10000','5000','1'),('PJL190720-192219','OBT0122','Contoh','5','Pcs','15000','0','75000','50000','25000','1'),('PJL190720-192227','OBT0118','Contoh','1','Pcs','15000','0','15000','10000','5000','1');
/*!40000 ALTER TABLE `tpenjualandetail` 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 = utf8 */;
CREATE TABLE `tpiutang` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `tempo` varchar(255) DEFAULT NULL,
  `jatuh_tempo` varchar(255) DEFAULT NULL,
  `suplier` 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,
  `keterangan` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL,
  `status` 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 */;
INSERT INTO `tpiutang` VALUES ('PJL160720-114933','2020-07-16','Kredit','28-07-2020','','test','15000','0','15000','-','Master','Belum Lunas');
/*!40000 ALTER TABLE `tpiutang` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `treturdetail`
--

DROP TABLE IF EXISTS `treturdetail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `treturdetail` (
  `no_retur` varchar(255) DEFAULT NULL,
  `kode_obat` varchar(255) DEFAULT NULL,
  `jumlah` varchar(255) DEFAULT NULL,
  `nama` 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 `treturdetail`
--

LOCK TABLES `treturdetail` WRITE;
/*!40000 ALTER TABLE `treturdetail` DISABLE KEYS */;
/*!40000 ALTER TABLE `treturdetail` 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 = utf8 */;
CREATE TABLE `treturpembelian` (
  `no_retur` varchar(255) DEFAULT NULL,
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` 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 */;
/*!40000 ALTER TABLE `treturpembelian` 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 = utf8 */;
CREATE TABLE `treturpenjualan` (
  `no_retur` varchar(255) DEFAULT NULL,
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `pelanggan` 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 `treturpenjualan`
--

LOCK TABLES `treturpenjualan` WRITE;
/*!40000 ALTER TABLE `treturpenjualan` DISABLE KEYS */;
/*!40000 ALTER TABLE `treturpenjualan` 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 = utf8 */;
CREATE TABLE `tstokopname` (
  `kode` 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,
  `tanggal` 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-08-01 19:31:44
