ALTER TABLE `ks_attachment`
	ADD COLUMN `att_type` SMALLINT NOT NULL DEFAULT 0 AFTER `att_filemodificationtime`;
--ref 
INSERT INTO `t_ref_statuspermohonan` (`sta_code`, `sta_desc`, `sta_enabled`) VALUES ('PDTREVIEW', 'Semakan PDT', '1');

--t_permohonan
ALTER TABLE `t_permohonan`
	ADD COLUMN `per_status_pdt_syor` SMALLINT NULL DEFAULT '0' AFTER `per_status_tukartajuk`,
	ADD COLUMN `per_catatan_syor` VARCHAR(255) NULL DEFAULT NULL AFTER `per_status_pdt_syor`;
ALTER TABLE `t_permohonan`
	ADD INDEX `per_status_pdt_syor` (`per_status_pdt_syor`);
    
DROP TABLE IF EXISTS `t_ref_status_pengesyoran_pdt`;
CREATE TABLE IF NOT EXISTS `t_ref_status_pengesyoran_pdt` (
  `rspp_code` int(11) DEFAULT NULL,
  `rspp_desc` varchar(50) DEFAULT NULL,
  UNIQUE KEY `rspp_code` (`rspp_code`)
) ENGINE=InnoDB ;
INSERT INTO `t_ref_status_pengesyoran_pdt` (`rspp_code`, `rspp_desc`) VALUES
(1, 'Syor ke UPEN'),
(2, 'Tidak Disyorkan');

ALTER TABLE `t_permohonan`
	ADD COLUMN `per_file_permohonan` VARCHAR(255) NULL DEFAULT NULL AFTER `per_bajet_mb`,
	ADD COLUMN `per_file_invois` VARCHAR(255) NULL DEFAULT NULL AFTER `per_file_permohonan`,
	ADD COLUMN `per_file_kelulusan` VARCHAR(255) NULL DEFAULT NULL AFTER `per_file_invois`,
	ADD COLUMN `per_file_lain` VARCHAR(255) NULL DEFAULT NULL AFTER `per_file_kelulusan`,
	ADD COLUMN `per_file_keterangan` TEXT NULL DEFAULT NULL AFTER `per_file_lain`;

INSERT INTO  `ks_field` (`sf_tablename`, `sf_fieldname`, `sf_label`, `sf_type`) VALUES ('t_permohonan', 'per_file_permohonan', 'Permohonan', 'file');
INSERT INTO  `ks_field` (`sf_tablename`, `sf_fieldname`, `sf_label`, `sf_type`) VALUES ('t_permohonan', 'per_file_invois', 'Invois', 'file');
INSERT INTO  `ks_field` (`sf_tablename`, `sf_fieldname`, `sf_label`, `sf_type`) VALUES ('t_permohonan', 'per_file_kelulusan', 'Kelulusan', 'file');
INSERT INTO  `ks_field` (`sf_tablename`, `sf_fieldname`, `sf_label`, `sf_type`) VALUES ('t_permohonan', 'per_file_lain', 'Lain-lain', 'file');

INSERT INTO `ks_field_file` (`fp_tablename`, `fp_fieldname`, `fp_label`, `fp_labelalt`, `fp_columntype`, `fp_columncomment`, `fp_showactualfilename`, `fp_displaytext`, `fp_required_errormsg`, `fp_extension`, `fp_extensionmsg`, `fp_width`, `fp_browselabel`, `fp_minx`, `fp_maxx`, `fp_miny`, `fp_maxy`, `fp_dimensionmsg`, `fp_maxsize`, `fp_sizemsg`, `fp_prefix`, `fp_suffix`, `fp_help`, `fp_js_whenadd`, `fp_js_whenmodify`) 
	VALUES ('t_permohonan', 'per_file_permohonan', 'Permohonan', 'permohonan', 'varchar(255)', 'Field per_file_permohonan', '1', '1', '* A file must be uploaded.', '.jpg .png .gif', 'You must upload', '30', ' ', '200', '400', '300', '500', 'Image must be', '1024', 'File must be at least 10kb', ' ', ' ', ' ', ' ', ' ');
INSERT INTO `ks_field_file` (`fp_tablename`, `fp_fieldname`, `fp_label`, `fp_labelalt`, `fp_columntype`, `fp_columncomment`, `fp_showactualfilename`, `fp_displaytext`, `fp_required_errormsg`, `fp_extension`, `fp_extensionmsg`, `fp_width`, `fp_browselabel`, `fp_minx`, `fp_maxx`, `fp_miny`, `fp_maxy`, `fp_dimensionmsg`, `fp_maxsize`, `fp_sizemsg`, `fp_prefix`, `fp_suffix`, `fp_help`, `fp_js_whenadd`, `fp_js_whenmodify`) 
	VALUES ('t_permohonan', 'per_file_invois', 'Permohonan', 'permohonan', 'varchar(255)', 'Field per_file_invois', '1', '1', '* A file must be uploaded.', '.jpg .png .gif', 'You must upload', '30', ' ', '200', '400', '300', '500', 'Image must be', '1024', 'File must be at least 10kb', ' ', ' ', ' ', ' ', ' ');
INSERT INTO `ks_field_file` (`fp_tablename`, `fp_fieldname`, `fp_label`, `fp_labelalt`, `fp_columntype`, `fp_columncomment`, `fp_showactualfilename`, `fp_displaytext`, `fp_required_errormsg`, `fp_extension`, `fp_extensionmsg`, `fp_width`, `fp_browselabel`, `fp_minx`, `fp_maxx`, `fp_miny`, `fp_maxy`, `fp_dimensionmsg`, `fp_maxsize`, `fp_sizemsg`, `fp_prefix`, `fp_suffix`, `fp_help`, `fp_js_whenadd`, `fp_js_whenmodify`) 
	VALUES ('t_permohonan', 'per_file_kelulusan', 'Permohonan', 'permohonan', 'varchar(255)', 'Field per_file_kelulusan', '1', '1', '* A file must be uploaded.', '.jpg .png .gif', 'You must upload', '30', ' ', '200', '400', '300', '500', 'Image must be', '1024', 'File must be at least 10kb', ' ', ' ', ' ', ' ', ' ');
INSERT INTO `ks_field_file` (`fp_tablename`, `fp_fieldname`, `fp_label`, `fp_labelalt`, `fp_columntype`, `fp_columncomment`, `fp_showactualfilename`, `fp_displaytext`, `fp_required_errormsg`, `fp_extension`, `fp_extensionmsg`, `fp_width`, `fp_browselabel`, `fp_minx`, `fp_maxx`, `fp_miny`, `fp_maxy`, `fp_dimensionmsg`, `fp_maxsize`, `fp_sizemsg`, `fp_prefix`, `fp_suffix`, `fp_help`, `fp_js_whenadd`, `fp_js_whenmodify`) 
VALUES ('t_permohonan', 'per_file_lain', 'Permohonan', 'permohonan', 'varchar(255)', 'Field per_file_lain', '1', '1', '* A file must be uploaded.', '.jpg .png .gif', 'You must upload', '30', ' ', '200', '400', '300', '500', 'Image must be', '1024', 'File must be at least 10kb', ' ', ' ', ' ', ' ', ' ');


//enhancement 2nd changes
//check this one
ALTER TABLE `t_permohonan`
	ADD COLUMN `per_semakan_pdt` INT(11) NULL DEFAULT '0' COMMENT 'ADUN dan EXCO apply permohonan,' AFTER `per_bajet_mb`;
INSERT INTO  `t_ref_statuspermohonan` (`sta_code`, `sta_desc`, `sta_enabled`) VALUES ('QUERY', 'Kuiri Kepada Pemohon', '1');


ALTER TABLE `t_permohonan`
	ADD COLUMN `per_filesumb_kelulusan` VARCHAR(255) NULL DEFAULT NULL COMMENT 'Kelulusan Khas Ahli MMK/ADUN Cadangan Peruntukan Sumbangan Projek Pembangunan' AFTER `per_file_keterangan`,
	ADD COLUMN `per_filesumb_proposal` VARCHAR(255) NULL DEFAULT NULL COMMENT 'Proposal/ Kertas Kerja - Program/ Projek/ Bekalan/ Anggaran Belanjawan' AFTER `per_filesumb_kelulusan`,
	ADD COLUMN `per_filesumb_cert` VARCHAR(255) NULL DEFAULT NULL COMMENT 'Sijil Perakuan Pertubuhan/ Persatuan/ Kelab yang didaftarkan di bawah mana-mana undang-undang bertulis ' AFTER `per_filesumb_proposal`,
	ADD COLUMN `per_filesumb_pengesahan` VARCHAR(255) NULL DEFAULT NULL COMMENT 'Surat Pengesahan Akaun Bank Pertubuhan/ Persatuan/ Kelab yang didaftarkan di bawah mana-mana undang-undang bertulis' AFTER `per_filesumb_cert`,
	ADD COLUMN `per_filesumb_dokumen` VARCHAR(255) NULL DEFAULT NULL COMMENT 'Dokumen kelulusan khas Pejabat Kewangan Negeri/ YAB Menteri Besar' AFTER `per_filesumb_pengesahan`;

INSERT INTO  `ks_field` (`sf_tablename`, `sf_fieldname`, `sf_label`, `sf_type`) VALUES ('t_permohonan', 'per_filesumb_kelulusan', 'Kelulusan Khas Ahli MMK/ADUN Cadangan Peruntukan Sumbangan Projek Pembangunan', 'file');
INSERT INTO  `ks_field` (`sf_tablename`, `sf_fieldname`, `sf_label`, `sf_type`) VALUES ('t_permohonan', 'per_filesumb_proposal', 'Proposal/ Kertas Kerja - Program/ Projek/ Bekalan/ Anggaran Belanjawan', 'file');
INSERT INTO  `ks_field` (`sf_tablename`, `sf_fieldname`, `sf_label`, `sf_type`) VALUES ('t_permohonan', 'per_filesumb_cert', 'Sijil Perakuan Pertubuhan/ Persatuan/ Kelab yang didaftarkan di bawah mana-mana undang-undang bertulis', 'file');
INSERT INTO  `ks_field` (`sf_tablename`, `sf_fieldname`, `sf_label`, `sf_type`) VALUES ('t_permohonan', 'per_filesumb_pengesahan', 'Surat Pengesahan Akaun Bank Pertubuhan/ Persatuan/ Kelab yang didaftarkan di bawah mana-mana undang-undang bertulis', 'file');
INSERT INTO  `ks_field` (`sf_tablename`, `sf_fieldname`, `sf_label`, `sf_type`) VALUES ('t_permohonan', 'per_filesumb_dokumen', 'Dokumen kelulusan khas Pejabat Kewangan Negeri/ YAB Menteri Besar (diwujudkan bagi lain-lain dokumen yang tidak mematuhi perkara 3 dan 4)', 'file');

INSERT INTO `ks_field_file` (`fp_tablename`, `fp_fieldname`, `fp_label`, `fp_labelalt`, `fp_columntype`, `fp_columncomment`, `fp_showactualfilename`, `fp_displaytext`, `fp_required_errormsg`, `fp_extension`, `fp_extensionmsg`, `fp_width`, `fp_browselabel`, `fp_minx`, `fp_maxx`, `fp_miny`, `fp_maxy`, `fp_dimensionmsg`, `fp_maxsize`, `fp_sizemsg`, `fp_prefix`, `fp_suffix`, `fp_help`, `fp_js_whenadd`, `fp_js_whenmodify`) 
	VALUES ('t_permohonan', 'per_filesumb_kelulusan', 'Kelulusan Khas Ahli MMK/ADUN Cadangan Peruntukan Sumbangan Projek Pembangunan', 'permohonan', 'varchar(255)', 'Field per_filesumb_kelulusan', '1', '1', '* A file must be uploaded.', '.jpg .png .gif .doc .docx .pdf', 'You must upload', '30', ' ', '200', '400', '300', '500', 'Image must be', '1024', 'File must be at least 10kb', ' ', ' ', ' ', ' ', ' ');
INSERT INTO `ks_field_file` (`fp_tablename`, `fp_fieldname`, `fp_label`, `fp_labelalt`, `fp_columntype`, `fp_columncomment`, `fp_showactualfilename`, `fp_displaytext`, `fp_required_errormsg`, `fp_extension`, `fp_extensionmsg`, `fp_width`, `fp_browselabel`, `fp_minx`, `fp_maxx`, `fp_miny`, `fp_maxy`, `fp_dimensionmsg`, `fp_maxsize`, `fp_sizemsg`, `fp_prefix`, `fp_suffix`, `fp_help`, `fp_js_whenadd`, `fp_js_whenmodify`) 
	VALUES ('t_permohonan', 'per_filesumb_proposal', 'Proposal/ Kertas Kerja - Program/ Projek/ Bekalan/ Anggaran Belanjawan', 'permohonan', 'varchar(255)', 'Field per_filesumb_proposal', '1', '1', '* A file must be uploaded.', '.jpg .png .gif .doc .docx .pdf', 'You must upload', '30', ' ', '200', '400', '300', '500', 'Image must be', '1024', 'File must be at least 10kb', ' ', ' ', ' ', ' ', ' ');
INSERT INTO `ks_field_file` (`fp_tablename`, `fp_fieldname`, `fp_label`, `fp_labelalt`, `fp_columntype`, `fp_columncomment`, `fp_showactualfilename`, `fp_displaytext`, `fp_required_errormsg`, `fp_extension`, `fp_extensionmsg`, `fp_width`, `fp_browselabel`, `fp_minx`, `fp_maxx`, `fp_miny`, `fp_maxy`, `fp_dimensionmsg`, `fp_maxsize`, `fp_sizemsg`, `fp_prefix`, `fp_suffix`, `fp_help`, `fp_js_whenadd`, `fp_js_whenmodify`) 
	VALUES ('t_permohonan', 'per_filesumb_cert', 'Sijil Perakuan Pertubuhan/ Persatuan/ Kelab yang didaftarkan', 'permohonan', 'varchar(255)', 'Field per_filesumb_cert', '1', '1', '* A file must be uploaded.', '.jpg .png .gif .doc .docx .pdf', 'You must upload', '30', ' ', '200', '400', '300', '500', 'Image must be', '1024', 'File must be at least 10kb', ' ', ' ', ' ', ' ', ' ');
INSERT INTO `ks_field_file` (`fp_tablename`, `fp_fieldname`, `fp_label`, `fp_labelalt`, `fp_columntype`, `fp_columncomment`, `fp_showactualfilename`, `fp_displaytext`, `fp_required_errormsg`, `fp_extension`, `fp_extensionmsg`, `fp_width`, `fp_browselabel`, `fp_minx`, `fp_maxx`, `fp_miny`, `fp_maxy`, `fp_dimensionmsg`, `fp_maxsize`, `fp_sizemsg`, `fp_prefix`, `fp_suffix`, `fp_help`, `fp_js_whenadd`, `fp_js_whenmodify`) 
	VALUES ('t_permohonan', 'per_filesumb_pengesahan', 'Surat Pengesahan Akaun Bank Pertubuhan/ Persatuan/ Kelab yang didaftarkan di bawah mana-mana undang-undang bertulis', 'permohonan', 'varchar(255)', 'Field per_filesumb_pengesahan', '1', '1', '* A file must be uploaded.', '.jpg .png .gif .doc .docx .pdf', 'You must upload', '30', ' ', '200', '400', '300', '500', 'Image must be', '1024', 'File must be at least 10kb', ' ', ' ', ' ', ' ', ' ');
INSERT INTO `ks_field_file` (`fp_tablename`, `fp_fieldname`, `fp_label`, `fp_labelalt`, `fp_columntype`, `fp_columncomment`, `fp_showactualfilename`, `fp_displaytext`, `fp_required_errormsg`, `fp_extension`, `fp_extensionmsg`, `fp_width`, `fp_browselabel`, `fp_minx`, `fp_maxx`, `fp_miny`, `fp_maxy`, `fp_dimensionmsg`, `fp_maxsize`, `fp_sizemsg`, `fp_prefix`, `fp_suffix`, `fp_help`, `fp_js_whenadd`, `fp_js_whenmodify`) 
	VALUES ('t_permohonan', 'per_filesumb_dokumen', 'Dokumen kelulusan khas Pejabat Kewangan Negeri/ YAB Menteri Besar (diwujudkan bagi lain-lain dokumen yang tidak mematuhi perkara 3 dan 4)', 'permohonan', 'varchar(255)', 'Field per_filesumb_dokumen', '1', '1', '* A file must be uploaded.', '.jpg .png .gif .doc .docx .pdf', 'You must upload', '30', ' ', '200', '400', '300', '500', 'Image must be', '1024', 'File must be at least 10kb', ' ', ' ', ' ', ' ', ' ');


ALTER TABLE `ks_news`
	ADD COLUMN `ns_lampiran` VARCHAR(255) NULL DEFAULT NULL AFTER `ns_status`;