CREATE TABLE IF NOT EXISTS `#__djc2_stocknotify` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `item_type` varchar(50) NOT NULL,
  `email` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8mb4;

INSERT INTO `#__djc2_message_templates` (`id`, `type`, `name`, `state`, `subject`, `body`, `attachments`, `created`, `created_by`, `checked_out`, `checked_out_time`, `params`) VALUES
(10, 'stock_available', 'Stock Available', 1, 'Stock Available - [[product_name]]', '<p>Dear customer,</p>\r\n<p>We are happy to announce that a product ([[product_name]]) in which you were interested is in stock and available for purchase.</p>\r\n<p><a href=\"[[product_link]]\">Click here</a> to open product page.</p>', '[]', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', NULL);
