20190717_8888

CREATE TABLE `realisasih` (
    `idrealisasih` VARCHAR(50) NOT NULL DEFAULT '',
    `idpoh` VARCHAR(50) NOT NULL DEFAULT '',
    `tgl` DATE NULL DEFAULT '0000-00-00',
    `jam` TIME NULL DEFAULT NULL,
    `kodecustomer` VARCHAR(10) NULL DEFAULT NULL,
    `userid` VARCHAR(10) NULL DEFAULT NULL,
    `userid_edit` VARCHAR(10) NULL DEFAULT NULL,
    `ket` VARCHAR(255) NULL DEFAULT '0',
    PRIMARY KEY (`idrealisasih`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
ROW_FORMAT=DYNAMIC
;
CREATE TABLE `realisasid` (
    `idrealisasid` INT(11) NOT NULL AUTO_INCREMENT,
    `idrealisasih` VARCHAR(50) NULL DEFAULT NULL,
    `idpoh` VARCHAR(50) NULL DEFAULT NULL,
    `kodebarang` VARCHAR(20) NULL DEFAULT NULL,
    `qty` DOUBLE NULL DEFAULT 0,
    `satuan` VARCHAR(20) NULL DEFAULT NULL,
    PRIMARY KEY (`idrealisasid`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
ROW_FORMAT=DYNAMIC
AUTO_INCREMENT=0
;
CREATE TABLE `poh` (
    `idpoh` VARCHAR(50) NOT NULL DEFAULT '',
    `tgl` DATE NULL DEFAULT '0000-00-00',
    `jam` TIME NULL DEFAULT NULL,
    `kodecustomer` VARCHAR(10) NULL DEFAULT NULL,
    `userid` VARCHAR(10) NULL DEFAULT NULL,
    `userid_edit` VARCHAR(10) NULL DEFAULT NULL,
    `ket` VARCHAR(255) NULL DEFAULT '0',
    `realisasi` VARCHAR(2) NULL DEFAULT 'T',
    PRIMARY KEY (`idpoh`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
ROW_FORMAT=DYNAMIC
;
CREATE TABLE `pod` (
    `idpod` INT(11) NOT NULL AUTO_INCREMENT,
    `idpoh` VARCHAR(50) NULL DEFAULT NULL,
    `kodebarang` VARCHAR(20) NULL DEFAULT NULL,
    `qty` DOUBLE NULL DEFAULT 0,
    `qtyp` DOUBLE NULL DEFAULT 0,
    `satuan` VARCHAR(20) NULL DEFAULT NULL,
    `harga` DOUBLE NULL DEFAULT 0,
    `discpersen` DOUBLE NULL DEFAULT 0,
    `disc` DOUBLE NULL DEFAULT 0,
    `ndisc` DOUBLE NULL DEFAULT 0,
    `jumlah` DOUBLE NULL DEFAULT 0,
    `im` INT(11) NULL DEFAULT 1,
    PRIMARY KEY (`idpod`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
ROW_FORMAT=DYNAMIC
AUTO_INCREMENT=0
;
CREATE TABLE `orderpabrikh` (
    `idorderpabrikh` VARCHAR(50) NOT NULL DEFAULT '',
    `idrealisasih` VARCHAR(50) NOT NULL DEFAULT '',
    `idpoh` VARCHAR(50) NOT NULL DEFAULT '',
    `tgl` DATE NULL DEFAULT '0000-00-00',
    `jam` TIME NULL DEFAULT NULL,
    `kodecustomer` VARCHAR(10) NULL DEFAULT NULL,
    `userid` VARCHAR(10) NULL DEFAULT NULL,
    `userid_edit` VARCHAR(10) NULL DEFAULT NULL,
    `ket` VARCHAR(255) NULL DEFAULT '0',
    PRIMARY KEY (`idorderpabrikh`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
ROW_FORMAT=DYNAMIC
;
CREATE TABLE `orderpabrikd` (
    `idorderpabrikd` INT(11) NOT NULL AUTO_INCREMENT,
    `idorderpabrikh` VARCHAR(50) NULL DEFAULT NULL,
    `kodebarang` VARCHAR(20) NULL DEFAULT NULL,
    `idpoh` VARCHAR(50) NULL DEFAULT NULL,
    `qty` DOUBLE NULL DEFAULT 0,
    `satuan` VARCHAR(20) NULL DEFAULT NULL,
    PRIMARY KEY (`idorderpabrikd`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
ROW_FORMAT=DYNAMIC
AUTO_INCREMENT=0
;

CREATE TABLE `customer` (
    `kodecustomer` CHAR(20) NOT NULL DEFAULT '',
    `namacustomer` VARCHAR(50) NULL DEFAULT NULL,
    `alamat` VARCHAR(50) NULL DEFAULT NULL,
    `kota` VARCHAR(30) NULL DEFAULT NULL,
    `phone` VARCHAR(30) NULL DEFAULT NULL,
    `fax` VARCHAR(30) NULL DEFAULT NULL,
    `kontak` VARCHAR(30) NULL DEFAULT NULL,
    `hp` VARCHAR(30) NULL DEFAULT NULL,
    `tempo` INT(11) NULL DEFAULT 0,
    `plafon` INT(11) NULL DEFAULT 0,
    `level` CHAR(1) NULL DEFAULT '1',
    PRIMARY KEY (`kodecustomer`)
)
COLLATE='latin1_swedish_ci'
ENGINE=MyISAM
ROW_FORMAT=DYNAMIC
;


trigger realisasid before insert
BEGIN
update pod set qtyp = qtyp + new.qty where idpoh = new.idpoh and kodebarang = new.kodebarang;
update barang4 set stok = stok - new.qty where kodebarang = new.kodebarang;
END