hrms_masters_alter.sql 254 Bytes
ALTER TABLE `hrms_masters` ADD `status` ENUM('active','inactive') NOT NULL DEFAULT 'active' AFTER `mid`;
ALTER TABLE `hrms_masters` ADD `campaignstartdate` DATETIME NOT NULL AFTER `mid`, ADD `campaignenddate` DATETIME NOT NULL AFTER `campaignstartdate`;