CREATE TABLE `ks_option` (
	`option_code` VARCHAR(64) NOT NULL,
	`option_desc` TEXT NULL,
	`option_group` VARCHAR(64) NULL DEFAULT NULL,
	`option_value` LONGTEXT NULL,
	`option_readonly` TINYINT(1) NOT NULL DEFAULT '0',
	PRIMARY KEY (`option_code`)
)
COMMENT='Store options either in string, numbers or serialized'
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;

//permohonan lampiran penerima eft
ALTER TABLE `t_permohonan`
	ADD COLUMN `per_lampiran_eft` VARCHAR(255) NULL DEFAULT NULL AFTER `per_kewangan_tarikhwaran`,
	ADD COLUMN `per_lampiran_eft_date` DATETIME NULL DEFAULT NULL AFTER `per_lampiran_eft`;

//CR TOT tambah no rujukan
ALTER TABLE `t_permohonan`
	ADD COLUMN `per_no_rujukan` VARCHAR(255) NULL DEFAULT NULL AFTER `per_kewangan_tarikhwaran`,
	ADD COLUMN `per_no_rujukan_date` DATETIME NULL DEFAULT NULL AFTER `per_no_rujukan`;

//CR TOT S.K 
ALTER TABLE `t_pemohon`
	ADD COLUMN `pem_sk` TEXT NULL DEFAULT NULL COMMENT 'Untuk Kegunaan Surat Kelulusan (S.K)' AFTER `pem_alamat3`;

 
CREATE TABLE IF NOT EXISTS `t_ref_nama_pengarah` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`nama` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`is_aktif` SMALLINT(6) NULL DEFAULT '0',
	PRIMARY KEY (`id`)
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB 
;


ALTER TABLE `t_permohonan`
	ADD COLUMN `per_kewangan_waran_lampiran` VARCHAR(255) NULL DEFAULT NULL AFTER `per_kewangan_nowaran`;

	//update data sedia ada untuk permohonan sydah ada baucar_ok
UPDATE t_permohonan
SET per_status_projek = 'SS'
WHERE per_status_kewangan IN('BAUCAR_OK')