Skip to content

Instantly share code, notes, and snippets.

@devifr
Created November 8, 2019 01:43
Show Gist options
  • Save devifr/374735078731bfff610c02ea1f7794d8 to your computer and use it in GitHub Desktop.
Save devifr/374735078731bfff610c02ea1f7794d8 to your computer and use it in GitHub Desktop.
Tambah Column
ALTER TABLE `tb_final_register` ADD `no_bukpot` INT NOT NULL AFTER `nm_pemotong`;
ALTER TABLE `tb_non_final_register` ADD `no_bukpot` INT NOT NULL AFTER `tgl_bukti_potong`;
ALTER TABLE `tb_register_penghasilan` ADD `jumlah_penerima` INT(20) NOT NULL AFTER `ket_ssp`;
ALTER TABLE `tb_jenis_penghasilan` CHANGE `kd_satker` `tipe_bukpot` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE `tb_bayar_ptt` ADD `no_daftar` VARCHAR(45) NOT NULL AFTER `unit_pembayar`;
ALTER TABLE `tb_ppnpn` ADD `no_spp` VARCHAR(45) NOT NULL AFTER `idptt`;
ALTER TABLE `pegawai` ADD `unit_kerja` VARCHAR(45) NOT NULL AFTER `password`;
ALTER TABLE `tb_final_register` ADD `unit_kerja` VARCHAR(45) NOT NULL AFTER `no_bukpot`;
Perbaiki yang sudah Masuk
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment