USE `registration`;
CREATE TABLE `fs_event` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `fs_id` varchar(50) DEFAULT NULL,
  `type` varchar(100) NOT NULL DEFAULT '',
  `is_test` tinyint(1) DEFAULT NULL,
  `created_date` timestamp NULL DEFAULT NULL COMMENT 'unix timestamp',
  PRIMARY KEY (`id`),
  UNIQUE KEY `fs_id_key` (`fs_id`),
  KEY `EVENT_TYPE_KEY` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8;

--  Changes for Updating the Processed Date (28 November 2021)

ALTER TABLE `fs_event`
  ADD COLUMN `processed_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP;