CREATE TABLE JOURNAL_REK
(
  THN	CHAR(4) DEFAULT '2016' NOT NULL,
  BLN	CHAR(2) DEFAULT '09' NOT NULL,
  THN_BLN	CHAR(6) DEFAULT '092016' NOT NULL,
  REKENING	CHAR(20) DEFAULT '-' NOT NULL,
  URAIAN	CHAR(50) DEFAULT '-' NOT NULL,
  UP_REK	CHAR(20) DEFAULT '-' NOT NULL,
  SALDO	DECIMAL(15, 2) DEFAULT 0 NOT NULL,
  DEBET	DECIMAL(15, 2) DEFAULT 0 NOT NULL,
  KREDIT	DECIMAL(15, 2) DEFAULT 0 NOT NULL,
  DEBET_FS	DECIMAL(15, 2) DEFAULT 0 NOT NULL,
  KREDIT_FS	DECIMAL(15, 2) DEFAULT 0 NOT NULL,
  REKX	CHAR(20) DEFAULT '-' NOT NULL,
 PRIMARY KEY (THN, BLN, THN_BLN, REKENING)
);


DROP TRIGGER INS_JOURNAL_REK;
DELIMITER //
CREATE TRIGGER INS_JOURNAL_REK
BEFORE INSERT ON JOURNAL_REK FOR EACH ROW
BEGIN
  SET NEW.THN_BLN=TRIM(NEW.THN)||TRIM(NEW.BLN);
END//
DELIMITER ;