
-- ==========================================
-- Host		: localhost
-- Database	: APTK02
-- Aplikasi	: iB Apotek 5 Solution 5.2
-- Server Ver.	: 10.4.24-MariaDB-log
-- Total Row	: 100
-- ==========================================

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

DROP TABLE IF EXISTS `aturkolom`;
CREATE TABLE `aturkolom` (
  `kode` varchar(255) DEFAULT NULL,
  `tPenjualan` varchar(255) DEFAULT NULL,
  `tPembelian` varchar(255) DEFAULT NULL,
  `tHutang` varchar(255) DEFAULT NULL,
  `tPiutang` varchar(255) DEFAULT NULL,
  `tBiaya` varchar(255) DEFAULT NULL,
  `tCashflow` varchar(255) DEFAULT NULL,
  `tReturPenjualan` varchar(255) DEFAULT NULL,
  `tReturPembelian` varchar(255) DEFAULT NULL,
  `dObat` varchar(255) DEFAULT NULL,
  `dSuplier` varchar(255) DEFAULT NULL,
  `dPelanggan` varchar(255) DEFAULT NULL,
  `dSales` varchar(255) DEFAULT NULL,
  `dDokter` varchar(255) DEFAULT NULL,
  `dKaryawan` varchar(255) DEFAULT NULL,
  `dPetunjuk` varchar(255) DEFAULT NULL,
  `dObat_req` varchar(255) DEFAULT NULL,
  `dKaryawan_req` varchar(255) DEFAULT NULL,
  `dSaldoAwal` varchar(255) DEFAULT NULL,
  `tPenjualan_req` varchar(255) DEFAULT NULL,
  `tPembelian_req` varchar(255) DEFAULT NULL,
  `pSaldoAwal` varchar(255) DEFAULT NULL,
  `pSaldoAwalHutang` varchar(255) DEFAULT NULL,
  `pStokOpname` varchar(255) DEFAULT NULL,
  `pSaldoAwalPiutang` varchar(255) DEFAULT NULL,
  `tPembelianPending_req` varchar(255) DEFAULT NULL,
  `tPenjualanPending_req` varchar(255) DEFAULT NULL,
  `tPembelianDetail` varchar(255) DEFAULT NULL,
  `tPenjualanDetail` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `aturkolom` WRITE;
/*!40000 ALTER TABLE `aturkolom` DISABLE KEYS */;
INSERT INTO `aturkolom` VALUES ('aturKolom','true-true-true-true-true-true-false-false-false-true-false-false-false-true-true-false-false-false-false-true-false-false-true-true-','true-true-true-true-true-true-false-true-true-false-false-false-false-true-false-false-true','true-true-true-true-true-true-true-true-true-true-true-false-','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-false-true-true-true-true-true-','true-true-true-true-true-true-true-true-true-','true-true-true-true-true-true-true-true-true-false-false-false-false-false-false-true-true-false-false-false-false-false-false-false-false-false-true-false-false-true-true','true-true-true-true-true-true-false-','true-true-true-true-true-true-false-','true-true-true-true-true-true-false-','true-true-true-true-true-true-false-','true-true-true-true-true-true-false-','','true-true-false-true-false-false-false-true-true-false-false-false-false-false-false-true-true-false-false-false-false-false-false-false-false-false-true-false-false-true-false-','','false-true-false-true-true-true-true-true-true-true-','true-true-true-true-false-false-false-false-false-false-false-false-false-true-true-false-false-false-false-false-false-false-false-true-','true-true-false-true-false-false-false-true-true-false-false-false-false-false-true-','true-true-false-true-true-true-true-true-true-true-','true-true-true-true-true-true-true-','true-true-false-true-true-true-false-false-true-true-false-true-true-','true-true-true-true-true-true-true-','true-true-true-true-false-false-false-true-true-false-false-false-false-true-false-false-true-','true-true-true-false-false-false-false-false-true-false-false-false-false-false-true-false-false-false-false-true-true-false-false-true-','true-true-true-true-false-true-true-false-true-false-true-true-false-false-false-false-false-false-false-false-false-false-false-false-false-false-false-false-true-true-true-false-','true-true-true-true-true-true-false-false-true-true-true-false-false-','');
/*!40000 ALTER TABLE `aturkolom` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `autokode`;
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,
  `saldoAwal` varchar(255) DEFAULT NULL,
  `saldoAwalHutang` varchar(255) DEFAULT NULL,
  `saldoAwalPiutang` varchar(255) DEFAULT NULL,
  `stokOpname` varchar(255) DEFAULT NULL,
  `no_pesanan` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `autokode` WRITE;
/*!40000 ALTER TABLE `autokode` DISABLE KEYS */;
INSERT INTO `autokode` VALUES ('1','OBT0005','SPL0002','PLG0002','SLS0001','DKT0001','PTK0001','KRY0001','OPT0001','KTG0007','RTB0001','RTJ0001','SDA0002','SDH0002','SDP0002','STP0002','NSP0003','');
/*!40000 ALTER TABLE `autokode` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `barcode`;
CREATE TABLE `barcode` (
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `harga` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

DROP TABLE IF EXISTS `checkboxediting`;
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,
  `laba_otomatis` varchar(255) DEFAULT NULL,
  `option_print` varchar(255) DEFAULT NULL,
  `harga_resep` varchar(255) DEFAULT NULL,
  `pending_faktur` varchar(255) DEFAULT NULL,
  `konfirmasi_obat` varchar(255) DEFAULT NULL,
  `form_ongkos` varchar(255) DEFAULT NULL,
  `form_PPN` varchar(255) DEFAULT NULL,
  `nilai_PPN` varchar(255) DEFAULT NULL,
  `diskon_faktur` 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,
  `print_preview` varchar(255) DEFAULT NULL,
  `centang_ppn` varchar(255) DEFAULT NULL,
  `faktur_baru` varchar(255) DEFAULT NULL,
  `harga_sebelumnya` varchar(255) DEFAULT NULL,
  `laba_jual` varchar(255) DEFAULT NULL,
  `stok_minus` varchar(255) DEFAULT NULL,
  `input_tabel` varchar(250) NOT NULL DEFAULT 'false',
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

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

DROP TABLE IF EXISTS `comboalasan`;
CREATE TABLE `comboalasan` (
  `nama` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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`;
CREATE TABLE `comboexpired` (
  `nama` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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`;
CREATE TABLE `combojeniskas` (
  `nama` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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 `combojenispenjualan`
--

DROP TABLE IF EXISTS `combojenispenjualan`;
CREATE TABLE `combojenispenjualan` (
  `nama` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `combojenispenjualan` WRITE;
/*!40000 ALTER TABLE `combojenispenjualan` DISABLE KEYS */;
INSERT INTO `combojenispenjualan` VALUES ('Resep',''),('Non Resep','');
/*!40000 ALTER TABLE `combojenispenjualan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `combokategoriobat`
--

DROP TABLE IF EXISTS `combokategoriobat`;
CREATE TABLE `combokategoriobat` (
  `nama` varchar(255) NOT NULL,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`nama`,`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `combokategoriobat` WRITE;
/*!40000 ALTER TABLE `combokategoriobat` DISABLE KEYS */;
INSERT INTO `combokategoriobat` VALUES ('Obat',''),('Obat Anak',''),('Obat Biasa',''),('Obat Herbal',''),('Obat Keras',''),('Obat Kesehatan',''),('Vitamin','');
/*!40000 ALTER TABLE `combokategoriobat` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `combokategoripemasukan`;
CREATE TABLE `combokategoripemasukan` (
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `combokategoripemasukan` WRITE;
/*!40000 ALTER TABLE `combokategoripemasukan` DISABLE KEYS */;
INSERT INTO `combokategoripemasukan` VALUES ('KTG0005','Jual Rak Obat',''),('KTG0006','Dan lain lain',''),('KTG0007','Penjualan','');
/*!40000 ALTER TABLE `combokategoripemasukan` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `combokategoripengeluaran`;
CREATE TABLE `combokategoripengeluaran` (
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `combokategoripengeluaran` WRITE;
/*!40000 ALTER TABLE `combokategoripengeluaran` DISABLE KEYS */;
INSERT INTO `combokategoripengeluaran` VALUES ('KTG0002','Gaji Karyawan',''),('KTG0003','Bayar Token Listrik',''),('KTG0004','Dan lain lain','');
/*!40000 ALTER TABLE `combokategoripengeluaran` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `comboresepnonresep`
--

DROP TABLE IF EXISTS `comboresepnonresep`;
CREATE TABLE `comboresepnonresep` (
  `nama` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `comboresepnonresep` WRITE;
/*!40000 ALTER TABLE `comboresepnonresep` DISABLE KEYS */;
INSERT INTO `comboresepnonresep` VALUES ('Biasa',''),('Resep','');
/*!40000 ALTER TABLE `comboresepnonresep` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `combosatuanbeli`
--

DROP TABLE IF EXISTS `combosatuanbeli`;
CREATE TABLE `combosatuanbeli` (
  `nama` varchar(255) NOT NULL,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`nama`,`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `combosatuanbeli` WRITE;
/*!40000 ALTER TABLE `combosatuanbeli` DISABLE KEYS */;
INSERT INTO `combosatuanbeli` VALUES ('Ampul',''),('Botol',''),('Box',''),('Capsul',''),('Dus',''),('PCS',''),('Strip',''),('Tubes',''),('Vial','');
/*!40000 ALTER TABLE `combosatuanbeli` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `combosatuanjual`
--

DROP TABLE IF EXISTS `combosatuanjual`;
CREATE TABLE `combosatuanjual` (
  `nama` varchar(255) NOT NULL,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`nama`,`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `combosatuanjual` WRITE;
/*!40000 ALTER TABLE `combosatuanjual` DISABLE KEYS */;
INSERT INTO `combosatuanjual` VALUES ('-',''),('Ampul',''),('Botol',''),('Box',''),('Capsul',''),('Dus',''),('Kaplet',''),('Kapsul',''),('PCS',''),('Strip',''),('Tablet',''),('Tube',''),('Vial','');
/*!40000 ALTER TABLE `combosatuanjual` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `combostok`;
CREATE TABLE `combostok` (
  `nama` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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`;
CREATE TABLE `combotunaikredit` (
  `nama` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

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

DROP TABLE IF EXISTS `comboukurancetak`;
CREATE TABLE `comboukurancetak` (
  `nama` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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 `dapotek`
--

DROP TABLE IF EXISTS `dapotek`;
CREATE TABLE `dapotek` (
  `kode` varchar(255) DEFAULT NULL,
  `nama_apotek` varchar(255) DEFAULT NULL,
  `apoteker` varchar(250) DEFAULT '',
  `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,
  `logo` varchar(255) DEFAULT NULL,
  `nomor_wa_lap_online` varchar(250) NOT NULL DEFAULT '081000000000',
  `password_lap_online` varchar(250) NOT NULL DEFAULT '123456',
  `sinkron_laporan` varchar(250) NOT NULL DEFAULT 'true',
  `nomor_wa_notif` varchar(250) NOT NULL DEFAULT '081000000000',
  `value_periode` varchar(250) NOT NULL DEFAULT '1 Jam',
  `pukul` varchar(250) NOT NULL DEFAULT '18:00',
  `waktu_kirim_pesan` varchar(250) NOT NULL DEFAULT 'Pukul',
  `text_header` varchar(250) NOT NULL DEFAULT 'true',
  `text_total_harian` varchar(250) NOT NULL DEFAULT 'true',
  `text_total_bulanan` varchar(250) NOT NULL DEFAULT 'true',
  `banyak_transaksi_harian` varchar(250) NOT NULL DEFAULT 'true',
  `banyak_transaksi_bulanan` varchar(250) NOT NULL DEFAULT 'true',
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `dapotek` WRITE;
/*!40000 ALTER TABLE `dapotek` DISABLE KEYS */;
INSERT INTO `dapotek` VALUES ('apotek','Nama Apotek Anda','apt. Nama Apoteker','081359395206','Jln. Alamat Kec. Alamat - Alamat','Nama Apotek Anda\n081359395206\nJln. Alamat Kec. Alamat - Alamat','Terimaskasih telah berbelanja \ndi Nama Apotek Anda \nBarang yang sudah dibeli \ntidak dapat di tukar/kembalikan','Master','null','null','081000000000','123456','true','081000000000','','18:00','Pukul','true','true','true','true','true','');
/*!40000 ALTER TABLE `dapotek` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `ddokter`;
CREATE TABLE `ddokter` (
  `kode` varchar(255) NOT 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,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`kode`,`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `ddokter` WRITE;
/*!40000 ALTER TABLE `ddokter` DISABLE KEYS */;
INSERT INTO `ddokter` VALUES ('DKT0009','Dokter','','','','','','');
/*!40000 ALTER TABLE `ddokter` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `dediting`;
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,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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`;
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,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

--
-- Table structure for table `dobat`
--

DROP TABLE IF EXISTS `dobat`;
CREATE TABLE `dobat` (
  `kode` varchar(255) NOT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `kategori` varchar(255) DEFAULT NULL,
  `stok` varchar(255) DEFAULT NULL,
  `satuan_beli` varchar(255) DEFAULT NULL,
  `harga_beli` varchar(255) DEFAULT NULL,
  `stok_min` varchar(255) DEFAULT NULL,
  `satuan_1` varchar(255) DEFAULT NULL,
  `satuan_2` varchar(255) DEFAULT NULL,
  `satuan_3` varchar(255) DEFAULT NULL,
  `satuan_4` varchar(255) DEFAULT NULL,
  `isi_1` varchar(255) DEFAULT NULL,
  `isi_2` varchar(255) DEFAULT NULL,
  `isi_3` varchar(255) DEFAULT NULL,
  `isi_4` 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_resep_1` varchar(255) DEFAULT NULL,
  `harga_resep_2` varchar(255) DEFAULT NULL,
  `harga_resep_3` varchar(255) DEFAULT NULL,
  `harga_resep_4` varchar(255) DEFAULT NULL,
  `laba_otomatis` varchar(255) DEFAULT NULL,
  `suplier` varchar(255) DEFAULT NULL,
  `pabrik` varchar(255) DEFAULT NULL,
  `expired` varchar(255) DEFAULT NULL,
  `indikasi` text DEFAULT NULL,
  `komposisi` text DEFAULT NULL,
  `lokasi` varchar(255) DEFAULT NULL,
  `no_batch` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`kode`,`user_id`),
  UNIQUE KEY `kode` (`kode`),
  KEY `kode_2` (`kode`),
  KEY `nama` (`nama`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `dobat` WRITE;
/*!40000 ALTER TABLE `dobat` DISABLE KEYS */;
INSERT INTO `dobat` VALUES ('OBT001','Mecobex Tab','Obat','49','Strip','20000','0','Strip','','','','1','','','','24000','0','0','0','24000','0','0','0','0','Suplier 1','','-','','','','',''),('OBT002','Histigo','Obat','20','Botol','35000','5','Botol','','','','1','','','','40250','0','0','0','40250','0','0','0','0','','','-','','','','',''),('OBT003','Nutrifar','Obat','5','Dus','150000','0','Box','','','','10','0','0','0','15750','0','0','0','0','0','0','0','0','','','2020-10-18','','','','',''),('OBT005','Paraflu','Obat','50','Botol','31900','0','Botol','Kapsul','','','1','50','0','0','38280','765.5','0','0','0','0','0','0','0','','','-','','','','',''),('OBT06','Bronex','Obat','2','Dus','265000','2','Dus','Box','Tablet','','1','10','150','','278250','30475','2031.5','0','0','0','1855','0','0','','','-','','','','','');
/*!40000 ALTER TABLE `dobat` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `doperator`;
CREATE TABLE `doperator` (
  `kode` char(50) NOT NULL,
  `username` text DEFAULT NULL,
  `password` text DEFAULT NULL,
  `apotek` char(50) DEFAULT NULL,
  `operator` char(50) DEFAULT NULL,
  `editing` char(50) DEFAULT NULL,
  `barcode` char(50) DEFAULT NULL,
  `persediaan` char(50) DEFAULT NULL,
  `aktivasi` char(50) DEFAULT NULL,
  `updates` char(50) DEFAULT NULL,
  `about` char(50) DEFAULT NULL,
  `import_saldo_awal` char(50) DEFAULT NULL,
  `jendela_obat` char(50) DEFAULT NULL,
  `tambah_biaya` char(50) DEFAULT NULL,
  `export_dokter` char(50) DEFAULT NULL,
  `piutang` char(50) DEFAULT NULL,
  `hapus_karyawan` char(50) DEFAULT NULL,
  `jendela_petunjuk` char(50) DEFAULT NULL,
  `export_saldo_awal` char(50) DEFAULT NULL,
  `detail_biaya` char(50) DEFAULT NULL,
  `hapus_pelanggan` char(50) DEFAULT NULL,
  `jendela_cashflow` char(50) DEFAULT NULL,
  `hapus_saldo_awal` char(50) DEFAULT NULL,
  `detail_saldo_awal_hutang` char(50) DEFAULT NULL,
  `export_suplier` char(50) DEFAULT NULL,
  `tambah_hutang` char(50) DEFAULT NULL,
  `cetak_penjualan` char(50) DEFAULT NULL,
  `import_obat` char(50) DEFAULT NULL,
  `hapus_dokter` char(50) DEFAULT NULL,
  `export_pelanggan` char(50) DEFAULT NULL,
  `detail_penjualan` char(50) DEFAULT NULL,
  `jendela_sales` char(50) DEFAULT NULL,
  `jendela_piutang` char(50) DEFAULT NULL,
  `jendela_hutang` char(50) DEFAULT NULL,
  `bayar_hutang` char(50) DEFAULT NULL,
  `tambah_saldo_awal_piutang` char(50) DEFAULT NULL,
  `jendela_penjualan` char(50) DEFAULT NULL,
  `tambah_karyawan` char(50) DEFAULT NULL,
  `detail_saldo_awal_piutang` char(50) DEFAULT NULL,
  `export_biaya` char(50) DEFAULT NULL,
  `export_stok_opname` char(50) DEFAULT NULL,
  `export_piutang` char(50) DEFAULT NULL,
  `edit_karyawan` char(50) DEFAULT NULL,
  `hapus_petunjuk` char(50) DEFAULT NULL,
  `tambah_stok_opname` char(50) DEFAULT NULL,
  `edit_petunjuk` char(50) DEFAULT NULL,
  `hapus_sales` char(50) DEFAULT NULL,
  `jendela_pembelian` char(50) DEFAULT NULL,
  `stok_opname` char(50) DEFAULT NULL,
  `tambah_cashflow` char(50) DEFAULT NULL,
  `hutang` char(50) DEFAULT NULL,
  `cetak_pembelian` char(50) DEFAULT NULL,
  `laporan` char(50) DEFAULT NULL,
  `export_pembelian` char(50) DEFAULT NULL,
  `tambah_dokter` char(50) DEFAULT NULL,
  `export_penjualan` char(50) DEFAULT NULL,
  `hapus_pembelian` char(50) DEFAULT NULL,
  `detail_cashflow` char(50) DEFAULT NULL,
  `edit_pelanggan` char(50) DEFAULT NULL,
  `penjualan` char(50) DEFAULT NULL,
  `hapus_suplier` char(50) DEFAULT NULL,
  `hapus_hutang` char(50) DEFAULT NULL,
  `hapus_biaya` char(50) DEFAULT NULL,
  `tambah_petunjuk` char(50) DEFAULT NULL,
  `edit_suplier` char(50) DEFAULT NULL,
  `export_sales` char(50) DEFAULT NULL,
  `pembelian` char(50) DEFAULT NULL,
  `pengaturan` char(50) DEFAULT NULL,
  `hapus_penjualan` char(50) DEFAULT NULL,
  `tambah_saldo_awal_hutang` char(50) DEFAULT NULL,
  `detail_retur_pembelian` char(50) DEFAULT NULL,
  `export_saldo_awal_hutang` char(50) DEFAULT NULL,
  `edit_sales` char(50) DEFAULT NULL,
  `cashflow` char(50) DEFAULT NULL,
  `import_dokter` char(50) DEFAULT NULL,
  `tambah_suplier` char(50) DEFAULT NULL,
  `jendela_pelanggan` char(50) DEFAULT NULL,
  `edit_obat` char(50) DEFAULT NULL,
  `tambah_sales` char(50) DEFAULT NULL,
  `import_saldo_awal_piutang` char(50) DEFAULT NULL,
  `export_saldo_awal_piutang` char(50) DEFAULT NULL,
  `jendela_dokter` char(50) DEFAULT NULL,
  `retur_penjualan` char(50) DEFAULT NULL,
  `tambah_retur_pembelian` char(50) DEFAULT NULL,
  `export_hutang` char(50) DEFAULT NULL,
  `import_sales` char(50) DEFAULT NULL,
  `tambah_obat` char(50) DEFAULT NULL,
  `detail_saldo_awal` char(50) DEFAULT NULL,
  `hapus_cashflow` char(50) DEFAULT NULL,
  `jendela_biaya` char(50) DEFAULT NULL,
  `export_karyawan` char(50) DEFAULT NULL,
  `import_pelanggan` char(50) DEFAULT NULL,
  `hapus_retur_pembelian` char(50) DEFAULT NULL,
  `hapus_piutang` char(50) DEFAULT NULL,
  `tambah_piutang` char(50) DEFAULT NULL,
  `jendela_karyawan` char(50) DEFAULT NULL,
  `detail_pembelian` char(50) DEFAULT NULL,
  `tambah_pelanggan` char(50) DEFAULT NULL,
  `cetak_stok_opname` char(50) DEFAULT NULL,
  `import_suplier` char(50) DEFAULT NULL,
  `tambah_retur_penjualan` char(50) DEFAULT NULL,
  `export_cashflow` char(50) DEFAULT NULL,
  `export_obat` char(50) DEFAULT NULL,
  `cetak_piutang` char(50) DEFAULT NULL,
  `edit_dokter` char(50) DEFAULT NULL,
  `cetak_biaya` char(50) DEFAULT NULL,
  `hapus_stok_opname` char(50) DEFAULT NULL,
  `import_petunjuk` char(50) DEFAULT NULL,
  `cetak_hutang` char(50) DEFAULT NULL,
  `hapus_saldo_awal_hutang` char(50) DEFAULT NULL,
  `saldo_awal` char(50) DEFAULT NULL,
  `hapus_retur_penjualan` char(50) DEFAULT NULL,
  `import_karyawan` char(50) DEFAULT NULL,
  `detail_retur_penjualan` char(50) DEFAULT NULL,
  `tambah_saldo_awal` char(50) DEFAULT NULL,
  `import_stok_opname` char(50) DEFAULT NULL,
  `hapus_saldo_awal_piutang` char(50) DEFAULT NULL,
  `tambah_penjualan` char(50) DEFAULT NULL,
  `export_petunjuk` char(50) DEFAULT NULL,
  `saldo_awal_piutang` char(50) DEFAULT NULL,
  `cetak_cashflow` char(50) DEFAULT NULL,
  `import_saldo_awal_hutang` char(50) DEFAULT NULL,
  `detail_stok_opname` char(50) DEFAULT NULL,
  `retur_pembelian` char(50) DEFAULT NULL,
  `saldo_awal_hutang` char(50) DEFAULT NULL,
  `jendela_suplier` char(50) DEFAULT NULL,
  `bayar_piutang` char(50) DEFAULT NULL,
  `tambah_pembelian` char(50) DEFAULT NULL,
  `hapus_obat` char(50) DEFAULT NULL,
  `atur_kolom` char(50) DEFAULT NULL,
  `printSizeName` char(50) DEFAULT NULL,
  `obat` char(50) DEFAULT NULL,
  `laba` char(50) DEFAULT NULL,
  `export_pembelian_detail` char(50) DEFAULT NULL,
  `export_penjualan_detail` char(50) DEFAULT NULL,
  `keuangan` char(50) DEFAULT NULL,
  `aplikasi` char(50) DEFAULT NULL,
  `printer` char(50) DEFAULT NULL,
  `printSizeNameSP` char(50) DEFAULT NULL,
  `display_harga` char(50) DEFAULT NULL,
  `online` char(50) DEFAULT NULL,
  `histori_hutang` varchar(250) NOT NULL DEFAULT 'true',
  `histori_piutang` varchar(250) NOT NULL DEFAULT 'true',
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`kode`,`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `doperator` WRITE;
/*!40000 ALTER TABLE `doperator` DISABLE KEYS */;
INSERT INTO `doperator` VALUES ('Master','Master','Master','true','true','true','true','true','true','true',NULL,'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','true','true','true','true','true','true','true','true','true','Kecil (58mm) 2','true','true','true','true','true','true','true','A4','true','true','true','true',''),('OPT0007','Contoh Op. 1','123456','false','true','false','false','true','false','false',NULL,'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','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','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','true','false','false','true','false','false','false','false','false','false','false','false','false','false','false','true','Kecil (Z_58mm)','true','true','true','true','true','true','true','A4','true','true','true','true',''),('OPT0025','Contoh Op. 2','123456789','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','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','false','false','false','false','false','false','false','false','false','false','false','','','false','false','false','','','','true','false','','false','','false','false','','false','false','false','false','false','Kecil (Z_58mm)','true','true','true','true','true','true','true','A4','true','true','true','true','');
/*!40000 ALTER TABLE `doperator` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `dpelanggan`;
CREATE TABLE `dpelanggan` (
  `kode` varchar(255) NOT 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,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`kode`,`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

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

DROP TABLE IF EXISTS `dpetunjuk`;
CREATE TABLE `dpetunjuk` (
  `kode` varchar(255) DEFAULT NULL,
  `petunjuk` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

DROP TABLE IF EXISTS `dsales`;
CREATE TABLE `dsales` (
  `kode` varchar(255) NOT 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,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`kode`,`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

DROP TABLE IF EXISTS `dsuplier`;
CREATE TABLE `dsuplier` (
  `kode` varchar(255) NOT 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,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`kode`,`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

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

DROP TABLE IF EXISTS `filtertanggal`;
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,
  `saldoawal` varchar(255) DEFAULT NULL,
  `saldoawalhutang` varchar(255) DEFAULT NULL,
  `saldoawalpiutang` varchar(255) DEFAULT NULL,
  `pembelianDetail` varchar(255) DEFAULT NULL,
  `penjualanDetail` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

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

DROP TABLE IF EXISTS `keluarmasuk`;
CREATE TABLE `keluarmasuk` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(20) 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,
  `no_batch` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `faktur` (`faktur`),
  KEY `kode` (`kode`),
  KEY `kode_2` (`kode`),
  KEY `faktur_2` (`faktur`),
  KEY `no_batch` (`no_batch`),
  KEY `user_id` (`user_id`),
  KEY `tanggal` (`tanggal`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `keluarmasuk` WRITE;
/*!40000 ALTER TABLE `keluarmasuk` DISABLE KEYS */;
INSERT INTO `keluarmasuk` VALUES ('PJL231020-092522',NULL,'OBT004','Calortusin 500mg','0','1','Keluar','Kaplet','','',''),('PBL251020-092923','2020-10-25','OBT004','Calortusin 500mg','1','0','Masuk','Strip','','-',''),('PJL251020-093255',NULL,'OBT001','Mecobex Tab','0','1','Keluar','Strip','','','');
/*!40000 ALTER TABLE `keluarmasuk` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `perubahanharga`;
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_1` varchar(255) DEFAULT NULL,
  `harga_jual_baru_1` varchar(255) DEFAULT NULL,
  `harga_jual_lama_2` varchar(255) DEFAULT NULL,
  `harga_jual_baru_2` varchar(255) DEFAULT NULL,
  `harga_jual_lama_3` varchar(255) DEFAULT NULL,
  `harga_jual_baru_3` varchar(255) DEFAULT NULL,
  `harga_jual_lama_4` varchar(255) DEFAULT NULL,
  `harga_jual_baru_4` varchar(255) DEFAULT NULL,
  `Operator` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

--
-- Table structure for table `psaldoawal`
--

DROP TABLE IF EXISTS `psaldoawal`;
CREATE TABLE `psaldoawal` (
  `kode` varchar(255) NOT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `waktu` 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,
  `keterangan` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`kode`,`user_id`),
  KEY `kode` (`kode`),
  KEY `kode_obat` (`kode_obat`),
  KEY `tanggal` (`tanggal`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `psaldoawal` WRITE;
/*!40000 ALTER TABLE `psaldoawal` DISABLE KEYS */;
INSERT INTO `psaldoawal` VALUES ('SDA01','2020-07-01','09:02:13','OBT002','Histigo','50','Botol','35000','1750000','',''),('SDA02','2020-07-02','09:02:13','OBT001','Mecobex Tab','50','Strip','20000','1000000','',''),('SDA03','2020-07-03','09:02:13','OBT003','Nutrifar','50','Box','150000','7500000','',''),('SDA05','2020-07-05','09:02:13','OBT005','Cviplex','50','Strip','150000','7500000','',''),('SDA06','2021-03-01','09:13:28','OBT06','Bronex','10','Dus','265000','2650000','','');
/*!40000 ALTER TABLE `psaldoawal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `psaldoawalhutang`
--

DROP TABLE IF EXISTS `psaldoawalhutang`;
CREATE TABLE `psaldoawalhutang` (
  `kode` varchar(255) DEFAULT NULL,
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `jatuh_tempo` varchar(255) DEFAULT NULL,
  `suplier` varchar(255) DEFAULT NULL,
  `jumlah` varchar(255) DEFAULT NULL,
  `keterangan` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

--
-- Table structure for table `psaldoawalpiutang`
--

DROP TABLE IF EXISTS `psaldoawalpiutang`;
CREATE TABLE `psaldoawalpiutang` (
  `kode` varchar(255) DEFAULT NULL,
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `jatuh_tempo` varchar(255) DEFAULT NULL,
  `pelanggan` varchar(255) DEFAULT NULL,
  `jumlah` varchar(255) DEFAULT NULL,
  `keterangan` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

--
-- Table structure for table `pstokopname`
--

DROP TABLE IF EXISTS `pstokopname`;
CREATE TABLE `pstokopname` (
  `kode` varchar(255) NOT NULL,
  `tanggal` varchar(255) DEFAULT NULL,
  `waktu` varchar(255) DEFAULT NULL,
  `kode_obat` 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,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`kode`,`user_id`),
  KEY `kode` (`kode`),
  KEY `kode_obat` (`kode_obat`),
  KEY `tanggal` (`tanggal`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

DROP TABLE IF EXISTS `tbiaya`;
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,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

DROP TABLE IF EXISTS `tcashflow`;
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,
  `user_id` varchar(50) DEFAULT '',
  KEY `faktur` (`faktur`),
  KEY `tanggal` (`tanggal`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `tcashflow` WRITE;
/*!40000 ALTER TABLE `tcashflow` DISABLE KEYS */;
INSERT INTO `tcashflow` VALUES ('PBL301219-074841','2019-12-30','07:48','Pengeluaran','Pembelian','0','15000','Pembelian: PBL301219-074841','Master',''),('PJL301219-165546','2019-12-30','16:55','Pemasukan','Penjualan','15300','0','Penjualan: PJL301219-165546','Master',''),('PJL231020-092522','2020-10-23','09:25:27','Pemasukan','Penjualan','1875','0','Penjualan: PJL231020-092522','Master',''),('PJL251020-093255','2020-10-25','09:33:14','Pemasukan','Penjualan','24000','0','Penjualan: PJL251020-093255','Master','');
/*!40000 ALTER TABLE `tcashflow` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `thutang`;
CREATE TABLE `thutang` (
  `faktur` varchar(255) NOT 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,
  `tanggal_bayar` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`faktur`,`user_id`),
  KEY `faktur` (`faktur`),
  KEY `tanggal` (`tanggal`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `thutang` WRITE;
/*!40000 ALTER TABLE `thutang` DISABLE KEYS */;
INSERT INTO `thutang` VALUES ('PBL251020-092923','2020-10-25','09:29:27','12 hari','2020-11-06','Suplier 1','15000','0','15000','Master','Belum Lunas','','','');
/*!40000 ALTER TABLE `thutang` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `tpembelian`;
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,
  `ongkos` varchar(255) DEFAULT NULL,
  `bayar` varchar(255) DEFAULT NULL,
  `kembali` varchar(255) DEFAULT NULL,
  `no_pesanan` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`faktur`,`user_id`),
  UNIQUE KEY `faktur` (`faktur`),
  KEY `faktur_2` (`faktur`),
  KEY `tanggal` (`tanggal`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `tpembelian` WRITE;
/*!40000 ALTER TABLE `tpembelian` DISABLE KEYS */;
INSERT INTO `tpembelian` VALUES ('PBL251020-092923','2020-10-25','09:29:27','Kredit','12','2020-11-06','SPL0064','Suplier 1','15000','0','0','0','0','0','-15000','NSP0003','Master','');
/*!40000 ALTER TABLE `tpembelian` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `tpembeliandetail`;
CREATE TABLE `tpembeliandetail` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(100) DEFAULT NULL,
  `kode` varchar(255) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `kategori` varchar(255) DEFAULT NULL,
  `jumlah` varchar(100) DEFAULT NULL,
  `satuan` varchar(100) DEFAULT NULL,
  `harga_lama` varchar(100) DEFAULT NULL,
  `harga` varchar(100) DEFAULT NULL,
  `diskon_persen` varchar(100) DEFAULT NULL,
  `diskon` varchar(100) DEFAULT NULL,
  `total` varchar(100) DEFAULT NULL,
  `isi_1` varchar(100) DEFAULT NULL,
  `isi_2` varchar(100) DEFAULT NULL,
  `isi_3` varchar(100) DEFAULT NULL,
  `isi_4` varchar(100) DEFAULT NULL,
  `satuan_1` varchar(100) DEFAULT NULL,
  `satuan_2` varchar(100) DEFAULT NULL,
  `satuan_3` varchar(100) DEFAULT NULL,
  `satuan_4` varchar(100) DEFAULT NULL,
  `harga_jual_1` varchar(100) DEFAULT NULL,
  `harga_jual_2` varchar(100) DEFAULT NULL,
  `harga_jual_3` varchar(100) DEFAULT NULL,
  `harga_jual_4` varchar(100) DEFAULT NULL,
  `harga_resep_1` varchar(100) DEFAULT NULL,
  `harga_resep_2` varchar(100) DEFAULT NULL,
  `harga_resep_3` varchar(100) DEFAULT NULL,
  `harga_resep_4` varchar(100) DEFAULT NULL,
  `suplier` varchar(255) DEFAULT NULL,
  `expired` varchar(100) DEFAULT NULL,
  `no_batch` varchar(100) DEFAULT NULL,
  `input_baru` varchar(100) DEFAULT NULL,
  `jumlah_konversi` varchar(100) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `faktur` (`faktur`),
  KEY `kode` (`kode`),
  KEY `tanggal` (`tanggal`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

LOCK TABLES `tpembeliandetail` WRITE;
/*!40000 ALTER TABLE `tpembeliandetail` DISABLE KEYS */;
INSERT INTO `tpembeliandetail` VALUES ('PBL251020-092923','2020-10-25','OBT004','Calortusin 500mg','Obat','1','Strip','15000','15000','0','0','15000','1','10','0','0','Strip','Kaplet','','','18000','1875','0','0','18150','0','0','0','0','-','-','false','1','');
/*!40000 ALTER TABLE `tpembeliandetail` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `tpembelianpending`;
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,
  `ongkos` varchar(255) DEFAULT NULL,
  `bayar` varchar(255) DEFAULT NULL,
  `kembali` varchar(255) DEFAULT NULL,
  `no_pesanan` varchar(255) DEFAULT NULL,
  `operator` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `faktur` (`faktur`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

DROP TABLE IF EXISTS `tpembelianpendingdetail`;
CREATE TABLE `tpembelianpendingdetail` (
  `faktur` varchar(255) DEFAULT NULL,
  `tanggal` varchar(100) DEFAULT NULL,
  `kode` varchar(100) DEFAULT NULL,
  `nama` varchar(255) DEFAULT NULL,
  `kategori` varchar(255) DEFAULT NULL,
  `jumlah` varchar(100) DEFAULT NULL,
  `satuan` varchar(100) DEFAULT NULL,
  `harga_lama` varchar(100) DEFAULT NULL,
  `harga` varchar(100) DEFAULT NULL,
  `diskon_persen` varchar(100) DEFAULT NULL,
  `diskon` varchar(100) DEFAULT NULL,
  `total` varchar(100) DEFAULT NULL,
  `isi_1` varchar(100) DEFAULT NULL,
  `isi_2` varchar(100) DEFAULT NULL,
  `isi_3` varchar(100) DEFAULT NULL,
  `isi_4` varchar(100) DEFAULT NULL,
  `satuan_1` varchar(100) DEFAULT NULL,
  `satuan_2` varchar(100) DEFAULT NULL,
  `satuan_3` varchar(100) DEFAULT NULL,
  `satuan_4` varchar(100) DEFAULT NULL,
  `harga_jual_1` varchar(100) DEFAULT NULL,
  `harga_jual_2` varchar(100) DEFAULT NULL,
  `harga_jual_3` varchar(100) DEFAULT NULL,
  `harga_jual_4` varchar(100) DEFAULT NULL,
  `harga_resep_1` varchar(100) DEFAULT NULL,
  `harga_resep_2` varchar(100) DEFAULT NULL,
  `harga_resep_3` varchar(100) DEFAULT NULL,
  `harga_resep_4` varchar(100) DEFAULT NULL,
  `suplier` varchar(255) DEFAULT NULL,
  `expired` varchar(100) DEFAULT NULL,
  `no_batch` varchar(100) DEFAULT NULL,
  `input_baru` varchar(100) DEFAULT NULL,
  `jumlah_konversi` varchar(100) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

DROP TABLE IF EXISTS `tpenjualan`;
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,
  `jenis_penjualan` varchar(255) DEFAULT NULL,
  `kode_pelanggan` varchar(255) DEFAULT NULL,
  `pelanggan` varchar(255) DEFAULT NULL,
  `pasien` varchar(255) DEFAULT NULL,
  `kode_sales` varchar(255) DEFAULT NULL,
  `sales` varchar(255) DEFAULT NULL,
  `kode_dokter` 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,
  `ppn` varchar(255) DEFAULT NULL,
  `ongkos` 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,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`faktur`,`user_id`),
  UNIQUE KEY `faktur` (`faktur`),
  KEY `faktur_2` (`faktur`),
  KEY `tanggal` (`tanggal`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

DROP TABLE IF EXISTS `tpenjualandetail`;
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_beli` varchar(255) DEFAULT NULL,
  `harga_jual_lama` varchar(255) DEFAULT NULL,
  `harga` varchar(255) DEFAULT NULL,
  `diskon` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `laba` varchar(255) DEFAULT NULL,
  `jumlah_konversi` varchar(255) DEFAULT NULL,
  `expired` varchar(255) DEFAULT NULL,
  `no_batch` varchar(250) NOT NULL DEFAULT '',
  `user_id` varchar(50) DEFAULT '',
  KEY `faktur` (`faktur`),
  KEY `kode` (`kode`),
  KEY `tanggal` (`tanggal`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

DROP TABLE IF EXISTS `tpenjualanpending`;
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,
  `jenis_penjualan` varchar(255) DEFAULT NULL,
  `kode_pelanggan` varchar(255) DEFAULT NULL,
  `pelanggan` varchar(255) DEFAULT NULL,
  `pasien` varchar(255) DEFAULT NULL,
  `kode_sales` varchar(255) DEFAULT NULL,
  `sales` varchar(255) DEFAULT NULL,
  `kode_dokter` 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,
  `ppn` varchar(255) DEFAULT NULL,
  `ongkos` 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,
  `user_id` varchar(50) DEFAULT '',
  KEY `faktur` (`faktur`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

DROP TABLE IF EXISTS `tpenjualanpendingdetail`;
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_beli` varchar(255) DEFAULT NULL,
  `harga_jual_lama` varchar(255) DEFAULT NULL,
  `harga` varchar(255) DEFAULT NULL,
  `diskon` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `laba` varchar(255) DEFAULT NULL,
  `jumlah_konversi` varchar(255) DEFAULT NULL,
  `expired` varchar(255) DEFAULT NULL,
  `no_batch` varchar(250) NOT NULL DEFAULT '',
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

DROP TABLE IF EXISTS `tpiutang`;
CREATE TABLE `tpiutang` (
  `faktur` varchar(255) NOT 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,
  `tanggal_bayar` varchar(255) DEFAULT NULL,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`faktur`,`user_id`),
  KEY `faktur` (`faktur`),
  KEY `tanggal` (`tanggal`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

DROP TABLE IF EXISTS `treturpembelian`;
CREATE TABLE `treturpembelian` (
  `no_retur` varchar(255) NOT 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,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`no_retur`,`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

DROP TABLE IF EXISTS `treturpembeliandetail`;
CREATE TABLE `treturpembeliandetail` (
  `no_retur` varchar(255) DEFAULT NULL,
  `faktur` varchar(20) DEFAULT NULL,
  `tanggal` varchar(20) 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,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`),
  KEY `idx_faktur` (`faktur`),
  KEY `idx_tanggal` (`tanggal`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

DROP TABLE IF EXISTS `treturpenjualan`;
CREATE TABLE `treturpenjualan` (
  `no_retur` varchar(255) NOT 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,
  `user_id` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`no_retur`,`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

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

DROP TABLE IF EXISTS `treturpenjualandetail`;
CREATE TABLE `treturpenjualandetail` (
  `no_retur` varchar(255) DEFAULT NULL,
  `faktur` varchar(20) DEFAULT NULL,
  `tanggal` varchar(20) DEFAULT NULL,
  `kode` varchar(200) NOT 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,
  `user_id` varchar(50) DEFAULT '',
  KEY `user_id` (`user_id`),
  KEY `idx_faktur` (`faktur`),
  KEY `idx_tanggal` (`tanggal`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

--
-- BACKUP FINISH 	: 10-10-2025 06:59:51
--