INSERT INTO `tmenu` (`menu_id`, `menu`, `keterangan`, `Status_aktive`) VALUES ('120000', 'delivery1', 'Delivery', '1'); INSERT INTO `tmenu` (`menu_id`, `menu`, `keterangan`, `Status_aktive`) VALUES ('120100', 'deliverymaster1', 'Delivery Master','1'); INSERT INTO `tmenu` (`menu_id`, `menu`, `keterangan`, `Status_aktive`) VALUES ('120101', 'deliverymastergol1', 'Delivery Master Golongan', '1'); INSERT INTO `tmenu` (`menu_id`, `menu`, `keterangan`, `Status_aktive`) VALUES ('120102', 'deliverymasterbrand1', 'Delivery Master Brand', '1'); INSERT INTO `tmenu` (`menu_id`, `menu`, `keterangan`, `Status_aktive`) VALUES ('120103', 'deliverymasterbrg1', 'Delivery Master Barang', '1'); INSERT INTO `tmenu` (`menu_id`, `menu`, `keterangan`, `Status_aktive`) VALUES ('120104', 'deliverymasterpromo1', 'Delivery Master Promo', '1'); INSERT INTO `tmenu` (`menu_id`, `menu`, `keterangan`, `Status_aktive`) VALUES ('120200', 'deliveryorder1', 'Delivery Order', '1'); INSERT INTO `tuserlevel` (`userlevel_id`, `menu`, `status`, `Ket_level`) VALUES ('01', '120000', '1', 'MANAGER'); INSERT INTO `tuserlevel` (`userlevel_id`, `menu`, `status`, `Ket_level`) VALUES ('01', '120100', '1', 'MANAGER'); INSERT INTO `tuserlevel` (`userlevel_id`, `menu`, `status`, `Ket_level`) VALUES ('01', '120101', '1', 'MANAGER'); INSERT INTO `tuserlevel` (`userlevel_id`, `menu`, `status`, `Ket_level`) VALUES ('01', '120102', '1', 'MANAGER'); INSERT INTO `tuserlevel` (`userlevel_id`, `menu`, `status`, `Ket_level`) VALUES ('01', '120103', '1', 'MANAGER'); INSERT INTO `tuserlevel` (`userlevel_id`, `menu`, `status`, `Ket_level`) VALUES ('01', '120104', '1', 'MANAGER'); INSERT INTO `tuserlevel` (`userlevel_id`, `menu`, `status`, `Ket_level`) VALUES ('01', '120200', '1', 'MANAGER'); ALTER TABLE `tr_jualr_m` ADD COLUMN `Ongkir` double NULL AFTER `NamaCard`; ALTER TABLE `tr_jualr_m` ADD COLUMN `isDeliveryOrder` varchar(2) NULL DEFAULT 'N' AFTER `PotonganPointNilai`; ALTER TABLE `tr_jualr_m` ADD COLUMN `KodeDeliveryOrder` varchar(25) NULL AFTER `isDeliveryOrder`;