CREATE TABLE IF NOT EXISTS `snl_user` (
	`user_id` INT(11) NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(255),
	`username` VARCHAR(255),
	`password` VARCHAR(255),
	`role_id` INT(11) DEFAULT 0,
	`created_on` DATETIME DEFAULT NULL,
	`updated_on` DATETIME DEFAULT NULL,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0=No; 1=Yes',
	PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `snl_role` (
	`role_id` INT(11) NOT NULL AUTO_INCREMENT,
	`role` VARCHAR(255),
	`created_on` DATETIME,
	`updated_on` DATETIME,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0=No; 1=Yes',
	PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `snl_city` (
	`city_id` INT(11) NOT NULL AUTO_INCREMENT,
	`city_name` VARCHAR(255),
	`created_on` DATETIME,
	`updated_on` DATETIME,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0=No; 1=Yes',
	PRIMARY KEY (`city_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `snl_user_city` (
	`user_city_id` INT(11) NOT NULL AUTO_INCREMENT,
	`user_id` INT(11),
	`city_id` INT(11),
	PRIMARY KEY (`user_city_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `snl_ingredient` (
	`ingredient_id` INT(11) NOT NULL AUTO_INCREMENT,
	`ingredient_name` VARCHAR(255),
	`created_on` DATETIME,
	`updated_on` DATETIME,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0=No; 1=Yes',
	PRIMARY KEY (`ingredient_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `snl_ingredient_stock_price` (
	`ingredient_stock_price_id` INT(11) NOT NULL AUTO_INCREMENT,
	`ingredient_id` INT(11),
	`stock` DECIMAL(16,2) COMMENT 'Stock is in kg',
	`price` DECIMAL(16,2) COMMENT 'Price / kg',
	`created_on` DATETIME,
	`updated_on` DATETIME,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0=No; 1=Yes',
	PRIMARY KEY (`ingredient_stock_price_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `snl_ingredient` ADD `city_id` INT(11) AFTER `ingredient_id`;

CREATE TABLE IF NOT EXISTS `snl_product` (
	`product_id` INT(11) NOT NULL AUTO_INCREMENT,
	`city_id` INT(11),
	`name` VARCHAR(255),
	`qty` DECIMAL(16,2),
	`hpp` DECIMAL(16,2),
	`created_on` DATETIME,
	`updated_on` DATETIME,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0=No; 1=Yes',
	PRIMARY KEY (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `snl_product` ADD `estimate_qty` DECIMAL(16,2) AFTER `hpp`;
ALTER TABLE `snl_product` ADD `production_cost` DECIMAL(16,2) AFTER `estimate_qty`;

CREATE TABLE IF NOT EXISTS `snl_production` (
	`production_id` INT(11) NOT NULL AUTO_INCREMENT,
	`product_id` INT(11),
	`production_cost` DECIMAL(16,2),
	`other_cost` DECIMAL(16,2),
	`qty` DECIMAL(16,2),
	`hpp` DECIMAL(16,2),
	`estimate_qty` DECIMAL(16,2),
	`created_on` DATETIME,
	`updated_on` DATETIME,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0=No; 1=Yes',
	PRIMARY KEY (`production_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `snl_production_detail` (
	`production_detail_id` INT(11) NOT NULL AUTO_INCREMENT,
	`production_id` INT(11),
	`ingredient_id` INT(11),
	`ingredient_stock_price_id` INT(11),
	`qty` DECIMAL(16,2),
	`price` DECIMAL(16,2) COMMENT 'Price / kg',
	`created_on` DATETIME,
	`updated_on` DATETIME,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0=No; 1=Yes',
	PRIMARY KEY (`production_detail_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `snl_production` ADD `ingredient_cost` DECIMAL(16,2) AFTER `production_cost`;
ALTER TABLE `snl_production` ADD `status` VARCHAR(255) AFTER `estimate_qty`;

CREATE TABLE IF NOT EXISTS `snl_customer` (
	`customer_id` INT(11) NOT NULL AUTO_INCREMENT,
	`city_id` INT(11),
	`name` VARCHAR(255),
	`address` VARCHAR(255),
	`telp` VARCHAR(255),
	`created_on` DATETIME,
	`updated_on` DATETIME,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0=No; 1=Yes',
	PRIMARY KEY (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `snl_order` (
	`order_id` INT(11) NOT NULL AUTO_INCREMENT,
	`customer_id` INT(11),
	`date_order` DATETIME,
	`status` VARCHAR(255),
	`total` DECIMAL(16,2),
	`payment` DECIMAL(16,2),
	`created_on` DATETIME,
	`updated_on` DATETIME,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0=No; 1=Yes',
	PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `snl_order_detail` (
	`order_detail_id` INT(11) NOT NULL AUTO_INCREMENT,
	`order_id` INT(11),
	`production_id` INT(11),
	`product_id` INT(11),
	`qty` DECIMAL(16,2),
	`hpp` DECIMAL(16,2),
	`status` VARCHAR(255),
	`created_on` DATETIME,
	`updated_on` DATETIME,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0=No; 1=Yes',
	PRIMARY KEY (`order_detail_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `snl_order_return` (
	`order_return_id` INT(11) NOT NULL AUTO_INCREMENT,
	`order_detail_id` INT(11),
	`date_return` DATETIME,
	`remark` TEXT,
	`qty` DECIMAL(16,2),
	`created_on` DATETIME,
	`updated_on` DATETIME,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0=No; 1=Yes',
	PRIMARY KEY (`order_return_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `snl_order_payment` (
	`order_payment_id` INT(11) NOT NULL AUTO_INCREMENT,
	`order_id` INT(11),
	`date_payment` DATETIME,
	`total_payment` DECIMAL(16,2),
	`created_on` DATETIME,
	`updated_on` DATETIME,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0=No; 1=Yes',
	PRIMARY KEY (`order_payment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `snl_operation` (
	`operation_id` INT(11) NOT NULL AUTO_INCREMENT,
	`module` VARCHAR(255),
	`page` VARCHAR(255),
	`label` VARCHAR(255),
	PRIMARY KEY (`operation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `snl_role_detail` (
	`role_detail_id` INT(11) NOT NULL AUTO_INCREMENT,
	`role_id` INT(11),
	`operation_id` INT(11),
	`created_on` DATETIME,
	`updated_on` DATETIME,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	`is_deleted` TINYINT(1) DEFAULT 0 COMMENT '0=No; 1=Yes',
	PRIMARY KEY (`role_detail_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `snl_master_jurnal` (
	`master_jurnal_id` INT(11) NOT NULL AUTO_INCREMENT,
	`city_id` INT(11) DEFAULT NULL,
	`kode_jurnal` VARCHAR(255) DEFAULT NULL,
	`keterangan` TEXT DEFAULT NULL,
	`tipe_laporan` VARCHAR(255) DEFAULT NULL,
	`tipe_jurnal` VARCHAR(255) DEFAULT NULL,
	PRIMARY KEY (`master_jurnal_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `snl_jurnal_transaksi` (
	`jurnal_transaksi_id` INT(11) NOT NULL AUTO_INCREMENT,
	`ref` INT(11) DEFAULT NULL,
	`city_id` INT(11) DEFAULT NULL,
	`kode_jurnal` VARCHAR(255) DEFAULT NULL,
	`keterangan` TEXT DEFAULT NULL,
	`tipe_jurnal` VARCHAR(255) DEFAULT NULL,
	`operand` ENUM('plus', 'minus') DEFAULT NULL,
	`nominal` DECIMAL(16, 2) DEFAULT 0,
	`created_on` DATETIME DEFAULT NULL,
	`updated_on` DATETIME DEFAULT NULL,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	PRIMARY KEY (`jurnal_transaksi_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `snl_ingredient_purchase` (
	`ingredient_purchase_id` INT(11) NOT NULL AUTO_INCREMENT,
	`jurnal_transaksi_id` INT(11),
	`ingredient_id` INT(11) DEFAULT NULL,
	`qty` DECIMAL(16, 2) DEFAULT 0,
	`price` DECIMAL(16, 2) DEFAULT 0,
	`created_on` DATETIME DEFAULT NULL,
	`updated_on` DATETIME DEFAULT NULL,
	`created_by` INT(11) DEFAULT NULL,
	`updated_by` INT(11) DEFAULT NULL,
	PRIMARY KEY (`ingredient_purchase_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `snl_production` ADD `jurnal_transaksi_id` INT(11) DEFAULT NULL AFTER `production_id`;
ALTER TABLE `snl_order` ADD `jurnal_transaksi_id` INT(11) DEFAULT NULL AFTER `order_id`;
ALTER TABLE `snl_order_payment` ADD `jurnal_transaksi_ids` VARCHAR(255) DEFAULT NULL AFTER `order_payment_id`;
ALTER TABLE `snl_order_return` ADD `jurnal_transaksi_ids` VARCHAR(255) DEFAULT NULL AFTER `order_return_id`;
ALTER TABLE `snl_purchase` ADD `jurnal_transaksi_id` INT(11) DEFAULT NULL AFTER `purchase_id`;

INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('user', 'list', 'Lihat Daftar User');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('user', 'create', 'Buat User');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('user', 'update', 'Edit User');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('user', 'delete', 'Delete User');

INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('city', 'list', 'Lihat Daftar Kota');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('city', 'create', 'Buat Kota');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('city', 'update', 'Edit Kota');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('city', 'delete', 'Delete Kota');

INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('customer', 'list', 'Lihat Daftar Customer');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('customer', 'create', 'Buat Customer');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('customer', 'update', 'Edit Customer');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('customer', 'delete', 'Delete Customer');

INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('ingredient', 'list', 'Lihat Daftar Bahan Baku');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('ingredient', 'create', 'Buat Bahan Baku');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('ingredient', 'update', 'Edit Bahan Baku');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('ingredient', 'delete', 'Delete Bahan Baku');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('ingredient', 'view', 'Lihat Detail Bahan Baku');

INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('product', 'list', 'Lihat Daftar Produk');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('product', 'create', 'Buat Produk');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('product', 'update', 'Edit Produk');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('product', 'delete', 'Delete Produk');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('product', 'view', 'Lihat Detail Produk');

INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('order', 'list', 'Lihat Daftar Pesanan');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('order', 'create', 'Buat Pesanan');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('order', 'update', 'Edit Pesanan');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('order', 'delete', 'Delete Pesanan');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('order', 'view', 'Lihat Detail Pesanan');

INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('report', 'view', 'Lihat Semua Laporan');
INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('report', 'customer', 'Lihat Laporan per Customer');

INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('main', 'dashboard', 'Lihat Ringkasan');


INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '101000', 'KAS', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '101001', 'KAS SBY', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '101002', 'KAS JKT', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '101003', 'KAS BALI', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '101004', 'KAS MLG', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '102000', 'PERSEDIAAN BAHAN BAKU ', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '102001', 'PERSEDIAAN BAHAN BAKU SBY', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '102002', 'PERSEDIAAN BAHAN BAKU JKT', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '102003', 'PERSEDIAAN BAHAN BAKU BALI', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '102004', 'PERSEDIAAN BAHAN BAKU MLG', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '102100', 'PERSEDIAAN BAHAN JADI', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '102101', 'PERSEDIAAN BAHAN JADI SBY', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '102102', 'PERSEDIAAN BAHAN JADI JKT', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '102103', 'PERSEDIAAN BAHAN JADI BALI', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '102104', 'PERSEDIAAN BAHAN JADI MLG', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '103000', 'PIUTANG', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '103001', 'PIUTANG SBY', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '103002', 'PIUTANG JKT', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '103003', 'PIUTANG BALI', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '103004', 'PIUTANG MLG', 'NERACA', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '300000', 'MODAL', 'NERACA', 'Kredit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '300001', 'MODAL SBY', 'NERACA', 'Kredit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '300002', 'MODAL JKT', 'NERACA', 'Kredit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '300003', 'MODAL BALI', 'NERACA', 'Kredit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '300004', 'MODAL MLG', 'NERACA', 'Kredit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '400000', 'PENJUALAN ', 'LABA RUGI', 'Kredit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '400001', 'PENJUALAN SBY', 'LABA RUGI', 'Kredit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '400002', 'PENJUALAN JKT', 'LABA RUGI', 'Kredit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '400003', 'PENJUALAN BALI', 'LABA RUGI', 'Kredit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '400004', 'PENJUALAN MLG', 'LABA RUGI', 'Kredit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '401000', 'RETUR PENJUALAN', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '401001', 'RETUR PENJUALAN SBY', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '401002', 'RETUR PENJUALAN JKT', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '401003', 'RETUR PENJUALAN BALI', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '401004', 'RETUR PENJUALAN MLG', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '402000', 'POTONGAN PENJUALAN ', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '402001', 'POTONGAN PENJUALAN SBY', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '402002', 'POTONGAN PENJUALAN JKT', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '402003', 'POTONGAN PENJUALAN BALI', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '402004', 'POTONGAN PENJUALAN MLG', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '600000', 'HARGA POKOK PENJUALAN', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '600001', 'HARGA POKOK PENJUALAN SBY', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '600002', 'HARGA POKOK PENJUALAN JKT', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '600003', 'HARGA POKOK PENJUALAN BALI', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '600004', 'HARGA POKOK PENJUALAN MLG', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '700000', 'PENGELUARAN', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '700001', 'PENGELUARAN SBY', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '700002', 'PENGELUARAN JKT', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '700003', 'PENGELUARAN BALI', 'LABA RUGI', 'Debit');
INSERT INTO snl_master_jurnal (city_id, kode_jurnal, keterangan, tipe_laporan, tipe_jurnal) VALUES ('', '700004', 'PENGELUARAN MLG', 'LABA RUGI', 'Debit');

ALTER TABLE `snl_product` ADD `code` VARCHAR(255) DEFAULT NULL AFTER `name`;

INSERT INTO `snl_operation` (`module`, `page`, `label`) VALUES ('order', 'changestatus', 'Ubah Status Order');

ALTER TABLE `snl_order` ADD `remarks` VARCHAR(255) DEFAULT NULL AFTER `total_original`;