Aplikasi SIMRS (Sistem Informasi Managemen Rumah Sakit) Khanza HMS meskipun aplikasi gratisan ternyata pengembangannya sangat aktif, tiap bulan muncul update terbaru. Berikut cara update ke versi 16 september 2016.
Download file-file berikut ini:
Segera diupload nanti jam pocong
Cara Update:
1. Ekstrak file yang didownload tadi dan replace ke folder aplikasi Khanza, kalau saya letaknya di /opt/KhanzaHmsLinux (Saya menggunakan Netrunner Linux Frontier).
2. Update database Mysql: Buka browser dan navigasi ke phpmyadmin --> Pilih database sik --> sql
3. Paste script berikut ke kotak tersebut
DROP TABLE IF EXISTS `master_aturan_pakai`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `master_aturan_pakai` (
`aturan` varchar(40) NOT NULL,
PRIMARY KEY (`aturan`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `master_aturan_pakai`
--
LOCK TABLES `master_aturan_pakai` WRITE;
/*!40000 ALTER TABLE `master_aturan_pakai` DISABLE KEYS */;
INSERT INTO `master_aturan_pakai` VALUES ('3 x 1 Sehari'),('3 x 2 Sehari'),('3 x 3 Sehari Sebelum Makan');
/*!40000 ALTER TABLE `master_aturan_pakai` ENABLE KEYS */;
UNLOCK TABLES;
CREATE TABLE `set_alamat_pasien` (
`kelurahan` ENUM('true','false') NULL DEFAULT NULL,
`kecamatan` ENUM('true','false') NULL DEFAULT NULL,
`kabupaten` ENUM('true','false') NULL DEFAULT NULL
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
;
ALTER TABLE `operasi`
ADD COLUMN `dokter_pjanak` VARCHAR(20) NULL DEFAULT NULL AFTER `omloop3`,
ADD COLUMN `dokter_umum` VARCHAR(20) NULL DEFAULT NULL AFTER `dokter_pjanak`,
ADD COLUMN `biaya_dokter_pjanak` DOUBLE NULL DEFAULT NULL AFTER `biayasarpras`,
ADD COLUMN `biaya_dokter_umum` DOUBLE NULL DEFAULT NULL AFTER `biaya_dokter_pjanak`;
ALTER TABLE `operasi`
ADD CONSTRAINT `operasi_ibfk_50` FOREIGN KEY (`dokter_pjanak`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_51` FOREIGN KEY (`dokter_umum`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `operasi`
DROP FOREIGN KEY `operasi_ibfk_32`,
DROP FOREIGN KEY `operasi_ibfk_33`,
DROP FOREIGN KEY `operasi_ibfk_34`,
DROP FOREIGN KEY `operasi_ibfk_35`,
DROP FOREIGN KEY `operasi_ibfk_36`,
DROP FOREIGN KEY `operasi_ibfk_37`,
DROP FOREIGN KEY `operasi_ibfk_38`,
DROP FOREIGN KEY `operasi_ibfk_39`,
DROP FOREIGN KEY `operasi_ibfk_40`,
DROP FOREIGN KEY `operasi_ibfk_41`,
DROP FOREIGN KEY `operasi_ibfk_42`,
DROP FOREIGN KEY `operasi_ibfk_43`,
DROP FOREIGN KEY `operasi_ibfk_44`,
DROP FOREIGN KEY `operasi_ibfk_45`,
DROP FOREIGN KEY `operasi_ibfk_46`,
DROP FOREIGN KEY `operasi_ibfk_47`,
DROP FOREIGN KEY `operasi_ibfk_48`,
DROP FOREIGN KEY `operasi_ibfk_49`;
ALTER TABLE `operasi`
ADD CONSTRAINT `operasi_ibfk_32` FOREIGN KEY (`operator1`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_33` FOREIGN KEY (`operator2`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_34` FOREIGN KEY (`operator3`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_35` FOREIGN KEY (`asisten_operator1`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_36` FOREIGN KEY (`asisten_operator2`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_37` FOREIGN KEY (`instrumen`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_38` FOREIGN KEY (`dokter_anak`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_39` FOREIGN KEY (`perawaat_resusitas`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_40` FOREIGN KEY (`dokter_anestesi`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_41` FOREIGN KEY (`asisten_anestesi`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_42` FOREIGN KEY (`bidan`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_43` FOREIGN KEY (`perawat_luar`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_44` FOREIGN KEY (`kode_paket`) REFERENCES `paket_operasi` (`kode_paket`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_45` FOREIGN KEY (`bidan2`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_46` FOREIGN KEY (`bidan3`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_47` FOREIGN KEY (`omloop`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_48` FOREIGN KEY (`omloop2`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_49` FOREIGN KEY (`omloop3`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `user`
ADD COLUMN `temporary_presensi` ENUM('true','false') NULL DEFAULT NULL AFTER `retensi_rm`,
ADD COLUMN `jurnal_harian` ENUM('true','false') NULL DEFAULT NULL AFTER `temporary_presensi`,
ADD COLUMN `sirkulasi_obat2` ENUM('true','false') NULL DEFAULT NULL AFTER `jurnal_harian`,
ADD COLUMN `edit_registrasi` ENUM('true','false') NULL DEFAULT NULL AFTER `sirkulasi_obat2`;
ALTER TABLE `paket_operasi`
ADD COLUMN `dokter_pjanak` DOUBLE NULL DEFAULT NULL AFTER `sarpras`,
ADD COLUMN `dokter_umum` DOUBLE NULL DEFAULT NULL AFTER `dokter_pjanak`,
ADD COLUMN `kd_pj` CHAR(3) NULL DEFAULT NULL AFTER `dokter_umum`,
ADD COLUMN `status` ENUM('0','1') NULL DEFAULT NULL AFTER `kd_pj`,
ADD CONSTRAINT `paket_operasi_ibfk_1` FOREIGN KEY (`kd_pj`) REFERENCES `penjab` (`kd_pj`) ON UPDATE CASCADE;
ALTER TABLE `databarang`
ADD COLUMN `status` ENUM('0','1') NULL AFTER `expire`;
ALTER TABLE `detailbeli`
ADD COLUMN `no_batch` VARCHAR(10) NOT NULL AFTER `total`;
ALTER TABLE `detailpesan`
ADD COLUMN `no_batch` VARCHAR(10) NOT NULL AFTER `total`;
ALTER TABLE `detreturbeli`
ADD COLUMN `no_batch` VARCHAR(10) NOT NULL AFTER `total`;
ALTER TABLE `detreturjual`
DROP PRIMARY KEY;
ALTER TABLE `dokter`
ADD COLUMN `status` ENUM('0','1') NOT NULL AFTER `no_ijn_praktek`;
ALTER TABLE `dpjp_ranap`
DROP FOREIGN KEY `dpjp_ranap_ibfk_2`;
ALTER TABLE `dpjp_ranap`
ADD CONSTRAINT `dpjp_ranap_ibfk_2` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `gudangbarang`
DROP FOREIGN KEY `gudangbarang_ibfk_2`;
ALTER TABLE `gudangbarang`
ADD CONSTRAINT `gudangbarang_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `hemodialisa`
DROP FOREIGN KEY `hemodialisa_ibfk_3`;
ALTER TABLE `hemodialisa`
ADD CONSTRAINT `hemodialisa_ibfk_3` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `jns_perawatan`
ADD COLUMN `status` ENUM('0','1') NOT NULL AFTER `kd_poli`;
ALTER TABLE `jns_perawatan_inap`
ADD COLUMN `status` ENUM('0','1') NOT NULL AFTER `kd_bangsal`;
ALTER TABLE `jns_perawatan_lab`
ADD COLUMN `status` ENUM('0','1') NOT NULL AFTER `kd_pj`;
ALTER TABLE `jns_perawatan_radiologi`
ADD COLUMN `status` ENUM('0','1') NOT NULL AFTER `kd_pj`;
ALTER TABLE `mutasibarang`
DROP FOREIGN KEY `mutasibarang_ibfk_1`;
ALTER TABLE `mutasibarang`
ADD CONSTRAINT `mutasibarang_ibfk_1` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `obat_penyakit`
DROP FOREIGN KEY `obat_penyakit_ibfk_2`;
ALTER TABLE `obat_penyakit`
ADD CONSTRAINT `obat_penyakit_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `opname`
DROP FOREIGN KEY `opname_ibfk_1`;
ALTER TABLE `opname`
ADD CONSTRAINT `opname_ibfk_1` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `paket_operasi`
DROP FOREIGN KEY `paket_operasi_ibfk_1`;
ALTER TABLE `paket_operasi`
ADD CONSTRAINT `paket_operasi_ibfk_1` FOREIGN KEY (`kd_pj`) REFERENCES `penjab` (`kd_pj`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `parkir`
DROP FOREIGN KEY `parkir_ibfk_1`,
DROP FOREIGN KEY `parkir_ibfk_2`;
ALTER TABLE `parkir`
ADD CONSTRAINT `parkir_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `parkir_ibfk_2` FOREIGN KEY (`kd_parkir`) REFERENCES `parkir_jenis` (`kd_parkir`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `pemasukan_lain`
DROP FOREIGN KEY `pemasukan_lain_ibfk_1`,
DROP FOREIGN KEY `pemasukan_lain_ibfk_2`;
ALTER TABLE `pemasukan_lain`
ADD CONSTRAINT `pemasukan_lain_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pemasukan_lain_ibfk_2` FOREIGN KEY (`kode_kategori`) REFERENCES `kategori_pemasukan_lain` (`kode_kategori`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `pembelian`
DROP FOREIGN KEY `pembelian_ibfk_1`,
DROP FOREIGN KEY `pembelian_ibfk_2`,
DROP FOREIGN KEY `pembelian_ibfk_3`,
DROP FOREIGN KEY `pembelian_ibfk_4`;
ALTER TABLE `pembelian`
ADD CONSTRAINT `pembelian_ibfk_1` FOREIGN KEY (`kode_suplier`) REFERENCES `datasuplier` (`kode_suplier`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pembelian_ibfk_2` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pembelian_ibfk_3` FOREIGN KEY (`kd_bangsal`) REFERENCES `bangsal` (`kd_bangsal`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pembelian_ibfk_4` FOREIGN KEY (`kd_rek`) REFERENCES `akun_bayar` (`kd_rek`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `pemesanan`
DROP FOREIGN KEY `pemesanan_ibfk_1`,
DROP FOREIGN KEY `pemesanan_ibfk_2`;
ALTER TABLE `pemesanan`
ADD CONSTRAINT `pemesanan_ibfk_1` FOREIGN KEY (`kode_suplier`) REFERENCES `datasuplier` (`kode_suplier`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pemesanan_ibfk_2` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `peminjaman_berkas`
DROP FOREIGN KEY `peminjaman_berkas_ibfk_2`,
DROP FOREIGN KEY `peminjaman_berkas_ibfk_3`;
ALTER TABLE `peminjaman_berkas`
ADD CONSTRAINT `peminjaman_berkas_ibfk_2` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `peminjaman_berkas_ibfk_3` FOREIGN KEY (`id_ruang`) REFERENCES `inventaris_ruang` (`id_ruang`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `pengeluaran_harian`
DROP FOREIGN KEY `pengeluaran_harian_ibfk_1`,
DROP FOREIGN KEY `pengeluaran_harian_ibfk_2`;
ALTER TABLE `pengeluaran_harian`
ADD CONSTRAINT `pengeluaran_harian_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pengeluaran_harian_ibfk_2` FOREIGN KEY (`kode_kategori`) REFERENCES `kategori_pengeluaran_harian` (`kode_kategori`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `penjualan`
DROP FOREIGN KEY `penjualan_ibfk_11`,
DROP FOREIGN KEY `penjualan_ibfk_12`,
DROP FOREIGN KEY `penjualan_ibfk_9`;
ALTER TABLE `penjualan`
ADD CONSTRAINT `penjualan_ibfk_11` FOREIGN KEY (`kd_bangsal`) REFERENCES `bangsal` (`kd_bangsal`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `penjualan_ibfk_12` FOREIGN KEY (`kd_rek`) REFERENCES `akun_bayar` (`kd_rek`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `penjualan_ibfk_9` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `periksa_lab`
DROP FOREIGN KEY `periksa_lab_ibfk_10`,
DROP FOREIGN KEY `periksa_lab_ibfk_11`,
DROP FOREIGN KEY `periksa_lab_ibfk_12`,
DROP FOREIGN KEY `periksa_lab_ibfk_13`;
ALTER TABLE `periksa_lab`
ADD CONSTRAINT `periksa_lab_ibfk_10` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_lab_ibfk_11` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan_lab` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_lab_ibfk_12` FOREIGN KEY (`dokter_perujuk`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_lab_ibfk_13` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `periksa_radiologi`
DROP FOREIGN KEY `periksa_radiologi_ibfk_5`,
DROP FOREIGN KEY `periksa_radiologi_ibfk_6`,
DROP FOREIGN KEY `periksa_radiologi_ibfk_7`,
DROP FOREIGN KEY `periksa_radiologi_ibfk_8`;
ALTER TABLE `periksa_radiologi`
ADD CONSTRAINT `periksa_radiologi_ibfk_5` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_radiologi_ibfk_6` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan_radiologi` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_radiologi_ibfk_7` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_radiologi_ibfk_8` FOREIGN KEY (`dokter_perujuk`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `petugas`
CHANGE COLUMN `password` `status` ENUM('0','1') NULL DEFAULT NULL AFTER `no_telp`;
ALTER TABLE `piutang`
DROP FOREIGN KEY `piutang_ibfk_1`,
DROP FOREIGN KEY `piutang_ibfk_3`;
ALTER TABLE `piutang`
ADD CONSTRAINT `piutang_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `piutang_ibfk_3` FOREIGN KEY (`kd_bangsal`) REFERENCES `bangsal` (`kd_bangsal`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rawat_inap_dr`
DROP FOREIGN KEY `rawat_inap_dr_ibfk_3`,
DROP FOREIGN KEY `rawat_inap_dr_ibfk_6`;
ALTER TABLE `rawat_inap_dr`
ADD CONSTRAINT `rawat_inap_dr_ibfk_3` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_inap_dr_ibfk_6` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan_inap` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rawat_inap_drpr`
DROP FOREIGN KEY `rawat_inap_drpr_ibfk_2`,
DROP FOREIGN KEY `rawat_inap_drpr_ibfk_3`,
DROP FOREIGN KEY `rawat_inap_drpr_ibfk_4`;
ALTER TABLE `rawat_inap_drpr`
ADD CONSTRAINT `rawat_inap_drpr_ibfk_2` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan_inap` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_inap_drpr_ibfk_3` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_inap_drpr_ibfk_4` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rawat_inap_pr`
DROP FOREIGN KEY `rawat_inap_pr_ibfk_3`,
DROP FOREIGN KEY `rawat_inap_pr_ibfk_6`;
ALTER TABLE `rawat_inap_pr`
ADD CONSTRAINT `rawat_inap_pr_ibfk_3` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_inap_pr_ibfk_6` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan_inap` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rawat_jl_dr`
DROP FOREIGN KEY `rawat_jl_dr_ibfk_2`,
DROP FOREIGN KEY `rawat_jl_dr_ibfk_3`;
ALTER TABLE `rawat_jl_dr`
ADD CONSTRAINT `rawat_jl_dr_ibfk_2` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_jl_dr_ibfk_3` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rawat_jl_drpr`
DROP FOREIGN KEY `rawat_jl_drpr_ibfk_2`,
DROP FOREIGN KEY `rawat_jl_drpr_ibfk_3`,
DROP FOREIGN KEY `rawat_jl_drpr_ibfk_4`;
ALTER TABLE `rawat_jl_drpr`
ADD CONSTRAINT `rawat_jl_drpr_ibfk_2` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_jl_drpr_ibfk_3` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_jl_drpr_ibfk_4` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rawat_jl_pr`
DROP FOREIGN KEY `rawat_jl_pr_ibfk_10`,
DROP FOREIGN KEY `rawat_jl_pr_ibfk_9`;
ALTER TABLE `rawat_jl_pr`
ADD CONSTRAINT `rawat_jl_pr_ibfk_10` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_jl_pr_ibfk_9` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `reg_periksa`
DROP FOREIGN KEY `reg_periksa_ibfk_3`,
DROP FOREIGN KEY `reg_periksa_ibfk_4`,
DROP FOREIGN KEY `reg_periksa_ibfk_6`;
ALTER TABLE `reg_periksa`
ADD CONSTRAINT `reg_periksa_ibfk_3` FOREIGN KEY (`kd_poli`) REFERENCES `poliklinik` (`kd_poli`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `reg_periksa_ibfk_4` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `reg_periksa_ibfk_6` FOREIGN KEY (`kd_pj`) REFERENCES `penjab` (`kd_pj`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `resep_obat`
DROP FOREIGN KEY `resep_obat_ibfk_4`;
ALTER TABLE `resep_obat`
ADD CONSTRAINT `resep_obat_ibfk_4` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `resep_pulang`
DROP FOREIGN KEY `resep_pulang_ibfk_2`;
ALTER TABLE `resep_pulang`
ADD CONSTRAINT `resep_pulang_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `returbeli`
DROP FOREIGN KEY `returbeli_ibfk_2`,
DROP FOREIGN KEY `returbeli_ibfk_3`,
DROP FOREIGN KEY `returbeli_ibfk_4`;
ALTER TABLE `returbeli`
ADD CONSTRAINT `returbeli_ibfk_2` FOREIGN KEY (`kode_suplier`) REFERENCES `datasuplier` (`kode_suplier`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `returbeli_ibfk_3` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `returbeli_ibfk_4` FOREIGN KEY (`kd_bangsal`) REFERENCES `bangsal` (`kd_bangsal`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `returpasien`
DROP FOREIGN KEY `returpasien_ibfk_4`;
ALTER TABLE `returpasien`
ADD CONSTRAINT `returpasien_ibfk_4` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `returpiutang`
DROP FOREIGN KEY `returpiutang_ibfk_3`,
DROP FOREIGN KEY `returpiutang_ibfk_5`;
ALTER TABLE `returpiutang`
ADD CONSTRAINT `returpiutang_ibfk_3` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `returpiutang_ibfk_5` FOREIGN KEY (`kd_bangsal`) REFERENCES `bangsal` (`kd_bangsal`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rujuk`
DROP FOREIGN KEY `rujuk_ibfk_2`;
ALTER TABLE `rujuk`
ADD CONSTRAINT `rujuk_ibfk_2` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rujukanranap_dokter_rs`
DROP FOREIGN KEY `rujukanranap_dokter_rs_ibfk_1`;
ALTER TABLE `rujukanranap_dokter_rs`
ADD CONSTRAINT `rujukanranap_dokter_rs_ibfk_1` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `set_nota`
ADD COLUMN `tampilkan_tombol_nota_ralan` ENUM('Yes','No') NULL DEFAULT NULL AFTER `tampilkan_ppnobat_ranap`,
ADD COLUMN `tampilkan_tombol_nota_ranap` ENUM('Yes','No') NULL DEFAULT NULL AFTER `tampilkan_tombol_nota_ralan`;
ALTER TABLE `set_tarif`
ADD COLUMN `cara_bayar_operasi` ENUM('Yes','No') NULL DEFAULT NULL AFTER `cara_bayar_radiologi`;
ALTER TABLE `stok_obat_pasien`
DROP FOREIGN KEY `stok_obat_pasien_ibfk_2`;
ALTER TABLE `stok_obat_pasien`
ADD CONSTRAINT `stok_obat_pasien_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `tampreturbeli`
ADD COLUMN `no_batch` VARCHAR(10) NOT NULL AFTER `total`;
ALTER TABLE `tampreturbeli`
DROP FOREIGN KEY `tampreturbeli_ibfk_2`;
ALTER TABLE `tampreturbeli`
ADD CONSTRAINT `tampreturbeli_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `tampreturjual`
DROP FOREIGN KEY `tampreturjual_ibfk_3`;
ALTER TABLE `tampreturjual`
ADD CONSTRAINT `tampreturjual_ibfk_3` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `tampreturpiutang`
DROP FOREIGN KEY `tampreturpiutang_ibfk_2`;
ALTER TABLE `tampreturpiutang`
ADD CONSTRAINT `tampreturpiutang_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
update dokter set status='1';
update paket_operasi set status='1';
update databarang set status='1';
update jns_perawatan set status='1';
update jns_perawatan_inap set status='1';
update jns_perawatan_lab set status='1';
update jns_perawatan_radiologi set status='1';
update petugas set status='1';
Download file-file berikut ini:
Segera diupload nanti jam pocong
Cara Update:
1. Ekstrak file yang didownload tadi dan replace ke folder aplikasi Khanza, kalau saya letaknya di /opt/KhanzaHmsLinux (Saya menggunakan Netrunner Linux Frontier).
2. Update database Mysql: Buka browser dan navigasi ke phpmyadmin --> Pilih database sik --> sql
3. Paste script berikut ke kotak tersebut
DROP TABLE IF EXISTS `master_aturan_pakai`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `master_aturan_pakai` (
`aturan` varchar(40) NOT NULL,
PRIMARY KEY (`aturan`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `master_aturan_pakai`
--
LOCK TABLES `master_aturan_pakai` WRITE;
/*!40000 ALTER TABLE `master_aturan_pakai` DISABLE KEYS */;
INSERT INTO `master_aturan_pakai` VALUES ('3 x 1 Sehari'),('3 x 2 Sehari'),('3 x 3 Sehari Sebelum Makan');
/*!40000 ALTER TABLE `master_aturan_pakai` ENABLE KEYS */;
UNLOCK TABLES;
CREATE TABLE `set_alamat_pasien` (
`kelurahan` ENUM('true','false') NULL DEFAULT NULL,
`kecamatan` ENUM('true','false') NULL DEFAULT NULL,
`kabupaten` ENUM('true','false') NULL DEFAULT NULL
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
;
ALTER TABLE `operasi`
ADD COLUMN `dokter_pjanak` VARCHAR(20) NULL DEFAULT NULL AFTER `omloop3`,
ADD COLUMN `dokter_umum` VARCHAR(20) NULL DEFAULT NULL AFTER `dokter_pjanak`,
ADD COLUMN `biaya_dokter_pjanak` DOUBLE NULL DEFAULT NULL AFTER `biayasarpras`,
ADD COLUMN `biaya_dokter_umum` DOUBLE NULL DEFAULT NULL AFTER `biaya_dokter_pjanak`;
ALTER TABLE `operasi`
ADD CONSTRAINT `operasi_ibfk_50` FOREIGN KEY (`dokter_pjanak`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_51` FOREIGN KEY (`dokter_umum`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `operasi`
DROP FOREIGN KEY `operasi_ibfk_32`,
DROP FOREIGN KEY `operasi_ibfk_33`,
DROP FOREIGN KEY `operasi_ibfk_34`,
DROP FOREIGN KEY `operasi_ibfk_35`,
DROP FOREIGN KEY `operasi_ibfk_36`,
DROP FOREIGN KEY `operasi_ibfk_37`,
DROP FOREIGN KEY `operasi_ibfk_38`,
DROP FOREIGN KEY `operasi_ibfk_39`,
DROP FOREIGN KEY `operasi_ibfk_40`,
DROP FOREIGN KEY `operasi_ibfk_41`,
DROP FOREIGN KEY `operasi_ibfk_42`,
DROP FOREIGN KEY `operasi_ibfk_43`,
DROP FOREIGN KEY `operasi_ibfk_44`,
DROP FOREIGN KEY `operasi_ibfk_45`,
DROP FOREIGN KEY `operasi_ibfk_46`,
DROP FOREIGN KEY `operasi_ibfk_47`,
DROP FOREIGN KEY `operasi_ibfk_48`,
DROP FOREIGN KEY `operasi_ibfk_49`;
ALTER TABLE `operasi`
ADD CONSTRAINT `operasi_ibfk_32` FOREIGN KEY (`operator1`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_33` FOREIGN KEY (`operator2`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_34` FOREIGN KEY (`operator3`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_35` FOREIGN KEY (`asisten_operator1`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_36` FOREIGN KEY (`asisten_operator2`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_37` FOREIGN KEY (`instrumen`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_38` FOREIGN KEY (`dokter_anak`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_39` FOREIGN KEY (`perawaat_resusitas`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_40` FOREIGN KEY (`dokter_anestesi`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_41` FOREIGN KEY (`asisten_anestesi`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_42` FOREIGN KEY (`bidan`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_43` FOREIGN KEY (`perawat_luar`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_44` FOREIGN KEY (`kode_paket`) REFERENCES `paket_operasi` (`kode_paket`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_45` FOREIGN KEY (`bidan2`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_46` FOREIGN KEY (`bidan3`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_47` FOREIGN KEY (`omloop`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_48` FOREIGN KEY (`omloop2`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `operasi_ibfk_49` FOREIGN KEY (`omloop3`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `user`
ADD COLUMN `temporary_presensi` ENUM('true','false') NULL DEFAULT NULL AFTER `retensi_rm`,
ADD COLUMN `jurnal_harian` ENUM('true','false') NULL DEFAULT NULL AFTER `temporary_presensi`,
ADD COLUMN `sirkulasi_obat2` ENUM('true','false') NULL DEFAULT NULL AFTER `jurnal_harian`,
ADD COLUMN `edit_registrasi` ENUM('true','false') NULL DEFAULT NULL AFTER `sirkulasi_obat2`;
ALTER TABLE `paket_operasi`
ADD COLUMN `dokter_pjanak` DOUBLE NULL DEFAULT NULL AFTER `sarpras`,
ADD COLUMN `dokter_umum` DOUBLE NULL DEFAULT NULL AFTER `dokter_pjanak`,
ADD COLUMN `kd_pj` CHAR(3) NULL DEFAULT NULL AFTER `dokter_umum`,
ADD COLUMN `status` ENUM('0','1') NULL DEFAULT NULL AFTER `kd_pj`,
ADD CONSTRAINT `paket_operasi_ibfk_1` FOREIGN KEY (`kd_pj`) REFERENCES `penjab` (`kd_pj`) ON UPDATE CASCADE;
ALTER TABLE `databarang`
ADD COLUMN `status` ENUM('0','1') NULL AFTER `expire`;
ALTER TABLE `detailbeli`
ADD COLUMN `no_batch` VARCHAR(10) NOT NULL AFTER `total`;
ALTER TABLE `detailpesan`
ADD COLUMN `no_batch` VARCHAR(10) NOT NULL AFTER `total`;
ALTER TABLE `detreturbeli`
ADD COLUMN `no_batch` VARCHAR(10) NOT NULL AFTER `total`;
ALTER TABLE `detreturjual`
DROP PRIMARY KEY;
ALTER TABLE `dokter`
ADD COLUMN `status` ENUM('0','1') NOT NULL AFTER `no_ijn_praktek`;
ALTER TABLE `dpjp_ranap`
DROP FOREIGN KEY `dpjp_ranap_ibfk_2`;
ALTER TABLE `dpjp_ranap`
ADD CONSTRAINT `dpjp_ranap_ibfk_2` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `gudangbarang`
DROP FOREIGN KEY `gudangbarang_ibfk_2`;
ALTER TABLE `gudangbarang`
ADD CONSTRAINT `gudangbarang_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `hemodialisa`
DROP FOREIGN KEY `hemodialisa_ibfk_3`;
ALTER TABLE `hemodialisa`
ADD CONSTRAINT `hemodialisa_ibfk_3` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `jns_perawatan`
ADD COLUMN `status` ENUM('0','1') NOT NULL AFTER `kd_poli`;
ALTER TABLE `jns_perawatan_inap`
ADD COLUMN `status` ENUM('0','1') NOT NULL AFTER `kd_bangsal`;
ALTER TABLE `jns_perawatan_lab`
ADD COLUMN `status` ENUM('0','1') NOT NULL AFTER `kd_pj`;
ALTER TABLE `jns_perawatan_radiologi`
ADD COLUMN `status` ENUM('0','1') NOT NULL AFTER `kd_pj`;
ALTER TABLE `mutasibarang`
DROP FOREIGN KEY `mutasibarang_ibfk_1`;
ALTER TABLE `mutasibarang`
ADD CONSTRAINT `mutasibarang_ibfk_1` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `obat_penyakit`
DROP FOREIGN KEY `obat_penyakit_ibfk_2`;
ALTER TABLE `obat_penyakit`
ADD CONSTRAINT `obat_penyakit_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `opname`
DROP FOREIGN KEY `opname_ibfk_1`;
ALTER TABLE `opname`
ADD CONSTRAINT `opname_ibfk_1` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `paket_operasi`
DROP FOREIGN KEY `paket_operasi_ibfk_1`;
ALTER TABLE `paket_operasi`
ADD CONSTRAINT `paket_operasi_ibfk_1` FOREIGN KEY (`kd_pj`) REFERENCES `penjab` (`kd_pj`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `parkir`
DROP FOREIGN KEY `parkir_ibfk_1`,
DROP FOREIGN KEY `parkir_ibfk_2`;
ALTER TABLE `parkir`
ADD CONSTRAINT `parkir_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `parkir_ibfk_2` FOREIGN KEY (`kd_parkir`) REFERENCES `parkir_jenis` (`kd_parkir`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `pemasukan_lain`
DROP FOREIGN KEY `pemasukan_lain_ibfk_1`,
DROP FOREIGN KEY `pemasukan_lain_ibfk_2`;
ALTER TABLE `pemasukan_lain`
ADD CONSTRAINT `pemasukan_lain_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pemasukan_lain_ibfk_2` FOREIGN KEY (`kode_kategori`) REFERENCES `kategori_pemasukan_lain` (`kode_kategori`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `pembelian`
DROP FOREIGN KEY `pembelian_ibfk_1`,
DROP FOREIGN KEY `pembelian_ibfk_2`,
DROP FOREIGN KEY `pembelian_ibfk_3`,
DROP FOREIGN KEY `pembelian_ibfk_4`;
ALTER TABLE `pembelian`
ADD CONSTRAINT `pembelian_ibfk_1` FOREIGN KEY (`kode_suplier`) REFERENCES `datasuplier` (`kode_suplier`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pembelian_ibfk_2` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pembelian_ibfk_3` FOREIGN KEY (`kd_bangsal`) REFERENCES `bangsal` (`kd_bangsal`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pembelian_ibfk_4` FOREIGN KEY (`kd_rek`) REFERENCES `akun_bayar` (`kd_rek`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `pemesanan`
DROP FOREIGN KEY `pemesanan_ibfk_1`,
DROP FOREIGN KEY `pemesanan_ibfk_2`;
ALTER TABLE `pemesanan`
ADD CONSTRAINT `pemesanan_ibfk_1` FOREIGN KEY (`kode_suplier`) REFERENCES `datasuplier` (`kode_suplier`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pemesanan_ibfk_2` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `peminjaman_berkas`
DROP FOREIGN KEY `peminjaman_berkas_ibfk_2`,
DROP FOREIGN KEY `peminjaman_berkas_ibfk_3`;
ALTER TABLE `peminjaman_berkas`
ADD CONSTRAINT `peminjaman_berkas_ibfk_2` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `peminjaman_berkas_ibfk_3` FOREIGN KEY (`id_ruang`) REFERENCES `inventaris_ruang` (`id_ruang`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `pengeluaran_harian`
DROP FOREIGN KEY `pengeluaran_harian_ibfk_1`,
DROP FOREIGN KEY `pengeluaran_harian_ibfk_2`;
ALTER TABLE `pengeluaran_harian`
ADD CONSTRAINT `pengeluaran_harian_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `pengeluaran_harian_ibfk_2` FOREIGN KEY (`kode_kategori`) REFERENCES `kategori_pengeluaran_harian` (`kode_kategori`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `penjualan`
DROP FOREIGN KEY `penjualan_ibfk_11`,
DROP FOREIGN KEY `penjualan_ibfk_12`,
DROP FOREIGN KEY `penjualan_ibfk_9`;
ALTER TABLE `penjualan`
ADD CONSTRAINT `penjualan_ibfk_11` FOREIGN KEY (`kd_bangsal`) REFERENCES `bangsal` (`kd_bangsal`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `penjualan_ibfk_12` FOREIGN KEY (`kd_rek`) REFERENCES `akun_bayar` (`kd_rek`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `penjualan_ibfk_9` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `periksa_lab`
DROP FOREIGN KEY `periksa_lab_ibfk_10`,
DROP FOREIGN KEY `periksa_lab_ibfk_11`,
DROP FOREIGN KEY `periksa_lab_ibfk_12`,
DROP FOREIGN KEY `periksa_lab_ibfk_13`;
ALTER TABLE `periksa_lab`
ADD CONSTRAINT `periksa_lab_ibfk_10` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_lab_ibfk_11` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan_lab` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_lab_ibfk_12` FOREIGN KEY (`dokter_perujuk`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_lab_ibfk_13` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `periksa_radiologi`
DROP FOREIGN KEY `periksa_radiologi_ibfk_5`,
DROP FOREIGN KEY `periksa_radiologi_ibfk_6`,
DROP FOREIGN KEY `periksa_radiologi_ibfk_7`,
DROP FOREIGN KEY `periksa_radiologi_ibfk_8`;
ALTER TABLE `periksa_radiologi`
ADD CONSTRAINT `periksa_radiologi_ibfk_5` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_radiologi_ibfk_6` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan_radiologi` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_radiologi_ibfk_7` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `periksa_radiologi_ibfk_8` FOREIGN KEY (`dokter_perujuk`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `petugas`
CHANGE COLUMN `password` `status` ENUM('0','1') NULL DEFAULT NULL AFTER `no_telp`;
ALTER TABLE `piutang`
DROP FOREIGN KEY `piutang_ibfk_1`,
DROP FOREIGN KEY `piutang_ibfk_3`;
ALTER TABLE `piutang`
ADD CONSTRAINT `piutang_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `piutang_ibfk_3` FOREIGN KEY (`kd_bangsal`) REFERENCES `bangsal` (`kd_bangsal`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rawat_inap_dr`
DROP FOREIGN KEY `rawat_inap_dr_ibfk_3`,
DROP FOREIGN KEY `rawat_inap_dr_ibfk_6`;
ALTER TABLE `rawat_inap_dr`
ADD CONSTRAINT `rawat_inap_dr_ibfk_3` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_inap_dr_ibfk_6` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan_inap` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rawat_inap_drpr`
DROP FOREIGN KEY `rawat_inap_drpr_ibfk_2`,
DROP FOREIGN KEY `rawat_inap_drpr_ibfk_3`,
DROP FOREIGN KEY `rawat_inap_drpr_ibfk_4`;
ALTER TABLE `rawat_inap_drpr`
ADD CONSTRAINT `rawat_inap_drpr_ibfk_2` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan_inap` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_inap_drpr_ibfk_3` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_inap_drpr_ibfk_4` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rawat_inap_pr`
DROP FOREIGN KEY `rawat_inap_pr_ibfk_3`,
DROP FOREIGN KEY `rawat_inap_pr_ibfk_6`;
ALTER TABLE `rawat_inap_pr`
ADD CONSTRAINT `rawat_inap_pr_ibfk_3` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_inap_pr_ibfk_6` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan_inap` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rawat_jl_dr`
DROP FOREIGN KEY `rawat_jl_dr_ibfk_2`,
DROP FOREIGN KEY `rawat_jl_dr_ibfk_3`;
ALTER TABLE `rawat_jl_dr`
ADD CONSTRAINT `rawat_jl_dr_ibfk_2` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_jl_dr_ibfk_3` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rawat_jl_drpr`
DROP FOREIGN KEY `rawat_jl_drpr_ibfk_2`,
DROP FOREIGN KEY `rawat_jl_drpr_ibfk_3`,
DROP FOREIGN KEY `rawat_jl_drpr_ibfk_4`;
ALTER TABLE `rawat_jl_drpr`
ADD CONSTRAINT `rawat_jl_drpr_ibfk_2` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_jl_drpr_ibfk_3` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_jl_drpr_ibfk_4` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rawat_jl_pr`
DROP FOREIGN KEY `rawat_jl_pr_ibfk_10`,
DROP FOREIGN KEY `rawat_jl_pr_ibfk_9`;
ALTER TABLE `rawat_jl_pr`
ADD CONSTRAINT `rawat_jl_pr_ibfk_10` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `rawat_jl_pr_ibfk_9` FOREIGN KEY (`kd_jenis_prw`) REFERENCES `jns_perawatan` (`kd_jenis_prw`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `reg_periksa`
DROP FOREIGN KEY `reg_periksa_ibfk_3`,
DROP FOREIGN KEY `reg_periksa_ibfk_4`,
DROP FOREIGN KEY `reg_periksa_ibfk_6`;
ALTER TABLE `reg_periksa`
ADD CONSTRAINT `reg_periksa_ibfk_3` FOREIGN KEY (`kd_poli`) REFERENCES `poliklinik` (`kd_poli`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `reg_periksa_ibfk_4` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `reg_periksa_ibfk_6` FOREIGN KEY (`kd_pj`) REFERENCES `penjab` (`kd_pj`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `resep_obat`
DROP FOREIGN KEY `resep_obat_ibfk_4`;
ALTER TABLE `resep_obat`
ADD CONSTRAINT `resep_obat_ibfk_4` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `resep_pulang`
DROP FOREIGN KEY `resep_pulang_ibfk_2`;
ALTER TABLE `resep_pulang`
ADD CONSTRAINT `resep_pulang_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `returbeli`
DROP FOREIGN KEY `returbeli_ibfk_2`,
DROP FOREIGN KEY `returbeli_ibfk_3`,
DROP FOREIGN KEY `returbeli_ibfk_4`;
ALTER TABLE `returbeli`
ADD CONSTRAINT `returbeli_ibfk_2` FOREIGN KEY (`kode_suplier`) REFERENCES `datasuplier` (`kode_suplier`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `returbeli_ibfk_3` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `returbeli_ibfk_4` FOREIGN KEY (`kd_bangsal`) REFERENCES `bangsal` (`kd_bangsal`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `returpasien`
DROP FOREIGN KEY `returpasien_ibfk_4`;
ALTER TABLE `returpasien`
ADD CONSTRAINT `returpasien_ibfk_4` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `returpiutang`
DROP FOREIGN KEY `returpiutang_ibfk_3`,
DROP FOREIGN KEY `returpiutang_ibfk_5`;
ALTER TABLE `returpiutang`
ADD CONSTRAINT `returpiutang_ibfk_3` FOREIGN KEY (`nip`) REFERENCES `petugas` (`nip`) ON UPDATE CASCADE ON DELETE CASCADE,
ADD CONSTRAINT `returpiutang_ibfk_5` FOREIGN KEY (`kd_bangsal`) REFERENCES `bangsal` (`kd_bangsal`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rujuk`
DROP FOREIGN KEY `rujuk_ibfk_2`;
ALTER TABLE `rujuk`
ADD CONSTRAINT `rujuk_ibfk_2` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `rujukanranap_dokter_rs`
DROP FOREIGN KEY `rujukanranap_dokter_rs_ibfk_1`;
ALTER TABLE `rujukanranap_dokter_rs`
ADD CONSTRAINT `rujukanranap_dokter_rs_ibfk_1` FOREIGN KEY (`kd_dokter`) REFERENCES `dokter` (`kd_dokter`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `set_nota`
ADD COLUMN `tampilkan_tombol_nota_ralan` ENUM('Yes','No') NULL DEFAULT NULL AFTER `tampilkan_ppnobat_ranap`,
ADD COLUMN `tampilkan_tombol_nota_ranap` ENUM('Yes','No') NULL DEFAULT NULL AFTER `tampilkan_tombol_nota_ralan`;
ALTER TABLE `set_tarif`
ADD COLUMN `cara_bayar_operasi` ENUM('Yes','No') NULL DEFAULT NULL AFTER `cara_bayar_radiologi`;
ALTER TABLE `stok_obat_pasien`
DROP FOREIGN KEY `stok_obat_pasien_ibfk_2`;
ALTER TABLE `stok_obat_pasien`
ADD CONSTRAINT `stok_obat_pasien_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `tampreturbeli`
ADD COLUMN `no_batch` VARCHAR(10) NOT NULL AFTER `total`;
ALTER TABLE `tampreturbeli`
DROP FOREIGN KEY `tampreturbeli_ibfk_2`;
ALTER TABLE `tampreturbeli`
ADD CONSTRAINT `tampreturbeli_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `tampreturjual`
DROP FOREIGN KEY `tampreturjual_ibfk_3`;
ALTER TABLE `tampreturjual`
ADD CONSTRAINT `tampreturjual_ibfk_3` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE `tampreturpiutang`
DROP FOREIGN KEY `tampreturpiutang_ibfk_2`;
ALTER TABLE `tampreturpiutang`
ADD CONSTRAINT `tampreturpiutang_ibfk_2` FOREIGN KEY (`kode_brng`) REFERENCES `databarang` (`kode_brng`) ON UPDATE CASCADE ON DELETE CASCADE;
update dokter set status='1';
update paket_operasi set status='1';
update databarang set status='1';
update jns_perawatan set status='1';
update jns_perawatan_inap set status='1';
update jns_perawatan_lab set status='1';
update jns_perawatan_radiologi set status='1';
update petugas set status='1';
3. Klik go, tunggu sampai selesai
Semoga berguna
0 komentar:
Posting Komentar