CREATE TABLE `categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_name` varchar(20) NOT NULL,
  `description` text,
  `created_datetime` datetime NOT NULL,
  `updated_datetime` datetime NOT NULL,
  `created_by` int(11) NOT NULL,
  `updated_by` int(11) NOT NULL,
  `is_default` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

INSERT INTO `categories` (`category_name`, `description`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`, `is_default`) VALUES ('Archive', 'Archive', '2017-12-27 21:17:39', '2017-12-27 21:17:39', '1', '1', '1');
INSERT INTO `categories` (`category_name`, `description`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`, `is_default`) VALUES ('General', 'General', '2017-12-27 21:17:39', '2017-12-27 21:17:39', '1', '1', '1');
INSERT INTO `categories` (`category_name`, `description`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`, `is_default`) VALUES ('Maintenance', 'Maintenance', '2017-12-27 21:17:39', '2017-12-27 21:17:39', '1', '1', '1');
INSERT INTO `categories` (`category_name`, `description`, `created_datetime`, `updated_datetime`, `created_by`, `updated_by`, `is_default`) VALUES ('Security ', 'Security ', '2017-12-27 21:17:39', '2017-12-27 21:17:39', '1', '1', '1');


ALTER TABLE `general_message` ADD COLUMN `category` TEXT NULL DEFAULT NULL;

ALTER TABLE `announcement` ADD COLUMN `published_start_date` DATE NULL DEFAULT NULL;

ALTER TABLE `announcement` ADD COLUMN `published_end_date` DATE NULL DEFAULT NULL;

ALTER TABLE `announcement` ADD COLUMN `published_start_time` VARCHAR(11) NULL DEFAULT NULL;

ALTER TABLE `announcement` ADD COLUMN `published_end_time` VARCHAR(11) NULL DEFAULT NULL;

UPDATE `announcement` SET `published_start_date` ='2017-12-01',`published_start_time`='12:00 PM',`published_end_date` ='2030-12-31',`published_end_time`='11:59 PM'
where `published_start_date` is null