CREATE TABLE IF NOT EXISTS `notification_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) NOT NULL,
  `date_from` datetime DEFAULT NULL,
  `date_to` datetime DEFAULT NULL,
  `data` mediumtext DEFAULT NULL,
  `handler_class_name` varchar(255) DEFAULT NULL,
  `settings` TEXT,
  PRIMARY KEY (`id`),
  KEY `contract_id` (`contract_id`),
  KEY `date_from` (`date_from`)
);

CREATE TABLE IF NOT EXISTS `notification_contract` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contract_id` int(10) unsigned NOT NULL DEFAULT 0,
  `subject` varchar(255) NOT NULL,
  `notification_id` int(10) NOT NULL,
  `sent_time` datetime NOT NULL,
  `sent` tinyint(1) NOT NULL DEFAULT 0,
  FOREIGN KEY (`contract_id`) REFERENCES `contract` (`id`) ON DELETE CASCADE,
  PRIMARY KEY (`id`)
);