CREATE TABLE `additional_umut_approval` (
	`id` Int( 11 ) UNSIGNED AUTO_INCREMENT NOT NULL,
	`approval_type` VarChar( 12 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0' COMMENT 'data ini di ambil dari ref_approval_type',
	`approval_status` Enum( '0', '1', '2', '3', '4' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0' COMMENT '0=> none
1=> waiting Approval
2= > approved
3=>revised
4=>rejected',
	`approval_date` DateTime NULL DEFAULT CURRENT_TIMESTAMP,
	`approval_level` TinyInt( 1 ) UNSIGNED NOT NULL,
	`is_last_approval` Enum( '1', '0' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
	`reject_comment` Text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
	`delegate` VarChar( 12 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
	`approved_by` VarChar( 12 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 'ini di isi nik yang akan approved ',
	`is_group` Enum( '0', '1' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
	`additional_umut_id` Int( 11 ) UNSIGNED NOT NULL,
	`days_limit_approval` Int( 10 ) NULL,
	`is_limit_approval` Enum( '0', '1' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
	PRIMARY KEY ( `id` ) )
CHARACTER SET = latin1
COLLATE = latin1_swedish_ci
ENGINE = InnoDB
AUTO_INCREMENT = 1;

CREATE TABLE `additional_umut_group_approval` (
	`id` Int( 11 ) UNSIGNED AUTO_INCREMENT NOT NULL,
	`nik_app` VarChar( 12 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
	`additional_umut_approval_id` Int( 11 ) UNSIGNED NOT NULL,
	PRIMARY KEY ( `id` ) )
CHARACTER SET = latin1
COLLATE = latin1_swedish_ci
ENGINE = InnoDB
AUTO_INCREMENT = 1;

ALTER TABLE `additional_umut_approval`
	ADD CONSTRAINT `fk_additional_umut_additional_umut_approval` FOREIGN KEY ( `additional_umut_id` )
	REFERENCES `additional_umut`( `id` )
	ON DELETE Cascade
	ON UPDATE Cascade;


ALTER TABLE `additional_umut_group_approval`
	ADD CONSTRAINT `fk_additional_umut_approval_additional_umut_group_approval` FOREIGN KEY ( `additional_umut_approval_id` )
	REFERENCES `additional_umut_approval`( `id` )
	ON DELETE Cascade
	ON UPDATE Cascade;