/**
 * SocialEngine
 *
 * @category   Application_Extensions
 * @package    Warning
 * @copyright  Copyright 2006-2024 Ahead WebSoft Technologies
 * @license    https://socialengine.com/eula
 * @version    $Id: my.sql 2024-01-24 00:00:00Z 
 * @author     SocialEngine
 */

/**
 * @category   Application_Extensions
 * @package    Warning
 * @copyright  Copyright 2006-2024 Ahead WebSoft Technologies
 * @license    https://socialengine.com/eula
 */

INSERT IGNORE INTO `engine4_core_menuitems` (`name`, `module`, `label`, `plugin`, `params`, `menu`, `submenu`, `order`) VALUES
('core_admin_main_plugins_warning', 'warning', 'Website Warning Pages', '', '{"route":"admin_default","module":"warning","controller":"private", "action":"index"}', 'core_admin_main_plugins', '', 999),
("warning_admin_main_private", "warning", "Private Page", "", '{"route":"admin_default","module":"warning","controller":"private", "action":"index"}', "warning_admin_main", "", 1),
("warning_admin_main_pagenotfound", "warning", "Page Not Found", "", '{"route":"admin_default","module":"warning","controller":"pagenotfound", "action":"index"}', "warning_admin_main", "", 2),
("warning_admin_main_comingsoon", "warning", "Coming Soon Page", "", '{"route":"admin_default","module":"warning","controller":"comingsoon", "action":"index"}', "warning_admin_main", "", 3);

DROP TABLE IF EXISTS `engine4_warning_visitors`;
CREATE TABLE IF NOT EXISTS `engine4_warning_visitors` (
	`visitor_id` int(11) NOT NULL AUTO_INCREMENT,
	`name` varchar(64) NOT NULL,
	`email` varchar(64) NOT NULL,
	`body` text NOT NULL,
	PRIMARY KEY (`visitor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci ;
