ALTER TABLE `t_permohonan` ADD INDEX ( `per_tajuk_permohonan` ) ;

ALTER TABLE `t_peruntukan` ADD INDEX ( `putk_tahun_semasa` ) ;

ALTER TABLE `t_projek_status` CHANGE `prst_userid_modified` `prst_userid_modified` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
CHANGE `prst_date_modified` `prst_date_modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';

ALTER TABLE `t_projek_status` CHANGE `prst_belanja_terkini` `prst_belanja_terkini` FLOAT( 10, 2 ) NOT NULL DEFAULT '0.00',
CHANGE `prst_belanja_peratus` `prst_belanja_peratus` FLOAT( 5, 2 ) NOT NULL DEFAULT '0.00',
CHANGE `prst_catatan` `prst_catatan` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
CHANGE `prst_userid_created` `prst_userid_created` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
CHANGE `prst_date_created` `prst_date_created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';

ALTER TABLE `t_permohonan`
	ADD COLUMN `per_tukartajuk_parent` INT(11) NOT NULL COMMENT 'Lookup per_id at t_peemohonan table' AFTER `per_catatan_mbsuk`;

ALTER TABLE `t_peruntukan_pemohon` CHANGE `pp_remarks` `pp_remarks` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ;

ALTER TABLE `t_permohonan`
	CHANGE COLUMN `per_tukartajuk_data` `per_tukartajuk_data` LONGTEXT NULL AFTER `per_fulltext`;
	
ALTER TABLE `t_permohonan`
	CHANGE COLUMN `per_tukartajuk_parent` `per_tukartajuk_parent` INT(11) NOT NULL DEFAULT '0' COMMENT 'Lookup per_id at t_peemohonan table' AFTER `per_catatan_mbsuk`;
	
ALTER TABLE `t_peruntukan_pemohon` ADD INDEX ( `pp_kepcode` ) ;

INSERT INTO `t_ref_statustukartajuk` (`tuk_code`, `tuk_desc`) VALUES ('NEW_MB', 'Sedang Diproses oleh MB');

ALTER TABLE `t_ps_map` CHANGE `map_month` `map_month` SMALLINT( 2 ) NOT NULL DEFAULT '0',
CHANGE `map_year` `map_year` YEAR( 4 ) NOT NULL DEFAULT '0',
CHANGE `map_submitted` `map_submitted` SMALLINT( 1 ) NOT NULL DEFAULT '0';

ALTER TABLE `t_permohonan` ADD INDEX ( `per_jenis_permohonan` ) ;

ALTER TABLE `t_permohonan`
	ADD COLUMN `per_justifikasi` VARCHAR(255) NULL DEFAULT NULL COMMENT 'Catatan Setiap Kali Pecah Tajuk' AFTER `per_catatan_tukartajuk`;
ALTER TABLE `ks_field_text`
	ADD COLUMN `fp_placeholder` VARCHAR(255) NULL DEFAULT NULL AFTER `fp_readonly_whenadd`;	
	
ALTER TABLE `ks_field_lookup`
	ADD COLUMN `fp_dbport` VARCHAR(10) NULL DEFAULT NULL AFTER `fp_dbname`;
	
CREATE TABLE IF NOT EXISTS `t_user_draft` (
  `usd_id` int(11) NOT NULL auto_increment COMMENT 'Unique ID',
  `usd_usr_id` varchar(32) default NULL COMMENT 'reference t_user, jika lulus , usr_id akan disimpan',
  `usd_name` varchar(255) default NULL COMMENT 'User fullname',
  `usd_status` varchar(10) default NULL COMMENT 't_ref_pemohonan_status',
  `usd_changepwd` int(1) default NULL COMMENT '1=belum ubah katalaluan , 0 = sudah ubah katalaluan',
  `usd_email` varchar(32) default NULL COMMENT 'User email address',
  `usd_dun` varchar(10) default NULL COMMENT 'User dun from table t_ref_dun',
  `usd_pemid` int(11) NOT NULL default '0' COMMENT 'Id pemohon creator',
  `usd_jawatan` varchar(50) default NULL,
  `usd_gred` varchar(10) default NULL,
  `usd_no_kadpengenalan` varchar(30) default NULL,
  `usd_telefon_pejabat` varchar(30) default NULL,
  `usd_telefon_bimbit` varchar(30) default NULL,
  `usd_faks` varchar(30) default NULL,
  `usd_phone_office` varchar(20) default NULL COMMENT 'Office phone',
  `usd_phone_mobile` varchar(20) default NULL COMMENT 'Mobile phone',
  `usd_date_created` datetime NOT NULL default '0000-00-00 00:00:00' COMMENT 'Date & time record created.',
  `usd_date_modified` datetime NOT NULL default '0000-00-00 00:00:00' COMMENT 'Date & time record last modified.',
  `usd_userid_created` varchar(32) default NULL COMMENT 'UserID who creates the record, from t_user.usr_userid',
  `usd_userid_modified` varchar(32) default NULL COMMENT 'UserID who last modified the record, from t_user.usr_userid',
  PRIMARY KEY  (`usd_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='System users';
	
ALTER TABLE `ks_news`
	ADD COLUMN `ns_read` INT(1) NULL DEFAULT '0' COMMENT '1=belum dibaca, 0 = sudah dibaca' AFTER `ns_status`;
	
CREATE TABLE IF NOT EXISTS `t_news_read` (
	`nr_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`nr_ns_id` INT(11) NOT NULL DEFAULT '0' COMMENT 'reference KS_NEWS',
	`nr_usr_id` VARCHAR(50) NULL DEFAULT NULL COMMENT 'references t_user',
	`nr_read` INT(1) NOT NULL DEFAULT '0' COMMENT '1= belum dibaca, 0 =sudah dibaca',
	`nr_read_date` DATETIME NULL DEFAULT NULL COMMENT 'Tarik bila dibaca oleh user',
	`nr_userid_createdby` VARCHAR(50) NULL DEFAULT NULL,
	`nr_date_createdby` DATETIME NOT NULL,
	PRIMARY KEY (`nr_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;